APPS.CS_SERVICEREQUEST_PVT dependencies on CS_WF_PROCESS_ID_S

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

3158: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'PROBLEM_CODE', l_service_request_rec.problem_code, 'W', 'T');
3159: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'EXPECTED_RESOLUTION_DATE', l_service_request_rec.exp_resolution_date, 'W', 'T');
3160:
3161: -- Before the call to WorkFlow Hook, generate a unique item key using the workflow sequence
3162: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;
3163:
3164: JTF_USR_HKS.WrkflowLaunch(p_wf_item_name => 'SERVEREQ',
3165: p_wf_item_process_name => 'CALL_SUPPORT',
3166: p_wf_item_key => 'SR' || TO_CHAR(l_workflow_item_key),

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

6317: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'EXPECTED_RESOLUTION_DATE', l_service_request_rec.exp_resolution_date, 'W', 'T');
6318:
6319:
6320: -- Before the call to WorkFlow Hook, generate a unique item key using the workflow sequence
6321: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;
6322:
6323: JTF_USR_HKS.WrkflowLaunch(p_wf_item_name => 'SERVEREQ',
6324: p_wf_item_process_name => 'CALL_SUPPORT',
6325: p_wf_item_key => 'SR' || TO_CHAR(l_workflow_item_key),