APPS.HR_DM_GEN_TUPS dependencies on HR_DM_TABLES

Line 450: l_parent_table_name hr_dm_tables.table_name%type;

446: -- variables to store the information about p_fk_to_aol_columns_tbl elements.
447: -- this is to reduce the variable name and add clarity.
448: l_column_name hr_dm_hierarchies.column_name%type;
449: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
450: l_parent_table_name hr_dm_tables.table_name%type;
451: l_parent_table_alias hr_dm_tables.table_alias%type;
452: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
453: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
454:

Line 451: l_parent_table_alias hr_dm_tables.table_alias%type;

447: -- this is to reduce the variable name and add clarity.
448: l_column_name hr_dm_hierarchies.column_name%type;
449: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
450: l_parent_table_name hr_dm_tables.table_name%type;
451: l_parent_table_alias hr_dm_tables.table_alias%type;
452: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
453: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
454:
455:

Line 577: l_parent_table_name hr_dm_tables.table_name%type;

573: -- variables to store the information about p_fk_to_aol_columns_tbl elements.
574: -- this is to reduce the variable name and add clarity.
575: l_column_name hr_dm_hierarchies.column_name%type;
576: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
577: l_parent_table_name hr_dm_tables.table_name%type;
578: l_parent_table_alias hr_dm_tables.table_alias%type;
579: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
580: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
581:

Line 578: l_parent_table_alias hr_dm_tables.table_alias%type;

574: -- this is to reduce the variable name and add clarity.
575: l_column_name hr_dm_hierarchies.column_name%type;
576: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
577: l_parent_table_name hr_dm_tables.table_name%type;
578: l_parent_table_alias hr_dm_tables.table_alias%type;
579: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
580: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
581:
582:

Line 1712: -- Uses the derive_sql_source_tables info stored in HR_DM_TABLES to form the

1708: raise;
1709: end generate_upload;
1710: -- ----------------------- get_derive_from_clause -------------------------
1711: -- Description:
1712: -- Uses the derive_sql_source_tables info stored in HR_DM_TABLES to form the
1713: -- 'from clause'.
1714: -- The from clause stored in each derive field will be in the following format :
1715: -- table1 tbl,:table2 tbl2, :table3 tbl3
1716: -- where ':' is the next line indicator i.e : will be replaced with new line.

Line 1733: l_derive_sql hr_dm_tables.derive_sql_download_full%type;

1729: p_derive_from in varchar2,
1730: p_from_clause in out nocopy varchar2,
1731: p_lpad_spaces in number default 2
1732: ) is
1733: l_derive_sql hr_dm_tables.derive_sql_download_full%type;
1734: l_start_ptr number;
1735: l_end_ptr number;
1736: l_terminator varchar2(5) := ';';
1737: begin

Line 1783: -- Uses the derive_sql info stored in HR_DM_TABLES for each type of cursors.

1779: raise;
1780: end get_derive_from_clause;
1781: -- ----------------------- get_derive_where_clause -------------------------
1782: -- Description:
1783: -- Uses the derive_sql info stored in HR_DM_TABLES for each type of cursors.
1784: -- The where clause stored in each derive field will
1785: -- example derive where clause :
1786: -- where tbl.col1 = tbl2.col1 : and tbl.col2 = tbl1.col2 : and tbl.col3 = tbl3.col3
1787: -- Above derive where clause will be converted as

Line 1812: l_derive_sql hr_dm_tables.derive_sql_chk_row_exists%type;

1808: p_derive_sql in varchar2,
1809: p_where_clause in out nocopy varchar2,
1810: p_lpad_spaces in number default 2
1811: ) is
1812: l_derive_sql hr_dm_tables.derive_sql_chk_row_exists%type;
1813: l_start_ptr number;
1814: l_end_ptr number;
1815: l_terminator varchar2(5) := ';';
1816: begin

Line 2026: hr_dm_tables tbl,

2022: hir.hierarchy_type,
2023: lower(dmt.table_alias) table_alias,
2024: tbl.table_name table_name
2025: from all_tab_columns col,
2026: hr_dm_tables tbl,
2027: hr_dm_tables dmt,
2028: hr_dm_hierarchies hir
2029: where tbl.table_name = nvl(dmt.upload_table_name, dmt.table_name)
2030: and dmt.table_id = p_table_info.table_id

Line 2027: hr_dm_tables dmt,

2023: lower(dmt.table_alias) table_alias,
2024: tbl.table_name table_name
2025: from all_tab_columns col,
2026: hr_dm_tables tbl,
2027: hr_dm_tables dmt,
2028: hr_dm_hierarchies hir
2029: where tbl.table_name = nvl(dmt.upload_table_name, dmt.table_name)
2030: and dmt.table_id = p_table_info.table_id
2031: and hierarchy_type = 'R'

Line 3033: l_generator_version hr_dm_tables.generator_version%type;

3029: l_header varchar2(32767);
3030: l_body varchar2(32767);
3031: l_header_comment varchar2(2048);
3032: l_package_name varchar2(30) := 'hrdmu_' || p_table_info.short_name;
3033: l_generator_version hr_dm_tables.generator_version%type;
3034: l_package_version varchar2(200);
3035: l_index number := 1;
3036: l_call_to_aol_proc varchar2(32767);
3037: l_dev_key_local_var varchar2(32767);