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 221: -------itemtype = OE_GLOBALS.G_WFI_NGO-------

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

Line 365: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

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

Line 367: OE_GLOBALS.G_WFI_NGO,

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

Line 419: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

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

Line 768: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

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

Line 770: OE_GLOBALS.G_WFI_NGO,

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

Line 911: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

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

Line 913: OE_GLOBALS.G_WFI_NGO,

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

Line 1053: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

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

Line 1055: p_item_type => OE_GLOBALS.G_WFI_NGO,

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

Line 1275: OE_GLOBALS.G_WFI_NGO,

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

Line 1425: IF itemtype = oe_globals.g_wfi_ngo

1421: -- Delete any previous approval transaction data.
1422: DELETE FROM oe_approver_transactions
1423: WHERE transaction_id = l_transaction_id;
1424:
1425: IF itemtype = oe_globals.g_wfi_ngo
1426: THEN
1427: l_sales_document_type_code :=
1428: wf_engine.getitemattrtext (oe_globals.g_wfi_ngo,
1429: l_transaction_id,

Line 1428: wf_engine.getitemattrtext (oe_globals.g_wfi_ngo,

1424:
1425: IF itemtype = oe_globals.g_wfi_ngo
1426: THEN
1427: l_sales_document_type_code :=
1428: wf_engine.getitemattrtext (oe_globals.g_wfi_ngo,
1429: l_transaction_id,
1430: 'SALES_DOCUMENT_TYPE_CODE'
1431: );
1432:

Line 1463: IF itemtype = oe_globals.g_wfi_ngo

1459: oe_debug_pub.ADD
1460: ('Getting the AME transaction type associated with this header');
1461: END IF;
1462:
1463: IF itemtype = oe_globals.g_wfi_ngo
1464: THEN
1465: IF l_debug_level > 0
1466: THEN
1467: oe_debug_pub.ADD ('item type is negotiation so AME TTY is OENEG');

Line 1477: ELSIF itemtype = oe_globals.g_wfi_hdr

1473:
1474: ELSE -- 16084377 AME BSA
1475: l_ame_transaction := 'OEBSA';
1476: END IF ;
1477: ELSIF itemtype = oe_globals.g_wfi_hdr
1478: THEN
1479: IF l_debug_level > 0
1480: THEN
1481: oe_debug_pub.ADD ('item type is header so AME TTY is OERMA');

Line 1767: IF itemtype = oe_globals.g_wfi_ngo

1763: j := j + 1;
1764: l_aname2 (j) := 'HEADER_ID';
1765: l_avalue (j) := TO_NUMBER (itemkey);
1766:
1767: IF itemtype = oe_globals.g_wfi_ngo
1768: THEN
1769: i := i + 1;
1770: l_aname (i) := 'SALES_DOCUMENT_TYPE_CODE';
1771: l_avaluetext (i) := l_sales_document_type_code;

Line 1894: IF itemtype = oe_globals.g_wfi_ngo

1890: END IF;
1891:
1892: --------------------------------------------------
1893: -- Set Header Attributes Values for Negotiation --
1894: IF itemtype = oe_globals.g_wfi_ngo
1895: THEN
1896: IF l_sales_document_type_code = 'O'
1897: THEN
1898: SELECT sold_to_org_id, expiration_date,

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

1962: l_item_key,
1963: l_aname2,
1964: l_avalue
1965: );
1966: -------itemtype = OE_GLOBALS.G_WFI_NGO-------
1967: wf_engine.startprocess (itemtype => l_item_type,
1968: itemkey => l_item_key
1969: );
1970: END IF;

Line 2382: IF l_parent_itemtype = oe_globals.g_wfi_ngo

2378: l_transaction_id,
2379: 'NOTIFICATION_APPROVER'
2380: );
2381:
2382: IF l_parent_itemtype = oe_globals.g_wfi_ngo
2383: THEN
2384: BEGIN
2385: l_sales_document_type_code :=
2386: wf_engine.getitemattrtext (itemtype,

Line 2708: IF l_parent_item_type = oe_globals.g_wfi_ngo

2704: l_transaction_id,
2705: 'NOTIFICATION_APPROVER'
2706: );
2707:
2708: IF l_parent_item_type = oe_globals.g_wfi_ngo
2709: THEN
2710: BEGIN
2711: l_sales_document_type_code :=
2712: wf_engine.getitemattrtext (itemtype,

Line 3311: IF itemtype = oe_globals.g_wfi_ngo

3307: oe_debug_pub.ADD ('Entering IS_AME_APPROVAL');
3308: END IF ;
3309: g_ame_used := 'N';
3310:
3311: IF itemtype = oe_globals.g_wfi_ngo
3312: THEN
3313: l_sales_document_type_code := wf_engine.GetItemAttrText(
3314: itemtype,
3315: itemkey,

Line 3325: ELSIF itemtype = oe_globals.g_wfi_hdr

3321: l_ame_transaction := 'OENEG'; -- 16084377 AME BSA
3322: ELSE
3323: l_ame_transaction := 'OEBSA';
3324: END IF ;
3325: ELSIF itemtype = oe_globals.g_wfi_hdr
3326: THEN
3327: IF l_debug_level > 0 THEN
3328: oe_debug_pub.ADD ('item type is header so AME TTY is OERMA');
3329: END IF ;