DBA Data[Home] [Help]

APPS.OKL_SETUPPSTYPES_PUB_W dependencies on OKL_SETUPPSTYPES_PUB

Line 1: package body okl_setuppstypes_pub_w as

1: package body okl_setuppstypes_pub_w as
2: /* $Header: OKLUSPSB.pls 120.1 2005/07/19 07:31:33 asawanka 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_psyv_rec okl_setuppstypes_pub.psyv_rec_type;

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

Line 54: ddx_psyv_rec okl_setuppstypes_pub.psyv_rec_type;

50:
51: as
52: ddp_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
53: ddx_no_data_found boolean;
54: ddx_psyv_rec okl_setuppstypes_pub.psyv_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_setuppstypes_pub.get_rec(ddp_psyv_rec,

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

Line 173: ddp_pdtv_rec okl_setuppstypes_pub.pdtv_rec_type;

169: , p6_a11 NUMBER := 0-1962.0724
170: )
171:
172: as
173: ddp_pdtv_rec okl_setuppstypes_pub.pdtv_rec_type;
174: ddp_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
175: ddx_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
176: ddindx binary_integer; indx binary_integer;
177: begin

Line 174: ddp_psyv_rec okl_setuppstypes_pub.psyv_rec_type;

170: )
171:
172: as
173: ddp_pdtv_rec okl_setuppstypes_pub.pdtv_rec_type;
174: ddp_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
175: ddx_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
176: ddindx binary_integer; indx binary_integer;
177: begin
178:

Line 175: ddx_psyv_rec okl_setuppstypes_pub.psyv_rec_type;

171:
172: as
173: ddp_pdtv_rec okl_setuppstypes_pub.pdtv_rec_type;
174: ddp_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
175: ddx_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
176: ddindx binary_integer; indx binary_integer;
177: begin
178:
179: -- copy data to the local IN or IN-OUT args, if any

Line 234: okl_setuppstypes_pub.insert_pstypes(p_api_version,

230: ddp_psyv_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
231:
232:
233: -- here's the delegated call to the old PL/SQL routine
234: okl_setuppstypes_pub.insert_pstypes(p_api_version,
235: p_init_msg_list,
236: x_return_status,
237: x_msg_count,
238: x_msg_data,

Line 330: ddp_pdtv_rec okl_setuppstypes_pub.pdtv_rec_type;

326: , p6_a11 NUMBER := 0-1962.0724
327: )
328:
329: as
330: ddp_pdtv_rec okl_setuppstypes_pub.pdtv_rec_type;
331: ddp_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
332: ddx_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
333: ddindx binary_integer; indx binary_integer;
334: begin

Line 331: ddp_psyv_rec okl_setuppstypes_pub.psyv_rec_type;

327: )
328:
329: as
330: ddp_pdtv_rec okl_setuppstypes_pub.pdtv_rec_type;
331: ddp_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
332: ddx_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
333: ddindx binary_integer; indx binary_integer;
334: begin
335:

Line 332: ddx_psyv_rec okl_setuppstypes_pub.psyv_rec_type;

328:
329: as
330: ddp_pdtv_rec okl_setuppstypes_pub.pdtv_rec_type;
331: ddp_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
332: ddx_psyv_rec okl_setuppstypes_pub.psyv_rec_type;
333: ddindx binary_integer; indx binary_integer;
334: begin
335:
336: -- copy data to the local IN or IN-OUT args, if any

Line 391: okl_setuppstypes_pub.update_pstypes(p_api_version,

387: ddp_psyv_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
388:
389:
390: -- here's the delegated call to the old PL/SQL routine
391: okl_setuppstypes_pub.update_pstypes(p_api_version,
392: p_init_msg_list,
393: x_return_status,
394: x_msg_count,
395: x_msg_data,

Line 422: end okl_setuppstypes_pub_w;

418: p7_a10 := rosetta_g_miss_num_map(ddx_psyv_rec.last_updated_by);
419: p7_a11 := rosetta_g_miss_num_map(ddx_psyv_rec.last_update_login);
420: end;
421:
422: end okl_setuppstypes_pub_w;