DBA Data[Home] [Help]

APPS.PAY_AUTOGN dependencies on HR_UTILITY

Line 16: hr_utility.trace('p_dimension_name is ' || p_dimension_name);

12: p_feed_checking_code varchar2,
13: p_expiry_checking_level varchar2,
14: p_expiry_checking_code varchar2) is
15: begin
16: hr_utility.trace('p_dimension_name is ' || p_dimension_name);
17: x := pay_db_balances_pkg.create_balance_dimension
18: (p_legislation_code => 'BF',
19: p_route_id => p_route_id,
20: p_database_item_suffix => p_database_item_suffix,

Line 36: hr_utility.set_location('pay_autogn.insert_bf_dimensions',20);

32: begin
33: --
34: -- insert row into ff_route_context_usages
35: --
36: hr_utility.set_location('pay_autogn.insert_bf_dimensions',20);
37: insert into ff_route_context_usages
38: (route_id,
39: context_id,
40: sequence_no)

Line 49: hr_utility.set_location('pay_autogn.insert_bf_dimensions',30);

45: where CON.context_name = 'ASSIGNMENT_ACTION_ID';
46: --
47: -- insert row into ff_route_parameters
48: --
49: hr_utility.set_location('pay_autogn.insert_bf_dimensions',30);
50: insert into ff_route_parameters
51: (route_parameter_id,
52: route_id,
53: sequence_no,

Line 62: hr_utility.set_location('pay_autogn.insert_bf_dimensions',40);

58: ff_routes_s.currval,
59: 1,
60: 'Balance Type ID',
61: 'N');
62: hr_utility.set_location('pay_autogn.insert_bf_dimensions',40);
63: select ff_routes_s.currval into x from dual;
64: --
65: return x;
66: --

Line 70: hr_utility.set_location('pay_autogn.insert_bf_dimensions',1);

66: --
67: end do_child_inserts;
68: begin
69: -- Insert row in FF_ROUTES for this dimension
70: hr_utility.set_location('pay_autogn.insert_bf_dimensions',1);
71: insert into ff_routes
72: (route_id,
73: user_defined_flag,
74: route_name,

Line 136: hr_utility.set_location('pay_autogn.insert_bf_dimensions',2);

132: 'P', -- expiry check at payroll action level
133: 'pay_bf_expc.pytd_ec' -- expry checking procedure.
134: );
135: -- Insert row in FF_ROUTES for this dimension
136: hr_utility.set_location('pay_autogn.insert_bf_dimensions',2);
137: insert into ff_routes
138: (route_id,
139: user_defined_flag,
140: route_name,

Line 194: hr_utility.set_location('pay_autogn.insert_bf_dimensions',3);

190: 'P',
191: 'pay_bf_expc.aytd_ec' -- checking code.
192: );
193: -- Insert row in FF_ROUTES for this dimension
194: hr_utility.set_location('pay_autogn.insert_bf_dimensions',3);
195: insert into ff_routes
196: (route_id,
197: user_defined_flag,
198: route_name,

Line 259: hr_utility.set_location('pay_autogn.insert_bf_dimensions',5);

255: 'P', -- expiry check at Payroll Action level
256: 'pay_bf_expc.pptd_ec' -- expiry checking procedure.
257: );
258: -- Insert row in FF_ROUTES for this dimension
259: hr_utility.set_location('pay_autogn.insert_bf_dimensions',5);
260: insert into ff_routes
261: (route_id,
262: user_defined_flag,
263: route_name,

Line 316: hr_utility.set_location('pay_autogn.insert_bf_dimensions',4);

312: 'P', -- expiry check at Payroll Action level
313: 'pay_bf_expc.aptd_ec' -- expiry checking procedure.
314: );
315: -- Insert row in FF_ROUTES for this dimension
316: hr_utility.set_location('pay_autogn.insert_bf_dimensions',4);
317: insert into ff_routes
318: (route_id,
319: user_defined_flag,
320: route_name,

Line 381: hr_utility.set_location('pay_autogn.insert_bf_dimensions',6);

377: 'A', -- expiry check at Assignment Action level
378: 'pay_bf_expc.pptd_alc_ec'
379: );
380: -- Insert row in FF_ROUTES for this dimension
381: hr_utility.set_location('pay_autogn.insert_bf_dimensions',6);
382: insert into ff_routes
383: (route_id,
384: user_defined_flag,
385: route_name,

Line 440: hr_utility.set_location('pay_autogn.insert_bf_dimensions',7);

436: 'P', -- expiry check at payroll action level.
437: 'pay_bf_expc.never_expires'
438: );
439: -- Insert row in FF_ROUTES for this dimension
440: hr_utility.set_location('pay_autogn.insert_bf_dimensions',7);
441: insert into ff_routes
442: (route_id,
443: user_defined_flag,
444: route_name,

Line 491: hr_utility.set_location('pay_autogn.insert_bf_dimensions',8);

487: 'P', -- expiry check at Payroll Action level
488: 'pay_bf_expc.never_expires'
489: );
490: -- Insert row in FF_ROUTES for this dimension
491: hr_utility.set_location('pay_autogn.insert_bf_dimensions',8);
492: insert into ff_routes
493: (route_id,
494: user_defined_flag,
495: route_name,

Line 542: hr_utility.set_location('pay_autogn.insert_bf_dimensions',9);

538: null, -- never fed or stored
539: null -- never fed or stored
540: );
541: -- Insert row in FF_ROUTES for this dimension
542: hr_utility.set_location('pay_autogn.insert_bf_dimensions',9);
543: insert into ff_routes
544: (route_id,
545: user_defined_flag,
546: route_name,

Line 588: hr_utility.set_location('pay_autogn.insert_bf_dimensions',10);

584: null, -- never stored, no expiry details needed
585: null -- never stored, no expiry details needed
586: );
587: -- Insert row in FF_ROUTES for this dimension
588: hr_utility.set_location('pay_autogn.insert_bf_dimensions',10);
589: insert into ff_routes
590: (route_id,
591: user_defined_flag,
592: route_name,

Line 647: hr_utility.set_location('pay_autogn.insert_bf_dimensions',11);

643: 'P', -- expiry check at payroll action level.
644: 'pay_bf_expc.pcon_ec' -- expiry checking procedure.
645: );
646: -- Insert row in FF_ROUTES for this dimension
647: hr_utility.set_location('pay_autogn.insert_bf_dimensions',11);
648: insert into ff_routes
649: (route_id,
650: user_defined_flag,
651: route_name,