APPS.OE_NEGOTIATE_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 702: FROM wf_item_activity_statuses

698: -- if viewing method is through URL
699: -- fix bug 1332384
700: SELECT item_key, item_type
701: INTO l_item_key, l_item_type --l_header_id AME ER
702: FROM wf_item_activity_statuses
703: WHERE notification_id = TO_NUMBER (document_id);
704: IF l_debug_level > 0 THEN
705: oe_debug_pub.ADD ('item key selected is:' || l_item_key);
706: END IF ;

Line 714: FROM wf_item_activity_statuses_h

710: /* 9047023: Check details in wf history tables */
711: BEGIN
712: SELECT item_key, item_type
713: INTO l_item_key, l_item_type -- l_header_id AME ER
714: FROM wf_item_activity_statuses_h
715: WHERE notification_id = TO_NUMBER (document_id);
716: EXCEPTION
717: WHEN NO_DATA_FOUND
718: THEN

Line 839: from wf_item_activity_statuses wias, wf_process_activities wpa

835:
836: BEGIN
837: select wpa.activity_name
838: into l_activity_name
839: from wf_item_activity_statuses wias, wf_process_activities wpa
840: where item_type = OE_GLOBALS.G_WFI_NGO
841: and item_key = to_char(p_header_id)
842: and activity_status = wf_engine.eng_notified
843: and wpa.activity_name in ('SUBMIT_DRAFT_ELIGIBLE', 'NEGOTIATION_COMPLETE_ELIGIBLE')

Line 962: from wf_item_activity_statuses wias, wf_process_activities wpa

958:
959: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
960: select wpa.activity_name
961: into l_activity_name
962: from wf_item_activity_statuses wias, wf_process_activities wpa
963: where item_type = OE_GLOBALS.G_WFI_NGO
964: and item_key = to_char(p_header_id)
965: and activity_status = wf_engine.eng_notified
966: and wpa.activity_name = l_customer_acceptance

Line 1067: from wf_item_activity_statuses wias, wf_process_activities wpa

1063:
1064: BEGIN
1065: select wpa.activity_name
1066: into l_activity_name
1067: from wf_item_activity_statuses wias, wf_process_activities wpa
1068: where item_type = OE_GLOBALS.G_WFI_NGO
1069: and item_key = to_char(p_header_id)
1070: and activity_status = wf_engine.eng_notified
1071: and wpa.activity_name = l_customer_acceptance

Line 1150: from wf_item_activity_statuses wias, wf_process_activities wpa

1146:
1147: BEGIN
1148: select wpa.activity_name
1149: into l_activity_name
1150: from wf_item_activity_statuses wias, wf_process_activities wpa
1151: where item_type = OE_GLOBALS.G_WFI_NGO
1152: and item_key = to_char(p_header_id)
1153: and activity_status = wf_engine.eng_notified
1154: and wpa.activity_name in ('WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION')

Line 1278: from wf_item_activity_statuses wias, wf_process_activities wpa

1274: ,p_source_document_type_id => null);
1275:
1276: select wpa.activity_name
1277: into l_activity_name
1278: from wf_item_activity_statuses wias, wf_process_activities wpa
1279: where item_type = OE_GLOBALS.G_WFI_NGO
1280: and item_key = to_char(p_header_id)
1281: and activity_status = wf_engine.eng_notified
1282: and wpa.activity_name = l_submit_draft_eligible

Line 1532: from wf_item_activity_statuses wias, wf_process_activities wpa

1528: END IF;
1529:
1530: select wpa.activity_name
1531: into l_activity_name
1532: from wf_item_activity_statuses wias, wf_process_activities wpa
1533: where item_type = OE_GLOBALS.G_WFI_NGO
1534: and item_key = to_char(p_header_id)
1535: and activity_status = wf_engine.eng_notified
1536: and wpa.activity_name = l_customer_acceptance