1: package body okl_setuppoptions_pvt_w as
2: /* $Header: OKLESPOB.pls 115.3 2002/12/24 04:03:36 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:
47: , p0_a11 NUMBER := 0-1962.0724
48: )
49:
50: as
51: ddp_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
52: ddx_no_data_found boolean;
53: ddx_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
54: ddindx binary_integer; indx binary_integer;
55: begin
49:
50: as
51: ddp_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
52: ddx_no_data_found boolean;
53: ddx_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
54: ddindx binary_integer; indx binary_integer;
55: begin
56:
57: -- copy data to the local IN or IN-OUT args, if any
71:
72:
73:
74: -- here's the delegated call to the old PL/SQL routine
75: okl_setuppoptions_pvt.get_rec(ddp_ponv_rec,
76: ddx_no_data_found,
77: x_return_status,
78: ddx_ponv_rec);
79:
164: , p6_a11 NUMBER := 0-1962.0724
165: )
166:
167: as
168: ddp_pdtv_rec okl_setuppoptions_pvt.pdtv_rec_type;
169: ddp_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
170: ddx_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
171: ddindx binary_integer; indx binary_integer;
172: begin
165: )
166:
167: as
168: ddp_pdtv_rec okl_setuppoptions_pvt.pdtv_rec_type;
169: ddp_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
170: ddx_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
171: ddindx binary_integer; indx binary_integer;
172: begin
173:
166:
167: as
168: ddp_pdtv_rec okl_setuppoptions_pvt.pdtv_rec_type;
169: ddp_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
170: ddx_ponv_rec okl_setuppoptions_pvt.ponv_rec_type;
171: ddindx binary_integer; indx binary_integer;
172: begin
173:
174: -- copy data to the local IN or IN-OUT args, if any
224: ddp_ponv_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
225:
226:
227: -- here's the delegated call to the old PL/SQL routine
228: okl_setuppoptions_pvt.insert_poptions(p_api_version,
229: p_init_msg_list,
230: x_return_status,
231: x_msg_count,
232: x_msg_data,
307: , p5_a31 NUMBER := 0-1962.0724
308: )
309:
310: as
311: ddp_pdtv_rec okl_setuppoptions_pvt.pdtv_rec_type;
312: ddp_ponv_tbl okl_setuppoptions_pvt.ponv_tbl_type;
313: ddindx binary_integer; indx binary_integer;
314: begin
315:
308: )
309:
310: as
311: ddp_pdtv_rec okl_setuppoptions_pvt.pdtv_rec_type;
312: ddp_ponv_tbl okl_setuppoptions_pvt.ponv_tbl_type;
313: ddindx binary_integer; indx binary_integer;
314: begin
315:
316: -- copy data to the local IN or IN-OUT args, if any
366: , p6_a11
367: );
368:
369: -- here's the delegated call to the old PL/SQL routine
370: okl_setuppoptions_pvt.delete_poptions(p_api_version,
371: p_init_msg_list,
372: x_return_status,
373: x_msg_count,
374: x_msg_data,
383:
384:
385: end;
386:
387: end okl_setuppoptions_pvt_w;