APPS.RCV_TABLE_FUNCTIONS dependencies on OE_ORDER_LINES

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 823: p_line_number oe_order_lines_all.line_number%TYPE,

819: /*******/
820: /* oel */
821: /*******/
822: FUNCTION get_oel_row_from_num(
823: p_line_number oe_order_lines_all.line_number%TYPE,
824: p_header_id oe_order_lines_all.header_id%TYPE
825: )
826: RETURN oe_order_lines_all%ROWTYPE IS
827: BEGIN

Line 824: p_header_id oe_order_lines_all.header_id%TYPE

820: /* oel */
821: /*******/
822: FUNCTION get_oel_row_from_num(
823: p_line_number oe_order_lines_all.line_number%TYPE,
824: p_header_id oe_order_lines_all.header_id%TYPE
825: )
826: RETURN oe_order_lines_all%ROWTYPE IS
827: BEGIN
828: IF ( p_line_number IS NULL

Line 826: RETURN oe_order_lines_all%ROWTYPE IS

822: FUNCTION get_oel_row_from_num(
823: p_line_number oe_order_lines_all.line_number%TYPE,
824: p_header_id oe_order_lines_all.header_id%TYPE
825: )
826: RETURN oe_order_lines_all%ROWTYPE IS
827: BEGIN
828: IF ( p_line_number IS NULL
829: OR p_header_id IS NULL) THEN
830: RETURN NULL;

Line 841: FROM oe_order_lines_all

837:
838: --first check if there is a singular match in the current OU
839: SELECT *
840: INTO g_oel_row
841: FROM oe_order_lines_all
842: WHERE line_id IN(SELECT line_id
843: FROM oe_order_lines
844: WHERE line_number = p_line_number
845: AND header_id = p_header_id

Line 843: FROM oe_order_lines

839: SELECT *
840: INTO g_oel_row
841: FROM oe_order_lines_all
842: WHERE line_id IN(SELECT line_id
843: FROM oe_order_lines
844: WHERE line_number = p_line_number
845: AND header_id = p_header_id
846: AND flow_status_code = 'AWAITING_RETURN');
847:

Line 854: FROM oe_order_lines_all

850: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
851: BEGIN
852: SELECT *
853: INTO g_oel_row
854: FROM oe_order_lines_all
855: WHERE line_number = p_line_number
856: AND header_id = p_header_id
857: AND flow_status_code = 'AWAITING_RETURN';
858:

Line 879: p_line_id IN oe_order_lines_all.line_id%TYPE

875: RETURN NULL;
876: END get_oel_row_from_num;
877:
878: FUNCTION get_oel_row_from_id(
879: p_line_id IN oe_order_lines_all.line_id%TYPE
880: )
881: RETURN oe_order_lines_all%ROWTYPE IS
882: BEGIN
883: IF (p_line_id IS NULL) THEN

Line 881: RETURN oe_order_lines_all%ROWTYPE IS

877:
878: FUNCTION get_oel_row_from_id(
879: p_line_id IN oe_order_lines_all.line_id%TYPE
880: )
881: RETURN oe_order_lines_all%ROWTYPE IS
882: BEGIN
883: IF (p_line_id IS NULL) THEN
884: RETURN NULL;
885: END IF;

Line 893: FROM oe_order_lines_all

889: END IF;
890:
891: SELECT *
892: INTO g_oel_row
893: FROM oe_order_lines_all
894: WHERE line_id = p_line_id;
895:
896: RETURN g_oel_row;
897: EXCEPTION