DBA Data[Home] [Help]

APPS.OKL_SETUPDQUALITYS_PUB_W dependencies on OKL_SETUPDQUALITYS_PUB

Line 1: package body okl_setupdqualitys_pub_w as

1: package body okl_setupdqualitys_pub_w as
2: /* $Header: OKLUSDQB.pls 120.2 2007/03/04 10:08:28 dcshanmu ship $ */
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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 53: ddp_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;

49: , p0_a10 NUMBER := 0-1962.0724
50: )
51:
52: as
53: ddp_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
54: ddx_no_data_found boolean;
55: ddx_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
56: ddindx binary_integer; indx binary_integer;
57: begin

Line 55: ddx_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;

51:
52: as
53: ddp_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
54: ddx_no_data_found boolean;
55: ddx_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
56: ddindx binary_integer; indx binary_integer;
57: begin
58:
59: -- copy data to the local IN or IN-OUT args, if any

Line 77: okl_setupdqualitys_pub.get_rec(ddp_pdqv_rec,

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

Line 149: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;

145: , p6_a10 NUMBER := 0-1962.0724
146: )
147:
148: as
149: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;
150: ddp_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
151: ddx_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
152: ddindx binary_integer; indx binary_integer;
153: begin

Line 150: ddp_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;

146: )
147:
148: as
149: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;
150: ddp_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
151: ddx_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
152: ddindx binary_integer; indx binary_integer;
153: begin
154:

Line 151: ddx_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;

147:
148: as
149: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;
150: ddp_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
151: ddx_pdqv_rec okl_setupdqualitys_pub.pdqv_rec_type;
152: ddindx binary_integer; indx binary_integer;
153: begin
154:
155: -- copy data to the local IN or IN-OUT args, if any

Line 188: okl_setupdqualitys_pub.insert_dqualitys(p_api_version,

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

Line 260: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;

256: , p5_a11 NUMBER := 0-1962.0724
257: )
258:
259: as
260: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;
261: ddp_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;
262: ddx_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;
263: ddindx binary_integer; indx binary_integer;
264: begin

Line 261: ddp_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;

257: )
258:
259: as
260: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;
261: ddp_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;
262: ddx_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;
263: ddindx binary_integer; indx binary_integer;
264: begin
265:

Line 262: ddx_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;

258:
259: as
260: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;
261: ddp_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;
262: ddx_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;
263: ddindx binary_integer; indx binary_integer;
264: begin
265:
266: -- copy data to the local IN or IN-OUT args, if any

Line 300: okl_setupdqualitys_pub.insert_dqualitys(p_api_version,

296: );
297:
298:
299: -- here's the delegated call to the old PL/SQL routine
300: okl_setupdqualitys_pub.insert_dqualitys(p_api_version,
301: p_init_msg_list,
302: x_return_status,
303: x_msg_count,
304: x_msg_data,

Line 362: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;

358: , p5_a11 NUMBER := 0-1962.0724
359: )
360:
361: as
362: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;
363: ddp_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;
364: ddindx binary_integer; indx binary_integer;
365: begin
366:

Line 363: ddp_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;

359: )
360:
361: as
362: ddp_ptlv_rec okl_setupdqualitys_pub.ptlv_rec_type;
363: ddp_pdqv_tbl okl_setupdqualitys_pub.pdqv_tbl_type;
364: ddindx binary_integer; indx binary_integer;
365: begin
366:
367: -- copy data to the local IN or IN-OUT args, if any

Line 400: okl_setupdqualitys_pub.delete_dqualitys(p_api_version,

396: , p6_a10
397: );
398:
399: -- here's the delegated call to the old PL/SQL routine
400: okl_setupdqualitys_pub.delete_dqualitys(p_api_version,
401: p_init_msg_list,
402: x_return_status,
403: x_msg_count,
404: x_msg_data,

Line 417: end okl_setupdqualitys_pub_w;

413:
414:
415: end;
416:
417: end okl_setupdqualitys_pub_w;