APPS.CSFW_SERVICEREQUEST_PUB_W SQL Statements

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

Line: 3

  procedure update_request_resolution(p_incident_id  NUMBER
    , p_resolution_code  VARCHAR2
    , p_resolution_summary  VARCHAR2
    , p_problem_code  VARCHAR2
    , p_cust_po_number  VARCHAR2
    , p_commit  number
    , p_init_msg_list  number
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  INTEGER
    , x_msg_data out nocopy  VARCHAR2
    , p_object_version_number  NUMBER
    , p_incident_severity_id   NUMBER default null -- For enhancement in FSTP 12.1.3 Project
  )

  as
    ddp_commit boolean;

Line: 48

    csfw_servicerequest_pub.update_request_resolution(p_incident_id,
      p_resolution_code,
      p_resolution_summary,
      p_problem_code,
      p_cust_po_number,
      ddp_commit,
      ddp_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_object_version_number,
      p_incident_severity_id );