APPS.CS_SERVICEREQUEST_PVT dependencies on CS_WF_PROCESS_ID_S

Line 2822: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;

2818: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'PROBLEM_CODE', l_service_request_rec.problem_code, 'W', 'T');
2819: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'EXPECTED_RESOLUTION_DATE', l_service_request_rec.exp_resolution_date, 'W', 'T');
2820:
2821: -- Before the call to WorkFlow Hook, generate a unique item key using the workflow sequence
2822: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;
2823:
2824: JTF_USR_HKS.WrkflowLaunch(p_wf_item_name => 'SERVEREQ',
2825: p_wf_item_process_name => 'CALL_SUPPORT',
2826: p_wf_item_key => 'SR' || TO_CHAR(l_workflow_item_key),

Line 5640: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;

5636: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'EXPECTED_RESOLUTION_DATE', l_service_request_rec.exp_resolution_date, 'W', 'T');
5637:
5638:
5639: -- Before the call to WorkFlow Hook, generate a unique item key using the workflow sequence
5640: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;
5641:
5642: JTF_USR_HKS.WrkflowLaunch(p_wf_item_name => 'SERVEREQ',
5643: p_wf_item_process_name => 'CALL_SUPPORT',
5644: p_wf_item_key => 'SR' || TO_CHAR(l_workflow_item_key),