APPS.RCV_TABLE_FUNCTIONS dependencies on PO_LINE_LOCATIONS

Line 11: g_pll_row po_line_locations_all%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;
14: g_oel_row oe_order_lines_all%ROWTYPE;
15: g_prl_row po_requisition_lines_all%ROWTYPE;

Line 570: p_shipment_num po_line_locations_all.shipment_num%TYPE,

566: /*******/
567: /* pll */
568: /*******/
569: FUNCTION get_pll_row_from_num(
570: p_shipment_num po_line_locations_all.shipment_num%TYPE,
571: p_line_id po_line_locations_all.po_line_id%TYPE
572: )
573: RETURN po_line_locations_all%ROWTYPE IS
574: BEGIN

Line 571: p_line_id po_line_locations_all.po_line_id%TYPE

567: /* pll */
568: /*******/
569: FUNCTION get_pll_row_from_num(
570: p_shipment_num po_line_locations_all.shipment_num%TYPE,
571: p_line_id po_line_locations_all.po_line_id%TYPE
572: )
573: RETURN po_line_locations_all%ROWTYPE IS
574: BEGIN
575: IF ( p_shipment_num IS NULL

Line 573: RETURN po_line_locations_all%ROWTYPE IS

569: FUNCTION get_pll_row_from_num(
570: p_shipment_num po_line_locations_all.shipment_num%TYPE,
571: p_line_id po_line_locations_all.po_line_id%TYPE
572: )
573: RETURN po_line_locations_all%ROWTYPE IS
574: BEGIN
575: IF ( p_shipment_num IS NULL
576: OR p_line_id IS NULL) THEN
577: RETURN NULL;

Line 588: FROM po_line_locations_all

584:
585: --first check if there is a singular match in the current OU
586: SELECT *
587: INTO g_pll_row
588: FROM po_line_locations_all
589: WHERE line_location_id IN(SELECT line_location_id
590: FROM po_line_locations
591: WHERE shipment_num = p_shipment_num
592: AND po_line_id = p_line_id);

Line 590: FROM po_line_locations

586: SELECT *
587: INTO g_pll_row
588: FROM po_line_locations_all
589: WHERE line_location_id IN(SELECT line_location_id
590: FROM po_line_locations
591: WHERE shipment_num = p_shipment_num
592: AND po_line_id = p_line_id);
593:
594: RETURN g_pll_row;

Line 600: FROM po_line_locations_all

596: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
597: BEGIN
598: SELECT *
599: INTO g_pll_row
600: FROM po_line_locations_all
601: WHERE shipment_num = p_shipment_num
602: AND po_line_id = p_line_id;
603:
604: RETURN g_pll_row;

Line 628: p_line_location_id IN po_line_locations_all.line_location_id%TYPE

624: RETURN NULL;
625: END get_pll_row_from_num;
626:
627: FUNCTION get_pll_row_from_id(
628: p_line_location_id IN po_line_locations_all.line_location_id%TYPE
629: )
630: RETURN po_line_locations_all%ROWTYPE IS
631: BEGIN
632: IF (p_line_location_id IS NULL) THEN

Line 630: RETURN po_line_locations_all%ROWTYPE IS

626:
627: FUNCTION get_pll_row_from_id(
628: p_line_location_id IN po_line_locations_all.line_location_id%TYPE
629: )
630: RETURN po_line_locations_all%ROWTYPE IS
631: BEGIN
632: IF (p_line_location_id IS NULL) THEN
633: RETURN NULL;
634: END IF;

Line 642: FROM po_line_locations_all

638: END IF;
639:
640: SELECT *
641: INTO g_pll_row
642: FROM po_line_locations_all
643: WHERE line_location_id = p_line_location_id;
644:
645: RETURN g_pll_row;
646: EXCEPTION

Line 1184: FROM po_line_locations_all

1180: IF ( nvl(g_pll_id,-99) <> p_po_line_location_id) THEN
1181:
1182: SELECT nvl(lcm_flag,'N')
1183: INTO g_lcm_flag
1184: FROM po_line_locations_all
1185: WHERE line_location_id = p_po_line_location_id;
1186:
1187: g_pll_id := p_po_line_location_id;
1188: END IF;