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_CHG_REQUEST_PVT dependencies on PO_HEADERS_ALL

Line 27: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;

23: p_po_release_id in number,
24: x_activity_name out nocopy varchar2) RETURN NUMBER IS
25:
26: v_nid NUMBER;
27: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
28: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
29: l_message_name varchar2(100);
30:
31:

Line 28: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;

24: x_activity_name out nocopy varchar2) RETURN NUMBER IS
25:
26: v_nid NUMBER;
27: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
28: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
29: l_message_name varchar2(100);
30:
31:
32: BEGIN

Line 37: from wf_notifications a, po_headers_all poh,

33: if p_po_release_id is null then
34: begin
35: select a.notification_id,poh.wf_item_type,poh.wf_item_key, a.message_name
36: INTO v_nid,l_po_item_type,l_po_item_key, l_message_name
37: from wf_notifications a, po_headers_all poh,
38: wf_item_activity_statuses wa
39: where poh.po_header_id = p_po_header_id and
40: poh.wf_item_key = wa.item_key and
41: poh.wf_item_type = wa.item_type

Line 197: ifAckReqd PO_HEADERS_ALL.acceptance_required_flag%TYPE;

193: p_ack_reqd IN varchar2
194: ) RETURN VARCHAR2 IS
195:
196: startWf varchar2(10);
197: ifAckReqd PO_HEADERS_ALL.acceptance_required_flag%TYPE;
198: l_nid NUMBER;
199: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
200: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
201: l_api_name CONSTANT VARCHAR2(30) := 'startSupplierWF';

Line 199: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;

195:
196: startWf varchar2(10);
197: ifAckReqd PO_HEADERS_ALL.acceptance_required_flag%TYPE;
198: l_nid NUMBER;
199: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
200: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
201: l_api_name CONSTANT VARCHAR2(30) := 'startSupplierWF';
202: x_return_status VARCHAR2(10);
203: l_activity_name VARCHAR2(100);

Line 200: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;

196: startWf varchar2(10);
197: ifAckReqd PO_HEADERS_ALL.acceptance_required_flag%TYPE;
198: l_nid NUMBER;
199: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
200: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
201: l_api_name CONSTANT VARCHAR2(30) := 'startSupplierWF';
202: x_return_status VARCHAR2(10);
203: l_activity_name VARCHAR2(100);
204: l_document_type varchar2(10);

Line 226: from po_headers_all

222:
223: if p_po_release_id is null then
224: select wf_item_key,wf_item_type
225: into l_po_item_key,l_po_item_type
226: from po_headers_all
227: where po_header_id = p_po_header_id;
228: else
229: select wf_item_key,wf_item_type
230: into l_po_item_key,l_po_item_type

Line 655: v_auth_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;

651: p_mpoc IN varchar2 default FND_API.G_FALSE) IS
652:
653: x_error_code varchar2(40);
654: no_rec_found exception;
655: v_auth_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
656: x_progress varchar2(3) := '000';
657: l_api_version_number CONSTANT NUMBER := 1.0;
658: l_api_name CONSTANT VARCHAR2(30) := 'process_supplier_request';
659: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 676: x_accp_flag po_headers_all.acceptance_required_flag%type;

672: ack_cnt number :=0;
673: callDocCheck boolean :=false;
674: accp_flag char(1);
675: v_buyer_id number;
676: x_accp_flag po_headers_all.acceptance_required_flag%type;
677: l_err_msg_name_tbl po_tbl_varchar30;
678: l_err_msg_text_tbl po_tbl_varchar2000;
679: l_last_upd_date po_headers_all.last_update_date%type;
680: l_count_asn NUMBER;

Line 679: l_last_upd_date po_headers_all.last_update_date%type;

675: v_buyer_id number;
676: x_accp_flag po_headers_all.acceptance_required_flag%type;
677: l_err_msg_name_tbl po_tbl_varchar30;
678: l_err_msg_text_tbl po_tbl_varchar2000;
679: l_last_upd_date po_headers_all.last_update_date%type;
680: l_count_asn NUMBER;
681: l_ret_sts varchar2(1);
682:
683:

Line 686: FROM PO_HEADERS_ALL

682:
683:
684: CURSOR PO_CSR(p_po_header_id in number) IS
685: SELECT last_update_date
686: FROM PO_HEADERS_ALL
687: WHERE PO_HEADER_ID = p_po_header_id
688: FOR UPDATE of last_update_date NOWAIT;
689:
690: poRec PO_CSR%ROWTYPE;

Line 869: from po_headers_all

865:
866: if p_po_release_id is null then
867: select agent_id,nvl(acceptance_required_flag,'N')
868: into v_buyer_id,x_accp_flag
869: from po_headers_all
870: where po_header_id = p_po_header_id;
871: else
872: select agent_id,nvl(acceptance_required_flag,'N')
873: into v_buyer_id,x_accp_flag

Line 985: update po_headers_all

981: if (nvl(l_po_change_requests(i).New_Supplier_Order_Number,-1) <> nvl(l_po_change_requests(i).Old_Supplier_Order_Number,-1)) then
982:
983: if (p_po_release_id is null ) then
984: -- Update the vendor_order_num for PO Headers no need of approval.
985: update po_headers_all
986: set vendor_order_num = l_po_change_requests(i).New_Supplier_Order_Number
987: where po_header_id = p_po_header_id;
988: else
989: -- Update the vendor_order_num for PO Releases no need of approval.

Line 1153: update po_headers_all set

1149: program_id = fnd_global.conc_program_id,
1150: program_update_date = sysdate
1151: where po_release_id = p_po_release_id;
1152: else
1153: update po_headers_all set
1154: last_update_date = sysdate,
1155: last_updated_by = l_user_id,
1156: last_update_login = l_login_id,
1157: request_id = fnd_global.conc_request_id,

Line 1183: * Effects: Updates The PO_HEADERS_ALL, PO_RELEASES_ALL

