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.OE_ORDER_WF_UTIL dependencies on WF_ENGINE

Line 211: l_header_id := to_number(wf_engine.setctx_itemkey);

207: where notification_id = to_number(document_id);
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: -- if viewing method is email
211: l_header_id := to_number(wf_engine.setctx_itemkey);
212: END;
213:
214: SELECT order_number, order_type_id, order_category_code
215: into l_order_number, l_order_type_id, l_order_category_code

Line 288: l_line_id := to_number(wf_engine.setctx_itemkey);

284: where notification_id = to_number(document_id);
285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN
287: -- if viewing method is email
288: l_line_id := to_number(wf_engine.setctx_itemkey);
289: END;
290: SELECT header_id, line_number, shipment_number, option_number, service_number
291: into l_header_id, l_line_number, l_shipment_number, l_option_number, l_service_number
292: FROM oe_order_lines_all

Line 415: -- This procedure starts the flow, by calling WF_ENGINE utilities.

411: END Set_Line_User_Key;
412:
413:
414:
415: -- This procedure starts the flow, by calling WF_ENGINE utilities.
416: --
417: PROCEDURE Start_Flow
418: ( p_itemtype in varchar2
419: , p_itemkey in varchar2

Line 431: WF_ENGINE.StartProcess(p_itemtype, p_itemkey);

427: IF l_debug_level > 0 THEN
428: oe_debug_pub.add( 'IN START_FLOW' ) ;
429: END IF;
430:
431: WF_ENGINE.StartProcess(p_itemtype, p_itemkey);
432:
433: IF l_debug_level > 0 THEN
434: oe_debug_pub.add( 'EXITING START_FLOW' ) ;
435: END IF;

Line 462: WF_ENGINE.StartForkProcess('OEOL', p_itemkey);

458: IF l_debug_level > 0 THEN
459: oe_debug_pub.add( 'IN START_LINEFORK' ) ;
460: END IF;
461:
462: WF_ENGINE.StartForkProcess('OEOL', p_itemkey);
463:
464: -- Refresh old notifications here if needed.
465: IF l_debug_level > 0 THEN
466: oe_debug_pub.add( 'EXITING START_LINEFORK' ) ;

Line 558: l_aname wf_engine.nametabtyp;

554: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
555: )
556: IS
557: l_hdr_process_name VARCHAR2(30);
558: l_aname wf_engine.nametabtyp;
559: l_aname2 wf_engine.nametabtyp;
560: l_avalue wf_engine.numtabtyp;
561: l_avaluetext wf_engine.texttabtyp;
562:

Line 559: l_aname2 wf_engine.nametabtyp;

555: )
556: IS
557: l_hdr_process_name VARCHAR2(30);
558: l_aname wf_engine.nametabtyp;
559: l_aname2 wf_engine.nametabtyp;
560: l_avalue wf_engine.numtabtyp;
561: l_avaluetext wf_engine.texttabtyp;
562:
563: sales_order VARCHAR2(240);

Line 560: l_avalue wf_engine.numtabtyp;

556: IS
557: l_hdr_process_name VARCHAR2(30);
558: l_aname wf_engine.nametabtyp;
559: l_aname2 wf_engine.nametabtyp;
560: l_avalue wf_engine.numtabtyp;
561: l_avaluetext wf_engine.texttabtyp;
562:
563: sales_order VARCHAR2(240);
564: l_user_name VARCHAR2(100);

Line 561: l_avaluetext wf_engine.texttabtyp;

557: l_hdr_process_name VARCHAR2(30);
558: l_aname wf_engine.nametabtyp;
559: l_aname2 wf_engine.nametabtyp;
560: l_avalue wf_engine.numtabtyp;
561: l_avaluetext wf_engine.texttabtyp;
562:
563: sales_order VARCHAR2(240);
564: l_user_name VARCHAR2(100);
565: l_validate_user NUMBER;

Line 592: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),

588: INTO l_owner_role
589: FROM FND_USER
590: WHERE USER_ID = FND_GLOBAL.USER_ID;
591: -- Create Header Work item
592: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),
593: l_hdr_process_name,
594: sales_order,
595: l_owner_role);
596:

Line 597: WF_ENGINE.additemattr(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),

593: l_hdr_process_name,
594: sales_order,
595: l_owner_role);
596:
597: WF_ENGINE.additemattr(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),
598: '#WAITFORDETAIL',null,0);
599:
600: IF l_debug_level > 0 THEN
601: oe_debug_pub.add( 'AFTER WF_ENGINE.CREATEPROCESS' ) ;

Line 601: oe_debug_pub.add( 'AFTER WF_ENGINE.CREATEPROCESS' ) ;

597: WF_ENGINE.additemattr(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),
598: '#WAITFORDETAIL',null,0);
599:
600: IF l_debug_level > 0 THEN
601: oe_debug_pub.add( 'AFTER WF_ENGINE.CREATEPROCESS' ) ;
602: END IF;
603:
604: -- Set various Header Attributes
605: l_aname(1) := 'USER_ID';

Line 616: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR

612: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
613: l_aname(5) := 'ORDER_NUMBER';
614: l_avalue(5) := p_header_rec.order_number;
615:
616: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR
617: , p_header_rec.header_id
618: , l_aname
619: , l_avalue
620: );

Line 647: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_HDR

643: '/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' ||
644: 'akRegionApplicationId=660' || '&' || 'HeaderId=' || to_char(p_header_rec.header_id);
645:
646:
647: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_HDR
648: , p_header_rec.header_id
649: , l_aname2
650: , l_avaluetext
651: );

Line 788: l_aname wf_engine.nametabtyp;

784: IS
785: l_line_process_name VARCHAR2(30);
786: l_item_type varchar2(30);
787: l_order_number NUMBER;
788: l_aname wf_engine.nametabtyp;
789: l_aname2 wf_engine.nametabtyp;
790: l_avalue wf_engine.numtabtyp;
791: l_avaluetext wf_engine.texttabtyp;
792:

Line 789: l_aname2 wf_engine.nametabtyp;

785: l_line_process_name VARCHAR2(30);
786: l_item_type varchar2(30);
787: l_order_number NUMBER;
788: l_aname wf_engine.nametabtyp;
789: l_aname2 wf_engine.nametabtyp;
790: l_avalue wf_engine.numtabtyp;
791: l_avaluetext wf_engine.texttabtyp;
792:
793: line VARCHAR2(240);

Line 790: l_avalue wf_engine.numtabtyp;

786: l_item_type varchar2(30);
787: l_order_number NUMBER;
788: l_aname wf_engine.nametabtyp;
789: l_aname2 wf_engine.nametabtyp;
790: l_avalue wf_engine.numtabtyp;
791: l_avaluetext wf_engine.texttabtyp;
792:
793: line VARCHAR2(240);
794: l_owner_role VARCHAR2(100);

Line 791: l_avaluetext wf_engine.texttabtyp;

787: l_order_number NUMBER;
788: l_aname wf_engine.nametabtyp;
789: l_aname2 wf_engine.nametabtyp;
790: l_avalue wf_engine.numtabtyp;
791: l_avaluetext wf_engine.texttabtyp;
792:
793: line VARCHAR2(240);
794: l_owner_role VARCHAR2(100);
795: --

Line 820: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN,to_char(p_Line_rec.line_id),

816: FROM FND_USER
817: WHERE USER_ID = FND_GLOBAL.USER_ID;
818:
819: -- Create Line Work item
820: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN,to_char(p_Line_rec.line_id),
821: l_line_process_name,
822: line,
823: l_owner_role);
824:

Line 827: oe_debug_pub.add( 'AFTER WF_ENGINE.CREATEPROCESS' ) ;

823: l_owner_role);
824:
825:
826: IF l_debug_level > 0 THEN
827: oe_debug_pub.add( 'AFTER WF_ENGINE.CREATEPROCESS' ) ;
828: END IF;
829:
830:
831: -- Set various Line Attributes

Line 841: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN

837: l_avalue(3) := FND_GLOBAL.RESP_ID;
838: l_aname(4) := 'ORG_ID';
839: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
840:
841: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN
842: , p_line_rec.line_id
843: , l_aname
844: , l_avalue
845: );

Line 852: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_LIN

