APPS.CS_WORKFLOW_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

	SELECT
		it.business_process_id,
		sr.customer_id,
		sr.record_is_valid_flag record_valid,
--		act.action_effective_date effective_date,
--		act.expected_resolution_date resolution_date,
--		act.action_assignee_id assignee_id,
--		act.dispatcher_orig_syst_id employee_id,
--		act.dispatcher_orig_syst dis_orig_syst,
		it.workflow wf_name,
		(
		hl.address1 || hl.address2 || hl.address3
		) install_address
  	FROM
		CS_INCIDENTS_V sr,
--		CS_INCIDENT_ACTIONS_V act,
  		CS_INCIDENT_TYPES_VL it,
                HZ_PARTY_SITES hps,
                HZ_LOCATIONS hl
  	WHERE   it.incident_type_id = sr.incident_type_id
  		AND   sr.incident_id = fs_request_id
--  		AND   act.incident_id = fs_request_id
--  		AND   act.action_num = fs_action_num
                AND   sr.customer_id = hps.party_id
                AND   hps.party_site_id = hl.location_id;

Line: 101

      Select item_type
      from cs_incidents_all_b inc, cs_incident_types types, wf_activities wf
      where inc.incident_number= p_request_number
      and types.incident_type_id=inc.incident_type_id
      and wf.name=types.workflow;

Line: 108

      SELECT end_date
      FROM   wf_items
--      WHERE  item_type = 'SERVEREQ'  --Commented for Bug 6449697
      WHERE  item_type = l_item_type
      AND    item_key  = l_itemkey;

Line: 160

    SELECT display_name INTO l_display_name
      FROM WF_RUNNABLE_PROCESSES_V
     WHERE item_type = p_item_type
       AND process_name = p_process_name;

Line: 351

    SELECT end_date
    FROM   wf_items
    WHERE  item_type = 'SRACTION'
    AND    item_key  = l_itemkey;

Line: 579

        SELECT nvl(status.close_flag,'N') close_flag,
                inc.workflow_process_id,
                cit.AUTOLAUNCH_WORKFLOW_FLAG,
                cit.WORKFLOW,
                inc.resource_type,
                inc.incident_owner_id,
                inc.incident_id,
                inc.object_version_number
        FROM   cs_incident_statuses status,
                cs_incidents_all_b inc,
                cs_incident_types cit
        WHERE  inc.incident_number = p_request_number
               AND inc.incident_status_id = status.incident_status_id
               and cit.incident_type_id = inc.incident_type_id;

Line: 605

      CS_WF_AUTO_NTFY_UPDATE_PKG.get_fnd_user_role
           ( p_fnd_user_id        => p_initiator_user_id,
             x_role_name          => l_initiator_role,
             x_role_display_name  => l_dummy );

Line: 651

    SELECT cs_wf_process_id_s.nextval
    INTO l_event_id
    FROM dual;

Line: 662

    wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.updated',
                   p_event_key  => l_event_key,
                   p_parameters => l_param_list);

Line: 677

      UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = l_event_id
      WHERE INCIDENT_ID = l_sel_request_rec.incident_id;