1179: /**
1180: * Private Procedure: update_po_attributes
1181: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,REQUEST_GROUP_ID
1182: * Modifies:
1183: * Effects: Updates The PO_HEADERS_ALL, PO_RELEASES_ALL
1184: * Returns:
1185: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1186: * FND_API.G_RET_STS_ERROR if an error occurs
1187: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

Line 1216: update po_headers_all set

1212: l_login_id := p_login_id;
1213: end if;
1214:
1215: if p_po_release_id is null then
1216: update po_headers_all set
1217: authorization_status = 'IN PROCESS',
1218: CHANGE_REQUESTED_BY = 'SUPPLIER',
1219: last_update_date = sysdate,
1220: last_updated_by = l_user_id,

Line 1372: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

1368: ship_cnt number :=0;
1369: dist_cnt number :=0;
1370: ack_cnt number :=0;
1371: p_document_id NUMBER;
1372: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1373: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1374: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1375: sub_check_failed exception;
1376:

Line 1373: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

1369: dist_cnt number :=0;
1370: ack_cnt number :=0;
1371: p_document_id NUMBER;
1372: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1373: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1374: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1375: sub_check_failed exception;
1376:
1377: poLineIdTbl po_tbl_number := po_tbl_number();

Line 1374: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

1370: ack_cnt number :=0;
1371: p_document_id NUMBER;
1372: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1373: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1374: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1375: sub_check_failed exception;
1376:
1377: poLineIdTbl po_tbl_number := po_tbl_number();
1378: unitPriceTbl po_tbl_number := po_tbl_number();

Line 1449: from po_headers_all poh

1445: where pol.po_header_id = p_po_header_id and
1446: pol.latest_external_flag='Y' and
1447: pol.from_header_id in (
1448: select po_header_id
1449: from po_headers_all poh
1450: where poh.global_agreement_flag='Y'
1451: and poh.po_header_id=pol.from_header_id) ;
1452:
1453: cursor ga_ship_csr(p_line_id in number) is

Line 1491: from po_headers_all

1487: else
1488: p_document_id := p_po_header_id;
1489: select type_lookup_code , org_id
1490: into v_type_code , x_org_id
1491: from po_headers_all
1492: where po_header_id= p_po_header_id;
1493: if (v_type_code in ('STANDARD','PLANNED')) then
1494: v_document_type := 'PO';
1495: v_document_subtype := v_type_code;

Line 1888: x_po_header_id po_headers_all.po_header_id%type;

1884: x_order_type po_line_types.order_type_lookup_code%type;
1885: l_return_status varchar2(3);
1886: l_retro_active_price_change varchar2(3);
1887: l_doc_type varchar2(25);
1888: x_po_header_id po_headers_all.po_header_id%type;
1889: l_is_complex_po varchar2(1):='N';
1890: l_is_actual_po varchar2(1):='Y';
1891:
1892: BEGIN

Line 1913: from po_headers_all poh, po_lines_all pol

1909:
1910: --See if the PO is of type BLANKET; if so, the price can be updatable at any time.
1911: select poh.type_lookup_code
1912: into l_doc_type
1913: from po_headers_all poh, po_lines_all pol
1914: where poh.po_header_id = pol.po_header_id
1915: and po_line_id = p_po_line_id;
1916:
1917: if (l_doc_type = 'STANDARD') then

Line 1983: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

1979: p_po_header_id IN NUMBER,
1980: p_po_release_id IN NUMBER) IS
1981:
1982: p_document_id NUMBER;
1983: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1984: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1985: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1986: l_api_name CONSTANT VARCHAR2(30) := 'validateCancelRequest';
1987: l_api_version CONSTANT NUMBER := 1.0;

Line 1984: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

1980: p_po_release_id IN NUMBER) IS
1981:
1982: p_document_id NUMBER;
1983: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1984: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1985: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1986: l_api_name CONSTANT VARCHAR2(30) := 'validateCancelRequest';
1987: l_api_version CONSTANT NUMBER := 1.0;
1988: x_org_id number;

Line 1985: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

1981:
1982: p_document_id NUMBER;
1983: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1984: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1985: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1986: l_api_name CONSTANT VARCHAR2(30) := 'validateCancelRequest';
1987: l_api_version CONSTANT NUMBER := 1.0;
1988: x_org_id number;
1989: x_ship_count NUMBER := 0;

Line 2020: from po_headers_all poh,po_releases_all por

2016:
2017:
2018: select poh.type_lookup_code,por.org_id
2019: into v_type_code,x_org_id
2020: from po_headers_all poh,po_releases_all por
2021: where por.po_header_id = poh.po_header_id and
2022: por.po_release_id = p_po_release_id;
2023:
2024: if (v_type_code = 'BLANKET') then

Line 2034: from po_headers_all

2030: end if;
2031: else
2032: p_document_id := p_po_header_id;
2033: select type_lookup_code into v_type_code
2034: from po_headers_all
2035: where po_header_id= p_po_header_id;
2036: if (v_type_code in ('STANDARD','PLANNED')) then
2037: v_document_type := 'PO';
2038: v_document_subtype := v_type_code;

Line 2046: from po_headers_all

2042: end if;
2043:
2044: select org_id
2045: into x_org_id
2046: from po_headers_all
2047: where po_header_id= p_po_header_id;
2048:
2049: end if;
2050: -- Set the org context before calling the cancel api

Line 2090: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH

2086: AND POL.order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE');
2087: else
2088: SELECT count(*)
2089: INTO x_ship_count
2090: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH
2091: WHERE
2092: POH.PO_HEADER_ID = p_po_header_id
2093: AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
2094: AND POH.TYPE_LOOKUP_CODE ='STANDARD'

Line 2163: x_accp_flag po_headers_all.acceptance_required_flag%type;

2159: x_msg_display OUT NOCOPY VARCHAR2,
2160: x_note OUT NOCOPY LONG) IS
2161:
2162: x_ack_stat varchar2(40);
2163: x_accp_flag po_headers_all.acceptance_required_flag%type;
2164: x_revision number;
2165: x_cons_flag po_line_locations.consigned_flag%type;
2166:
2167: BEGIN

Line 2212: po_headers_all poh,

2208: pll.po_header_id, p_po_release_id,p_revision_num),nvl(poh.acceptance_required_flag,'N'),
2209: poh.revision_num,nvl(pll.consigned_flag,'N')
2210: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2211: from po_line_locations_all pll,
2212: po_headers_all poh,
2213: po_lookup_codes polc
2214: where
2215: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and
2216: polc.lookup_type = 'DOCUMENT STATE' and

Line 2423: FROM po_headers_all

2419:
2420: BEGIN
2421: SELECT segment1
2422: INTO x_ga_number
2423: FROM po_headers_all
2424: WHERE po_header_id = p_from_header_id
2425: AND global_agreement_flag='Y';
2426: EXCEPTION
2427: when no_data_found then

Line 2675: update po_headers_all set

2671: fetch c1 into lGrpId,lRevNum;
2672: close c1;
2673: if (lGrpId is null) then
2674:
2675: update po_headers_all set
2676: authorization_status = 'APPROVED',
2677: CHANGE_REQUESTED_BY = null,
2678: last_update_date = sysdate,
2679: last_updated_by = fnd_global.user_id,

Line 2692: from po_headers_all

2688:
2689: begin
2690: select revision_num
2691: into l_revision_num
2692: from po_headers_all
2693: where po_header_id = p_po_header_id;
2694: exception
2695: when others then
2696: raise;

Line 2798: from po_headers_all

2794: end if;
2795:
2796: select wf_item_type
2797: into l_item_type
2798: from po_headers_all
2799: WHERE po_header_id = p_po_header_id;
2800:
2801:
2802: -- First Find the Item Key for this Document if it were ever generated

Line 3143: from po_headers_All

3139: else
3140:
3141: select last_update_Date
3142: into p_last_update_date
3143: from po_headers_All
3144: where po_header_id = p_header_id
3145: and rownum=1;
3146:
3147: end if;