848: l_avaluetext(1) := p_line_rec.line_category_code;
849: l_aname2(2) := 'NOTIFICATION_APPROVER';
850: l_avaluetext(2) := FND_PROFILE.VALUE('OE_NOTIFICATION_APPROVER');
851:
852: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_LIN
853: , p_line_rec.line_id
854: , l_aname2
855: , l_avaluetext
856: );

Line 904: WF_ENGINE.CreateForkProcess('OEOL', p_line_rec.split_from_line_id,

900:
901: Set_Line_User_Key(p_line_rec);
902: line := substrb(fnd_message.get, 1, 240);
903:
904: WF_ENGINE.CreateForkProcess('OEOL', p_line_rec.split_from_line_id,
905: p_line_rec.line_id,
906: true,
907: true );
908:

Line 909: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_LIN

905: p_line_rec.line_id,
906: true,
907: true );
908:
909: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_LIN
910: , p_line_rec.line_id
911: , line);
912:
913: IF l_debug_level > 0 THEN

Line 1161: WF_ENGINE.AbortProcess

1157:
1158: IF OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).post_write_ato_line_id
1159: <> l_ato_line_id THEN
1160:
1161: WF_ENGINE.AbortProcess
1162: (itemtype => OE_GLOBALS.G_WFI_LIN,
1163: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id);
1164:
1165: WF_PURGE.Items

Line 1327: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_HDR,

1323: oe_debug_pub.add( 'IN OE_ORDER_WF_UTIL.DELETE_ROW' ) ;
1324: END IF;
1325:
1326: IF p_type = 'HEADER' THEN
1327: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_HDR,
1328: itemkey => p_id,
1329: status => l_status,
1330: result => l_result);
1331: IF l_status <> 'COMPLETE' THEN

Line 1332: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_HDR,

1328: itemkey => p_id,
1329: status => l_status,
1330: result => l_result);
1331: IF l_status <> 'COMPLETE' THEN
1332: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_HDR,
1333: itemkey => p_id);
1334: END IF;
1335: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_HDR,
1336: itemkey => p_id,

Line 1361: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_LIN,

1357: WHERE line_id = p_id;
1358:
1359: IF nvl(l_transaction_phase_code, 'F') <> 'N' THEN
1360:
1361: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_LIN,
1362: itemkey => p_id,
1363: status => l_status,
1364: result => l_result);
1365: --Added the nvl condition to fix bug 2333095

Line 1367: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_LIN,

1363: status => l_status,
1364: result => l_result);
1365: --Added the nvl condition to fix bug 2333095
1366: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN
1367: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_LIN,
1368: itemkey => p_id);
1369: END IF;
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'PURGING WF ITEM' ) ;

Line 1380: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_NGO,

1376: docommit => false);
1377: END IF;
1378:
1379: ELSIF p_type = 'NEGOTIATE' THEN
1380: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_NGO,
1381: itemkey => p_id,
1382: status => l_status,
1383: result => l_result);
1384: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN

Line 1385: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_NGO,

1381: itemkey => p_id,
1382: status => l_status,
1383: result => l_result);
1384: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN
1385: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_NGO,
1386: itemkey => p_id);
1387: END IF;
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add( 'PURGING WF ITEM - Negotiate') ;

Line 1396: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_BKT,

1392: itemkey => p_id,
1393: force => TRUE,
1394: docommit => false);
1395: ELSIF p_type = 'BLANKET' THEN
1396: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_BKT,
1397: itemkey => p_id,
1398: status => l_status,
1399: result => l_result);
1400: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN

Line 1401: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_BKT,

1397: itemkey => p_id,
1398: status => l_status,
1399: result => l_result);
1400: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN
1401: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_BKT,
1402: itemkey => p_id);
1403: END IF;
1404: IF l_debug_level > 0 THEN
1405: oe_debug_pub.add( 'PURGING WF ITEM - BLANKET') ;

Line 2188: l_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'SOURCE');

