DBA Data[Home] [Help]

APPS.PV_PRGM_PTR_TYPES_PVT_W dependencies on PV_PRGM_PTR_TYPES_PVT

Line 1: package body pv_prgm_ptr_types_pvt_w as

1: package body pv_prgm_ptr_types_pvt_w as
2: /* $Header: pvxwprpb.pls 115.2 2002/11/27 22:09:38 ktsao 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:

Line 22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 57: procedure rosetta_table_copy_out_p2(t pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p2;
57: procedure rosetta_table_copy_out_p2(t pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
58: , a1 OUT NOCOPY JTF_NUMBER_TABLE
59: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60: , a3 OUT NOCOPY JTF_DATE_TABLE
61: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 141: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;

137: , x_program_partner_types_id OUT NOCOPY NUMBER
138: )
139:
140: as
141: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;
142: ddindx binary_integer; indx binary_integer;
143: begin
144:
145: -- copy data to the local IN or IN-OUT args, if any

Line 165: pv_prgm_ptr_types_pvt.create_prgm_ptr_type(p_api_version_number,

161: ddp_prgm_ptr_types_rec.object_version_number := p7_a8;
162:
163:
164: -- here's the delegated call to the old PL/SQL routine
165: pv_prgm_ptr_types_pvt.create_prgm_ptr_type(p_api_version_number,
166: p_init_msg_list,
167: p_commit,
168: p_validation_level,
169: x_return_status,

Line 205: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;

201: , p7_a8 NUMBER
202: )
203:
204: as
205: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;
206: ddindx binary_integer; indx binary_integer;
207: begin
208:
209: -- copy data to the local IN or IN-OUT args, if any

Line 228: pv_prgm_ptr_types_pvt.update_prgm_ptr_type(p_api_version_number,

224: ddp_prgm_ptr_types_rec.last_update_login := p7_a7;
225: ddp_prgm_ptr_types_rec.object_version_number := p7_a8;
226:
227: -- here's the delegated call to the old PL/SQL routine
228: pv_prgm_ptr_types_pvt.update_prgm_ptr_type(p_api_version_number,
229: p_init_msg_list,
230: p_commit,
231: p_validation_level,
232: x_return_status,

Line 266: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;

262: , x_msg_data OUT NOCOPY VARCHAR2
263: )
264:
265: as
266: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;
267: ddindx binary_integer; indx binary_integer;
268: begin
269:
270: -- copy data to the local IN or IN-OUT args, if any

Line 289: pv_prgm_ptr_types_pvt.validate_prgm_ptr_type(p_api_version_number,

285:
286:
287:
288: -- here's the delegated call to the old PL/SQL routine
289: pv_prgm_ptr_types_pvt.validate_prgm_ptr_type(p_api_version_number,
290: p_init_msg_list,
291: p_validation_level,
292: p_validation_mode,
293: ddp_prgm_ptr_types_rec,

Line 322: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;

318: , x_return_status OUT NOCOPY VARCHAR2
319: )
320:
321: as
322: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;
323: ddindx binary_integer; indx binary_integer;
324: begin
325:
326: -- copy data to the local IN or IN-OUT args, if any

Line 340: pv_prgm_ptr_types_pvt.check_items(ddp_prgm_ptr_types_rec,

336:
337:
338:
339: -- here's the delegated call to the old PL/SQL routine
340: pv_prgm_ptr_types_pvt.check_items(ddp_prgm_ptr_types_rec,
341: p_validation_mode,
342: x_return_status);
343:
344: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 366: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;

362: , p5_a8 NUMBER
363: )
364:
365: as
366: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;
367: ddindx binary_integer; indx binary_integer;
368: begin
369:
370: -- copy data to the local IN or IN-OUT args, if any

Line 387: pv_prgm_ptr_types_pvt.validate_rec(p_api_version_number,

383: ddp_prgm_ptr_types_rec.last_update_login := p5_a7;
384: ddp_prgm_ptr_types_rec.object_version_number := p5_a8;
385:
386: -- here's the delegated call to the old PL/SQL routine
387: pv_prgm_ptr_types_pvt.validate_rec(p_api_version_number,
388: p_init_msg_list,
389: x_return_status,
390: x_msg_count,
391: x_msg_data,

Line 423: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;

419: , p1_a8 OUT NOCOPY NUMBER
420: )
421:
422: as
423: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;
424: ddx_complete_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;
425: ddindx binary_integer; indx binary_integer;
426: begin
427:

Line 424: ddx_complete_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;

420: )
421:
422: as
423: ddp_prgm_ptr_types_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;
424: ddx_complete_rec pv_prgm_ptr_types_pvt.prgm_ptr_types_rec_type;
425: ddindx binary_integer; indx binary_integer;
426: begin
427:
428: -- copy data to the local IN or IN-OUT args, if any

Line 441: pv_prgm_ptr_types_pvt.complete_rec(ddp_prgm_ptr_types_rec,

437: ddp_prgm_ptr_types_rec.object_version_number := p0_a8;
438:
439:
440: -- here's the delegated call to the old PL/SQL routine
441: pv_prgm_ptr_types_pvt.complete_rec(ddp_prgm_ptr_types_rec,
442: ddx_complete_rec);
443:
444: -- copy data back from the local variables to OUT or IN-OUT args, if any
445:

Line 457: end pv_prgm_ptr_types_pvt_w;

453: p1_a7 := ddx_complete_rec.last_update_login;
454: p1_a8 := ddx_complete_rec.object_version_number;
455: end;
456:
457: end pv_prgm_ptr_types_pvt_w;