APPS.OE_LINE_PAYMENT_UTIL dependencies on OE_ORDER_HOLDS

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

853: ) IS
854:
855: CURSOR line_paytype_hold IS
856: Select OH.Order_hold_id,NVL(OH.hold_release_id,0)
857: FROM OE_HOLD_SOURCES HS,OE_ORDER_HOLDS OH,OE_PAYMENTS OP
858: WHERE HS.hold_source_id=OH.hold_source_id
859: AND OH.header_id=OP.header_id
860: AND OH.line_id=OP.line_id
861: AND OP.payment_number=p_payment_number

Line 867: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;

863: OR (HS.hold_entity_code2 = 'P' AND HS.hold_entity_id2=OP.payment_type_code))
864: AND OH.header_id=p_header_id
865: AND OH.line_id=p_line_id;
866:
867: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
868: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;
869: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
870:
871: BEGIN

Line 868: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;

864: AND OH.header_id=p_header_id
865: AND OH.line_id=p_line_id;
866:
867: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
868: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;
869: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
870:
871: BEGIN
872: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 890: DELETE FROM OE_ORDER_HOLDS

886: IF l_debug_level > 0 THEN
887: oe_debug_pub.add( 'DELETING LINE PAYMENT TYPE HOLD' ) ;
888: END IF;
889:
890: DELETE FROM OE_ORDER_HOLDS
891: WHERE order_hold_id = l_order_hold_id;
892:
893: DELETE FROM OE_HOLD_RELEASES
894: WHERE HOLD_RELEASE_ID = l_hold_release_id