2184: --
2185: -- RUN mode - normal process execution
2186: --
2187: IF (funcmode = 'RUN') THEN
2188: l_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'SOURCE');
2189: IF l_type = 'PROFILE_APPROVER' THEN
2190: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context
2191: IF itemtype = 'OEOH' THEN
2192: v_value := oe_profile.value(p_header_id => to_number(itemkey),

Line 2273: wf_engine.SetItemAttrText(itemtype, itemkey, 'NOTIFICATION_APPROVER', v_value);

2269: WHERE LINE_ID = TO_NUMBER(ITEMKEY);
2270: END IF;
2271: */
2272: END IF;
2273: wf_engine.SetItemAttrText(itemtype, itemkey, 'NOTIFICATION_APPROVER', v_value);
2274: resultout := 'COMPLETE:COMPLETE';
2275: END IF;
2276: Exception
2277: When Others Then

Line 2348: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(p_item_type, p_item_key, 'SALES_DOCUMENT_TYPE_CODE');

2344:
2345: IF p_item_type = OE_GLOBALS.G_WFI_BKT THEN
2346: l_sales_document_type_code := 'B';
2347: ELSE -- itemtype = OENH
2348: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(p_item_type, p_item_key, 'SALES_DOCUMENT_TYPE_CODE');
2349: END IF;
2350:
2351:
2352: IF l_sales_document_type_code = 'O' THEN

Line 2661: l_aname wf_engine.nametabtyp;

2657: )
2658: IS
2659: user_key_string VARCHAR2(240);
2660: l_valid_process VARCHAR2(30);
2661: l_aname wf_engine.nametabtyp;
2662: l_aname2 wf_engine.nametabtyp;
2663: l_avalue wf_engine.numtabtyp;
2664: l_avaluetext wf_engine.texttabtyp;
2665: l_user_name VARCHAR2(100);

Line 2662: l_aname2 wf_engine.nametabtyp;

2658: IS
2659: user_key_string VARCHAR2(240);
2660: l_valid_process VARCHAR2(30);
2661: l_aname wf_engine.nametabtyp;
2662: l_aname2 wf_engine.nametabtyp;
2663: l_avalue wf_engine.numtabtyp;
2664: l_avaluetext wf_engine.texttabtyp;
2665: l_user_name VARCHAR2(100);
2666: l_validate_user NUMBER;

Line 2663: l_avalue wf_engine.numtabtyp;

2659: user_key_string VARCHAR2(240);
2660: l_valid_process VARCHAR2(30);
2661: l_aname wf_engine.nametabtyp;
2662: l_aname2 wf_engine.nametabtyp;
2663: l_avalue wf_engine.numtabtyp;
2664: l_avaluetext wf_engine.texttabtyp;
2665: l_user_name VARCHAR2(100);
2666: l_validate_user NUMBER;
2667: l_owner_role VARCHAR2(100);

Line 2664: l_avaluetext wf_engine.texttabtyp;

2660: l_valid_process VARCHAR2(30);
2661: l_aname wf_engine.nametabtyp;
2662: l_aname2 wf_engine.nametabtyp;
2663: l_avalue wf_engine.numtabtyp;
2664: l_avaluetext wf_engine.texttabtyp;
2665: l_user_name VARCHAR2(100);
2666: l_validate_user NUMBER;
2667: l_owner_role VARCHAR2(100);
2668:

Line 2705: WF_ENGINE.CreateProcess(p_item_type,

2701: FROM FND_USER
2702: WHERE USER_ID = p_user_id;
2703:
2704: -- Create process
2705: WF_ENGINE.CreateProcess(p_item_type,
2706: p_item_key,
2707: p_process_name,
2708: user_key_string,
2709: l_owner_role);

Line 2713: oe_debug_pub.add( 'After WF_ENGINE.CreateProcess', 4 ) ;

2709: l_owner_role);
2710:
2711:
2712: IF l_debug_level > 0 THEN
2713: oe_debug_pub.add( 'After WF_ENGINE.CreateProcess', 4 ) ;
2714: END IF;
2715:
2716: -- Set various Header Attributes
2717: l_aname(1) := 'USER_ID';

Line 2728: wf_engine.SetItemAttrNumberArray(p_item_type

2724: l_avalue(4) := p_org_id;
2725: l_aname(5) := 'TRANSACTION_NUMBER';
2726: l_avalue(5) := p_transaction_number;
2727:
2728: wf_engine.SetItemAttrNumberArray(p_item_type
2729: , p_item_key
2730: , l_aname
2731: , l_avalue
2732: );

Line 2829: l_aname wf_engine.nametabtyp;

2825: p_sales_document_type_code IN VARCHAR2
2826: )
2827: IS
2828: l_hdr_process_name VARCHAR2(30);
2829: l_aname wf_engine.nametabtyp;
2830: l_aname2 wf_engine.nametabtyp;
2831: l_avalue wf_engine.numtabtyp;
2832: l_avaluetext wf_engine.texttabtyp;
2833:

