APPS.RCV_TABLE_FUNCTIONS dependencies on PO_HEADERS_ALL

Line 9: g_poh_row po_headers_all%ROWTYPE;

5: g_rti_row rcv_transactions_interface%ROWTYPE;
6: g_rt_row rcv_transactions%ROWTYPE;
7: g_rsh_row rcv_shipment_headers%ROWTYPE;
8: g_rsl_row rcv_shipment_lines%ROWTYPE;
9: g_poh_row po_headers_all%ROWTYPE;
10: g_pol_row po_lines_all%ROWTYPE;
11: g_pll_row po_line_locations_all%ROWTYPE;
12: g_pod_row po_distributions_all%ROWTYPE;
13: g_oeh_row oe_order_headers_all%ROWTYPE;

Line 316: p_po_num po_headers_all.segment1%TYPE,

312: /*******/
313: /* poh */
314: /*******/
315: FUNCTION get_poh_row_from_num(
316: p_po_num po_headers_all.segment1%TYPE,
317: p_org_id po_headers_all.org_id%TYPE
318: )
319: RETURN po_headers_all%ROWTYPE IS
320: BEGIN

Line 317: p_org_id po_headers_all.org_id%TYPE

313: /* poh */
314: /*******/
315: FUNCTION get_poh_row_from_num(
316: p_po_num po_headers_all.segment1%TYPE,
317: p_org_id po_headers_all.org_id%TYPE
318: )
319: RETURN po_headers_all%ROWTYPE IS
320: BEGIN
321: IF (p_po_num IS NULL) THEN

Line 319: RETURN po_headers_all%ROWTYPE IS

315: FUNCTION get_poh_row_from_num(
316: p_po_num po_headers_all.segment1%TYPE,
317: p_org_id po_headers_all.org_id%TYPE
318: )
319: RETURN po_headers_all%ROWTYPE IS
320: BEGIN
321: IF (p_po_num IS NULL) THEN
322: RETURN NULL;
323: END IF;

Line 332: FROM po_headers_all

328:
329: --first check if there is a singular match in the current OU
330: SELECT *
331: INTO g_poh_row
332: FROM po_headers_all
333: WHERE po_header_id IN(SELECT po_header_id
334: FROM po_headers
335: WHERE segment1 = p_po_num
336: AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')

Line 345: FROM po_headers_all

341: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
342: BEGIN
343: SELECT *
344: INTO g_poh_row
345: FROM po_headers_all
346: WHERE segment1 = p_po_num
347: AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
348: AND org_id = NVL(p_org_id, org_id);
349:

Line 366: FROM po_headers_all

362: IF (g_default_org_id IS NOT NULL) THEN
363: BEGIN
364: SELECT *
365: INTO g_poh_row
366: FROM po_headers_all
367: WHERE segment1 = p_po_num
368: AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
369: AND org_id = g_default_org_id;
370:

Line 386: p_header_id IN po_headers_all.po_header_id%TYPE

382: RETURN NULL;
383: END get_poh_row_from_num;
384:
385: FUNCTION get_poh_row_from_id(
386: p_header_id IN po_headers_all.po_header_id%TYPE
387: )
388: RETURN po_headers_all%ROWTYPE IS
389: BEGIN
390: IF (p_header_id IS NULL) THEN

Line 388: RETURN po_headers_all%ROWTYPE IS

384:
385: FUNCTION get_poh_row_from_id(
386: p_header_id IN po_headers_all.po_header_id%TYPE
387: )
388: RETURN po_headers_all%ROWTYPE IS
389: BEGIN
390: IF (p_header_id IS NULL) THEN
391: RETURN NULL;
392: END IF;

Line 400: FROM po_headers_all

396: END IF;
397:
398: SELECT *
399: INTO g_poh_row
400: FROM po_headers_all
401: WHERE po_header_id = p_header_id;
402:
403: RETURN g_poh_row;
404: EXCEPTION