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.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_WF_UTIL_PKG

Line 422: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,

418: IF (g_po_wf_debug = 'Y') THEN
419: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
420: END IF;
421:
422: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,
423: itemkey=>itemkey,
424: aname=>'APPROVER_USER_NAME');
425: if (l_approver_user_name is not null) then
426: SELECT user_id

Line 4044: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(

4040: open get_parent_info_csr(p_change_request_group_id);
4041: fetch get_parent_info_csr into l_parent_item_type, l_parent_item_key;
4042: close get_parent_info_csr;
4043:
4044: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
4045: itemtype=>l_parent_item_type,
4046: itemkey=>l_parent_item_key,
4047: aname =>'RESPONDER_USER_NAME');
4048:

Line 4049: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

4045: itemtype=>l_parent_item_type,
4046: itemkey=>l_parent_item_key,
4047: aname =>'RESPONDER_USER_NAME');
4048:
4049: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4050: itemkey => l_parent_item_key,
4051: aname => 'USER_ID');
4052:
4053: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

Line 4053: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

4049: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4050: itemkey => l_parent_item_key,
4051: aname => 'USER_ID');
4052:
4053: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4054: itemkey => l_parent_item_key,
4055: aname => 'RESPONSIBILITY_ID');
4056:
4057: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

Line 4057: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

4053: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4054: itemkey => l_parent_item_key,
4055: aname => 'RESPONSIBILITY_ID');
4056:
4057: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4058: itemkey => l_parent_item_key,
4059: aname => 'APPLICATION_ID');
4060:
4061: StartPOChangeWF(p_change_request_group_id, item_key, 'INFORM_BUYER_PO_CHANGE', l_forward_from_username, l_user_id, l_responsibility_id, l_application_id);

Line 4170: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,

4166: t_varname(5) := 'PREPARER_DISPLAY_NAME';
4167: t_varval(5) := l_requester_display_name;
4168: t_varname(6) := 'REQ_CHANGE_RESPONSE_NOTIF_BODY';
4169: t_varval(6) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||to_char(p_change_request_group_id);
4170: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,
4171: itemkey=>p_old_item_key,
4172: aname =>'TOTAL_AMOUNT_DSP');
4173: l_functional_currency:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,
4174: itemkey=>p_old_item_key,

Line 4173: l_functional_currency:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,

4169: t_varval(6) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||to_char(p_change_request_group_id);
4170: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,
4171: itemkey=>p_old_item_key,
4172: aname =>'TOTAL_AMOUNT_DSP');
4173: l_functional_currency:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,
4174: itemkey=>p_old_item_key,
4175: aname =>'FUNCTIONAL_CURRENCY');
4176: t_varname(7) := 'TOTAL_AMOUNT_DSP';
4177: t_varval(7) := l_total_amount_dsp;

Line 4180: l_note := PO_WF_UTIL_PKG.GetItemAttrText

4176: t_varname(7) := 'TOTAL_AMOUNT_DSP';
4177: t_varval(7) := l_total_amount_dsp;
4178: t_varname(8) := 'FUNCTIONAL_CURRENCY';
4179: t_varval(8) := l_functional_currency;
4180: l_note := PO_WF_UTIL_PKG.GetItemAttrText
4181: (itemtype => item_type,
4182: itemkey => p_old_item_key,
4183: aname => 'JUSTIFICATION');
4184: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText

Line 4184: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText

4180: l_note := PO_WF_UTIL_PKG.GetItemAttrText
4181: (itemtype => item_type,
4182: itemkey => p_old_item_key,
4183: aname => 'JUSTIFICATION');
4184: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText
4185: (itemtype => item_type,
4186: itemkey => p_old_item_key,
4187: aname => 'REQ_AMOUNT_CURRENCY_DSP');
4188: l_new_amount_currency:= PO_WF_UTIL_PKG.GetItemAttrText

Line 4188: l_new_amount_currency:= PO_WF_UTIL_PKG.GetItemAttrText

4184: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText
4185: (itemtype => item_type,
4186: itemkey => p_old_item_key,
4187: aname => 'REQ_AMOUNT_CURRENCY_DSP');
4188: l_new_amount_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4189: (itemtype => item_type,
4190: itemkey => p_old_item_key,
4191: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP');
4192: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

Line 4192: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

4188: l_new_amount_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4189: (itemtype => item_type,
4190: itemkey => p_old_item_key,
4191: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP');
4192: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4193: (itemtype => item_type,
4194: itemkey => p_old_item_key,
4195: aname => 'TAX_AMOUNT_CURRENCY_DSP');
4196: l_new_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

Line 4196: l_new_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

4192: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4193: (itemtype => item_type,
4194: itemkey => p_old_item_key,
4195: aname => 'TAX_AMOUNT_CURRENCY_DSP');
4196: l_new_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4197: (itemtype => item_type,
4198: itemkey => p_old_item_key,
4199: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP');
4200: l_new_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText

Line 4200: l_new_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText

4196: l_new_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4197: (itemtype => item_type,
4198: itemkey => p_old_item_key,
4199: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP');
4200: l_new_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText
4201: (itemtype => item_type,
4202: itemkey => p_old_item_key,
4203: aname => 'NEW_TOTAL_AMOUNT_DSP');
4204:

Line 4562: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,

4558: x_amount_for_tax => l_amount_for_tax);
4559:
4560: x_progress :='StartPOChangeWF:009';
4561:
4562: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,
4563: itemkey => item_key,
4564: aname => 'TOTAL_AMOUNT_DSP',
4565: avalue => l_amount_for_subject);
4566:

Line 4567: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,

4563: itemkey => item_key,
4564: aname => 'TOTAL_AMOUNT_DSP',
4565: avalue => l_amount_for_subject);
4566:
4567: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,
4568: itemkey => item_key,
4569: aname => 'REQ_AMOUNT_CURRENCY_DSP',
4570: avalue => l_amount_for_header);
4571:

Line 4572: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,

4568: itemkey => item_key,
4569: aname => 'REQ_AMOUNT_CURRENCY_DSP',
4570: avalue => l_amount_for_header);
4571:
4572: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,
4573: itemkey => item_key,
4574: aname => 'TAX_AMOUNT_CURRENCY_DSP',
4575: avalue => l_amount_for_tax);
4576:

Line 4580: l_responder_user_id := nvl(PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,

4576:
4577: --Bug#5114191 : Set responsibility user id, resp id, appl id for
4578: -- processbuyer response wf from inform buyer wf.
4579:
4580: l_responder_user_id := nvl(PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4581: itemkey => l_inform_item_key,
4582: aname => 'RESPONDER_USER_ID'),
4583: fnd_global.user_id);
4584: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,

Line 4584: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,

4580: l_responder_user_id := nvl(PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4581: itemkey => l_inform_item_key,
4582: aname => 'RESPONDER_USER_ID'),
4583: fnd_global.user_id);
4584: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4585: itemkey => l_inform_item_key,
4586: aname => 'RESPONDER_RESP_ID'),
4587: fnd_global.resp_id);
4588: l_responder_appl_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,

Line 4588: l_responder_appl_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,

4584: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4585: itemkey => l_inform_item_key,
4586: aname => 'RESPONDER_RESP_ID'),
4587: fnd_global.resp_id);
4588: l_responder_appl_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4589: itemkey => l_inform_item_key,
4590: aname => 'RESPONDER_APPL_ID'),
4591: fnd_global.resp_appl_id);
4592:

Line 4603: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,

4599: END IF;
4600: END IF;
4601:
4602:
4603: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4604: itemkey => item_key,
4605: aname => 'RESPONDER_USER_ID',
4606: avalue => l_responder_user_id);
4607: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,

Line 4607: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,

4603: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4604: itemkey => item_key,
4605: aname => 'RESPONDER_USER_ID',
4606: avalue => l_responder_user_id);
4607: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4608: itemkey => item_key,
4609: aname => 'RESPONDER_RESP_ID',
4610: avalue => l_responder_resp_id);
4611: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,

Line 4611: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,

4607: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4608: itemkey => item_key,
4609: aname => 'RESPONDER_RESP_ID',
4610: avalue => l_responder_resp_id);
4611: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4612: itemkey => item_key,
4613: aname => 'RESPONDER_APPL_ID',
4614: avalue => l_responder_appl_id);
4615:

Line 4766: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

4762: return;
4763:
4764: end if;
4765:
4766: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4767: itemkey => itemkey,
4768: aname => 'DOCUMENT_ID');
4769:
4770: -- Set the multi-org context

Line 4771: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

