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

Line 14: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

10:
11: =============================================================================*/
12: FUNCTION is_quotation
13: (
14: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
15: )
16: RETURN BOOLEAN
17: IS
18: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 18: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

14: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
15: )
16: RETURN BOOLEAN
17: IS
18: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
19:
20: BEGIN
21:
22: SELECT type_lookup_code

Line 24: FROM po_headers_all

20: BEGIN
21:
22: SELECT type_lookup_code
23: INTO l_type_lookup_code
24: FROM po_headers_all
25: WHERE po_header_id = p_po_header_id;
26:
27: IF ( l_type_lookup_code = 'QUOTATION' ) THEN
28: return (TRUE);

Line 115: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

111:
112: =============================================================================*/
113: FUNCTION get_type_name
114: (
115: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
116: )
117: RETURN PO_DOCUMENT_TYPES_ALL.type_name%TYPE
118: IS
119: x_type_name PO_DOCUMENT_TYPES_ALL.type_name%TYPE;

Line 121: l_org_id PO_HEADERS_ALL.org_id%TYPE;

117: RETURN PO_DOCUMENT_TYPES_ALL.type_name%TYPE
118: IS
119: x_type_name PO_DOCUMENT_TYPES_ALL.type_name%TYPE;
120:
121: l_org_id PO_HEADERS_ALL.org_id%TYPE;
122: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
123: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;
124:
125: l_document_type_code PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

Line 122: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

118: IS
119: x_type_name PO_DOCUMENT_TYPES_ALL.type_name%TYPE;
120:
121: l_org_id PO_HEADERS_ALL.org_id%TYPE;
122: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
123: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;
124:
125: l_document_type_code PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
126: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

Line 123: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;

119: x_type_name PO_DOCUMENT_TYPES_ALL.type_name%TYPE;
120:
121: l_org_id PO_HEADERS_ALL.org_id%TYPE;
122: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
123: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;
124:
125: l_document_type_code PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
126: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
127:

Line 136: FROM po_headers_all

132: org_id
133: INTO l_type_lookup_code,
134: l_quote_type_lookup_code,
135: l_org_id
136: FROM po_headers_all
137: WHERE po_header_id = p_po_header_id;
138:
139: -- based on PO_HEADERS_ALL.type_lookup_code & .quote_type_lookup_code,
140: -- sets PO_DOCUMENT_TYPES_ALL.document_type_code & .document_subtype

Line 139: -- based on PO_HEADERS_ALL.type_lookup_code & .quote_type_lookup_code,

135: l_org_id
136: FROM po_headers_all
137: WHERE po_header_id = p_po_header_id;
138:
139: -- based on PO_HEADERS_ALL.type_lookup_code & .quote_type_lookup_code,
140: -- sets PO_DOCUMENT_TYPES_ALL.document_type_code & .document_subtype
141: --
142: IF ( l_type_lookup_code = 'BLANKET' ) THEN -- Blanket Agreement
143: l_document_type_code := 'PA';

Line 189: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

185:
186: =============================================================================*/
187: FUNCTION get_doc_num
188: (
189: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
190: )
191: RETURN PO_HEADERS_ALL.segment1%TYPE
192: IS
193: x_segment1 PO_HEADERS_ALL.segment1%TYPE;

Line 191: RETURN PO_HEADERS_ALL.segment1%TYPE

187: FUNCTION get_doc_num
188: (
189: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
190: )
191: RETURN PO_HEADERS_ALL.segment1%TYPE
192: IS
193: x_segment1 PO_HEADERS_ALL.segment1%TYPE;
194:
195: BEGIN

Line 193: x_segment1 PO_HEADERS_ALL.segment1%TYPE;

189: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
190: )
191: RETURN PO_HEADERS_ALL.segment1%TYPE
192: IS
193: x_segment1 PO_HEADERS_ALL.segment1%TYPE;
194:
195: BEGIN
196:
197: SELECT segment1

Line 199: FROM po_headers_all

195: BEGIN
196:
197: SELECT segment1
198: INTO x_segment1
199: FROM po_headers_all
200: WHERE po_header_id = p_po_header_id;
201:
202: return (x_segment1);
203:

Line 220: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

216:
217: =============================================================================*/
218: FUNCTION get_vendor_quote_num
219: (
220: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
221: )
222: RETURN PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
223: IS
224: x_vendor_quote_num PO_HEADERS_ALL.quote_vendor_quote_number%TYPE;

Line 222: RETURN PO_HEADERS_ALL.quote_vendor_quote_number%TYPE

218: FUNCTION get_vendor_quote_num
219: (
220: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
221: )
222: RETURN PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
223: IS
224: x_vendor_quote_num PO_HEADERS_ALL.quote_vendor_quote_number%TYPE;
225:
226: BEGIN

Line 224: x_vendor_quote_num PO_HEADERS_ALL.quote_vendor_quote_number%TYPE;

220: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
221: )
222: RETURN PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
223: IS
224: x_vendor_quote_num PO_HEADERS_ALL.quote_vendor_quote_number%TYPE;
225:
226: BEGIN
227:
228: SELECT quote_vendor_quote_number

Line 230: FROM po_headers_all

226: BEGIN
227:
228: SELECT quote_vendor_quote_number
229: INTO x_vendor_quote_num
230: FROM po_headers_all
231: WHERE po_header_id = p_po_header_id;
232:
233: return (x_vendor_quote_num);
234:

Line 338: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

334: -- Exceptions : -
335: --=============================================================================
336: FUNCTION cumulative_lines_exist
337: (
338: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
339: )
340: RETURN BOOLEAN
341: IS
342: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;

Line 378: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE

374:
375: =============================================================================*/
376: /*FUNCTION references_exist
377: (
378: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
379: )
380: RETURN BOOLEAN
381: IS
382: CURSOR l_reference_csr IS

Line 443: FROM po_headers_all POH

439: BEGIN
440:
441: SELECT 'Y'
442: INTO l_is_valid
443: FROM po_headers_all POH
444: WHERE POH.po_header_id = p_po_header_id
445: AND POH.type_lookup_code = 'CONTRACT'
446: AND NVL(POH.cancel_flag, 'N') = 'N'
447: AND NVL(POH.closed_code, 'OPEN') = 'OPEN'