DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_MOAC_UTILS_PVT

Line 1418: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --

1414: ** By all other activities.
1415: */
1416: PO_REQAPPROVAL_INIT1.get_multiorg_context (DocumentTypeCode, DocumentID, x_orgid);
1417: IF x_orgid IS NOT NULL THEN
1418: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --
1419: /* Set the Org_id item attribute. We will use it to get the context for every activity */
1420: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'ORG_ID', avalue => x_orgid);
1421: END IF;
1422: -- DKC 02/06/01

Line 1602: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --

1598: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'USER_ID', avalue => l_user_id);
1599: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPLICATION_ID', avalue => l_application_id);
1600: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RESPONSIBILITY_ID', avalue => l_responsibility_id);
1601: IF x_orgid IS NOT NULL THEN
1602: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --
1603: END IF;
1604: END IF;
1605: --
1606: -- When background flag is 'Y' the approval workflow blocks at a background activity

Line 1741: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --

1737: END IF;
1738: -- Set the multi-org context
1739: x_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
1740: IF x_orgid IS NOT NULL THEN
1741: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --
1742: END IF;
1743: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
1744: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
1745: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');

Line 2156: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

2152: --Context Setting Revamp
2153: /* PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey); */
2154: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2155: IF l_orgid IS NOT NULL THEN
2156: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2157: END IF;
2158: l_requisition_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
2159: GetReqAttributes(l_requisition_header_id,itemtype,itemkey);
2160: --

Line 2208: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

2204: END IF;
2205: -- Set the multi-org context
2206: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2207: IF l_orgid IS NOT NULL THEN
2208: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2209: END IF;
2210: -- Bug 3326847: Change l_requisition_header_id to l_doc_header_id
2211: l_doc_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
2212: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');

Line 2283: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

2279: END IF;
2280: -- Set the multi-org context
2281: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2282: IF l_orgid IS NOT NULL THEN
2283: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2284: END IF;
2285: -- Bug 3326847: Change l_requisition_header_id to l_doc_header_id
2286: l_doc_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
2287: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');

Line 2354: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

2350: END IF;
2351: -- Set the multi-org context
2352: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2353: IF l_orgid IS NOT NULL THEN
2354: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2355: END IF;
2356: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
2357: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
2358: l_authorization_stat := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'AUTHORIZATION_STATUS');

Line 2452: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

2448: END IF;
2449: -- Set the multi-org context
2450: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2451: IF l_orgid IS NOT NULL THEN
2452: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2453: END IF;
2454: l_orig_auth_stat := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'ORIG_AUTH_STATUS');
2455: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
2456: l_doc_subtype := wf_engine.GetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');

Line 2568: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

2564: END IF;
2565: -- Set the multi-org context
2566: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2567: IF l_orgid IS NOT NULL THEN
2568: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2569: END IF;
2570: l_doc_id := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
2571: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
2572: IF l_doc_type = 'REQUISITION' THEN

Line 2642: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

2638: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
2639: -- Set the multi-org context
2640: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2641: IF l_orgid IS NOT NULL THEN
2642: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2643: END IF;
2644: PO_REQAPPROVAL_INIT1.GetCanOwnerApprove(itemtype, itemkey, x_CanOwnerApproveFlag);
2645: --
2646: resultout := wf_engine.eng_completed || ':' || x_CanOwnerApproveFlag ;

Line 2740: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

2736: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
2737: -- Bug 762194: Need to set multi-org context.
2738: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2739: IF l_orgid IS NOT NULL THEN
2740: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2741: END IF;
2742: IF l_doc_type = 'REQUISITION' THEN
2743: SELECT NVL(authorization_status, 'INCOMPLETE')
2744: INTO l_auth_stat

Line 2858: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

2854: l_note := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'NOTE');
2855: -- Set the multi-org context
2856: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2857: IF l_orgid IS NOT NULL THEN
2858: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2859: END IF;
2860: l_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'APPROVAL_PATH_ID');
2861: -- Mod Project; added draft_id to the next proc.
2862: PO_REQAPPROVAL_INIT1.InsertActionHistSubmit(itemtype,itemkey,l_doc_id, l_doc_type, l_doc_subtype, l_employee_id, 'SUBMIT', l_note, l_path_id, l_draft_id);

Line 3060: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

3056: --
3057: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
3058: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
3059: IF l_orgid IS NOT NULL THEN
3060: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
3061: END IF;
3062: IF ( EncumbOn_DocUnreserved( p_doc_type => l_document_type, p_doc_subtype => l_document_subtype, p_doc_id => l_document_id) = 'Y' ) THEN
3063: --
3064: resultout := wf_engine.eng_completed || ':' || 'Y' ;

Line 3242: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

3238: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3239: itemkey => itemkey,
3240: aname => 'ORG_ID');
3241: IF l_orgid is NOT NULL THEN
3242: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
3243: END IF;
3244: */
3245: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
3246: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');

Line 3250: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

3246: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
3247: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
3248: PO_REQAPPROVAL_INIT1.get_multiorg_context(l_document_type,l_document_id,l_orgid);
3249: IF l_orgid IS NOT NULL THEN
3250: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
3251: wf_engine.SetItemAttrNumber (itemtype => itemtype , itemkey => itemkey , aname => 'ORG_ID' , avalue => l_orgid );
3252: END IF;
3253: /* End of fix for Bug # 1384323 */
3254: IF l_document_type = 'RELEASE' THEN

Line 3443: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

3439: l_appl_id is not null )then
3440: -- Bug 4290541,replaced apps init call with set doc mgr contxt
3441: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey); */
3442: IF l_orgid IS NOT NULL THEN
3443: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
3444: END IF;
3445: -- end if;
3446: l_create_sr_asl := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CREATE_SOURCING_RULE');
3447: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');

Line 3926: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

3922: * was throwing an exception. Hence setting the org context here.
3923: */
3924: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
3925: IF l_orgid IS NOT NULL THEN
3926: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
3927: END IF;
3928: x_progress := '001';
3929: -- Create the attribute email document
3930: l_email_doc := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'EMAIL_DOCUMENT');

Line 4127: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

4123: RETURN;
4124: END IF;
4125: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
4126: IF l_orgid IS NOT NULL THEN
4127: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4128: END IF;
4129: x_progress := 'PO_REQAPPROVAL_INIT1.Print_Document: 02';
4130: PrintDocument(itemtype,itemkey);
4131: --

Line 4172: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

4168: RETURN;
4169: END IF;
4170: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
4171: IF l_orgid IS NOT NULL THEN
4172: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4173: END IF;
4174: x_progress := 'PO_REQAPPROVAL_INIT1.Fax_Document: 02';
4175: FaxDocument(itemtype,itemkey);
4176: --

Line 4232: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

4228: --Context Setting Revamp
4229: --PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey);
4230: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
4231: IF l_orgid IS NOT NULL THEN
4232: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4233: END IF;
4234: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
4235: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4236: IF l_doc_type ='REQUISITION' THEN

Line 6253: po_moac_utils_pvt.set_request_context

6249: )
6250: ;
6251: BEGIN
6252: --
6253: po_moac_utils_pvt.set_request_context
6254: (
6255: po_moac_utils_pvt.get_current_org_id
6256: )
6257: ;

Line 6255: po_moac_utils_pvt.get_current_org_id

6251: BEGIN
6252: --
6253: po_moac_utils_pvt.set_request_context
6254: (
6255: po_moac_utils_pvt.get_current_org_id
6256: )
6257: ;
6258: --
6259: l_request_id := fnd_request.submit_request

Line 6318: po_moac_utils_pvt.set_request_context

6314: )
6315: THEN
6316: --Launching the Dispatch Purchase Order Concurrent Program
6317: --
6318: po_moac_utils_pvt.set_request_context
6319: (
6320: po_moac_utils_pvt.get_current_org_id
6321: )
6322: ;

Line 6320: po_moac_utils_pvt.get_current_org_id

6316: --Launching the Dispatch Purchase Order Concurrent Program
6317: --
6318: po_moac_utils_pvt.set_request_context
6319: (
6320: po_moac_utils_pvt.get_current_org_id
6321: )
6322: ;
6323: --
6324: l_request_id := fnd_request.submit_request

Line 6368: po_moac_utils_pvt.set_request_context

6364: ;
6365: --
6366: ELSE
6367: --
6368: po_moac_utils_pvt.set_request_context
6369: (
6370: po_moac_utils_pvt.get_current_org_id
6371: )
6372: ;

Line 6370: po_moac_utils_pvt.get_current_org_id

6366: ELSE
6367: --
6368: po_moac_utils_pvt.set_request_context
6369: (
6370: po_moac_utils_pvt.get_current_org_id
6371: )
6372: ;
6373: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));
6374: --

Line 6438: po_moac_utils_pvt.set_request_context

6434: )
6435: THEN
6436: --Launching the Dispatch Purchase Order Concurrent Program
6437: --
6438: po_moac_utils_pvt.set_request_context
6439: (
6440: po_moac_utils_pvt.get_current_org_id
6441: )
6442: ;

Line 6440: po_moac_utils_pvt.get_current_org_id

6436: --Launching the Dispatch Purchase Order Concurrent Program
6437: --
6438: po_moac_utils_pvt.set_request_context
6439: (
6440: po_moac_utils_pvt.get_current_org_id
6441: )
6442: ;
6443: --
6444: --Bug5080617 Pass the parameters P_PO_TEMPLATE_CODE and P_CONTRACT_TEMPLATE_CODE as null

Line 6489: po_moac_utils_pvt.set_request_context

6485: ;
6486: --
6487: ELSE
6488: --
6489: po_moac_utils_pvt.set_request_context
6490: (
6491: po_moac_utils_pvt.get_current_org_id
6492: )
6493: ;

Line 6491: po_moac_utils_pvt.get_current_org_id

6487: ELSE
6488: --
6489: po_moac_utils_pvt.set_request_context
6490: (
6491: po_moac_utils_pvt.get_current_org_id
6492: )
6493: ;
6494: --
6495: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));

Line 6561: po_moac_utils_pvt.set_request_context

6557: )
6558: THEN
6559: --Launching the Dispatch Purchase Order Concurrent Program
6560: --
6561: po_moac_utils_pvt.set_request_context
6562: (
6563: po_moac_utils_pvt.get_current_org_id
6564: )
6565: ;

Line 6563: po_moac_utils_pvt.get_current_org_id

6559: --Launching the Dispatch Purchase Order Concurrent Program
6560: --
6561: po_moac_utils_pvt.set_request_context
6562: (
6563: po_moac_utils_pvt.get_current_org_id
6564: )
6565: ;
6566: --
6567: --Bug5080617 Pass the parameters P_PO_TEMPLATE_CODE and P_CONTRACT_TEMPLATE_CODE as null

Line 6613: po_moac_utils_pvt.set_request_context

6609: --
6610: ELSE
6611: -- FRKHAN 09/17/98. Change 'p_doc_num || p_release_num' from P_RELEASE_NUM_FROM and TO to just p_release_num
6612: --
6613: po_moac_utils_pvt.set_request_context
6614: (
6615: po_moac_utils_pvt.get_current_org_id
6616: )
6617: ;

Line 6615: po_moac_utils_pvt.get_current_org_id

6611: -- FRKHAN 09/17/98. Change 'p_doc_num || p_release_num' from P_RELEASE_NUM_FROM and TO to just p_release_num
6612: --
6613: po_moac_utils_pvt.set_request_context
6614: (
6615: po_moac_utils_pvt.get_current_org_id
6616: )
6617: ;
6618: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));
6619: --

Line 6684: po_moac_utils_pvt.set_request_context

6680: )
6681: THEN
6682: --Launching the Dispatch Purchase Order Concurrent Program
6683: --
6684: po_moac_utils_pvt.set_request_context
6685: (
6686: po_moac_utils_pvt.get_current_org_id
6687: )
6688: ;

Line 6686: po_moac_utils_pvt.get_current_org_id

6682: --Launching the Dispatch Purchase Order Concurrent Program
6683: --
6684: po_moac_utils_pvt.set_request_context
6685: (
6686: po_moac_utils_pvt.get_current_org_id
6687: )
6688: ;
6689: --
6690: --Bug5080617 Pass the parameters P_PO_TEMPLATE_CODE and P_CONTRACT_TEMPLATE_CODE as null

Line 6736: po_moac_utils_pvt.set_request_context

6732: ;
6733: --
6734: ELSE
6735: --
6736: po_moac_utils_pvt.set_request_context
6737: (
6738: po_moac_utils_pvt.get_current_org_id
6739: )
6740: ;

Line 6738: po_moac_utils_pvt.get_current_org_id

6734: ELSE
6735: --
6736: po_moac_utils_pvt.set_request_context
6737: (
6738: po_moac_utils_pvt.get_current_org_id
6739: )
6740: ;
6741: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));
6742: --

Line 6973: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

6969: BEGIN
6970: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
6971: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
6972: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
6973: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
6974: IF (l_document_type IN ('PO', 'PA')) THEN
6975: SELECT st.DISPLAYED_FIELD
6976: || ' '
6977: || ty.DISPLAYED_FIELD

Line 7356: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

7352: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_ID');
7353: IF l_ga_flag = 'N' THEN
7354: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type, itemkey => l_item_key, aname => 'ORG_ID');
7355: IF l_orgid IS NOT NULL THEN
7356: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7357: END IF;
7358: END IF;
7359: /* if l_ga_flag = 'N' */
7360: IF (l_doc_type = 'PA' AND l_doc_subtype IN ('BLANKET','CONTRACT')) OR (l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD') THEN

Line 7506: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ; --

7502: l_ntf_role_name VARCHAR2(320);
7503: BEGIN
7504: -- set the org context
7505: x_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
7506: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ; --
7507: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
7508: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
7509: -- commented out the usage of accptance_type (FPI)
7510: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 7641: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ; --

7637: l_ntf_role_name VARCHAR2(320);
7638: BEGIN
7639: -- set the org context
7640: x_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
7641: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ; --
7642: x_progress := '001';
7643: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
7644: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
7645: -- commented out the usage of accptance_type (FPI)

Line 7961: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

7957: * the responsibility. So set the org context explicitly again.
7958: */
7959: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
7960: IF l_orgid IS NOT NULL THEN
7961: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7962: END IF;
7963: /* RETRO FPI END. */
7964: -- Bug 3571038
7965: igi_sls_context_pkg.set_sls_context;

Line 8015: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

8011: l_appl_id is not null )then
8012: -- Bug 4125251,replaced apps init call with set doc mgr context call
8013: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey); */
8014: IF l_orgid IS NOT NULL THEN
8015: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8016: END IF;
8017: -- end if;
8018: l_massupdate_releases := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'MASSUPDATE_RELEASES');
8019: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');