eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DM_GEN_TDS dependencies on HR_DM_GEN_MAIN

Line 9: g_table_info hr_dm_gen_main.t_table_info;

5: --type t_varchar2_tbl is table of varchar2(32767) index by binary_integer;
6: type t_varchar2_32k_tbl is table of varchar2(32767) index by binary_integer;
7:
8:
9: g_table_info hr_dm_gen_main.t_table_info;
10: g_columns_tbl hr_dm_library.t_varchar2_tbl;
11: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
12: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
13: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;

Line 14: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;

10: g_columns_tbl hr_dm_library.t_varchar2_tbl;
11: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
12: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
13: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
14: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
15: g_surrogate_pk_col_param varchar2(30);
16:
17: -- to store the package body in to array so as to overcome the limit of 32767
18: -- character the global variable is defined.

Line 193: p_table_info in hr_dm_gen_main.t_table_info,

189: -- 'END' - to put the debug message at end.
190: -- ------------------------------------------------------------------------
191: procedure add_debug_messages
192: (
193: p_table_info in hr_dm_gen_main.t_table_info,
194: p_procedure_name in varchar2,
195: p_message_location in varchar2,
196: p_proc_body in out nocopy varchar2
197: ) is

Line 398: p_table_info in hr_dm_gen_main.t_table_info,

394: -- o If 'from' string is not there it puts the from string.
395: -- ------------------------------------------------------------------------------
396: procedure get_derive_from_clause
397: (
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;

Line 461: p_table_info in hr_dm_gen_main.t_table_info,

457: -- then it is derived from the table hierarchy table.
458: -- ------------------------------------------------------------------------
459: procedure get_cursor_from_clause
460: (
461: p_table_info in hr_dm_gen_main.t_table_info,
462: p_from_clause out nocopy varchar2 ,
463: p_lpad_spaces in number default 2
464: ) is
465:

Line 466: l_parent_table_info hr_dm_gen_main.t_table_info;

462: p_from_clause out nocopy varchar2 ,
463: p_lpad_spaces in number default 2
464: ) is
465:
466: l_parent_table_info hr_dm_gen_main.t_table_info;
467:
468: -- get all parent tables required to get the business group id, if business
469: -- group id is not there in the table to be downloaded.
470:

Line 544: p_table_info in hr_dm_gen_main.t_table_info,

540: -- 'DELETE_SOURCE' - where clause for delete source
541: -- ------------------------------------------------------------------------------
542: procedure get_derive_where_clause
543: (
544: p_table_info in hr_dm_gen_main.t_table_info,
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

Line 687: p_table_info in hr_dm_gen_main.t_table_info,

683: -- components : (a,c)
684: -- ------------------------------------------------------------------------------
685: procedure get_gen_cursor_where_clause
686: (
687: p_table_info in hr_dm_gen_main.t_table_info,
688: p_where_clause in out nocopy varchar2,
689: p_cursor_type in varchar2 default 'DOWNLOAD',
690: p_lpad_spaces in number default 2
691: ) is

Line 693: l_parent_table_info hr_dm_gen_main.t_table_info;

689: p_cursor_type in varchar2 default 'DOWNLOAD',
690: p_lpad_spaces in number default 2
691: ) is
692:
693: l_parent_table_info hr_dm_gen_main.t_table_info;
694: l_selective_criteria varchar2(8000);
695:
696: -- get the selective formula criteria
697: cursor get_sel_formula is

Line 773: (hr_dm_gen_main.chk_ins_resolve_pk(p_table_info.table_id) = 'N') then

769: -- last_update_date clause is ommitted.
770:
771: if (p_table_info.missing_who_info = 'N') and
772: (p_table_info.datetrack = 'N') and
773: (hr_dm_gen_main.chk_ins_resolve_pk(p_table_info.table_id) = 'N') then
774:
775: -- add 'and' if the surrogate id criteria has been applied.
776:
777: if p_table_info.surrogate_primary_key = 'Y' then

Line 804: (hr_dm_gen_main.chk_ins_resolve_pk(p_table_info.table_id) = 'N') then

