DBA Data[Home] [Help]

APPS.OKL_SETUPTQUALITYS_PUB_W dependencies on OKL_SETUPTQUALITYS_PUB

Line 1: package body okl_setuptqualitys_pub_w as

1: package body okl_setuptqualitys_pub_w as
2: /* $Header: OKLUSTQB.pls 115.2 2002/12/24 04:21:45 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 50: ddp_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;

46: , p0_a10 NUMBER := 0-1962.0724
47: )
48:
49: as
50: ddp_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
51: ddx_no_data_found boolean;
52: ddx_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
53: ddindx binary_integer; indx binary_integer;
54: begin

Line 52: ddx_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;

48:
49: as
50: ddp_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
51: ddx_no_data_found boolean;
52: ddx_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
53: ddindx binary_integer; indx binary_integer;
54: begin
55:
56: -- copy data to the local IN or IN-OUT args, if any

Line 74: okl_setuptqualitys_pub.get_rec(ddp_ptqv_rec,

70:
71:
72:
73: -- here's the delegated call to the old PL/SQL routine
74: okl_setuptqualitys_pub.get_rec(ddp_ptqv_rec,
75: x_return_status,
76: x_msg_data,
77: ddx_no_data_found,
78: ddx_ptqv_rec);

Line 134: ddp_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;

130: , p5_a10 NUMBER := 0-1962.0724
131: )
132:
133: as
134: ddp_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
135: ddx_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
136: ddindx binary_integer; indx binary_integer;
137: begin
138:

Line 135: ddx_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;

131: )
132:
133: as
134: ddp_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
135: ddx_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
136: ddindx binary_integer; indx binary_integer;
137: begin
138:
139: -- copy data to the local IN or IN-OUT args, if any

Line 159: okl_setuptqualitys_pub.insert_tqualitys(p_api_version,

155: ddp_ptqv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
156:
157:
158: -- here's the delegated call to the old PL/SQL routine
159: okl_setuptqualitys_pub.insert_tqualitys(p_api_version,
160: p_init_msg_list,
161: x_return_status,
162: x_msg_count,
163: x_msg_data,

Line 217: ddp_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;

213: , p5_a10 NUMBER := 0-1962.0724
214: )
215:
216: as
217: ddp_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
218: ddx_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
219: ddindx binary_integer; indx binary_integer;
220: begin
221:

Line 218: ddx_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;

214: )
215:
216: as
217: ddp_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
218: ddx_ptqv_rec okl_setuptqualitys_pub.ptqv_rec_type;
219: ddindx binary_integer; indx binary_integer;
220: begin
221:
222: -- copy data to the local IN or IN-OUT args, if any

Line 242: okl_setuptqualitys_pub.update_tqualitys(p_api_version,

238: ddp_ptqv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
239:
240:
241: -- here's the delegated call to the old PL/SQL routine
242: okl_setuptqualitys_pub.update_tqualitys(p_api_version,
243: p_init_msg_list,
244: x_return_status,
245: x_msg_count,
246: x_msg_data,

Line 270: end okl_setuptqualitys_pub_w;

266: p6_a9 := ddx_ptqv_rec.last_update_date;
267: p6_a10 := rosetta_g_miss_num_map(ddx_ptqv_rec.last_update_login);
268: end;
269:
270: end okl_setuptqualitys_pub_w;