DBA Data[Home] [Help]

APPS.OKL_SETUPPQUALITYS_PUB_W dependencies on OKL_SETUPPQUALITYS_PUB

Line 1: package body okl_setuppqualitys_pub_w as

1: package body okl_setuppqualitys_pub_w as
2: /* $Header: OKLUSPQB.pls 115.2 2002/12/24 04:20:44 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_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;

48: , p0_a11 NUMBER := 0-1962.0724
49: )
50:
51: as
52: ddp_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
53: ddx_no_data_found boolean;
54: ddx_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
55: ddindx binary_integer; indx binary_integer;
56: begin

Line 54: ddx_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;

50:
51: as
52: ddp_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
53: ddx_no_data_found boolean;
54: ddx_pqyv_rec okl_setuppqualitys_pub.pqyv_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_setuppqualitys_pub.get_rec(ddp_pqyv_rec,

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

Line 140: ddp_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;

136: , p5_a11 NUMBER := 0-1962.0724
137: )
138:
139: as
140: ddp_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
141: ddx_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
142: ddindx binary_integer; indx binary_integer;
143: begin
144:

Line 141: ddx_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;

137: )
138:
139: as
140: ddp_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
141: ddx_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
142: ddindx binary_integer; indx binary_integer;
143: begin
144:
145: -- copy data to the local IN or IN-OUT args, if any

Line 166: okl_setuppqualitys_pub.insert_pqualitys(p_api_version,

162: ddp_pqyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
163:
164:
165: -- here's the delegated call to the old PL/SQL routine
166: okl_setuppqualitys_pub.insert_pqualitys(p_api_version,
167: p_init_msg_list,
168: x_return_status,
169: x_msg_count,
170: x_msg_data,

Line 227: ddp_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;

223: , p5_a11 NUMBER := 0-1962.0724
224: )
225:
226: as
227: ddp_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
228: ddx_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
229: ddindx binary_integer; indx binary_integer;
230: begin
231:

Line 228: ddx_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;

224: )
225:
226: as
227: ddp_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
228: ddx_pqyv_rec okl_setuppqualitys_pub.pqyv_rec_type;
229: ddindx binary_integer; indx binary_integer;
230: begin
231:
232: -- copy data to the local IN or IN-OUT args, if any

Line 253: okl_setuppqualitys_pub.update_pqualitys(p_api_version,

249: ddp_pqyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
250:
251:
252: -- here's the delegated call to the old PL/SQL routine
253: okl_setuppqualitys_pub.update_pqualitys(p_api_version,
254: p_init_msg_list,
255: x_return_status,
256: x_msg_count,
257: x_msg_data,

Line 282: end okl_setuppqualitys_pub_w;

278: p6_a10 := ddx_pqyv_rec.last_update_date;
279: p6_a11 := rosetta_g_miss_num_map(ddx_pqyv_rec.last_update_login);
280: end;
281:
282: end okl_setuppqualitys_pub_w;