800:
801: -- Add the last_update_date comparison in the where clause, if table has
802: -- WHO columns.
803: if p_table_info.missing_who_info = 'N' and
804: (hr_dm_gen_main.chk_ins_resolve_pk(p_table_info.table_id) = 'N') then
805:
806: p_where_clause := p_where_clause || p_table_info.alias || '.' ||
807: 'last_update_date >= nvl(p_last_migration_date,' ||
808: indent(38) || p_table_info.alias || '.last_update_date)';

Line 906: p_table_info in hr_dm_gen_main.t_table_info,

902: -- components : (c)
903: -- ------------------------------------------------------------------------
904: procedure get_dt_subqry_where_clause
905: (
906: p_table_info in hr_dm_gen_main.t_table_info,
907: p_where_clause in out nocopy varchar2,
908: p_cursor_type in varchar2 default 'DOWNLOAD',
909: p_lpad_spaces in number default 2
910: ) is

Line 912: l_parent_table_info hr_dm_gen_main.t_table_info;

908: p_cursor_type in varchar2 default 'DOWNLOAD',
909: p_lpad_spaces in number default 2
910: ) is
911:
912: l_parent_table_info hr_dm_gen_main.t_table_info;
913: begin
914:
915: /*
916: Following where clause stmt will be created by the assignment below e.g

Line 962: p_table_info in hr_dm_gen_main.t_table_info,

958: -- components : (a,b,c)
959: -- ------------------------------------------------------------------------
960: procedure get_dt_cursor_where_clause
961: (
962: p_table_info in hr_dm_gen_main.t_table_info,
963: p_where_clause out nocopy varchar2,
964: p_cursor_type in varchar2 default 'DOWNLOAD',
965: p_lpad_spaces in number default 2
966: ) is

Line 1142: p_table_info in hr_dm_gen_main.t_table_info,

1138: -- migration is same.
1139: -- ------------------------------------------------------------------------
1140: procedure prepare_download_cursor
1141: (
1142: p_table_info in hr_dm_gen_main.t_table_info,
1143: p_cursor out nocopy varchar2,
1144: p_cursor_type in varchar2 default 'FULL_BG_MIGRATION',
1145: p_hier_column in varchar2 default 'N'
1146: )

Line 1283: p_table_info in hr_dm_gen_main.t_table_info,

1279: -- ------------------------------------------------------------------------
1280:
1281: procedure prepare_dt_private_procedures
1282: (
1283: p_table_info in hr_dm_gen_main.t_table_info,
1284: p_body out nocopy varchar2
1285: ) is
1286: l_proc_body varchar2(32767) := null;
1287: l_indent number;

Line 1383: p_table_info in hr_dm_gen_main.t_table_info,

1379: -- hier_col2 := null;
1380: -- ------------------------------------------------------------------------
1381: procedure nullify_hierarchical_cols
1382: (
1383: p_table_info in hr_dm_gen_main.t_table_info,
1384: p_lpad_spaces in number,
1385: p_body out nocopy varchar2
1386: )
1387: is

Line 1433: p_table_info in hr_dm_gen_main.t_table_info

1429: -- Generates the get link value from the sequence procedure of the TDS
1430: -- ------------------------------------------------------------------------
1431: procedure generate_get_link_value
1432: (
1433: p_table_info in hr_dm_gen_main.t_table_info
1434: )
1435: is
1436: l_interface varchar2(32767);
1437: l_locals varchar2(32767) := null;

Line 1537: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,

1533: -- developer key
1534: -- ------------------------------------------------------------------------
1535: procedure generate_developer_key_func
1536: (
1537: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
1538: p_table_info in hr_dm_gen_main.t_table_info,
1539: p_call_to_proc_body in out nocopy varchar2,
1540: p_dev_key_local_var_body in out nocopy varchar2
1541: )

Line 1538: p_table_info in hr_dm_gen_main.t_table_info,

1534: -- ------------------------------------------------------------------------
1535: procedure generate_developer_key_func
1536: (
1537: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
1538: p_table_info in hr_dm_gen_main.t_table_info,
1539: p_call_to_proc_body in out nocopy varchar2,
1540: p_dev_key_local_var_body in out nocopy varchar2
1541: )
1542: is

Line 1744: p_table_info in hr_dm_gen_main.t_table_info,

1740: -- Generates the download procedure of the TDS
1741: -- ------------------------------------------------------------------------
1742: procedure generate_download
1743: (
1744: p_table_info in hr_dm_gen_main.t_table_info,
1745: p_header in out nocopy varchar2,
1746: p_hier_column in varchar2 default 'N',
1747: p_call_to_proc_body in varchar2,
1748: p_dev_key_local_var_body in varchar2,

Line 1749: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl

1745: p_header in out nocopy varchar2,
1746: p_hier_column in varchar2 default 'N',
1747: p_call_to_proc_body in varchar2,
1748: p_dev_key_local_var_body in varchar2,
1749: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
1750: )
1751: is
1752: l_interface varchar2(32767);
1753: l_locals varchar2(32767) := null;

Line 2121: p_table_info in hr_dm_gen_main.t_table_info,

2117: -- Preapre the cursor for calculate ranges procedure
2118: -- ------------------------------------------------------------------------
2119: procedure prepare_calc_range_cursor
2120: (
2121: p_table_info in hr_dm_gen_main.t_table_info,
2122: p_cursor out nocopy varchar2
2123: )
2124: is
2125: l_cursor_comment varchar2(2000);

Line 2180: p_table_info in hr_dm_gen_main.t_table_info,

2176: -- Generates the calculate_ranges procedure of the TDS
2177: -- ------------------------------------------------------------------------
2178: procedure generate_calculate_ranges
2179: (
2180: p_table_info in hr_dm_gen_main.t_table_info,
2181: p_header in out nocopy varchar2
2182: )
2183: is
2184: l_interface varchar2(32767);

Line 2389: p_table_info in hr_dm_gen_main.t_table_info,

2385: -- Preapre the cursor for delete data pump procedure
2386: -- ------------------------------------------------------------------------
2387: procedure prepare_del_datapump_cursor
2388: (
2389: p_table_info in hr_dm_gen_main.t_table_info,
2390: p_cursor out nocopy varchar2
2391: )
2392: is
2393: l_cursor_comment varchar2(2000);

Line 2456: p_table_info in hr_dm_gen_main.t_table_info,

2452: -- Generates the delete_datapump procedure of the TDS
2453: -- ------------------------------------------------------------------------
2454: procedure generate_delete_datapump
2455: (
2456: p_table_info in hr_dm_gen_main.t_table_info,
2457: p_header in out nocopy varchar2
2458: )
2459: is
2460: l_interface varchar2(32767);

Line 2586: p_table_info in hr_dm_gen_main.t_table_info,

2582: -- which has been migrated.
2583: -- ------------------------------------------------------------------------
2584: procedure prepare_delete_source_cursor
2585: (
2586: p_table_info in hr_dm_gen_main.t_table_info,
2587: p_cursor out nocopy varchar2
2588: )
2589: is
2590: l_cursor_comment varchar2(2000);

Line 2659: p_table_info in hr_dm_gen_main.t_table_info,

2655: -- Generates the delete_source procedure of the TDS.
2656: -- ------------------------------------------------------------------------
2657: procedure generate_delete_source
2658: (
2659: p_table_info in hr_dm_gen_main.t_table_info,
2660: p_header in out nocopy varchar2
2661: )
2662: is
2663: l_interface varchar2(32767);

Line 2806: p_table_info in hr_dm_gen_main.t_table_info,

2802: -- table.
2803: -- ------------------------------------------------------------------------
2804: procedure create_tds_pacakge
2805: (
2806: p_table_info in hr_dm_gen_main.t_table_info,
2807: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
2808: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2809: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
2810: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,

Line 2811: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl

2807: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
2808: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2809: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
2810: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2811: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
2812: )
2813: is
2814: l_header varchar2(32767);
2815: l_body varchar2(32767);