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 4322: t_varval(6) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||to_char(p_change_request_group_id);

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

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

4644: t_varval(4) := l_preparer_username;
4645: t_varname(5) := 'PREPARER_DISPLAY_NAME';
4646: t_varval(5) := l_preparer_display_name;
4647: t_varname(6) := 'PO_CHANGE_APPROVAL_NOTIF_BODY';
4648: t_varval(6) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_po_chg_approval_notif/'
4649: ||to_char(p_change_request_group_id);
4650: t_varname(7) := 'DOCUMENT_NUMBER';
4651: t_varval(7) := l_document_num;
4652: t_varname(8) := 'REQ_CHANGE_RESPONSE_NOTIF_BODY';

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

4649: ||to_char(p_change_request_group_id);
4650: t_varname(7) := 'DOCUMENT_NUMBER';
4651: t_varval(7) := l_document_num;
4652: t_varname(8) := 'REQ_CHANGE_RESPONSE_NOTIF_BODY';
4653: t_varval(8) := 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'
4654: ||to_char(l_parent_group_id);
4655: t_varname(9) := 'REQUISITION_NUMBER';
4656: t_varval(9) := l_requisition_num;
4657: t_varname(10) := 'FORWARD_FROM_USERNAME';

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

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/'||
4983: itemtype||':'||
4984: itemkey);
4985: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4986: itemkey => itemkey,

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

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/'||
4990: to_char(l_change_request_group_id));
4991:
4992: /*
4993: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

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

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);
4998:
4999: */
5000: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes: 02';
5001: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

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

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/'||
8609: to_char(l_parent_group_id));
8610:
8611: exception when others then
8612: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Change_Attribute',x_progress);

Line 9910: get_formatted_total(PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount(

9906:
9907: if ( l_pcr_action_type <> 'CANCELLATION') then
9908:
9909: l_new_total := l_new_total +
9910: get_formatted_total(PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount(
9911: p_org_id,p_change_request_group_id,l_line_id,l_item_id,l_uom,
9912: nvl(l_pcr_old_price, nvl(l_pll_price_override,l_pol_unit_price)),
9913: l_line_loc_id), p_po_currency);
9914:

Line 11105: PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount

11101: sum ( nvl(pcr.old_quantity, nvl(pll.quantity,0))
11102: *pll.price_override ),
11103: sum ( decode ( pcr.document_line_location_id, null, 0,
11104: decode (pcr.action_type , 'CANCELLATION', 0,
11105: PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount
11106: ( pol.org_id,p_pochggrp_id,pol.po_line_id,
11107: pol.item_id,pll.unit_meas_lookup_code,
11108: nvl(pcr.old_price, nvl(pll.price_override, pol.unit_price)),
11109: pll.line_location_id)) ) )

Line 11707: l_new_price:= PO_ReqChangeRequestNotif_PVT.Get_PO_Price_Break_Grp(

11703: l_progress := '006';
11704:
11705: -- quantity change could cause price change, call price break function to update the price
11706: if (l_pcr_new_price is null and l_pcr_new_quantity is not null ) then
11707: l_new_price:= PO_ReqChangeRequestNotif_PVT.Get_PO_Price_Break_Grp(
11708: l_po_org_id,
11709: p_chg_request_grp_id,
11710: p_po_line_id,
11711: l_item_id,