APPS.OE_BLANKET_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 315: FROM wf_item_activity_statuses

311: -- if viewing method is through URL
312: -- fix bug 1332384
313: SELECT item_key
314: INTO l_header_id
315: FROM wf_item_activity_statuses
316: where notification_id = to_number(document_id);
317: EXCEPTION
318: WHEN NO_DATA_FOUND THEN
319: -- if viewing method is email

Line 363: FROM wf_item_activity_statuses

359: -- if viewing method is through URL
360: -- fix bug 1332384
361: SELECT item_key
362: INTO l_header_id
363: FROM wf_item_activity_statuses
364: where notification_id = to_number(document_id);
365: EXCEPTION
366: WHEN NO_DATA_FOUND THEN
367: -- if viewing method is email

Line 607: from wf_item_activity_statuses wias, wf_process_activities wpa

603:
604: BEGIN
605: select wpa.activity_name
606: into l_activity_name
607: from wf_item_activity_statuses wias, wf_process_activities wpa
608: where item_type = OE_GLOBALS.G_WFI_BKT
609: and item_key = to_char(p_header_id)
610: and activity_status = 'NOTIFIED'
611: and wpa.activity_name in ('WAIT_FOR_START_DATE', 'BLANKET_NO_END_DATE', 'WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION', 'BLANKET_SUBMIT_DRAFT_ELIGIBLE')

Line 672: from wf_item_activity_statuses wias, wf_process_activities wpa

668: END IF;
669: BEGIN
670: select wpa.activity_name
671: into l_activity_name
672: from wf_item_activity_statuses wias, wf_process_activities wpa
673: where item_type = OE_GLOBALS.G_WFI_BKT
674: and item_key = to_char(p_header_id)
675: and activity_status = 'NOTIFIED'
676: and wpa.activity_name = 'BLANKET_SUBMIT_DRAFT_ELIGIBLE'

Line 736: from wf_item_activity_statuses wias, wf_process_activities wpa

732: END IF;
733: BEGIN
734: select wpa.activity_name
735: into l_activity_name
736: from wf_item_activity_statuses wias, wf_process_activities wpa
737: where item_type = OE_GLOBALS.G_WFI_BKT
738: and item_key = to_char(p_header_id)
739: and activity_status = 'NOTIFIED'
740: and wpa.activity_name = 'CLOSE_BLANKET_ELIGIBLE'

Line 813: from wf_item_activity_statuses wias, wf_process_activities wpa

809: END IF;
810: BEGIN
811: select wpa.activity_name
812: into l_activity_name
813: from wf_item_activity_statuses wias, wf_process_activities wpa
814: where item_type = OE_GLOBALS.G_WFI_BKT
815: and item_key = to_char(p_header_id)
816: and activity_status = 'NOTIFIED'
817: and wpa.activity_name in ('WAIT_FOR_START_DATE', 'BLANKET_NO_END_DATE', 'WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION')

Line 916: from wf_item_activity_statuses wias, wf_process_activities wpa

912: END IF;
913: BEGIN
914: select wpa.activity_name
915: into l_activity_name
916: from wf_item_activity_statuses wias, wf_process_activities wpa
917: where item_type = OE_GLOBALS.G_WFI_BKT
918: and item_key = to_char(p_header_id)
919: and activity_status = 'NOTIFIED'
920: and wpa.activity_name = 'CLOSE_BLANKET_ELIGIBLE'