APPS.OE_HOLDS_PUB dependencies on OE_HOLD_RELEASES

Line 794: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,

790: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
791: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
792: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
793: DEFAULT NULL,
794: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
795: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
796: DEFAULT NULL,
797: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
798: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 795: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

791: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
792: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
793: DEFAULT NULL,
794: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
795: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
796: DEFAULT NULL,
797: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
798: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
799: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 2607: -- release record also from OE_HOLD_RELEASES;

2603: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
2604: -- order, deletes hold source records from OE_HOLD_SOURCES.
2605: -- If the hold or hold source was released and the same release record is
2606: -- not used by an existing hold or hold source, then deletes the
2607: -- release record also from OE_HOLD_RELEASES;
2608: ----------------------------------------------------------------------------
2609: PROCEDURE Delete_Holds
2610: ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
2611: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 2703: DELETE FROM OE_HOLD_RELEASES

2699:
2700: IF l_debug_level > 0 THEN
2701: oe_debug_pub.add( 'DELETING HOLD RELEASE RECORD' ) ;
2702: END IF;
2703: DELETE FROM OE_HOLD_RELEASES
2704: WHERE HOLD_RELEASE_ID = l_hold_release_id
2705: AND ORDER_HOLD_ID = l_order_hold_id;
2706:
2707: /* DELETE FROM OE_HOLD_RELEASES

Line 2707: /* DELETE FROM OE_HOLD_RELEASES

2703: DELETE FROM OE_HOLD_RELEASES
2704: WHERE HOLD_RELEASE_ID = l_hold_release_id
2705: AND ORDER_HOLD_ID = l_order_hold_id;
2706:
2707: /* DELETE FROM OE_HOLD_RELEASES
2708: WHERE HOLD_RELEASE_ID = l_hold_release_id
2709: AND HOLD_RELEASE_ID NOT IN (SELECT NVL(HOLD_RELEASE_ID,0)
2710: FROM OE_ORDER_HOLDS
2711: UNION

Line 2737: DELETE FROM OE_HOLD_RELEASES

2733:
2734: IF l_debug_level > 0 THEN
2735: oe_debug_pub.add( 'DELETING HOLD RELEASE RECORD' ) ;
2736: END IF;
2737: DELETE FROM OE_HOLD_RELEASES
2738: WHERE HOLD_RELEASE_ID = l_hold_release_id;
2739:
2740: END LOOP;
2741: CLOSE hold_source;

Line 2761: DELETE FROM OE_HOLD_RELEASES

2757:
2758: DELETE FROM OE_ORDER_HOLDS
2759: WHERE order_hold_id = l_order_hold_id;
2760:
2761: DELETE FROM OE_HOLD_RELEASES
2762: WHERE HOLD_RELEASE_ID = l_hold_release_id
2763: AND ORDER_HOLD_ID = l_order_hold_id;
2764:
2765: /* AND HOLD_RELEASE_ID NOT IN

Line 2799: DELETE FROM OE_HOLD_RELEASES

2795:
2796: DELETE FROM OE_ORDER_HOLDS
2797: WHERE order_hold_id = l_order_hold_id;
2798:
2799: DELETE FROM OE_HOLD_RELEASES
2800: WHERE HOLD_RELEASE_ID = l_hold_release_id
2801: AND ORDER_HOLD_ID = l_order_hold_id;
2802: END LOOP;
2803: