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_REQUISITION_HEADERS_ALL

Line 306: po_requisition_headers_all prh,

302:
303: SELECT ooh.ORG_ID
304: INTO l_org_id
305: from po_requisition_lines_all prl,
306: po_requisition_headers_all prh,
307: oe_order_headers_all ooh,
308: po_system_parameters_all psp
309: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
310: AND prl.requisition_line_id = nvl(p_req_line_id,prl.requisition_line_id)

Line 335: po_requisition_headers_all prh

331:
332: SELECT prh.org_id
333: INTO l_org_id
334: from po_requisition_lines_all prl,
335: po_requisition_headers_all prh
336: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
337: AND prh.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
338: AND prl.requisition_line_id = nvl(p_req_line_id,prl.requisition_line_id)
339: AND nvl(p_req_hdr_id,p_req_line_id) IS NOT NULL

Line 885: update po_requisition_headers_all

881: where change_request_id=l_req_change_request_id;
882:
883: if(l_action_type='CANCELLATION') then
884: if(l_request_level='HEADER') then
885: update po_requisition_headers_all
886: set cancel_flag='Y'
887: where requisition_header_id=l_header_id;
888: else
889: -- it is line level

Line 3612: update po_requisition_headers_all

3608: x_progress varchar2(3):= '000';
3609:
3610: BEGIN
3611:
3612: update po_requisition_headers_all
3613: set last_updated_by = nvl(fnd_global.user_id, last_updated_by),
3614: last_update_login = nvl(fnd_global.login_id, last_update_login),
3615: last_update_date = sysdate,
3616: change_pending_flag=p_change_flag

Line 4106: from po_change_requests pcr, po_requisition_headers_all por

4102: l_total_amount_dsp varchar2(100);
4103: cursor change_request(l_change_request_group_id number) is
4104: select document_header_id, nvl(pcr.requester_id, por.preparer_id),
4105: document_num
4106: from po_change_requests pcr, po_requisition_headers_all por
4107: where pcr.change_request_group_id=l_change_request_group_id
4108: and pcr.document_header_id=por.requisition_header_id;
4109:
4110: l_old_req_amount varchar2(40);

Line 4137: from po_requisition_headers_all

4133: x_progress :='StartConvertProcess:002';
4134:
4135: select org_id
4136: into l_org_id
4137: from po_requisition_headers_all
4138: where requisition_header_id=l_document_id;
4139:
4140: x_progress :='StartConvertProcess:003';
4141:

Line 4318: from po_requisition_headers_all por,

4314: --SQL Why: wf attribute needs it
4315: --SQL Join: parent_change_request_id, requisition_header_id
4316: cursor req_preparer_id(l_change_request_group_id number) is
4317: select por.preparer_id
4318: from po_requisition_headers_all por,
4319: po_change_requests pcr1,
4320: po_change_requests pcr2
4321: where pcr2.change_request_group_id=l_change_request_group_id
4322: and pcr2.parent_change_request_id=pcr1.change_request_id

Line 4335: from po_requisition_headers_all prh, po_change_requests pcr

4331: where change_request_group_id=l_change_request_group_id);
4332:
4333: cursor get_parent_info_csr(l_change_request_group_id number) is
4334: select prh.segment1, pcr.wf_item_type, pcr.wf_item_key, prh.requisition_header_id
4335: from po_requisition_headers_all prh, po_change_requests pcr
4336: where prh.requisition_header_id=pcr.document_header_id
4337: and pcr.change_request_group_id=l_change_request_group_id;
4338:
4339: n_varname Wf_Engine.NameTabTyp;

Line 4833: * set the change_pending_flag in the po_requisition_headers_all

4829: *
4830: * Public Procedure: Update_Req_Change_Flag
4831: * Effects: workflow procedure, called at the beginning of POREQCHA
4832: *
4833: * set the change_pending_flag in the po_requisition_headers_all
4834: * table to 'Y'
4835: *
4836: ************************************************************************/
4837: procedure Update_Req_Change_Flag(itemtype in varchar2,

Line 5002: from po_requisition_headers_all

4998: where po_header_id=l_doc_id;
4999: elsif(l_doc_type='REQUISITION') then
5000: select preparer_id
5001: into l_employee_id
5002: from po_requisition_headers_all
5003: where requisition_header_id=l_doc_id;
5004: else
5005: select agent_id
5006: into l_employee_id

Line 6104: * reset the change_pending_flag in po_requisition_headers_all

6100: *
6101: * Public Procedure: Reset_Change_Flag
6102: * Effects: workflow procedure, used in POREQCHA
6103: *
6104: * reset the change_pending_flag in po_requisition_headers_all
6105: * table to 'N'
6106: *
6107: ************************************************************************/
6108: procedure Reset_Change_Flag(itemtype in varchar2,

Line 7913: from po_requisition_headers_all

7909: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 05';
7910:
7911: select NVL(CONTRACTOR_REQUISITION_FLAG, 'N'), NOTE_TO_AUTHORIZER
7912: into l_contractor_req_flag,l_note
7913: from po_requisition_headers_all
7914: where REQUISITION_HEADER_ID = l_document_id;
7915:
7916: t_varname(1) := 'CONTRACTOR_REQUISITION_FLAG';
7917: t_varval(1) := l_contractor_req_flag ;

Line 8166: from po_change_requests pcr, po_requisition_headers_all por

8162: from po_change_requests
8163: where change_request_group_id=l_change_request_group_id);
8164: cursor change_request(l_change_request_group_id number) is
8165: select nvl(pcr.requester_id, por.preparer_id)
8166: from po_change_requests pcr, po_requisition_headers_all por
8167: where pcr.change_request_group_id=l_change_request_group_id
8168: and pcr.document_header_id=por.requisition_header_id;
8169:
8170: BEGIN

Line 8740: UPDATE po_requisition_headers_all h

8736: where change_request_id=l_change_request_id;
8737:
8738:
8739: --bug 7664476 -- roll up the authorization status if all lines of requisiton is cancelled
8740: UPDATE po_requisition_headers_all h
8741: SET h.AUTHORIZATION_STATUS = 'CANCELLED'
8742: WHERE h.REQUISITION_HEADER_ID = l_document_id
8743: AND NOT EXISTS
8744: (SELECT 'UNCANCELLED LINE EXISTS'

Line 8852: l_req_num po_requisition_headers_all.segment1%type;

8848: p_submitter_action VARCHAR2(20) := 'APPROVE';
8849: p_workflow_process VARCHAR2(30):='MAIN_CHANGE_APPROVAL';
8850: l_change_request_group_id number;
8851: l_preparer_id number;
8852: l_req_num po_requisition_headers_all.segment1%type;
8853: cursor change_request_group_id is
8854: select max(change_request_group_id)
8855: from po_change_requests
8856: where document_header_id = p_req_header_id

Line 8883: from po_requisition_headers_all

8879: FROM sys.dual;
8880:
8881: select preparer_id, segment1
8882: into l_preparer_id, l_req_num
8883: from po_requisition_headers_all
8884: where requisition_header_id= p_req_header_id;
8885:
8886: PO_REQAPPROVAL_INIT1.Start_WF_Process(
8887: ItemType => p_item_type,

Line 11412: l_req_num po_requisition_headers_all.segment1%TYPE;

11408: p_workflow_process VARCHAR2(30) := 'MAIN_CHANGE_APPROVAL';
11409: l_change_request_group_id NUMBER;
11410: l_preparer_id NUMBER;
11411: p_source_type_code VARCHAR2(20) := 'INVENTORY';
11412: l_req_num po_requisition_headers_all.segment1%TYPE;
11413: CURSOR change_request_group_id IS
11414: SELECT MAX(change_request_group_id)
11415: FROM po_change_requests
11416: WHERE document_header_id = p_req_header_id

Line 11467: FROM po_requisition_headers_all

11463:
11464:
11465: SELECT preparer_id, segment1,TYPE_LOOKUP_CODE
11466: INTO l_preparer_id, l_req_num,p_document_subtype
11467: FROM po_requisition_headers_all
11468: WHERE requisition_header_id = p_req_header_id;
11469:
11470:
11471: -- Provide an hold on SO before calling reapproval of change

Line 12102: from po_requisition_headers_all prh,

12098: )) THEN
12099:
12100:
12101: select prh.preparer_id into l_preparer_id
12102: from po_requisition_headers_all prh,
12103: po_requisition_lines_all prl
12104: where prl.requisition_line_id = p_req_line_id
12105: and prl.requisition_header_id = prh.requisition_header_id;
12106:

Line 12404: UPDATE po_requisition_headers_all h

12400: where requisition_line_id = p_req_line_id ;
12401:
12402: x_progress := '013';
12403:
12404: UPDATE po_requisition_headers_all h
12405: SET h.AUTHORIZATION_STATUS = 'CANCELLED'
12406: WHERE h.REQUISITION_HEADER_ID = l_document_id
12407: AND NOT EXISTS
12408: (SELECT 'UNCANCELLED LINE EXISTS'