APPS.OE_NEGOTIATE_WF dependencies on WF_PROCESS_ACTIVITIES

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