Line 2830: l_aname2 wf_engine.nametabtyp;

2826: )
2827: IS
2828: l_hdr_process_name VARCHAR2(30);
2829: l_aname wf_engine.nametabtyp;
2830: l_aname2 wf_engine.nametabtyp;
2831: l_avalue wf_engine.numtabtyp;
2832: l_avaluetext wf_engine.texttabtyp;
2833:
2834: user_key_string VARCHAR2(240);

Line 2831: l_avalue wf_engine.numtabtyp;

2827: IS
2828: l_hdr_process_name VARCHAR2(30);
2829: l_aname wf_engine.nametabtyp;
2830: l_aname2 wf_engine.nametabtyp;
2831: l_avalue wf_engine.numtabtyp;
2832: l_avaluetext wf_engine.texttabtyp;
2833:
2834: user_key_string VARCHAR2(240);
2835: l_user_name VARCHAR2(100);

Line 2832: l_avaluetext wf_engine.texttabtyp;

2828: l_hdr_process_name VARCHAR2(30);
2829: l_aname wf_engine.nametabtyp;
2830: l_aname2 wf_engine.nametabtyp;
2831: l_avalue wf_engine.numtabtyp;
2832: l_avaluetext wf_engine.texttabtyp;
2833:
2834: user_key_string VARCHAR2(240);
2835: l_user_name VARCHAR2(100);
2836: l_validate_user NUMBER;

Line 2871: WF_ENGINE.CreateProcess(p_item_type,

2867: FROM FND_USER
2868: WHERE USER_ID = FND_GLOBAL.USER_ID;
2869:
2870: -- Create Header Work item
2871: WF_ENGINE.CreateProcess(p_item_type,
2872: to_char(p_header_id),
2873: l_hdr_process_name,
2874: user_key_string,
2875: l_owner_role);

Line 2879: oe_debug_pub.add( 'AFTER WF_ENGINE.CREATEPROCESS' ) ;

2875: l_owner_role);
2876:
2877:
2878: IF l_debug_level > 0 THEN
2879: oe_debug_pub.add( 'AFTER WF_ENGINE.CREATEPROCESS' ) ;
2880: END IF;
2881:
2882: -- Set various Header Attributes
2883: l_aname(1) := 'USER_ID';

