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 439: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,

435: IF (g_po_wf_debug = 'Y') THEN
436: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
437: END IF;
438:
439: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,
440: itemkey=>itemkey,
441: aname=>'APPROVER_USER_NAME');
442: if (l_approver_user_name is not null) then
443: SELECT user_id

Line 4197: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(

4193: open get_parent_info_csr(p_change_request_group_id);
4194: fetch get_parent_info_csr into l_parent_item_type, l_parent_item_key;
4195: close get_parent_info_csr;
4196:
4197: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
4198: itemtype=>l_parent_item_type,
4199: itemkey=>l_parent_item_key,
4200: aname =>'RESPONDER_USER_NAME');
4201:

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

4198: itemtype=>l_parent_item_type,
4199: itemkey=>l_parent_item_key,
4200: aname =>'RESPONDER_USER_NAME');
4201:
4202: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4203: itemkey => l_parent_item_key,
4204: aname => 'USER_ID');
4205:
4206: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

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

4202: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4203: itemkey => l_parent_item_key,
4204: aname => 'USER_ID');
4205:
4206: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4207: itemkey => l_parent_item_key,
4208: aname => 'RESPONSIBILITY_ID');
4209:
4210: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

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

4206: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4207: itemkey => l_parent_item_key,
4208: aname => 'RESPONSIBILITY_ID');
4209:
4210: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
4211: itemkey => l_parent_item_key,
4212: aname => 'APPLICATION_ID');
4213:
4214: 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 4323: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,

4319: t_varname(5) := 'PREPARER_DISPLAY_NAME';
4320: t_varval(5) := l_requester_display_name;
4321: t_varname(6) := 'REQ_CHANGE_RESPONSE_NOTIF_BODY';
4322: t_varval(6) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||to_char(p_change_request_group_id);
4323: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,
4324: itemkey=>p_old_item_key,
4325: aname =>'TOTAL_AMOUNT_DSP');
4326: l_functional_currency:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,
4327: itemkey=>p_old_item_key,

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

4322: t_varval(6) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||to_char(p_change_request_group_id);
4323: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,
4324: itemkey=>p_old_item_key,
4325: aname =>'TOTAL_AMOUNT_DSP');
4326: l_functional_currency:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>item_type,
4327: itemkey=>p_old_item_key,
4328: aname =>'FUNCTIONAL_CURRENCY');
4329: t_varname(7) := 'TOTAL_AMOUNT_DSP';
4330: t_varval(7) := l_total_amount_dsp;

Line 4333: l_note := PO_WF_UTIL_PKG.GetItemAttrText

4329: t_varname(7) := 'TOTAL_AMOUNT_DSP';
4330: t_varval(7) := l_total_amount_dsp;
4331: t_varname(8) := 'FUNCTIONAL_CURRENCY';
4332: t_varval(8) := l_functional_currency;
4333: l_note := PO_WF_UTIL_PKG.GetItemAttrText
4334: (itemtype => item_type,
4335: itemkey => p_old_item_key,
4336: aname => 'JUSTIFICATION');
4337: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText

Line 4337: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText

4333: l_note := PO_WF_UTIL_PKG.GetItemAttrText
4334: (itemtype => item_type,
4335: itemkey => p_old_item_key,
4336: aname => 'JUSTIFICATION');
4337: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText
4338: (itemtype => item_type,
4339: itemkey => p_old_item_key,
4340: aname => 'REQ_AMOUNT_CURRENCY_DSP');
4341: l_new_amount_currency:= PO_WF_UTIL_PKG.GetItemAttrText

Line 4341: l_new_amount_currency:= PO_WF_UTIL_PKG.GetItemAttrText

4337: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText
4338: (itemtype => item_type,
4339: itemkey => p_old_item_key,
4340: aname => 'REQ_AMOUNT_CURRENCY_DSP');
4341: l_new_amount_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4342: (itemtype => item_type,
4343: itemkey => p_old_item_key,
4344: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP');
4345: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

Line 4345: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

4341: l_new_amount_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4342: (itemtype => item_type,
4343: itemkey => p_old_item_key,
4344: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP');
4345: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4346: (itemtype => item_type,
4347: itemkey => p_old_item_key,
4348: aname => 'TAX_AMOUNT_CURRENCY_DSP');
4349: l_new_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

Line 4349: l_new_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

4345: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4346: (itemtype => item_type,
4347: itemkey => p_old_item_key,
4348: aname => 'TAX_AMOUNT_CURRENCY_DSP');
4349: l_new_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4350: (itemtype => item_type,
4351: itemkey => p_old_item_key,
4352: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP');
4353: l_new_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText

Line 4353: l_new_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText

4349: l_new_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
4350: (itemtype => item_type,
4351: itemkey => p_old_item_key,
4352: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP');
4353: l_new_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText
4354: (itemtype => item_type,
4355: itemkey => p_old_item_key,
4356: aname => 'NEW_TOTAL_AMOUNT_DSP');
4357:

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

4735: x_amount_for_tax => l_amount_for_tax);
4736:
4737: x_progress :='StartPOChangeWF:009';
4738:
4739: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,
4740: itemkey => item_key,
4741: aname => 'TOTAL_AMOUNT_DSP',
4742: avalue => l_amount_for_subject);
4743:

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

4740: itemkey => item_key,
4741: aname => 'TOTAL_AMOUNT_DSP',
4742: avalue => l_amount_for_subject);
4743:
4744: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,
4745: itemkey => item_key,
4746: aname => 'REQ_AMOUNT_CURRENCY_DSP',
4747: avalue => l_amount_for_header);
4748:

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

4745: itemkey => item_key,
4746: aname => 'REQ_AMOUNT_CURRENCY_DSP',
4747: avalue => l_amount_for_header);
4748:
4749: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,
4750: itemkey => item_key,
4751: aname => 'TAX_AMOUNT_CURRENCY_DSP',
4752: avalue => l_amount_for_tax);
4753:

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

4753:
4754: --Bug#5114191 : Set responsibility user id, resp id, appl id for
4755: -- processbuyer response wf from inform buyer wf.
4756:
4757: l_responder_user_id := nvl(PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4758: itemkey => l_inform_item_key,
4759: aname => 'RESPONDER_USER_ID'),
4760: fnd_global.user_id);
4761: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,

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

4757: l_responder_user_id := nvl(PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4758: itemkey => l_inform_item_key,
4759: aname => 'RESPONDER_USER_ID'),
4760: fnd_global.user_id);
4761: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4762: itemkey => l_inform_item_key,
4763: aname => 'RESPONDER_RESP_ID'),
4764: fnd_global.resp_id);
4765: l_responder_appl_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,

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

4761: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4762: itemkey => l_inform_item_key,
4763: aname => 'RESPONDER_RESP_ID'),
4764: fnd_global.resp_id);
4765: l_responder_appl_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4766: itemkey => l_inform_item_key,
4767: aname => 'RESPONDER_APPL_ID'),
4768: fnd_global.resp_appl_id);
4769: --bug 9685961

Line 4770: l_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_inform_item_type,

4766: itemkey => l_inform_item_key,
4767: aname => 'RESPONDER_APPL_ID'),
4768: fnd_global.resp_appl_id);
4769: --bug 9685961
4770: l_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_inform_item_type,
4771: itemkey => l_inform_item_key,
4772: aname => 'NOTE');
4773:
4774: IF (g_fnd_debug = 'Y') THEN

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

4782: END IF;
4783: END IF;
4784:
4785:
4786: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4787: itemkey => item_key,
4788: aname => 'RESPONDER_USER_ID',
4789: avalue => l_responder_user_id);
4790: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,

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

4786: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4787: itemkey => item_key,
4788: aname => 'RESPONDER_USER_ID',
4789: avalue => l_responder_user_id);
4790: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4791: itemkey => item_key,
4792: aname => 'RESPONDER_RESP_ID',
4793: avalue => l_responder_resp_id);
4794: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,

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

4790: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4791: itemkey => item_key,
4792: aname => 'RESPONDER_RESP_ID',
4793: avalue => l_responder_resp_id);
4794: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => item_type,
4795: itemkey => item_key,
4796: aname => 'RESPONDER_APPL_ID',
4797: avalue => l_responder_appl_id);
4798: --bug 9685961

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

4795: itemkey => item_key,
4796: aname => 'RESPONDER_APPL_ID',
4797: avalue => l_responder_appl_id);
4798: --bug 9685961
4799: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => item_type,
4800: itemkey => item_key,
4801: aname => 'NOTE',
4802: avalue => l_note);
4803:

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

4950: return;
4951:
4952: end if;
4953:
4954: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4955: itemkey => itemkey,
4956: aname => 'DOCUMENT_ID');
4957:
4958: -- Set the multi-org context

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

4955: itemkey => itemkey,
4956: aname => 'DOCUMENT_ID');
4957:
4958: -- Set the multi-org context
4959: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4960: itemkey => itemkey,
4961: aname => 'ORG_ID');
4962:
4963: IF l_orgid is NOT NULL THEN

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

4969: open change_request_group_id;
4970: fetch change_request_group_id into l_change_request_group_id;
4971: close change_request_group_id;
4972:
4973: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
4974: itemkey => itemkey,
4975: aname => 'CHANGE_REQUEST_GROUP_ID',
4976: avalue => l_change_request_group_id);
4977:

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

4974: itemkey => itemkey,
4975: aname => 'CHANGE_REQUEST_GROUP_ID',
4976: avalue => l_change_request_group_id);
4977:
4978: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4979: itemkey => itemkey,
4980: aname => 'REQ_CHANGE_NOTIF_BODY',
4981: avalue =>
4982: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_approval_notif/'||

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

4981: avalue =>
4982: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_approval_notif/'||
4983: itemtype||':'||
4984: itemkey);
4985: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4986: itemkey => itemkey,
4987: aname => 'REQ_CHANGE_RESPONSE_NOTIF_BODY',
4988: avalue =>
4989: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||

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

4989: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||
4990: to_char(l_change_request_group_id));
4991:
4992: /*
4993: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4994: itemkey => itemkey,
4995: aname => 'NEW_AMOUNT_WITH_CURRENCY_D',
4996: avalue =>
4997: 'plsql:PO_ReqChangeRequestNotif_PVT.get_new_req_amount/'||itemtype||':'||itemkey);

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

5049:
5050: end if;
5051:
5052: -- Set the multi-org context
5053: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5054: itemkey => itemkey,
5055: aname => 'ORG_ID');
5056:
5057: IF l_orgid is NOT NULL THEN

Line 5063: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

5059: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5060:
5061: END IF;
5062:
5063: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
5064: itemtype => itemtype,
5065: itemkey => itemkey,
5066: aname => 'CHANGE_REQUEST_GROUP_ID');
5067:

Line 5068: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

5064: itemtype => itemtype,
5065: itemkey => itemkey,
5066: aname => 'CHANGE_REQUEST_GROUP_ID');
5067:
5068: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
5069: itemtype => itemtype,
5070: itemkey => itemkey,
5071: aname => 'DOCUMENT_ID');
5072:

Line 5142: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (

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

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

5149: fetch change_request into l_employee_id;
5150: close change_request;
5151:
5152: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 03';
5153: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5154: itemkey => itemkey,
5155: aname => 'DOCUMENT_ID');
5156:
5157: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

5153: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5154: itemkey => itemkey,
5155: aname => 'DOCUMENT_ID');
5156:
5157: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5158: itemkey => itemkey,
5159: aname => 'DOCUMENT_TYPE');
5160:
5161: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

5157: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5158: itemkey => itemkey,
5159: aname => 'DOCUMENT_TYPE');
5160:
5161: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5162: itemkey => itemkey,
5163: aname => 'DOCUMENT_SUBTYPE');
5164:
5165: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 04';

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

5163: aname => 'DOCUMENT_SUBTYPE');
5164:
5165: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 04';
5166: -- Set the multi-org context
5167: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5168: itemkey => itemkey,
5169: aname => 'ORG_ID');
5170:
5171: IF l_orgid is NOT NULL THEN

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

5171: IF l_orgid is NOT NULL THEN
5172: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5173: END IF;
5174:
5175: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
5176: itemkey => itemkey,
5177: aname => 'NOTE');
5178:
5179:

Line 5266: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

5262: resultout := wf_engine.eng_null;
5263: return;
5264: end if;
5265:
5266: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
5267: itemtype => itemtype,
5268: itemkey => itemkey,
5269: aname => 'CHANGE_REQUEST_GROUP_ID');
5270:

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

5329: resultout := wf_engine.eng_null;
5330: return;
5331: end if;
5332:
5333: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5334: itemkey => itemkey,
5335: aname => 'CHANGE_REQUEST_GROUP_ID');
5336:
5337:

Line 5396: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

5392: resultout := wf_engine.eng_null;
5393: return;
5394: end if;
5395:
5396: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
5397: itemtype => itemtype,
5398: itemkey => itemkey,
5399: aname => 'CHANGE_REQUEST_GROUP_ID');
5400:

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

5453: return;
5454:
5455: end if;
5456:
5457: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5458: itemkey => itemkey,
5459: aname => 'CHANGE_REQUEST_GROUP_ID');
5460:
5461:

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

5521:
5522: end if;
5523:
5524:
5525: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5526: itemkey => itemkey,
5527: aname => 'CHANGE_REQUEST_GROUP_ID');
5528:
5529: -- Set the multi-org context

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

5526: itemkey => itemkey,
5527: aname => 'CHANGE_REQUEST_GROUP_ID');
5528:
5529: -- Set the multi-org context
5530: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5531: itemkey => itemkey,
5532: aname => 'ORG_ID');
5533:
5534: IF l_orgid is NOT NULL THEN

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

5578: IS
5579: x_progress varchar2(3) := '000';
5580: BEGIN
5581:
5582: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
5583: itemkey => itemkey,
5584: aname => 'REMINDER_COUNTER',
5585: avalue => 0);
5586: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

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

5609: x_progress varchar2(3) := '000';
5610: l_max_reminder number;
5611: BEGIN
5612:
5613: l_reminder_counter:= PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
5614: itemkey => itemkey,
5615: aname => 'REMINDER_COUNTER');
5616: l_max_reminder := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
5617: itemkey => itemkey,

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

5612:
5613: l_reminder_counter:= PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
5614: itemkey => itemkey,
5615: aname => 'REMINDER_COUNTER');
5616: l_max_reminder := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
5617: itemkey => itemkey,
5618: aname => 'MAX_REMINDER_MSG_COUNT');
5619:
5620: if(l_reminder_counter=l_max_reminder) then

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

5625: itemkey => itemkey,
5626: aname => 'REMINDER_COUNTER',
5627: avalue => l_reminder_counter+1);
5628: if(l_reminder_counter=l_max_reminder-1) then
5629: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5630: itemkey => itemkey,
5631: aname => 'REMINDER_MSG',
5632: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_REMINDER')||':');
5633: elsif(l_reminder_counter=1) then

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

5630: itemkey => itemkey,
5631: aname => 'REMINDER_MSG',
5632: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_REMINDER')||':');
5633: elsif(l_reminder_counter=1) then
5634: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5635: itemkey => itemkey,
5636: aname => 'REMINDER_MSG',
5637: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_FIRST_REMINDER')||':');
5638: elsif(l_reminder_counter=2) then

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

5635: itemkey => itemkey,
5636: aname => 'REMINDER_MSG',
5637: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_FIRST_REMINDER')||':');
5638: elsif(l_reminder_counter=2) then
5639: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5640: itemkey => itemkey,
5641: aname => 'REMINDER_MSG',
5642: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_SECOND_REMINDER')||':');
5643: else

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

5640: itemkey => itemkey,
5641: aname => 'REMINDER_MSG',
5642: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_SECOND_REMINDER')||':');
5643: else
5644: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5645: itemkey => itemkey,
5646: aname => 'REMINDER_MSG',
5647: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_REMINDER')||' '||to_char(l_reminder_counter)||':');
5648: end if;

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

5691: resultout := wf_engine.eng_null;
5692: return;
5693:
5694: end if;
5695: l_ActionOriginatedFrom := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
5696: itemkey => itemkey,
5697: aname => 'INTERFACE_SOURCE_CODE');
5698:
5699:

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

5757: return;
5758:
5759: end if;
5760:
5761: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5762: itemkey => itemkey,
5763: aname => 'CHANGE_REQUEST_GROUP_ID');
5764:
5765: -- Set the multi-org context

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

5762: itemkey => itemkey,
5763: aname => 'CHANGE_REQUEST_GROUP_ID');
5764:
5765: -- Set the multi-org context
5766: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5767: itemkey => itemkey,
5768: aname => 'ORG_ID');
5769:
5770: IF l_orgid is NOT NULL THEN

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

5941: END IF;
5942:
5943: IF (funcmode='RUN') THEN
5944:
5945: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5946: itemkey => itemkey,
5947: aname => 'DOCUMENT_ID');
5948:
5949: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

5945: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5946: itemkey => itemkey,
5947: aname => 'DOCUMENT_ID');
5948:
5949: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5950: itemkey => itemkey,
5951: aname => 'DOCUMENT_TYPE');
5952:
5953: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

5949: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5950: itemkey => itemkey,
5951: aname => 'DOCUMENT_TYPE');
5952:
5953: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5954: itemkey => itemkey,
5955: aname => 'DOCUMENT_SUBTYPE');
5956:
5957: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

5953: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
5954: itemkey => itemkey,
5955: aname => 'DOCUMENT_SUBTYPE');
5956:
5957: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5958: itemkey => itemkey,
5959: aname => 'CHANGE_REQUEST_GROUP_ID');
5960:
5961: -- Set the multi-org context

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

5958: itemkey => itemkey,
5959: aname => 'CHANGE_REQUEST_GROUP_ID');
5960:
5961: -- Set the multi-org context
5962: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
5963: itemkey => itemkey,
5964: aname => 'ORG_ID');
5965:
5966: IF l_org_id is NOT NULL THEN

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

6094: l_progress := 'Update_Action_History_Return: 001';
6095:
6096: IF (funcmode='RUN') THEN
6097:
6098: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6099: itemkey => itemkey,
6100: aname => 'DOCUMENT_ID');
6101:
6102: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

6098: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6099: itemkey => itemkey,
6100: aname => 'DOCUMENT_ID');
6101:
6102: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6103: itemkey => itemkey,
6104: aname => 'DOCUMENT_TYPE');
6105:
6106: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

6102: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6103: itemkey => itemkey,
6104: aname => 'DOCUMENT_TYPE');
6105:
6106: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6107: itemkey => itemkey,
6108: aname => 'DOCUMENT_SUBTYPE');
6109:
6110: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

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

6106: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6107: itemkey => itemkey,
6108: aname => 'DOCUMENT_SUBTYPE');
6109:
6110: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
6111: itemkey => itemkey,
6112: aname => 'NOTE');
6113:
6114: -- Set the multi-org context

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

6112: aname => 'NOTE');
6113:
6114: -- Set the multi-org context
6115:
6116: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6117: itemkey => itemkey,
6118: aname => 'ORG_ID');
6119:
6120: IF l_org_id is NOT NULL THEN

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

6174: temp number;
6175: l_error_code varchar2(200);
6176:
6177: begin
6178: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6179: itemkey => itemkey,
6180: aname => 'CHANGE_REQUEST_GROUP_ID');
6181:
6182: ConvertIntoPOChange(l_change_request_group_id);

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

6242:
6243: end if;
6244:
6245: -- Set the multi-org context
6246: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6247: itemkey => itemkey,
6248: aname => 'ORG_ID');
6249:
6250: IF l_orgid is NOT NULL THEN

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

6252: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6253:
6254: END IF;
6255:
6256: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6257: itemkey => itemkey,
6258: aname => 'CHANGE_REQUEST_GROUP_ID');
6259:
6260: open child_request_group_id;

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

6322:
6323: end if;
6324:
6325: -- Set the multi-org context
6326: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6327: itemkey => itemkey,
6328: aname => 'ORG_ID');
6329:
6330: IF l_orgid is NOT NULL THEN

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

6332: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6333:
6334: END IF;
6335:
6336: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6337: itemkey => itemkey,
6338: aname => 'CHANGE_REQUEST_GROUP_ID');
6339:
6340: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

6336: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6337: itemkey => itemkey,
6338: aname => 'CHANGE_REQUEST_GROUP_ID');
6339:
6340: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6341: itemkey => itemkey,
6342: aname => 'DOCUMENT_ID');
6343:
6344: SetReqChangeFlag(l_change_request_group_id, l_document_id, itemtype, itemkey, 'N');

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

6393:
6394: end if;
6395:
6396: -- Set the multi-org context
6397: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6398: itemkey => itemkey,
6399: aname => 'ORG_ID');
6400:
6401: IF l_orgid is NOT NULL THEN

Line 6440: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber

6436: ln_jai_excl_nr_tax_disp VARCHAR2(400); --Non-Rec tax for display
6437: --------------------------------------------------------------------------
6438: --Added by Xiao and Eric for IL PO Notification on Mar-30-2009, End
6439: begin
6440: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber
6441: (itemtype => itemtype,
6442: itemkey => itemkey,
6443: aname => 'CHANGE_REQUEST_GROUP_ID');
6444: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

6440: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber
6441: (itemtype => itemtype,
6442: itemkey => itemkey,
6443: aname => 'CHANGE_REQUEST_GROUP_ID');
6444: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6445: itemkey => itemkey,
6446: aname => 'DOCUMENT_ID');
6447:
6448: l_currency_code := PO_WF_UTIL_PKG.GetItemAttrText

Line 6448: l_currency_code := PO_WF_UTIL_PKG.GetItemAttrText

6444: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6445: itemkey => itemkey,
6446: aname => 'DOCUMENT_ID');
6447:
6448: l_currency_code := PO_WF_UTIL_PKG.GetItemAttrText
6449: (itemtype => itemtype,
6450: itemkey => itemkey,
6451: aname => 'FUNCTIONAL_CURRENCY');
6452:

Line 6495: ln_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber

6491: and NVL(prl.cancel_flag, 'N')='N';
6492: x_progress :='002';
6493: -- Added by Xiao and Eric for IL PO Notification on Feb-11,2009 , Begin
6494: -------------------------------------------------------------------------------------
6495: ln_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber
6496: ( itemtype => itemtype
6497: , itemkey => itemkey
6498: , aname => 'ORG_ID'
6499: );

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

6586: -------------------------------------------------------------------------------------
6587: -- Modified by Xiao and Eric for IL PO Notification on Apr-3,2009 , End
6588:
6589:
6590: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
6591: itemkey=> itemkey,
6592: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP',
6593: avalue => l_amount_for_header);
6594:

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

6591: itemkey=> itemkey,
6592: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP',
6593: avalue => l_amount_for_header);
6594:
6595: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
6596: itemkey=> itemkey,
6597: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP',
6598: avalue => l_amount_for_tax);
6599: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

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

6595: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
6596: itemkey=> itemkey,
6597: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP',
6598: avalue => l_amount_for_tax);
6599: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
6600: itemkey=> itemkey,
6601: aname => 'NEW_TOTAL_AMOUNT_DSP',
6602: avalue => l_amount_for_subject);
6603: x_progress :='004';

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

6644: resultout := wf_engine.eng_null;
6645: return;
6646: end if;
6647:
6648: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6649: itemkey => itemkey,
6650: aname => 'DOCUMENT_ID');
6651:
6652: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

6648: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6649: itemkey => itemkey,
6650: aname => 'DOCUMENT_ID');
6651:
6652: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6653: itemkey => itemkey,
6654: aname => 'DOCUMENT_TYPE');
6655:
6656: -- Set the multi-org context

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

6653: itemkey => itemkey,
6654: aname => 'DOCUMENT_TYPE');
6655:
6656: -- Set the multi-org context
6657: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6658: itemkey => itemkey,
6659: aname => 'ORG_ID');
6660:
6661: IF l_orgid is NOT NULL THEN

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

6742: resultout := wf_engine.eng_null;
6743: return;
6744: end if;
6745:
6746: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6747: itemkey => itemkey,
6748: aname => 'DOCUMENT_ID');
6749:
6750: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

6746: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6747: itemkey => itemkey,
6748: aname => 'DOCUMENT_ID');
6749:
6750: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6751: itemkey => itemkey,
6752: aname => 'DOCUMENT_TYPE');
6753:
6754: -- Set the multi-org context

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

6751: itemkey => itemkey,
6752: aname => 'DOCUMENT_TYPE');
6753:
6754: -- Set the multi-org context
6755: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6756: itemkey => itemkey,
6757: aname => 'ORG_ID');
6758:
6759: IF l_orgid is NOT NULL THEN

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

6825: return;
6826:
6827: end if;
6828:
6829: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6830: itemkey => itemkey,
6831: aname => 'DOCUMENT_ID');
6832:
6833: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

6829: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6830: itemkey => itemkey,
6831: aname => 'DOCUMENT_ID');
6832:
6833: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6834: itemkey => itemkey,
6835: aname => 'DOCUMENT_TYPE');
6836: l_old_doc_revision := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
6837: itemkey => itemkey,

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

6832:
6833: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
6834: itemkey => itemkey,
6835: aname => 'DOCUMENT_TYPE');
6836: l_old_doc_revision := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
6837: itemkey => itemkey,
6838: aname => 'DOCUMENT_REVISION_NUM');
6839: -- Set the multi-org context
6840: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

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

Line 6924: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

6920: resultout := wf_engine.eng_null;
6921: return;
6922: end if;
6923:
6924: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
6925: itemtype => itemtype,
6926: itemkey => itemkey,
6927: aname => 'CHANGE_REQUEST_GROUP_ID');
6928:

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

6925: itemtype => itemtype,
6926: itemkey => itemkey,
6927: aname => 'CHANGE_REQUEST_GROUP_ID');
6928:
6929: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6930: itemkey => itemkey,
6931: aname => 'ORG_ID');
6932: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
6933: itemkey => itemkey,

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

6928:
6929: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6930: itemkey => itemkey,
6931: aname => 'ORG_ID');
6932: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
6933: itemkey => itemkey,
6934: aname => 'RESPONSE_REASON');
6935:
6936: IF l_orgid is NOT NULL THEN

Line 6997: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

6993: resultout := wf_engine.eng_null;
6994: return;
6995: end if;
6996:
6997: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
6998: itemtype => itemtype,
6999: itemkey => itemkey,
7000: aname => 'CHANGE_REQUEST_GROUP_ID');
7001:

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

6998: itemtype => itemtype,
6999: itemkey => itemkey,
7000: aname => 'CHANGE_REQUEST_GROUP_ID');
7001:
7002: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
7003: itemkey => itemkey,
7004: aname => 'RESPONSE_REASON');
7005:
7006: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

7002: l_response_reason := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
7003: itemkey => itemkey,
7004: aname => 'RESPONSE_REASON');
7005:
7006: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7007: itemkey => itemkey,
7008: aname => 'ORG_ID');
7009:
7010: IF l_orgid is NOT NULL THEN

Line 7069: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

7065: resultout := wf_engine.eng_null;
7066: return;
7067: end if;
7068:
7069: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
7070: itemtype => itemtype,
7071: itemkey => itemkey,
7072: aname => 'CHANGE_REQUEST_GROUP_ID');
7073:

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

7071: itemkey => itemkey,
7072: aname => 'CHANGE_REQUEST_GROUP_ID');
7073:
7074: -- Set the multi-org context
7075: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7076: itemkey => itemkey,
7077: aname => 'ORG_ID');
7078:
7079: IF l_orgid is NOT NULL THEN

Line 7151: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (

7147: resultout := wf_engine.eng_null;
7148: return;
7149: end if;
7150:
7151: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (
7152: itemtype => itemtype,
7153: itemkey => itemkey,
7154: aname => 'CHANGE_REQUEST_GROUP_ID');
7155:

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

7171: else
7172: l_action:='RESPOND';
7173: end if;
7174:
7175: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7176: itemkey => itemkey,
7177: aname => 'DOCUMENT_ID');
7178:
7179: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

7175: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7176: itemkey => itemkey,
7177: aname => 'DOCUMENT_ID');
7178:
7179: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
7180: itemkey => itemkey,
7181: aname => 'DOCUMENT_TYPE');
7182:
7183: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

7179: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
7180: itemkey => itemkey,
7181: aname => 'DOCUMENT_TYPE');
7182:
7183: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
7184: itemkey => itemkey,
7185: aname => 'DOCUMENT_SUBTYPE');
7186:
7187: -- Set the multi-org context

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

7184: itemkey => itemkey,
7185: aname => 'DOCUMENT_SUBTYPE');
7186:
7187: -- Set the multi-org context
7188: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7189: itemkey => itemkey,
7190: aname => 'ORG_ID');
7191:
7192: IF l_orgid is NOT NULL THEN

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

7210: where PO_RELEASE_ID = l_doc_id;
7211: end if;
7212:
7213: -- Bug 9685961
7214: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
7215: itemkey => itemkey,
7216: aname => 'NOTE');
7217:
7218: InsertActionHist(itemtype,itemkey,l_doc_id, l_doc_type,

Line 7281: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

7277: return;
7278: end if;
7279:
7280:
7281: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
7282: itemtype => itemtype,
7283: itemkey => itemkey,
7284: aname => 'CHANGE_REQUEST_GROUP_ID');
7285:

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

7283: itemkey => itemkey,
7284: aname => 'CHANGE_REQUEST_GROUP_ID');
7285:
7286: -- Set the multi-org context
7287: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7288: itemkey => itemkey,
7289: aname => 'ORG_ID');
7290:
7291: IF l_orgid is NOT NULL THEN

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

7353: resultout := wf_engine.eng_null;
7354: return;
7355: end if;
7356:
7357: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7358: itemkey => itemkey,
7359: aname => 'CHANGE_REQUEST_GROUP_ID');
7360: /* Bug#3769157 : Set the responsibility and application id of the preparer
7361: if null(happens when notification responded by buyer from worklist) */

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

7360: /* Bug#3769157 : Set the responsibility and application id of the preparer
7361: if null(happens when notification responded by buyer from worklist) */
7362:
7363: if( (nvl(l_responsibility_id, -1) <0) or (nvl(l_application_id, -1) < 0) ) then
7364: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7365: itemkey => itemkey,
7366: aname => 'RESPONSIBILITY_ID');
7367:
7368: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

7364: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7365: itemkey => itemkey,
7366: aname => 'RESPONSIBILITY_ID');
7367:
7368: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7369: itemkey => itemkey,
7370: aname => 'APPLICATION_ID');
7371:
7372: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);

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

7374: end if;
7375:
7376:
7377: -- Set the multi-org context
7378: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7379: itemkey => itemkey,
7380: aname => 'ORG_ID');
7381:
7382: IF l_orgid is NOT NULL THEN

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

7441: resultout := wf_engine.eng_null;
7442: return;
7443: end if;
7444:
7445: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7446: itemkey => itemkey,
7447: aname => 'CHANGE_REQUEST_GROUP_ID');
7448:
7449: -- Set the multi-org context

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

7446: itemkey => itemkey,
7447: aname => 'CHANGE_REQUEST_GROUP_ID');
7448:
7449: -- Set the multi-org context
7450: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7451: itemkey => itemkey,
7452: aname => 'ORG_ID');
7453:
7454: IF l_orgid is NOT NULL THEN

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

7521:
7522: end if;
7523:
7524:
7525: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7526: itemkey => itemkey,
7527: aname => 'CHANGE_REQUEST_GROUP_ID');
7528:
7529: -- Set the multi-org context

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

7526: itemkey => itemkey,
7527: aname => 'CHANGE_REQUEST_GROUP_ID');
7528:
7529: -- Set the multi-org context
7530: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7531: itemkey => itemkey,
7532: aname => 'ORG_ID');
7533:
7534: IF l_orgid is NOT NULL THEN

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

7641:
7642: end if;
7643:
7644:
7645: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7646: itemkey => itemkey,
7647: aname => 'CHANGE_REQUEST_GROUP_ID');
7648:
7649: -- Set the multi-org context

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

7646: itemkey => itemkey,
7647: aname => 'CHANGE_REQUEST_GROUP_ID');
7648:
7649: -- Set the multi-org context
7650: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7651: itemkey => itemkey,
7652: aname => 'ORG_ID');
7653:
7654: IF l_orgid is NOT NULL THEN

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

7766: resultout := wf_engine.eng_null;
7767: return;
7768: end if;
7769:
7770: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7771: itemkey => itemkey,
7772: aname => 'CHANGE_REQUEST_GROUP_ID');
7773:
7774: -- Set the multi-org context

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

7771: itemkey => itemkey,
7772: aname => 'CHANGE_REQUEST_GROUP_ID');
7773:
7774: -- Set the multi-org context
7775: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7776: itemkey => itemkey,
7777: aname => 'ORG_ID');
7778:
7779: IF l_orgid is NOT NULL THEN

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

7843:
7844: end if;
7845:
7846: -- Set the multi-org context
7847: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
7848: itemkey => itemkey,
7849: aname => 'ORG_ID' );
7850:
7851: IF l_orgid is NOT NULL THEN

Line 7857: l_req_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

7853: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7854:
7855: END IF;
7856:
7857: l_req_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
7858: itemtype => itemtype,
7859: itemkey => itemkey,
7860: aname => 'REQ_CHANGE_GROUP_ID');
7861:

Line 7862: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

7858: itemtype => itemtype,
7859: itemkey => itemkey,
7860: aname => 'REQ_CHANGE_GROUP_ID');
7861:
7862: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
7863: itemtype => itemtype,
7864: itemkey => itemkey,
7865: aname => 'REQ_HEADER_ID');
7866:

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

7950: return;
7951: end if;
7952:
7953: -- Set the multi-org context
7954: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7955: itemkey => itemkey,
7956: aname => 'ORG_ID');
7957:
7958: IF l_orgid is NOT NULL THEN

Line 7964: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber

7960: END IF;
7961:
7962: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 02';
7963:
7964: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber
7965: (itemtype => itemtype,
7966: itemkey => itemkey,
7967: aname => 'REQ_CHANGE_GROUP_ID');
7968:

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

8000: if ( l_rco_wf_available = 'Y') then
8001:
8002: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 04:' || l_req_item_type || '-' || l_req_item_key;
8003:
8004: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
8005: itemkey=>l_req_item_key,
8006: aname =>'TOTAL_AMOUNT_DSP');
8007:
8008: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 05:';

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

8006: aname =>'TOTAL_AMOUNT_DSP');
8007:
8008: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 05:';
8009:
8010: l_functional_currency:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
8011: itemkey=>l_req_item_key,
8012: aname =>'FUNCTIONAL_CURRENCY');
8013:
8014: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 06:';

Line 8016: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

8012: aname =>'FUNCTIONAL_CURRENCY');
8013:
8014: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 06:';
8015:
8016: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
8017: (itemtype => l_req_item_type,
8018: itemkey => l_req_item_key,
8019: aname => 'DOCUMENT_ID');
8020:

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

8017: (itemtype => l_req_item_type,
8018: itemkey => l_req_item_key,
8019: aname => 'DOCUMENT_ID');
8020:
8021: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
8022: itemkey=>l_req_item_key,
8023: aname =>'IS_AME_APPROVAL');
8024:
8025: l_contractor_req_flag:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,

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

8021: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
8022: itemkey=>l_req_item_key,
8023: aname =>'IS_AME_APPROVAL');
8024:
8025: l_contractor_req_flag:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
8026: itemkey=>l_req_item_key,
8027: aname =>'CONTRACTOR_REQUISITION_FLAG');
8028:
8029: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber

Line 8029: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber

8025: l_contractor_req_flag:= PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>l_req_item_type,
8026: itemkey=>l_req_item_key,
8027: aname =>'CONTRACTOR_REQUISITION_FLAG');
8028:
8029: l_req_change_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber
8030: (itemtype => l_req_item_type,
8031: itemkey => l_req_item_key,
8032: aname => 'CHANGE_REQUEST_GROUP_ID');
8033:

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

8030: (itemtype => l_req_item_type,
8031: itemkey => l_req_item_key,
8032: aname => 'CHANGE_REQUEST_GROUP_ID');
8033:
8034: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8035: itemkey => itemkey,
8036: aname => 'IS_AME_APPROVAL',
8037: avalue => l_is_ame_approval);
8038:

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

8035: itemkey => itemkey,
8036: aname => 'IS_AME_APPROVAL',
8037: avalue => l_is_ame_approval);
8038:
8039: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8040: itemkey => itemkey,
8041: aname => 'CONTRACTOR_REQUISITION_FLAG',
8042: avalue => l_contractor_req_flag);
8043:

Line 8049: l_note := PO_WF_UTIL_PKG.GetItemAttrText

8045: t_varval(1) := l_total_amount_dsp;
8046: t_varname(2) := 'FUNCTIONAL_CURRENCY';
8047: t_varval(2) := l_functional_currency;
8048:
8049: l_note := PO_WF_UTIL_PKG.GetItemAttrText
8050: (itemtype => l_req_item_type,
8051: itemkey => l_req_item_key,
8052: aname => 'JUSTIFICATION');
8053:

Line 8054: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText

8050: (itemtype => l_req_item_type,
8051: itemkey => l_req_item_key,
8052: aname => 'JUSTIFICATION');
8053:
8054: l_old_amount_currency := PO_WF_UTIL_PKG.GetItemAttrText
8055: ( itemtype => l_req_item_type,
8056: itemkey => l_req_item_key,
8057: aname => 'REQ_AMOUNT_CURRENCY_DSP');
8058:

Line 8059: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText

8055: ( itemtype => l_req_item_type,
8056: itemkey => l_req_item_key,
8057: aname => 'REQ_AMOUNT_CURRENCY_DSP');
8058:
8059: l_old_tax_currency:= PO_WF_UTIL_PKG.GetItemAttrText
8060: ( itemtype => l_req_item_type,
8061: itemkey => l_req_item_key,
8062: aname => 'TAX_AMOUNT_CURRENCY_DSP');
8063:

Line 8131: l_preparer_display_name := PO_WF_UTIL_PKG.GetItemAttrText

8127: x_amount_for_subject => l_amount_for_subject,
8128: x_amount_for_header => l_amount_for_header,
8129: x_amount_for_tax => l_amount_for_tax);
8130:
8131: l_preparer_display_name := PO_WF_UTIL_PKG.GetItemAttrText
8132: ( itemtype => l_req_item_type,
8133: itemkey => l_req_item_key,
8134: aname => 'PREPARER_DISPLAY_NAME' );
8135:

Line 8136: l_preparer_user_name := PO_WF_UTIL_PKG.GetItemAttrText

8132: ( itemtype => l_req_item_type,
8133: itemkey => l_req_item_key,
8134: aname => 'PREPARER_DISPLAY_NAME' );
8135:
8136: l_preparer_user_name := PO_WF_UTIL_PKG.GetItemAttrText
8137: ( itemtype => l_req_item_type,
8138: itemkey => l_req_item_key,
8139: aname => 'PREPARER_USER_NAME' );
8140: --Added by Xiao and Eric for IL PO Notification on Apr-2-2009, Begin

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

8186: INTO l_document_id
8187: FROM po_change_requests pcr
8188: WHERE pcr.change_request_group_id = l_req_change_group_id and rownum=1;
8189:
8190: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
8191: itemkey => itemkey,
8192: aname => 'REQ_HEADER_ID',
8193: avalue => l_document_id);
8194:

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

8368:
8369: end if;
8370:
8371:
8372: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8373: itemkey => itemkey,
8374: aname => 'CHANGE_REQUEST_GROUP_ID');
8375:
8376: -- Set the multi-org context

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

8373: itemkey => itemkey,
8374: aname => 'CHANGE_REQUEST_GROUP_ID');
8375:
8376: -- Set the multi-org context
8377: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8378: itemkey => itemkey,
8379: aname => 'ORG_ID');
8380:
8381: IF l_orgid is NOT NULL THEN

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

8486: where pcr.change_request_group_id=l_change_request_group_id
8487: and pcr.document_header_id=por.requisition_header_id;
8488:
8489: BEGIN
8490: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8491: itemkey => itemkey,
8492: aname => 'DOCUMENT_ID');
8493: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8494: itemkey => itemkey,

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

8489: BEGIN
8490: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8491: itemkey => itemkey,
8492: aname => 'DOCUMENT_ID');
8493: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8494: itemkey => itemkey,
8495: aname => 'DOCUMENT_TYPE');
8496:
8497: IF l_document_type = 'PO' THEN

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

8517:
8518: END IF;
8519:
8520:
8521: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
8522: itemkey => itemkey,
8523: aname => 'ORG_ID',
8524: avalue => l_org_id);
8525:

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

8527: -- get Buyer's name
8528: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_buyer_name, l_buyer_display_name);
8529:
8530: -- set value of BUYER_USER_NAME WF attribute
8531: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
8532: itemkey => itemkey,
8533: aname => 'BUYER_USER_NAME',
8534: avalue => l_buyer_name );
8535: -- Set value of Document Number attribute

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

8532: itemkey => itemkey,
8533: aname => 'BUYER_USER_NAME',
8534: avalue => l_buyer_name );
8535: -- Set value of Document Number attribute
8536: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
8537: itemkey => itemkey,
8538: aname => 'DOCUMENT_NUMBER',
8539: avalue => l_document_num);
8540: -- Set value of DOCUMENT_TYPE_DISP attribute

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

8537: itemkey => itemkey,
8538: aname => 'DOCUMENT_NUMBER',
8539: avalue => l_document_num);
8540: -- Set value of DOCUMENT_TYPE_DISP attribute
8541: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
8542: itemkey => itemkey,
8543: aname => 'DOCUMENT_TYPE_DISP',
8544: avalue => l_document_type_disp);
8545:

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

8542: itemkey => itemkey,
8543: aname => 'DOCUMENT_TYPE_DISP',
8544: avalue => l_document_type_disp);
8545:
8546: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
8547: itemkey => itemkey,
8548: aname => 'PO_DOCUMENT_REVISION',
8549: avalue => l_document_revision);
8550:

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

8563: close l_get_group_id_po_csr;
8564: l_document_subtype := 'STANDARD';
8565: end if;
8566:
8567: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8568: itemkey => itemkey,
8569: aname => 'DOCUMENT_SUBTYPE',
8570: avalue =>l_document_subtype);
8571:

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

8568: itemkey => itemkey,
8569: aname => 'DOCUMENT_SUBTYPE',
8570: avalue =>l_document_subtype);
8571:
8572: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
8573: itemkey => itemkey,
8574: aname => 'CHANGE_REQUEST_GROUP_ID',
8575: avalue => l_change_request_group_id);
8576:

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

8583: close change_request;
8584:
8585: PO_REQAPPROVAL_INIT1.get_user_name(l_requester_id, l_requester_name, l_requester_display_name);
8586:
8587: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8588: itemkey => itemkey,
8589: aname => 'PREPARER_USER_NAME',
8590: avalue =>l_requester_name);
8591:

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

8588: itemkey => itemkey,
8589: aname => 'PREPARER_USER_NAME',
8590: avalue =>l_requester_name);
8591:
8592: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8593: itemkey => itemkey,
8594: aname => 'PREPARER_DISPLAY_NAME',
8595: avalue =>l_requester_display_name);
8596:

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

8593: itemkey => itemkey,
8594: aname => 'PREPARER_DISPLAY_NAME',
8595: avalue =>l_requester_display_name);
8596:
8597: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8598: itemkey => itemkey,
8599: aname => 'FORWARD_FROM_USERNAME',
8600: avalue =>l_requester_display_name);
8601:

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

8600: avalue =>l_requester_display_name);
8601:
8602:
8603:
8604: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8605: itemkey => itemkey,
8606: aname => 'REQ_CHANGE_RESPONSE_NOTIF_BODY',
8607: avalue =>
8608: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||

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

8657: resultout := wf_engine.eng_null;
8658: return;
8659: end if;
8660:
8661: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8662: itemkey => itemkey,
8663: aname => 'CHANGE_REQUEST_GROUP_ID');
8664:
8665: -- Set the multi-org context

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

8662: itemkey => itemkey,
8663: aname => 'CHANGE_REQUEST_GROUP_ID');
8664:
8665: -- Set the multi-org context
8666: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8667: itemkey => itemkey,
8668: aname => 'ORG_ID');
8669:
8670: IF l_orgid is NOT NULL THEN

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

8677: fetch new_change into l_change_request_id;
8678: close new_change;
8679:
8680: if(l_change_request_id is null) then
8681: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8682: itemkey => itemkey,
8683: aname => 'DOCUMENT_ID');
8684: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8685: itemkey => itemkey,

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

8680: if(l_change_request_id is null) then
8681: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8682: itemkey => itemkey,
8683: aname => 'DOCUMENT_ID');
8684: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8685: itemkey => itemkey,
8686: aname => 'DOCUMENT_TYPE');
8687:
8688: --Moved the update to po_headers/po_releases to an autonomous transaction procedure UpdatePODocheaderTables

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

8743:
8744: end if;
8745:
8746:
8747: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8748: itemkey => itemkey,
8749: aname => 'CHANGE_REQUEST_GROUP_ID');
8750:
8751: -- Set the multi-org context

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

8748: itemkey => itemkey,
8749: aname => 'CHANGE_REQUEST_GROUP_ID');
8750:
8751: -- Set the multi-org context
8752: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8753: itemkey => itemkey,
8754: aname => 'ORG_ID');
8755:
8756: IF l_orgid is NOT NULL THEN

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

8809:
8810: end if;
8811:
8812:
8813: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8814: itemkey => itemkey,
8815: aname => 'CHANGE_REQUEST_GROUP_ID');
8816:
8817: -- Set the multi-org context

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

8814: itemkey => itemkey,
8815: aname => 'CHANGE_REQUEST_GROUP_ID');
8816:
8817: -- Set the multi-org context
8818: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8819: itemkey => itemkey,
8820: aname => 'ORG_ID');
8821:
8822: IF l_orgid is NOT NULL THEN

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

8878:
8879: end if;
8880:
8881:
8882: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8883: itemkey => itemkey,
8884: aname => 'CHANGE_REQUEST_GROUP_ID');
8885:
8886: -- Set the multi-org context

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

8883: itemkey => itemkey,
8884: aname => 'CHANGE_REQUEST_GROUP_ID');
8885:
8886: -- Set the multi-org context
8887: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
8888: itemkey => itemkey,
8889: aname => 'ORG_ID');
8890:
8891: IF l_orgid is NOT NULL THEN

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

8944: and initiator='REQUESTER'
8945: and document_type='RELEASE';
8946: BEGIN
8947:
8948: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8949: itemkey => itemkey,
8950: aname => 'DOCUMENT_ID');
8951: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8952: itemkey => itemkey,

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

8947:
8948: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
8949: itemkey => itemkey,
8950: aname => 'DOCUMENT_ID');
8951: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8952: itemkey => itemkey,
8953: aname => 'DOCUMENT_TYPE');
8954:
8955: if(l_document_type = 'RELEASE') then

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

8995: l_seq number;
8996: l_item_key varchar2(240);
8997: x_progress varchar2(3) := '000';
8998: BEGIN
8999: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
9000: itemkey => itemkey,
9001: aname => 'DOCUMENT_ID');
9002: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
9003: itemkey => itemkey,

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

8998: BEGIN
8999: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
9000: itemkey => itemkey,
9001: aname => 'DOCUMENT_ID');
9002: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
9003: itemkey => itemkey,
9004: aname => 'DOCUMENT_TYPE');
9005:
9006: select PO_REQUESTER_CHANGE_WF_S.nextval into l_seq from dual;

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

9009: l_item_key := 'RC_REL'||'-'||l_document_id||'-'||l_seq;
9010: else
9011: l_item_key := 'RC_PO'||'-'||l_document_id||'-'||l_seq;
9012: end if;
9013: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
9014: itemkey => itemkey,
9015: aname => 'REQ_CHANGE_EVENT_KEY',
9016: avalue => l_item_key );
9017:

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

9157: -- workflow to convert the change request.
9158: begin
9159: wf_engine.abortprocess(l_wf_item_type, l_wf_item_key);
9160:
9161: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_wf_item_type,
9162: itemkey => l_wf_item_key,
9163: aname => 'NOTE');
9164:
9165: PO_APPROVAL_LIST_HISTORY_SV.Update_Action_History(

Line 9346: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(

9342: open get_parent_info_csr(p_change_request_group_id);
9343: fetch get_parent_info_csr into l_parent_item_type, l_parent_item_key;
9344: close get_parent_info_csr;
9345:
9346: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
9347: itemtype=>l_parent_item_type,
9348: itemkey=>l_parent_item_key,
9349: aname =>'RESPONDER_USER_NAME');
9350: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

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

9346: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
9347: itemtype=>l_parent_item_type,
9348: itemkey=>l_parent_item_key,
9349: aname =>'RESPONDER_USER_NAME');
9350: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9351: itemkey => l_parent_item_key,
9352: aname => 'USER_ID');
9353:
9354: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

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

9350: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9351: itemkey => l_parent_item_key,
9352: aname => 'USER_ID');
9353:
9354: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9355: itemkey => l_parent_item_key,
9356: aname => 'RESPONSIBILITY_ID');
9357: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9358: itemkey => l_parent_item_key,

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

9353:
9354: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9355: itemkey => l_parent_item_key,
9356: aname => 'RESPONSIBILITY_ID');
9357: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9358: itemkey => l_parent_item_key,
9359: aname => 'APPLICATION_ID');
9360:
9361:

Line 9546: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(

9542: END IF;
9543:
9544: if ( l_parent_wf_available = 'Y') then
9545:
9546: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
9547: itemtype=>l_parent_item_type,
9548: itemkey=>l_parent_item_key,
9549: aname =>'RESPONDER_USER_NAME');
9550:

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

9547: itemtype=>l_parent_item_type,
9548: itemkey=>l_parent_item_key,
9549: aname =>'RESPONDER_USER_NAME');
9550:
9551: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9552: itemkey => l_parent_item_key,
9553: aname => 'USER_ID');
9554:
9555: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

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

9551: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9552: itemkey => l_parent_item_key,
9553: aname => 'USER_ID');
9554:
9555: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9556: itemkey => l_parent_item_key,
9557: aname => 'RESPONSIBILITY_ID');
9558:
9559: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,

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

9555: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9556: itemkey => l_parent_item_key,
9557: aname => 'RESPONSIBILITY_ID');
9558:
9559: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_parent_item_type,
9560: itemkey => l_parent_item_key,
9561: aname => 'APPLICATION_ID');
9562:
9563: x_progress:='005';

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

9626: l_change_request_id number:=null;
9627: x_progress varchar2(3) := '000';
9628: BEGIN
9629:
9630: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
9631: itemkey => itemkey,
9632: aname => 'DOCUMENT_ID');
9633:
9634: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

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

9630: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
9631: itemkey => itemkey,
9632: aname => 'DOCUMENT_ID');
9633:
9634: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
9635: itemkey => itemkey,
9636: aname => 'DOCUMENT_TYPE');
9637:
9638: IF (l_document_type = 'RELEASE') THEN

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

9970: resultout := wf_engine.eng_null;
9971: return;
9972: end if;
9973:
9974: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9975: itemkey => itemkey,
9976: aname => 'DOCUMENT_ID');
9977:
9978: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

9974: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9975: itemkey => itemkey,
9976: aname => 'DOCUMENT_ID');
9977:
9978: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9979: itemkey => itemkey,
9980: aname => 'DOCUMENT_TYPE');
9981:
9982: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 9982: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

9978: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9979: itemkey => itemkey,
9980: aname => 'DOCUMENT_TYPE');
9981:
9982: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
9983: itemtype => itemtype,
9984: itemkey => itemkey,
9985: aname => 'CHANGE_REQUEST_GROUP_ID');
9986:

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

9984: itemkey => itemkey,
9985: aname => 'CHANGE_REQUEST_GROUP_ID');
9986:
9987: -- Set the multi-org context
9988: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9989: itemkey => itemkey,
9990: aname => 'ORG_ID');
9991:
9992: IF l_orgid is NOT NULL THEN

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

10027: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 04';
10028:
10029: -- set the order totals and the order date.
10030: -- These are used by approval notification
10031: PO_WF_UTIL_PKG.SetItemAttrDate ( itemtype => itemtype,
10032: itemkey => itemkey,
10033: aname => 'ORDER_DATE',
10034: avalue => l_order_date);
10035:

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

10032: itemkey => itemkey,
10033: aname => 'ORDER_DATE',
10034: avalue => l_order_date);
10035:
10036: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10037: itemkey => itemkey,
10038: aname => 'OLD_ORD_TOTAL_CURRENCY_DSP',
10039: avalue => to_char(l_old_total,
10040: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,

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

10039: avalue => to_char(l_old_total,
10040: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,
10041: g_currency_format_mask))
10042: || ' ' ||l_po_currency);
10043: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10044: itemkey => itemkey,
10045: aname => 'NEW_ORD_TOTAL_CURRENCY_DSP',
10046: avalue => to_char(l_new_total,
10047: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,

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

10089: x_progress VARCHAR2(3) := '000';
10090: BEGIN
10091:
10092: l_change_request_group_id :=
10093: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
10094: itemkey => itemkey,
10095: aname => 'CHANGE_REQUEST_GROUP_ID');
10096:
10097: x_progress := '001';

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

10127: p_chg_req_grp_id => l_po_request_group_id );
10128:
10129: -- set change_pending flag to 'N' for the req
10130: l_req_document_id :=
10131: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
10132: itemkey => itemkey,
10133: aname => 'DOCUMENT_ID');
10134:
10135: SetReqChangeFlag(l_change_request_group_id, l_req_document_id, itemtype, itemkey, 'N');

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

10161: l_temp_status varchar2(1000);
10162: BEGIN
10163:
10164: l_change_request_group_id :=
10165: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
10166: itemkey => itemkey,
10167: aname => 'CHANGE_REQUEST_GROUP_ID');
10168: x_progress := '001';
10169:

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

10167: aname => 'CHANGE_REQUEST_GROUP_ID');
10168: x_progress := '001';
10169:
10170: l_document_id :=
10171: PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
10172: itemkey => itemkey,
10173: aname => 'DOCUMENT_ID');
10174: x_progress := '002';
10175:

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

10235:
10236: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 02';
10237:
10238: -- Set the multi-org context
10239: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
10240: itemkey => itemkey,
10241: aname => 'ORG_ID');
10242:
10243: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 03';

Line 10253: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10249: END IF;
10250:
10251: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 04';
10252:
10253: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10254: itemtype => itemtype,
10255: itemkey => itemkey,
10256: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10257:

Line 10335: l_po_chg_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10331: l_creation_method po_headers_all.document_creation_method%TYPE;
10332: l_document_type po_change_requests.document_type%TYPE;
10333: BEGIN
10334:
10335: l_po_chg_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10336: itemtype => itemtype,
10337: itemkey => itemkey,
10338: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10339:

Line 10340: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (

10336: itemtype => itemtype,
10337: itemkey => itemkey,
10338: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10339:
10340: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (
10341: itemtype => itemtype,
10342: itemkey => itemkey,
10343: aname => 'PO_DOCUMENT_TYPE');
10344:

Line 10433: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10429: end if;
10430:
10431: l_progress := 'PO_ReqChangeRequestWF_PVT.More_Po_To_Process: 01';
10432:
10433: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10434: itemtype => itemtype,
10435: itemkey => itemkey,
10436: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10437:

Line 10440: l_change_request_grp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10436: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10437:
10438: l_progress := 'PO_ReqChangeRequestWF_PVT.More_Po_To_Process: 02';
10439:
10440: l_change_request_grp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10441: itemtype => itemtype,
10442: itemkey => itemkey,
10443: aname => 'CHANGE_REQUEST_GROUP_ID');
10444:

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

10459:
10460: -- when next po change request group id is found
10461: IF (l_next_po_grp_id IS NOT NULL) THEN
10462:
10463: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
10464: itemkey => itemkey,
10465: aname => 'PO_CHANGE_REQUEST_GROUP_ID',
10466: avalue => l_next_po_grp_id );
10467:

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

10470: into l_po_document_type, l_po_document_rev, l_po_document_id
10471: FROM po_change_requests
10472: WHERE change_request_group_id = l_next_po_grp_id AND rownum=1;
10473:
10474: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10475: itemkey => itemkey,
10476: aname => 'PO_DOCUMENT_TYPE',
10477: avalue => l_po_document_type );
10478:

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

10475: itemkey => itemkey,
10476: aname => 'PO_DOCUMENT_TYPE',
10477: avalue => l_po_document_type );
10478:
10479: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10480: itemkey => itemkey,
10481: aname => 'PO_DOCUMENT_REVISION',
10482: avalue => l_po_document_rev );
10483:

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

10480: itemkey => itemkey,
10481: aname => 'PO_DOCUMENT_REVISION',
10482: avalue => l_po_document_rev );
10483:
10484: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
10485: itemkey => itemkey,
10486: aname => 'CURRENT_PO_HEADER_ID',
10487: avalue => l_po_document_id );
10488: l_result := 'Y';

Line 10540: l_po_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

10536: end if;
10537:
10538: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 01';
10539:
10540: l_po_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
10541: itemtype => itemtype,
10542: itemkey => itemkey,
10543: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10544:

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

10579: -- get Buyer's name
10580: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_buyer_name, l_buyer_display_name);
10581:
10582: -- set value of BUYER_USER_NAME WF attribute
10583: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10584: itemkey => itemkey,
10585: aname => 'BUYER_USER_NAME',
10586: avalue => l_buyer_name );
10587:

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

10585: aname => 'BUYER_USER_NAME',
10586: avalue => l_buyer_name );
10587:
10588: -- set value of PO_ORDER_DATE WF attribute
10589: PO_WF_UTIL_PKG.SetItemAttrDate( itemtype => itemtype,
10590: itemkey => itemkey,
10591: aname => 'PO_ORDER_DATE',
10592: avalue => l_order_date );
10593:

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

10591: aname => 'PO_ORDER_DATE',
10592: avalue => l_order_date );
10593:
10594: -- set value of PO_DOCUMENT_NUMBER WF attribute
10595: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10596: itemkey => itemkey,
10597: aname => 'PO_DOCUMENT_NUMBER',
10598: avalue => l_document_number );
10599:

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

10692: end if;
10693:
10694: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 02';
10695:
10696: l_po_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
10697: itemkey => itemkey,
10698: aname => 'CURRENT_PO_HEADER_ID');
10699:
10700: l_po_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

10696: l_po_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
10697: itemkey => itemkey,
10698: aname => 'CURRENT_PO_HEADER_ID');
10699:
10700: l_po_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
10701: itemkey => itemkey,
10702: aname => 'PO_DOCUMENT_TYPE');
10703:
10704: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 03';

Line 10726: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

10722: END IF;
10723:
10724: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 04';
10725:
10726: l_po_chg_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
10727: itemtype => itemtype,
10728: itemkey => itemkey,
10729: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10730:

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

10729: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
10730:
10731: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 05';
10732:
10733: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
10734: itemkey => itemkey,
10735: aname => 'ORG_ID');
10736:
10737: -- get the order total (old/new)

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

10743: x_new_total =>l_new_total);
10744:
10745: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 06';
10746:
10747: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10748: itemkey => itemkey,
10749: aname => 'OLD_PO_TOTAL',
10750: avalue =>
10751: to_char(l_old_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);

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

10749: aname => 'OLD_PO_TOTAL',
10750: avalue =>
10751: to_char(l_old_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);
10752:
10753: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10754: itemkey => itemkey,
10755: aname => 'NEW_PO_TOTAL',
10756: avalue =>
10757: to_char(l_new_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);

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

11178: resultout := wf_engine.eng_null;
11179: RETURN;
11180: END IF;
11181:
11182: l_pochggrp_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
11183: itemkey => itemkey,
11184: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
11185: l_poheader_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
11186: itemkey => itemkey,

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

11181:
11182: l_pochggrp_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
11183: itemkey => itemkey,
11184: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
11185: l_poheader_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
11186: itemkey => itemkey,
11187: aname => 'CURRENT_PO_HEADER_ID');
11188:
11189: IF (g_po_wf_debug = 'Y') THEN

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

11196: IF ( l_poheader_id is not null ) THEN
11197: -- bug 5363103
11198: -- To simply the logic, if PO is created in txn currency, RCO always needs buyer approval.
11199:
11200: l_po_doc_type := PO_WF_UTIL_PKG.GetItemAttrText( itemtype => itemtype,
11201: itemkey => itemkey,
11202: aname => 'PO_DOCUMENT_TYPE');
11203:
11204: -- For releases, the current doc header id is the release id

Line 11316: l_req_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

11312: END IF;
11313:
11314: l_progress := 'PO_ReqChangeRequestWF_PVT.More_Req_To_Process: 01';
11315:
11316: l_req_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
11317: itemtype => itemtype,
11318: itemkey => itemkey,
11319: aname => 'REQ_CHANGE_GROUP_ID');
11320:

Line 11323: l_po_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

11319: aname => 'REQ_CHANGE_GROUP_ID');
11320:
11321: l_progress := 'PO_ReqChangeRequestWF_PVT.More_Req_To_Process: 02';
11322:
11323: l_po_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
11324: itemtype => itemtype,
11325: itemkey => itemkey,
11326: aname => 'CHANGE_REQUEST_GROUP_ID');
11327:

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

11341:
11342: -- when next po change request group id is found
11343: IF (l_next_req_grp_id IS NOT NULL) THEN
11344:
11345: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
11346: itemkey => itemkey,
11347: aname => 'REQ_CHANGE_GROUP_ID',
11348: avalue => l_next_req_grp_id );
11349:

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

11351: INTO l_document_id, l_document_num
11352: FROM po_change_requests
11353: WHERE change_request_group_id = l_next_req_grp_id AND rownum=1;
11354:
11355: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype,
11356: itemkey => itemkey,
11357: aname => 'REQ_HEADER_ID',
11358: avalue => l_document_id );
11359:

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

11356: itemkey => itemkey,
11357: aname => 'REQ_HEADER_ID',
11358: avalue => l_document_id );
11359:
11360: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
11361: itemkey => itemkey,
11362: aname => 'REQUISITION_NUMBER',
11363: avalue => l_document_num );
11364: l_result := 'Y';

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

11401: return;
11402: END IF;
11403:
11404: -- Set the multi-org context
11405: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
11406: itemkey => itemkey,
11407: aname => 'ORG_ID');
11408:
11409: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 02';

Line 11417: l_po_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

11413: END IF;
11414:
11415: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 03';
11416:
11417: l_po_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
11418: itemtype => itemtype,
11419: itemkey => itemkey,
11420: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
11421:

Line 11473: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(

11469: l_item_key:='NOTIFREQ_'||to_char(p_po_change_request_group_id)||'_'||to_char(l_count);
11470:
11471: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_NotifyRequesterProcess: 02' || ' ITEM KEY:' || l_item_key;
11472:
11473: l_forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText(
11474: itemtype=>p_req_item_type,
11475: itemkey=>p_req_item_key,
11476: aname =>'RESPONDER_USER_NAME');
11477:

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

11474: itemtype=>p_req_item_type,
11475: itemkey=>p_req_item_key,
11476: aname =>'RESPONDER_USER_NAME');
11477:
11478: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => p_req_item_type,
11479: itemkey => p_req_item_key,
11480: aname => 'USER_ID');
11481:
11482: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

Line 11482: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

11478: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => p_req_item_type,
11479: itemkey => p_req_item_key,
11480: aname => 'USER_ID');
11481:
11482: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
11483: itemtype => p_req_item_type,
11484: itemkey => p_req_item_key,
11485: aname => 'RESPONSIBILITY_ID');
11486:

Line 11487: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

11483: itemtype => p_req_item_type,
11484: itemkey => p_req_item_key,
11485: aname => 'RESPONSIBILITY_ID');
11486:
11487: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
11488: itemtype => p_req_item_type,
11489: itemkey => p_req_item_key,
11490: aname => 'APPLICATION_ID');
11491:

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

12022: x_progress VARCHAR2(100) := '001';
12023: l_CHANGE_REQUEST_ID number;
12024: l_return_msg VARCHAR2(200);
12025: BEGIN
12026: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
12027: itemkey => itemkey,
12028: aname => 'CHANGE_REQUEST_GROUP_ID');
12029: x_progress := '002';
12030: --query the pcr table to get these values to pass to the public api

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

12119: FROM po_change_requests
12120: WHERE change_request_group_id = l_change_request_group_id
12121: AND request_status = 'ACCEPTED';
12122:
12123: po_wf_util_pkg.setitemattrnumber (itemtype => itemtype,
12124: itemkey => itemkey,
12125: aname => 'INTERNAL_CHANGE_REQUEST_ID',
12126: avalue => L_CHANGE_REQUEST_ID);
12127:

Line 13094: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (

13090: RETURN;
13091: END IF;
13092:
13093:
13094: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (
13095: itemtype => itemtype,
13096: itemkey => itemkey,
13097: aname => 'CHANGE_REQUEST_GROUP_ID');
13098:

Line 13100: l_change_request_id := po_wf_util_pkg.getitemattrnumber (

13096: itemkey => itemkey,
13097: aname => 'CHANGE_REQUEST_GROUP_ID');
13098:
13099:
13100: l_change_request_id := po_wf_util_pkg.getitemattrnumber (
13101: itemtype => itemtype,
13102: itemkey => itemkey,
13103: aname => 'INTERNAL_CHANGE_REQUEST_ID');
13104:

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

13128:
13129: */
13130:
13131: l_planner_id := 0;
13132: l_PLANNERS_NOTIFIED := po_wf_util_pkg.getitemattrtext ( itemtype => itemtype,
13133: itemkey => itemkey,
13134: aname => 'PLANNERS_NOTIFIED');
13135:
13136: l_sql := '

Line 13237: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (

13233: RETURN;
13234: END IF;
13235:
13236:
13237: l_change_request_group_id := po_wf_util_pkg.getitemattrnumber (
13238: itemtype => itemtype,
13239: itemkey => itemkey,
13240: aname => 'CHANGE_REQUEST_GROUP_ID');
13241:

Line 13243: l_old_change_request_id := po_wf_util_pkg.getitemattrnumber (

13239: itemkey => itemkey,
13240: aname => 'CHANGE_REQUEST_GROUP_ID');
13241:
13242:
13243: l_old_change_request_id := po_wf_util_pkg.getitemattrnumber (
13244: itemtype => itemtype,
13245: itemkey => itemkey,
13246: aname => 'INTERNAL_CHANGE_REQUEST_ID');
13247:

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

13259: WHEN NO_DATA_FOUND THEN
13260: L_NEW_CHANGE_REQUEST_ID := -99;
13261: END;
13262: IF (L_NEW_CHANGE_REQUEST_ID <> -99) THEN
13263: po_wf_util_pkg.setitemattrnumber (itemtype => itemtype,
13264: itemkey => itemkey,
13265: aname => 'INTERNAL_CHANGE_REQUEST_ID',
13266: avalue => L_NEW_CHANGE_REQUEST_ID);
13267: