1: package body okl_resi_cat_sets_pvt_w as
2: /* $Header: OKLERCSB.pls 120.1 2005/07/08 14:38:53 smadhava noship $ */
3: procedure create_rcs(p_api_version NUMBER
4: , p_init_msg_list VARCHAR2
5: , x_return_status out nocopy VARCHAR2
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
60: )
61:
62: as
63: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
64: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
65: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
66: ddx_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
67: ddindx binary_integer; indx binary_integer;
60: )
61:
62: as
63: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
64: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
65: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
66: ddx_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
67: ddindx binary_integer; indx binary_integer;
68: begin
61:
62: as
63: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
64: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
65: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
66: ddx_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
67: ddindx binary_integer; indx binary_integer;
68: begin
69:
62: as
63: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
64: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
65: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
66: ddx_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
67: ddindx binary_integer; indx binary_integer;
68: begin
69:
70: -- copy data to the local IN or IN-OUT args, if any
104:
105:
106:
107: -- here's the delegated call to the old PL/SQL routine
108: okl_resi_cat_sets_pvt.create_rcs(p_api_version,
109: p_init_msg_list,
110: x_return_status,
111: x_msg_count,
112: x_msg_data,
200: , p7_a13 out nocopy NUMBER
201: )
202:
203: as
204: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
205: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
206: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
207: ddindx binary_integer; indx binary_integer;
208: begin
201: )
202:
203: as
204: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
205: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
206: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
207: ddindx binary_integer; indx binary_integer;
208: begin
209:
202:
203: as
204: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
205: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
206: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
207: ddindx binary_integer; indx binary_integer;
208: begin
209:
210: -- copy data to the local IN or IN-OUT args, if any
243: );
244:
245:
246: -- here's the delegated call to the old PL/SQL routine
247: okl_resi_cat_sets_pvt.update_rcs(p_api_version,
248: p_init_msg_list,
249: x_return_status,
250: x_msg_count,
251: x_msg_data,
324: , p7_a13 out nocopy NUMBER
325: )
326:
327: as
328: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
329: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
330: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
331: ddindx binary_integer; indx binary_integer;
332: begin
325: )
326:
327: as
328: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
329: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
330: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
331: ddindx binary_integer; indx binary_integer;
332: begin
333:
326:
327: as
328: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
329: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
330: ddx_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
331: ddindx binary_integer; indx binary_integer;
332: begin
333:
334: -- copy data to the local IN or IN-OUT args, if any
367: );
368:
369:
370: -- here's the delegated call to the old PL/SQL routine
371: okl_resi_cat_sets_pvt.activate_rcs(p_api_version,
372: p_init_msg_list,
373: x_return_status,
374: x_msg_count,
375: x_msg_data,
420: , p5_a11 JTF_NUMBER_TABLE
421: )
422:
423: as
424: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;
425: ddindx binary_integer; indx binary_integer;
426: begin
427:
428: -- copy data to the local IN or IN-OUT args, if any
445: , p5_a11
446: );
447:
448: -- here's the delegated call to the old PL/SQL routine
449: okl_resi_cat_sets_pvt.delete_objects(p_api_version,
450: p_init_msg_list,
451: x_return_status,
452: x_msg_count,
453: x_msg_data,
460:
461:
462: end;
463:
464: end okl_resi_cat_sets_pvt_w;