APPS.ETRM_PNAV dependencies on DBA_TAB_COLUMNS

Line 770: , c_owner dba_tab_columns.owner%type) is

766: end ls_table;
767:
768:
769: procedure ls_table(c_name dba_tables.table_name%type
770: , c_owner dba_tab_columns.owner%type) is
771:
772: CURSOR cur_table_dets(c_name in dba_tables.table_name%type
773: , c_owner in dba_objects.owner%type)
774: -- List table details

Line 1009: procedure ls_columns(c_name dba_tab_columns.table_name%type

1005: 'An unexpected error has occured in the script. This is an internal error - not normally issued'
1006: );
1007: END ls_table;
1008:
1009: procedure ls_columns(c_name dba_tab_columns.table_name%type
1010: , c_owner dba_tab_columns.owner%type
1011: , c_query_text varchar2 := 'Y') is
1012:
1013: cursor cur_columns(c_name dba_tab_columns.table_name%type

Line 1010: , c_owner dba_tab_columns.owner%type

1006: );
1007: END ls_table;
1008:
1009: procedure ls_columns(c_name dba_tab_columns.table_name%type
1010: , c_owner dba_tab_columns.owner%type
1011: , c_query_text varchar2 := 'Y') is
1012:
1013: cursor cur_columns(c_name dba_tab_columns.table_name%type
1014: , c_owner dba_tab_columns.owner%type)

Line 1013: cursor cur_columns(c_name dba_tab_columns.table_name%type

1009: procedure ls_columns(c_name dba_tab_columns.table_name%type
1010: , c_owner dba_tab_columns.owner%type
1011: , c_query_text varchar2 := 'Y') is
1012:
1013: cursor cur_columns(c_name dba_tab_columns.table_name%type
1014: , c_owner dba_tab_columns.owner%type)
1015: is select col.column_name
1016: , col.data_type
1017: , col.data_length

Line 1014: , c_owner dba_tab_columns.owner%type)

1010: , c_owner dba_tab_columns.owner%type
1011: , c_query_text varchar2 := 'Y') is
1012:
1013: cursor cur_columns(c_name dba_tab_columns.table_name%type
1014: , c_owner dba_tab_columns.owner%type)
1015: is select col.column_name
1016: , col.data_type
1017: , col.data_length
1018: , nvl(to_char(col.data_precision), '
') data_precision

Line 1020: from dba_tab_columns col

1016: , col.data_type
1017: , col.data_length
1018: , nvl(to_char(col.data_precision), '
') data_precision
1019: , nvl(decode(col.nullable, 'N', 'Yes'), '
') nullable
1020: from dba_tab_columns col
1021: where col.table_name = c_name
1022: and col.owner = c_owner
1023: order by col.column_id;
1024:

Line 1026: cursor cur_col_comments(c_tname dba_tab_columns.table_name%type

1022: and col.owner = c_owner
1023: order by col.column_id;
1024:
1025:
1026: cursor cur_col_comments(c_tname dba_tab_columns.table_name%type
1027: , c_cname dba_tab_columns.column_name%type
1028: , c_owner dba_tab_columns.owner%type)
1029: is select comments
1030: from dba_col_comments

Line 1027: , c_cname dba_tab_columns.column_name%type

1023: order by col.column_id;
1024:
1025:
1026: cursor cur_col_comments(c_tname dba_tab_columns.table_name%type
1027: , c_cname dba_tab_columns.column_name%type
1028: , c_owner dba_tab_columns.owner%type)
1029: is select comments
1030: from dba_col_comments
1031: where owner = c_owner

Line 1028: , c_owner dba_tab_columns.owner%type)

1024:
1025:
1026: cursor cur_col_comments(c_tname dba_tab_columns.table_name%type
1027: , c_cname dba_tab_columns.column_name%type
1028: , c_owner dba_tab_columns.owner%type)
1029: is select comments
1030: from dba_col_comments
1031: where owner = c_owner
1032: and table_name = c_tname