APPS.HR_DM_GEN_TDS dependencies on HR_DM_TABLES

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

385: raise;
386: end add_to_package_body;
387: -- ----------------------- get_derive_from_clause -------------------------
388: -- Description:
389: -- Uses the derive_sql_source_tables info stored in HR_DM_TABLES to form the
390: -- 'from clause'.
391: -- The from clause stored in each derive field will be in the following format :
392: -- table1 tbl,:table2 tbl2, :table3 tbl3
393: -- where ':' is the next line indicator i.e : will be replaced with new line.

Line 402: l_derive_sql hr_dm_tables.derive_sql_download_full%type;

398: p_table_info in hr_dm_gen_main.t_table_info,
399: p_from_clause in out nocopy varchar2,
400: p_lpad_spaces in number default 2
401: ) is
402: l_derive_sql hr_dm_tables.derive_sql_download_full%type;
403: l_start_ptr number;
404: l_end_ptr number;
405: l_where_string varchar2(25) := 'where';
406: l_terminator varchar2(5) := ';';

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

518: end get_cursor_from_clause;
519:
520: -- ----------------------- get_derive_where_clause -------------------------
521: -- Description:
522: -- Uses the derive_sql info stored in HR_DM_TABLES for each type of cursors.
523: -- The where clause stored in each derive field will
524: -- example derive where clause :
525: -- where tbl.col1 = tbl2.col1 : and tbl.col2 = tbl1.col2 : and tbl.col3 = tbl3.col3
526: -- Above derive where clause will be converted as

Line 549: l_derive_sql hr_dm_tables.derive_sql_download_full%type;

545: p_where_clause in out nocopy varchar2,
546: p_cursor_type in varchar2 default 'DOWNLOAD',
547: p_lpad_spaces in number default 2
548: ) is
549: l_derive_sql hr_dm_tables.derive_sql_download_full%type;
550: l_start_ptr number;
551: l_end_ptr number;
552: l_where_string varchar2(25) := 'where ';
553: l_terminator varchar2(5) := ';';

Line 1219: -- remove it and seed the derive_sql columns in HR_DM_TABLES for

1215: -- does not use the 'exists' clause which results in the same row
1216: -- being fetch equals to the number of child rows it matches. To
1217: -- avoid this ' distinct' clause is added for only these tables.
1218: -- If the 'distinct' clause causes the performance problem then
1219: -- remove it and seed the derive_sql columns in HR_DM_TABLES for
1220: -- these tables.
1221:
1222: hr_dm_utility.message('INFO','Distinct form for ' || p_table_info.table_name, 25);
1223: hr_dm_utility.message('INFO','p_table_info.use_distinct - ' || p_table_info.use_distinct, 25);

Line 1556: l_parent_table_name hr_dm_tables.table_name%type;

1552: -- this is to reduce the variable name and add clarity.
1553:
1554: l_column_name hr_dm_hierarchies.column_name%type;
1555: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
1556: l_parent_table_name hr_dm_tables.table_name%type;
1557: l_parent_table_alias hr_dm_tables.table_alias%type;
1558: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
1559: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
1560:

Line 1557: l_parent_table_alias hr_dm_tables.table_alias%type;

1553:
1554: l_column_name hr_dm_hierarchies.column_name%type;
1555: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
1556: l_parent_table_name hr_dm_tables.table_name%type;
1557: l_parent_table_alias hr_dm_tables.table_alias%type;
1558: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
1559: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
1560:
1561:

Line 1784: hr_dm_tables t

1780:
1781: cursor csr_null_hierarchy is
1782: select h.column_name
1783: from hr_dm_hierarchies h,
1784: hr_dm_tables t
1785: where h.hierarchy_type = 'N'
1786: and h.table_id = t.table_id
1787: and t.table_name = upper(p_table_info.table_name);
1788:

Line 2618: -- remove it and seed the derive_sql columns in HR_DM_TABLES for

2614: -- does not use the 'exists' clause which results in the same row
2615: -- being fetch equals to the number of child rows it matches. To
2616: -- avoid this ' distinct' clause is added for only these tables.
2617: -- If the 'distinct' clause causes the performance problem then
2618: -- remove it and seed the derive_sql columns in HR_DM_TABLES for
2619: -- these tables.
2620:
2621: if p_table_info.use_distinct = 'Y' then
2622: l_cursor_select_cols := ' select distinct ' || p_table_info.alias ||

Line 2818: l_generator_version hr_dm_tables.generator_version%type;

2814: l_header varchar2(32767);
2815: l_body varchar2(32767);
2816: l_header_comment varchar2(2048);
2817: l_package_name varchar2(30) := 'hrdmd_' || p_table_info.short_name;
2818: l_generator_version hr_dm_tables.generator_version%type;
2819: l_package_version varchar2(200);
2820: l_index number := 1;
2821: l_call_to_aol_proc varchar2(32767);
2822: l_dev_key_local_var varchar2(32767);