APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG dependencies on DUAL

Line 102: from dual;

98: ff_routes_s.currval,
99: 'N',
100: 'User Entity ID',
101: 1
102: from dual;
103:
104: -- Define the route context usage
105: insert into ff_route_context_usages
106: (

Line 114: from dual;

110: )
111: select ff_routes_s.currval,
112: l_assignment_action_context_id,
113: 1
114: from dual;
115:
116: end;
117:
118: -------------------------------------------------------------------------

Line 180: from dual;

176: ff_routes_s.currval,
177: 'N',
178: 'User Entity ID',
179: 1
180: from dual;
181:
182: -- Define the route context usage
183: insert into ff_route_context_usages
184: (

Line 192: from dual;

188: )
189: select ff_routes_s.currval,
190: l_assignment_action_context_id,
191: 1
192: from dual;
193:
194: end;
195:
196: -------------------------------------------------------------------------

Line 258: from dual;

254: ff_routes_s.currval,
255: 'N',
256: 'User Entity ID',
257: 1
258: from dual;
259:
260: -- Define the route context usage
261: insert into ff_route_context_usages
262: (

Line 270: from dual;

266: )
267: select ff_routes_s.currval,
268: l_assignment_action_context_id,
269: 1
270: from dual;
271:
272: end;
273:
274: -------------------------------------------------------------------------

Line 342: from dual;

338: ff_routes_s.currval,
339: 'N',
340: 'User Entity ID',
341: 1
342: from dual;
343:
344: -- Define the route context usage
345: insert into ff_route_context_usages
346: (

Line 354: from dual;

350: )
351: select ff_routes_s.currval,
352: l_assignment_action_context_id,
353: 1
354: from dual;
355:
356: insert into ff_route_context_usages
357: (
358: route_id,

Line 365: from dual;

361: )
362: select ff_routes_s.currval,
363: l_source_context_id,
364: 2
365: from dual;
366:
367: insert into ff_route_context_usages
368: (
369: route_id,

Line 376: from dual;

372: )
373: select ff_routes_s.currval,
374: l_source_text_context_id,
375: 3
376: from dual;
377:
378: end;
379:
380: -------------------------------------------------------------------------

Line 445: from dual;

441: ff_routes_s.currval,
442: 'N',
443: 'User Entity ID',
444: 1
445: from dual;
446:
447: -- Define the route context usage
448: insert into ff_route_context_usages
449: (

Line 457: from dual;

453: )
454: select ff_routes_s.currval,
455: l_assignment_action_context_id,
456: 1
457: from dual;
458:
459: insert into ff_route_context_usages
460: (
461: route_id,

Line 468: from dual;

464: )
465: select ff_routes_s.currval,
466: l_source_text_context_id,
467: 2
468: from dual;
469:
470: end;
471:
472: -------------------------------------------------------------------------

Line 540: from dual;

536: ff_routes_s.currval,
537: 'N',
538: 'User Entity ID',
539: 1
540: from dual;
541:
542: -- Define the route context usage
543: insert into ff_route_context_usages
544: (

Line 552: from dual;

548: )
549: select ff_routes_s.currval,
550: l_assignment_action_context_id,
551: 1
552: from dual;
553:
554: insert into ff_route_context_usages
555: (
556: route_id,

Line 563: from dual;

559: )
560: select ff_routes_s.currval,
561: l_source_text_context_id,
562: 2
563: from dual;
564:
565: end;
566:
567: -------------------------------------------------------------------------

Line 635: from dual;

631: ff_routes_s.currval,
632: 'N',
633: 'User Entity ID',
634: 1
635: from dual;
636:
637: -- Define the route context usage
638: insert into ff_route_context_usages
639: (

Line 647: from dual;

643: )
644: select ff_routes_s.currval,
645: l_assignment_action_context_id,
646: 1
647: from dual;
648:
649: insert into ff_route_context_usages
650: (
651: route_id,

Line 658: from dual;

654: )
655: select ff_routes_s.currval,
656: l_source_number_context_id,
657: 2
658: from dual;
659:
660: end;
661:
662: --End Added for balance feed Enhancement and Context balance functionality

Line 945: from dual;

941:
942: -- Create the archive database item
943: select ff_user_entities_s.nextval
944: into l_user_entity_seq
945: from dual;
946:
947: insert into ff_user_entities
948: (
949: user_entity_id,