APPS.OE_HOLDS_PUB dependencies on OE_HOLD_RELEASES

Line 877: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,

873: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
874: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
875: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
876: DEFAULT NULL,
877: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
878: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
879: DEFAULT NULL,
880: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
881: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 878: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

874: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
875: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
876: DEFAULT NULL,
877: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
878: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
879: DEFAULT NULL,
880: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
881: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
882: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2699: -- release record also from OE_HOLD_RELEASES;

2695: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
2696: -- order, deletes hold source records from OE_HOLD_SOURCES.
2697: -- If the hold or hold source was released and the same release record is
2698: -- not used by an existing hold or hold source, then deletes the
2699: -- release record also from OE_HOLD_RELEASES;
2700: ----------------------------------------------------------------------------
2701: PROCEDURE Delete_Holds
2702: ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
2703: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 2795: DELETE FROM OE_HOLD_RELEASES

2791:
2792: IF l_debug_level > 0 THEN
2793: oe_debug_pub.add( 'DELETING HOLD RELEASE RECORD' ) ;
2794: END IF;
2795: DELETE FROM OE_HOLD_RELEASES
2796: WHERE HOLD_RELEASE_ID = l_hold_release_id
2797: AND ORDER_HOLD_ID = l_order_hold_id;
2798:
2799: /* DELETE FROM OE_HOLD_RELEASES

Line 2799: /* DELETE FROM OE_HOLD_RELEASES

2795: DELETE FROM OE_HOLD_RELEASES
2796: WHERE HOLD_RELEASE_ID = l_hold_release_id
2797: AND 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 HOLD_RELEASE_ID NOT IN (SELECT NVL(HOLD_RELEASE_ID,0)
2802: FROM OE_ORDER_HOLDS
2803: UNION

Line 2829: DELETE FROM OE_HOLD_RELEASES

2825:
2826: IF l_debug_level > 0 THEN
2827: oe_debug_pub.add( 'DELETING HOLD RELEASE RECORD' ) ;
2828: END IF;
2829: DELETE FROM OE_HOLD_RELEASES
2830: WHERE HOLD_RELEASE_ID = l_hold_release_id;
2831:
2832: END LOOP;
2833: CLOSE hold_source;

Line 2853: DELETE FROM OE_HOLD_RELEASES

2849:
2850: DELETE FROM OE_ORDER_HOLDS
2851: WHERE order_hold_id = l_order_hold_id;
2852:
2853: DELETE FROM OE_HOLD_RELEASES
2854: WHERE HOLD_RELEASE_ID = l_hold_release_id
2855: AND ORDER_HOLD_ID = l_order_hold_id;
2856:
2857: /* AND HOLD_RELEASE_ID NOT IN

Line 2891: DELETE FROM OE_HOLD_RELEASES

2887:
2888: DELETE FROM OE_ORDER_HOLDS
2889: WHERE order_hold_id = l_order_hold_id;
2890:
2891: DELETE FROM OE_HOLD_RELEASES
2892: WHERE HOLD_RELEASE_ID = l_hold_release_id
2893: AND ORDER_HOLD_ID = l_order_hold_id;
2894: END LOOP;
2895: