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_HEADERS_ALL

Line 555: l_doc_status po_headers_all.authorization_status%type;

551: l_msg_data varchar2(1000);
552:
553: l_record_count number;
554: l_change_request_group_id number;
555: l_doc_status po_headers_all.authorization_status%type;
556: i number;
557: l_save_failure exception;
558: l_error_message varchar2(240);
559: l_error_message1 varchar2(2000);

Line 569: from po_headers_all

565: -- only if the doc is in 'APPROVED' status
566: if(p_po_release_id is null) then
567: select nvl(authorization_status, 'IN PROCESS')
568: into l_doc_status
569: from po_headers_all
570: where po_header_id=p_po_header_id;
571: else
572: select nvl(authorization_status, 'IN PROCESS')
573: into l_doc_status

Line 1093: l_po_currency_code PO_HEADERS_ALL.currency_code%type;

1089: l_header_cancel_flag varchar2(1);
1090: l_line_cancel_flag varchar2(1);
1091: l_shipment_cancel_flag varchar2(1);
1092:
1093: l_po_currency_code PO_HEADERS_ALL.currency_code%type;
1094: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
1095: l_org_id number;
1096:
1097: cursor l_pending_change_csr(p_change_request_group_id in number) is

Line 1125: po_headers_all poh,

1121: pll.cancel_flag shipment_cancel_flag,
1122: poh.currency_code,
1123: pol.org_id
1124: from po_change_requests pcr,
1125: po_headers_all poh,
1126: po_lines_all pol,
1127: po_line_locations_all pll,
1128: po_distributions_all pod,
1129: po_releases_all por

Line 1272: l_doc_status po_headers_all.authorization_status%type;

1268: ************************************************************************/
1269: PROCEDURE ValidateChgAgainstNewPO(p_change_request_group_id in number) is
1270: --pragma AUTONOMOUS_TRANSACTION;
1271:
1272: l_doc_status po_headers_all.authorization_status%type;
1273:
1274: x_progress varchar2(3):= '000';
1275:
1276: l_doc_check_rec_type Doc_Check_Return_Type;

Line 1376: from po_headers_all

1372: x_progress :='001';
1373: if(ll_document_type ='PO' ) then
1374: select nvl(authorization_status, 'IN PROCESS'), revision_num
1375: into l_doc_status,ll_document_revision_num
1376: from po_headers_all
1377: where po_header_id=ll_document_header_id;
1378: x_progress :='002';
1379: else
1380: select nvl(authorization_status, 'IN PROCESS'), revision_num

Line 1876: update po_headers_all

1872: -- to 'APPROVED' status first.
1873: if(l_document_type= 'PO') then
1874: l_document_subtype := 'STANDARD';
1875:
1876: update po_headers_all
1877: set AUTHORIZATION_STATUS = 'APPROVED',
1878: approved_flag='Y',
1879: CHANGE_REQUESTED_BY=null,
1880: last_updated_by = fnd_global.user_id,

Line 2016: update po_headers_all set

2012:
2013: -- fix bug 2733373. when change is submitted, and wait
2014: -- for buyer's response, we just set the status to
2015: -- 'IN PROCESS', but not the approved_flag
2016: update po_headers_all set
2017: AUTHORIZATION_STATUS = 'IN PROCESS',
2018: -- approved_flag='N',
2019: CHANGE_REQUESTED_BY='REQUESTER',
2020: last_updated_by = fnd_global.user_id,

Line 2970: po_headers_all poh,

2966: max(pcr.requester_id) requester_id -- Bug # 3862383
2967: from po_change_requests pcr,
2968: po_line_locations_all pll,
2969: po_requisition_lines_all prl,
2970: po_headers_all poh,
2971: po_releases_all por,
2972: po_lines_all pol
2973: where pcr.change_request_group_id=l_change_request_group_id
2974: and pcr.request_status='MGR_APP'

Line 3025: po_headers_all poh,

3021: pcr.requester_id requester_id -- Bug # 3862383
3022: from po_change_requests pcr,
3023: po_line_locations_all pll,
3024: po_requisition_lines_all prl,
3025: po_headers_all poh,
3026: po_releases_all por,
3027: po_lines_all pol
3028: where pcr.change_request_group_id=l_change_request_group_id
3029: and pcr.request_status='MGR_APP'

Line 3080: po_headers_all poh,

3076: pcr.requester_id requester_id -- Bug # 3862383
3077: from po_change_requests pcr,
3078: po_line_locations_all pll,
3079: po_requisition_lines_all prl,
3080: po_headers_all poh,
3081: po_releases_all por,
3082: po_distributions_all pod,
3083: po_req_distributions_all prd,
3084: po_lines_all pol

Line 3705: from PO_HEADERS_ALL

3701: x_progress := '003';
3702:
3703: select revision_num
3704: into l_revision_num
3705: from PO_HEADERS_ALL
3706: where po_header_id = p_doc_id;
3707:
3708: ELSIF p_doc_type = 'RELEASE' THEN
3709:

Line 3904: update po_headers_all set

3900:
3901: -- fix bug 2733373. when change is submitted, and wait
3902: -- for buyer's response, we just set the status to
3903: -- 'IN PROCESS', but not the approved_flag
3904: update po_headers_all set
3905: AUTHORIZATION_STATUS = 'IN PROCESS',
3906: -- approved_flag='N',
3907: CHANGE_REQUESTED_BY='REQUESTER',
3908: last_updated_by = fnd_global.user_id,

Line 4396: from po_releases_all por, po_headers_all poh

4392: l_document_type_disp := fnd_message.get;
4393:
4394: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num)
4395: into l_org_id, l_agent_id, l_document_num
4396: from po_releases_all por, po_headers_all poh
4397: where por.po_release_id=l_document_id
4398: and por.po_header_id=poh.po_header_id;
4399: else
4400: l_document_subtype:='STANDARD';

Line 4407: from po_headers_all

4403: l_document_type_disp := fnd_message.get;
4404:
4405: select org_id, agent_id, segment1
4406: into l_org_id, l_agent_id, l_document_num
4407: from po_headers_all
4408: where po_header_id=l_document_id;
4409: end if;
4410:
4411: x_progress :='StartPOChangeWF:003';

Line 4702: update po_headers_all

4698: BEGIN
4699: x_progress := 'PO_ReqChangeRequestWF_PVT.UpdatePODocHeaderTables';
4700:
4701: if(p_document_type = 'PO') then
4702: update po_headers_all
4703: set change_requested_by = null,
4704: last_updated_by = fnd_global.user_id,
4705: last_update_login = fnd_global.login_id,
4706: last_update_date = sysdate

Line 4997: from po_headers_all

4993: if(l_employee_id is null) then
4994: if(l_doc_type='PO') then
4995: select agent_id
4996: into l_employee_id
4997: from po_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

Line 6398: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;

6394:
6395: l_doc_id number;
6396: l_doc_type varchar2(25);
6397: l_orgid number;
6398: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
6399:
6400: x_progress varchar2(100);
6401:
6402: l_doc_string varchar2(200);

Line 6438: from po_headers_all

6434: IF l_doc_type IN ('PO','PA') THEN
6435:
6436: select AUTHORIZATION_STATUS
6437: into l_authorization_status
6438: from po_headers_all
6439: where PO_HEADER_ID = l_doc_id;
6440:
6441: ELSIF l_doc_type = 'RELEASE' THEN
6442:

Line 6497: l_authorization_status PO_HEADERS_ALL.authorization_status%type;

6493:
6494: l_doc_id number;
6495: l_doc_type varchar2(25);
6496: l_orgid number;
6497: l_authorization_status PO_HEADERS_ALL.authorization_status%type;
6498:
6499: x_progress varchar2(100);
6500:
6501: l_doc_string varchar2(200);

Line 6577: l_authorization_status PO_HEADERS_ALL.authorization_status%type;

6573: l_doc_type varchar2(25);
6574: l_doc_revision NUMBER;
6575: l_old_doc_revision NUMBER;
6576: l_orgid number;
6577: l_authorization_status PO_HEADERS_ALL.authorization_status%type;
6578:
6579: x_progress varchar2(100);
6580:
6581: l_doc_string varchar2(200);

Line 6620: from po_headers_all

6616:
6617: IF l_doc_type IN ('PO','PA') THEN
6618: select revision_num
6619: into l_doc_revision
6620: from po_headers_all
6621: where po_header_id=l_doc_id;
6622: ELSIF l_doc_type = 'RELEASE' THEN
6623: select revision_num
6624: into l_doc_revision

Line 6672: l_authorization_status PO_HEADERS_ALL.authorization_status%type;

6668: l_doc_revision NUMBER;
6669: l_old_doc_revision NUMBER;
6670: l_orgid number;
6671: l_change_request_group_id number;
6672: l_authorization_status PO_HEADERS_ALL.authorization_status%type;
6673:
6674: x_progress varchar2(100);
6675:
6676: l_doc_string varchar2(200);

Line 6746: l_authorization_status PO_HEADERS_ALL.authorization_status%type;

6742: l_doc_revision NUMBER;
6743: l_old_doc_revision NUMBER;
6744: l_orgid number;
6745: l_change_request_group_id number;
6746: l_authorization_status PO_HEADERS_ALL.authorization_status%type;
6747:
6748: x_progress varchar2(100);
6749:
6750: l_doc_string varchar2(200);

Line 6969: from po_headers_all

6965: IF l_doc_type IN ('PO','PA') THEN
6966:
6967: select agent_id
6968: into l_employee_id
6969: from po_headers_all
6970: where PO_HEADER_ID = l_doc_id;
6971:
6972: ELSIF l_doc_type = 'RELEASE' THEN
6973:

Line 7465: UPDATE po_headers_all

7461: UPDATE po_releases_all
7462: SET authorization_status='APPROVED'
7463: WHERE po_release_id = l_release_id;
7464: ELSE
7465: UPDATE po_headers_all
7466: SET authorization_status='APPROVED'
7467: WHERE po_header_id = l_header_id;
7468: END IF;
7469:

Line 9378: from po_headers_all poh

9374: AND fsp.set_of_books_id = sob.set_of_books_id;
9375:
9376: select poh.rate
9377: into l_rate
9378: from po_headers_all poh
9379: where poh.po_header_id in (
9380: select document_header_id from po_change_requests
9381: where change_request_group_id = p_change_request_group_id ) ;
9382:

Line 9617: from po_headers_all

9613: IF l_doc_type IN ('PO','PA') THEN
9614:
9615: select creation_date, currency_code
9616: into l_order_date, l_po_currency
9617: from po_headers_all
9618: where PO_HEADER_ID = l_doc_id;
9619:
9620: ELSIF l_doc_type = 'RELEASE' THEN
9621:

Line 9624: from po_releases_all pr, po_headers_all ph

9620: ELSIF l_doc_type = 'RELEASE' THEN
9621:
9622: select pr.creation_date, ph.currency_code
9623: into l_order_date, l_po_currency
9624: from po_releases_all pr, po_headers_all ph
9625: where pr.po_release_id = l_doc_id
9626: and pr.po_header_id = ph.po_header_id;
9627:
9628: END IF;

Line 9944: l_creation_method po_headers_all.document_creation_method%TYPE;

9940: l_value varchar2(1) := '';
9941: l_po_chg_group_id NUMBER;
9942: l_po_org_id NUMBER;
9943: l_progress VARCHAR2(100) := '000';
9944: l_creation_method po_headers_all.document_creation_method%TYPE;
9945: l_document_type po_change_requests.document_type%TYPE;
9946: BEGIN
9947:
9948: l_po_chg_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 9967: po_headers_all poh,

9963:
9964: SELECT poh.document_creation_method, poh.org_id
9965: INTO l_creation_method, l_po_org_id
9966: FROM
9967: po_headers_all poh,
9968: po_change_requests pcr
9969: WHERE poh.po_header_id =pcr.document_header_id
9970: AND pcr.change_request_group_id = l_po_chg_group_id
9971: AND rownum=1;

Line 10178: FROM po_headers_all

10174: IF l_document_type = 'PO' THEN
10175:
10176: SELECT agent_id, creation_date
10177: INTO l_buyer_id, l_order_date
10178: FROM po_headers_all
10179: WHERE PO_HEADER_ID = l_document_id;
10180:
10181: ELSIF l_document_type = 'RELEASE' THEN
10182:

Line 10321: FROM po_headers_all

10317: IF l_po_doc_type IN ('PO','PA') THEN
10318:
10319: SELECT currency_code
10320: INTO l_po_currency
10321: FROM po_headers_all
10322: WHERE PO_HEADER_ID = l_po_doc_id;
10323:
10324: ELSIF l_po_doc_type = 'RELEASE' THEN
10325:

Line 10328: FROM po_releases_all pr, po_headers_all ph

10324: ELSIF l_po_doc_type = 'RELEASE' THEN
10325:
10326: SELECT ph.currency_code
10327: INTO l_po_currency
10328: FROM po_releases_all pr, po_headers_all ph
10329: WHERE pr.po_release_id = l_po_doc_id
10330: and pr.po_header_id = ph.po_header_id;
10331:
10332: END IF;

Line 10779: l_po_currency_code PO_HEADERS_ALL.currency_code%type;

10775: l_tolerances_tab po_co_tolerances_grp.tolerances_tbl_type;
10776: l_api_name varchar2(30) := 'Changes_Wthn_Buyer_Tol_Values';
10777: l_progress VARCHAR2(100) := '000';
10778:
10779: l_po_currency_code PO_HEADERS_ALL.currency_code%type;
10780: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
10781: l_org_id number;
10782: l_po_doc_type VARCHAR2(25);
10783:

Line 10818: from po_headers_all poh, po_releases_all pr

10814: -- For releases, the current doc header id is the release id
10815: if (l_po_doc_type = 'RELEASE') then
10816: select poh.currency_code, poh.org_id
10817: into l_po_currency_code, l_org_id
10818: from po_headers_all poh, po_releases_all pr
10819: where pr.po_release_id = l_poheader_id
10820: and poh.po_header_id = pr.po_header_id;
10821: else
10822: select poh.currency_code, poh.org_id

Line 10824: from po_headers_all poh

10820: and poh.po_header_id = pr.po_header_id;
10821: else
10822: select poh.currency_code, poh.org_id
10823: into l_po_currency_code, l_org_id
10824: from po_headers_all poh
10825: where poh.po_header_id = l_poheader_id;
10826: end if;
10827:
10828: l_progress := '002';