APPS.OE_CREDIT_WF dependencies on OE_HOLD_SOURCES

Line 186: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

182:
183: -- Getting the number of credit failure holds on this order
184: SELECT count(*)
185: INTO l_hold_count
186: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
187: WHERE H.HEADER_ID = l_header_id
188: -- AND H.LINE_ID IS NULL
189: AND H.HOLD_RELEASE_ID IS NULL
190: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID

Line 282: l_hold_source_rec OE_Hold_Sources_Pvt.Hold_Source_REC :=

278: l_return_status VARCHAR2(30);
279: l_msg_count NUMBER := 0;
280: l_msg_data VARCHAR2(240);
281: l_header_id NUMBER;
282: l_hold_source_rec OE_Hold_Sources_Pvt.Hold_Source_REC :=
283: OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC;
284: --
285: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
286: --

Line 283: OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC;

279: l_msg_count NUMBER := 0;
280: l_msg_data VARCHAR2(240);
281: l_header_id NUMBER;
282: l_hold_source_rec OE_Hold_Sources_Pvt.Hold_Source_REC :=
283: OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC;
284: --
285: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
286: --
287: begin

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

415: funcmode in varchar2,
416: resultout in out nocopy varchar2)
417: is
418: --ER#7479609 l_hold_entity_id NUMBER;
419: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
420: l_hold_count NUMBER;
421: l_return_status VARCHAR2(30);
422: l_msg_count NUMBER := 0;
423: l_msg_data VARCHAR2(240);

Line 425: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC :=

421: l_return_status VARCHAR2(30);
422: l_msg_count NUMBER := 0;
423: l_msg_data VARCHAR2(240);
424: l_release_reason VARCHAR2(30);
425: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC :=
426: OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
427: Cursor blocked_process IS
428: SELECT wfas.item_type, wfas.item_key, wpa.activity_name, wfas.activity_status
429: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

Line 426: OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;

422: l_msg_count NUMBER := 0;
423: l_msg_data VARCHAR2(240);
424: l_release_reason VARCHAR2(30);
425: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC :=
426: OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
427: Cursor blocked_process IS
428: SELECT wfas.item_type, wfas.item_key, wpa.activity_name, wfas.activity_status
429: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
430: WHERE wpa.activity_name IN ('OE_CREDIT_HOLD_NTF','OE_HOLD_BLOCK','WAIT_FOR_NTF_RESULT')

Line 481: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

477: /*-------------------- Checking if the hold still exists -------------------*/
478:
479: SELECT count(*)
480: INTO l_hold_count
481: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
482: WHERE H.HEADER_ID = l_hold_entity_id
483: -- AND H.LINE_ID IS NULL
484: AND H.HOLD_RELEASE_ID IS NULL
485: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID

Line 850: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

846: l_manual_release NUMBER := 0; -- no. of times credit hold was manually released
847: l_hold_release_id NUMBER := 0; -- release ID for the last credit hold
848: CURSOR released_hold IS
849: SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
850: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
851: WHERE H.HEADER_ID = header_id
852: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
853: AND H.HOLD_RELEASE_ID IS NOT NULL
854: AND S.HOLD_ID = 1