APPS.OKL_SETUPPQYVALUES_PVT_W dependencies on OKL_SETUPPQYVALUES_PVT

Line 1: package body okl_setuppqyvalues_pvt_w as

1: package body okl_setuppqyvalues_pvt_w as
2: /* $Header: OKLESQVB.pls 115.2 2002/12/24 04:04:27 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:

Line 51: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;

47: , p0_a11 NUMBER := 0-1962.0724
48: )
49:
50: as
51: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
52: ddx_no_data_found boolean;
53: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
54: ddindx binary_integer; indx binary_integer;
55: begin

Line 53: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;

49:
50: as
51: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
52: ddx_no_data_found boolean;
53: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_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

Line 75: okl_setuppqyvalues_pvt.get_rec(ddp_qvev_rec,

71:
72:
73:
74: -- here's the delegated call to the old PL/SQL routine
75: okl_setuppqyvalues_pvt.get_rec(ddp_qvev_rec,
76: ddx_no_data_found,
77: x_return_status,
78: ddx_qvev_rec);
79:

Line 148: ddp_pqyv_rec okl_setuppqyvalues_pvt.pqyv_rec_type;

144: , p6_a11 NUMBER := 0-1962.0724
145: )
146:
147: as
148: ddp_pqyv_rec okl_setuppqyvalues_pvt.pqyv_rec_type;
149: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
150: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
151: ddindx binary_integer; indx binary_integer;
152: begin

Line 149: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;

145: )
146:
147: as
148: ddp_pqyv_rec okl_setuppqyvalues_pvt.pqyv_rec_type;
149: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
150: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
151: ddindx binary_integer; indx binary_integer;
152: begin
153:

Line 150: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;

146:
147: as
148: ddp_pqyv_rec okl_setuppqyvalues_pvt.pqyv_rec_type;
149: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
150: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
151: ddindx binary_integer; indx binary_integer;
152: begin
153:
154: -- copy data to the local IN or IN-OUT args, if any

Line 188: okl_setuppqyvalues_pvt.insert_pqyvalues(p_api_version,

184: ddp_qvev_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
185:
186:
187: -- here's the delegated call to the old PL/SQL routine
188: okl_setuppqyvalues_pvt.insert_pqyvalues(p_api_version,
189: p_init_msg_list,
190: x_return_status,
191: x_msg_count,
192: x_msg_data,

Line 263: ddp_pqyv_rec okl_setuppqyvalues_pvt.pqyv_rec_type;

259: , p6_a11 NUMBER := 0-1962.0724
260: )
261:
262: as
263: ddp_pqyv_rec okl_setuppqyvalues_pvt.pqyv_rec_type;
264: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
265: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
266: ddindx binary_integer; indx binary_integer;
267: begin

Line 264: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;

260: )
261:
262: as
263: ddp_pqyv_rec okl_setuppqyvalues_pvt.pqyv_rec_type;
264: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
265: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
266: ddindx binary_integer; indx binary_integer;
267: begin
268:

Line 265: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;

261:
262: as
263: ddp_pqyv_rec okl_setuppqyvalues_pvt.pqyv_rec_type;
264: ddp_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
265: ddx_qvev_rec okl_setuppqyvalues_pvt.qvev_rec_type;
266: ddindx binary_integer; indx binary_integer;
267: begin
268:
269: -- copy data to the local IN or IN-OUT args, if any

Line 303: okl_setuppqyvalues_pvt.update_pqyvalues(p_api_version,

299: ddp_qvev_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
300:
301:
302: -- here's the delegated call to the old PL/SQL routine
303: okl_setuppqyvalues_pvt.update_pqyvalues(p_api_version,
304: p_init_msg_list,
305: x_return_status,
306: x_msg_count,
307: x_msg_data,

Line 334: end okl_setuppqyvalues_pvt_w;

330: p7_a10 := ddx_qvev_rec.last_update_date;
331: p7_a11 := rosetta_g_miss_num_map(ddx_qvev_rec.last_update_login);
332: end;
333:
334: end okl_setuppqyvalues_pvt_w;