APPS.HR_DM_LIBRARY dependencies on ALL_TAB_COLUMNS

Line 319: from all_tab_columns

315:
316: --cursor to get the data type of column
317: cursor csr_get_data_type is
318: select lower(data_type) data_type
319: from all_tab_columns
320: where table_name = upper(p_table_name)
321: and column_name = upper(p_column_name)
322: and owner in
323: (l_apps_name,

Line 651: from all_tab_columns

647: -- cursor to get the column name and data type
648: cursor csr_get_columns is
649: select distinct lower(column_name) col_name,
650: lower(data_type) data_type
651: from all_tab_columns
652: where table_name = upper(p_table_info.table_name)
653: and column_name <> 'BATCH_ID'
654: and data_type <> 'SDO_GEOMETRY'
655: and owner in

Line 799: from all_tab_columns atc,

795: cursor csr_get_pk_columns is
796: select distinct lower(atc.column_name) col_name,
797: lower(atc.data_type) data_type,
798: acc.position
799: from all_tab_columns atc,
800: all_cons_columns acc,
801: all_constraints ac
802: where ac.table_name = upper(p_table_info.table_name)
803: and ac.constraint_type = 'P'

Line 969: from all_tab_columns atc,

965: cursor csr_get_pk_columns is
966: select distinct lower(atc.column_name) col_name,
967: lower(atc.data_type) data_type,
968: acc.position
969: from all_tab_columns atc,
970: all_cons_columns acc,
971: all_constraints ac
972: where ac.table_name = upper(p_table_info.table_name)
973: and ac.constraint_type = 'P'

Line 1451: from all_tab_columns

1447:
1448: cursor csr_data_type is
1449: select data_type,
1450: nullable
1451: from all_tab_columns
1452: where table_name = upper(p_table_name)
1453: and column_name = upper(p_column_name)
1454: and owner in
1455: (l_apps_name,

Line 3023: from all_tab_columns

3019: where ORACLE_ID = 900;
3020:
3021: cursor csr_columns is
3022: select column_name
3023: from all_tab_columns
3024: where table_name = upper(p_table_info.upload_table_name)
3025: and column_name not in ('BUSINESS_GROUP_ID','BATCH_ID')
3026: and data_type <> 'SDO_GEOMETRY'
3027: and not (table_name = 'FF_FORMULAS_F' and column_name = 'FORMULA_TEXT')

Line 3039: from all_tab_columns

3035: order by column_id;
3036:
3037: cursor csr_sp_columns is
3038: select column_name
3039: from all_tab_columns
3040: where table_name = upper(p_table_info.upload_table_name)
3041: and data_type <> 'SDO_GEOMETRY'
3042: and owner in
3043: (l_apps_name,

Line 3228: all_tab_columns tc

3224: cursor csr_table is
3225: select distinct dm.table_name,
3226: dm.table_id
3227: from hr_dm_tables dm,
3228: all_tab_columns tc
3229: where dm.table_name not like 'FND%'
3230: and dm.table_name like 'HR_DMV%'
3231: and dm.table_name = tc.table_name
3232: and tc.column_name = 'CREATED_BY'

Line 3377: all_tab_columns tc1,

3373: cursor csr_table is
3374: select distinct dm.table_name,
3375: dm.table_id
3376: from hr_dm_tables dm,
3377: all_tab_columns tc1,
3378: all_tab_columns tc2
3379: where dm.table_name not like 'FND%'
3380: and dm.table_name like 'HR_DMV%'
3381: and dm.table_name = tc1.table_name

Line 3378: all_tab_columns tc2

3374: select distinct dm.table_name,
3375: dm.table_id
3376: from hr_dm_tables dm,
3377: all_tab_columns tc1,
3378: all_tab_columns tc2
3379: where dm.table_name not like 'FND%'
3380: and dm.table_name like 'HR_DMV%'
3381: and dm.table_name = tc1.table_name
3382: and dm.table_name = tc2.table_name

Line 3541: from all_tab_columns

3537: and p.migration_id = p_migration_id;
3538:
3539: cursor csr_columns is
3540: select column_name
3541: from all_tab_columns
3542: where table_name = l_table_name
3543: and column_name not in ('BUSINESS_GROUP_ID','BATCH_ID')
3544: and data_type <> 'SDO_GEOMETRY'
3545: and not (table_name = 'FF_FORMULAS_F' and column_name = 'FORMULA_TEXT')

Line 3557: from all_tab_columns

3553: order by column_id;
3554:
3555: cursor csr_sp_columns is
3556: select column_name
3557: from all_tab_columns
3558: where table_name = l_table_name
3559: and data_type <> 'SDO_GEOMETRY'
3560: and owner in
3561: (l_apps_name,

Line 3571: from all_tab_columns

3567: order by column_id;
3568:
3569: cursor csr_sp2_columns is
3570: select column_name
3571: from all_tab_columns
3572: where table_name = l_table_name
3573: and column_name <> 'BATCH_ID'
3574: and owner in
3575: (l_apps_name,