DBA Data[Home] [Help]

APPS.PAY_GBATGN dependencies on HR_UTILITY

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

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

Line 34: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',20);

30: begin
31: --
32: -- insert row into ff_route_context_usages
33: --
34: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',20);
35: insert into ff_route_context_usages
36: (route_id,
37: context_id,
38: sequence_no)

Line 47: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',30);

43: where CON.context_name = 'ASSIGNMENT_ACTION_ID';
44: --
45: -- insert row into ff_route_parameters
46: --
47: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',30);
48: insert into ff_route_parameters
49: (route_parameter_id,
50: route_id,
51: sequence_no,

Line 60: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',40);

56: ff_routes_s.currval,
57: 1,
58: 'Balance Type ID',
59: 'N');
60: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',40);
61: select ff_routes_s.currval into x from dual;
62: --
63: return x;
64: --

Line 68: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',1);

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

Line 150: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',2);

146: end if;
147: end;'
148: );
149: -- Insert row in FF_ROUTES for this dimension
150: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',2);
151: insert into ff_routes
152: (route_id,
153: user_defined_flag,
154: route_name,

Line 224: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',3);

220: end if;
221: end;'
222: );
223: -- Insert row in FF_ROUTES for this dimension
224: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',3);
225: insert into ff_routes
226: (route_id,
227: user_defined_flag,
228: route_name,

Line 304: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',4);

300: end if;
301: end;'
302: );
303: -- Insert row in FF_ROUTES for this dimension
304: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',4);
305: insert into ff_routes
306: (route_id,
307: user_defined_flag,
308: route_name,

Line 376: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',5);

372: end if;
373: end;'
374: );
375: -- Insert row in FF_ROUTES for this dimension
376: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',5);
377: insert into ff_routes
378: (route_id,
379: user_defined_flag,
380: route_name,

Line 434: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',6);

430: 'P', -- expiry check at Payroll Action level
431: 'l_dimension_expired := 0;' -- never expires
432: );
433: -- Insert row in FF_ROUTES for this dimension
434: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',6);
435: insert into ff_routes
436: (route_id,
437: user_defined_flag,
438: route_name,

Line 484: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',7);

480: 'P', -- expiry check at Payroll Action level
481: 'l_dimension_expired := 0;' -- never expires
482: );
483: -- Insert row in FF_ROUTES for this dimension
484: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',7);
485: insert into ff_routes
486: (route_id,
487: user_defined_flag,
488: route_name,

Line 530: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',8);

526: null, -- never stored, no expiry details needed
527: null -- never stored, no expiry details needed
528: );
529: -- Insert row in FF_ROUTES for this dimension
530: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',8);
531: insert into ff_routes
532: (route_id,
533: user_defined_flag,
534: route_name,

Line 620: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',9);

616: end if;
617: end;'
618: );
619: -- Insert row in FF_ROUTES for this dimension
620: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',9);
621: insert into ff_routes
622: (route_id,
623: user_defined_flag,
624: route_name,