APPS.OE_CREDIT_WF dependencies on OE_HOLD_SOURCES_PVT

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