[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure rosetta_table_copy_in_p7(t out nocopy okl_mla_create_update_pub.deal_tab_type, a0 JTF_NUMBER_TABLE
, a1 JTF_VARCHAR2_TABLE_200
, a2 JTF_VARCHAR2_TABLE_2000
, a3 JTF_VARCHAR2_TABLE_100
, a4 JTF_VARCHAR2_TABLE_100
, a5 JTF_DATE_TABLE
, a6 JTF_DATE_TABLE
, a7 JTF_NUMBER_TABLE
, a8 JTF_VARCHAR2_TABLE_200
, a9 JTF_NUMBER_TABLE
, a10 JTF_NUMBER_TABLE
, a11 JTF_VARCHAR2_TABLE_100
, a12 JTF_VARCHAR2_TABLE_100
, a13 JTF_VARCHAR2_TABLE_100
, a14 JTF_VARCHAR2_TABLE_100
, a15 JTF_VARCHAR2_TABLE_100
, a16 JTF_VARCHAR2_TABLE_100
, a17 JTF_VARCHAR2_TABLE_100
, a18 JTF_DATE_TABLE
, a19 JTF_DATE_TABLE
, a20 JTF_DATE_TABLE
, a21 JTF_DATE_TABLE
, a22 JTF_VARCHAR2_TABLE_100
, a23 JTF_VARCHAR2_TABLE_100
, a24 JTF_VARCHAR2_TABLE_200
, a25 JTF_NUMBER_TABLE
, a26 JTF_NUMBER_TABLE
, a27 JTF_NUMBER_TABLE
, a28 JTF_VARCHAR2_TABLE_100
, a29 JTF_VARCHAR2_TABLE_200
, a30 JTF_VARCHAR2_TABLE_100
, a31 JTF_VARCHAR2_TABLE_300
, a32 JTF_NUMBER_TABLE
, a33 JTF_VARCHAR2_TABLE_100
, a34 JTF_VARCHAR2_TABLE_200
, a35 JTF_VARCHAR2_TABLE_100
, a36 JTF_VARCHAR2_TABLE_300
, a37 JTF_VARCHAR2_TABLE_100
, a38 JTF_VARCHAR2_TABLE_300
, a39 JTF_NUMBER_TABLE
, a40 JTF_VARCHAR2_TABLE_200
, a41 JTF_VARCHAR2_TABLE_2000
, a42 JTF_NUMBER_TABLE
, a43 JTF_VARCHAR2_TABLE_200
, a44 JTF_VARCHAR2_TABLE_200
, a45 JTF_NUMBER_TABLE
, a46 JTF_NUMBER_TABLE
, a47 JTF_NUMBER_TABLE
, a48 JTF_NUMBER_TABLE
, a49 JTF_VARCHAR2_TABLE_500
, a50 JTF_VARCHAR2_TABLE_300
, a51 JTF_NUMBER_TABLE
, a52 JTF_NUMBER_TABLE
, a53 JTF_VARCHAR2_TABLE_500
, a54 JTF_VARCHAR2_TABLE_300
, a55 JTF_NUMBER_TABLE
, a56 JTF_VARCHAR2_TABLE_300
, a57 JTF_VARCHAR2_TABLE_300
, a58 JTF_NUMBER_TABLE
, a59 JTF_VARCHAR2_TABLE_100
, a60 JTF_VARCHAR2_TABLE_200
, a61 JTF_VARCHAR2_TABLE_100
, a62 JTF_VARCHAR2_TABLE_300
, a63 JTF_NUMBER_TABLE
, a64 JTF_NUMBER_TABLE
, a65 JTF_VARCHAR2_TABLE_500
, a66 JTF_VARCHAR2_TABLE_300
, a67 JTF_NUMBER_TABLE
, a68 JTF_NUMBER_TABLE
, a69 JTF_VARCHAR2_TABLE_500
, a70 JTF_VARCHAR2_TABLE_300
, a71 JTF_NUMBER_TABLE
, a72 JTF_NUMBER_TABLE
, a73 JTF_VARCHAR2_TABLE_500
, a74 JTF_VARCHAR2_TABLE_300
, a75 JTF_NUMBER_TABLE
, a76 JTF_NUMBER_TABLE
, a77 JTF_VARCHAR2_TABLE_500
, a78 JTF_VARCHAR2_TABLE_300
, a79 JTF_VARCHAR2_TABLE_100
, a80 JTF_NUMBER_TABLE
, a81 JTF_DATE_TABLE
, a82 JTF_VARCHAR2_TABLE_100
, a83 JTF_NUMBER_TABLE
) as
ddindx binary_integer; indx binary_integer;
procedure rosetta_table_copy_out_p7(t okl_mla_create_update_pub.deal_tab_type, a0 out nocopy JTF_NUMBER_TABLE
, a1 out nocopy JTF_VARCHAR2_TABLE_200
, a2 out nocopy JTF_VARCHAR2_TABLE_2000
, a3 out nocopy JTF_VARCHAR2_TABLE_100
, a4 out nocopy JTF_VARCHAR2_TABLE_100
, a5 out nocopy JTF_DATE_TABLE
, a6 out nocopy JTF_DATE_TABLE
, a7 out nocopy JTF_NUMBER_TABLE
, a8 out nocopy JTF_VARCHAR2_TABLE_200
, a9 out nocopy JTF_NUMBER_TABLE
, a10 out nocopy JTF_NUMBER_TABLE
, a11 out nocopy JTF_VARCHAR2_TABLE_100
, a12 out nocopy JTF_VARCHAR2_TABLE_100
, a13 out nocopy JTF_VARCHAR2_TABLE_100
, a14 out nocopy JTF_VARCHAR2_TABLE_100
, a15 out nocopy JTF_VARCHAR2_TABLE_100
, a16 out nocopy JTF_VARCHAR2_TABLE_100
, a17 out nocopy JTF_VARCHAR2_TABLE_100
, a18 out nocopy JTF_DATE_TABLE
, a19 out nocopy JTF_DATE_TABLE
, a20 out nocopy JTF_DATE_TABLE
, a21 out nocopy JTF_DATE_TABLE
, a22 out nocopy JTF_VARCHAR2_TABLE_100
, a23 out nocopy JTF_VARCHAR2_TABLE_100
, a24 out nocopy JTF_VARCHAR2_TABLE_200
, a25 out nocopy JTF_NUMBER_TABLE
, a26 out nocopy JTF_NUMBER_TABLE
, a27 out nocopy JTF_NUMBER_TABLE
, a28 out nocopy JTF_VARCHAR2_TABLE_100
, a29 out nocopy JTF_VARCHAR2_TABLE_200
, a30 out nocopy JTF_VARCHAR2_TABLE_100
, a31 out nocopy JTF_VARCHAR2_TABLE_300
, a32 out nocopy JTF_NUMBER_TABLE
, a33 out nocopy JTF_VARCHAR2_TABLE_100
, a34 out nocopy JTF_VARCHAR2_TABLE_200
, a35 out nocopy JTF_VARCHAR2_TABLE_100
, a36 out nocopy JTF_VARCHAR2_TABLE_300
, a37 out nocopy JTF_VARCHAR2_TABLE_100
, a38 out nocopy JTF_VARCHAR2_TABLE_300
, a39 out nocopy JTF_NUMBER_TABLE
, a40 out nocopy JTF_VARCHAR2_TABLE_200
, a41 out nocopy JTF_VARCHAR2_TABLE_2000
, a42 out nocopy JTF_NUMBER_TABLE
, a43 out nocopy JTF_VARCHAR2_TABLE_200
, a44 out nocopy JTF_VARCHAR2_TABLE_200
, a45 out nocopy JTF_NUMBER_TABLE
, a46 out nocopy JTF_NUMBER_TABLE
, a47 out nocopy JTF_NUMBER_TABLE
, a48 out nocopy JTF_NUMBER_TABLE
, a49 out nocopy JTF_VARCHAR2_TABLE_500
, a50 out nocopy JTF_VARCHAR2_TABLE_300
, a51 out nocopy JTF_NUMBER_TABLE
, a52 out nocopy JTF_NUMBER_TABLE
, a53 out nocopy JTF_VARCHAR2_TABLE_500
, a54 out nocopy JTF_VARCHAR2_TABLE_300
, a55 out nocopy JTF_NUMBER_TABLE
, a56 out nocopy JTF_VARCHAR2_TABLE_300
, a57 out nocopy JTF_VARCHAR2_TABLE_300
, a58 out nocopy JTF_NUMBER_TABLE
, a59 out nocopy JTF_VARCHAR2_TABLE_100
, a60 out nocopy JTF_VARCHAR2_TABLE_200
, a61 out nocopy JTF_VARCHAR2_TABLE_100
, a62 out nocopy JTF_VARCHAR2_TABLE_300
, a63 out nocopy JTF_NUMBER_TABLE
, a64 out nocopy JTF_NUMBER_TABLE
, a65 out nocopy JTF_VARCHAR2_TABLE_500
, a66 out nocopy JTF_VARCHAR2_TABLE_300
, a67 out nocopy JTF_NUMBER_TABLE
, a68 out nocopy JTF_NUMBER_TABLE
, a69 out nocopy JTF_VARCHAR2_TABLE_500
, a70 out nocopy JTF_VARCHAR2_TABLE_300
, a71 out nocopy JTF_NUMBER_TABLE
, a72 out nocopy JTF_NUMBER_TABLE
, a73 out nocopy JTF_VARCHAR2_TABLE_500
, a74 out nocopy JTF_VARCHAR2_TABLE_300
, a75 out nocopy JTF_NUMBER_TABLE
, a76 out nocopy JTF_NUMBER_TABLE
, a77 out nocopy JTF_VARCHAR2_TABLE_500
, a78 out nocopy JTF_VARCHAR2_TABLE_300
, a79 out nocopy JTF_VARCHAR2_TABLE_100
, a80 out nocopy JTF_NUMBER_TABLE
, a81 out nocopy JTF_DATE_TABLE
, a82 out nocopy JTF_VARCHAR2_TABLE_100
, a83 out nocopy JTF_NUMBER_TABLE
) as
ddindx binary_integer; indx binary_integer;
procedure rosetta_table_copy_in_p9(t out nocopy okl_mla_create_update_pub.party_tab_type, a0 JTF_NUMBER_TABLE
, a1 JTF_VARCHAR2_TABLE_100
, a2 JTF_VARCHAR2_TABLE_500
, a3 JTF_VARCHAR2_TABLE_500
, a4 JTF_VARCHAR2_TABLE_500
, a5 JTF_VARCHAR2_TABLE_500
, a6 JTF_VARCHAR2_TABLE_500
, a7 JTF_VARCHAR2_TABLE_500
, a8 JTF_VARCHAR2_TABLE_500
, a9 JTF_VARCHAR2_TABLE_500
, a10 JTF_VARCHAR2_TABLE_500
, a11 JTF_VARCHAR2_TABLE_500
, a12 JTF_VARCHAR2_TABLE_500
, a13 JTF_VARCHAR2_TABLE_500
, a14 JTF_VARCHAR2_TABLE_500
, a15 JTF_VARCHAR2_TABLE_500
, a16 JTF_VARCHAR2_TABLE_500
, a17 JTF_VARCHAR2_TABLE_100
, a18 JTF_VARCHAR2_TABLE_200
, a19 JTF_VARCHAR2_TABLE_100
, a20 JTF_VARCHAR2_TABLE_100
, a21 JTF_NUMBER_TABLE
, a22 JTF_NUMBER_TABLE
, a23 JTF_NUMBER_TABLE
) as
ddindx binary_integer; indx binary_integer;
procedure rosetta_table_copy_out_p9(t okl_mla_create_update_pub.party_tab_type, a0 out nocopy JTF_NUMBER_TABLE
, a1 out nocopy JTF_VARCHAR2_TABLE_100
, a2 out nocopy JTF_VARCHAR2_TABLE_500
, a3 out nocopy JTF_VARCHAR2_TABLE_500
, a4 out nocopy JTF_VARCHAR2_TABLE_500
, a5 out nocopy JTF_VARCHAR2_TABLE_500
, a6 out nocopy JTF_VARCHAR2_TABLE_500
, a7 out nocopy JTF_VARCHAR2_TABLE_500
, a8 out nocopy JTF_VARCHAR2_TABLE_500
, a9 out nocopy JTF_VARCHAR2_TABLE_500
, a10 out nocopy JTF_VARCHAR2_TABLE_500
, a11 out nocopy JTF_VARCHAR2_TABLE_500
, a12 out nocopy JTF_VARCHAR2_TABLE_500
, a13 out nocopy JTF_VARCHAR2_TABLE_500
, a14 out nocopy JTF_VARCHAR2_TABLE_500
, a15 out nocopy JTF_VARCHAR2_TABLE_500
, a16 out nocopy JTF_VARCHAR2_TABLE_500
, a17 out nocopy JTF_VARCHAR2_TABLE_100
, a18 out nocopy JTF_VARCHAR2_TABLE_200
, a19 out nocopy JTF_VARCHAR2_TABLE_100
, a20 out nocopy JTF_VARCHAR2_TABLE_100
, a21 out nocopy JTF_NUMBER_TABLE
, a22 out nocopy JTF_NUMBER_TABLE
, a23 out nocopy JTF_NUMBER_TABLE
) as
ddindx binary_integer; indx binary_integer;
procedure rosetta_table_copy_in_p11(t out nocopy okl_mla_create_update_pub.upd_deal_tab_type, a0 JTF_NUMBER_TABLE
, a1 JTF_VARCHAR2_TABLE_200
, a2 JTF_VARCHAR2_TABLE_2000
, a3 JTF_DATE_TABLE
, a4 JTF_DATE_TABLE
, a5 JTF_VARCHAR2_TABLE_100
, a6 JTF_VARCHAR2_TABLE_100
, a7 JTF_DATE_TABLE
, a8 JTF_VARCHAR2_TABLE_100
, a9 JTF_NUMBER_TABLE
) as
ddindx binary_integer; indx binary_integer;
procedure rosetta_table_copy_out_p11(t okl_mla_create_update_pub.upd_deal_tab_type, a0 out nocopy JTF_NUMBER_TABLE
, a1 out nocopy JTF_VARCHAR2_TABLE_200
, a2 out nocopy JTF_VARCHAR2_TABLE_2000
, a3 out nocopy JTF_DATE_TABLE
, a4 out nocopy JTF_DATE_TABLE
, a5 out nocopy JTF_VARCHAR2_TABLE_100
, a6 out nocopy JTF_VARCHAR2_TABLE_100
, a7 out nocopy JTF_DATE_TABLE
, a8 out nocopy JTF_VARCHAR2_TABLE_100
, a9 out nocopy JTF_NUMBER_TABLE
) as
ddindx binary_integer; indx binary_integer;
procedure update_deal(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p6_a0 out nocopy NUMBER
, p6_a1 out nocopy VARCHAR2
, p6_a2 out nocopy VARCHAR2
, p6_a3 out nocopy DATE
, p6_a4 out nocopy DATE
, p6_a5 out nocopy VARCHAR2
, p6_a6 out nocopy VARCHAR2
, p6_a7 out nocopy DATE
, p6_a8 out nocopy VARCHAR2
, p6_a9 out nocopy NUMBER
, p5_a0 NUMBER := 0-1962.0724
, p5_a1 VARCHAR2 := fnd_api.g_miss_char
, p5_a2 VARCHAR2 := fnd_api.g_miss_char
, p5_a3 DATE := fnd_api.g_miss_date
, p5_a4 DATE := fnd_api.g_miss_date
, p5_a5 VARCHAR2 := fnd_api.g_miss_char
, p5_a6 VARCHAR2 := fnd_api.g_miss_char
, p5_a7 DATE := fnd_api.g_miss_date
, p5_a8 VARCHAR2 := fnd_api.g_miss_char
, p5_a9 NUMBER := 0-1962.0724
)
as
ddp_durv_rec okl_mla_create_update_pub.upd_deal_rec_type;
ddx_durv_rec okl_mla_create_update_pub.upd_deal_rec_type;
okl_mla_create_update_pub.update_deal(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
ddp_durv_rec,
ddx_durv_rec);
okl_mla_create_update_pub.create_deal(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_source_code,
p_template_type,
p_contract_number,
p_scs_code,
p_customer_id1,
p_customer_id2,
p_customer_code,
p_customer_name,
ddp_effective_from,
p_program_name,
p_program_id,
p_org_id,
p_organization_id,
p_source_chr_id,
p_source_contract_number,
x_chr_id,
p_legal_entity_id);
ddp_kpl_rec okl_mla_create_update_pub.party_rec_type;
ddx_kpl_rec okl_mla_create_update_pub.party_rec_type;
okl_mla_create_update_pub.create_party(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
ddp_kpl_rec,
ddx_kpl_rec);