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 319: p_po_num po_headers_all.segment1%TYPE,

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

Line 320: p_org_id po_headers_all.org_id%TYPE

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

Line 322: RETURN po_headers_all%ROWTYPE IS

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

Line 335: FROM po_headers_all

331:
332: --first check if there is a singular match in the current OU
333: SELECT *
334: INTO g_poh_row
335: FROM po_headers_all
336: WHERE po_header_id IN(SELECT po_header_id
337: FROM po_headers
338: WHERE segment1 = p_po_num
339: -- Bug 13720644 Begin: type_lookup_code for Planned Purchase Order is 'PLANNED'

Line 351: FROM po_headers_all

347: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
348: BEGIN
349: SELECT *
350: INTO g_poh_row
351: FROM po_headers_all
352: WHERE segment1 = p_po_num
353: -- Bug 13720644: type_lookup_code for Planned Purchase Order is 'PLANNED'
354: --AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
355: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')

Line 375: FROM po_headers_all

371: IF (g_default_org_id IS NOT NULL) THEN
372: BEGIN
373: SELECT *
374: INTO g_poh_row
375: FROM po_headers_all
376: WHERE segment1 = p_po_num
377: -- Bug 13720644: type_lookup_code for Planned Purchase Order is 'PLANNED'
378: --AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
379: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')

Line 398: p_header_id IN po_headers_all.po_header_id%TYPE

394: RETURN NULL;
395: END get_poh_row_from_num;
396:
397: FUNCTION get_poh_row_from_id(
398: p_header_id IN po_headers_all.po_header_id%TYPE
399: )
400: RETURN po_headers_all%ROWTYPE IS
401: BEGIN
402: IF (p_header_id IS NULL) THEN

Line 400: RETURN po_headers_all%ROWTYPE IS

396:
397: FUNCTION get_poh_row_from_id(
398: p_header_id IN po_headers_all.po_header_id%TYPE
399: )
400: RETURN po_headers_all%ROWTYPE IS
401: BEGIN
402: IF (p_header_id IS NULL) THEN
403: RETURN NULL;
404: END IF;

Line 412: FROM po_headers_all

408: END IF;
409:
410: SELECT *
411: INTO g_poh_row
412: FROM po_headers_all
413: WHERE po_header_id = p_header_id;
414:
415: RETURN g_poh_row;
416: EXCEPTION