APPS.RCV_TABLE_FUNCTIONS dependencies on OE_ORDER_LINES_ALL

Line 14: g_oel_row oe_order_lines_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;
16: g_prd_row po_req_distributions_all%ROWTYPE;
17: g_msi_row mtl_system_items%ROWTYPE;
18: g_mic_row mtl_item_categories%ROWTYPE;

Line 850: p_line_number oe_order_lines_all.line_number%TYPE,

846: /*******/
847: /* oel */
848: /*******/
849: FUNCTION get_oel_row_from_num(
850: p_line_number oe_order_lines_all.line_number%TYPE,
851: p_header_id oe_order_lines_all.header_id%TYPE
852: )
853: RETURN oe_order_lines_all%ROWTYPE IS
854: BEGIN

Line 851: p_header_id oe_order_lines_all.header_id%TYPE

847: /* oel */
848: /*******/
849: FUNCTION get_oel_row_from_num(
850: p_line_number oe_order_lines_all.line_number%TYPE,
851: p_header_id oe_order_lines_all.header_id%TYPE
852: )
853: RETURN oe_order_lines_all%ROWTYPE IS
854: BEGIN
855: IF ( p_line_number IS NULL

Line 853: RETURN oe_order_lines_all%ROWTYPE IS

849: FUNCTION get_oel_row_from_num(
850: p_line_number oe_order_lines_all.line_number%TYPE,
851: p_header_id oe_order_lines_all.header_id%TYPE
852: )
853: RETURN oe_order_lines_all%ROWTYPE IS
854: BEGIN
855: IF ( p_line_number IS NULL
856: OR p_header_id IS NULL) THEN
857: RETURN NULL;

Line 868: FROM oe_order_lines_all

864:
865: --first check if there is a singular match in the current OU
866: SELECT *
867: INTO g_oel_row
868: FROM oe_order_lines_all
869: WHERE line_id IN(SELECT line_id
870: FROM oe_order_lines
871: WHERE line_number = p_line_number
872: AND header_id = p_header_id

Line 881: FROM oe_order_lines_all

877: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
878: BEGIN
879: SELECT *
880: INTO g_oel_row
881: FROM oe_order_lines_all
882: WHERE line_number = p_line_number
883: AND header_id = p_header_id
884: AND flow_status_code = 'AWAITING_RETURN';
885:

Line 906: p_line_id IN oe_order_lines_all.line_id%TYPE

902: RETURN NULL;
903: END get_oel_row_from_num;
904:
905: FUNCTION get_oel_row_from_id(
906: p_line_id IN oe_order_lines_all.line_id%TYPE
907: )
908: RETURN oe_order_lines_all%ROWTYPE IS
909: BEGIN
910: IF (p_line_id IS NULL) THEN

Line 908: RETURN oe_order_lines_all%ROWTYPE IS

904:
905: FUNCTION get_oel_row_from_id(
906: p_line_id IN oe_order_lines_all.line_id%TYPE
907: )
908: RETURN oe_order_lines_all%ROWTYPE IS
909: BEGIN
910: IF (p_line_id IS NULL) THEN
911: RETURN NULL;
912: END IF;

Line 920: FROM oe_order_lines_all

916: END IF;
917:
918: SELECT *
919: INTO g_oel_row
920: FROM oe_order_lines_all
921: WHERE line_id = p_line_id;
922:
923: RETURN g_oel_row;
924: EXCEPTION