APPS.JTF_RS_RES_SSWA_PUB_W SQL Statements

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

Line: 148

  procedure update_resource(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_resource_id  NUMBER
    , p_resource_number  VARCHAR2
    , p_resource_name  VARCHAR2
    , p_source_name  VARCHAR2
    , p_address_id  VARCHAR2
    , p_source_office  VARCHAR2
    , p_source_mailstop  VARCHAR2
    , p_source_location  VARCHAR2
    , p_source_phone  VARCHAR2
    , p_source_email  VARCHAR2
    , p_object_version_number  NUMBER
    , p_approved  VARCHAR2
    , p_source_job_id  NUMBER
    , p_source_job_title  VARCHAR2
    , p_salesrep_number  VARCHAR2
    , p_sales_credit_type_id  NUMBER
    , p_end_date_active  date
    , p_user_id  NUMBER
    , p_user_name  VARCHAR2
    , p_mgr_resource_id  NUMBER
    , p_org_id  NUMBER
    , x_return_status out NOCOPY  VARCHAR2
    , x_msg_count out NOCOPY  NUMBER
    , x_msg_data out NOCOPY  VARCHAR2
    , p_time_zone  NUMBER
    , p_cost_per_hr  NUMBER
    , p_primary_language  VARCHAR2
    , p_secondary_language  VARCHAR2
    , p_support_site_id  NUMBER
    , p_source_mobile_phone  VARCHAR2
    , p_source_pager  VARCHAR2
  )
  as
    ddp_end_date_active date;

Line: 225

    jtf_rs_res_sswa_pub.update_resource(p_api_version,
      p_init_msg_list,
      p_commit,
      p_resource_id,
      p_resource_number,
      p_resource_name,
      p_source_name,
      p_address_id,
      p_source_office,
      p_source_mailstop,
      p_source_location,
      p_source_phone,
      p_source_email,
      p_object_version_number,
      p_approved,
      p_source_job_id,
      p_source_job_title,
      p_salesrep_number,
      p_sales_credit_type_id,
      ddp_end_date_active,
      p_user_id,
      p_user_name,
      p_mgr_resource_id,
      p_org_id,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_time_zone,
      p_cost_per_hr,
      p_primary_language,
      p_secondary_language,
      p_support_site_id,
      p_source_mobile_phone,
      p_source_pager);