APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG dependencies on FF_ROUTE_PARAMETERS

Line 89: insert into ff_route_parameters

85: sysdate
86: );
87:
88: -- Define the route parameter
89: insert into ff_route_parameters
90: (
91: route_parameter_id,
92: route_id,
93: data_type,

Line 97: select ff_route_parameters_s.nextval,

93: data_type,
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

Line 167: insert into ff_route_parameters

163: sysdate
164: );
165:
166: -- Define the route parameter
167: insert into ff_route_parameters
168: (
169: route_parameter_id,
170: route_id,
171: data_type,

Line 175: select ff_route_parameters_s.nextval,

171: data_type,
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

Line 245: insert into ff_route_parameters

241: sysdate
242: );
243:
244: -- Define the route parameter
245: insert into ff_route_parameters
246: (
247: route_parameter_id,
248: route_id,
249: data_type,

Line 253: select ff_route_parameters_s.nextval,

249: data_type,
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

Line 329: insert into ff_route_parameters

325: sysdate
326: );
327:
328: -- Define the route parameter
329: insert into ff_route_parameters
330: (
331: route_parameter_id,
332: route_id,
333: data_type,

Line 337: select ff_route_parameters_s.nextval,

333: data_type,
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

Line 432: insert into ff_route_parameters

428: sysdate
429: );
430:
431: -- Define the route parameter
432: insert into ff_route_parameters
433: (
434: route_parameter_id,
435: route_id,
436: data_type,

Line 440: select ff_route_parameters_s.nextval,

436: data_type,
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

Line 527: insert into ff_route_parameters

523: sysdate
524: );
525:
526: -- Define the route parameter
527: insert into ff_route_parameters
528: (
529: route_parameter_id,
530: route_id,
531: data_type,

Line 535: select ff_route_parameters_s.nextval,

531: data_type,
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

Line 622: insert into ff_route_parameters

618: sysdate
619: );
620:
621: -- Define the route parameter
622: insert into ff_route_parameters
623: (
624: route_parameter_id,
625: route_id,
626: data_type,

Line 630: select ff_route_parameters_s.nextval,

626: data_type,
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

Line 863: from ff_route_parameters

859:
860: -- Find the User Entity Route parameter that goes with the archive route
861: select route_parameter_id
862: into l_route_parameter_id
863: from ff_route_parameters
864: where parameter_name = 'User Entity ID'
865: and route_id = l_route_id;
866:
867: begin