1: package body okl_setupovdtemplates_pvt_w as
2: /* $Header: OKLESVTB.pls 115.2 2002/12/24 04:05:26 sgorantl 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:
43: , p0_a9 NUMBER := 0-1962.0724
44: )
45:
46: as
47: ddp_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
48: ddx_no_data_found boolean;
49: ddx_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
50: ddindx binary_integer; indx binary_integer;
51: begin
45:
46: as
47: ddp_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
48: ddx_no_data_found boolean;
49: ddx_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
50: ddindx binary_integer; indx binary_integer;
51: begin
52:
53: -- copy data to the local IN or IN-OUT args, if any
65:
66:
67:
68: -- here's the delegated call to the old PL/SQL routine
69: okl_setupovdtemplates_pvt.get_rec(ddp_ovtv_rec,
70: x_return_status,
71: ddx_no_data_found,
72: ddx_ovtv_rec);
73:
174: , p8_a9 NUMBER := 0-1962.0724
175: )
176:
177: as
178: ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
179: ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
180: ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
181: ddp_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
182: ddx_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
175: )
176:
177: as
178: ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
179: ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
180: ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
181: ddp_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
182: ddx_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
183: ddindx binary_integer; indx binary_integer;
176:
177: as
178: ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
179: ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
180: ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
181: ddp_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
182: ddx_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
183: ddindx binary_integer; indx binary_integer;
184: begin
177: as
178: ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
179: ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
180: ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
181: ddp_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
182: ddx_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
183: ddindx binary_integer; indx binary_integer;
184: begin
185:
178: ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
179: ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
180: ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
181: ddp_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
182: ddx_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
183: ddindx binary_integer; indx binary_integer;
184: begin
185:
186: -- copy data to the local IN or IN-OUT args, if any
258: ddp_ovtv_rec.last_update_login := rosetta_g_miss_num_map(p8_a9);
259:
260:
261: -- here's the delegated call to the old PL/SQL routine
262: okl_setupovdtemplates_pvt.insert_ovdtemplates(p_api_version,
263: p_init_msg_list,
264: x_return_status,
265: x_msg_count,
266: x_msg_data,
363: , p7_a14 NUMBER := 0-1962.0724
364: )
365:
366: as
367: ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
368: ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
369: ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
370: ddp_ovtv_tbl okl_setupovdtemplates_pvt.ovtv_tbl_type;
371: ddindx binary_integer; indx binary_integer;
364: )
365:
366: as
367: ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
368: ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
369: ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
370: ddp_ovtv_tbl okl_setupovdtemplates_pvt.ovtv_tbl_type;
371: ddindx binary_integer; indx binary_integer;
372: begin
365:
366: as
367: ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
368: ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
369: ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
370: ddp_ovtv_tbl okl_setupovdtemplates_pvt.ovtv_tbl_type;
371: ddindx binary_integer; indx binary_integer;
372: begin
373:
366: as
367: ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
368: ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
369: ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
370: ddp_ovtv_tbl okl_setupovdtemplates_pvt.ovtv_tbl_type;
371: ddindx binary_integer; indx binary_integer;
372: begin
373:
374: -- copy data to the local IN or IN-OUT args, if any
446: , p8_a9
447: );
448:
449: -- here's the delegated call to the old PL/SQL routine
450: okl_setupovdtemplates_pvt.delete_ovdtemplates(p_api_version,
451: p_init_msg_list,
452: x_return_status,
453: x_msg_count,
454: x_msg_data,
467:
468:
469: end;
470:
471: end okl_setupovdtemplates_pvt_w;