eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG dependencies on FF_ROUTES

Line 10: l_text ff_routes.text%TYPE;

6: -- create_archive_dbi procedure
7: -------------------------------------------------------------------------
8: procedure create_archive_routes is
9:
10: l_text ff_routes.text%TYPE;
11: l_source_context_id number;
12: l_source_text_context_id number;
13: l_assignment_action_context_id number;
14: l_source_number_context_id number;

Line 52: from ff_routes

48: and target.context1 = &B1 /* context assignment action id */';
49:
50: select 'y'
51: into l_exists
52: from ff_routes
53: where route_name = 'ZA_NUMBER_ARCHIVE_ROUTE';
54:
55: update ff_routes
56: set text = l_text

Line 55: update ff_routes

51: into l_exists
52: from ff_routes
53: where route_name = 'ZA_NUMBER_ARCHIVE_ROUTE';
54:
55: update ff_routes
56: set text = l_text
57: where route_name = 'ZA_NUMBER_ARCHIVE_ROUTE';
58:
59: exception when no_data_found then

Line 61: insert into ff_routes

57: where route_name = 'ZA_NUMBER_ARCHIVE_ROUTE';
58:
59: exception when no_data_found then
60:
61: insert into ff_routes
62: (
63: route_id,
64: route_name,
65: user_defined_flag,

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 130: from ff_routes

126: and target.context1 = &B1 /* context assignment action id */';
127:
128: select 'y'
129: into l_exists
130: from ff_routes
131: where route_name = 'ZA_DATE_ARCHIVE_ROUTE';
132:
133: update ff_routes
134: set text = l_text

Line 133: update ff_routes

129: into l_exists
130: from ff_routes
131: where route_name = 'ZA_DATE_ARCHIVE_ROUTE';
132:
133: update ff_routes
134: set text = l_text
135: where route_name = 'ZA_DATE_ARCHIVE_ROUTE';
136:
137: exception when no_data_found then

Line 139: insert into ff_routes

135: where route_name = 'ZA_DATE_ARCHIVE_ROUTE';
136:
137: exception when no_data_found then
138:
139: insert into ff_routes
140: (
141: route_id,
142: route_name,
143: user_defined_flag,

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 208: from ff_routes

204: and target.context1 = &B1 /* context assignment action id */';
205:
206: select 'y'
207: into l_exists
208: from ff_routes
209: where route_name = 'ZA_CHARACTER_ARCHIVE_ROUTE';
210:
211: update ff_routes
212: set text = l_text

Line 211: update ff_routes

207: into l_exists
208: from ff_routes
209: where route_name = 'ZA_CHARACTER_ARCHIVE_ROUTE';
210:
211: update ff_routes
212: set text = l_text
213: where route_name = 'ZA_CHARACTER_ARCHIVE_ROUTE';
214:
215: exception when no_data_found then

Line 217: insert into ff_routes

213: where route_name = 'ZA_CHARACTER_ARCHIVE_ROUTE';
214:
215: exception when no_data_found then
216:
217: insert into ff_routes
218: (
219: route_id,
220: route_name,
221: user_defined_flag,

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 292: from ff_routes

288: and fac1.context = &B3 /* 3rd context of clearance no */';
289:
290: select 'y'
291: into l_exists
292: from ff_routes
293: where route_name = 'ZA_IRP5_DEDUCTIONS_ARCHIVE_ROUTE';
294:
295: update ff_routes
296: set text = l_text

Line 295: update ff_routes

291: into l_exists
292: from ff_routes
293: where route_name = 'ZA_IRP5_DEDUCTIONS_ARCHIVE_ROUTE';
294:
295: update ff_routes
296: set text = l_text
297: where route_name = 'ZA_IRP5_DEDUCTIONS_ARCHIVE_ROUTE';
298:
299: exception when no_data_found then

Line 301: insert into ff_routes

297: where route_name = 'ZA_IRP5_DEDUCTIONS_ARCHIVE_ROUTE';
298:
299: exception when no_data_found then
300:
301: insert into ff_routes
302: (
303: route_id,
304: route_name,
305: user_defined_flag,

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 395: from ff_routes

391: and fac.context = &B2 /* 2nd context of clearance no */';
392:
393: select 'y'
394: into l_exists
395: from ff_routes
396: where route_name = 'ZA_IRP5_4001_4003_ARCHIVE_ROUTE';
397:
398: update ff_routes
399: set text = l_text

Line 398: update ff_routes

394: into l_exists
395: from ff_routes
396: where route_name = 'ZA_IRP5_4001_4003_ARCHIVE_ROUTE';
397:
398: update ff_routes
399: set text = l_text
400: where route_name = 'ZA_IRP5_4001_4003_ARCHIVE_ROUTE';
401:
402: exception when no_data_found then

Line 404: insert into ff_routes

400: where route_name = 'ZA_IRP5_4001_4003_ARCHIVE_ROUTE';
401:
402: exception when no_data_found then
403:
404: insert into ff_routes
405: (
406: route_id,
407: route_name,
408: user_defined_flag,

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 490: from ff_routes

486: AND faic.CONTEXT = &B2 /* context SOURCE_TEXT for lump sums */';
487:
488: select 'y'
489: into l_exists
490: from ff_routes
491: where route_name = 'ZA_LMPSM_ARCHIVE_ROUTE';
492:
493: update ff_routes
494: set text = l_text

Line 493: update ff_routes

489: into l_exists
490: from ff_routes
491: where route_name = 'ZA_LMPSM_ARCHIVE_ROUTE';
492:
493: update ff_routes
494: set text = l_text
495: where route_name = 'ZA_LMPSM_ARCHIVE_ROUTE';
496:
497: exception when no_data_found then

Line 499: insert into ff_routes

495: where route_name = 'ZA_LMPSM_ARCHIVE_ROUTE';
496:
497: exception when no_data_found then
498:
499: insert into ff_routes
500: (
501: route_id,
502: route_name,
503: user_defined_flag,

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 585: from ff_routes

581: AND faic.CONTEXT = TO_CHAR(&B2) /* context SOURCE_NUMBER for Clearance Number */';
582:
583: select 'y'
584: into l_exists
585: from ff_routes
586: where route_name = 'ZA_CLRNO_ARCHIVE_ROUTE';
587:
588: update ff_routes
589: set text = l_text

Line 588: update ff_routes

584: into l_exists
585: from ff_routes
586: where route_name = 'ZA_CLRNO_ARCHIVE_ROUTE';
587:
588: update ff_routes
589: set text = l_text
590: where route_name = 'ZA_CLRNO_ARCHIVE_ROUTE';
591:
592: exception when no_data_found then

Line 594: insert into ff_routes

590: where route_name = 'ZA_CLRNO_ARCHIVE_ROUTE';
591:
592: exception when no_data_found then
593:
594: insert into ff_routes
595: (
596: route_id,
597: route_name,
598: user_defined_flag,

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:

Line 779: from ff_routes

775: end;
776:
777: select route_id
778: into l_number_archive_route_id
779: from ff_routes
780: where route_name = 'ZA_NUMBER_ARCHIVE_ROUTE';
781:
782: select route_id
783: into l_date_archive_route_id

Line 784: from ff_routes

780: where route_name = 'ZA_NUMBER_ARCHIVE_ROUTE';
781:
782: select route_id
783: into l_date_archive_route_id
784: from ff_routes
785: where route_name = 'ZA_DATE_ARCHIVE_ROUTE';
786:
787: select route_id
788: into l_character_archive_route_id

Line 789: from ff_routes

785: where route_name = 'ZA_DATE_ARCHIVE_ROUTE';
786:
787: select route_id
788: into l_character_archive_route_id
789: from ff_routes
790: where route_name = 'ZA_CHARACTER_ARCHIVE_ROUTE';
791:
792: select route_id
793: into l_irp5_deductions_route

Line 794: from ff_routes

790: where route_name = 'ZA_CHARACTER_ARCHIVE_ROUTE';
791:
792: select route_id
793: into l_irp5_deductions_route
794: from ff_routes
795: where route_name = 'ZA_IRP5_DEDUCTIONS_ARCHIVE_ROUTE';
796:
797: select route_id
798: into l_4001_4003_archive_route_id

Line 799: from ff_routes

795: where route_name = 'ZA_IRP5_DEDUCTIONS_ARCHIVE_ROUTE';
796:
797: select route_id
798: into l_4001_4003_archive_route_id
799: from ff_routes
800: where route_name = 'ZA_IRP5_4001_4003_ARCHIVE_ROUTE';
801:
802: select route_id
803: into l_lmpsm_archive_route_id

Line 804: from ff_routes

800: where route_name = 'ZA_IRP5_4001_4003_ARCHIVE_ROUTE';
801:
802: select route_id
803: into l_lmpsm_archive_route_id
804: from ff_routes
805: where route_name = 'ZA_LMPSM_ARCHIVE_ROUTE';
806:
807: select route_id
808: into l_clrno_archive_route_id

Line 809: from ff_routes

805: where route_name = 'ZA_LMPSM_ARCHIVE_ROUTE';
806:
807: select route_id
808: into l_clrno_archive_route_id
809: from ff_routes
810: where route_name = 'ZA_CLRNO_ARCHIVE_ROUTE';
811:
812: -- Choose the archive route, based on the live db item's data type
813: if l_dbi_data_type = 'N' then