APPS.JTF_MSITE_GRP_W SQL Statements

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

Line: 200

  procedure rosetta_table_copy_in_p10(t out jtf_msite_grp.msite_delete_tbl_type, a0 JTF_NUMBER_TABLE
    , a1 JTF_NUMBER_TABLE
    ) as
    ddindx binary_integer; indx binary_integer;

Line: 221

  procedure rosetta_table_copy_out_p10(t jtf_msite_grp.msite_delete_tbl_type, a0 out JTF_NUMBER_TABLE
    , a1 out JTF_NUMBER_TABLE
    ) as
    ddindx binary_integer; indx binary_integer;

Line: 291

  procedure delete_msite(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , x_return_status out  VARCHAR2
    , x_msg_count out  NUMBER
    , x_msg_data out  VARCHAR2
    , p6_a0 JTF_NUMBER_TABLE
    , p6_a1 JTF_NUMBER_TABLE
  )
  as
    ddp_msite_id_tbl jtf_msite_grp.msite_delete_tbl_type;

Line: 317

    jtf_msite_grp.delete_msite(p_api_version,
      p_init_msg_list,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_msite_id_tbl);

Line: 575

  procedure insert_row(x_rowid in out  VARCHAR2
    , x_msite_id  NUMBER
    , x_attribute_category  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_attribute11  VARCHAR2
    , x_attribute10  VARCHAR2
    , x_attribute12  VARCHAR2
    , x_attribute13  VARCHAR2
    , x_attribute14  VARCHAR2
    , x_attribute15  VARCHAR2
    , x_security_group_id  NUMBER
    , x_object_version_number  NUMBER
    , x_store_id  NUMBER
    , x_start_date_active  date
    , x_end_date_active  date
    , x_default_language_code  VARCHAR2
    , x_default_currency_code  VARCHAR2
    , x_default_date_format  VARCHAR2
    , x_default_org_id  NUMBER
    , x_atp_check_flag  VARCHAR2
    , x_walkin_allowed_flag  VARCHAR2
    , x_msite_root_section_id  NUMBER
    , x_profile_id  NUMBER
    , x_master_msite_flag  VARCHAR2
    , x_msite_name  VARCHAR2
    , x_msite_description  VARCHAR2
    , x_creation_date  date
    , x_created_by  NUMBER
    , x_last_update_date  date
    , x_last_updated_by  NUMBER
    , x_last_update_login  NUMBER
    , x_resp_access_flag  VARCHAR2
    , x_party_access_code  VARCHAR2
    , x_access_name  VARCHAR2
    , x_url  VARCHAR2
    , x_theme_id  NUMBER
  )
  as
    ddx_start_date_active date;

Line: 624

    ddx_last_update_date date;

Line: 668

    ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);

Line: 678

    jtf_msite_grp.insert_row(x_rowid,
      x_msite_id,
      x_attribute_category,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute11,
      x_attribute10,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_security_group_id,
      x_object_version_number,
      x_store_id,
      ddx_start_date_active,
      ddx_end_date_active,
      x_default_language_code,
      x_default_currency_code,
      x_default_date_format,
      x_default_org_id,
      x_atp_check_flag,
      x_walkin_allowed_flag,
      x_msite_root_section_id,
      x_profile_id,
      x_master_msite_flag,
      x_msite_name,
      x_msite_description,
      ddx_creation_date,
      x_created_by,
      ddx_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_resp_access_flag,
      x_party_access_code,
      x_access_name,
      x_url,
      x_theme_id);

Line: 935

  procedure update_row(x_msite_id  NUMBER
    , x_attribute_category  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_attribute11  VARCHAR2
    , x_attribute10  VARCHAR2
    , x_attribute12  VARCHAR2
    , x_attribute13  VARCHAR2
    , x_attribute14  VARCHAR2
    , x_attribute15  VARCHAR2
    , x_security_group_id  NUMBER
    , x_object_version_number  NUMBER
    , x_store_id  NUMBER
    , x_start_date_active  date
    , x_end_date_active  date
    , x_default_language_code  VARCHAR2
    , x_default_currency_code  VARCHAR2
    , x_default_date_format  VARCHAR2
    , x_default_org_id  NUMBER
    , x_atp_check_flag  VARCHAR2
    , x_walkin_allowed_flag  VARCHAR2
    , x_msite_root_section_id  NUMBER
    , x_profile_id  NUMBER
    , x_master_msite_flag  VARCHAR2
    , x_msite_name  VARCHAR2
    , x_msite_description  VARCHAR2
    , x_last_update_date  date
    , x_last_updated_by  NUMBER
    , x_last_update_login  NUMBER
    , x_resp_access_flag  VARCHAR2
    , x_party_access_code  VARCHAR2
    , x_access_name  VARCHAR2
    , x_url  VARCHAR2
    , x_theme_id  NUMBER
  )
  as
    ddx_start_date_active date;

Line: 980

    ddx_last_update_date date;

Line: 1020

    ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);

Line: 1030

    jtf_msite_grp.update_row(x_msite_id,
      x_attribute_category,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute11,
      x_attribute10,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_security_group_id,
      x_object_version_number,
      x_store_id,
      ddx_start_date_active,
      ddx_end_date_active,
      x_default_language_code,
      x_default_currency_code,
      x_default_date_format,
      x_default_org_id,
      x_atp_check_flag,
      x_walkin_allowed_flag,
      x_msite_root_section_id,
      x_profile_id,
      x_master_msite_flag,
      x_msite_name,
      x_msite_description,
      ddx_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_resp_access_flag,
      x_party_access_code,
      x_access_name,
      x_url,
      x_theme_id);