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 322: po_requisition_headers_all prh,

318: /*
319: SELECT ooh.ORG_ID
320: INTO l_org_id
321: from po_requisition_lines_all prl,
322: po_requisition_headers_all prh,
323: oe_order_headers_all ooh,
324: po_system_parameters_all psp
325: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
326: AND prl.requisition_line_id = nvl(p_req_line_id,prl.requisition_line_id)

Line 352: po_requisition_headers_all prh

348:
349: SELECT prh.org_id
350: INTO l_org_id
351: from po_requisition_lines_all prl,
352: po_requisition_headers_all prh
353: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
354: AND prh.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
355: AND prl.requisition_line_id = nvl(p_req_line_id,prl.requisition_line_id)
356: AND nvl(p_req_hdr_id,p_req_line_id) IS NOT NULL

Line 902: update po_requisition_headers_all

898: where change_request_id=l_req_change_request_id;
899:
900: if(l_action_type='CANCELLATION') then
901: if(l_request_level='HEADER') then
902: update po_requisition_headers_all
903: set cancel_flag='Y'
904: where requisition_header_id=l_header_id;
905: else
906: -- it is line level

Line 3743: update po_requisition_headers_all

3739: x_progress varchar2(3):= '000';
3740:
3741: BEGIN
3742:
3743: update po_requisition_headers_all
3744: set last_updated_by = nvl(fnd_global.user_id, last_updated_by),
3745: last_update_login = nvl(fnd_global.login_id, last_update_login),
3746: last_update_date = sysdate,
3747: change_pending_flag=p_change_flag

Line 3761: UPDATE po_requisition_headers_all h

3757: end if;
3758:
3759: x_progress:='002';
3760:
3761: UPDATE po_requisition_headers_all h
3762: SET h.AUTHORIZATION_STATUS = 'CANCELLED'
3763: WHERE h.REQUISITION_HEADER_ID = p_document_id
3764: AND NOT EXISTS
3765: (SELECT 'UNCANCELLED LINE EXISTS'

Line 4259: from po_change_requests pcr, po_requisition_headers_all por

4255: l_total_amount_dsp varchar2(100);
4256: cursor change_request(l_change_request_group_id number) is
4257: select document_header_id, nvl(pcr.requester_id, por.preparer_id),
4258: document_num
4259: from po_change_requests pcr, po_requisition_headers_all por
4260: where pcr.change_request_group_id=l_change_request_group_id
4261: and pcr.document_header_id=por.requisition_header_id;
4262:
4263: l_old_req_amount varchar2(40);

Line 4290: from po_requisition_headers_all

4286: x_progress :='StartConvertProcess:002';
4287:
4288: select org_id
4289: into l_org_id
4290: from po_requisition_headers_all
4291: where requisition_header_id=l_document_id;
4292:
4293: x_progress :='StartConvertProcess:003';
4294:

Line 4472: from po_requisition_headers_all por,

4468: --SQL Why: wf attribute needs it
4469: --SQL Join: parent_change_request_id, requisition_header_id
4470: cursor req_preparer_id(l_change_request_group_id number) is
4471: select por.preparer_id
4472: from po_requisition_headers_all por,
4473: po_change_requests pcr1,
4474: po_change_requests pcr2
4475: where pcr2.change_request_group_id=l_change_request_group_id
4476: and pcr2.parent_change_request_id=pcr1.change_request_id

Line 4489: from po_requisition_headers_all prh, po_change_requests pcr

4485: where change_request_group_id=l_change_request_group_id);
4486:
4487: cursor get_parent_info_csr(l_change_request_group_id number) is
4488: select prh.segment1, pcr.wf_item_type, pcr.wf_item_key, prh.requisition_header_id
4489: from po_requisition_headers_all prh, po_change_requests pcr
4490: where prh.requisition_header_id=pcr.document_header_id
4491: and pcr.change_request_group_id=l_change_request_group_id;
4492:
4493: n_varname Wf_Engine.NameTabTyp;

Line 5021: * set the change_pending_flag in the po_requisition_headers_all

5017: *
5018: * Public Procedure: Update_Req_Change_Flag
5019: * Effects: workflow procedure, called at the beginning of POREQCHA
5020: *
5021: * set the change_pending_flag in the po_requisition_headers_all
5022: * table to 'Y'
5023: *
5024: ************************************************************************/
5025: procedure Update_Req_Change_Flag(itemtype in varchar2,

Line 5190: from po_requisition_headers_all

5186: where po_header_id=l_doc_id;
5187: elsif(l_doc_type='REQUISITION') then
5188: select preparer_id
5189: into l_employee_id
5190: from po_requisition_headers_all
5191: where requisition_header_id=l_doc_id;
5192: else
5193: select agent_id
5194: into l_employee_id

Line 6292: * reset the change_pending_flag in po_requisition_headers_all

6288: *
6289: * Public Procedure: Reset_Change_Flag
6290: * Effects: workflow procedure, used in POREQCHA
6291: *
6292: * reset the change_pending_flag in po_requisition_headers_all
6293: * table to 'N'
6294: *
6295: ************************************************************************/
6296: procedure Reset_Change_Flag(itemtype in varchar2,

Line 8199: from po_requisition_headers_all

8195: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 05';
8196:
8197: select NVL(CONTRACTOR_REQUISITION_FLAG, 'N'), NOTE_TO_AUTHORIZER
8198: into l_contractor_req_flag,l_note
8199: from po_requisition_headers_all
8200: where REQUISITION_HEADER_ID = l_document_id;
8201:
8202: t_varname(1) := 'CONTRACTOR_REQUISITION_FLAG';
8203: t_varval(1) := l_contractor_req_flag ;

Line 8485: from po_change_requests pcr, po_requisition_headers_all por

8481: from po_change_requests
8482: where change_request_group_id=l_change_request_group_id);
8483: cursor change_request(l_change_request_group_id number) is
8484: select nvl(pcr.requester_id, por.preparer_id)
8485: from po_change_requests pcr, po_requisition_headers_all por
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

Line 9127: UPDATE po_requisition_headers_all h

9123: where change_request_id=l_change_request_id;
9124:
9125:
9126: --bug 7664476 -- roll up the authorization status if all lines of requisiton is cancelled
9127: UPDATE po_requisition_headers_all h
9128: SET h.AUTHORIZATION_STATUS = 'CANCELLED'
9129: WHERE h.REQUISITION_HEADER_ID = l_document_id
9130: AND NOT EXISTS
9131: (SELECT 'UNCANCELLED LINE EXISTS'

Line 9239: l_req_num po_requisition_headers_all.segment1%type;

9235: p_submitter_action VARCHAR2(20) := 'APPROVE';
9236: p_workflow_process VARCHAR2(30):='MAIN_CHANGE_APPROVAL';
9237: l_change_request_group_id number;
9238: l_preparer_id number;
9239: l_req_num po_requisition_headers_all.segment1%type;
9240: cursor change_request_group_id is
9241: select max(change_request_group_id)
9242: from po_change_requests
9243: where document_header_id = p_req_header_id

Line 9270: from po_requisition_headers_all

9266: FROM sys.dual;
9267:
9268: select preparer_id, segment1
9269: into l_preparer_id, l_req_num
9270: from po_requisition_headers_all
9271: where requisition_header_id= p_req_header_id;
9272:
9273: PO_REQAPPROVAL_INIT1.Start_WF_Process(
9274: ItemType => p_item_type,

Line 11816: l_req_num po_requisition_headers_all.segment1%TYPE;

11812: p_workflow_process VARCHAR2(30) := 'MAIN_CHANGE_APPROVAL';
11813: l_change_request_group_id NUMBER;
11814: l_preparer_id NUMBER;
11815: p_source_type_code VARCHAR2(20) := 'INVENTORY';
11816: l_req_num po_requisition_headers_all.segment1%TYPE;
11817: CURSOR change_request_group_id IS
11818: SELECT MAX(change_request_group_id)
11819: FROM po_change_requests
11820: WHERE document_header_id = p_req_header_id

Line 11871: FROM po_requisition_headers_all

11867:
11868:
11869: SELECT preparer_id, segment1,TYPE_LOOKUP_CODE
11870: INTO l_preparer_id, l_req_num,p_document_subtype
11871: FROM po_requisition_headers_all
11872: WHERE requisition_header_id = p_req_header_id;
11873:
11874:
11875:

Line 12541: from po_requisition_headers_all prh,

12537: )) THEN
12538:
12539:
12540: select prh.preparer_id into l_preparer_id
12541: from po_requisition_headers_all prh,
12542: po_requisition_lines_all prl
12543: where prl.requisition_line_id = p_req_line_id
12544: and prl.requisition_header_id = prh.requisition_header_id;
12545:

Line 13018: UPDATE po_requisition_headers_all h

13014: where requisition_line_id = p_req_line_id ;
13015:
13016: x_progress := '013';
13017: -- bug 14407998 changes added LAST_UPDATED_BY, LAST_UPDATE_DATE colums in update stmt
13018: UPDATE po_requisition_headers_all h
13019: SET h.AUTHORIZATION_STATUS = 'CANCELLED',
13020: h.LAST_UPDATED_BY = fnd_global.user_id,
13021: h.LAST_UPDATE_DATE = SYSDATE
13022: WHERE h.REQUISITION_HEADER_ID = l_document_id

Line 13410: from po_requisition_headers_all prh,

13406: )) THEN
13407:
13408:
13409: select prh.preparer_id into l_preparer_id
13410: from po_requisition_headers_all prh,
13411: po_requisition_lines_all prl
13412: where prl.requisition_line_id = p_req_line_id
13413: and prl.requisition_header_id = prh.requisition_header_id;
13414: