APPS.OE_NEGOTIATE_WF dependencies on WF_PROCESS_ACTIVITIES

Line 784: from wf_item_activity_statuses wias, wf_process_activities wpa

780:
781: BEGIN
782: select wpa.activity_name
783: into l_activity_name
784: from wf_item_activity_statuses wias, wf_process_activities wpa
785: where item_type = OE_GLOBALS.G_WFI_NGO
786: and item_key = to_char(p_header_id)
787: and activity_status = wf_engine.eng_notified
788: and wpa.activity_name in ('SUBMIT_DRAFT_ELIGIBLE', 'NEGOTIATION_COMPLETE_ELIGIBLE')

Line 907: from wf_item_activity_statuses wias, wf_process_activities wpa

903:
904: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
905: select wpa.activity_name
906: into l_activity_name
907: from wf_item_activity_statuses wias, wf_process_activities wpa
908: where item_type = OE_GLOBALS.G_WFI_NGO
909: and item_key = to_char(p_header_id)
910: and activity_status = wf_engine.eng_notified
911: and wpa.activity_name = l_customer_acceptance

Line 1012: from wf_item_activity_statuses wias, wf_process_activities wpa

1008:
1009: BEGIN
1010: select wpa.activity_name
1011: into l_activity_name
1012: from wf_item_activity_statuses wias, wf_process_activities wpa
1013: where item_type = OE_GLOBALS.G_WFI_NGO
1014: and item_key = to_char(p_header_id)
1015: and activity_status = wf_engine.eng_notified
1016: and wpa.activity_name = l_customer_acceptance

Line 1095: from wf_item_activity_statuses wias, wf_process_activities wpa

1091:
1092: BEGIN
1093: select wpa.activity_name
1094: into l_activity_name
1095: from wf_item_activity_statuses wias, wf_process_activities wpa
1096: where item_type = OE_GLOBALS.G_WFI_NGO
1097: and item_key = to_char(p_header_id)
1098: and activity_status = wf_engine.eng_notified
1099: and wpa.activity_name in ('WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION')

Line 1223: from wf_item_activity_statuses wias, wf_process_activities wpa

1219: ,p_source_document_type_id => null);
1220:
1221: select wpa.activity_name
1222: into l_activity_name
1223: from wf_item_activity_statuses wias, wf_process_activities wpa
1224: where item_type = OE_GLOBALS.G_WFI_NGO
1225: and item_key = to_char(p_header_id)
1226: and activity_status = wf_engine.eng_notified
1227: and wpa.activity_name = l_submit_draft_eligible

Line 1465: from wf_item_activity_statuses wias, wf_process_activities wpa

1461: END IF;
1462:
1463: select wpa.activity_name
1464: into l_activity_name
1465: from wf_item_activity_statuses wias, wf_process_activities wpa
1466: where item_type = OE_GLOBALS.G_WFI_NGO
1467: and item_key = to_char(p_header_id)
1468: and activity_status = wf_engine.eng_notified
1469: and wpa.activity_name = l_customer_acceptance