APPS.OE_CREDIT_WF dependencies on OE_HOLD_SOURCES_PVT

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 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')