DBA Data[Home] [Help]

APPS.PAY_AUTOGN dependencies on FF_ROUTE_PARAMETERS

Line 47: -- insert row into ff_route_parameters

43: 1
44: from ff_contexts CON
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,

Line 50: insert into ff_route_parameters

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,
54: parameter_name,

Line 57: (ff_route_parameters_s.nextval,

53: sequence_no,
54: parameter_name,
55: data_type)
56: values
57: (ff_route_parameters_s.nextval,
58: ff_routes_s.currval,
59: 1,
60: 'Balance Type ID',
61: 'N');

Line 117: -- now insert rows into ff_route_context_usages and ff_route_parameters

113: ASS.effective_start_date and ASS.effective_end_date
114: and PACT.effective_date between
115: START_ASS.effective_start_date and START_ASS.effective_end_date');
116: --
117: -- now insert rows into ff_route_context_usages and ff_route_parameters
118: -- and load variable with the current route_id
119: --
120: x := do_child_inserts;
121: --

Line 175: -- now insert rows into ff_route_context_usages and ff_route_parameters

171: from dual)
172: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
173: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
174: --
175: -- now insert rows into ff_route_context_usages and ff_route_parameters
176: -- and load variable with the current route_id
177: --
178: x := do_child_inserts;
179: --

Line 240: -- now insert rows into ff_route_context_usages and ff_route_parameters

236: ASS.effective_start_date and ASS.effective_end_date
237: and PACT.effective_date between
238: START_ASS.effective_start_date and START_ASS.effective_end_date');
239: --
240: -- now insert rows into ff_route_context_usages and ff_route_parameters
241: -- and load variable with the current route_id
242: --
243: x := do_child_inserts;
244: --

Line 297: -- now insert rows into ff_route_context_usages and ff_route_parameters

293: )
294: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
295: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
296: --
297: -- now insert rows into ff_route_context_usages and ff_route_parameters
298: -- and load variable with the current route_id
299: --
300: x := do_child_inserts;
301: --

Line 362: -- now insert rows into ff_route_context_usages and ff_route_parameters

358: ASS.effective_start_date and ASS.effective_end_date
359: and PACT.effective_date between
360: START_ASS.effective_start_date and START_ASS.effective_end_date');
361: --
362: -- now insert rows into ff_route_context_usages and ff_route_parameters
363: -- and load variable with the current route_id
364: --
365: x := do_child_inserts;
366: --

Line 421: -- now insert rows into ff_route_context_usages and ff_route_parameters

417: ASS.effective_start_date and ASS.effective_end_date
418: and PACT.effective_date between
419: START_ASS.effective_start_date and START_ASS.effective_end_date');
420: --
421: -- now insert rows into ff_route_context_usages and ff_route_parameters
422: -- and load variable with the current route_id
423: --
424: x := do_child_inserts;
425: --

Line 472: -- now insert rows into ff_route_context_usages and ff_route_parameters

468: and RR.status in (''P'',''PA'')
469: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
470: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
471: --
472: -- now insert rows into ff_route_context_usages and ff_route_parameters
473: -- and load variable with the current route_id
474: --
475: x := do_child_inserts;
476: --

Line 523: -- now insert rows into ff_route_context_usages and ff_route_parameters

519: and RR.status in (''P'',''PA'')
520: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
521: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
522: --
523: -- now insert rows into ff_route_context_usages and ff_route_parameters
524: -- and load variable with the current route_id
525: --
526: x := do_child_inserts;
527: --

Line 569: -- now insert rows into ff_route_context_usages and ff_route_parameters

565: and PACT.effective_date between
566: FEED.effective_start_date and FEED.effective_end_date
567: and RR.status in (''P'',''PA'')');
568: --
569: -- now insert rows into ff_route_context_usages and ff_route_parameters
570: -- and load variable with the current route_id
571: --
572: x := do_child_inserts;
573: --

Line 628: -- now insert rows into ff_route_context_usages and ff_route_parameters

624: ASS.effective_start_date and ASS.effective_end_date
625: and PACT.effective_date between
626: START_ASS.effective_start_date and START_ASS.effective_end_date');
627: --
628: -- now insert rows into ff_route_context_usages and ff_route_parameters
629: -- and load variable with the current route_id
630: --
631: x := do_child_inserts;
632: --

Line 681: -- now insert rows into ff_route_context_usages and ff_route_parameters

677: and ASSACT.assignment_action_id = INTLK.locked_action_id
678: and INTLK.locking_action_id = BAL_ASSACT.assignment_action_id
679: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
680: --
681: -- now insert rows into ff_route_context_usages and ff_route_parameters
682: -- and load variable with the current route_id
683: --
684: x := do_child_inserts;
685: --