APPS.OKL_SETUPPSTYPES_PVT_W dependencies on OKL_SETUPPSTYPES_PVT

Line 1: package body okl_setuppstypes_pvt_w as

1: package body okl_setuppstypes_pvt_w as
2: /* $Header: OKLESPSB.pls 120.1 2005/07/12 09:10:45 dkagrawa 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 51: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;

47: , p0_a11 NUMBER := 0-1962.0724
48: )
49:
50: as
51: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
52: ddx_no_data_found boolean;
53: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
54: ddindx binary_integer; indx binary_integer;
55: begin

Line 53: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;

49:
50: as
51: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
52: ddx_no_data_found boolean;
53: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
54: ddindx binary_integer; indx binary_integer;
55: begin
56:
57: -- copy data to the local IN or IN-OUT args, if any

Line 75: okl_setuppstypes_pvt.get_rec(ddp_psyv_rec,

71:
72:
73:
74: -- here's the delegated call to the old PL/SQL routine
75: okl_setuppstypes_pvt.get_rec(ddp_psyv_rec,
76: ddx_no_data_found,
77: x_return_status,
78: ddx_psyv_rec);
79:

Line 169: ddp_pdtv_rec okl_setuppstypes_pvt.pdtv_rec_type;

165: , p6_a11 NUMBER := 0-1962.0724
166: )
167:
168: as
169: ddp_pdtv_rec okl_setuppstypes_pvt.pdtv_rec_type;
170: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
171: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
172: ddindx binary_integer; indx binary_integer;
173: begin

Line 170: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;

166: )
167:
168: as
169: ddp_pdtv_rec okl_setuppstypes_pvt.pdtv_rec_type;
170: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
171: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
172: ddindx binary_integer; indx binary_integer;
173: begin
174:

Line 171: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;

167:
168: as
169: ddp_pdtv_rec okl_setuppstypes_pvt.pdtv_rec_type;
170: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
171: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
172: ddindx binary_integer; indx binary_integer;
173: begin
174:
175: -- copy data to the local IN or IN-OUT args, if any

Line 230: okl_setuppstypes_pvt.insert_pstypes(p_api_version,

226: ddp_psyv_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
227:
228:
229: -- here's the delegated call to the old PL/SQL routine
230: okl_setuppstypes_pvt.insert_pstypes(p_api_version,
231: p_init_msg_list,
232: x_return_status,
233: x_msg_count,
234: x_msg_data,

Line 326: ddp_pdtv_rec okl_setuppstypes_pvt.pdtv_rec_type;

322: , p6_a11 NUMBER := 0-1962.0724
323: )
324:
325: as
326: ddp_pdtv_rec okl_setuppstypes_pvt.pdtv_rec_type;
327: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
328: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
329: ddindx binary_integer; indx binary_integer;
330: begin

Line 327: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;

323: )
324:
325: as
326: ddp_pdtv_rec okl_setuppstypes_pvt.pdtv_rec_type;
327: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
328: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
329: ddindx binary_integer; indx binary_integer;
330: begin
331:

Line 328: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;

324:
325: as
326: ddp_pdtv_rec okl_setuppstypes_pvt.pdtv_rec_type;
327: ddp_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
328: ddx_psyv_rec okl_setuppstypes_pvt.psyv_rec_type;
329: ddindx binary_integer; indx binary_integer;
330: begin
331:
332: -- copy data to the local IN or IN-OUT args, if any

Line 387: okl_setuppstypes_pvt.update_pstypes(p_api_version,

383: ddp_psyv_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
384:
385:
386: -- here's the delegated call to the old PL/SQL routine
387: okl_setuppstypes_pvt.update_pstypes(p_api_version,
388: p_init_msg_list,
389: x_return_status,
390: x_msg_count,
391: x_msg_data,

Line 418: end okl_setuppstypes_pvt_w;

414: p7_a10 := rosetta_g_miss_num_map(ddx_psyv_rec.last_updated_by);
415: p7_a11 := rosetta_g_miss_num_map(ddx_psyv_rec.last_update_login);
416: end;
417:
418: end okl_setuppstypes_pvt_w;