DBA Data[Home] [Help]

APPS.PON_WITH_DRAW_PKG dependencies on WF_ENGINE

Line 126: wf_engine.CreateProcess(itemtype => l_itemtype,

122: END IF;
123: IF L_NOTIF_SUBSCR_FLAG='Y'
124: THEN
125:
126: wf_engine.CreateProcess(itemtype => l_itemtype,
127: itemkey => l_itemkey,
128: process => l_process);
129:
130: L_STEP:=2;

Line 161: wf_engine.SetItemAttrText (itemtype => l_itemtype,

157:
158: IF L_DOCUMENT_TYPE_CODE IN ('SOLICITATION')
159: THEN
160:
161: wf_engine.SetItemAttrText (itemtype => l_itemtype,
162: itemkey => l_itemkey,
163: aname => 'DOCUMENT_TYPE',
164: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUC_NEG_X'));
165:

Line 166: wf_engine.SetItemAttrText (itemtype => l_itemtype,

162: itemkey => l_itemkey,
163: aname => 'DOCUMENT_TYPE',
164: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUC_NEG_X'));
165:
166: wf_engine.SetItemAttrText (itemtype => l_itemtype,
167: itemkey => l_itemkey,
168: aname => 'RESPONSE_TYPE',
169: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_X')||' '||L_BID_NUMBER);
170:

Line 171: wf_engine.SetItemAttrText (itemtype => l_itemtype,

167: itemkey => l_itemkey,
168: aname => 'RESPONSE_TYPE',
169: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_X')||' '||L_BID_NUMBER);
170:
171: wf_engine.SetItemAttrText (itemtype => l_itemtype,
172: itemkey => l_itemkey,
173: aname => 'RESPONSE',
174: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_X'));
175:

Line 179: wf_engine.SetItemAttrText (itemtype => l_itemtype,

175:
176:
177: ELSE
178:
179: wf_engine.SetItemAttrText (itemtype => l_itemtype,
180: itemkey => l_itemkey,
181: aname => 'DOCUMENT_TYPE',
182: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUC_NEG'));
183:

Line 184: wf_engine.SetItemAttrText (itemtype => l_itemtype,

180: itemkey => l_itemkey,
181: aname => 'DOCUMENT_TYPE',
182: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUC_NEG'));
183:
184: wf_engine.SetItemAttrText (itemtype => l_itemtype,
185: itemkey => l_itemkey,
186: aname => 'RESPONSE_TYPE',
187: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_R')||' '||L_BID_NUMBER);
188:

Line 189: wf_engine.SetItemAttrText (itemtype => l_itemtype,

185: itemkey => l_itemkey,
186: aname => 'RESPONSE_TYPE',
187: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_R')||' '||L_BID_NUMBER);
188:
189: wf_engine.SetItemAttrText (itemtype => l_itemtype,
190: itemkey => l_itemkey,
191: aname => 'RESPONSE',
192: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_R'));
193:

Line 196: wf_engine.SetItemAttrText (itemtype => l_itemtype,

192: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_R'));
193:
194: END IF;
195:
196: wf_engine.SetItemAttrText (itemtype => l_itemtype,
197: itemkey => l_itemkey,
198: aname => 'SOURCE_DOC_TYPE',
199: avalue => L_DOCUMENT_TYPE||' '||L_DOCUMENT_NUMBER);
200:

Line 202: wf_engine.SetItemAttrText (itemtype => l_itemtype,

198: aname => 'SOURCE_DOC_TYPE',
199: avalue => L_DOCUMENT_TYPE||' '||L_DOCUMENT_NUMBER);
200:
201:
202: wf_engine.SetItemAttrText (itemtype => l_itemtype,
203: itemkey => l_itemkey,
204: aname => 'RECEIVER',
205: avalue => L_TRADING_PARTNER_CONTACT_NAME);
206:

Line 215: wf_engine.SetItemAttrText (itemtype => l_itemtype,

211: PARTY_ID=L_TRADING_PARTNER_ID;
212:
213: L_STEP:=6;
214:
215: wf_engine.SetItemAttrText (itemtype => l_itemtype,
216: itemkey => l_itemkey,
217: aname => 'PREPARER_TP_NAME',
218: avalue => L_PREPARER_TP_NAME);
219:

Line 220: wf_engine.SetItemAttrText (itemtype => l_itemtype,

216: itemkey => l_itemkey,
217: aname => 'PREPARER_TP_NAME',
218: avalue => L_PREPARER_TP_NAME);
219:
220: wf_engine.SetItemAttrText (itemtype => l_itemtype,
221: itemkey => l_itemkey,
222: aname => 'DOC_NUMBER',
223: avalue => L_DOCUMENT_NUMBER);
224:

Line 225: wf_engine.SetItemAttrText (itemtype => l_itemtype,

221: itemkey => l_itemkey,
222: aname => 'DOC_NUMBER',
223: avalue => L_DOCUMENT_NUMBER);
224:
225: wf_engine.SetItemAttrText (itemtype => l_itemtype,
226: itemkey => l_itemkey,
227: aname => 'AUCTION_TITLE',
228: avalue => L_AUCTION_TITLE);
229:

Line 230: wf_engine.SetItemAttrText (itemtype => l_itemtype,

226: itemkey => l_itemkey,
227: aname => 'AUCTION_TITLE',
228: avalue => L_AUCTION_TITLE);
229:
230: wf_engine.SetItemAttrText (itemtype => l_itemtype,
231: itemkey => l_itemkey,
232: aname => 'SUB_AUCTION_TITLE',
233: avalue => L_AUCTION_TITLE);
234:

Line 235: wf_engine.SetItemAttrText (itemtype => l_itemtype,

231: itemkey => l_itemkey,
232: aname => 'SUB_AUCTION_TITLE',
233: avalue => L_AUCTION_TITLE);
234:
235: wf_engine.SetItemAttrText (itemtype => l_itemtype,
236: itemkey => l_itemkey,
237: aname => 'ORIGIN_USER_NAME',
238: avalue => L_FROM_USER);
239:

Line 241: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

237: aname => 'ORIGIN_USER_NAME',
238: avalue => L_FROM_USER);
239:
240: /* Response URL Bug Chnages */
241: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
242: itemkey => l_itemkey,
243: aname => 'BID_ID',
244: avalue => L_BID_NUMBER);
245:

Line 246: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

242: itemkey => l_itemkey,
243: aname => 'BID_ID',
244: avalue => L_BID_NUMBER);
245:
246: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
247: itemkey => l_itemkey,
248: aname => 'AUCTION_ID',
249: avalue => L_AUCTION_HEADER_ID);
250:

Line 254: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

250:
251: /* Preview Date,Open Date,Close Date,Withdrawn Date */
252:
253: IF L_PREVIEW_DATE IS NULL THEN
254: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
255: itemkey => l_itemkey,
256: aname => 'NEG_PREVIEW_DATE',
257: avalue => NULL);
258: ELSE

Line 259: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

255: itemkey => l_itemkey,
256: aname => 'NEG_PREVIEW_DATE',
257: avalue => NULL);
258: ELSE
259: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
260: itemkey => l_itemkey,
261: aname => 'NEG_PREVIEW_DATE',
262: avalue => L_PREVIEW_DATE);
263: END IF;

Line 267: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

263: END IF;
264:
265:
266: IF L_START_DATE IS NULL THEN
267: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
268: itemkey => l_itemkey,
269: aname => 'NEG_OPEN_DATE',
270: avalue => NULL);
271: ELSE

Line 272: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

268: itemkey => l_itemkey,
269: aname => 'NEG_OPEN_DATE',
270: avalue => NULL);
271: ELSE
272: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
273: itemkey => l_itemkey,
274: aname => 'NEG_OPEN_DATE',
275: avalue => L_START_DATE);
276: END IF;

Line 280: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

276: END IF;
277:
278: IF L_END_DATE IS NULL THEN
279:
280: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
281: itemkey => l_itemkey,
282: aname => 'NEG_CLOSE_DATE',
283: avalue => NULL);
284: ELSE

Line 286: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

282: aname => 'NEG_CLOSE_DATE',
283: avalue => NULL);
284: ELSE
285:
286: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
287: itemkey => l_itemkey,
288: aname => 'NEG_CLOSE_DATE',
289: avalue => L_END_DATE);
290: END IF;

Line 292: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

288: aname => 'NEG_CLOSE_DATE',
289: avalue => L_END_DATE);
290: END IF;
291:
292: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
293: itemkey => l_itemkey,
294: aname => 'NEG_WITH_DRAWN_DATE',
295: avalue => SYSDATE);
296:

Line 310: wf_engine.SetItemAttrText (itemtype => l_itemtype,

306: PBH.BID_NUMBER=L_BID_NUMBER;
307:
308: L_STEP:=7;
309:
310: wf_engine.SetItemAttrText (itemtype => l_itemtype,
311: itemkey => l_itemkey,
312: aname => 'SUPPLIER',
313: avalue => L_SUPPLIER);
314:

Line 327: wf_engine.SetItemAttrText (itemtype => l_itemtype,

323: END IF;
324:
325: L_STEP:=8;
326:
327: wf_engine.SetItemAttrText (itemtype => l_itemtype,
328: itemkey => l_itemkey,
329: aname => 'SUPPLIER_SITE',
330: avalue => L_SUPPLIER_SITE_NAME);
331:

Line 332: wf_engine.SetItemAttrText (itemtype => l_itemtype,

328: itemkey => l_itemkey,
329: aname => 'SUPPLIER_SITE',
330: avalue => L_SUPPLIER_SITE_NAME);
331:
332: wf_engine.SetItemAttrText (itemtype => l_itemtype,
333: itemkey => l_itemkey,
334: aname => 'WITHDRAW_REASON',
335: avalue => L_WITHDRAW_REASON);
336:

Line 357: wf_engine.SetItemAttrText (itemtype => l_itemtype,

353: IF(x_notification_id IS NOT null) THEN
354: x_view_quote_url:=REPLACE(x_view_quote_url,'&#NID',x_notification_id);
355: END IF;
356:
357: wf_engine.SetItemAttrText (itemtype => l_itemtype,
358: itemkey => l_itemkey,
359: aname => 'URL',
360: avalue => x_view_quote_url);
361:

Line 363: wf_engine.StartProcess(itemtype => l_itemtype,

359: aname => 'URL',
360: avalue => x_view_quote_url);
361:
362:
363: wf_engine.StartProcess(itemtype => l_itemtype,
364: itemkey => l_itemkey );
365:
366: END IF;
367:

Line 532: wf_engine.CreateProcess(itemtype => l_itemtype,

528: END IF;
529: IF L_NOTIF_SUBSCR_FLAG='Y'
530: THEN
531:
532: wf_engine.CreateProcess(itemtype => l_itemtype,
533: itemkey => l_itemkey,
534: process => l_process);
535:
536: SELECT PAH.TRADING_PARTNER_CONTACT_NAME,PAH.DOCUMENT_NUMBER,PAH.AUCTION_TITLE,PAH.TRADING_PARTNER_ID,

Line 560: wf_engine.SetItemAttrText (itemtype => l_itemtype,

556:
557: IF L_DOCUMENT_TYPE_CODE IN ('SOLICITATION')
558: THEN
559:
560: wf_engine.SetItemAttrText (itemtype => l_itemtype,
561: itemkey => l_itemkey,
562: aname => 'DOCUMENT_TYPE',
563: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUC_NEG_X'));
564:

Line 565: wf_engine.SetItemAttrText (itemtype => l_itemtype,

561: itemkey => l_itemkey,
562: aname => 'DOCUMENT_TYPE',
563: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUC_NEG_X'));
564:
565: wf_engine.SetItemAttrText (itemtype => l_itemtype,
566: itemkey => l_itemkey,
567: aname => 'RESPONSE_TYPE',
568: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_X')||' '||L_BID_NUMBER);
569:

Line 570: wf_engine.SetItemAttrText (itemtype => l_itemtype,

566: itemkey => l_itemkey,
567: aname => 'RESPONSE_TYPE',
568: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_X')||' '||L_BID_NUMBER);
569:
570: wf_engine.SetItemAttrText (itemtype => l_itemtype,
571: itemkey => l_itemkey,
572: aname => 'RESPONSE',
573: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_X'));
574:

Line 578: wf_engine.SetItemAttrText (itemtype => l_itemtype,

574:
575:
576: ELSE
577:
578: wf_engine.SetItemAttrText (itemtype => l_itemtype,
579: itemkey => l_itemkey,
580: aname => 'DOCUMENT_TYPE',
581: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUC_NEG'));
582:

Line 583: wf_engine.SetItemAttrText (itemtype => l_itemtype,

579: itemkey => l_itemkey,
580: aname => 'DOCUMENT_TYPE',
581: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUC_NEG'));
582:
583: wf_engine.SetItemAttrText (itemtype => l_itemtype,
584: itemkey => l_itemkey,
585: aname => 'RESPONSE_TYPE',
586: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_R')||' '||L_BID_NUMBER);
587:

Line 588: wf_engine.SetItemAttrText (itemtype => l_itemtype,

584: itemkey => l_itemkey,
585: aname => 'RESPONSE_TYPE',
586: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_R')||' '||L_BID_NUMBER);
587:
588: wf_engine.SetItemAttrText (itemtype => l_itemtype,
589: itemkey => l_itemkey,
590: aname => 'RESPONSE',
591: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_R'));
592:

Line 595: wf_engine.SetItemAttrText (itemtype => l_itemtype,

591: avalue => FND_MESSAGE.GET_STRING('PON','PON_AUCTS_BID_R'));
592:
593: END IF;
594:
595: wf_engine.SetItemAttrText (itemtype => l_itemtype,
596: itemkey => l_itemkey,
597: aname => 'SOURCE_DOC_TYPE',
598: avalue => L_DOCUMENT_TYPE||' '||L_DOCUMENT_NUMBER);
599:

Line 601: wf_engine.SetItemAttrText (itemtype => l_itemtype,

597: aname => 'SOURCE_DOC_TYPE',
598: avalue => L_DOCUMENT_TYPE||' '||L_DOCUMENT_NUMBER);
599:
600:
601: wf_engine.SetItemAttrText (itemtype => l_itemtype,
602: itemkey => l_itemkey,
603: aname => 'RECEIVER',
604: avalue => L_TRADING_PARTNER_CONTACT_NAME);
605:

Line 612: wf_engine.SetItemAttrText (itemtype => l_itemtype,

608: HZ_PARTIES HZ
609: WHERE
610: PARTY_ID=L_TRADING_PARTNER_ID;
611:
612: wf_engine.SetItemAttrText (itemtype => l_itemtype,
613: itemkey => l_itemkey,
614: aname => 'PREPARER_TP_NAME',
615: avalue => L_PREPARER_TP_NAME);
616:

Line 617: wf_engine.SetItemAttrText (itemtype => l_itemtype,

613: itemkey => l_itemkey,
614: aname => 'PREPARER_TP_NAME',
615: avalue => L_PREPARER_TP_NAME);
616:
617: wf_engine.SetItemAttrText (itemtype => l_itemtype,
618: itemkey => l_itemkey,
619: aname => 'DOC_NUMBER',
620: avalue => L_DOCUMENT_NUMBER);
621:

Line 622: wf_engine.SetItemAttrText (itemtype => l_itemtype,

618: itemkey => l_itemkey,
619: aname => 'DOC_NUMBER',
620: avalue => L_DOCUMENT_NUMBER);
621:
622: wf_engine.SetItemAttrText (itemtype => l_itemtype,
623: itemkey => l_itemkey,
624: aname => 'AUCTION_TITLE',
625: avalue => L_AUCTION_TITLE);
626:

Line 627: wf_engine.SetItemAttrText (itemtype => l_itemtype,

623: itemkey => l_itemkey,
624: aname => 'AUCTION_TITLE',
625: avalue => L_AUCTION_TITLE);
626:
627: wf_engine.SetItemAttrText (itemtype => l_itemtype,
628: itemkey => l_itemkey,
629: aname => 'SUB_AUCTION_TITLE',
630: avalue => L_AUCTION_TITLE);
631:

Line 632: wf_engine.SetItemAttrText (itemtype => l_itemtype,

628: itemkey => l_itemkey,
629: aname => 'SUB_AUCTION_TITLE',
630: avalue => L_AUCTION_TITLE);
631:
632: wf_engine.SetItemAttrText (itemtype => l_itemtype,
633: itemkey => l_itemkey,
634: aname => 'ORIGIN_USER_NAME',
635: avalue => L_FROM_USER);
636:

Line 638: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

634: aname => 'ORIGIN_USER_NAME',
635: avalue => L_FROM_USER);
636:
637: /* Response URL Bug Chnages */
638: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
639: itemkey => l_itemkey,
640: aname => 'BID_ID',
641: avalue => L_BID_NUMBER);
642:

Line 643: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

639: itemkey => l_itemkey,
640: aname => 'BID_ID',
641: avalue => L_BID_NUMBER);
642:
643: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
644: itemkey => l_itemkey,
645: aname => 'AUCTION_ID',
646: avalue => L_AUCTION_HEADER_ID);
647:

Line 652: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

648:
649: /* Preview Date,Open Date,Close Date,Withdrawn Date */
650:
651: IF L_PREVIEW_DATE IS NULL THEN
652: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
653: itemkey => l_itemkey,
654: aname => 'NEG_PREVIEW_DATE',
655: avalue => NULL);
656: ELSE

Line 657: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

653: itemkey => l_itemkey,
654: aname => 'NEG_PREVIEW_DATE',
655: avalue => NULL);
656: ELSE
657: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
658: itemkey => l_itemkey,
659: aname => 'NEG_PREVIEW_DATE',
660: avalue => L_PREVIEW_DATE);
661: END IF;

Line 665: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

661: END IF;
662:
663:
664: IF L_START_DATE IS NULL THEN
665: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
666: itemkey => l_itemkey,
667: aname => 'NEG_OPEN_DATE',
668: avalue => NULL);
669: ELSE

Line 670: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

666: itemkey => l_itemkey,
667: aname => 'NEG_OPEN_DATE',
668: avalue => NULL);
669: ELSE
670: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
671: itemkey => l_itemkey,
672: aname => 'NEG_OPEN_DATE',
673: avalue => L_START_DATE);
674: END IF;

Line 678: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

674: END IF;
675:
676: IF L_END_DATE IS NULL THEN
677:
678: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
679: itemkey => l_itemkey,
680: aname => 'NEG_CLOSE_DATE',
681: avalue => NULL);
682: ELSE

Line 684: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

680: aname => 'NEG_CLOSE_DATE',
681: avalue => NULL);
682: ELSE
683:
684: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
685: itemkey => l_itemkey,
686: aname => 'NEG_CLOSE_DATE',
687: avalue => L_END_DATE);
688: END IF;

Line 690: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

686: aname => 'NEG_CLOSE_DATE',
687: avalue => L_END_DATE);
688: END IF;
689:
690: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
691: itemkey => l_itemkey,
692: aname => 'NEG_WITH_DRAWN_DATE',
693: avalue => SYSDATE);
694:

Line 706: wf_engine.SetItemAttrText (itemtype => l_itemtype,

702: PBH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID
703: AND
704: PBH.BID_NUMBER=L_BID_NUMBER;
705:
706: wf_engine.SetItemAttrText (itemtype => l_itemtype,
707: itemkey => l_itemkey,
708: aname => 'SUPPLIER',
709: avalue => L_SUPPLIER);
710:

Line 722: wf_engine.SetItemAttrText (itemtype => l_itemtype,

718: APS.VENDOR_SITE_ID=L_SUPPLIER_SITE_ID;
719:
720: END IF;
721:
722: wf_engine.SetItemAttrText (itemtype => l_itemtype,
723: itemkey => l_itemkey,
724: aname => 'SUPPLIER_SITE',
725: avalue => L_SUPPLIER_SITE_NAME);
726:

Line 727: wf_engine.SetItemAttrText (itemtype => l_itemtype,

723: itemkey => l_itemkey,
724: aname => 'SUPPLIER_SITE',
725: avalue => L_SUPPLIER_SITE_NAME);
726:
727: wf_engine.SetItemAttrText (itemtype => l_itemtype,
728: itemkey => l_itemkey,
729: aname => 'WITHDRAW_REASON',
730: avalue => L_WITHDRAW_REASON);
731:

Line 750: wf_engine.SetItemAttrText (itemtype => l_itemtype,

746: IF(x_notification_id IS NOT null) THEN
747: x_view_quote_url:=REPLACE(x_view_quote_url,'&#NID',x_notification_id);
748: END IF;
749:
750: wf_engine.SetItemAttrText (itemtype => l_itemtype,
751: itemkey => l_itemkey,
752: aname => 'URL',
753: avalue => x_view_quote_url);
754:

Line 756: wf_engine.StartProcess(itemtype => l_itemtype,

752: aname => 'URL',
753: avalue => x_view_quote_url);
754:
755:
756: wf_engine.StartProcess(itemtype => l_itemtype,
757: itemkey => l_itemkey );
758:
759: END IF;
760: