APPS.HR_DM_LIBRARY dependencies on HR_DM_TABLES

Line 84: l_generator_version hr_dm_tables.generator_version%type;

80: p_format_output in varchar2 default 'N'
81: )
82: is
83: l_package_version varchar2(1000);
84: l_generator_version hr_dm_tables.generator_version%type;
85:
86: -- ----------------------- indent -----------------------------------------
87: -- Description:
88: -- returns the 'n' blank spaces on a newline.used to indent the procedure

Line 377: -- p_table_id - Primary key of the hr_dm_tables.

373: -- ------------------------- get_table_info ------------------------
374: -- Description:
375: -- It returns the properties of the table for the given id.
376: -- Input Parameters :
377: -- p_table_id - Primary key of the hr_dm_tables.
378: -- Output Parameters
379: -- p_table_info - Various properties of the table is returned in
380: -- pl/sql table. The properties are
381: -- o table_id

Line 415: from hr_dm_tables tbl

411: ,derive_sql_delete_source
412: ,derive_sql_source_tables
413: ,upper(tbl.global_data) global_data
414: ,sequence_name
415: from hr_dm_tables tbl
416: where tbl.table_id = p_table_id;
417:
418: begin
419:

Line 545: from hr_dm_tables tbl,

541: lower(hir.parent_column_name) parent_column_name,
542: lower(hir.parent_id_column_name) parent_id_column_name,
543: lower(tbl.table_name) parent_table_name,
544: lower(tbl.table_alias) parent_table_alias
545: from hr_dm_tables tbl,
546: hr_dm_hierarchies hir
547: where hir.hierarchy_type = p_hierarchy_type
548: and tbl.table_id = hir.parent_table_id
549: and hir.table_id = (

Line 551: from hr_dm_tables

547: where hir.hierarchy_type = p_hierarchy_type
548: and tbl.table_id = hir.parent_table_id
549: and hir.table_id = (
550: select table_id
551: from hr_dm_tables
552: where table_name = (
553: select nvl(upload_table_name, table_name)
554: from hr_dm_tables
555: where table_id = p_table_info.table_id));

Line 554: from hr_dm_tables

550: select table_id
551: from hr_dm_tables
552: where table_name = (
553: select nvl(upload_table_name, table_name)
554: from hr_dm_tables
555: where table_id = p_table_info.table_id));
556:
557: l_index number := 1;
558: begin

Line 3053: from hr_dm_tables

3049: order by column_id;
3050:
3051: cursor csr_nonnull_id is
3052: select table_id
3053: from hr_dm_tables
3054: where table_name = upper(p_table_info.upload_table_name);
3055:
3056: cursor csr_get_table is
3057: select distinct parent_table_id

Line 3227: from hr_dm_tables dm,

3223:
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

Line 3262: from hr_dm_tables

3258: -- get parent table ids
3259:
3260: select table_id
3261: into l_created_table
3262: from hr_dm_tables
3263: where table_name = 'HR_DM_FND_USERS_V1';
3264:
3265: select table_id
3266: into l_updated_table

Line 3267: from hr_dm_tables

3263: where table_name = 'HR_DM_FND_USERS_V1';
3264:
3265: select table_id
3266: into l_updated_table
3267: from hr_dm_tables
3268: where table_name = 'HR_DM_FND_USERS_V2';
3269:
3270: -- do inserts, if no data already exists
3271:

Line 3376: from hr_dm_tables dm,

3372:
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%'

Line 3529: from hr_dm_tables dmt,

3525:
3526: cursor csr_view is
3527: select dmt.table_name,
3528: dmt.upload_table_name
3529: from hr_dm_tables dmt,
3530: hr_dm_phase_items pi,
3531: hr_dm_phases p
3532: where p.phase_name = 'G'
3533: and pi.phase_id = p.phase_id