APPS.RCV_TABLE_FUNCTIONS dependencies on OE_ORDER_HEADERS_ALL

Line 13: g_oeh_row oe_order_headers_all%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;
16: g_prd_row po_req_distributions_all%ROWTYPE;
17: g_msi_row mtl_system_items%ROWTYPE;

Line 736: p_order_number oe_order_headers_all.order_number%TYPE,

732: /*******/
733: /* oeh */
734: /*******/
735: FUNCTION get_oeh_row_from_num(
736: p_order_number oe_order_headers_all.order_number%TYPE,
737: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
738: p_version_number oe_order_headers_all.version_number%TYPE,
739: p_org_id oe_order_headers_all.org_id%TYPE
740: )

Line 737: p_order_type_id oe_order_headers_all.order_type_id%TYPE,

733: /* oeh */
734: /*******/
735: FUNCTION get_oeh_row_from_num(
736: p_order_number oe_order_headers_all.order_number%TYPE,
737: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
738: p_version_number oe_order_headers_all.version_number%TYPE,
739: p_org_id oe_order_headers_all.org_id%TYPE
740: )
741: RETURN oe_order_headers_all%ROWTYPE IS

Line 738: p_version_number oe_order_headers_all.version_number%TYPE,

734: /*******/
735: FUNCTION get_oeh_row_from_num(
736: p_order_number oe_order_headers_all.order_number%TYPE,
737: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
738: p_version_number oe_order_headers_all.version_number%TYPE,
739: p_org_id oe_order_headers_all.org_id%TYPE
740: )
741: RETURN oe_order_headers_all%ROWTYPE IS
742: BEGIN

Line 739: p_org_id oe_order_headers_all.org_id%TYPE

735: FUNCTION get_oeh_row_from_num(
736: p_order_number oe_order_headers_all.order_number%TYPE,
737: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
738: p_version_number oe_order_headers_all.version_number%TYPE,
739: p_org_id oe_order_headers_all.org_id%TYPE
740: )
741: RETURN oe_order_headers_all%ROWTYPE IS
742: BEGIN
743: IF (p_order_number IS NULL) THEN

Line 741: RETURN oe_order_headers_all%ROWTYPE IS

737: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
738: p_version_number oe_order_headers_all.version_number%TYPE,
739: p_org_id oe_order_headers_all.org_id%TYPE
740: )
741: RETURN oe_order_headers_all%ROWTYPE IS
742: BEGIN
743: IF (p_order_number IS NULL) THEN
744: RETURN NULL;
745: END IF;

Line 760: FROM oe_order_headers_all

756: /* WDK: NOTE - THIS QUERY IS NOT UNIQUE!!! REQUIRES ORDER_TYPE_ID and VERSION_NUMBER.
757: WE CAN FIX ONLY IF WE ADD THESE COLUMNS */
758: SELECT *
759: INTO g_oeh_row
760: FROM oe_order_headers_all
761: WHERE header_id IN(SELECT header_id
762: FROM oe_order_headers
763: WHERE order_number = p_order_number
764: AND order_type_id = NVL(p_order_type_id, order_type_id)

Line 776: FROM oe_order_headers_all

772: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
773: BEGIN
774: SELECT *
775: INTO g_oeh_row
776: FROM oe_order_headers_all
777: WHERE order_number = p_order_number
778: AND order_type_id = NVL(p_order_type_id, order_type_id)
779: AND version_number = NVL(p_version_number, version_number)
780: AND org_id = NVL(p_org_id, org_id)

Line 800: FROM oe_order_headers_all

796: IF (g_default_org_id IS NOT NULL) THEN
797: BEGIN
798: SELECT *
799: INTO g_oeh_row
800: FROM oe_order_headers_all
801: WHERE order_number = p_order_number
802: AND order_type_id = NVL(p_order_type_id, order_type_id)
803: AND version_number = NVL(p_version_number, version_number)
804: AND org_id = g_default_org_id

Line 823: p_header_id IN oe_order_headers_all.header_id%TYPE

819: RETURN NULL;
820: END get_oeh_row_from_num;
821:
822: FUNCTION get_oeh_row_from_id(
823: p_header_id IN oe_order_headers_all.header_id%TYPE
824: )
825: RETURN oe_order_headers_all%ROWTYPE IS
826: BEGIN
827: IF (p_header_id IS NULL) THEN

Line 825: RETURN oe_order_headers_all%ROWTYPE IS

821:
822: FUNCTION get_oeh_row_from_id(
823: p_header_id IN oe_order_headers_all.header_id%TYPE
824: )
825: RETURN oe_order_headers_all%ROWTYPE IS
826: BEGIN
827: IF (p_header_id IS NULL) THEN
828: RETURN NULL;
829: END IF;

Line 837: FROM oe_order_headers_all

833: END IF;
834:
835: SELECT *
836: INTO g_oeh_row
837: FROM oe_order_headers_all
838: WHERE header_id = p_header_id;
839:
840: RETURN g_oeh_row;
841: EXCEPTION