APPS.OKL_SETUPTQYVALUES_PUB_W dependencies on OKL_SETUPTQYVALUES_PUB

Line 1: package body okl_setuptqyvalues_pub_w as

1: package body okl_setuptqyvalues_pub_w as
2: /* $Header: OKLUSEVB.pls 115.2 2002/12/24 04:18:39 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_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;

48: , p0_a11 NUMBER := 0-1962.0724
49: )
50:
51: as
52: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
53: ddx_no_data_found boolean;
54: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
55: ddindx binary_integer; indx binary_integer;
56: begin

Line 54: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;

50:
51: as
52: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
53: ddx_no_data_found boolean;
54: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_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_setuptqyvalues_pub.get_rec(ddp_ptvv_rec,

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

Line 151: ddp_ptqv_rec okl_setuptqyvalues_pub.ptqv_rec_type;

147: , p6_a11 NUMBER := 0-1962.0724
148: )
149:
150: as
151: ddp_ptqv_rec okl_setuptqyvalues_pub.ptqv_rec_type;
152: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
153: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
154: ddindx binary_integer; indx binary_integer;
155: begin

Line 152: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;

148: )
149:
150: as
151: ddp_ptqv_rec okl_setuptqyvalues_pub.ptqv_rec_type;
152: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
153: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
154: ddindx binary_integer; indx binary_integer;
155: begin
156:

Line 153: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;

149:
150: as
151: ddp_ptqv_rec okl_setuptqyvalues_pub.ptqv_rec_type;
152: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
153: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
154: ddindx binary_integer; indx binary_integer;
155: begin
156:
157: -- copy data to the local IN or IN-OUT args, if any

Line 190: okl_setuptqyvalues_pub.insert_tqyvalues(p_api_version,

186: ddp_ptvv_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
187:
188:
189: -- here's the delegated call to the old PL/SQL routine
190: okl_setuptqyvalues_pub.insert_tqyvalues(p_api_version,
191: p_init_msg_list,
192: x_return_status,
193: x_msg_count,
194: x_msg_data,

Line 264: ddp_ptqv_rec okl_setuptqyvalues_pub.ptqv_rec_type;

260: , p6_a11 NUMBER := 0-1962.0724
261: )
262:
263: as
264: ddp_ptqv_rec okl_setuptqyvalues_pub.ptqv_rec_type;
265: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
266: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
267: ddindx binary_integer; indx binary_integer;
268: begin

Line 265: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;

261: )
262:
263: as
264: ddp_ptqv_rec okl_setuptqyvalues_pub.ptqv_rec_type;
265: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
266: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
267: ddindx binary_integer; indx binary_integer;
268: begin
269:

Line 266: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;

262:
263: as
264: ddp_ptqv_rec okl_setuptqyvalues_pub.ptqv_rec_type;
265: ddp_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
266: ddx_ptvv_rec okl_setuptqyvalues_pub.ptvv_rec_type;
267: ddindx binary_integer; indx binary_integer;
268: begin
269:
270: -- copy data to the local IN or IN-OUT args, if any

Line 303: okl_setuptqyvalues_pub.update_tqyvalues(p_api_version,

299: ddp_ptvv_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_setuptqyvalues_pub.update_tqyvalues(p_api_version,
304: p_init_msg_list,
305: x_return_status,
306: x_msg_count,
307: x_msg_data,

Line 334: end okl_setuptqyvalues_pub_w;

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