APPS.CUG_SR_TYPE_ATTR_MAPS_PKG_W SQL Statements

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

Line: 13

  procedure insert_row(x_rowid in out nocopy  VARCHAR2
    , x_sr_type_attr_map_id  NUMBER
    , x_sr_type_attr_seq_num  NUMBER
    , x_object_version_number  NUMBER
    , x_incident_type_id  NUMBER
    , x_sr_attribute_code  VARCHAR2
    , x_sr_attr_mandatory_flag  VARCHAR2
    , x_sr_attr_displayed_flag  VARCHAR2
    , x_sr_attr_dup_check_flag  VARCHAR2
    , x_sr_attribute_list_name  VARCHAR2
    , x_attribute1  VARCHAR2
    , x_attribute2  VARCHAR2
    , x_attribute3  VARCHAR2
    , x_attribute4  VARCHAR2
    , x_attribute5  VARCHAR2
    , x_attribute6  VARCHAR2
    , x_attribute7  VARCHAR2
    , x_attribute8  VARCHAR2
    , x_attribute9  VARCHAR2
    , x_attribute10  VARCHAR2
    , x_attribute11  VARCHAR2
    , x_attribute12  VARCHAR2
    , x_attribute13  VARCHAR2
    , x_attribute14  VARCHAR2
    , x_attribute15  VARCHAR2
    , x_attribute_category  VARCHAR2
    , x_start_date_active  date
    , x_end_date_active  date
    , x_security_group_id  NUMBER
    , x_template_id  NUMBER
    , x_reqd_for_close_flag  VARCHAR2
    , x_show_on_update_flag  VARCHAR2
    , x_update_allowed_flag  VARCHAR2
    , x_sr_attr_default_value  VARCHAR2
    , x_creation_date  date
    , x_created_by  NUMBER
    , x_last_update_date  date
    , x_last_updated_by  NUMBER
    , x_last_update_login  NUMBER
  )

  as
    ddx_start_date_active date;

Line: 58

    ddx_last_update_date date;

Line: 102

    ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);

Line: 107

    cug_sr_type_attr_maps_pkg.insert_row(x_rowid,
      x_sr_type_attr_map_id,
      x_sr_type_attr_seq_num,
      x_object_version_number,
      x_incident_type_id,
      x_sr_attribute_code,
      x_sr_attr_mandatory_flag,
      x_sr_attr_displayed_flag,
      x_sr_attr_dup_check_flag,
      x_sr_attribute_list_name,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute10,
      x_attribute11,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_attribute_category,
      ddx_start_date_active,
      ddx_end_date_active,
      x_security_group_id,
      x_template_id,
      x_reqd_for_close_flag,
      x_show_on_update_flag,
      x_update_allowed_flag,
      x_sr_attr_default_value,
      ddx_creation_date,
      x_created_by,
      ddx_last_update_date,
      x_last_updated_by,
      x_last_update_login);

Line: 218

    , x_show_on_update_flag  VARCHAR2
    , x_update_allowed_flag  VARCHAR2
    , x_sr_attr_default_value  VARCHAR2
  )

  as
    ddx_start_date_active date;

Line: 296

      x_show_on_update_flag,
      x_update_allowed_flag,
      x_sr_attr_default_value);

Line: 335

  procedure update_row(x_sr_type_attr_map_id  NUMBER
    , x_sr_type_attr_seq_num  NUMBER
    , x_object_version_number  NUMBER
    , x_incident_type_id  NUMBER
    , x_sr_attribute_code  VARCHAR2
    , x_sr_attr_mandatory_flag  VARCHAR2
    , x_sr_attr_displayed_flag  VARCHAR2
    , x_sr_attr_dup_check_flag  VARCHAR2
    , x_sr_attribute_list_name  VARCHAR2
    , x_attribute1  VARCHAR2
    , x_attribute2  VARCHAR2
    , x_attribute3  VARCHAR2
    , x_attribute4  VARCHAR2
    , x_attribute5  VARCHAR2
    , x_attribute6  VARCHAR2
    , x_attribute7  VARCHAR2
    , x_attribute8  VARCHAR2
    , x_attribute9  VARCHAR2
    , x_attribute10  VARCHAR2
    , x_attribute11  VARCHAR2
    , x_attribute12  VARCHAR2
    , x_attribute13  VARCHAR2
    , x_attribute14  VARCHAR2
    , x_attribute15  VARCHAR2
    , x_attribute_category  VARCHAR2
    , x_start_date_active  date
    , x_end_date_active  date
    , x_security_group_id  NUMBER
    , x_template_id  NUMBER
    , x_reqd_for_close_flag  VARCHAR2
    , x_show_on_update_flag  VARCHAR2
    , x_update_allowed_flag  VARCHAR2
    , x_sr_attr_default_value  VARCHAR2
    , x_last_update_date  date
    , x_last_updated_by  NUMBER
    , x_last_update_login  NUMBER
  )

  as
    ddx_start_date_active date;

Line: 376

    ddx_last_update_date date;

Line: 416

    ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);

Line: 421

    cug_sr_type_attr_maps_pkg.update_row(x_sr_type_attr_map_id,
      x_sr_type_attr_seq_num,
      x_object_version_number,
      x_incident_type_id,
      x_sr_attribute_code,
      x_sr_attr_mandatory_flag,
      x_sr_attr_displayed_flag,
      x_sr_attr_dup_check_flag,
      x_sr_attribute_list_name,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute10,
      x_attribute11,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_attribute_category,
      ddx_start_date_active,
      ddx_end_date_active,
      x_security_group_id,
      x_template_id,
      x_reqd_for_close_flag,
      x_show_on_update_flag,
      x_update_allowed_flag,
      x_sr_attr_default_value,
      ddx_last_update_date,
      x_last_updated_by,
      x_last_update_login);

Line: 508

    , x_show_on_update_flag  VARCHAR2
    , x_update_allowed_flag  VARCHAR2
    , x_sr_type_attr_seq_num  NUMBER
    , x_security_group_id  NUMBER
    , x_creation_date  VARCHAR2
    , x_created_by  NUMBER
    , x_last_update_date  VARCHAR2
    , x_last_updated_by  NUMBER
    , x_last_update_login  NUMBER
    , x_owner  VARCHAR2
  )

  as
    ddx_start_date_active date;

Line: 564

      x_show_on_update_flag,
      x_update_allowed_flag,
      x_sr_type_attr_seq_num,
      x_security_group_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_owner);