DBA Data[Home] [Help]

APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG dependencies on FF_ROUTES_S

Line 76: ff_routes_s.nextval,

72: creation_date
73: )
74: values
75: (
76: ff_routes_s.nextval,
77: 'ZA_NUMBER_ARCHIVE_ROUTE',
78: 'N',
79: 'Generic number archive route',
80: l_text,

Line 98: ff_routes_s.currval,

94: parameter_name,
95: sequence_no
96: )
97: select ff_route_parameters_s.nextval,
98: ff_routes_s.currval,
99: 'N',
100: 'User Entity ID',
101: 1
102: from dual;

Line 111: select ff_routes_s.currval,

107: route_id,
108: context_id,
109: sequence_no
110: )
111: select ff_routes_s.currval,
112: l_assignment_action_context_id,
113: 1
114: from dual;
115:

Line 154: ff_routes_s.nextval,

150: creation_date
151: )
152: values
153: (
154: ff_routes_s.nextval,
155: 'ZA_DATE_ARCHIVE_ROUTE',
156: 'N',
157: 'Generic date archive route',
158: l_text,

Line 176: ff_routes_s.currval,

172: parameter_name,
173: sequence_no
174: )
175: select ff_route_parameters_s.nextval,
176: ff_routes_s.currval,
177: 'N',
178: 'User Entity ID',
179: 1
180: from dual;

Line 189: select ff_routes_s.currval,

185: route_id,
186: context_id,
187: sequence_no
188: )
189: select ff_routes_s.currval,
190: l_assignment_action_context_id,
191: 1
192: from dual;
193:

Line 232: ff_routes_s.nextval,

228: creation_date
229: )
230: values
231: (
232: ff_routes_s.nextval,
233: 'ZA_CHARACTER_ARCHIVE_ROUTE',
234: 'N',
235: 'Generic character archive route',
236: l_text,

Line 254: ff_routes_s.currval,

250: parameter_name,
251: sequence_no
252: )
253: select ff_route_parameters_s.nextval,
254: ff_routes_s.currval,
255: 'N',
256: 'User Entity ID',
257: 1
258: from dual;

Line 267: select ff_routes_s.currval,

263: route_id,
264: context_id,
265: sequence_no
266: )
267: select ff_routes_s.currval,
268: l_assignment_action_context_id,
269: 1
270: from dual;
271:

Line 316: ff_routes_s.nextval,

312: creation_date
313: )
314: values
315: (
316: ff_routes_s.nextval,
317: 'ZA_IRP5_DEDUCTIONS_ARCHIVE_ROUTE',
318: 'N',
319: 'IRP5 Deductions archive route',
320: l_text,

Line 338: ff_routes_s.currval,

334: parameter_name,
335: sequence_no
336: )
337: select ff_route_parameters_s.nextval,
338: ff_routes_s.currval,
339: 'N',
340: 'User Entity ID',
341: 1
342: from dual;

Line 351: select ff_routes_s.currval,

347: route_id,
348: context_id,
349: sequence_no
350: )
351: select ff_routes_s.currval,
352: l_assignment_action_context_id,
353: 1
354: from dual;
355:

Line 362: select ff_routes_s.currval,

358: route_id,
359: context_id,
360: sequence_no
361: )
362: select ff_routes_s.currval,
363: l_source_context_id,
364: 2
365: from dual;
366:

Line 373: select ff_routes_s.currval,

369: route_id,
370: context_id,
371: sequence_no
372: )
373: select ff_routes_s.currval,
374: l_source_text_context_id,
375: 3
376: from dual;
377:

Line 419: ff_routes_s.nextval,

415: creation_date
416: )
417: values
418: (
419: ff_routes_s.nextval,
420: 'ZA_IRP5_4001_4003_ARCHIVE_ROUTE',
421: 'N',
422: 'IRP5 4001 to 4003 archive route',
423: l_text,

Line 441: ff_routes_s.currval,

437: parameter_name,
438: sequence_no
439: )
440: select ff_route_parameters_s.nextval,
441: ff_routes_s.currval,
442: 'N',
443: 'User Entity ID',
444: 1
445: from dual;

Line 454: select ff_routes_s.currval,

450: route_id,
451: context_id,
452: sequence_no
453: )
454: select ff_routes_s.currval,
455: l_assignment_action_context_id,
456: 1
457: from dual;
458:

Line 465: select ff_routes_s.currval,

461: route_id,
462: context_id,
463: sequence_no
464: )
465: select ff_routes_s.currval,
466: l_source_text_context_id,
467: 2
468: from dual;
469:

Line 514: ff_routes_s.nextval,

510: creation_date
511: )
512: values
513: (
514: ff_routes_s.nextval,
515: 'ZA_LMPSM_ARCHIVE_ROUTE',
516: 'N',
517: 'Generic number archive route with SOURCE_TEXT context',
518: l_text,

Line 536: ff_routes_s.currval,

532: parameter_name,
533: sequence_no
534: )
535: select ff_route_parameters_s.nextval,
536: ff_routes_s.currval,
537: 'N',
538: 'User Entity ID',
539: 1
540: from dual;

Line 549: select ff_routes_s.currval,

545: route_id,
546: context_id,
547: sequence_no
548: )
549: select ff_routes_s.currval,
550: l_assignment_action_context_id,
551: 1
552: from dual;
553:

Line 560: select ff_routes_s.currval,

556: route_id,
557: context_id,
558: sequence_no
559: )
560: select ff_routes_s.currval,
561: l_source_text_context_id,
562: 2
563: from dual;
564:

Line 609: ff_routes_s.nextval,

605: creation_date
606: )
607: values
608: (
609: ff_routes_s.nextval,
610: 'ZA_CLRNO_ARCHIVE_ROUTE',
611: 'N',
612: 'Generic number archive route with SOURCE_NUMBER context',
613: l_text,

Line 631: ff_routes_s.currval,

627: parameter_name,
628: sequence_no
629: )
630: select ff_route_parameters_s.nextval,
631: ff_routes_s.currval,
632: 'N',
633: 'User Entity ID',
634: 1
635: from dual;

Line 644: select ff_routes_s.currval,

640: route_id,
641: context_id,
642: sequence_no
643: )
644: select ff_routes_s.currval,
645: l_assignment_action_context_id,
646: 1
647: from dual;
648:

Line 655: select ff_routes_s.currval,

651: route_id,
652: context_id,
653: sequence_no
654: )
655: select ff_routes_s.currval,
656: l_source_number_context_id,
657: 2
658: from dual;
659: