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_REQCHANGEREQUESTNOTIF_PVT

Line 4169: t_varval(6) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||to_char(p_change_request_group_id);

4165: t_varval(4) := 'PO_CANCEL';
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,

Line 4488: t_varval(6) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_po_chg_approval_notif/'

4484: t_varval(4) := l_preparer_username;
4485: t_varname(5) := 'PREPARER_DISPLAY_NAME';
4486: t_varval(5) := l_preparer_display_name;
4487: t_varname(6) := 'PO_CHANGE_APPROVAL_NOTIF_BODY';
4488: t_varval(6) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_po_chg_approval_notif/'
4489: ||to_char(p_change_request_group_id);
4490: t_varname(7) := 'DOCUMENT_NUMBER';
4491: t_varval(7) := l_document_num;
4492: t_varname(8) := 'REQ_CHANGE_RESPONSE_NOTIF_BODY';

Line 4493: t_varval(8) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'

4489: ||to_char(p_change_request_group_id);
4490: t_varname(7) := 'DOCUMENT_NUMBER';
4491: t_varval(7) := l_document_num;
4492: t_varname(8) := 'REQ_CHANGE_RESPONSE_NOTIF_BODY';
4493: t_varval(8) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'
4494: ||to_char(l_parent_group_id);
4495: t_varname(9) := 'REQUISITION_NUMBER';
4496: t_varval(9) := l_requisition_num;
4497: t_varname(10) := 'FORWARD_FROM_USERNAME';

Line 4794: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_approval_notif/'||

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/'||
4795: itemtype||':'||
4796: itemkey);
4797: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4798: itemkey => itemkey,

Line 4801: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||

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/'||
4802: to_char(l_change_request_group_id));
4803:
4804: /*
4805: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

Line 4809: 'plsql:PO_ReqChangeRequestNotif_PVT.get_new_req_amount/'||itemtype||':'||itemkey);

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);
4810:
4811: */
4812: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes: 02';
4813: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

Line 8221: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||

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/'||
8222: to_char(l_parent_group_id));
8223:
8224: exception when others then
8225: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Change_Attribute',x_progress);

Line 9523: get_formatted_total(PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount(

9519:
9520: if ( l_pcr_action_type <> 'CANCELLATION') then
9521:
9522: l_new_total := l_new_total +
9523: get_formatted_total(PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount(
9524: p_org_id,p_change_request_group_id,l_line_id,l_item_id,l_uom,
9525: nvl(l_pcr_old_price, nvl(l_pll_price_override,l_pol_unit_price)),
9526: l_line_loc_id), p_po_currency);
9527:

Line 10715: PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount

10711: sum ( nvl(pcr.old_quantity, nvl(pll.quantity,0))
10712: *pll.price_override ),
10713: sum ( decode ( pcr.document_line_location_id, null, 0,
10714: decode (pcr.action_type , 'CANCELLATION', 0,
10715: PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount
10716: ( pol.org_id,p_pochggrp_id,pol.po_line_id,
10717: pol.item_id,pll.unit_meas_lookup_code,
10718: nvl(pcr.old_price, nvl(pll.price_override, pol.unit_price)),
10719: pll.line_location_id)) ) )

Line 11303: l_new_price:= PO_ReqChangeRequestNotif_PVT.Get_PO_Price_Break_Grp(

11299: l_progress := '006';
11300:
11301: -- quantity change could cause price change, call price break function to update the price
11302: if (l_pcr_new_price is null and l_pcr_new_quantity is not null ) then
11303: l_new_price:= PO_ReqChangeRequestNotif_PVT.Get_PO_Price_Break_Grp(
11304: l_po_org_id,
11305: p_chg_request_grp_id,
11306: p_po_line_id,
11307: l_item_id,