The following lines contain the word 'select', 'insert', 'update' or 'delete':
, p_update_header number
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_update_header boolean;
if p_update_header is null
then ddp_update_header := null;
elsif p_update_header = 0
then ddp_update_header := false;
else ddp_update_header := true;
ddp_update_header,
x_return_status,
x_msg_count,
x_msg_data);
procedure updatecustomschedule(p0_a0 JTF_NUMBER_TABLE
, p0_a1 JTF_NUMBER_TABLE
, p0_a2 JTF_NUMBER_TABLE
, p0_a3 JTF_DATE_TABLE
, p0_a4 JTF_DATE_TABLE
, p0_a5 JTF_DATE_TABLE
, p0_a6 JTF_NUMBER_TABLE
, p0_a7 JTF_NUMBER_TABLE
, p0_a8 JTF_NUMBER_TABLE
, p0_a9 JTF_NUMBER_TABLE
, p0_a10 JTF_NUMBER_TABLE
, p0_a11 JTF_NUMBER_TABLE
, p0_a12 JTF_NUMBER_TABLE
, p0_a13 JTF_NUMBER_TABLE
, p0_a14 JTF_NUMBER_TABLE
, p0_a15 JTF_NUMBER_TABLE
, p0_a16 JTF_VARCHAR2_TABLE_100
, p0_a17 JTF_VARCHAR2_TABLE_200
, p0_a18 JTF_VARCHAR2_TABLE_200
, p0_a19 JTF_VARCHAR2_TABLE_200
, p0_a20 JTF_VARCHAR2_TABLE_200
, p0_a21 JTF_VARCHAR2_TABLE_200
, p0_a22 JTF_VARCHAR2_TABLE_200
, p0_a23 JTF_VARCHAR2_TABLE_200
, p0_a24 JTF_VARCHAR2_TABLE_200
, p0_a25 JTF_VARCHAR2_TABLE_200
, p0_a26 JTF_VARCHAR2_TABLE_200
, p0_a27 JTF_VARCHAR2_TABLE_200
, p0_a28 JTF_VARCHAR2_TABLE_200
, p0_a29 JTF_VARCHAR2_TABLE_200
, p0_a30 JTF_VARCHAR2_TABLE_200
, p0_a31 JTF_VARCHAR2_TABLE_200
, p0_a32 JTF_VARCHAR2_TABLE_200
, p0_a33 JTF_VARCHAR2_TABLE_200
, p0_a34 JTF_VARCHAR2_TABLE_200
, p0_a35 JTF_VARCHAR2_TABLE_200
, p0_a36 JTF_VARCHAR2_TABLE_200
, p0_a37 JTF_NUMBER_TABLE
, p0_a38 JTF_NUMBER_TABLE
, p0_a39 JTF_NUMBER_TABLE
, p0_a40 JTF_NUMBER_TABLE
, p0_a41 JTF_NUMBER_TABLE
, p0_a42 JTF_NUMBER_TABLE
, p0_a43 JTF_NUMBER_TABLE
, p0_a44 JTF_NUMBER_TABLE
, p0_a45 JTF_VARCHAR2_TABLE_100
, p0_a46 JTF_VARCHAR2_TABLE_100
, p0_a47 JTF_VARCHAR2_TABLE_100
, p_loan_id NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, x_invalid_installment_num out nocopy NUMBER
)
as
ddp_custom_tbl lns_custom_pub.custom_tbl;
lns_custom_pub.updatecustomschedule(ddp_custom_tbl,
p_loan_id,
p_init_msg_list,
p_commit,
x_return_status,
x_msg_count,
x_msg_data,
x_invalid_installment_num);
procedure updatecustomsched(p0_a0 NUMBER
, p0_a1 NUMBER
, p0_a2 NUMBER
, p0_a3 DATE
, p0_a4 DATE
, p0_a5 DATE
, p0_a6 NUMBER
, p0_a7 NUMBER
, p0_a8 NUMBER
, p0_a9 NUMBER
, p0_a10 NUMBER
, p0_a11 NUMBER
, p0_a12 NUMBER
, p0_a13 NUMBER
, p0_a14 NUMBER
, p0_a15 NUMBER
, p0_a16 VARCHAR2
, p0_a17 VARCHAR2
, p0_a18 VARCHAR2
, p0_a19 VARCHAR2
, p0_a20 VARCHAR2
, p0_a21 VARCHAR2
, p0_a22 VARCHAR2
, p0_a23 VARCHAR2
, p0_a24 VARCHAR2
, p0_a25 VARCHAR2
, p0_a26 VARCHAR2
, p0_a27 VARCHAR2
, p0_a28 VARCHAR2
, p0_a29 VARCHAR2
, p0_a30 VARCHAR2
, p0_a31 VARCHAR2
, p0_a32 VARCHAR2
, p0_a33 VARCHAR2
, p0_a34 VARCHAR2
, p0_a35 VARCHAR2
, p0_a36 VARCHAR2
, p0_a37 NUMBER
, p0_a38 NUMBER
, p0_a39 NUMBER
, p0_a40 NUMBER
, p0_a41 NUMBER
, p0_a42 NUMBER
, p0_a43 NUMBER
, p0_a44 NUMBER
, p0_a45 VARCHAR2
, p0_a46 VARCHAR2
, p0_a47 VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_custom_rec lns_custom_pub.custom_sched_type;
lns_custom_pub.updatecustomsched(ddp_custom_rec,
x_return_status,
x_msg_count,
x_msg_data);