APPS.OE_HEADER_PAYMENT_UTIL dependencies on OE_ORDER_HOLDS

Line 842: FROM OE_HOLD_SOURCES HS,OE_ORDER_HOLDS OH,OE_PAYMENTS OP

838: ) IS
839:
840: CURSOR order_paytype_hold IS
841: Select OH.Order_hold_id,NVL(OH.hold_release_id,0)
842: FROM OE_HOLD_SOURCES HS,OE_ORDER_HOLDS OH,OE_PAYMENTS OP
843: WHERE HS.hold_source_id=OH.hold_source_id
844: AND OH.header_id=OP.header_id
845: AND OP.payment_number=p_payment_number
846: AND ((HS.hold_entity_code= 'P' AND HS.hold_entity_id=OP.payment_type_code)

Line 852: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;

848: AND OH.header_id=p_header_id
849: AND OH.line_id IS NULL
850: AND OP.line_id IS NULL;
851:
852: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
853: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;
854: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
855:
856: BEGIN

Line 853: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;

849: AND OH.line_id IS NULL
850: AND OP.line_id IS NULL;
851:
852: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
853: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;
854: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
855:
856: BEGIN
857: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 875: DELETE FROM OE_ORDER_HOLDS

871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add( 'DELETING HEADER PAYMENT TYPE HOLD' ) ;
873: END IF;
874:
875: DELETE FROM OE_ORDER_HOLDS
876: WHERE order_hold_id = l_order_hold_id;
877:
878: DELETE FROM OE_HOLD_RELEASES
879: WHERE HOLD_RELEASE_ID = l_hold_release_id