APPS.OKL_SETUPPQYVALUES_PUB_W dependencies on OKL_SETUPPQYVALUES_PUB

Line 1: package body okl_setuppqyvalues_pub_w as

1: package body okl_setuppqyvalues_pub_w as
2: /* $Header: OKLUSQVB.pls 115.2 2002/12/24 04:21:11 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 52: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;

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

Line 54: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;

50:
51: as
52: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
53: ddx_no_data_found boolean;
54: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
55: ddindx binary_integer; indx binary_integer;
56: begin
57:
58: -- copy data to the local IN or IN-OUT args, if any

Line 77: okl_setuppqyvalues_pub.get_rec(ddp_qvev_rec,

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

Line 152: ddp_pqyv_rec okl_setuppqyvalues_pub.pqyv_rec_type;

148: , p6_a11 NUMBER := 0-1962.0724
149: )
150:
151: as
152: ddp_pqyv_rec okl_setuppqyvalues_pub.pqyv_rec_type;
153: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
154: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
155: ddindx binary_integer; indx binary_integer;
156: begin

Line 153: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;

149: )
150:
151: as
152: ddp_pqyv_rec okl_setuppqyvalues_pub.pqyv_rec_type;
153: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
154: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
155: ddindx binary_integer; indx binary_integer;
156: begin
157:

Line 154: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;

150:
151: as
152: ddp_pqyv_rec okl_setuppqyvalues_pub.pqyv_rec_type;
153: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
154: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
155: ddindx binary_integer; indx binary_integer;
156: begin
157:
158: -- copy data to the local IN or IN-OUT args, if any

Line 192: okl_setuppqyvalues_pub.insert_pqyvalues(p_api_version,

188: ddp_qvev_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
189:
190:
191: -- here's the delegated call to the old PL/SQL routine
192: okl_setuppqyvalues_pub.insert_pqyvalues(p_api_version,
193: p_init_msg_list,
194: x_return_status,
195: x_msg_count,
196: x_msg_data,

Line 267: ddp_pqyv_rec okl_setuppqyvalues_pub.pqyv_rec_type;

263: , p6_a11 NUMBER := 0-1962.0724
264: )
265:
266: as
267: ddp_pqyv_rec okl_setuppqyvalues_pub.pqyv_rec_type;
268: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
269: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
270: ddindx binary_integer; indx binary_integer;
271: begin

Line 268: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;

264: )
265:
266: as
267: ddp_pqyv_rec okl_setuppqyvalues_pub.pqyv_rec_type;
268: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
269: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
270: ddindx binary_integer; indx binary_integer;
271: begin
272:

Line 269: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;

265:
266: as
267: ddp_pqyv_rec okl_setuppqyvalues_pub.pqyv_rec_type;
268: ddp_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
269: ddx_qvev_rec okl_setuppqyvalues_pub.qvev_rec_type;
270: ddindx binary_integer; indx binary_integer;
271: begin
272:
273: -- copy data to the local IN or IN-OUT args, if any

Line 307: okl_setuppqyvalues_pub.update_pqyvalues(p_api_version,

303: ddp_qvev_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
304:
305:
306: -- here's the delegated call to the old PL/SQL routine
307: okl_setuppqyvalues_pub.update_pqyvalues(p_api_version,
308: p_init_msg_list,
309: x_return_status,
310: x_msg_count,
311: x_msg_data,

Line 338: end okl_setuppqyvalues_pub_w;

334: p7_a10 := ddx_qvev_rec.last_update_date;
335: p7_a11 := rosetta_g_miss_num_map(ddx_qvev_rec.last_update_login);
336: end;
337:
338: end okl_setuppqyvalues_pub_w;