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 709: p_order_number oe_order_headers_all.order_number%TYPE,

705: /*******/
706: /* oeh */
707: /*******/
708: FUNCTION get_oeh_row_from_num(
709: p_order_number oe_order_headers_all.order_number%TYPE,
710: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
711: p_version_number oe_order_headers_all.version_number%TYPE,
712: p_org_id oe_order_headers_all.org_id%TYPE
713: )

Line 710: p_order_type_id oe_order_headers_all.order_type_id%TYPE,

706: /* oeh */
707: /*******/
708: FUNCTION get_oeh_row_from_num(
709: p_order_number oe_order_headers_all.order_number%TYPE,
710: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
711: p_version_number oe_order_headers_all.version_number%TYPE,
712: p_org_id oe_order_headers_all.org_id%TYPE
713: )
714: RETURN oe_order_headers_all%ROWTYPE IS

Line 711: p_version_number oe_order_headers_all.version_number%TYPE,

707: /*******/
708: FUNCTION get_oeh_row_from_num(
709: p_order_number oe_order_headers_all.order_number%TYPE,
710: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
711: p_version_number oe_order_headers_all.version_number%TYPE,
712: p_org_id oe_order_headers_all.org_id%TYPE
713: )
714: RETURN oe_order_headers_all%ROWTYPE IS
715: BEGIN

Line 712: p_org_id oe_order_headers_all.org_id%TYPE

708: FUNCTION get_oeh_row_from_num(
709: p_order_number oe_order_headers_all.order_number%TYPE,
710: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
711: p_version_number oe_order_headers_all.version_number%TYPE,
712: p_org_id oe_order_headers_all.org_id%TYPE
713: )
714: RETURN oe_order_headers_all%ROWTYPE IS
715: BEGIN
716: IF (p_order_number IS NULL) THEN

Line 714: RETURN oe_order_headers_all%ROWTYPE IS

710: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
711: p_version_number oe_order_headers_all.version_number%TYPE,
712: p_org_id oe_order_headers_all.org_id%TYPE
713: )
714: RETURN oe_order_headers_all%ROWTYPE IS
715: BEGIN
716: IF (p_order_number IS NULL) THEN
717: RETURN NULL;
718: END IF;

Line 733: FROM oe_order_headers_all

729: /* WDK: NOTE - THIS QUERY IS NOT UNIQUE!!! REQUIRES ORDER_TYPE_ID and VERSION_NUMBER.
730: WE CAN FIX ONLY IF WE ADD THESE COLUMNS */
731: SELECT *
732: INTO g_oeh_row
733: FROM oe_order_headers_all
734: WHERE header_id IN(SELECT header_id
735: FROM oe_order_headers
736: WHERE order_number = p_order_number
737: AND order_type_id = NVL(p_order_type_id, order_type_id)

Line 749: FROM oe_order_headers_all

745: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
746: BEGIN
747: SELECT *
748: INTO g_oeh_row
749: FROM oe_order_headers_all
750: WHERE order_number = p_order_number
751: AND order_type_id = NVL(p_order_type_id, order_type_id)
752: AND version_number = NVL(p_version_number, version_number)
753: AND org_id = NVL(p_org_id, org_id)

Line 773: FROM oe_order_headers_all

769: IF (g_default_org_id IS NOT NULL) THEN
770: BEGIN
771: SELECT *
772: INTO g_oeh_row
773: FROM oe_order_headers_all
774: WHERE order_number = p_order_number
775: AND order_type_id = NVL(p_order_type_id, order_type_id)
776: AND version_number = NVL(p_version_number, version_number)
777: AND org_id = g_default_org_id

Line 796: p_header_id IN oe_order_headers_all.header_id%TYPE

792: RETURN NULL;
793: END get_oeh_row_from_num;
794:
795: FUNCTION get_oeh_row_from_id(
796: p_header_id IN oe_order_headers_all.header_id%TYPE
797: )
798: RETURN oe_order_headers_all%ROWTYPE IS
799: BEGIN
800: IF (p_header_id IS NULL) THEN

Line 798: RETURN oe_order_headers_all%ROWTYPE IS

794:
795: FUNCTION get_oeh_row_from_id(
796: p_header_id IN oe_order_headers_all.header_id%TYPE
797: )
798: RETURN oe_order_headers_all%ROWTYPE IS
799: BEGIN
800: IF (p_header_id IS NULL) THEN
801: RETURN NULL;
802: END IF;

Line 810: FROM oe_order_headers_all

806: END IF;
807:
808: SELECT *
809: INTO g_oeh_row
810: FROM oe_order_headers_all
811: WHERE header_id = p_header_id;
812:
813: RETURN g_oeh_row;
814: EXCEPTION