create or replace package cdwp_tbl is g_tbl_name varchar2(40); g_tbl_id number(38); procedure short_list_table_definitions ( p_session_id in number ); procedure list_table_definitions ( p_session_id in number , p_irid in number default null , p_ivid in number default null ); procedure print_oky -- Purpose: this procedure prints the columns in the key components -- for the indicated constraint -- it prints them all in one row, -- assuming the row has been opened and will be closed by the calling routine -- Usage: in table and view reports ( p_oco_reference in number , p_pac_ivid in number default null ); procedure summary_modtab_definitions; procedure summary_column_definitions; procedure summary_trg_definitions; procedure summary_oco_definitions; procedure incoming_fco; procedure list_pco_definitions; procedure list_uco_definitions; procedure list_fco_definitions; procedure list_cco_definitions; function column_in_primary_key ( p_column_id in number ) return boolean ; procedure list_column_definitions; -- can be used for both table columns and view columns procedure list_tabent; procedure list_vwtab; function has_app_logic ( p_el_id in number default null , p_el_ivid in number default null , p_al_type in varchar2 default '%' -- any type; other values: NRA, API and EVA ) return boolean ; function display_name_al_type ( p_al_type in varchar2 ) return varchar2 ; procedure list_app_logic ( p_el_id in number default null , p_el_ivid in number default null , p_al_type in varchar2 default '%' , p_el_type in varchar2 default 'TBL' -- 2.7 ) ; end cdwp_tbl; /