APPS.HR_DM_IMP_BG_WHERE dependencies on HR_DM_GEN_MAIN

Line 66: ( p_table_info in hr_dm_gen_main.t_table_info ) is

62: -- populate the PL/SQL table with the hierarchy information for deriving the
63: -- business group id.
64: -----------------------------------------------------------------------------
65: procedure populate_table
66: ( p_table_info in hr_dm_gen_main.t_table_info ) is
67:
68: --
69: -- This cursor will get the information of all the parent tables to be
70: -- used in deriving the business group id.

Line 90: l_child_table_info hr_dm_gen_main.t_table_info;

86: start with table_id = p_table_info.table_id
87: connect by prior parent_table_id = table_id
88: order by level desc;
89:
90: l_child_table_info hr_dm_gen_main.t_table_info;
91: l_parent_table_info hr_dm_gen_main.t_table_info;
92:
93: l_index number := 1;
94: begin

Line 91: l_parent_table_info hr_dm_gen_main.t_table_info;

87: connect by prior parent_table_id = table_id
88: order by level desc;
89:
90: l_child_table_info hr_dm_gen_main.t_table_info;
91: l_parent_table_info hr_dm_gen_main.t_table_info;
92:
93: l_index number := 1;
94: begin
95: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.populate_table', 5);

Line 461: (p_table_info in hr_dm_gen_main.t_table_info,

457: -- p_table_index - Index of the g_hierarchy_info_tbl list. Index is used
458: -- get the starting parent and table name.
459: ---------------------------------------------------------------------
460: procedure prepare_where_clause_for_chain
461: (p_table_info in hr_dm_gen_main.t_table_info,
462: p_table_index in number,
463: p_cursor_type in varchar2,
464: p_query_type in varchar2
465: ) is

Line 695: (p_table_info in hr_dm_gen_main.t_table_info,

691: -- 'SUB_QUERY' - Download cursor sub query where clause
692: -- Additive migration of date track table.
693: ------------------------------------------------------------------------------
694: procedure prepare_where_clause
695: (p_table_info in hr_dm_gen_main.t_table_info,
696: p_cursor_type in varchar2,
697: p_query_type in varchar2,
698: p_where_clause out nocopy varchar2
699: ) is

Line 871: (p_table_info in hr_dm_gen_main.t_table_info,

867: -- p_where_clause - Formatted where clause.
868: --
869: -------------------------------------------------------------------------
870: procedure main
871: (p_table_info in hr_dm_gen_main.t_table_info,
872: p_cursor_type in varchar2,
873: p_query_type in varchar2,
874: p_where_clause out nocopy varchar2) is
875: