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 572: l_doc_status po_headers_all.authorization_status%type;

568: l_msg_data varchar2(1000);
569:
570: l_record_count number;
571: l_change_request_group_id number;
572: l_doc_status po_headers_all.authorization_status%type;
573: i number;
574: l_save_failure exception;
575: l_error_message varchar2(240);
576: l_error_message1 varchar2(2000);

Line 586: from po_headers_all

582: -- only if the doc is in 'APPROVED' status
583: if(p_po_release_id is null) then
584: select nvl(authorization_status, 'IN PROCESS')
585: into l_doc_status
586: from po_headers_all
587: where po_header_id=p_po_header_id;
588: else
589: select nvl(authorization_status, 'IN PROCESS')
590: into l_doc_status

Line 1110: l_po_currency_code PO_HEADERS_ALL.currency_code%type;

1106: l_header_cancel_flag varchar2(1);
1107: l_line_cancel_flag varchar2(1);
1108: l_shipment_cancel_flag varchar2(1);
1109:
1110: l_po_currency_code PO_HEADERS_ALL.currency_code%type;
1111: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
1112: l_org_id number;
1113:
1114: cursor l_pending_change_csr(p_change_request_group_id in number) is

Line 1142: po_headers_all poh,

1138: pll.cancel_flag shipment_cancel_flag,
1139: poh.currency_code,
1140: pol.org_id
1141: from po_change_requests pcr,
1142: po_headers_all poh,
1143: po_lines_all pol,
1144: po_line_locations_all pll,
1145: po_distributions_all pod,
1146: po_releases_all por

Line 1289: l_doc_status po_headers_all.authorization_status%type;

1285: ************************************************************************/
1286: PROCEDURE ValidateChgAgainstNewPO(p_change_request_group_id in number) is
1287: --pragma AUTONOMOUS_TRANSACTION;
1288:
1289: l_doc_status po_headers_all.authorization_status%type;
1290:
1291: x_progress varchar2(3):= '000';
1292:
1293: l_doc_check_rec_type Doc_Check_Return_Type;

Line 1393: from po_headers_all

1389: x_progress :='001';
1390: if(ll_document_type ='PO' ) then
1391: select nvl(authorization_status, 'IN PROCESS'), revision_num
1392: into l_doc_status,ll_document_revision_num
1393: from po_headers_all
1394: where po_header_id=ll_document_header_id;
1395: x_progress :='002';
1396: else
1397: select nvl(authorization_status, 'IN PROCESS'), revision_num

Line 1898: update po_headers_all

1894: fetch l_document_id_csr into l_document_type, l_document_id, l_release_id, l_requester_id;
1895: close l_document_id_csr;
1896:
1897: if(l_document_type IN ('PO','PA')) then
1898: update po_headers_all
1899: set AUTHORIZATION_STATUS = 'APPROVED'
1900: where po_header_id = l_document_id;
1901: elsif l_document_type = 'RELEASE' THEN
1902: update po_releases_all

Line 1984: update po_headers_all

1980: -- to 'APPROVED' status first.
1981: if(l_document_type= 'PO') then
1982: l_document_subtype := 'STANDARD';
1983:
1984: update po_headers_all
1985: set AUTHORIZATION_STATUS = 'APPROVED',
1986: approved_flag='Y',
1987: CHANGE_REQUESTED_BY=null,
1988: last_updated_by = fnd_global.user_id,

Line 2107: update po_headers_all set

2103:
2104: -- fix bug 2733373. when change is submitted, and wait
2105: -- for buyer's response, we just set the status to
2106: -- 'IN PROCESS', but not the approved_flag
2107: update po_headers_all set
2108: AUTHORIZATION_STATUS = 'IN PROCESS',
2109: -- approved_flag='N',
2110: CHANGE_REQUESTED_BY='REQUESTER',
2111: last_updated_by = fnd_global.user_id,

Line 3092: po_headers_all poh,

3088: max(pcr.requester_id) requester_id -- Bug # 3862383
3089: from po_change_requests pcr,
3090: po_line_locations_all pll,
3091: po_requisition_lines_all prl,
3092: po_headers_all poh,
3093: po_releases_all por,
3094: po_lines_all pol
3095: where pcr.change_request_group_id=l_change_request_group_id
3096: and pcr.request_status='MGR_APP'

Line 3148: po_headers_all poh,

3144: pcr.requester_id requester_id -- Bug # 3862383
3145: from po_change_requests pcr,
3146: po_line_locations_all pll,
3147: po_requisition_lines_all prl,
3148: po_headers_all poh,
3149: po_releases_all por,
3150: po_lines_all pol
3151: where pcr.change_request_group_id=l_change_request_group_id
3152: and pcr.request_status='MGR_APP'

Line 3211: po_headers_all poh,

3207: pcr.requester_id requester_id -- Bug # 3862383
3208: from po_change_requests pcr,
3209: po_line_locations_all pll,
3210: po_requisition_lines_all prl,
3211: po_headers_all poh,
3212: po_releases_all por,
3213: po_distributions_all pod,
3214: po_req_distributions_all prd,
3215: po_lines_all pol

Line 3849: from PO_HEADERS_ALL

3845: x_progress := '003';
3846:
3847: select revision_num
3848: into l_revision_num
3849: from PO_HEADERS_ALL
3850: where po_header_id = p_doc_id;
3851:
3852: ELSIF p_doc_type = 'RELEASE' THEN
3853:

Line 3976: FROM po_headers_all

3972:
3973: IF(p_doc_type = 'PO' AND p_action = 'SUBMIT CHANGE') THEN
3974: SELECT agent_id
3975: INTO l_buyer_id
3976: FROM po_headers_all
3977: WHERE PO_HEADER_ID = p_doc_id;
3978:
3979:
3980: INSERT into PO_ACTION_HISTORY

Line 4057: update po_headers_all set

4053:
4054: -- fix bug 2733373. when change is submitted, and wait
4055: -- for buyer's response, we just set the status to
4056: -- 'IN PROCESS', but not the approved_flag
4057: update po_headers_all set
4058: AUTHORIZATION_STATUS = 'IN PROCESS',
4059: -- approved_flag='N',
4060: CHANGE_REQUESTED_BY='REQUESTER',
4061: last_updated_by = fnd_global.user_id,

Line 4556: from po_releases_all por, po_headers_all poh

4552: l_document_type_disp := fnd_message.get;
4553:
4554: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num)
4555: into l_org_id, l_agent_id, l_document_num
4556: from po_releases_all por, po_headers_all poh
4557: where por.po_release_id=l_document_id
4558: and por.po_header_id=poh.po_header_id;
4559: else
4560: l_document_subtype:='STANDARD';

Line 4567: from po_headers_all

4563: l_document_type_disp := fnd_message.get;
4564:
4565: select org_id, agent_id, segment1
4566: into l_org_id, l_agent_id, l_document_num
4567: from po_headers_all
4568: where po_header_id=l_document_id;
4569: end if;
4570:
4571: x_progress :='StartPOChangeWF:003';

Line 4890: update po_headers_all

4886: BEGIN
4887: x_progress := 'PO_ReqChangeRequestWF_PVT.UpdatePODocHeaderTables';
4888:
4889: if(p_document_type = 'PO') then
4890: update po_headers_all
4891: set change_requested_by = null,
4892: last_updated_by = fnd_global.user_id,
4893: last_update_login = fnd_global.login_id,
4894: last_update_date = sysdate

Line 5185: from po_headers_all

5181: if(l_employee_id is null) then
5182: if(l_doc_type='PO') then
5183: select agent_id
5184: into l_employee_id
5185: from po_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

Line 6631: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;

6627:
6628: l_doc_id number;
6629: l_doc_type varchar2(25);
6630: l_orgid number;
6631: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
6632:
6633: x_progress varchar2(100);
6634:
6635: l_doc_string varchar2(200);

Line 6671: from po_headers_all

6667: IF l_doc_type IN ('PO','PA') THEN
6668:
6669: select AUTHORIZATION_STATUS
6670: into l_authorization_status
6671: from po_headers_all
6672: where PO_HEADER_ID = l_doc_id;
6673:
6674: ELSIF l_doc_type = 'RELEASE' THEN
6675:

Line 6730: l_authorization_status PO_HEADERS_ALL.authorization_status%type;

6726:
6727: l_doc_id number;
6728: l_doc_type varchar2(25);
6729: l_orgid number;
6730: l_authorization_status PO_HEADERS_ALL.authorization_status%type;
6731:
6732: x_progress varchar2(100);
6733:
6734: l_doc_string varchar2(200);

Line 6810: l_authorization_status PO_HEADERS_ALL.authorization_status%type;

6806: l_doc_type varchar2(25);
6807: l_doc_revision NUMBER;
6808: l_old_doc_revision NUMBER;
6809: l_orgid number;
6810: l_authorization_status PO_HEADERS_ALL.authorization_status%type;
6811:
6812: x_progress varchar2(100);
6813:
6814: l_doc_string varchar2(200);

Line 6853: from po_headers_all

6849:
6850: IF l_doc_type IN ('PO','PA') THEN
6851: select revision_num
6852: into l_doc_revision
6853: from po_headers_all
6854: where po_header_id=l_doc_id;
6855: ELSIF l_doc_type = 'RELEASE' THEN
6856: select revision_num
6857: into l_doc_revision

Line 6905: l_authorization_status PO_HEADERS_ALL.authorization_status%type;

6901: l_doc_revision NUMBER;
6902: l_old_doc_revision NUMBER;
6903: l_orgid number;
6904: l_change_request_group_id number;
6905: l_authorization_status PO_HEADERS_ALL.authorization_status%type;
6906:
6907: x_progress varchar2(100);
6908:
6909: l_doc_string varchar2(200);

Line 6979: l_authorization_status PO_HEADERS_ALL.authorization_status%type;

6975: l_doc_revision NUMBER;
6976: l_old_doc_revision NUMBER;
6977: l_orgid number;
6978: l_change_request_group_id number;
6979: l_authorization_status PO_HEADERS_ALL.authorization_status%type;
6980:
6981: x_progress varchar2(100);
6982:
6983: l_doc_string varchar2(200);

Line 7202: from po_headers_all

7198: IF l_doc_type IN ('PO','PA') THEN
7199:
7200: select agent_id
7201: into l_employee_id
7202: from po_headers_all
7203: where PO_HEADER_ID = l_doc_id;
7204:
7205: ELSIF l_doc_type = 'RELEASE' THEN
7206:

Line 7702: UPDATE po_headers_all

7698: UPDATE po_releases_all
7699: SET authorization_status='APPROVED'
7700: WHERE po_release_id = l_release_id;
7701: ELSE
7702: UPDATE po_headers_all
7703: SET authorization_status='APPROVED'
7704: WHERE po_header_id = l_header_id;
7705: END IF;
7706:

Line 8504: from po_headers_all

8500: l_document_type_disp := fnd_message.get;
8501:
8502: select org_id, agent_id, segment1, REVISION_NUM
8503: into l_org_id, l_buyer_id, l_document_num, l_document_revision
8504: from po_headers_all
8505: where po_header_id=l_document_id;
8506:
8507: ELSIF l_document_type = 'RELEASE' THEN
8508:

Line 8514: from po_releases_all por, po_headers_all poh

8510: l_document_type_disp := fnd_message.get;
8511:
8512: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num), por.REVISION_NUM
8513: into l_org_id, l_buyer_id, l_document_num, l_document_revision
8514: from po_releases_all por, po_headers_all poh
8515: where por.po_release_id=l_document_id
8516: and por.po_header_id=poh.po_header_id;
8517:
8518: END IF;

Line 9765: from po_headers_all poh

9761: AND fsp.set_of_books_id = sob.set_of_books_id;
9762:
9763: select poh.rate
9764: into l_rate
9765: from po_headers_all poh
9766: where poh.po_header_id in (
9767: select document_header_id from po_change_requests
9768: where change_request_group_id = p_change_request_group_id ) ;
9769:

Line 10004: from po_headers_all

