APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_HOLD_SOURCES

Line 239: OE_HOLD_SOURCES s,

235: --added for BUG#9728597 Start
236: cursor released_hold is
237: SELECT ohr.HOLD_RELEASE_ID
238: FROM OE_ORDER_HOLDS h,
239: OE_HOLD_SOURCES s,
240: oe_hold_releases ohr
241: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
242: AND H.HEADER_ID = p_header_id
243: AND H.LINE_ID IS NULL

Line 255: OE_HOLD_SOURCES s,

251:
252: cursor released_hold_line is
253: SELECT ohr.HOLD_RELEASE_ID
254: FROM OE_ORDER_HOLDS h,
255: OE_HOLD_SOURCES s,
256: oe_hold_releases ohr
257: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
258: AND H.HEADER_ID = p_header_id
259: AND H.LINE_ID = p_line_id

Line 280: OE_HOLD_SOURCES s

276: --commented for BUG#9728597 Start
277: /*SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
278: INTO l_hold_release_id
279: FROM OE_ORDER_HOLDS h,
280: OE_HOLD_SOURCES s
281: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
282: AND H.HEADER_ID = p_header_id
283: AND H.LINE_ID IS NULL
284: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 321: OE_HOLD_SOURCES s

317: --commented for BUG#9728597 Start
318: /*SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
319: INTO l_hold_release_id
320: FROM OE_ORDER_HOLDS h,
321: OE_HOLD_SOURCES s
322: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
323: AND H.HEADER_ID = p_header_id
324: AND H.LINE_ID = p_line_id
325: AND H.HOLD_RELEASE_ID IS NOT NULL

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

2228: IF l_debug_level > 0 THEN
2229: oe_debug_pub.add( 'OEXPVPMB: RELEASE EPAYMENT HOLDS FOR HEADER ID : ' || L_HOLD_ENTITY_ID ) ;
2230: END IF;
2231:
2232: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
2233:
2234: l_hold_id := 11 ; -- Credit Card Authorization Failure Hold
2235:
2236: -- Call Check for Hold to see if the Hold Exists

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

2276: IF l_debug_level > 0 THEN
2277: oe_debug_pub.add( 'OEXPVPMB: CHECKING CREDIT CARD RISK HOLD FOR HEADER ID : ' || L_HOLD_ENTITY_ID ) ;
2278: END IF;
2279:
2280: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
2281: l_hold_id := 12 ; -- Credit Card Risk Hold
2282:
2283: -- Call Check for Hold to see if the Hold Exists
2284: IF l_debug_level > 0 THEN

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

2371: IF l_debug_level > 0 THEN
2372: oe_debug_pub.add( 'OEXPVPMB: CHECKING CREDIT CHECKING HOLD FOR HEADER ID : ' || L_HOLD_ENTITY_ID ) ;
2373: END IF;
2374:
2375: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
2376: l_hold_id := 1 ; -- Credit Checking Hold
2377:
2378: -- Call Check for Hold to see if the Hold Exists
2379: IF l_debug_level > 0 THEN

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

8368: IF l_debug_level > 0 THEN
8369: oe_debug_pub.add( 'OEXPVPMB: RELEASE EPAYMENT HOLDS FOR LINE ID : ' || p_line_id ) ;
8370: END IF;
8371:
8372: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
8373:
8374: l_hold_id := 11 ; -- Credit Card Authorization Failure Hold
8375:
8376: -- Call Check for Hold to see if the Hold Exists

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

8426: IF l_debug_level > 0 THEN
8427: oe_debug_pub.add( 'OEXPVPMB: CHECKING CREDIT CARD RISK HOLD FOR LINE ID : ' || p_line_id ) ;
8428: END IF;
8429:
8430: -- l_hold_release_rec := OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
8431: l_hold_id := 12 ; -- Credit Card Risk Hold
8432:
8433: -- Call Check for Hold to see if the Hold Exists
8434: IF l_debug_level > 0 THEN