4767: itemkey => itemkey,
4768: aname => 'DOCUMENT_ID');
4769:
4770: -- Set the multi-org context
4771: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4772: itemkey => itemkey,
4773: aname => 'ORG_ID');
4774:
4775: IF l_orgid is NOT NULL THEN

Line 4785: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

4781: open change_request_group_id;
4782: fetch change_request_group_id into l_change_request_group_id;
4783: close change_request_group_id;
4784:
4785: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
4786: itemkey => itemkey,
4787: aname => 'CHANGE_REQUEST_GROUP_ID',
4788: avalue => l_change_request_group_id);
4789:

Line 4790: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

4786: itemkey => itemkey,
4787: aname => 'CHANGE_REQUEST_GROUP_ID',
4788: avalue => l_change_request_group_id);
4789:
4790: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4791: itemkey => itemkey,
4792: aname => 'REQ_CHANGE_NOTIF_BODY',
4793: avalue =>
4794: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_approval_notif/'||

Line 4797: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

4793: avalue =>
4794: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_approval_notif/'||
4795: itemtype||':'||
4796: itemkey);
4797: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4798: itemkey => itemkey,
4799: aname => 'REQ_CHANGE_RESPONSE_NOTIF_BODY',
4800: avalue =>
4801: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||

Line 4805: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

4801: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||
4802: to_char(l_change_request_group_id));
4803:
4804: /*
4805: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4806: itemkey => itemkey,
4807: aname => 'NEW_AMOUNT_WITH_CURRENCY_D',
4808: avalue =>
4809: 'plsql:PO_ReqChangeRequestNotif_PVT.get_new_req_amount/'||itemtype||':'||itemkey);

Line 4865: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

4861:
4862: end if;
4863:
4864: -- Set the multi-org context
4865: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4866: itemkey => itemkey,
4867: aname => 'ORG_ID');
4868:
4869: IF l_orgid is NOT NULL THEN

Line 4875: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

4871: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4872:
4873: END IF;
4874:
4875: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
4876: itemtype => itemtype,
4877: itemkey => itemkey,
4878: aname => 'CHANGE_REQUEST_GROUP_ID');
4879:

Line 4880: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

4876: itemtype => itemtype,
4877: itemkey => itemkey,
4878: aname => 'CHANGE_REQUEST_GROUP_ID');
4879:
4880: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
4881: itemtype => itemtype,
4882: itemkey => itemkey,
4883: aname => 'DOCUMENT_ID');
4884:

Line 4954: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (

4950: resultout := wf_engine.eng_null;
4951: return;
4952: end if;
4953:
4954: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (
4955: itemtype => itemtype,
4956: itemkey => itemkey,
4957: aname => 'CHANGE_REQUEST_GROUP_ID');
4958:

Line 4965: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

4961: fetch change_request into l_employee_id;
4962: close change_request;
4963:
4964: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 03';
4965: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4966: itemkey => itemkey,
4967: aname => 'DOCUMENT_ID');
4968:
4969: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 4969: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

4965: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4966: itemkey => itemkey,
4967: aname => 'DOCUMENT_ID');
4968:
4969: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
4970: itemkey => itemkey,
4971: aname => 'DOCUMENT_TYPE');
4972:
4973: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 4973: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

4969: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
4970: itemkey => itemkey,
4971: aname => 'DOCUMENT_TYPE');
4972:
4973: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
4974: itemkey => itemkey,
4975: aname => 'DOCUMENT_SUBTYPE');
4976:
4977: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 04';

Line 4979: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

4975: aname => 'DOCUMENT_SUBTYPE');
4976:
4977: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 04';
4978: -- Set the multi-org context
4979: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4980: itemkey => itemkey,
4981: aname => 'ORG_ID');
4982:
4983: IF l_orgid is NOT NULL THEN

Line 4987: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

4983: IF l_orgid is NOT NULL THEN
4984: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4985: END IF;
4986:
4987: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4988: itemkey => itemkey,
4989: aname => 'NOTE');
4990:
4991:

Line 5078: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

5074: resultout := wf_engine.eng_null;
5075: return;
5076: end if;
5077:
5078: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
5079: itemtype => itemtype,
5080: itemkey => itemkey,
5081: aname => 'CHANGE_REQUEST_GROUP_ID');
5082:

Line 5145: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5141: resultout := wf_engine.eng_null;
5142: return;
5143: end if;
5144:
5145: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5146: itemkey => itemkey,
5147: aname => 'CHANGE_REQUEST_GROUP_ID');
5148:
5149:

Line 5208: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

5204: resultout := wf_engine.eng_null;
5205: return;
5206: end if;
5207:
5208: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
5209: itemtype => itemtype,
5210: itemkey => itemkey,
5211: aname => 'CHANGE_REQUEST_GROUP_ID');
5212:

Line 5269: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5265: return;
5266:
5267: end if;
5268:
5269: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5270: itemkey => itemkey,
5271: aname => 'CHANGE_REQUEST_GROUP_ID');
5272:
5273:

Line 5337: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5333:
5334: end if;
5335:
5336:
5337: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5338: itemkey => itemkey,
5339: aname => 'CHANGE_REQUEST_GROUP_ID');
5340:
5341: -- Set the multi-org context

Line 5342: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5338: itemkey => itemkey,
5339: aname => 'CHANGE_REQUEST_GROUP_ID');
5340:
5341: -- Set the multi-org context
5342: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5343: itemkey => itemkey,
5344: aname => 'ORG_ID');
5345:
5346: IF l_orgid is NOT NULL THEN

Line 5394: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

5390: IS
5391: x_progress varchar2(3) := '000';
5392: BEGIN
5393:
5394: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
5395: itemkey => itemkey,
5396: aname => 'REMINDER_COUNTER',
5397: avalue => 0);
5398: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

Line 5425: l_reminder_counter:= PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

5421: x_progress varchar2(3) := '000';
5422: l_max_reminder number;
5423: BEGIN
5424:
5425: l_reminder_counter:= PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
5426: itemkey => itemkey,
5427: aname => 'REMINDER_COUNTER');
5428: l_max_reminder := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
5429: itemkey => itemkey,

Line 5428: l_max_reminder := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

5424:
5425: l_reminder_counter:= PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
5426: itemkey => itemkey,
5427: aname => 'REMINDER_COUNTER');
5428: l_max_reminder := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
5429: itemkey => itemkey,
5430: aname => 'MAX_REMINDER_MSG_COUNT');
5431:
5432: if(l_reminder_counter=l_max_reminder) then

Line 5441: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

5437: itemkey => itemkey,
5438: aname => 'REMINDER_COUNTER',
5439: avalue => l_reminder_counter+1);
5440: if(l_reminder_counter=l_max_reminder-1) then
5441: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5442: itemkey => itemkey,
5443: aname => 'REMINDER_MSG',
5444: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_REMINDER')||':');
5445: elsif(l_reminder_counter=1) then

Line 5446: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

5442: itemkey => itemkey,
5443: aname => 'REMINDER_MSG',
5444: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_REMINDER')||':');
5445: elsif(l_reminder_counter=1) then
5446: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5447: itemkey => itemkey,
5448: aname => 'REMINDER_MSG',
5449: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_FIRST_REMINDER')||':');
5450: elsif(l_reminder_counter=2) then

Line 5451: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

5447: itemkey => itemkey,
5448: aname => 'REMINDER_MSG',
5449: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_FIRST_REMINDER')||':');
5450: elsif(l_reminder_counter=2) then
5451: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5452: itemkey => itemkey,
5453: aname => 'REMINDER_MSG',
5454: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_SECOND_REMINDER')||':');
5455: else

Line 5456: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

5452: itemkey => itemkey,
5453: aname => 'REMINDER_MSG',
5454: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_SECOND_REMINDER')||':');
5455: else
5456: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5457: itemkey => itemkey,
5458: aname => 'REMINDER_MSG',
5459: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_REMINDER')||' '||to_char(l_reminder_counter)||':');
5460: end if;

Line 5507: l_ActionOriginatedFrom := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

5503: resultout := wf_engine.eng_null;
5504: return;
5505:
5506: end if;
5507: l_ActionOriginatedFrom := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
5508: itemkey => itemkey,
5509: aname => 'INTERFACE_SOURCE_CODE');
5510:
5511:

Line 5573: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5569: return;
5570:
5571: end if;
5572:
5573: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5574: itemkey => itemkey,
5575: aname => 'CHANGE_REQUEST_GROUP_ID');
5576:
5577: -- Set the multi-org context

Line 5578: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5574: itemkey => itemkey,
5575: aname => 'CHANGE_REQUEST_GROUP_ID');
5576:
5577: -- Set the multi-org context
5578: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5579: itemkey => itemkey,
5580: aname => 'ORG_ID');
5581:
5582: IF l_orgid is NOT NULL THEN

Line 5757: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5753: END IF;
5754:
5755: IF (funcmode='RUN') THEN
5756:
5757: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5758: itemkey => itemkey,
5759: aname => 'DOCUMENT_ID');
5760:
5761: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 5761: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

5757: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5758: itemkey => itemkey,
5759: aname => 'DOCUMENT_ID');
5760:
5761: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5762: itemkey => itemkey,
5763: aname => 'DOCUMENT_TYPE');
5764:
5765: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 5765: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

5761: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5762: itemkey => itemkey,
5763: aname => 'DOCUMENT_TYPE');
5764:
5765: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5766: itemkey => itemkey,
5767: aname => 'DOCUMENT_SUBTYPE');
5768:
5769: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 5769: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5765: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5766: itemkey => itemkey,
5767: aname => 'DOCUMENT_SUBTYPE');
5768:
5769: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5770: itemkey => itemkey,
5771: aname => 'CHANGE_REQUEST_GROUP_ID');
5772:
5773: -- Set the multi-org context

Line 5774: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5770: itemkey => itemkey,
5771: aname => 'CHANGE_REQUEST_GROUP_ID');
5772:
5773: -- Set the multi-org context
5774: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5775: itemkey => itemkey,
5776: aname => 'ORG_ID');
5777:
5778: IF l_org_id is NOT NULL THEN

Line 5910: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5906: l_progress := 'Update_Action_History_Return: 001';
5907:
5908: IF (funcmode='RUN') THEN
5909:
5910: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5911: itemkey => itemkey,
5912: aname => 'DOCUMENT_ID');
5913:
5914: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 5914: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

5910: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5911: itemkey => itemkey,
5912: aname => 'DOCUMENT_ID');
5913:
5914: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5915: itemkey => itemkey,
5916: aname => 'DOCUMENT_TYPE');
5917:
5918: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 5918: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

5914: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5915: itemkey => itemkey,
5916: aname => 'DOCUMENT_TYPE');
5917:
5918: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5919: itemkey => itemkey,
5920: aname => 'DOCUMENT_SUBTYPE');
5921:
5922: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 5922: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

5918: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5919: itemkey => itemkey,
5920: aname => 'DOCUMENT_SUBTYPE');
5921:
5922: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
5923: itemkey => itemkey,
5924: aname => 'NOTE');
5925:
5926: -- Set the multi-org context

Line 5928: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5924: aname => 'NOTE');
5925:
5926: -- Set the multi-org context
5927:
5928: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5929: itemkey => itemkey,
5930: aname => 'ORG_ID');
5931:
5932: IF l_org_id is NOT NULL THEN

Line 5990: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

5986: temp number;
5987: l_error_code varchar2(200);
5988:
5989: begin
5990: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5991: itemkey => itemkey,
5992: aname => 'CHANGE_REQUEST_GROUP_ID');
5993:
5994: ConvertIntoPOChange(l_change_request_group_id);

Line 6058: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6054:
6055: end if;
6056:
6057: -- Set the multi-org context
6058: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6059: itemkey => itemkey,
6060: aname => 'ORG_ID');
6061:
6062: IF l_orgid is NOT NULL THEN

Line 6068: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6064: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6065:
6066: END IF;
6067:
6068: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6069: itemkey => itemkey,
6070: aname => 'CHANGE_REQUEST_GROUP_ID');
6071:
6072: open child_request_group_id;

Line 6138: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6134:
6135: end if;
6136:
6137: -- Set the multi-org context
6138: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6139: itemkey => itemkey,
6140: aname => 'ORG_ID');
6141:
6142: IF l_orgid is NOT NULL THEN

Line 6148: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6144: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6145:
6146: END IF;
6147:
6148: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6149: itemkey => itemkey,
6150: aname => 'CHANGE_REQUEST_GROUP_ID');
6151:
6152: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 6152: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6148: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6149: itemkey => itemkey,
6150: aname => 'CHANGE_REQUEST_GROUP_ID');
6151:
6152: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6153: itemkey => itemkey,
6154: aname => 'DOCUMENT_ID');
6155:
6156: SetReqChangeFlag(l_change_request_group_id, l_document_id, itemtype, itemkey, 'N');

Line 6209: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6205:
6206: end if;
6207:
6208: -- Set the multi-org context
6209: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6210: itemkey => itemkey,
6211: aname => 'ORG_ID');
6212:
6213: IF l_orgid is NOT NULL THEN

Line 6244: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber

6240: l_tax_amount_disp varchar2(60);
6241: l_total_amount_disp varchar2(60);
6242:
6243: begin
6244: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber
6245: (itemtype => itemtype,
6246: itemkey => itemkey,
6247: aname => 'CHANGE_REQUEST_GROUP_ID');
6248: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 6248: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6244: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber
6245: (itemtype => itemtype,
6246: itemkey => itemkey,
6247: aname => 'CHANGE_REQUEST_GROUP_ID');
6248: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6249: itemkey => itemkey,
6250: aname => 'DOCUMENT_ID');
6251:
6252: l_currency_code := PO_WF_UTIL_PKG.GetItemAttrText

Line 6252: l_currency_code := PO_WF_UTIL_PKG.GetItemAttrText

6248: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6249: itemkey => itemkey,
6250: aname => 'DOCUMENT_ID');
6251:
6252: l_currency_code := PO_WF_UTIL_PKG.GetItemAttrText
6253: (itemtype => itemtype,
6254: itemkey => itemkey,
6255: aname => 'FUNCTIONAL_CURRENCY');
6256:

Line 6357: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

6353: x_amount_for_header => l_amount_for_header,
6354: x_amount_for_tax => l_amount_for_tax);
6355:
6356:
6357: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
6358: itemkey=> itemkey,
6359: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP',
6360: avalue => l_amount_for_header);
6361:

Line 6362: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

6358: itemkey=> itemkey,
6359: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP',
6360: avalue => l_amount_for_header);
6361:
6362: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
6363: itemkey=> itemkey,
6364: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP',
6365: avalue => l_amount_for_tax);
6366: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

Line 6366: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

6362: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
6363: itemkey=> itemkey,
6364: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP',
6365: avalue => l_amount_for_tax);
6366: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
6367: itemkey=> itemkey,
6368: aname => 'NEW_TOTAL_AMOUNT_DSP',
6369: avalue => l_amount_for_subject);
6370: x_progress :='004';

Line 6415: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6411: resultout := wf_engine.eng_null;
6412: return;
6413: end if;
6414:
6415: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6416: itemkey => itemkey,
6417: aname => 'DOCUMENT_ID');
6418:
6419: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 6419: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

6415: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6416: itemkey => itemkey,
6417: aname => 'DOCUMENT_ID');
6418:
6419: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6420: itemkey => itemkey,
6421: aname => 'DOCUMENT_TYPE');
6422:
6423: -- Set the multi-org context

Line 6424: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6420: itemkey => itemkey,
6421: aname => 'DOCUMENT_TYPE');
6422:
6423: -- Set the multi-org context
6424: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6425: itemkey => itemkey,
6426: aname => 'ORG_ID');
6427:
6428: IF l_orgid is NOT NULL THEN

Line 6513: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6509: resultout := wf_engine.eng_null;
6510: return;
6511: end if;
6512:
6513: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6514: itemkey => itemkey,
6515: aname => 'DOCUMENT_ID');
6516:
6517: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 6517: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

6513: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6514: itemkey => itemkey,
6515: aname => 'DOCUMENT_ID');
6516:
6517: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6518: itemkey => itemkey,
6519: aname => 'DOCUMENT_TYPE');
6520:
6521: -- Set the multi-org context

Line 6522: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6518: itemkey => itemkey,
6519: aname => 'DOCUMENT_TYPE');
6520:
6521: -- Set the multi-org context
6522: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6523: itemkey => itemkey,
6524: aname => 'ORG_ID');
6525:
6526: IF l_orgid is NOT NULL THEN

Line 6596: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6592: return;
6593:
6594: end if;
6595:
6596: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6597: itemkey => itemkey,
6598: aname => 'DOCUMENT_ID');
6599:
6600: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 6600: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

6596: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6597: itemkey => itemkey,
6598: aname => 'DOCUMENT_ID');
6599:
6600: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6601: itemkey => itemkey,
6602: aname => 'DOCUMENT_TYPE');
6603: l_old_doc_revision := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
6604: itemkey => itemkey,

Line 6603: l_old_doc_revision := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

6599:
6600: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6601: itemkey => itemkey,
6602: aname => 'DOCUMENT_TYPE');
6603: l_old_doc_revision := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
6604: itemkey => itemkey,
6605: aname => 'DOCUMENT_REVISION_NUM');
6606: -- Set the multi-org context
6607: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 6607: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6603: l_old_doc_revision := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
6604: itemkey => itemkey,
6605: aname => 'DOCUMENT_REVISION_NUM');
6606: -- Set the multi-org context
6607: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6608: itemkey => itemkey,
6609: aname => 'ORG_ID');
6610:
6611: IF l_orgid is NOT NULL THEN

Line 6691: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

6687: resultout := wf_engine.eng_null;
6688: return;
6689: end if;
6690:
6691: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
6692: itemtype => itemtype,
6693: itemkey => itemkey,
6694: aname => 'CHANGE_REQUEST_GROUP_ID');
6695:

Line 6696: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6692: itemtype => itemtype,
6693: itemkey => itemkey,
6694: aname => 'CHANGE_REQUEST_GROUP_ID');
6695:
6696: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6697: itemkey => itemkey,
6698: aname => 'ORG_ID');
6699: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
6700: itemkey => itemkey,

Line 6699: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

6695:
6696: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6697: itemkey => itemkey,
6698: aname => 'ORG_ID');
6699: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
6700: itemkey => itemkey,
6701: aname => 'RESPONSE_REASON');
6702:
6703: IF l_orgid is NOT NULL THEN

Line 6764: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

6760: resultout := wf_engine.eng_null;
6761: return;
6762: end if;
6763:
6764: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
6765: itemtype => itemtype,
6766: itemkey => itemkey,
6767: aname => 'CHANGE_REQUEST_GROUP_ID');
6768:

Line 6769: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

6765: itemtype => itemtype,
6766: itemkey => itemkey,
6767: aname => 'CHANGE_REQUEST_GROUP_ID');
6768:
6769: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
6770: itemkey => itemkey,
6771: aname => 'RESPONSE_REASON');
6772:
6773: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 6773: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6769: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
6770: itemkey => itemkey,
6771: aname => 'RESPONSE_REASON');
6772:
6773: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6774: itemkey => itemkey,
6775: aname => 'ORG_ID');
6776:
6777: IF l_orgid is NOT NULL THEN

Line 6836: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

6832: resultout := wf_engine.eng_null;
6833: return;
6834: end if;
6835:
6836: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
6837: itemtype => itemtype,
6838: itemkey => itemkey,
6839: aname => 'CHANGE_REQUEST_GROUP_ID');
6840:

Line 6842: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6838: itemkey => itemkey,
6839: aname => 'CHANGE_REQUEST_GROUP_ID');
6840:
6841: -- Set the multi-org context
6842: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6843: itemkey => itemkey,
6844: aname => 'ORG_ID');
6845:
6846: IF l_orgid is NOT NULL THEN

Line 6918: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (

6914: resultout := wf_engine.eng_null;
6915: return;
6916: end if;
6917:
6918: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (
6919: itemtype => itemtype,
6920: itemkey => itemkey,
6921: aname => 'CHANGE_REQUEST_GROUP_ID');
6922:

Line 6942: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6938: else
6939: l_action:='RESPOND';
6940: end if;
6941:
6942: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6943: itemkey => itemkey,
6944: aname => 'DOCUMENT_ID');
6945:
6946: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 6946: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

6942: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6943: itemkey => itemkey,
6944: aname => 'DOCUMENT_ID');
6945:
6946: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6947: itemkey => itemkey,
6948: aname => 'DOCUMENT_TYPE');
6949:
6950: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 6950: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

6946: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6947: itemkey => itemkey,
6948: aname => 'DOCUMENT_TYPE');
6949:
6950: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6951: itemkey => itemkey,
6952: aname => 'DOCUMENT_SUBTYPE');
6953:
6954: -- Set the multi-org context

Line 6955: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

6951: itemkey => itemkey,
6952: aname => 'DOCUMENT_SUBTYPE');
6953:
6954: -- Set the multi-org context
6955: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6956: itemkey => itemkey,
6957: aname => 'ORG_ID');
6958:
6959: IF l_orgid is NOT NULL THEN

Line 7044: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

7040: return;
7041: end if;
7042:
7043:
7044: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
7045: itemtype => itemtype,
7046: itemkey => itemkey,
7047: aname => 'CHANGE_REQUEST_GROUP_ID');
7048:

Line 7050: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7046: itemkey => itemkey,
7047: aname => 'CHANGE_REQUEST_GROUP_ID');
7048:
7049: -- Set the multi-org context
7050: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7051: itemkey => itemkey,
7052: aname => 'ORG_ID');
7053:
7054: IF l_orgid is NOT NULL THEN

Line 7120: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7116: resultout := wf_engine.eng_null;
7117: return;
7118: end if;
7119:
7120: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7121: itemkey => itemkey,
7122: aname => 'CHANGE_REQUEST_GROUP_ID');
7123: /* Bug#3769157 : Set the responsibility and application id of the preparer
7124: if null(happens when notification responded by buyer from worklist) */

Line 7127: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7123: /* Bug#3769157 : Set the responsibility and application id of the preparer
7124: if null(happens when notification responded by buyer from worklist) */
7125:
7126: if( (nvl(l_responsibility_id, -1) <0) or (nvl(l_application_id, -1) < 0) ) then
7127: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7128: itemkey => itemkey,
7129: aname => 'RESPONSIBILITY_ID');
7130:
7131: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 7131: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7127: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7128: itemkey => itemkey,
7129: aname => 'RESPONSIBILITY_ID');
7130:
7131: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7132: itemkey => itemkey,
7133: aname => 'APPLICATION_ID');
7134:
7135: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);

Line 7141: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7137: end if;
7138:
7139:
7140: -- Set the multi-org context
7141: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7142: itemkey => itemkey,
7143: aname => 'ORG_ID');
7144:
7145: IF l_orgid is NOT NULL THEN

Line 7208: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7204: resultout := wf_engine.eng_null;
7205: return;
7206: end if;
7207:
7208: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7209: itemkey => itemkey,
7210: aname => 'CHANGE_REQUEST_GROUP_ID');
7211:
7212: -- Set the multi-org context

Line 7213: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7209: itemkey => itemkey,
7210: aname => 'CHANGE_REQUEST_GROUP_ID');
7211:
7212: -- Set the multi-org context
7213: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7214: itemkey => itemkey,
7215: aname => 'ORG_ID');
7216:
7217: IF l_orgid is NOT NULL THEN

Line 7288: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7284:
7285: end if;
7286:
7287:
7288: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7289: itemkey => itemkey,
7290: aname => 'CHANGE_REQUEST_GROUP_ID');
7291:
7292: -- Set the multi-org context

Line 7293: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7289: itemkey => itemkey,
7290: aname => 'CHANGE_REQUEST_GROUP_ID');
7291:
7292: -- Set the multi-org context
7293: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7294: itemkey => itemkey,
7295: aname => 'ORG_ID');
7296:
7297: IF l_orgid is NOT NULL THEN

Line 7408: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7404:
7405: end if;
7406:
7407:
7408: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7409: itemkey => itemkey,
7410: aname => 'CHANGE_REQUEST_GROUP_ID');
7411:
7412: -- Set the multi-org context

Line 7413: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7409: itemkey => itemkey,
7410: aname => 'CHANGE_REQUEST_GROUP_ID');
7411:
7412: -- Set the multi-org context
7413: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7414: itemkey => itemkey,
7415: aname => 'ORG_ID');
7416:
7417: IF l_orgid is NOT NULL THEN

Line 7533: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7529: resultout := wf_engine.eng_null;
7530: return;
7531: end if;
7532:
7533: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7534: itemkey => itemkey,
7535: aname => 'CHANGE_REQUEST_GROUP_ID');
7536:
7537: -- Set the multi-org context

Line 7538: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7534: itemkey => itemkey,
7535: aname => 'CHANGE_REQUEST_GROUP_ID');
7536:
7537: -- Set the multi-org context
7538: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7539: itemkey => itemkey,
7540: aname => 'ORG_ID');
7541:
7542: IF l_orgid is NOT NULL THEN

Line 7610: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

7606:
7607: end if;
7608:
7609: -- Set the multi-org context
7610: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
7611: itemkey => itemkey,
7612: aname => 'ORG_ID' );
7613:
7614: IF l_orgid is NOT NULL THEN

Line 7620: l_req_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

7616: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7617:
7618: END IF;
7619:
7620: l_req_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
7621: itemtype => itemtype,
7622: itemkey => itemkey,
7623: aname => 'REQ_CHANGE_GROUP_ID');
7624:

Line 7625: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

7621: itemtype => itemtype,
7622: itemkey => itemkey,
7623: aname => 'REQ_CHANGE_GROUP_ID');
7624:
7625: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
7626: itemtype => itemtype,
7627: itemkey => itemkey,
7628: aname => 'REQ_HEADER_ID');
7629:

Line 7710: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

7706: return;
7707: end if;
7708:
7709: -- Set the multi-org context
7710: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7711: itemkey => itemkey,
7712: aname => 'ORG_ID');
7713:
7714: IF l_orgid is NOT NULL THEN

Line 7720: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber

7716: END IF;
7717:
7718: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 02';
7719:
7720: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber
7721: (itemtype => itemtype,
7722: itemkey => itemkey,
7723: aname => 'REQ_CHANGE_GROUP_ID');
7724:

Line 7755: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,

7751: if ( l_rco_wf_available = 'Y') then
7752:
7753: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 04:' || l_req_item_type || '-' || l_req_item_key;
7754:
7755: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
7756: itemkey=>l_req_item_key,
7757: aname =>'TOTAL_AMOUNT_DSP');
7758:
7759: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 05:';

Line 7761: l_functional_currency:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,

7757: aname =>'TOTAL_AMOUNT_DSP');
7758:
7759: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 05:';
7760:
7761: l_functional_currency:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
7762: itemkey=>l_req_item_key,
7763: aname =>'FUNCTIONAL_CURRENCY');
7764:
7765: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 06:';

Line 7767: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

7763: aname =>'FUNCTIONAL_CURRENCY');
7764:
7765: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 06:';
7766:
7767: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
7768: (itemtype => l_req_item_type,
7769: itemkey => l_req_item_key,
7770: aname => 'DOCUMENT_ID');
7771:

Line 7772: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,

7768: (itemtype => l_req_item_type,
7769: itemkey => l_req_item_key,
7770: aname => 'DOCUMENT_ID');
7771:
7772: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
7773: itemkey=>l_req_item_key,
7774: aname =>'IS_AME_APPROVAL');
7775:
7776: l_contractor_req_flag:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,

Line 7776: l_contractor_req_flag:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,

7772: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
7773: itemkey=>l_req_item_key,
7774: aname =>'IS_AME_APPROVAL');
7775:
7776: l_contractor_req_flag:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
7777: itemkey=>l_req_item_key,
7778: aname =>'CONTRACTOR_REQUISITION_FLAG');
7779:
7780: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber

Line 7780: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber

7776: l_contractor_req_flag:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
7777: itemkey=>l_req_item_key,
7778: aname =>'CONTRACTOR_REQUISITION_FLAG');
7779:
7780: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber
7781: (itemtype => l_req_item_type,
7782: itemkey => l_req_item_key,
7783: aname => 'CHANGE_REQUEST_GROUP_ID');
7784:

Line 7785: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

7781: (itemtype => l_req_item_type,
7782: itemkey => l_req_item_key,
7783: aname => 'CHANGE_REQUEST_GROUP_ID');
7784:
7785: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
7786: itemkey => itemkey,
7787: aname => 'IS_AME_APPROVAL',
7788: avalue => l_is_ame_approval);
7789:

Line 7790: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

7786: itemkey => itemkey,
7787: aname => 'IS_AME_APPROVAL',
7788: avalue => l_is_ame_approval);
7789:
7790: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
7791: itemkey => itemkey,
7792: aname => 'CONTRACTOR_REQUISITION_FLAG',
7793: avalue => l_contractor_req_flag);
7794:

Line 7800: l_note := PO_WF_UTIL_PKG.GetItemAttrText

7796: t_varval(1) := l_total_amount_dsp;
7797: t_varname(2) := 'FUNCTIONAL_CURRENCY';
7798: t_varval(2) := l_functional_currency;
7799:
7800: l_note := PO_WF_UTIL_PKG.GetItemAttrText
7801: (itemtype => l_req_item_type,
7802: itemkey => l_req_item_key,
7803: aname => 'JUSTIFICATION');
7804:

Line 7805: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText

7801: (itemtype => l_req_item_type,
7802: itemkey => l_req_item_key,
7803: aname => 'JUSTIFICATION');
7804:
7805: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText
7806: ( itemtype => l_req_item_type,
7807: itemkey => l_req_item_key,
7808: aname => 'REQ_AMOUNT_CURRENCY_DSP');
7809:

Line 7810: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

7806: ( itemtype => l_req_item_type,
7807: itemkey => l_req_item_key,
7808: aname => 'REQ_AMOUNT_CURRENCY_DSP');
7809:
7810: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
7811: ( itemtype => l_req_item_type,
7812: itemkey => l_req_item_key,
7813: aname => 'TAX_AMOUNT_CURRENCY_DSP');
7814:

Line 7858: l_preparer_display_name := PO_WF_UTIL_PKG.GetItemAttrText

7854: x_amount_for_subject => l_amount_for_subject,
7855: x_amount_for_header => l_amount_for_header,
7856: x_amount_for_tax => l_amount_for_tax);
7857:
7858: l_preparer_display_name := PO_WF_UTIL_PKG.GetItemAttrText
7859: ( itemtype => l_req_item_type,
7860: itemkey => l_req_item_key,
7861: aname => 'PREPARER_DISPLAY_NAME' );
7862:

Line 7863: l_preparer_user_name := PO_WF_UTIL_PKG.GetItemAttrText

7859: ( itemtype => l_req_item_type,
7860: itemkey => l_req_item_key,
7861: aname => 'PREPARER_DISPLAY_NAME' );
7862:
7863: l_preparer_user_name := PO_WF_UTIL_PKG.GetItemAttrText
7864: ( itemtype => l_req_item_type,
7865: itemkey => l_req_item_key,
7866: aname => 'PREPARER_USER_NAME' );
7867:

Line 7904: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

7900: INTO l_document_id
7901: FROM po_change_requests pcr
7902: WHERE pcr.change_request_group_id = l_req_change_group_id and rownum=1;
7903:
7904: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
7905: itemkey => itemkey,
7906: aname => 'REQ_HEADER_ID',
7907: avalue => l_document_id);
7908:

Line 8056: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8052:
8053: end if;
8054:
8055:
8056: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8057: itemkey => itemkey,
8058: aname => 'CHANGE_REQUEST_GROUP_ID');
8059:
8060: -- Set the multi-org context

Line 8061: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8057: itemkey => itemkey,
8058: aname => 'CHANGE_REQUEST_GROUP_ID');
8059:
8060: -- Set the multi-org context
8061: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8062: itemkey => itemkey,
8063: aname => 'ORG_ID');
8064:
8065: IF l_orgid is NOT NULL THEN

Line 8171: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

8167: where pcr.change_request_group_id=l_change_request_group_id
8168: and pcr.document_header_id=por.requisition_header_id;
8169:
8170: BEGIN
8171: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8172: itemkey => itemkey,
8173: aname => 'DOCUMENT_ID');
8174: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8175: itemkey => itemkey,

Line 8174: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

8170: BEGIN
8171: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8172: itemkey => itemkey,
8173: aname => 'DOCUMENT_ID');
8174: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8175: itemkey => itemkey,
8176: aname => 'DOCUMENT_TYPE');
8177:
8178: if (l_document_type = 'RELEASE' ) then

Line 8192: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

8188: close l_get_group_id_po_csr;
8189: l_document_subtype := 'STANDARD';
8190: end if;
8191:
8192: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8193: itemkey => itemkey,
8194: aname => 'DOCUMENT_SUBTYPE',
8195: avalue =>l_document_subtype);
8196:

Line 8197: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,

8193: itemkey => itemkey,
8194: aname => 'DOCUMENT_SUBTYPE',
8195: avalue =>l_document_subtype);
8196:
8197: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
8198: itemkey => itemkey,
8199: aname => 'CHANGE_REQUEST_GROUP_ID',
8200: avalue => l_change_request_group_id);
8201:

Line 8212: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

8208: close change_request;
8209:
8210: PO_REQAPPROVAL_INIT1.get_user_name(l_requester_id, l_requester_name, l_requester_display_name);
8211:
8212: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8213: itemkey => itemkey,
8214: aname => 'PREPARER_USER_NAME',
8215: avalue =>l_requester_name);
8216:

Line 8217: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

8213: itemkey => itemkey,
8214: aname => 'PREPARER_USER_NAME',
8215: avalue =>l_requester_name);
8216:
8217: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8218: itemkey => itemkey,
8219: aname => 'REQ_CHANGE_RESPONSE_NOTIF_BODY',
8220: avalue =>
8221: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||

Line 8274: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8270: resultout := wf_engine.eng_null;
8271: return;
8272: end if;
8273:
8274: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8275: itemkey => itemkey,
8276: aname => 'CHANGE_REQUEST_GROUP_ID');
8277:
8278: -- Set the multi-org context

Line 8279: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8275: itemkey => itemkey,
8276: aname => 'CHANGE_REQUEST_GROUP_ID');
8277:
8278: -- Set the multi-org context
8279: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8280: itemkey => itemkey,
8281: aname => 'ORG_ID');
8282:
8283: IF l_orgid is NOT NULL THEN

Line 8294: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

8290: fetch new_change into l_change_request_id;
8291: close new_change;
8292:
8293: if(l_change_request_id is null) then
8294: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8295: itemkey => itemkey,
8296: aname => 'DOCUMENT_ID');
8297: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8298: itemkey => itemkey,

Line 8297: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

8293: if(l_change_request_id is null) then
8294: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8295: itemkey => itemkey,
8296: aname => 'DOCUMENT_ID');
8297: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8298: itemkey => itemkey,
8299: aname => 'DOCUMENT_TYPE');
8300:
8301: --Moved the update to po_headers/po_releases to an autonomous transaction procedure UpdatePODocheaderTables

Line 8360: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8356:
8357: end if;
8358:
8359:
8360: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8361: itemkey => itemkey,
8362: aname => 'CHANGE_REQUEST_GROUP_ID');
8363:
8364: -- Set the multi-org context

Line 8365: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8361: itemkey => itemkey,
8362: aname => 'CHANGE_REQUEST_GROUP_ID');
8363:
8364: -- Set the multi-org context
8365: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8366: itemkey => itemkey,
8367: aname => 'ORG_ID');
8368:
8369: IF l_orgid is NOT NULL THEN

Line 8426: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8422:
8423: end if;
8424:
8425:
8426: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8427: itemkey => itemkey,
8428: aname => 'CHANGE_REQUEST_GROUP_ID');
8429:
8430: -- Set the multi-org context

Line 8431: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8427: itemkey => itemkey,
8428: aname => 'CHANGE_REQUEST_GROUP_ID');
8429:
8430: -- Set the multi-org context
8431: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8432: itemkey => itemkey,
8433: aname => 'ORG_ID');
8434:
8435: IF l_orgid is NOT NULL THEN

Line 8495: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8491:
8492: end if;
8493:
8494:
8495: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8496: itemkey => itemkey,
8497: aname => 'CHANGE_REQUEST_GROUP_ID');
8498:
8499: -- Set the multi-org context

Line 8500: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

8496: itemkey => itemkey,
8497: aname => 'CHANGE_REQUEST_GROUP_ID');
8498:
8499: -- Set the multi-org context
8500: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8501: itemkey => itemkey,
8502: aname => 'ORG_ID');
8503:
8504: IF l_orgid is NOT NULL THEN

Line 8561: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

8557: and initiator='REQUESTER'
8558: and document_type='RELEASE';
8559: BEGIN
8560:
8561: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8562: itemkey => itemkey,
8563: aname => 'DOCUMENT_ID');
8564: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8565: itemkey => itemkey,

Line 8564: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

8560:
8561: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8562: itemkey => itemkey,
8563: aname => 'DOCUMENT_ID');
8564: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8565: itemkey => itemkey,
8566: aname => 'DOCUMENT_TYPE');
8567:
8568: if(l_document_type = 'RELEASE') then

Line 8612: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

8608: l_seq number;
8609: l_item_key varchar2(240);
8610: x_progress varchar2(3) := '000';
8611: BEGIN
8612: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8613: itemkey => itemkey,
8614: aname => 'DOCUMENT_ID');
8615: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8616: itemkey => itemkey,

Line 8615: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

8611: BEGIN
8612: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8613: itemkey => itemkey,
8614: aname => 'DOCUMENT_ID');
8615: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8616: itemkey => itemkey,
8617: aname => 'DOCUMENT_TYPE');
8618:
8619: select PO_REQUESTER_CHANGE_WF_S.nextval into l_seq from dual;

Line 8626: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

8622: l_item_key := 'RC_REL'||'-'||l_document_id||'-'||l_seq;
8623: else
8624: l_item_key := 'RC_PO'||'-'||l_document_id||'-'||l_seq;
8625: end if;
8626: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8627: itemkey => itemkey,
8628: aname => 'REQ_CHANGE_EVENT_KEY',
8629: avalue => l_item_key );
8630:

Line 8774: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_wf_item_type,

8770: -- workflow to convert the change request.
8771: begin
8772: wf_engine.abortprocess(l_wf_item_type, l_wf_item_key);
8773:
8774: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_wf_item_type,
8775: itemkey => l_wf_item_key,
8776: aname => 'NOTE');
8777:
8778: PO_APPROVAL_LIST_HISTORY_SV.Update_Action_History(

Line 8959: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(

8955: open get_parent_info_csr(p_change_request_group_id);
8956: fetch get_parent_info_csr into l_parent_item_type, l_parent_item_key;
8957: close get_parent_info_csr;
8958:
8959: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
8960: itemtype=>l_parent_item_type,
8961: itemkey=>l_parent_item_key,
8962: aname =>'RESPONDER_USER_NAME');
8963: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

Line 8963: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

8959: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
8960: itemtype=>l_parent_item_type,
8961: itemkey=>l_parent_item_key,
8962: aname =>'RESPONDER_USER_NAME');
8963: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
8964: itemkey => l_parent_item_key,
8965: aname => 'USER_ID');
8966:
8967: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

Line 8967: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

8963: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
8964: itemkey => l_parent_item_key,
8965: aname => 'USER_ID');
8966:
8967: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
8968: itemkey => l_parent_item_key,
8969: aname => 'RESPONSIBILITY_ID');
8970: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
8971: itemkey => l_parent_item_key,

Line 8970: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

8966:
8967: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
8968: itemkey => l_parent_item_key,
8969: aname => 'RESPONSIBILITY_ID');
8970: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
8971: itemkey => l_parent_item_key,
8972: aname => 'APPLICATION_ID');
8973:
8974:

Line 9159: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(

9155: END IF;
9156:
9157: if ( l_parent_wf_available = 'Y') then
9158:
9159: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
9160: itemtype=>l_parent_item_type,
9161: itemkey=>l_parent_item_key,
9162: aname =>'RESPONDER_USER_NAME');
9163:

Line 9164: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

9160: itemtype=>l_parent_item_type,
9161: itemkey=>l_parent_item_key,
9162: aname =>'RESPONDER_USER_NAME');
9163:
9164: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9165: itemkey => l_parent_item_key,
9166: aname => 'USER_ID');
9167:
9168: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

Line 9168: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

9164: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9165: itemkey => l_parent_item_key,
9166: aname => 'USER_ID');
9167:
9168: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9169: itemkey => l_parent_item_key,
9170: aname => 'RESPONSIBILITY_ID');
9171:
9172: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

Line 9172: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

9168: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9169: itemkey => l_parent_item_key,
9170: aname => 'RESPONSIBILITY_ID');
9171:
9172: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9173: itemkey => l_parent_item_key,
9174: aname => 'APPLICATION_ID');
9175:
9176: x_progress:='005';

Line 9243: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

9239: l_change_request_id number:=null;
9240: x_progress varchar2(3) := '000';
9241: BEGIN
9242:
9243: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
9244: itemkey => itemkey,
9245: aname => 'DOCUMENT_ID');
9246:
9247: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 9247: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

9243: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
9244: itemkey => itemkey,
9245: aname => 'DOCUMENT_ID');
9246:
9247: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
9248: itemkey => itemkey,
9249: aname => 'DOCUMENT_TYPE');
9250:
9251: IF (l_document_type = 'RELEASE') THEN

Line 9587: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

9583: resultout := wf_engine.eng_null;
9584: return;
9585: end if;
9586:
9587: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9588: itemkey => itemkey,
9589: aname => 'DOCUMENT_ID');
9590:
9591: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 9591: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

9587: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9588: itemkey => itemkey,
9589: aname => 'DOCUMENT_ID');
9590:
9591: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9592: itemkey => itemkey,
9593: aname => 'DOCUMENT_TYPE');
9594:
9595: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 9595: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

9591: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9592: itemkey => itemkey,
9593: aname => 'DOCUMENT_TYPE');
9594:
9595: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
9596: itemtype => itemtype,
9597: itemkey => itemkey,
9598: aname => 'CHANGE_REQUEST_GROUP_ID');
9599:

Line 9601: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

9597: itemkey => itemkey,
9598: aname => 'CHANGE_REQUEST_GROUP_ID');
9599:
9600: -- Set the multi-org context
9601: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9602: itemkey => itemkey,
9603: aname => 'ORG_ID');
9604:
9605: IF l_orgid is NOT NULL THEN

Line 9644: PO_WF_UTIL_PKG.SetItemAttrDate ( itemtype => itemtype,

9640: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 04';
9641:
9642: -- set the order totals and the order date.
9643: -- These are used by approval notification
9644: PO_WF_UTIL_PKG.SetItemAttrDate ( itemtype => itemtype,
9645: itemkey => itemkey,
9646: aname => 'ORDER_DATE',
9647: avalue => l_order_date);
9648:

Line 9649: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

9645: itemkey => itemkey,
9646: aname => 'ORDER_DATE',
9647: avalue => l_order_date);
9648:
9649: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
9650: itemkey => itemkey,
9651: aname => 'OLD_ORD_TOTAL_CURRENCY_DSP',
9652: avalue => to_char(l_old_total,
9653: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,

Line 9656: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

9652: avalue => to_char(l_old_total,
9653: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,
9654: g_currency_format_mask))
9655: || ' ' ||l_po_currency);
9656: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
9657: itemkey => itemkey,
9658: aname => 'NEW_ORD_TOTAL_CURRENCY_DSP',
9659: avalue => to_char(l_new_total,
9660: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,

Line 9706: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

9702: x_progress VARCHAR2(3) := '000';
9703: BEGIN
9704:
9705: l_change_request_group_id :=
9706: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
9707: itemkey => itemkey,
9708: aname => 'CHANGE_REQUEST_GROUP_ID');
9709:
9710: x_progress := '001';

Line 9744: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

9740: p_chg_req_grp_id => l_po_request_group_id );
9741:
9742: -- set change_pending flag to 'N' for the req
9743: l_req_document_id :=
9744: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
9745: itemkey => itemkey,
9746: aname => 'DOCUMENT_ID');
9747:
9748: SetReqChangeFlag(l_change_request_group_id, l_req_document_id, itemtype, itemkey, 'N');

Line 9778: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

9774: l_temp_status varchar2(1000);
9775: BEGIN
9776:
9777: l_change_request_group_id :=
9778: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
9779: itemkey => itemkey,
9780: aname => 'CHANGE_REQUEST_GROUP_ID');
9781: x_progress := '001';
9782:

Line 9784: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

9780: aname => 'CHANGE_REQUEST_GROUP_ID');
9781: x_progress := '001';
9782:
9783: l_document_id :=
9784: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
9785: itemkey => itemkey,
9786: aname => 'DOCUMENT_ID');
9787: x_progress := '002';
9788:

Line 9852: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

9848:
9849: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 02';
9850:
9851: -- Set the multi-org context
9852: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9853: itemkey => itemkey,
9854: aname => 'ORG_ID');
9855:
9856: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 03';

Line 9866: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

9862: END IF;
9863:
9864: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 04';
9865:
9866: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
9867: itemtype => itemtype,
9868: itemkey => itemkey,
9869: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
9870:

Line 9948: l_po_chg_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

9944: l_creation_method po_headers_all.document_creation_method%TYPE;
9945: l_document_type po_change_requests.document_type%TYPE;
9946: BEGIN
9947:
9948: l_po_chg_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
9949: itemtype => itemtype,
9950: itemkey => itemkey,
9951: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
9952:

Line 9953: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (

9949: itemtype => itemtype,
9950: itemkey => itemkey,
9951: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
9952:
9953: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (
9954: itemtype => itemtype,
9955: itemkey => itemkey,
9956: aname => 'PO_DOCUMENT_TYPE');
9957:

Line 10046: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10042: end if;
10043:
10044: l_progress := 'PO_ReqChangeRequestWF_PVT.More_Po_To_Process: 01';
10045:
10046: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10047: itemtype => itemtype,
10048: itemkey => itemkey,
10049: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10050:

Line 10053: l_change_request_grp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10049: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10050:
10051: l_progress := 'PO_ReqChangeRequestWF_PVT.More_Po_To_Process: 02';
10052:
10053: l_change_request_grp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10054: itemtype => itemtype,
10055: itemkey => itemkey,
10056: aname => 'CHANGE_REQUEST_GROUP_ID');
10057:

Line 10076: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,

10072:
10073: -- when next po change request group id is found
10074: IF (l_next_po_grp_id IS NOT NULL) THEN
10075:
10076: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
10077: itemkey => itemkey,
10078: aname => 'PO_CHANGE_REQUEST_GROUP_ID',
10079: avalue => l_next_po_grp_id );
10080:

Line 10087: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,

10083: into l_po_document_type, l_po_document_rev, l_po_document_id
10084: FROM po_change_requests
10085: WHERE change_request_group_id = l_next_po_grp_id AND rownum=1;
10086:
10087: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10088: itemkey => itemkey,
10089: aname => 'PO_DOCUMENT_TYPE',
10090: avalue => l_po_document_type );
10091:

Line 10092: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,

10088: itemkey => itemkey,
10089: aname => 'PO_DOCUMENT_TYPE',
10090: avalue => l_po_document_type );
10091:
10092: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10093: itemkey => itemkey,
10094: aname => 'PO_DOCUMENT_REVISION',
10095: avalue => l_po_document_rev );
10096:

Line 10097: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,

10093: itemkey => itemkey,
10094: aname => 'PO_DOCUMENT_REVISION',
10095: avalue => l_po_document_rev );
10096:
10097: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
10098: itemkey => itemkey,
10099: aname => 'CURRENT_PO_HEADER_ID',
10100: avalue => l_po_document_id );
10101: l_result := 'Y';

Line 10153: l_po_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

10149: end if;
10150:
10151: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 01';
10152:
10153: l_po_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
10154: itemtype => itemtype,
10155: itemkey => itemkey,
10156: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10157:

Line 10196: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,

10192: -- get Buyer's name
10193: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_buyer_name, l_buyer_display_name);
10194:
10195: -- set value of BUYER_USER_NAME WF attribute
10196: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10197: itemkey => itemkey,
10198: aname => 'BUYER_USER_NAME',
10199: avalue => l_buyer_name );
10200:

Line 10202: PO_WF_UTIL_PKG.SetItemAttrDate( itemtype => itemtype,

10198: aname => 'BUYER_USER_NAME',
10199: avalue => l_buyer_name );
10200:
10201: -- set value of PO_ORDER_DATE WF attribute
10202: PO_WF_UTIL_PKG.SetItemAttrDate( itemtype => itemtype,
10203: itemkey => itemkey,
10204: aname => 'PO_ORDER_DATE',
10205: avalue => l_order_date );
10206:

Line 10208: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,

10204: aname => 'PO_ORDER_DATE',
10205: avalue => l_order_date );
10206:
10207: -- set value of PO_DOCUMENT_NUMBER WF attribute
10208: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10209: itemkey => itemkey,
10210: aname => 'PO_DOCUMENT_NUMBER',
10211: avalue => l_document_number );
10212:

Line 10306: l_po_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

10302: end if;
10303:
10304: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 02';
10305:
10306: l_po_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
10307: itemkey => itemkey,
10308: aname => 'CURRENT_PO_HEADER_ID');
10309:
10310: l_po_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 10310: l_po_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

10306: l_po_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
10307: itemkey => itemkey,
10308: aname => 'CURRENT_PO_HEADER_ID');
10309:
10310: l_po_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
10311: itemkey => itemkey,
10312: aname => 'PO_DOCUMENT_TYPE');
10313:
10314: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 03';

Line 10336: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10332: END IF;
10333:
10334: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 04';
10335:
10336: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10337: itemtype => itemtype,
10338: itemkey => itemkey,
10339: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10340:

Line 10343: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

10339: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10340:
10341: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 05';
10342:
10343: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
10344: itemkey => itemkey,
10345: aname => 'ORG_ID');
10346:
10347: -- get the order total (old/new)

Line 10357: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

10353: x_new_total =>l_new_total);
10354:
10355: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 06';
10356:
10357: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10358: itemkey => itemkey,
10359: aname => 'OLD_PO_TOTAL',
10360: avalue =>
10361: to_char(l_old_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);

Line 10363: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

10359: aname => 'OLD_PO_TOTAL',
10360: avalue =>
10361: to_char(l_old_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);
10362:
10363: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10364: itemkey => itemkey,
10365: aname => 'NEW_PO_TOTAL',
10366: avalue =>
10367: to_char(l_new_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);

Line 10792: l_pochggrp_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

10788: resultout := wf_engine.eng_null;
10789: RETURN;
10790: END IF;
10791:
10792: l_pochggrp_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
10793: itemkey => itemkey,
10794: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10795: l_poheader_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
10796: itemkey => itemkey,

Line 10795: l_poheader_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

10791:
10792: l_pochggrp_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
10793: itemkey => itemkey,
10794: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10795: l_poheader_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
10796: itemkey => itemkey,
10797: aname => 'CURRENT_PO_HEADER_ID');
10798:
10799: IF (g_po_wf_debug = 'Y') THEN

Line 10810: l_po_doc_type := PO_WF_UTIL_PKG.GetItemAttrText( itemtype => itemtype,

10806: IF ( l_poheader_id is not null ) THEN
10807: -- bug 5363103
10808: -- To simply the logic, if PO is created in txn currency, RCO always needs buyer approval.
10809:
10810: l_po_doc_type := PO_WF_UTIL_PKG.GetItemAttrText( itemtype => itemtype,
10811: itemkey => itemkey,
10812: aname => 'PO_DOCUMENT_TYPE');
10813:
10814: -- For releases, the current doc header id is the release id

Line 10926: l_req_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10922: END IF;
10923:
10924: l_progress := 'PO_ReqChangeRequestWF_PVT.More_Req_To_Process: 01';
10925:
10926: l_req_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10927: itemtype => itemtype,
10928: itemkey => itemkey,
10929: aname => 'REQ_CHANGE_GROUP_ID');
10930:

Line 10933: l_po_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10929: aname => 'REQ_CHANGE_GROUP_ID');
10930:
10931: l_progress := 'PO_ReqChangeRequestWF_PVT.More_Req_To_Process: 02';
10932:
10933: l_po_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10934: itemtype => itemtype,
10935: itemkey => itemkey,
10936: aname => 'CHANGE_REQUEST_GROUP_ID');
10937:

Line 10955: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,

10951:
10952: -- when next po change request group id is found
10953: IF (l_next_req_grp_id IS NOT NULL) THEN
10954:
10955: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
10956: itemkey => itemkey,
10957: aname => 'REQ_CHANGE_GROUP_ID',
10958: avalue => l_next_req_grp_id );
10959:

Line 10965: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,

10961: INTO l_document_id, l_document_num
10962: FROM po_change_requests
10963: WHERE change_request_group_id = l_next_req_grp_id AND rownum=1;
10964:
10965: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
10966: itemkey => itemkey,
10967: aname => 'REQ_HEADER_ID',
10968: avalue => l_document_id );
10969:

Line 10970: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,

10966: itemkey => itemkey,
10967: aname => 'REQ_HEADER_ID',
10968: avalue => l_document_id );
10969:
10970: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10971: itemkey => itemkey,
10972: aname => 'REQUISITION_NUMBER',
10973: avalue => l_document_num );
10974: l_result := 'Y';

Line 11011: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

11007: return;
11008: END IF;
11009:
11010: -- Set the multi-org context
11011: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
11012: itemkey => itemkey,
11013: aname => 'ORG_ID');
11014:
11015: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 02';

Line 11023: l_po_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

11019: END IF;
11020:
11021: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 03';
11022:
11023: l_po_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
11024: itemtype => itemtype,
11025: itemkey => itemkey,
11026: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
11027:

Line 11069: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(

11065: l_item_key:='NOTIFREQ_'||to_char(p_po_change_request_group_id)||'_'||to_char(l_count);
11066:
11067: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_NotifyRequesterProcess: 02' || ' ITEM KEY:' || l_item_key;
11068:
11069: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
11070: itemtype=>p_req_item_type,
11071: itemkey=>p_req_item_key,
11072: aname =>'RESPONDER_USER_NAME');
11073:

Line 11074: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => p_req_item_type,

11070: itemtype=>p_req_item_type,
11071: itemkey=>p_req_item_key,
11072: aname =>'RESPONDER_USER_NAME');
11073:
11074: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => p_req_item_type,
11075: itemkey => p_req_item_key,
11076: aname => 'USER_ID');
11077:
11078: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

Line 11078: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

11074: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => p_req_item_type,
11075: itemkey => p_req_item_key,
11076: aname => 'USER_ID');
11077:
11078: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
11079: itemtype => p_req_item_type,
11080: itemkey => p_req_item_key,
11081: aname => 'RESPONSIBILITY_ID');
11082:

Line 11083: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

11079: itemtype => p_req_item_type,
11080: itemkey => p_req_item_key,
11081: aname => 'RESPONSIBILITY_ID');
11082:
11083: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
11084: itemtype => p_req_item_type,
11085: itemkey => p_req_item_key,
11086: aname => 'APPLICATION_ID');
11087:

Line 11612: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,

11608: x_progress VARCHAR2(100) := '001';
11609: l_CHANGE_REQUEST_ID number;
11610: l_return_msg VARCHAR2(200);
11611: BEGIN
11612: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
11613: itemkey => itemkey,
11614: aname => 'CHANGE_REQUEST_GROUP_ID');
11615: x_progress := '002';
11616: --query the pcr table to get these values to pass to the public api

Line 11695: po_wf_util_pkg.setitemattrnumber (itemtype => itemtype,

11691: FROM po_change_requests
11692: WHERE change_request_group_id = l_change_request_group_id
11693: AND request_status = 'ACCEPTED';
11694:
11695: po_wf_util_pkg.setitemattrnumber (itemtype => itemtype,
11696: itemkey => itemkey,
11697: aname => 'INTERNAL_CHANGE_REQUEST_ID',
11698: avalue => L_CHANGE_REQUEST_ID);
11699:

Line 12502: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (

12498: RETURN;
12499: END IF;
12500:
12501:
12502: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (
12503: itemtype => itemtype,
12504: itemkey => itemkey,
12505: aname => 'CHANGE_REQUEST_GROUP_ID');
12506:

Line 12508: l_change_request_id := po_wf_util_pkg.getitemattrnumber (

12504: itemkey => itemkey,
12505: aname => 'CHANGE_REQUEST_GROUP_ID');
12506:
12507:
12508: l_change_request_id := po_wf_util_pkg.getitemattrnumber (
12509: itemtype => itemtype,
12510: itemkey => itemkey,
12511: aname => 'INTERNAL_CHANGE_REQUEST_ID');
12512:

Line 12540: l_PLANNERS_NOTIFIED := po_wf_util_pkg.getitemattrtext ( itemtype => itemtype,

12536:
12537: */
12538:
12539: l_planner_id := 0;
12540: l_PLANNERS_NOTIFIED := po_wf_util_pkg.getitemattrtext ( itemtype => itemtype,
12541: itemkey => itemkey,
12542: aname => 'PLANNERS_NOTIFIED');
12543:
12544: l_sql := '

Line 12645: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (

12641: RETURN;
12642: END IF;
12643:
12644:
12645: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (
12646: itemtype => itemtype,
12647: itemkey => itemkey,
12648: aname => 'CHANGE_REQUEST_GROUP_ID');
12649:

Line 12651: l_old_change_request_id := po_wf_util_pkg.getitemattrnumber (

12647: itemkey => itemkey,
12648: aname => 'CHANGE_REQUEST_GROUP_ID');
12649:
12650:
12651: l_old_change_request_id := po_wf_util_pkg.getitemattrnumber (
12652: itemtype => itemtype,
12653: itemkey => itemkey,
12654: aname => 'INTERNAL_CHANGE_REQUEST_ID');
12655:

Line 12671: po_wf_util_pkg.setitemattrnumber (itemtype => itemtype,

12667: WHEN NO_DATA_FOUND THEN
12668: L_NEW_CHANGE_REQUEST_ID := -99;
12669: END;
12670: IF (L_NEW_CHANGE_REQUEST_ID <> -99) THEN
12671: po_wf_util_pkg.setitemattrnumber (itemtype => itemtype,
12672: itemkey => itemkey,
12673: aname => 'INTERNAL_CHANGE_REQUEST_ID',
12674: avalue => L_NEW_CHANGE_REQUEST_ID);
12675: