The following lines contain the word 'select', 'insert', 'update' or 'delete':
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a1(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a2(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a5(indx));
a1(indx) := t(ddindx).last_update_date;
a2(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a5(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
ddp_access_profile_rec.mgr_update_profile_value := p4_a3;
ddp_access_profile_rec.admin_update_profile_value := p4_a4;
ddp_sales_team_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a1);
ddp_sales_team_rec.last_updated_by := rosetta_g_miss_num_map(p9_a2);
ddp_sales_team_rec.last_update_login := rosetta_g_miss_num_map(p9_a5);
procedure update_salesteam(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_validation_level NUMBER
, p_check_access_flag VARCHAR2
, p_admin_flag VARCHAR2
, p_admin_group_id NUMBER
, p_identity_salesforce_id NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_access_id out nocopy NUMBER
, p4_a0 VARCHAR2 := fnd_api.g_miss_char
, p4_a1 VARCHAR2 := fnd_api.g_miss_char
, p4_a2 VARCHAR2 := fnd_api.g_miss_char
, p4_a3 VARCHAR2 := fnd_api.g_miss_char
, p4_a4 VARCHAR2 := fnd_api.g_miss_char
, p9_a0 NUMBER := 0-1962.0724
, p9_a1 DATE := fnd_api.g_miss_date
, p9_a2 NUMBER := 0-1962.0724
, p9_a3 DATE := fnd_api.g_miss_date
, p9_a4 NUMBER := 0-1962.0724
, p9_a5 NUMBER := 0-1962.0724
, p9_a6 VARCHAR2 := fnd_api.g_miss_char
, p9_a7 VARCHAR2 := fnd_api.g_miss_char
, p9_a8 VARCHAR2 := fnd_api.g_miss_char
, p9_a9 NUMBER := 0-1962.0724
, p9_a10 NUMBER := 0-1962.0724
, p9_a11 NUMBER := 0-1962.0724
, p9_a12 NUMBER := 0-1962.0724
, p9_a13 VARCHAR2 := fnd_api.g_miss_char
, p9_a14 VARCHAR2 := fnd_api.g_miss_char
, p9_a15 VARCHAR2 := fnd_api.g_miss_char
, p9_a16 VARCHAR2 := fnd_api.g_miss_char
, p9_a17 VARCHAR2 := fnd_api.g_miss_char
, p9_a18 NUMBER := 0-1962.0724
, p9_a19 VARCHAR2 := fnd_api.g_miss_char
, p9_a20 NUMBER := 0-1962.0724
, p9_a21 NUMBER := 0-1962.0724
, p9_a22 VARCHAR2 := fnd_api.g_miss_char
, p9_a23 VARCHAR2 := fnd_api.g_miss_char
, p9_a24 VARCHAR2 := fnd_api.g_miss_char
, p9_a25 VARCHAR2 := fnd_api.g_miss_char
, p9_a26 VARCHAR2 := fnd_api.g_miss_char
, p9_a27 VARCHAR2 := fnd_api.g_miss_char
, p9_a28 NUMBER := 0-1962.0724
, p9_a29 NUMBER := 0-1962.0724
, p9_a30 DATE := fnd_api.g_miss_date
, p9_a31 VARCHAR2 := fnd_api.g_miss_char
, p9_a32 DATE := fnd_api.g_miss_date
, p9_a33 NUMBER := 0-1962.0724
, p9_a34 VARCHAR2 := fnd_api.g_miss_char
, p9_a35 VARCHAR2 := fnd_api.g_miss_char
, p9_a36 VARCHAR2 := fnd_api.g_miss_char
, p9_a37 VARCHAR2 := fnd_api.g_miss_char
, p9_a38 VARCHAR2 := fnd_api.g_miss_char
, p9_a39 VARCHAR2 := fnd_api.g_miss_char
, p9_a40 VARCHAR2 := fnd_api.g_miss_char
, p9_a41 VARCHAR2 := fnd_api.g_miss_char
, p9_a42 VARCHAR2 := fnd_api.g_miss_char
, p9_a43 VARCHAR2 := fnd_api.g_miss_char
, p9_a44 VARCHAR2 := fnd_api.g_miss_char
, p9_a45 VARCHAR2 := fnd_api.g_miss_char
, p9_a46 VARCHAR2 := fnd_api.g_miss_char
, p9_a47 VARCHAR2 := fnd_api.g_miss_char
, p9_a48 VARCHAR2 := fnd_api.g_miss_char
, p9_a49 VARCHAR2 := fnd_api.g_miss_char
, p9_a50 VARCHAR2 := fnd_api.g_miss_char
, p9_a51 VARCHAR2 := fnd_api.g_miss_char
, p9_a52 VARCHAR2 := fnd_api.g_miss_char
, p9_a53 VARCHAR2 := fnd_api.g_miss_char
, p9_a54 NUMBER := 0-1962.0724
, p9_a55 NUMBER := 0-1962.0724
, p9_a56 VARCHAR2 := fnd_api.g_miss_char
, p9_a57 VARCHAR2 := fnd_api.g_miss_char
, p9_a58 VARCHAR2 := fnd_api.g_miss_char
, p9_a59 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_access_profile_rec as_access_pub.access_profile_rec_type;
ddp_access_profile_rec.mgr_update_profile_value := p4_a3;
ddp_access_profile_rec.admin_update_profile_value := p4_a4;
ddp_sales_team_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a1);
ddp_sales_team_rec.last_updated_by := rosetta_g_miss_num_map(p9_a2);
ddp_sales_team_rec.last_update_login := rosetta_g_miss_num_map(p9_a5);
as_access_pub.update_salesteam(p_api_version_number,
p_init_msg_list,
p_commit,
p_validation_level,
ddp_access_profile_rec,
p_check_access_flag,
p_admin_flag,
p_admin_group_id,
p_identity_salesforce_id,
ddp_sales_team_rec,
x_return_status,
x_msg_count,
x_msg_data,
x_access_id);
procedure delete_salesteam(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_validation_level NUMBER
, p_check_access_flag VARCHAR2
, p_admin_flag VARCHAR2
, p_admin_group_id NUMBER
, p_identity_salesforce_id NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p4_a0 VARCHAR2 := fnd_api.g_miss_char
, p4_a1 VARCHAR2 := fnd_api.g_miss_char
, p4_a2 VARCHAR2 := fnd_api.g_miss_char
, p4_a3 VARCHAR2 := fnd_api.g_miss_char
, p4_a4 VARCHAR2 := fnd_api.g_miss_char
, p9_a0 NUMBER := 0-1962.0724
, p9_a1 DATE := fnd_api.g_miss_date
, p9_a2 NUMBER := 0-1962.0724
, p9_a3 DATE := fnd_api.g_miss_date
, p9_a4 NUMBER := 0-1962.0724
, p9_a5 NUMBER := 0-1962.0724
, p9_a6 VARCHAR2 := fnd_api.g_miss_char
, p9_a7 VARCHAR2 := fnd_api.g_miss_char
, p9_a8 VARCHAR2 := fnd_api.g_miss_char
, p9_a9 NUMBER := 0-1962.0724
, p9_a10 NUMBER := 0-1962.0724
, p9_a11 NUMBER := 0-1962.0724
, p9_a12 NUMBER := 0-1962.0724
, p9_a13 VARCHAR2 := fnd_api.g_miss_char
, p9_a14 VARCHAR2 := fnd_api.g_miss_char
, p9_a15 VARCHAR2 := fnd_api.g_miss_char
, p9_a16 VARCHAR2 := fnd_api.g_miss_char
, p9_a17 VARCHAR2 := fnd_api.g_miss_char
, p9_a18 NUMBER := 0-1962.0724
, p9_a19 VARCHAR2 := fnd_api.g_miss_char
, p9_a20 NUMBER := 0-1962.0724
, p9_a21 NUMBER := 0-1962.0724
, p9_a22 VARCHAR2 := fnd_api.g_miss_char
, p9_a23 VARCHAR2 := fnd_api.g_miss_char
, p9_a24 VARCHAR2 := fnd_api.g_miss_char
, p9_a25 VARCHAR2 := fnd_api.g_miss_char
, p9_a26 VARCHAR2 := fnd_api.g_miss_char
, p9_a27 VARCHAR2 := fnd_api.g_miss_char
, p9_a28 NUMBER := 0-1962.0724
, p9_a29 NUMBER := 0-1962.0724
, p9_a30 DATE := fnd_api.g_miss_date
, p9_a31 VARCHAR2 := fnd_api.g_miss_char
, p9_a32 DATE := fnd_api.g_miss_date
, p9_a33 NUMBER := 0-1962.0724
, p9_a34 VARCHAR2 := fnd_api.g_miss_char
, p9_a35 VARCHAR2 := fnd_api.g_miss_char
, p9_a36 VARCHAR2 := fnd_api.g_miss_char
, p9_a37 VARCHAR2 := fnd_api.g_miss_char
, p9_a38 VARCHAR2 := fnd_api.g_miss_char
, p9_a39 VARCHAR2 := fnd_api.g_miss_char
, p9_a40 VARCHAR2 := fnd_api.g_miss_char
, p9_a41 VARCHAR2 := fnd_api.g_miss_char
, p9_a42 VARCHAR2 := fnd_api.g_miss_char
, p9_a43 VARCHAR2 := fnd_api.g_miss_char
, p9_a44 VARCHAR2 := fnd_api.g_miss_char
, p9_a45 VARCHAR2 := fnd_api.g_miss_char
, p9_a46 VARCHAR2 := fnd_api.g_miss_char
, p9_a47 VARCHAR2 := fnd_api.g_miss_char
, p9_a48 VARCHAR2 := fnd_api.g_miss_char
, p9_a49 VARCHAR2 := fnd_api.g_miss_char
, p9_a50 VARCHAR2 := fnd_api.g_miss_char
, p9_a51 VARCHAR2 := fnd_api.g_miss_char
, p9_a52 VARCHAR2 := fnd_api.g_miss_char
, p9_a53 VARCHAR2 := fnd_api.g_miss_char
, p9_a54 NUMBER := 0-1962.0724
, p9_a55 NUMBER := 0-1962.0724
, p9_a56 VARCHAR2 := fnd_api.g_miss_char
, p9_a57 VARCHAR2 := fnd_api.g_miss_char
, p9_a58 VARCHAR2 := fnd_api.g_miss_char
, p9_a59 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_access_profile_rec as_access_pub.access_profile_rec_type;
ddp_access_profile_rec.mgr_update_profile_value := p4_a3;
ddp_access_profile_rec.admin_update_profile_value := p4_a4;
ddp_sales_team_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a1);
ddp_sales_team_rec.last_updated_by := rosetta_g_miss_num_map(p9_a2);
ddp_sales_team_rec.last_update_login := rosetta_g_miss_num_map(p9_a5);
as_access_pub.delete_salesteam(p_api_version_number,
p_init_msg_list,
p_commit,
p_validation_level,
ddp_access_profile_rec,
p_check_access_flag,
p_admin_flag,
p_admin_group_id,
p_identity_salesforce_id,
ddp_sales_team_rec,
x_return_status,
x_msg_count,
x_msg_data);
ddp_access_profile_rec.mgr_update_profile_value := p1_a3;
ddp_access_profile_rec.admin_update_profile_value := p1_a4;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
procedure has_updatecustomeraccess(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_validation_level NUMBER
, p_admin_flag VARCHAR2
, p_admin_group_id NUMBER
, p_person_id NUMBER
, p_customer_id NUMBER
, p_check_access_flag VARCHAR2
, p_identity_salesforce_id NUMBER
, p_partner_cont_party_id NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_update_access_flag out nocopy VARCHAR2
, p3_a0 VARCHAR2 := fnd_api.g_miss_char
, p3_a1 VARCHAR2 := fnd_api.g_miss_char
, p3_a2 VARCHAR2 := fnd_api.g_miss_char
, p3_a3 VARCHAR2 := fnd_api.g_miss_char
, p3_a4 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_access_profile_rec as_access_pub.access_profile_rec_type;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
as_access_pub.has_updatecustomeraccess(p_api_version_number,
p_init_msg_list,
p_validation_level,
ddp_access_profile_rec,
p_admin_flag,
p_admin_group_id,
p_person_id,
p_customer_id,
p_check_access_flag,
p_identity_salesforce_id,
p_partner_cont_party_id,
x_return_status,
x_msg_count,
x_msg_data,
x_update_access_flag);
procedure has_updateleadaccess(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_validation_level NUMBER
, p_admin_flag VARCHAR2
, p_admin_group_id NUMBER
, p_person_id NUMBER
, p_sales_lead_id NUMBER
, p_check_access_flag VARCHAR2
, p_identity_salesforce_id NUMBER
, p_partner_cont_party_id NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_update_access_flag out nocopy VARCHAR2
, p3_a0 VARCHAR2 := fnd_api.g_miss_char
, p3_a1 VARCHAR2 := fnd_api.g_miss_char
, p3_a2 VARCHAR2 := fnd_api.g_miss_char
, p3_a3 VARCHAR2 := fnd_api.g_miss_char
, p3_a4 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_access_profile_rec as_access_pub.access_profile_rec_type;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
as_access_pub.has_updateleadaccess(p_api_version_number,
p_init_msg_list,
p_validation_level,
ddp_access_profile_rec,
p_admin_flag,
p_admin_group_id,
p_person_id,
p_sales_lead_id,
p_check_access_flag,
p_identity_salesforce_id,
p_partner_cont_party_id,
x_return_status,
x_msg_count,
x_msg_data,
x_update_access_flag);
procedure has_updateopportunityaccess(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_validation_level NUMBER
, p_admin_flag VARCHAR2
, p_admin_group_id NUMBER
, p_person_id NUMBER
, p_opportunity_id NUMBER
, p_check_access_flag VARCHAR2
, p_identity_salesforce_id NUMBER
, p_partner_cont_party_id NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_update_access_flag out nocopy VARCHAR2
, p3_a0 VARCHAR2 := fnd_api.g_miss_char
, p3_a1 VARCHAR2 := fnd_api.g_miss_char
, p3_a2 VARCHAR2 := fnd_api.g_miss_char
, p3_a3 VARCHAR2 := fnd_api.g_miss_char
, p3_a4 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_access_profile_rec as_access_pub.access_profile_rec_type;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
as_access_pub.has_updateopportunityaccess(p_api_version_number,
p_init_msg_list,
p_validation_level,
ddp_access_profile_rec,
p_admin_flag,
p_admin_group_id,
p_person_id,
p_opportunity_id,
p_check_access_flag,
p_identity_salesforce_id,
p_partner_cont_party_id,
x_return_status,
x_msg_count,
x_msg_data,
x_update_access_flag);
procedure has_updatepersonaccess(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_validation_level NUMBER
, p_admin_flag VARCHAR2
, p_admin_group_id NUMBER
, p_person_id NUMBER
, p_security_id NUMBER
, p_security_type VARCHAR2
, p_person_party_id NUMBER
, p_check_access_flag VARCHAR2
, p_identity_salesforce_id NUMBER
, p_partner_cont_party_id NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_update_access_flag out nocopy VARCHAR2
, p3_a0 VARCHAR2 := fnd_api.g_miss_char
, p3_a1 VARCHAR2 := fnd_api.g_miss_char
, p3_a2 VARCHAR2 := fnd_api.g_miss_char
, p3_a3 VARCHAR2 := fnd_api.g_miss_char
, p3_a4 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_access_profile_rec as_access_pub.access_profile_rec_type;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
as_access_pub.has_updatepersonaccess(p_api_version_number,
p_init_msg_list,
p_validation_level,
ddp_access_profile_rec,
p_admin_flag,
p_admin_group_id,
p_person_id,
p_security_id,
p_security_type,
p_person_party_id,
p_check_access_flag,
p_identity_salesforce_id,
p_partner_cont_party_id,
x_return_status,
x_msg_count,
x_msg_data,
x_update_access_flag);
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;
ddp_access_profile_rec.mgr_update_profile_value := p3_a3;
ddp_access_profile_rec.admin_update_profile_value := p3_a4;