Line 2899: wf_engine.SetItemAttrNumberArray(p_item_type

2895: l_aname(6) := 'HEADER_ID';
2896: l_avalue(6) := p_header_id;
2897: END IF;
2898:
2899: wf_engine.SetItemAttrNumberArray(p_item_type
2900: , to_char(p_header_id)
2901: , l_aname
2902: , l_avalue
2903: );

Line 2917: wf_engine.SetItemAttrText(p_item_type,

2913: WHEN OTHERS THEN
2914: l_user_name := null; -- do not set FROM_ROLE then
2915: END;
2916:
2917: wf_engine.SetItemAttrText(p_item_type,
2918: to_char(p_header_id),
2919: 'NOTIFICATION_FROM_ROLE',
2920: l_user_name);
2921:

Line 2935: wf_engine.SetItemAttrTextArray(p_item_type

2931: -- CONTRACT_ATTACHMENT will not be set here, it may be too early, we need
2932: -- to call contract to determine the attachment, at a later time, it's done
2933: -- at Initiate_Approval
2934:
2935: wf_engine.SetItemAttrTextArray(p_item_type
2936: , to_char(p_header_id)
2937: , l_aname2
2938: , l_avaluetext
2939: );

Line 2978: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_NGO

2974: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
2975: END IF;
2976:
2977: l_user_key := substrb(fnd_message.get, 1, 240);
2978: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_NGO
2979: , p_header_id
2980: , l_user_key);
2981: EXCEPTION
2982: WHEN OTHERS THEN

Line 3005: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_BKT

3001: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
3002: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
3003:
3004: l_user_key := substrb(fnd_message.get, 1, 240);
3005: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_BKT
3006: , p_header_id
3007: , l_user_key);
3008: EXCEPTION
3009: WHEN OTHERS THEN

Line 3059: l_sales_document_type_code := wf_engine.GetItemAttrText(

3055: -- Get the Sales Document Type
3056: if l_item_type = 'OEBH' THEN
3057: l_blanket_flag := 'Y';
3058: else
3059: l_sales_document_type_code := wf_engine.GetItemAttrText(
3060: OE_GLOBALS.G_WFI_NGO,
3061: l_item_key,
3062: 'SALES_DOCUMENT_TYPE_CODE');
3063: if l_sales_document_type_code = 'B' then

Line 3116: l_aname wf_engine.nametabtyp;

3112: --l_header_id NUMBER;
3113: l_blanket_flag VARCHAR2(1);
3114:
3115: l_item_type VARCHAR2(8);
3116: l_aname wf_engine.nametabtyp;
3117: l_avaluetext wf_engine.texttabtyp;
3118:
3119:
3120: l_transaction_number NUMBER;

Line 3117: l_avaluetext wf_engine.texttabtyp;

3113: l_blanket_flag VARCHAR2(1);
3114:
3115: l_item_type VARCHAR2(8);
3116: l_aname wf_engine.nametabtyp;
3117: l_avaluetext wf_engine.texttabtyp;
3118:
3119:
3120: l_transaction_number NUMBER;
3121:

Line 3268: l_transaction_number := wf_engine.GetItemAttrNumber(

3264: --------------------------------------------------
3265: -- IF the WF Header Attributes are not enables ---
3266: --------------------------------------------------
3267: IF l_wf_header_attr <> 'Y' THEN
3268: l_transaction_number := wf_engine.GetItemAttrNumber(
3269: p_item_type,
3270: p_item_key,
3271: 'TRANSACTION_NUMBER');
3272:

Line 3273: l_salesrep := wf_engine.GetItemAttrText(

3269: p_item_type,
3270: p_item_key,
3271: 'TRANSACTION_NUMBER');
3272:
3273: l_salesrep := wf_engine.GetItemAttrText(
3274: p_item_type,
3275: p_item_key,
3276: 'SALESPERSON');
3277: l_sold_to := wf_engine.GetItemAttrText(

Line 3277: l_sold_to := wf_engine.GetItemAttrText(

3273: l_salesrep := wf_engine.GetItemAttrText(
3274: p_item_type,
3275: p_item_key,
3276: 'SALESPERSON');
3277: l_sold_to := wf_engine.GetItemAttrText(
3278: p_item_type,
3279: p_item_key,
3280: 'SOLD_TO');
3281:

Line 3309: l_transaction_number := wf_engine.GetItemAttrNumber(

3305: ----------------
3306: --- TEXT ---
3307: elsif p_display_type = 'text/plain' then
3308:
3309: l_transaction_number := wf_engine.GetItemAttrNumber(
3310: p_item_type,
3311: p_item_key,
3312: 'TRANSACTION_NUMBER');
3313:

Line 3314: l_salesrep := wf_engine.GetItemAttrText(

3310: p_item_type,
3311: p_item_key,
3312: 'TRANSACTION_NUMBER');
3313:
3314: l_salesrep := wf_engine.GetItemAttrText(
3315: p_item_type,
3316: p_item_key,
3317: 'SALESPERSON');
3318: l_sold_to := wf_engine.GetItemAttrText(

Line 3318: l_sold_to := wf_engine.GetItemAttrText(

3314: l_salesrep := wf_engine.GetItemAttrText(
3315: p_item_type,
3316: p_item_key,
3317: 'SALESPERSON');
3318: l_sold_to := wf_engine.GetItemAttrText(
3319: p_item_type,
3320: p_item_key,
3321: 'SOLD_TO');
3322:

Line 3369: l_aname wf_engine.nametabtyp;

3365: l_transaction_id NUMBER;
3366: l_blanket_flag VARCHAR2(1);
3367:
3368: l_item_type VARCHAR2(8);
3369: l_aname wf_engine.nametabtyp;
3370: l_avaluetext wf_engine.texttabtyp;
3371:
3372:
3373: l_transaction_number NUMBER;

Line 3370: l_avaluetext wf_engine.texttabtyp;

3366: l_blanket_flag VARCHAR2(1);
3367:
3368: l_item_type VARCHAR2(8);
3369: l_aname wf_engine.nametabtyp;
3370: l_avaluetext wf_engine.texttabtyp;
3371:
3372:
3373: l_transaction_number NUMBER;
3374:

Line 3576: l_transaction_number := wf_engine.GetItemAttrNumber(

3572: --------------------------------------------------
3573: -- IF the WF Header Attributes are not enables ---
3574: --------------------------------------------------
3575: IF l_wf_header_attr <> 'Y' THEN
3576: l_transaction_number := wf_engine.GetItemAttrNumber(
3577: p_item_type,
3578: p_item_key,
3579: 'TRANSACTION_NUMBER');
3580: l_salesrep := wf_engine.GetItemAttrText(

Line 3580: l_salesrep := wf_engine.GetItemAttrText(

3576: l_transaction_number := wf_engine.GetItemAttrNumber(
3577: p_item_type,
3578: p_item_key,
3579: 'TRANSACTION_NUMBER');
3580: l_salesrep := wf_engine.GetItemAttrText(
3581: p_item_type,
3582: p_item_key,
3583: 'SALESPERSON');
3584: l_sold_to := wf_engine.GetItemAttrText(

Line 3584: l_sold_to := wf_engine.GetItemAttrText(

3580: l_salesrep := wf_engine.GetItemAttrText(
3581: p_item_type,
3582: p_item_key,
3583: 'SALESPERSON');
3584: l_sold_to := wf_engine.GetItemAttrText(
3585: p_item_type,
3586: p_item_key,
3587: 'SOLD_TO');
3588: l_expiration_date := wf_engine.GetItemAttrText(

Line 3588: l_expiration_date := wf_engine.GetItemAttrText(

3584: l_sold_to := wf_engine.GetItemAttrText(
3585: p_item_type,
3586: p_item_key,
3587: 'SOLD_TO');
3588: l_expiration_date := wf_engine.GetItemAttrText(
3589: p_item_type,
3590: p_item_key,
3591: 'EXPIRATION_DATE');
3592:

Line 3699: l_transaction_number := wf_engine.GetItemAttrNumber(

3695: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3696: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3697: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3698:
3699: l_transaction_number := wf_engine.GetItemAttrNumber(
3700: p_item_type,
3701: p_item_key,
3702: 'TRANSACTION_NUMBER');
3703:

Line 3704: l_salesrep := wf_engine.GetItemAttrText(

3700: p_item_type,
3701: p_item_key,
3702: 'TRANSACTION_NUMBER');
3703:
3704: l_salesrep := wf_engine.GetItemAttrText(
3705: p_item_type,
3706: p_item_key,
3707: 'SALESPERSON');
3708: l_sold_to := wf_engine.GetItemAttrText(

Line 3708: l_sold_to := wf_engine.GetItemAttrText(

3704: l_salesrep := wf_engine.GetItemAttrText(
3705: p_item_type,
3706: p_item_key,
3707: 'SALESPERSON');
3708: l_sold_to := wf_engine.GetItemAttrText(
3709: p_item_type,
3710: p_item_key,
3711: 'SOLD_TO');
3712: l_expiration_date := wf_engine.GetItemAttrText(

Line 3712: l_expiration_date := wf_engine.GetItemAttrText(

3708: l_sold_to := wf_engine.GetItemAttrText(
3709: p_item_type,
3710: p_item_key,
3711: 'SOLD_TO');
3712: l_expiration_date := wf_engine.GetItemAttrText(
3713: p_item_type,
3714: p_item_key,
3715: 'EXPIRATION_DATE');
3716:

Line 3888: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO,

3884: IF l_debug_level > 0 THEN
3885: oe_debug_pub.add('ELIGIBLE Activity: ' || l_activity);
3886: END IF;
3887:
3888: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO,
3889: to_char(p_header_id), l_activity, l_retval);
3890: -- The order could have been booked already becuase the booking was synchronous.
3891: select booked_flag, flow_status_code
3892: into l_booked_flag, l_flow_status_code