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

Line 74: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

70: p_po_release_id IN NUMBER,
71: p_po_line_location_id IN number default null) IS
72:
73: p_document_id NUMBER;
74: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
75: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
76: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
77: l_api_name CONSTANT VARCHAR2(30) := 'validateCancelRequest';
78: l_api_version CONSTANT NUMBER := 1.0;

Line 75: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

71: p_po_line_location_id IN number default null) IS
72:
73: p_document_id NUMBER;
74: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
75: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
76: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
77: l_api_name CONSTANT VARCHAR2(30) := 'validateCancelRequest';
78: l_api_version CONSTANT NUMBER := 1.0;
79: l_doc_line_id number; -- added for bug# 5639722

Line 76: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

72:
73: p_document_id NUMBER;
74: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
75: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
76: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
77: l_api_name CONSTANT VARCHAR2(30) := 'validateCancelRequest';
78: l_api_version CONSTANT NUMBER := 1.0;
79: l_doc_line_id number; -- added for bug# 5639722
80: x_org_id number;

Line 114: from po_headers_all

110:
111: else
112: p_document_id := p_po_header_id;
113: select type_lookup_code into v_type_code
114: from po_headers_all
115: where po_header_id= p_po_header_id;
116: if (v_type_code in ('STANDARD','PLANNED')) then
117: v_document_type := 'PO';
118: v_document_subtype := v_type_code;

Line 126: from po_headers_all

122: end if;
123:
124: select org_id
125: into x_org_id
126: from po_headers_all
127: where po_header_id= p_po_header_id;
128:
129: end if;
130: -- Set the org context before calling the cancel api

Line 250: from po_headers_all

246: AND vendor_site_id = p_tp_site_id;
247:
248: select po_header_id, VENDOR_ORDER_NUM
249: into l_po_header_id, l_old_so_order_number
250: from po_headers_all
251: where segment1 = p_po_number
252: AND org_id = l_org_id
253: AND TYPE_LOOKUP_CODE NOT IN ('QUOTATION','RFQ');
254: -- Bug 7287009 - End

Line 290: from po_headers_all

286: WHERE vendor_id = p_tp_id
287: AND vendor_site_id = p_tp_site_id;
288:
289: select po_header_id into l_po_header_id
290: from po_headers_all
291: where segment1 = p_po_number
292: AND org_id = l_org_id
293: AND TYPE_LOOKUP_CODE NOT IN ('QUOTATION','RFQ');
294: -- Bug 7287009 - End

Line 464: PO_HEADERS_ALL PHA,

460:
461: FROM
462: PO_LINES_ALL PLA,
463: FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
464: PO_HEADERS_ALL PHA,
465: PO_CHANGE_REQUESTS POCR
466:
467: WHERE
468:

Line 850: PO_RELEASES_ALL PRAA, PO_HEADERS_ALL PHA,

846: PO_LINE_LOCATIONS_ALL PLLA,
847: PO_LINES_ALL PLA,
848: FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
849: -- MTL_UNITS_OF_MEASURE_TL MUOMTL,
850: PO_RELEASES_ALL PRAA, PO_HEADERS_ALL PHA,
851: PO_CHANGE_REQUESTS POCR
852: WHERE
853: PLA.PO_Line_id= PLLA.PO_Line_ID and
854: (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) > 0 AND

Line 932: PO_HEADERS_ALL PHA,

928: FROM
929: PO_LINE_LOCATIONS_ALL PLLA,
930: PO_LINES_ALL PLA,
931: FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
932: PO_HEADERS_ALL PHA,
933: PO_CHANGE_REQUESTS POCR
934: WHERE
935: PLA.PO_Line_id= PLLA.PO_Line_ID and
936: (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) > 0 AND

Line 1503: from po_releases_all pra, po_headers_all pha

1499:
1500: --Check if the given release exists and belongs to the given TP
1501: if ('RELEASE' = upper(p_po_type) ) then
1502: select count(1) into l_count
1503: from po_releases_all pra, po_headers_all pha
1504: where pra.po_header_id = pha.po_header_id
1505: and pra.release_num = p_release_number
1506: and pha.segment1 = p_po_number
1507: and pha.org_id = l_org_id

Line 1527: from po_headers_all pha

1523:
1524: else -- assume that it is a STANDARD PO
1525: --Check if the given PO exists and belongs to the given TP
1526: select count(1) into l_count
1527: from po_headers_all pha
1528: where pha.segment1 = p_po_number
1529: and pha.org_id = l_org_id
1530: AND pha.TYPE_LOOKUP_CODE NOT IN ('QUOTATION','RFQ');
1531:

Line 1565: from po_headers_all

1561: --to recieve change or acknowledge.
1562:
1563: select authorization_status, po_header_id, last_update_date
1564: into l_po_status, l_po_header_id, g_last_upd_date
1565: from po_headers_all
1566: where segment1 = p_po_number
1567: and org_id = l_org_id
1568: and TYPE_LOOKUP_CODE NOT IN ('QUOTATION','RFQ');
1569:

Line 2063: l_last_update_date po_headers_all.last_update_date%type;

2059: x_error is added to check if there are any concurrency issues. If x_error is true then it will raise
2060: concurrency exception.
2061: l_concurrency_exception is added to raise the exception in case if there are any concurrency issues. */
2062:
2063: l_last_update_date po_headers_all.last_update_date%type;
2064: x_error VARCHAR2(30);
2065: l_concurrency_exception EXCEPTION;
2066:
2067: begin

Line 2085: from po_headers_all

2081: AND vendor_site_id = p_tp_site_id;
2082:
2083: select to_char(po_header_id), to_char(agent_id), LAST_UPDATE_DATE
2084: into l_po_header_id, l_po_buyer_id, l_last_update_date
2085: from po_headers_all
2086: where segment1 = p_po_number
2087: and org_id = l_org_id
2088: AND TYPE_LOOKUP_CODE NOT IN ('QUOTATION','RFQ');
2089: -- Bug 7287009 - End