DBA Data[Home] [Help]

APPS.OE_APPROVALS_WF dependencies on OE_GLOBALS

Line 85: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

81: DELETE
82: FROM OE_APPROVER_TRANSACTIONS
83: WHERE TRANSACTION_ID = l_transaction_id;
84:
85: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
86: l_sales_document_type_code := wf_engine.GetItemAttrText(
87: OE_GLOBALS.G_WFI_NGO,
88: l_transaction_id,
89: 'SALES_DOCUMENT_TYPE_CODE');

Line 87: OE_GLOBALS.G_WFI_NGO,

83: WHERE TRANSACTION_ID = l_transaction_id;
84:
85: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
86: l_sales_document_type_code := wf_engine.GetItemAttrText(
87: OE_GLOBALS.G_WFI_NGO,
88: l_transaction_id,
89: 'SALES_DOCUMENT_TYPE_CODE');
90: END IF;
91:

Line 186: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

182:
183: --------------------------------------------------
184: -- Set Header Attributes Values for Negotiation --
185:
186: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
187: IF l_sales_document_type_code = 'O' THEN
188: select sold_to_org_id, expiration_date, salesrep_id
189: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
190: from oe_order_headers_all

Line 220: -------itemtype = OE_GLOBALS.G_WFI_NGO-------

216: , l_avaluetext
217: );
218: -- End setting Header Attributes
219: END IF;
220: -------itemtype = OE_GLOBALS.G_WFI_NGO-------
221:
222: OE_ORDER_WF_UTIL.Update_Flow_Status_Code
223: (p_item_type => itemtype,
224: p_header_id => l_transaction_id,

Line 364: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

360: from OE_APPROVER_TRANSACTIONS
361: WHERE TRANSACTION_ID = l_transaction_id);
362:
363:
364: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
365: l_sales_document_type_code := wf_engine.GetItemAttrText(
366: OE_GLOBALS.G_WFI_NGO,
367: l_transaction_id,
368: 'SALES_DOCUMENT_TYPE_CODE');

Line 366: OE_GLOBALS.G_WFI_NGO,

362:
363:
364: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
365: l_sales_document_type_code := wf_engine.GetItemAttrText(
366: OE_GLOBALS.G_WFI_NGO,
367: l_transaction_id,
368: 'SALES_DOCUMENT_TYPE_CODE');
369: END IF;
370:

Line 418: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

414:
415:
416: -----------------------------------
417: -- Set Header Attributes Values --
418: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
419: ----???? Join to the value table
420: IF l_sales_document_type_code = 'O' THEN
421: select sold_to_org_id, expiration_date, salesrep_id
422: into l_sold_to_org_id, l_expiration_date, l_salesrep_id

Line 766: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

762: if (funcmode = 'RUN') then
763:
764: l_transaction_id := to_number(itemkey);
765:
766: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
767: l_sales_document_type_code := wf_engine.GetItemAttrText(
768: OE_GLOBALS.G_WFI_NGO,
769: l_transaction_id,
770: 'SALES_DOCUMENT_TYPE_CODE');

Line 768: OE_GLOBALS.G_WFI_NGO,

764: l_transaction_id := to_number(itemkey);
765:
766: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
767: l_sales_document_type_code := wf_engine.GetItemAttrText(
768: OE_GLOBALS.G_WFI_NGO,
769: l_transaction_id,
770: 'SALES_DOCUMENT_TYPE_CODE');
771: END IF;
772:

Line 909: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

905:
906: IF nvl(OE_SYS_PARAMETERS.value('NO_RESPONSE_FROM_APPROVER'), 'CONTINUE') ='CONTINUE' THEN
907:
908: -- If the current approver is the last in the list, then still reject it.
909: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
910: l_sales_document_type_code := wf_engine.GetItemAttrText(
911: OE_GLOBALS.G_WFI_NGO,
912: l_transaction_id,
913: 'SALES_DOCUMENT_TYPE_CODE');

Line 911: OE_GLOBALS.G_WFI_NGO,

907:
908: -- If the current approver is the last in the list, then still reject it.
909: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
910: l_sales_document_type_code := wf_engine.GetItemAttrText(
911: OE_GLOBALS.G_WFI_NGO,
912: l_transaction_id,
913: 'SALES_DOCUMENT_TYPE_CODE');
914: END IF;
915:

Line 1051: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

1047: -- and then that notifcations get rejected and transitions to Reject_apprroval
1048: null;
1049: END;
1050:
1051: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
1052: OE_ORDER_WF_UTIL.Update_Quote_Blanket(
1053: p_item_type => OE_GLOBALS.G_WFI_NGO,
1054: p_item_key => to_number(itemkey),
1055: p_flow_status_code => 'DRAFT_INTERNAL_REJECTED',

Line 1053: p_item_type => OE_GLOBALS.G_WFI_NGO,

1049: END;
1050:
1051: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
1052: OE_ORDER_WF_UTIL.Update_Quote_Blanket(
1053: p_item_type => OE_GLOBALS.G_WFI_NGO,
1054: p_item_key => to_number(itemkey),
1055: p_flow_status_code => 'DRAFT_INTERNAL_REJECTED',
1056: p_draft_submitted_flag => 'N',
1057: x_return_status => l_return_status);

Line 1273: OE_GLOBALS.G_WFI_NGO,

1269: where NOTIFICATION_ID = to_number(document_id);
1270:
1271:
1272: l_sales_document_type_code := wf_engine.GetItemAttrText(
1273: OE_GLOBALS.G_WFI_NGO,
1274: to_char(l_transaction_id),
1275: 'SALES_DOCUMENT_TYPE_CODE');
1276:
1277: select meaning