APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_HOLD_SOURCES

Line 245: OE_HOLD_SOURCES s

241: BEGIN
242: SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
243: INTO l_hold_release_id
244: FROM OE_ORDER_HOLDS h,
245: OE_HOLD_SOURCES s
246: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
247: AND H.HEADER_ID = p_header_id
248: AND H.LINE_ID IS NULL
249: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 270: OE_HOLD_SOURCES s

266: BEGIN
267: SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
268: INTO l_hold_release_id
269: FROM OE_ORDER_HOLDS h,
270: OE_HOLD_SOURCES s
271: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
272: AND H.HEADER_ID = p_header_id
273: AND H.LINE_ID = p_line_id
274: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 2159: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;

2155: IF l_debug_level > 0 THEN
2156: oe_debug_pub.add( 'OEXPVPMB: RELEASE EPAYMENT HOLDS FOR HEADER ID : ' || L_HOLD_ENTITY_ID ) ;
2157: END IF;
2158:
2159: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
2160:
2161: l_hold_id := 11 ; -- Credit Card Authorization Failure Hold
2162:
2163: -- Call Check for Hold to see if the Hold Exists

Line 2207: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;

2203: IF l_debug_level > 0 THEN
2204: oe_debug_pub.add( 'OEXPVPMB: CHECKING CREDIT CARD RISK HOLD FOR HEADER ID : ' || L_HOLD_ENTITY_ID ) ;
2205: END IF;
2206:
2207: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
2208: l_hold_id := 12 ; -- Credit Card Risk Hold
2209:
2210: -- Call Check for Hold to see if the Hold Exists
2211: IF l_debug_level > 0 THEN

Line 2302: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;

2298: IF l_debug_level > 0 THEN
2299: oe_debug_pub.add( 'OEXPVPMB: CHECKING CREDIT CHECKING HOLD FOR HEADER ID : ' || L_HOLD_ENTITY_ID ) ;
2300: END IF;
2301:
2302: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
2303: l_hold_id := 1 ; -- Credit Checking Hold
2304:
2305: -- Call Check for Hold to see if the Hold Exists
2306: IF l_debug_level > 0 THEN

Line 7728: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;

7724: IF l_debug_level > 0 THEN
7725: oe_debug_pub.add( 'OEXPVPMB: RELEASE EPAYMENT HOLDS FOR LINE ID : ' || p_line_id ) ;
7726: END IF;
7727:
7728: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
7729:
7730: l_hold_id := 11 ; -- Credit Card Authorization Failure Hold
7731:
7732: -- Call Check for Hold to see if the Hold Exists

Line 7786: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;

7782: IF l_debug_level > 0 THEN
7783: oe_debug_pub.add( 'OEXPVPMB: CHECKING CREDIT CARD RISK HOLD FOR LINE ID : ' || p_line_id ) ;
7784: END IF;
7785:
7786: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
7787: l_hold_id := 12 ; -- Credit Card Risk Hold
7788:
7789: -- Call Check for Hold to see if the Hold Exists
7790: IF l_debug_level > 0 THEN