DBA Data[Home] [Help]

APPS.OKL_SETUPPDTTEMPLATES_PVT_W dependencies on OKL_SETUPPDTTEMPLATES_PVT

Line 1: package body okl_setuppdttemplates_pvt_w as

1: package body okl_setuppdttemplates_pvt_w as
2: /* $Header: OKLESPTB.pls 115.2 2002/12/24 04:04:10 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 51: ddp_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;

47: , p0_a11 NUMBER := 0-1962.0724
48: )
49:
50: as
51: ddp_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
52: ddx_no_data_found boolean;
53: ddx_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
54: ddindx binary_integer; indx binary_integer;
55: begin

Line 53: ddx_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;

49:
50: as
51: ddp_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
52: ddx_no_data_found boolean;
53: ddx_ptlv_rec okl_setuppdttemplates_pvt.ptlv_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_setuppdttemplates_pvt.get_rec(ddp_ptlv_rec,

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

Line 130: okl_setuppdttemplates_pvt.get_version(p_name,

126:
127:
128:
129: -- here's the delegated call to the old PL/SQL routine
130: okl_setuppdttemplates_pvt.get_version(p_name,
131: p_cur_version,
132: ddp_from_date,
133: ddp_to_date,
134: p_table,

Line 174: okl_setuppdttemplates_pvt.check_overlaps(p_id,

170:
171:
172:
173: -- here's the delegated call to the old PL/SQL routine
174: okl_setuppdttemplates_pvt.check_overlaps(p_id,
175: p_name,
176: ddp_from_date,
177: ddp_to_date,
178: p_table,

Line 229: ddp_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;

225: , p5_a11 NUMBER := 0-1962.0724
226: )
227:
228: as
229: ddp_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
230: ddx_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
231: ddindx binary_integer; indx binary_integer;
232: begin
233:

Line 230: ddx_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;

226: )
227:
228: as
229: ddp_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
230: ddx_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
231: ddindx binary_integer; indx binary_integer;
232: begin
233:
234: -- copy data to the local IN or IN-OUT args, if any

Line 255: okl_setuppdttemplates_pvt.insert_pdttemplates(p_api_version,

251: ddp_ptlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
252:
253:
254: -- here's the delegated call to the old PL/SQL routine
255: okl_setuppdttemplates_pvt.insert_pdttemplates(p_api_version,
256: p_init_msg_list,
257: x_return_status,
258: x_msg_count,
259: x_msg_data,

Line 316: ddp_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;

312: , p5_a11 NUMBER := 0-1962.0724
313: )
314:
315: as
316: ddp_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
317: ddx_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
318: ddindx binary_integer; indx binary_integer;
319: begin
320:

Line 317: ddx_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;

313: )
314:
315: as
316: ddp_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
317: ddx_ptlv_rec okl_setuppdttemplates_pvt.ptlv_rec_type;
318: ddindx binary_integer; indx binary_integer;
319: begin
320:
321: -- copy data to the local IN or IN-OUT args, if any

Line 342: okl_setuppdttemplates_pvt.update_pdttemplates(p_api_version,

338: ddp_ptlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
339:
340:
341: -- here's the delegated call to the old PL/SQL routine
342: okl_setuppdttemplates_pvt.update_pdttemplates(p_api_version,
343: p_init_msg_list,
344: x_return_status,
345: x_msg_count,
346: x_msg_data,

Line 371: end okl_setuppdttemplates_pvt_w;

367: p6_a10 := ddx_ptlv_rec.last_update_date;
368: p6_a11 := rosetta_g_miss_num_map(ddx_ptlv_rec.last_update_login);
369: end;
370:
371: end okl_setuppdttemplates_pvt_w;