1: package body cn_wksht_ct_up_pub_w as
2: /* $Header: cnwwkcdb.pls 120.0 2005/09/26 15:09:28 fmburu noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
72: , x_loading_status out nocopy VARCHAR2
73: )
74:
75: as
76: ddp_old_srp_pmt_plans_rec cn_wksht_ct_up_pub.srp_pmt_plans_rec_type;
77: ddp_srp_pmt_plans_rec cn_wksht_ct_up_pub.srp_pmt_plans_rec_type;
78: ddindx binary_integer; indx binary_integer;
79: begin
80:
73: )
74:
75: as
76: ddp_old_srp_pmt_plans_rec cn_wksht_ct_up_pub.srp_pmt_plans_rec_type;
77: ddp_srp_pmt_plans_rec cn_wksht_ct_up_pub.srp_pmt_plans_rec_type;
78: ddindx binary_integer; indx binary_integer;
79: begin
80:
81: -- copy data to the local IN or IN-OUT args, if any
141:
142:
143:
144: -- here's the delegated call to the old PL/SQL routine
145: cn_wksht_ct_up_pub.apply_payment_plan_upd(p_api_version,
146: p_init_msg_list,
147: p_commit,
148: p_validation_level,
149: x_return_status,
211: , x_loading_status out nocopy VARCHAR2
212: )
213:
214: as
215: ddp_srp_pmt_plans_rec cn_wksht_ct_up_pub.srp_pmt_plans_rec_type;
216: ddindx binary_integer; indx binary_integer;
217: begin
218:
219: -- copy data to the local IN or IN-OUT args, if any
254:
255:
256:
257: -- here's the delegated call to the old PL/SQL routine
258: cn_wksht_ct_up_pub.apply_payment_plan_cre(p_api_version,
259: p_init_msg_list,
260: p_commit,
261: p_validation_level,
262: x_return_status,
322: , x_loading_status out nocopy VARCHAR2
323: )
324:
325: as
326: ddp_srp_pmt_plans_rec cn_wksht_ct_up_pub.srp_pmt_plans_rec_type;
327: ddindx binary_integer; indx binary_integer;
328: begin
329:
330: -- copy data to the local IN or IN-OUT args, if any
365:
366:
367:
368: -- here's the delegated call to the old PL/SQL routine
369: cn_wksht_ct_up_pub.apply_payment_plan_del(p_api_version,
370: p_init_msg_list,
371: p_commit,
372: p_validation_level,
373: x_return_status,
394:
395:
396: end;
397:
398: end cn_wksht_ct_up_pub_w;