APPS.PAY_US_CONTR_DBI dependencies on HR_UTILITY

Line 77: hr_utility.set_location('pay_us_contr_dbi.insert_route_parameters', 1);

73: p_data_type in varchar2,
74: p_sequence_no in number
75: ) is
76: begin
77: hr_utility.set_location('pay_us_contr_dbi.insert_route_parameters', 1);
78: insert into ff_route_parameters
79: (route_id,
80: sequence_no,
81: parameter_name,

Line 100: hr_utility.set_location('pay_us_contr_dbi.insert_route_context_usages', 1);

96: p_context_id in number,
97: p_sequence_no in number
98: ) is
99: begin
100: hr_utility.set_location('pay_us_contr_dbi.insert_route_context_usages', 1);
101: insert into ff_route_context_usages
102: (route_id,
103: context_id,
104: sequence_no)

Line 117: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 1);

113: BEGIN
114: --
115: -- get the context ids from the context table
116: --
117: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 1);
118: select context_id
119: into l_assign_id_context_id
120: from ff_contexts
121: where context_name = 'ASSIGNMENT_ID';

Line 123: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 2);

119: into l_assign_id_context_id
120: from ff_contexts
121: where context_name = 'ASSIGNMENT_ID';
122: --
123: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 2);
124: select context_id
125: into l_date_earned_context_id
126: from ff_contexts
127: where context_name = 'DATE_EARNED';

Line 175: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 5);

171: AND BCONTR.effective_end_date(+)
172: AND BCONTR.coverage_type(+) = EEV2.screen_entry_value
173: AND upper(INPUTV2.name) = ''COVERAGE''';
174: --
175: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 5);
176: select ff_routes_s.nextval
177: into l_temp
178: from dual;
179: --

Line 182: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 6);

178: from dual;
179: --
180: -- now do the normal insert
181: --
182: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 6);
183: insert into ff_routes
184: (route_id,
185: route_name,
186: user_defined_flag,

Line 246: hr_utility.set_location ('pay_us_contr_dbi.get_route', 1);

242: l_route_id NUMBER;
243: --
244: BEGIN
245: --
246: hr_utility.set_location ('pay_us_contr_dbi.get_route', 1);
247: SELECT route_id
248: INTO l_route_id
249: FROM ff_routes
250: WHERE route_name = p_route_name;

Line 318: hr_utility.set_location ('pay_us_contr_dbi.create_contr_items', 1);

314: --
315: -- retrieve details of the input value and element type
316: --
317: begin
318: hr_utility.set_location ('pay_us_contr_dbi.create_contr_items', 1);
319: select ET.element_type_id,
320: replace (ltrim (rtrim (upper (ET.element_name))), ' ', '_'),
321: replace (ltrim (rtrim (upper (IV.name))), ' ', '_'),
322: IV.business_group_id,

Line 377: hr_utility.set_location ('pay_us_contr_dbi.create_contr_items', 2);

373: -- Handle variable data type
374: --
375: l_text := 'min (' || p_start_string || l_text || p_end_string || ')';
376: --
377: hr_utility.set_location ('pay_us_contr_dbi.create_contr_items', 2);
378: create_item
379: (l_business_group_id
380: ,l_legislation_code
381: ,l_route_name