The following lines contain the word 'select', 'insert', 'update' or 'delete':
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
t(ddindx).updateable_flag := a54(indx);
t(ddindx).deleted_flag := a60(indx);
t(ddindx).delete_allowed_flag := a75(indx);
a0(indx) := t(ddindx).last_update_date;
a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
a8(indx) := t(ddindx).program_update_date;
a54(indx) := t(ddindx).updateable_flag;
a60(indx) := t(ddindx).deleted_flag;
a75(indx) := t(ddindx).delete_allowed_flag;
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
a0(indx) := t(ddindx).last_update_date;
a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
a8(indx) := t(ddindx).program_update_date;
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
t(ddindx).delete_flag := a34(indx);
a0(indx) := t(ddindx).last_update_date;
a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
a8(indx) := t(ddindx).program_update_date;
a34(indx) := t(ddindx).delete_flag;
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
a0(indx) := t(ddindx).last_update_date;
a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
a8(indx) := t(ddindx).program_update_date;
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
a0(indx) := t(ddindx).last_update_date;
a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
a8(indx) := t(ddindx).program_update_date;
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
a0(indx) := t(ddindx).last_update_date;
a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
a8(indx) := t(ddindx).program_update_date;
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
a0(indx) := t(ddindx).last_update_date;
a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
a8(indx) := t(ddindx).program_update_date;
t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a17(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a25(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a26(indx));
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a27(indx));
a17(indx) := t(ddindx).program_update_date;
a25(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
a26(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a27(indx) := t(ddindx).last_update_date;
t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a16(indx));
t(ddindx).last_updated_by := rosetta_g_miss_num_map(a26(indx));
t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a27(indx));
t(ddindx).last_update_login := rosetta_g_miss_num_map(a28(indx));
a16(indx) := t(ddindx).program_update_date;
a26(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
a27(indx) := t(ddindx).last_update_date;
a28(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a0);
ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p4_a1);
ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p4_a4);
ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p4_a8);
ddp_header_rec.updateable_flag := p4_a54;
ddp_header_rec.deleted_flag := p4_a60;
ddp_header_rec.delete_allowed_flag := p4_a75;
procedure update_opp_header(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
, p_partner_cont_party_id NUMBER
, p10_a0 JTF_VARCHAR2_TABLE_100
, p10_a1 JTF_VARCHAR2_TABLE_300
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_lead_id out nocopy NUMBER
, p4_a0 DATE := fnd_api.g_miss_date
, p4_a1 NUMBER := 0-1962.0724
, p4_a2 DATE := fnd_api.g_miss_date
, p4_a3 NUMBER := 0-1962.0724
, p4_a4 NUMBER := 0-1962.0724
, p4_a5 NUMBER := 0-1962.0724
, p4_a6 NUMBER := 0-1962.0724
, p4_a7 NUMBER := 0-1962.0724
, p4_a8 DATE := fnd_api.g_miss_date
, p4_a9 NUMBER := 0-1962.0724
, p4_a10 VARCHAR2 := fnd_api.g_miss_char
, p4_a11 VARCHAR2 := fnd_api.g_miss_char
, p4_a12 VARCHAR2 := fnd_api.g_miss_char
, p4_a13 VARCHAR2 := fnd_api.g_miss_char
, p4_a14 VARCHAR2 := fnd_api.g_miss_char
, p4_a15 NUMBER := 0-1962.0724
, p4_a16 VARCHAR2 := fnd_api.g_miss_char
, p4_a17 NUMBER := 0-1962.0724
, p4_a18 VARCHAR2 := fnd_api.g_miss_char
, p4_a19 VARCHAR2 := fnd_api.g_miss_char
, p4_a20 NUMBER := 0-1962.0724
, p4_a21 VARCHAR2 := fnd_api.g_miss_char
, p4_a22 VARCHAR2 := fnd_api.g_miss_char
, p4_a23 VARCHAR2 := fnd_api.g_miss_char
, p4_a24 VARCHAR2 := fnd_api.g_miss_char
, p4_a25 VARCHAR2 := fnd_api.g_miss_char
, p4_a26 VARCHAR2 := fnd_api.g_miss_char
, p4_a27 VARCHAR2 := fnd_api.g_miss_char
, p4_a28 VARCHAR2 := fnd_api.g_miss_char
, p4_a29 NUMBER := 0-1962.0724
, p4_a30 VARCHAR2 := fnd_api.g_miss_char
, p4_a31 NUMBER := 0-1962.0724
, p4_a32 VARCHAR2 := fnd_api.g_miss_char
, p4_a33 VARCHAR2 := fnd_api.g_miss_char
, p4_a34 NUMBER := 0-1962.0724
, p4_a35 NUMBER := 0-1962.0724
, p4_a36 VARCHAR2 := fnd_api.g_miss_char
, p4_a37 VARCHAR2 := fnd_api.g_miss_char
, p4_a38 DATE := fnd_api.g_miss_date
, p4_a39 VARCHAR2 := fnd_api.g_miss_char
, p4_a40 VARCHAR2 := fnd_api.g_miss_char
, p4_a41 VARCHAR2 := fnd_api.g_miss_char
, p4_a42 VARCHAR2 := fnd_api.g_miss_char
, p4_a43 VARCHAR2 := fnd_api.g_miss_char
, p4_a44 NUMBER := 0-1962.0724
, p4_a45 VARCHAR2 := fnd_api.g_miss_char
, p4_a46 VARCHAR2 := fnd_api.g_miss_char
, p4_a47 NUMBER := 0-1962.0724
, p4_a48 VARCHAR2 := fnd_api.g_miss_char
, p4_a49 NUMBER := 0-1962.0724
, p4_a50 NUMBER := 0-1962.0724
, p4_a51 NUMBER := 0-1962.0724
, p4_a52 VARCHAR2 := fnd_api.g_miss_char
, p4_a53 VARCHAR2 := fnd_api.g_miss_char
, p4_a54 VARCHAR2 := fnd_api.g_miss_char
, p4_a55 NUMBER := 0-1962.0724
, p4_a56 NUMBER := 0-1962.0724
, p4_a57 VARCHAR2 := fnd_api.g_miss_char
, p4_a58 VARCHAR2 := fnd_api.g_miss_char
, p4_a59 VARCHAR2 := fnd_api.g_miss_char
, p4_a60 VARCHAR2 := fnd_api.g_miss_char
, p4_a61 VARCHAR2 := fnd_api.g_miss_char
, p4_a62 VARCHAR2 := fnd_api.g_miss_char
, p4_a63 NUMBER := 0-1962.0724
, p4_a64 VARCHAR2 := fnd_api.g_miss_char
, p4_a65 NUMBER := 0-1962.0724
, p4_a66 NUMBER := 0-1962.0724
, p4_a67 VARCHAR2 := fnd_api.g_miss_char
, p4_a68 NUMBER := 0-1962.0724
, p4_a69 NUMBER := 0-1962.0724
, p4_a70 NUMBER := 0-1962.0724
, p4_a71 VARCHAR2 := fnd_api.g_miss_char
, p4_a72 VARCHAR2 := fnd_api.g_miss_char
, p4_a73 DATE := fnd_api.g_miss_date
, p4_a74 VARCHAR2 := fnd_api.g_miss_char
, p4_a75 VARCHAR2 := fnd_api.g_miss_char
, p4_a76 VARCHAR2 := fnd_api.g_miss_char
, p4_a77 VARCHAR2 := fnd_api.g_miss_char
, p4_a78 VARCHAR2 := fnd_api.g_miss_char
, p4_a79 VARCHAR2 := fnd_api.g_miss_char
, p4_a80 NUMBER := 0-1962.0724
, p4_a81 VARCHAR2 := fnd_api.g_miss_char
, p4_a82 VARCHAR2 := fnd_api.g_miss_char
, p4_a83 VARCHAR2 := fnd_api.g_miss_char
, p4_a84 VARCHAR2 := fnd_api.g_miss_char
, p4_a85 VARCHAR2 := fnd_api.g_miss_char
, p4_a86 VARCHAR2 := fnd_api.g_miss_char
, p4_a87 VARCHAR2 := fnd_api.g_miss_char
, p4_a88 VARCHAR2 := fnd_api.g_miss_char
, p4_a89 VARCHAR2 := fnd_api.g_miss_char
, p4_a90 VARCHAR2 := fnd_api.g_miss_char
, p4_a91 VARCHAR2 := fnd_api.g_miss_char
, p4_a92 VARCHAR2 := fnd_api.g_miss_char
, p4_a93 VARCHAR2 := fnd_api.g_miss_char
, p4_a94 VARCHAR2 := fnd_api.g_miss_char
, p4_a95 VARCHAR2 := fnd_api.g_miss_char
, p4_a96 VARCHAR2 := fnd_api.g_miss_char
, p4_a97 VARCHAR2 := fnd_api.g_miss_char
, p4_a98 VARCHAR2 := fnd_api.g_miss_char
, p4_a99 NUMBER := 0-1962.0724
)
as
ddp_header_rec as_opportunity_pub.header_rec_type;
ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a0);
ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p4_a1);
ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p4_a4);
ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p4_a8);
ddp_header_rec.updateable_flag := p4_a54;
ddp_header_rec.deleted_flag := p4_a60;
ddp_header_rec.delete_allowed_flag := p4_a75;
as_opportunity_pub.update_opp_header(p_api_version_number,
p_init_msg_list,
p_commit,
p_validation_level,
ddp_header_rec,
p_check_access_flag,
p_admin_flag,
p_admin_group_id,
p_identity_salesforce_id,
p_partner_cont_party_id,
ddp_profile_tbl,
x_return_status,
x_msg_count,
x_msg_data,
x_lead_id);
procedure delete_opp_header(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
, p_partner_cont_party_id NUMBER
, p10_a0 JTF_VARCHAR2_TABLE_100
, p10_a1 JTF_VARCHAR2_TABLE_300
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_lead_id out nocopy NUMBER
, p4_a0 DATE := fnd_api.g_miss_date
, p4_a1 NUMBER := 0-1962.0724
, p4_a2 DATE := fnd_api.g_miss_date
, p4_a3 NUMBER := 0-1962.0724
, p4_a4 NUMBER := 0-1962.0724
, p4_a5 NUMBER := 0-1962.0724
, p4_a6 NUMBER := 0-1962.0724
, p4_a7 NUMBER := 0-1962.0724
, p4_a8 DATE := fnd_api.g_miss_date
, p4_a9 NUMBER := 0-1962.0724
, p4_a10 VARCHAR2 := fnd_api.g_miss_char
, p4_a11 VARCHAR2 := fnd_api.g_miss_char
, p4_a12 VARCHAR2 := fnd_api.g_miss_char
, p4_a13 VARCHAR2 := fnd_api.g_miss_char
, p4_a14 VARCHAR2 := fnd_api.g_miss_char
, p4_a15 NUMBER := 0-1962.0724
, p4_a16 VARCHAR2 := fnd_api.g_miss_char
, p4_a17 NUMBER := 0-1962.0724
, p4_a18 VARCHAR2 := fnd_api.g_miss_char
, p4_a19 VARCHAR2 := fnd_api.g_miss_char
, p4_a20 NUMBER := 0-1962.0724
, p4_a21 VARCHAR2 := fnd_api.g_miss_char
, p4_a22 VARCHAR2 := fnd_api.g_miss_char
, p4_a23 VARCHAR2 := fnd_api.g_miss_char
, p4_a24 VARCHAR2 := fnd_api.g_miss_char
, p4_a25 VARCHAR2 := fnd_api.g_miss_char
, p4_a26 VARCHAR2 := fnd_api.g_miss_char
, p4_a27 VARCHAR2 := fnd_api.g_miss_char
, p4_a28 VARCHAR2 := fnd_api.g_miss_char
, p4_a29 NUMBER := 0-1962.0724
, p4_a30 VARCHAR2 := fnd_api.g_miss_char
, p4_a31 NUMBER := 0-1962.0724
, p4_a32 VARCHAR2 := fnd_api.g_miss_char
, p4_a33 VARCHAR2 := fnd_api.g_miss_char
, p4_a34 NUMBER := 0-1962.0724
, p4_a35 NUMBER := 0-1962.0724
, p4_a36 VARCHAR2 := fnd_api.g_miss_char
, p4_a37 VARCHAR2 := fnd_api.g_miss_char
, p4_a38 DATE := fnd_api.g_miss_date
, p4_a39 VARCHAR2 := fnd_api.g_miss_char
, p4_a40 VARCHAR2 := fnd_api.g_miss_char
, p4_a41 VARCHAR2 := fnd_api.g_miss_char
, p4_a42 VARCHAR2 := fnd_api.g_miss_char
, p4_a43 VARCHAR2 := fnd_api.g_miss_char
, p4_a44 NUMBER := 0-1962.0724
, p4_a45 VARCHAR2 := fnd_api.g_miss_char
, p4_a46 VARCHAR2 := fnd_api.g_miss_char
, p4_a47 NUMBER := 0-1962.0724
, p4_a48 VARCHAR2 := fnd_api.g_miss_char
, p4_a49 NUMBER := 0-1962.0724
, p4_a50 NUMBER := 0-1962.0724
, p4_a51 NUMBER := 0-1962.0724
, p4_a52 VARCHAR2 := fnd_api.g_miss_char
, p4_a53 VARCHAR2 := fnd_api.g_miss_char
, p4_a54 VARCHAR2 := fnd_api.g_miss_char
, p4_a55 NUMBER := 0-1962.0724
, p4_a56 NUMBER := 0-1962.0724
, p4_a57 VARCHAR2 := fnd_api.g_miss_char
, p4_a58 VARCHAR2 := fnd_api.g_miss_char
, p4_a59 VARCHAR2 := fnd_api.g_miss_char
, p4_a60 VARCHAR2 := fnd_api.g_miss_char
, p4_a61 VARCHAR2 := fnd_api.g_miss_char
, p4_a62 VARCHAR2 := fnd_api.g_miss_char
, p4_a63 NUMBER := 0-1962.0724
, p4_a64 VARCHAR2 := fnd_api.g_miss_char
, p4_a65 NUMBER := 0-1962.0724
, p4_a66 NUMBER := 0-1962.0724
, p4_a67 VARCHAR2 := fnd_api.g_miss_char
, p4_a68 NUMBER := 0-1962.0724
, p4_a69 NUMBER := 0-1962.0724
, p4_a70 NUMBER := 0-1962.0724
, p4_a71 VARCHAR2 := fnd_api.g_miss_char
, p4_a72 VARCHAR2 := fnd_api.g_miss_char
, p4_a73 DATE := fnd_api.g_miss_date
, p4_a74 VARCHAR2 := fnd_api.g_miss_char
, p4_a75 VARCHAR2 := fnd_api.g_miss_char
, p4_a76 VARCHAR2 := fnd_api.g_miss_char
, p4_a77 VARCHAR2 := fnd_api.g_miss_char
, p4_a78 VARCHAR2 := fnd_api.g_miss_char
, p4_a79 VARCHAR2 := fnd_api.g_miss_char
, p4_a80 NUMBER := 0-1962.0724
, p4_a81 VARCHAR2 := fnd_api.g_miss_char
, p4_a82 VARCHAR2 := fnd_api.g_miss_char
, p4_a83 VARCHAR2 := fnd_api.g_miss_char
, p4_a84 VARCHAR2 := fnd_api.g_miss_char
, p4_a85 VARCHAR2 := fnd_api.g_miss_char
, p4_a86 VARCHAR2 := fnd_api.g_miss_char
, p4_a87 VARCHAR2 := fnd_api.g_miss_char
, p4_a88 VARCHAR2 := fnd_api.g_miss_char
, p4_a89 VARCHAR2 := fnd_api.g_miss_char
, p4_a90 VARCHAR2 := fnd_api.g_miss_char
, p4_a91 VARCHAR2 := fnd_api.g_miss_char
, p4_a92 VARCHAR2 := fnd_api.g_miss_char
, p4_a93 VARCHAR2 := fnd_api.g_miss_char
, p4_a94 VARCHAR2 := fnd_api.g_miss_char
, p4_a95 VARCHAR2 := fnd_api.g_miss_char
, p4_a96 VARCHAR2 := fnd_api.g_miss_char
, p4_a97 VARCHAR2 := fnd_api.g_miss_char
, p4_a98 VARCHAR2 := fnd_api.g_miss_char
, p4_a99 NUMBER := 0-1962.0724
)
as
ddp_header_rec as_opportunity_pub.header_rec_type;
ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a0);
ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p4_a1);
ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p4_a4);
ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p4_a8);
ddp_header_rec.updateable_flag := p4_a54;
ddp_header_rec.deleted_flag := p4_a60;
ddp_header_rec.delete_allowed_flag := p4_a75;
as_opportunity_pub.delete_opp_header(p_api_version_number,
p_init_msg_list,
p_commit,
p_validation_level,
ddp_header_rec,
p_check_access_flag,
p_admin_flag,
p_admin_group_id,
p_identity_salesforce_id,
p_partner_cont_party_id,
ddp_profile_tbl,
x_return_status,
x_msg_count,
x_msg_data,
x_lead_id);
ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a0);
ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p5_a1);
ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p5_a4);
ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a8);
ddp_header_rec.updateable_flag := p5_a54;
ddp_header_rec.deleted_flag := p5_a60;
ddp_header_rec.delete_allowed_flag := p5_a75;
procedure update_opp_lines(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_validation_level NUMBER
, p_identity_salesforce_id NUMBER
, p5_a0 JTF_DATE_TABLE
, p5_a1 JTF_NUMBER_TABLE
, p5_a2 JTF_DATE_TABLE
, p5_a3 JTF_NUMBER_TABLE
, p5_a4 JTF_NUMBER_TABLE
, p5_a5 JTF_NUMBER_TABLE
, p5_a6 JTF_NUMBER_TABLE
, p5_a7 JTF_NUMBER_TABLE
, p5_a8 JTF_DATE_TABLE
, p5_a9 JTF_NUMBER_TABLE
, p5_a10 JTF_NUMBER_TABLE
, p5_a11 JTF_NUMBER_TABLE
, p5_a12 JTF_NUMBER_TABLE
, p5_a13 JTF_VARCHAR2_TABLE_100
, p5_a14 JTF_VARCHAR2_TABLE_100
, p5_a15 JTF_NUMBER_TABLE
, p5_a16 JTF_VARCHAR2_TABLE_100
, p5_a17 JTF_NUMBER_TABLE
, p5_a18 JTF_VARCHAR2_TABLE_100
, p5_a19 JTF_NUMBER_TABLE
, p5_a20 JTF_VARCHAR2_TABLE_2000
, p5_a21 JTF_NUMBER_TABLE
, p5_a22 JTF_VARCHAR2_TABLE_100
, p5_a23 JTF_VARCHAR2_TABLE_100
, p5_a24 JTF_NUMBER_TABLE
, p5_a25 JTF_DATE_TABLE
, p5_a26 JTF_NUMBER_TABLE
, p5_a27 JTF_NUMBER_TABLE
, p5_a28 JTF_VARCHAR2_TABLE_100
, p5_a29 JTF_NUMBER_TABLE
, p5_a30 JTF_VARCHAR2_TABLE_100
, p5_a31 JTF_VARCHAR2_TABLE_100
, p5_a32 JTF_DATE_TABLE
, p5_a33 JTF_VARCHAR2_TABLE_100
, p5_a34 JTF_VARCHAR2_TABLE_100
, p5_a35 JTF_NUMBER_TABLE
, p5_a36 JTF_NUMBER_TABLE
, p5_a37 JTF_NUMBER_TABLE
, p5_a38 JTF_VARCHAR2_TABLE_100
, p5_a39 JTF_VARCHAR2_TABLE_100
, p5_a40 JTF_VARCHAR2_TABLE_100
, p5_a41 JTF_VARCHAR2_TABLE_100
, p5_a42 JTF_NUMBER_TABLE
, p5_a43 JTF_NUMBER_TABLE
, p5_a44 JTF_DATE_TABLE
, p5_a45 JTF_VARCHAR2_TABLE_100
, p5_a46 JTF_NUMBER_TABLE
, p5_a47 JTF_NUMBER_TABLE
, p5_a48 JTF_NUMBER_TABLE
, p5_a49 JTF_NUMBER_TABLE
, p5_a50 JTF_VARCHAR2_TABLE_100
, p5_a51 JTF_VARCHAR2_TABLE_200
, p5_a52 JTF_VARCHAR2_TABLE_200
, p5_a53 JTF_VARCHAR2_TABLE_200
, p5_a54 JTF_VARCHAR2_TABLE_200
, p5_a55 JTF_VARCHAR2_TABLE_200
, p5_a56 JTF_VARCHAR2_TABLE_200
, p5_a57 JTF_VARCHAR2_TABLE_200
, p5_a58 JTF_VARCHAR2_TABLE_200
, p5_a59 JTF_VARCHAR2_TABLE_200
, p5_a60 JTF_VARCHAR2_TABLE_200
, p5_a61 JTF_VARCHAR2_TABLE_200
, p5_a62 JTF_VARCHAR2_TABLE_200
, p5_a63 JTF_VARCHAR2_TABLE_200
, p5_a64 JTF_VARCHAR2_TABLE_200
, p5_a65 JTF_VARCHAR2_TABLE_200
, p5_a66 JTF_NUMBER_TABLE
, p5_a67 JTF_NUMBER_TABLE
, p5_a68 JTF_NUMBER_TABLE
, p_check_access_flag VARCHAR2
, p_admin_flag VARCHAR2
, p_admin_group_id NUMBER
, p_partner_cont_party_id NUMBER
, p11_a0 JTF_VARCHAR2_TABLE_100
, p11_a1 JTF_VARCHAR2_TABLE_300
, p12_a0 out nocopy JTF_NUMBER_TABLE
, p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p6_a0 DATE := fnd_api.g_miss_date
, p6_a1 NUMBER := 0-1962.0724
, p6_a2 DATE := fnd_api.g_miss_date
, p6_a3 NUMBER := 0-1962.0724
, p6_a4 NUMBER := 0-1962.0724
, p6_a5 NUMBER := 0-1962.0724
, p6_a6 NUMBER := 0-1962.0724
, p6_a7 NUMBER := 0-1962.0724
, p6_a8 DATE := fnd_api.g_miss_date
, p6_a9 NUMBER := 0-1962.0724
, p6_a10 VARCHAR2 := fnd_api.g_miss_char
, p6_a11 VARCHAR2 := fnd_api.g_miss_char
, p6_a12 VARCHAR2 := fnd_api.g_miss_char
, p6_a13 VARCHAR2 := fnd_api.g_miss_char
, p6_a14 VARCHAR2 := fnd_api.g_miss_char
, p6_a15 NUMBER := 0-1962.0724
, p6_a16 VARCHAR2 := fnd_api.g_miss_char
, p6_a17 NUMBER := 0-1962.0724
, p6_a18 VARCHAR2 := fnd_api.g_miss_char
, p6_a19 VARCHAR2 := fnd_api.g_miss_char
, p6_a20 NUMBER := 0-1962.0724
, p6_a21 VARCHAR2 := fnd_api.g_miss_char
, p6_a22 VARCHAR2 := fnd_api.g_miss_char
, p6_a23 VARCHAR2 := fnd_api.g_miss_char
, p6_a24 VARCHAR2 := fnd_api.g_miss_char
, p6_a25 VARCHAR2 := fnd_api.g_miss_char
, p6_a26 VARCHAR2 := fnd_api.g_miss_char
, p6_a27 VARCHAR2 := fnd_api.g_miss_char
, p6_a28 VARCHAR2 := fnd_api.g_miss_char
, p6_a29 NUMBER := 0-1962.0724
, p6_a30 VARCHAR2 := fnd_api.g_miss_char
, p6_a31 NUMBER := 0-1962.0724
, p6_a32 VARCHAR2 := fnd_api.g_miss_char
, p6_a33 VARCHAR2 := fnd_api.g_miss_char
, p6_a34 NUMBER := 0-1962.0724
, p6_a35 NUMBER := 0-1962.0724
, p6_a36 VARCHAR2 := fnd_api.g_miss_char
, p6_a37 VARCHAR2 := fnd_api.g_miss_char
, p6_a38 DATE := fnd_api.g_miss_date
, p6_a39 VARCHAR2 := fnd_api.g_miss_char
, p6_a40 VARCHAR2 := fnd_api.g_miss_char
, p6_a41 VARCHAR2 := fnd_api.g_miss_char
, p6_a42 VARCHAR2 := fnd_api.g_miss_char
, p6_a43 VARCHAR2 := fnd_api.g_miss_char
, p6_a44 NUMBER := 0-1962.0724
, p6_a45 VARCHAR2 := fnd_api.g_miss_char
, p6_a46 VARCHAR2 := fnd_api.g_miss_char
, p6_a47 NUMBER := 0-1962.0724
, p6_a48 VARCHAR2 := fnd_api.g_miss_char
, p6_a49 NUMBER := 0-1962.0724
, p6_a50 NUMBER := 0-1962.0724
, p6_a51 NUMBER := 0-1962.0724
, p6_a52 VARCHAR2 := fnd_api.g_miss_char
, p6_a53 VARCHAR2 := fnd_api.g_miss_char
, p6_a54 VARCHAR2 := fnd_api.g_miss_char
, p6_a55 NUMBER := 0-1962.0724
, p6_a56 NUMBER := 0-1962.0724
, p6_a57 VARCHAR2 := fnd_api.g_miss_char
, p6_a58 VARCHAR2 := fnd_api.g_miss_char
, p6_a59 VARCHAR2 := fnd_api.g_miss_char
, p6_a60 VARCHAR2 := fnd_api.g_miss_char
, p6_a61 VARCHAR2 := fnd_api.g_miss_char
, p6_a62 VARCHAR2 := fnd_api.g_miss_char
, p6_a63 NUMBER := 0-1962.0724
, p6_a64 VARCHAR2 := fnd_api.g_miss_char
, p6_a65 NUMBER := 0-1962.0724
, p6_a66 NUMBER := 0-1962.0724
, p6_a67 VARCHAR2 := fnd_api.g_miss_char
, p6_a68 NUMBER := 0-1962.0724
, p6_a69 NUMBER := 0-1962.0724
, p6_a70 NUMBER := 0-1962.0724
, p6_a71 VARCHAR2 := fnd_api.g_miss_char
, p6_a72 VARCHAR2 := fnd_api.g_miss_char
, p6_a73 DATE := fnd_api.g_miss_date
, p6_a74 VARCHAR2 := fnd_api.g_miss_char
, p6_a75 VARCHAR2 := fnd_api.g_miss_char
, p6_a76 VARCHAR2 := fnd_api.g_miss_char
, p6_a77 VARCHAR2 := fnd_api.g_miss_char
, p6_a78 VARCHAR2 := fnd_api.g_miss_char
, p6_a79 VARCHAR2 := fnd_api.g_miss_char
, p6_a80 NUMBER := 0-1962.0724
, p6_a81 VARCHAR2 := fnd_api.g_miss_char
, p6_a82 VARCHAR2 := fnd_api.g_miss_char
, p6_a83 VARCHAR2 := fnd_api.g_miss_char
, p6_a84 VARCHAR2 := fnd_api.g_miss_char
, p6_a85 VARCHAR2 := fnd_api.g_miss_char
, p6_a86 VARCHAR2 := fnd_api.g_miss_char
, p6_a87 VARCHAR2 := fnd_api.g_miss_char
, p6_a88 VARCHAR2 := fnd_api.g_miss_char
, p6_a89 VARCHAR2 := fnd_api.g_miss_char
, p6_a90 VARCHAR2 := fnd_api.g_miss_char
, p6_a91 VARCHAR2 := fnd_api.g_miss_char
, p6_a92 VARCHAR2 := fnd_api.g_miss_char
, p6_a93 VARCHAR2 := fnd_api.g_miss_char
, p6_a94 VARCHAR2 := fnd_api.g_miss_char
, p6_a95 VARCHAR2 := fnd_api.g_miss_char
, p6_a96 VARCHAR2 := fnd_api.g_miss_char
, p6_a97 VARCHAR2 := fnd_api.g_miss_char
, p6_a98 VARCHAR2 := fnd_api.g_miss_char
, p6_a99 NUMBER := 0-1962.0724
)
as
ddp_line_tbl as_opportunity_pub.line_tbl_type;
ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a0);
ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p6_a1);
ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p6_a4);
ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a8);
ddp_header_rec.updateable_flag := p6_a54;
ddp_header_rec.deleted_flag := p6_a60;
ddp_header_rec.delete_allowed_flag := p6_a75;
as_opportunity_pub.update_opp_lines(p_api_version_number,
p_init_msg_list,
p_commit,
p_validation_level,
p_identity_salesforce_id,
ddp_line_tbl,
ddp_header_rec,
p_check_access_flag,
p_admin_flag,
p_admin_group_id,
p_partner_cont_party_id,
ddp_profile_tbl,
ddx_line_out_tbl,
x_return_status,
x_msg_count,
x_msg_data);
procedure delete_opp_lines(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_validation_level NUMBER
, p_identity_salesforce_id NUMBER
, p5_a0 JTF_DATE_TABLE
, p5_a1 JTF_NUMBER_TABLE
, p5_a2 JTF_DATE_TABLE
, p5_a3 JTF_NUMBER_TABLE
, p5_a4 JTF_NUMBER_TABLE
, p5_a5 JTF_NUMBER_TABLE
, p5_a6 JTF_NUMBER_TABLE
, p5_a7 JTF_NUMBER_TABLE
, p5_a8 JTF_DATE_TABLE
, p5_a9 JTF_NUMBER_TABLE
, p5_a10 JTF_NUMBER_TABLE
, p5_a11 JTF_NUMBER_TABLE
, p5_a12 JTF_NUMBER_TABLE
, p5_a13 JTF_VARCHAR2_TABLE_100
, p5_a14 JTF_VARCHAR2_TABLE_100
, p5_a15 JTF_NUMBER_TABLE
, p5_a16 JTF_VARCHAR2_TABLE_100
, p5_a17 JTF_NUMBER_TABLE
, p5_a18 JTF_VARCHAR2_TABLE_100
, p5_a19 JTF_NUMBER_TABLE
, p5_a20 JTF_VARCHAR2_TABLE_2000
, p5_a21 JTF_NUMBER_TABLE
, p5_a22 JTF_VARCHAR2_TABLE_100
, p5_a23 JTF_VARCHAR2_TABLE_100
, p5_a24 JTF_NUMBER_TABLE
, p5_a25 JTF_DATE_TABLE
, p5_a26 JTF_NUMBER_TABLE
, p5_a27 JTF_NUMBER_TABLE
, p5_a28 JTF_VARCHAR2_TABLE_100
, p5_a29 JTF_NUMBER_TABLE
, p5_a30 JTF_VARCHAR2_TABLE_100
, p5_a31 JTF_VARCHAR2_TABLE_100
, p5_a32 JTF_DATE_TABLE
, p5_a33 JTF_VARCHAR2_TABLE_100
, p5_a34 JTF_VARCHAR2_TABLE_100
, p5_a35 JTF_NUMBER_TABLE
, p5_a36 JTF_NUMBER_TABLE
, p5_a37 JTF_NUMBER_TABLE
, p5_a38 JTF_VARCHAR2_TABLE_100
, p5_a39 JTF_VARCHAR2_TABLE_100
, p5_a40 JTF_VARCHAR2_TABLE_100
, p5_a41 JTF_VARCHAR2_TABLE_100
, p5_a42 JTF_NUMBER_TABLE
, p5_a43 JTF_NUMBER_TABLE
, p5_a44 JTF_DATE_TABLE
, p5_a45 JTF_VARCHAR2_TABLE_100
, p5_a46 JTF_NUMBER_TABLE
, p5_a47 JTF_NUMBER_TABLE
, p5_a48 JTF_NUMBER_TABLE
, p5_a49 JTF_NUMBER_TABLE
, p5_a50 JTF_VARCHAR2_TABLE_100
, p5_a51 JTF_VARCHAR2_TABLE_200
, p5_a52 JTF_VARCHAR2_TABLE_200
, p5_a53 JTF_VARCHAR2_TABLE_200
, p5_a54 JTF_VARCHAR2_TABLE_200
, p5_a55 JTF_VARCHAR2_TABLE_200
, p5_a56 JTF_VARCHAR2_TABLE_200
, p5_a57 JTF_VARCHAR2_TABLE_200
, p5_a58 JTF_VARCHAR2_TABLE_200
, p5_a59 JTF_VARCHAR2_TABLE_200
, p5_a60 JTF_VARCHAR2_TABLE_200
, p5_a61 JTF_VARCHAR2_TABLE_200
, p5_a62 JTF_VARCHAR2_TABLE_200
, p5_a63 JTF_VARCHAR2_TABLE_200
, p5_a64 JTF_VARCHAR2_TABLE_200
, p5_a65 JTF_VARCHAR2_TABLE_200
, p5_a66 JTF_NUMBER_TABLE
, p5_a67 JTF_NUMBER_TABLE
, p5_a68 JTF_NUMBER_TABLE
, p_check_access_flag VARCHAR2
, p_admin_flag VARCHAR2
, p_admin_group_id NUMBER
, p_partner_cont_party_id NUMBER
, p11_a0 JTF_VARCHAR2_TABLE_100
, p11_a1 JTF_VARCHAR2_TABLE_300
, p12_a0 out nocopy JTF_NUMBER_TABLE
, p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p6_a0 DATE := fnd_api.g_miss_date
, p6_a1 NUMBER := 0-1962.0724
, p6_a2 DATE := fnd_api.g_miss_date
, p6_a3 NUMBER := 0-1962.0724
, p6_a4 NUMBER := 0-1962.0724
, p6_a5 NUMBER := 0-1962.0724
, p6_a6 NUMBER := 0-1962.0724
, p6_a7 NUMBER := 0-1962.0724
, p6_a8 DATE := fnd_api.g_miss_date
, p6_a9 NUMBER := 0-1962.0724
, p6_a10 VARCHAR2 := fnd_api.g_miss_char
, p6_a11 VARCHAR2 := fnd_api.g_miss_char
, p6_a12 VARCHAR2 := fnd_api.g_miss_char
, p6_a13 VARCHAR2 := fnd_api.g_miss_char
, p6_a14 VARCHAR2 := fnd_api.g_miss_char
, p6_a15 NUMBER := 0-1962.0724
, p6_a16 VARCHAR2 := fnd_api.g_miss_char
, p6_a17 NUMBER := 0-1962.0724
, p6_a18 VARCHAR2 := fnd_api.g_miss_char
, p6_a19 VARCHAR2 := fnd_api.g_miss_char
, p6_a20 NUMBER := 0-1962.0724
, p6_a21 VARCHAR2 := fnd_api.g_miss_char
, p6_a22 VARCHAR2 := fnd_api.g_miss_char
, p6_a23 VARCHAR2 := fnd_api.g_miss_char
, p6_a24 VARCHAR2 := fnd_api.g_miss_char
, p6_a25 VARCHAR2 := fnd_api.g_miss_char
, p6_a26 VARCHAR2 := fnd_api.g_miss_char
, p6_a27 VARCHAR2 := fnd_api.g_miss_char
, p6_a28 VARCHAR2 := fnd_api.g_miss_char
, p6_a29 NUMBER := 0-1962.0724
, p6_a30 VARCHAR2 := fnd_api.g_miss_char
, p6_a31 NUMBER := 0-1962.0724
, p6_a32 VARCHAR2 := fnd_api.g_miss_char
, p6_a33 VARCHAR2 := fnd_api.g_miss_char
, p6_a34 NUMBER := 0-1962.0724
, p6_a35 NUMBER := 0-1962.0724
, p6_a36 VARCHAR2 := fnd_api.g_miss_char
, p6_a37 VARCHAR2 := fnd_api.g_miss_char
, p6_a38 DATE := fnd_api.g_miss_date
, p6_a39 VARCHAR2 := fnd_api.g_miss_char
, p6_a40 VARCHAR2 := fnd_api.g_miss_char
, p6_a41 VARCHAR2 := fnd_api.g_miss_char
, p6_a42 VARCHAR2 := fnd_api.g_miss_char
, p6_a43 VARCHAR2 := fnd_api.g_miss_char
, p6_a44 NUMBER := 0-1962.0724
, p6_a45 VARCHAR2 := fnd_api.g_miss_char
, p6_a46 VARCHAR2 := fnd_api.g_miss_char
, p6_a47 NUMBER := 0-1962.0724
, p6_a48 VARCHAR2 := fnd_api.g_miss_char
, p6_a49 NUMBER := 0-1962.0724
, p6_a50 NUMBER := 0-1962.0724
, p6_a51 NUMBER := 0-1962.0724
, p6_a52 VARCHAR2 := fnd_api.g_miss_char
, p6_a53 VARCHAR2 := fnd_api.g_miss_char
, p6_a54 VARCHAR2 := fnd_api.g_miss_char
, p6_a55 NUMBER := 0-1962.0724
, p6_a56 NUMBER := 0-1962.0724
, p6_a57 VARCHAR2 := fnd_api.g_miss_char
, p6_a58 VARCHAR2 := fnd_api.g_miss_char
, p6_a59 VARCHAR2 := fnd_api.g_miss_char
, p6_a60 VARCHAR2 := fnd_api.g_miss_char
, p6_a61 VARCHAR2 := fnd_api.g_miss_char
, p6_a62 VARCHAR2 := fnd_api.g_miss_char
, p6_a63 NUMBER := 0-1962.0724
, p6_a64 VARCHAR2 := fnd_api.g_miss_char
, p6_a65 NUMBER := 0-1962.0724
, p6_a66 NUMBER := 0-1962.0724
, p6_a67 VARCHAR2 := fnd_api.g_miss_char
, p6_a68 NUMBER := 0-1962.0724
, p6_a69 NUMBER := 0-1962.0724
, p6_a70 NUMBER := 0-1962.0724
, p6_a71 VARCHAR2 := fnd_api.g_miss_char
, p6_a72 VARCHAR2 := fnd_api.g_miss_char
, p6_a73 DATE := fnd_api.g_miss_date
, p6_a74 VARCHAR2 := fnd_api.g_miss_char
, p6_a75 VARCHAR2 := fnd_api.g_miss_char
, p6_a76 VARCHAR2 := fnd_api.g_miss_char
, p6_a77 VARCHAR2 := fnd_api.g_miss_char
, p6_a78 VARCHAR2 := fnd_api.g_miss_char
, p6_a79 VARCHAR2 := fnd_api.g_miss_char
, p6_a80 NUMBER := 0-1962.0724
, p6_a81 VARCHAR2 := fnd_api.g_miss_char
, p6_a82 VARCHAR2 := fnd_api.g_miss_char
, p6_a83 VARCHAR2 := fnd_api.g_miss_char
, p6_a84 VARCHAR2 := fnd_api.g_miss_char
, p6_a85 VARCHAR2 := fnd_api.g_miss_char
, p6_a86 VARCHAR2 := fnd_api.g_miss_char
, p6_a87 VARCHAR2 := fnd_api.g_miss_char
, p6_a88 VARCHAR2 := fnd_api.g_miss_char
, p6_a89 VARCHAR2 := fnd_api.g_miss_char
, p6_a90 VARCHAR2 := fnd_api.g_miss_char
, p6_a91 VARCHAR2 := fnd_api.g_miss_char
, p6_a92 VARCHAR2 := fnd_api.g_miss_char
, p6_a93 VARCHAR2 := fnd_api.g_miss_char
, p6_a94 VARCHAR2 := fnd_api.g_miss_char
, p6_a95 VARCHAR2 := fnd_api.g_miss_char
, p6_a96 VARCHAR2 := fnd_api.g_miss_char
, p6_a97 VARCHAR2 := fnd_api.g_miss_char
, p6_a98 VARCHAR2 := fnd_api.g_miss_char
, p6_a99 NUMBER := 0-1962.0724
)
as
ddp_line_tbl as_opportunity_pub.line_tbl_type;
ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a0);
ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p6_a1);
ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p6_a4);
ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a8);
ddp_header_rec.updateable_flag := p6_a54;
ddp_header_rec.deleted_flag := p6_a60;
ddp_header_rec.delete_allowed_flag := p6_a75;
as_opportunity_pub.delete_opp_lines(p_api_version_number,
p_init_msg_list,
p_commit,
p_validation_level,
p_identity_salesforce_id,
ddp_line_tbl,
ddp_header_rec,
p_check_access_flag,
p_admin_flag,
p_admin_group_id,
p_partner_cont_party_id,
ddp_profile_tbl,
ddx_line_out_tbl,
x_return_status,
x_msg_count,
x_msg_data);
procedure update_sales_credits(p_api_version_number NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_validation_level NUMBER
, p_identity_salesforce_id NUMBER
, p5_a0 JTF_DATE_TABLE
, p5_a1 JTF_NUMBER_TABLE
, p5_a2 JTF_DATE_TABLE
, p5_a3 JTF_NUMBER_TABLE
, p5_a4 JTF_NUMBER_TABLE
, p5_a5 JTF_NUMBER_TABLE
, p5_a6 JTF_NUMBER_TABLE
, p5_a7 JTF_NUMBER_TABLE
, p5_a8 JTF_DATE_TABLE
, p5_a9 JTF_NUMBER_TABLE
, p5_a10 JTF_NUMBER_TABLE
, p5_a11 JTF_NUMBER_TABLE
, p5_a12 JTF_NUMBER_TABLE
, p5_a13 JTF_NUMBER_TABLE
, p5_a14 JTF_NUMBER_TABLE
, p5_a15 JTF_VARCHAR2_TABLE_100
, p5_a16 JTF_VARCHAR2_TABLE_100
, p5_a17 JTF_NUMBER_TABLE
, p5_a18 JTF_VARCHAR2_TABLE_100
, p5_a19 JTF_NUMBER_TABLE
, p5_a20 JTF_VARCHAR2_TABLE_400
, p5_a21 JTF_VARCHAR2_TABLE_100
, p5_a22 JTF_NUMBER_TABLE
, p5_a23 JTF_NUMBER_TABLE
, p5_a24 JTF_NUMBER_TABLE
, p5_a25 JTF_NUMBER_TABLE
, p5_a26 JTF_NUMBER_TABLE
, p5_a27 JTF_NUMBER_TABLE
, p5_a28 JTF_NUMBER_TABLE
, p5_a29 JTF_VARCHAR2_TABLE_100
, p5_a30 JTF_VARCHAR2_TABLE_100
, p5_a31 JTF_VARCHAR2_TABLE_100
, p5_a32 JTF_DATE_TABLE
, p5_a33 JTF_NUMBER_TABLE
, p5_a34 JTF_VARCHAR2_TABLE_100
, p5_a35 JTF_VARCHAR2_TABLE_100
, p5_a36 JTF_NUMBER_TABLE
, p5_a37 JTF_VARCHAR2_TABLE_100
, p5_a38 JTF_NUMBER_TABLE
, p5_a39 JTF_NUMBER_TABLE
, p5_a40 JTF_NUMBER_TABLE
, p5_a41 JTF_VARCHAR2_TABLE_100
, p5_a42 JTF_VARCHAR2_TABLE_200
, p5_a43 JTF_VARCHAR2_TABLE_200
, p5_a44 JTF_VARCHAR2_TABLE_200
, p5_a45 JTF_VARCHAR2_TABLE_200
, p5_a46 JTF_VARCHAR2_TABLE_200
, p5_a47 JTF_VARCHAR2_TABLE_200
, p5_a48 JTF_VARCHAR2_TABLE_200
, p5_a49 JTF_VARCHAR2_TABLE_200
, p5_a50 JTF_VARCHAR2_TABLE_200
, p5_a51 JTF_VARCHAR2_TABLE_200
, p5_a52 JTF_VARCHAR2_TABLE_200
, p5_a53 JTF_VARCHAR2_TABLE_200
, p5_a54 JTF_VARCHAR2_TABLE_200
, p5_a55 JTF_VARCHAR2_TABLE_200
, p5_a56 JTF_VARCHAR2_TABLE_200
, p5_a57 JTF_NUMBER_TABLE
, p5_a58 JTF_NUMBER_TABLE
, p5_a59 JTF_NUMBER_TABLE
, p5_a60 JTF_VARCHAR2_TABLE_100
, p_check_access_flag VARCHAR2
, p_admin_flag VARCHAR2
, p_admin_group_id NUMBER
, p_partner_cont_party_id NUMBER
, p10_a0 JTF_VARCHAR2_TABLE_100
, p10_a1 JTF_VARCHAR2_TABLE_300
, p11_a0 out nocopy JTF_NUMBER_TABLE
, p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
as_opportunity_pub.update_sales_credits(p_api_version_number,
p_init_msg_list,
p_commit,
p_validation_level,
p_identity_salesforce_id,
ddp_sales_credit_tbl,
p_check_access_flag,
p_admin_flag,
p_admin_group_id,
p_partner_cont_party_id,
ddp_profile_tbl,
ddx_sales_credit_out_tbl,
x_return_status,
x_msg_count,
x_msg_data);