10000: IF l_doc_type IN ('PO','PA') THEN
10001:
10002: select creation_date, currency_code
10003: into l_order_date, l_po_currency
10004: from po_headers_all
10005: where PO_HEADER_ID = l_doc_id;
10006:
10007: ELSIF l_doc_type = 'RELEASE' THEN
10008:

Line 10011: from po_releases_all pr, po_headers_all ph

10007: ELSIF l_doc_type = 'RELEASE' THEN
10008:
10009: select pr.creation_date, ph.currency_code
10010: into l_order_date, l_po_currency
10011: from po_releases_all pr, po_headers_all ph
10012: where pr.po_release_id = l_doc_id
10013: and pr.po_header_id = ph.po_header_id;
10014:
10015: END IF;

Line 10331: l_creation_method po_headers_all.document_creation_method%TYPE;

10327: l_value varchar2(1) := '';
10328: l_po_chg_group_id NUMBER;
10329: l_po_org_id NUMBER;
10330: l_progress VARCHAR2(100) := '000';
10331: l_creation_method po_headers_all.document_creation_method%TYPE;
10332: l_document_type po_change_requests.document_type%TYPE;
10333: BEGIN
10334:
10335: l_po_chg_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 10354: po_headers_all poh,

10350:
10351: SELECT poh.document_creation_method, poh.org_id
10352: INTO l_creation_method, l_po_org_id
10353: FROM
10354: po_headers_all poh,
10355: po_change_requests pcr
10356: WHERE poh.po_header_id =pcr.document_header_id
10357: AND pcr.change_request_group_id = l_po_chg_group_id
10358: AND rownum=1;

Line 10565: FROM po_headers_all

10561: IF l_document_type = 'PO' THEN
10562:
10563: SELECT agent_id, creation_date
10564: INTO l_buyer_id, l_order_date
10565: FROM po_headers_all
10566: WHERE PO_HEADER_ID = l_document_id;
10567:
10568: ELSIF l_document_type = 'RELEASE' THEN
10569:

Line 10711: FROM po_headers_all

10707: IF l_po_doc_type IN ('PO','PA') THEN
10708:
10709: SELECT currency_code
10710: INTO l_po_currency
10711: FROM po_headers_all
10712: WHERE PO_HEADER_ID = l_po_doc_id;
10713:
10714: ELSIF l_po_doc_type = 'RELEASE' THEN
10715:

Line 10718: FROM po_releases_all pr, po_headers_all ph

10714: ELSIF l_po_doc_type = 'RELEASE' THEN
10715:
10716: SELECT ph.currency_code
10717: INTO l_po_currency
10718: FROM po_releases_all pr, po_headers_all ph
10719: WHERE pr.po_release_id = l_po_doc_id
10720: and pr.po_header_id = ph.po_header_id;
10721:
10722: END IF;

Line 11169: l_po_currency_code PO_HEADERS_ALL.currency_code%type;

11165: l_tolerances_tab po_co_tolerances_grp.tolerances_tbl_type;
11166: l_api_name varchar2(30) := 'Changes_Wthn_Buyer_Tol_Values';
11167: l_progress VARCHAR2(100) := '000';
11168:
11169: l_po_currency_code PO_HEADERS_ALL.currency_code%type;
11170: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
11171: l_org_id number;
11172: l_po_doc_type VARCHAR2(25);
11173:

Line 11208: from po_headers_all poh, po_releases_all pr

11204: -- For releases, the current doc header id is the release id
11205: if (l_po_doc_type = 'RELEASE') then
11206: select poh.currency_code, poh.org_id
11207: into l_po_currency_code, l_org_id
11208: from po_headers_all poh, po_releases_all pr
11209: where pr.po_release_id = l_poheader_id
11210: and poh.po_header_id = pr.po_header_id;
11211: else
11212: select poh.currency_code, poh.org_id

Line 11214: from po_headers_all poh

11210: and poh.po_header_id = pr.po_header_id;
11211: else
11212: select poh.currency_code, poh.org_id
11213: into l_po_currency_code, l_org_id
11214: from po_headers_all poh
11215: where poh.po_header_id = l_poheader_id;
11216: end if;
11217:
11218: l_progress := '002';