APPS.PAY_AUTOGN dependencies on PAY_AUTOGN

Line 1: package body pay_autogn as

1: package body pay_autogn as
2: /* $Header: pyautogn.pkb 115.2 1999/11/24 02:18:35 pkm ship $ */
3: procedure insert_bf_dimensions is
4: x number;
5: procedure my_dimension_insert ( p_route_id number,

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,

Line 700: end pay_autogn;

696: null, -- never held or stored
697: null -- never held or stored
698: );
699: end insert_bf_dimensions;
700: end pay_autogn;