APPS.RCV_TABLE_FUNCTIONS dependencies on PO_LINE_LOCATIONS_ALL

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 547: p_shipment_num po_line_locations_all.shipment_num%TYPE,

543: /*******/
544: /* pll */
545: /*******/
546: FUNCTION get_pll_row_from_num(
547: p_shipment_num po_line_locations_all.shipment_num%TYPE,
548: p_line_id po_line_locations_all.po_line_id%TYPE
549: )
550: RETURN po_line_locations_all%ROWTYPE IS
551: BEGIN

Line 548: p_line_id po_line_locations_all.po_line_id%TYPE

544: /* pll */
545: /*******/
546: FUNCTION get_pll_row_from_num(
547: p_shipment_num po_line_locations_all.shipment_num%TYPE,
548: p_line_id po_line_locations_all.po_line_id%TYPE
549: )
550: RETURN po_line_locations_all%ROWTYPE IS
551: BEGIN
552: IF ( p_shipment_num IS NULL

Line 550: RETURN po_line_locations_all%ROWTYPE IS

546: FUNCTION get_pll_row_from_num(
547: p_shipment_num po_line_locations_all.shipment_num%TYPE,
548: p_line_id po_line_locations_all.po_line_id%TYPE
549: )
550: RETURN po_line_locations_all%ROWTYPE IS
551: BEGIN
552: IF ( p_shipment_num IS NULL
553: OR p_line_id IS NULL) THEN
554: RETURN NULL;

Line 565: FROM po_line_locations_all

561:
562: --first check if there is a singular match in the current OU
563: SELECT *
564: INTO g_pll_row
565: FROM po_line_locations_all
566: WHERE line_location_id IN(SELECT line_location_id
567: FROM po_line_locations
568: WHERE shipment_num = p_shipment_num
569: AND po_line_id = p_line_id);

Line 577: FROM po_line_locations_all

573: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
574: BEGIN
575: SELECT *
576: INTO g_pll_row
577: FROM po_line_locations_all
578: WHERE shipment_num = p_shipment_num
579: AND po_line_id = p_line_id;
580:
581: RETURN g_pll_row;

Line 601: p_line_location_id IN po_line_locations_all.line_location_id%TYPE

597: RETURN NULL;
598: END get_pll_row_from_num;
599:
600: FUNCTION get_pll_row_from_id(
601: p_line_location_id IN po_line_locations_all.line_location_id%TYPE
602: )
603: RETURN po_line_locations_all%ROWTYPE IS
604: BEGIN
605: IF (p_line_location_id IS NULL) THEN

Line 603: RETURN po_line_locations_all%ROWTYPE IS

599:
600: FUNCTION get_pll_row_from_id(
601: p_line_location_id IN po_line_locations_all.line_location_id%TYPE
602: )
603: RETURN po_line_locations_all%ROWTYPE IS
604: BEGIN
605: IF (p_line_location_id IS NULL) THEN
606: RETURN NULL;
607: END IF;

Line 615: FROM po_line_locations_all

611: END IF;
612:
613: SELECT *
614: INTO g_pll_row
615: FROM po_line_locations_all
616: WHERE line_location_id = p_line_location_id;
617:
618: RETURN g_pll_row;
619: EXCEPTION

Line 1148: FROM po_line_locations_all

1144: IF ( nvl(g_pll_id,-99) <> p_po_line_location_id) THEN
1145:
1146: SELECT nvl(lcm_flag,'N')
1147: INTO g_lcm_flag
1148: FROM po_line_locations_all
1149: WHERE line_location_id = p_po_line_location_id;
1150:
1151: g_pll_id := p_po_line_location_id;
1152: END IF;