APPS.POS_ASN_NOTIF dependencies on WF_ENGINE

Line 30: wf_engine.createProcess( ItemType => l_item_type,

26: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;
27: l_item_key := 'POSASNNB_' || p_shipment_num || '_' || to_char(l_seq_val);
28:
29: if (p_notif_type = 'CANCEL') then
30: wf_engine.createProcess( ItemType => l_item_type,
31: ItemKey => l_item_key,
32: Process => 'BUYER_NOTIF_CANCEL'
33: );
34: else

Line 35: wf_engine.createProcess( ItemType => l_item_type,

31: ItemKey => l_item_key,
32: Process => 'BUYER_NOTIF_CANCEL'
33: );
34: else
35: wf_engine.createProcess( ItemType => l_item_type,
36: ItemKey => l_item_key,
37: Process => 'BUYER_NOTIFICATION'
38: );
39: end if;

Line 47: wf_engine.SetItemAttrText

43: p_user_id,
44: l_supp_username,
45: l_supplier_displayname);
46:
47: wf_engine.SetItemAttrText
48: (
49: ItemType => l_item_type,
50: ItemKey => l_item_key,
51: aname => 'SHIPMENT_NUM',

Line 55: wf_engine.SetItemAttrText

51: aname => 'SHIPMENT_NUM',
52: avalue => p_shipment_num
53: );
54:
55: wf_engine.SetItemAttrText
56: (
57: ItemType => l_item_type,
58: ItemKey => l_item_key,
59: aname => 'SUPPLIER_USERNAME',

Line 63: wf_engine.SetItemAttrNumber

59: aname => 'SUPPLIER_USERNAME',
60: avalue => l_supp_username
61: );
62:
63: wf_engine.SetItemAttrNumber
64: (
65: ItemType => l_item_type,
66: ItemKey => l_item_key,
67: aname => 'VENDOR_ID',

Line 71: wf_engine.SetItemAttrNumber

67: aname => 'VENDOR_ID',
68: avalue => p_vendor_id
69: );
70:
71: wf_engine.SetItemAttrNumber
72: (
73: ItemType => l_item_type,
74: ItemKey => l_item_key,
75: aname => 'VENDOR_SITE_ID',

Line 79: wf_engine.StartProcess( ItemType => l_item_type,

75: aname => 'VENDOR_SITE_ID',
76: avalue => p_vendor_site_id
77: );
78: --dbms_output.put_line('Item Key ' || l_item_key );
79: wf_engine.StartProcess( ItemType => l_item_type,
80: ItemKey => l_item_key );
81:
82:
83: END GENERATE_NOTIF;

Line 111: wf_engine.createProcess

107: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;
108: l_item_key := 'WCAPPRV_' || p_wc_num || '_' || to_char(l_seq_val);
109:
110:
111: wf_engine.createProcess
112: (
113: ItemType => l_item_type,
114: ItemKey => l_item_key,
115: Process => 'BUYER_NOTIF_WC_CANCEL'

Line 132: wf_engine.SetItemAttrText(

128: l_buyer_user_displayname);
129:
130:
131:
132: wf_engine.SetItemAttrText(
133: ItemType => l_item_type,
134: ItemKey => l_item_key,
135: aname => 'BUYER_NAME',
136: avalue => l_buyer_user_name

Line 140: wf_engine.SetItemAttrText

136: avalue => l_buyer_user_name
137: );
138:
139:
140: wf_engine.SetItemAttrText
141: (
142: ItemType => l_item_type,
143: ItemKey => l_item_key,
144: aname => 'WORK_CONFIRMATION_ID',

Line 148: wf_engine.SetItemAttrText

144: aname => 'WORK_CONFIRMATION_ID',
145: avalue => p_wc_id
146: );
147:
148: wf_engine.SetItemAttrText
149: (
150: ItemType => l_item_type,
151: ItemKey => l_item_key,
152: aname => 'WORK_CONFIRMATION_NUMBER',

Line 157: wf_engine.SetItemAttrText

153: avalue => p_wc_num
154: );
155:
156:
157: wf_engine.SetItemAttrText
158: (
159: ItemType => l_item_type,
160: ItemKey => l_item_key,
161: aname => 'DOC_STATUS',

Line 165: wf_engine.SetItemAttrText

161: aname => 'DOC_STATUS',
162: avalue => p_wc_status
163: );
164:
165: wf_engine.SetItemAttrText
166: (
167: ItemType => l_item_type,
168: ItemKey => l_item_key,
169: aname => 'PO_DOCUMENT_ID',

Line 173: wf_engine.SetItemAttrText

169: aname => 'PO_DOCUMENT_ID',
170: avalue => p_po_header_id
171: );
172:
173: wf_engine.SetItemAttrText
174: (
175: ItemType => l_item_type,
176: ItemKey => l_item_key,
177: aname => 'SUPPLIER_USERNAME',

Line 181: wf_engine.StartProcess( ItemType => l_item_type,

177: aname => 'SUPPLIER_USERNAME',
178: avalue => l_supp_username
179: );
180:
181: wf_engine.StartProcess( ItemType => l_item_type,
182: ItemKey => l_item_key );
183:
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:

Line 223: x_total_num_buyers := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

219: l_client_tz NUMBER;
220:
221: BEGIN
222: --dbms_output.put_line('Calling Set Next Buyer');
223: x_total_num_buyers := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
224: itemkey => l_item_key,
225: aname => 'TOTAL_BUYER_NUM');
226:
227: x_curr_buyer := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 227: x_curr_buyer := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

223: x_total_num_buyers := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
224: itemkey => l_item_key,
225: aname => 'TOTAL_BUYER_NUM');
226:
227: x_curr_buyer := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
228: itemkey => l_item_key,
229: aname => 'CURR_BUYER_NUM');
230:
231: x_shipment_num := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 231: x_shipment_num := wf_engine.GetItemAttrText ( itemtype => l_item_type,

227: x_curr_buyer := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
228: itemkey => l_item_key,
229: aname => 'CURR_BUYER_NUM');
230:
231: x_shipment_num := wf_engine.GetItemAttrText ( itemtype => l_item_type,
232: itemkey => l_item_key,
233: aname => 'SHIPMENT_NUM');
234:
235: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 235: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

231: x_shipment_num := wf_engine.GetItemAttrText ( itemtype => l_item_type,
232: itemkey => l_item_key,
233: aname => 'SHIPMENT_NUM');
234:
235: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
236: itemkey => l_item_key,
237: aname => 'VENDOR_ID');
238:
239: x_vendor_site_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 239: x_vendor_site_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

235: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
236: itemkey => l_item_key,
237: aname => 'VENDOR_ID');
238:
239: x_vendor_site_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
240: itemkey => l_item_key,
241: aname => 'VENDOR_SITE_ID');
242:
243: /* code added for bug 10408761

Line 269: wf_engine.SetItemAttrText(ItemType => l_item_type,

265: END;
266:
267: h_expected_receipt_date_print := to_char(h_expected_receipt_date_ts,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
268:
269: wf_engine.SetItemAttrText(ItemType => l_item_type,
270: ItemKey => l_item_key,
271: aname => 'EXPECTED_RECEIPT_TS',
272: avalue => h_expected_receipt_date_print
273: );

Line 287: wf_engine.SetItemAttrText

283: asn_buyers(x_curr_buyer),
284: x_buyer_user_name,
285: x_buyer_user_displayname);
286:
287: wf_engine.SetItemAttrText
288: (
289: ItemType => l_item_type,
290: ItemKey => l_item_key,
291: aname => 'ASN_BUYER',

Line 324: wf_engine.SetItemAttrText(

320:
321: h_expected_receipt_date_ts := HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz, l_client_tz, h_expected_receipt_date_ts);
322: h_expected_receipt_date_print := to_char(h_expected_receipt_date_ts,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
323:
324: wf_engine.SetItemAttrText(
325: ItemType => l_item_type,
326: ItemKey => l_item_key,
327: aname => 'EXPECTED_RECEIPT_TS',
328: avalue => h_expected_receipt_date_print

Line 339: wf_engine.SetItemAttrText (

335: END if;
336:
337: /* end of code added for conversion of expected_receipt_date time stamp */
338:
339: wf_engine.SetItemAttrText (
340: itemtype => l_item_type,
341: itemkey => l_item_key,
342: aname => 'ASN_INFO',
343: avalue => 'PLSQLCLOB:POS_ASN_NOTIF.GENERATE_ASN_BODY/'

Line 351: wf_engine.SetItemAttrNumber

347:
348: -- dbms_output.put_line('Buyer Name is ' || x_buyer_user_name );
349: x_curr_buyer := x_curr_buyer + 1;
350:
351: wf_engine.SetItemAttrNumber
352: (
353: ItemType => l_item_type,
354: ItemKey => l_item_key,
355: aname => 'CURR_BUYER_NUM',

Line 453: x_shipment_num := wf_engine.GetItemAttrText ( itemtype => l_item_type,

449:
450: asn_buyers := asn_buyers_empty;
451: --asn_buyer_num := 0;
452:
453: x_shipment_num := wf_engine.GetItemAttrText ( itemtype => l_item_type,
454: itemkey => l_item_key,
455: aname => 'SHIPMENT_NUM');
456:
457: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 457: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

453: x_shipment_num := wf_engine.GetItemAttrText ( itemtype => l_item_type,
454: itemkey => l_item_key,
455: aname => 'SHIPMENT_NUM');
456:
457: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
458: itemkey => l_item_key,
459: aname => 'VENDOR_ID');
460:
461: x_vendor_site_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 461: x_vendor_site_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

457: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
458: itemkey => l_item_key,
459: aname => 'VENDOR_ID');
460:
461: x_vendor_site_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
462: itemkey => l_item_key,
463: aname => 'VENDOR_SITE_ID');
464:
465: --dbms_output.put_line('Shipment Num is ' || x_shipment_num);

Line 557: wf_engine.SetItemAttrText

553: EXCEPTION
554: WHEN NO_DATA_FOUND then
555: l_document1:= 'ASN has been cancelled';
556: -- fnd_message.get_string('POS','POS_ASN_CANCELLED');
557: wf_engine.SetItemAttrText
558: (
559: ItemType => l_item_type,
560: ItemKey => l_item_key,
561: aname => 'ASN_HEADERS',

Line 570: wf_engine.SetItemAttrText

566: asn_buyers(1),
567: x_buyer_user_name,
568: x_buyer_user_displayname);
569:
570: wf_engine.SetItemAttrText
571: (
572: ItemType => l_item_type,
573: ItemKey => l_item_key,
574: aname => 'ASN_BUYER',

Line 584: wf_engine.SetItemAttrText

580: END;
581:
582: --dbms_output.put_line('Asn Type is ' || x_asn_type);
583: --dbms_output.put_line('Vendor Name is ' || x_vendor_name);
584: wf_engine.SetItemAttrText
585: (
586: ItemType => l_item_type,
587: ItemKey => l_item_key,
588: aname => 'SUPPLIER',

Line 592: wf_engine.SetItemAttrText

588: aname => 'SUPPLIER',
589: avalue => x_vendor_name
590: );
591:
592: wf_engine.SetItemAttrText
593: (
594: ItemType => l_item_type,
595: ItemKey => l_item_key,
596: aname => 'EXPECTED_RECEIPT_TS',

Line 600: wf_engine.SetItemAttrDate

596: aname => 'EXPECTED_RECEIPT_TS',
597: avalue => x_expected_receipt_ts
598: );
599:
600: wf_engine.SetItemAttrDate
601: (
602: ItemType => l_item_type,
603: ItemKey => l_item_key,
604: aname => 'EXPECTED_RECEIPT_DATE',

Line 608: wf_engine.SetItemAttrText

604: aname => 'EXPECTED_RECEIPT_DATE',
605: avalue => x_expected_receipt_date
606: );
607:
608: wf_engine.SetItemAttrText
609: (
610: ItemType => l_item_type,
611: ItemKey => l_item_key,
612: aname => 'ASN_TYPE',

Line 657: wf_engine.SetItemAttrText

653:
654:
655: IF (x_asn_type = 'ASBN') THEN
656:
657: wf_engine.SetItemAttrText
658: (
659: ItemType => l_item_type,
660: ItemKey => l_item_key,
661: aname => 'INVOICE_INFO',

Line 665: wf_engine.SetItemAttrText

661: aname => 'INVOICE_INFO',
662: avalue => 'and Invoice'
663: );
664:
665: wf_engine.SetItemAttrText
666: (
667: ItemType => l_item_type,
668: ItemKey => l_item_key,
669: aname => 'INVOICE_NUM',

Line 730: wf_engine.SetItemAttrText

726: l_document1 := l_document1 || '

Line 738: wf_engine.SetItemAttrText

734: aname => 'INVOICE_INFO',
735: avalue => ''
736: );
737:
738: wf_engine.SetItemAttrText
739: (
740: ItemType => l_item_type,
741: ItemKey => l_item_key,
742: aname => 'INVOICE_NUM',

Line 750: wf_engine.SetItemAttrText

746: END IF;
747:
748: -- This Attribute is not being set to l_document any more , moved to the body section as pl/sql clob
749:
750: wf_engine.SetItemAttrText
751: (
752: ItemType => l_item_type,
753: ItemKey => l_item_key,
754: aname => 'ASN_HEADERS',

Line 759: wf_engine.SetItemAttrNumber

755: avalue => ''
756: );
757:
758: -- Set the Buyer Count and Current Number in the Workflow
759: wf_engine.SetItemAttrNumber
760: (
761: ItemType => l_item_type,
762: ItemKey => l_item_key,
763: aname => 'TOTAL_BUYER_NUM',

Line 766: wf_engine.SetItemAttrNumber

762: ItemKey => l_item_key,
763: aname => 'TOTAL_BUYER_NUM',
764: avalue => asn_buyers.COUNT
765: );
766: wf_engine.SetItemAttrNumber
767: (
768: ItemType => l_item_type,
769: ItemKey => l_item_key,
770: aname => 'CURR_BUYER_NUM',