APPS.OE_CREDIT_WF dependencies on OE_HOLD_SOURCES

Line 192: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

188:
189: -- Getting the number of credit failure holds on this order
190: SELECT count(*)
191: INTO l_hold_count
192: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
193: WHERE H.HEADER_ID = l_header_id
194: -- AND H.LINE_ID IS NULL
195: AND H.HOLD_RELEASE_ID IS NULL
196: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID

Line 288: l_hold_source_rec OE_Hold_Sources_Pvt.Hold_Source_REC :=

284: l_return_status VARCHAR2(30);
285: l_msg_count NUMBER := 0;
286: l_msg_data VARCHAR2(240);
287: l_header_id NUMBER;
288: l_hold_source_rec OE_Hold_Sources_Pvt.Hold_Source_REC :=
289: OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC;
290: --
291: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
292: --

Line 289: OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC;

285: l_msg_count NUMBER := 0;
286: l_msg_data VARCHAR2(240);
287: l_header_id NUMBER;
288: l_hold_source_rec OE_Hold_Sources_Pvt.Hold_Source_REC :=
289: OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC;
290: --
291: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
292: --
293: begin

Line 425: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

421: funcmode in varchar2,
422: resultout in out nocopy varchar2)
423: is
424: --ER#7479609 l_hold_entity_id NUMBER;
425: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
426: l_hold_count NUMBER;
427: l_return_status VARCHAR2(30);
428: l_msg_count NUMBER := 0;
429: l_msg_data VARCHAR2(240);

Line 431: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC :=

427: l_return_status VARCHAR2(30);
428: l_msg_count NUMBER := 0;
429: l_msg_data VARCHAR2(240);
430: l_release_reason VARCHAR2(30);
431: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC :=
432: OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
433: Cursor blocked_process IS
434: SELECT wfas.item_type, wfas.item_key, wpa.activity_name, wfas.activity_status
435: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

Line 432: OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;

428: l_msg_count NUMBER := 0;
429: l_msg_data VARCHAR2(240);
430: l_release_reason VARCHAR2(30);
431: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC :=
432: OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
433: Cursor blocked_process IS
434: SELECT wfas.item_type, wfas.item_key, wpa.activity_name, wfas.activity_status
435: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
436: WHERE wpa.activity_name IN ('OE_CREDIT_HOLD_NTF','OE_HOLD_BLOCK','WAIT_FOR_NTF_RESULT')

Line 487: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

483: /*-------------------- Checking if the hold still exists -------------------*/
484:
485: SELECT count(*)
486: INTO l_hold_count
487: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
488: WHERE H.HEADER_ID = l_hold_entity_id
489: -- AND H.LINE_ID IS NULL
490: AND H.HOLD_RELEASE_ID IS NULL
491: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID

Line 857: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

853: l_hold_release_id NUMBER := 0; -- release ID for the last credit hold
854: CURSOR released_hold IS
855: --added for BUG#9728597 Start
856: SELECT ohr.HOLD_RELEASE_ID
857: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
858: ,oe_hold_releases ohr
859: WHERE H.HEADER_ID = header_id
860: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
861: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 872: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

868: --added for BUG#9728597 End
869:
870: --commented for BUG#9728597
871: /* SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
872: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
873: WHERE H.HEADER_ID = header_id
874: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
875: AND H.HOLD_RELEASE_ID IS NOT NULL
876: AND S.HOLD_ID = 1