The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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;
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);
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;
ddx_last_update_date date;
ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);
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);
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;
ddx_last_update_date date;
ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);
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);