APPS.PV_PRGM_BENEFITS_PVT_W dependencies on PV_PRGM_BENEFITS_PVT

Line 1: package body pv_prgm_benefits_pvt_w as

1: package body pv_prgm_benefits_pvt_w as
2: /* $Header: pvxwppbb.pls 115.6 2003/11/07 06:13:58 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 13: procedure rosetta_table_copy_in_p2(t out nocopy pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100

Line 54: procedure rosetta_table_copy_out_p2(t pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

50: end loop;
51: end if;
52: end if;
53: end rosetta_table_copy_in_p2;
54: procedure rosetta_table_copy_out_p2(t pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_VARCHAR2_TABLE_100
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;

152: , x_program_benefits_id out nocopy NUMBER
153: )
154:
155: as
156: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;
157: ddindx binary_integer; indx binary_integer;
158: begin
159:
160: -- copy data to the local IN or IN-OUT args, if any

Line 183: pv_prgm_benefits_pvt.create_prgm_benefits(p_api_version_number,

179: ddp_prgm_benefits_rec.creation_date := rosetta_g_miss_date_in_map(p7_a11);
180:
181:
182: -- here's the delegated call to the old PL/SQL routine
183: pv_prgm_benefits_pvt.create_prgm_benefits(p_api_version_number,
184: p_init_msg_list,
185: p_commit,
186: p_validation_level,
187: x_return_status,

Line 226: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;

222: , p7_a11 DATE
223: )
224:
225: as
226: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;
227: ddindx binary_integer; indx binary_integer;
228: begin
229:
230: -- copy data to the local IN or IN-OUT args, if any

Line 252: pv_prgm_benefits_pvt.update_prgm_benefits(p_api_version_number,

248: ddp_prgm_benefits_rec.created_by := p7_a10;
249: ddp_prgm_benefits_rec.creation_date := rosetta_g_miss_date_in_map(p7_a11);
250:
251: -- here's the delegated call to the old PL/SQL routine
252: pv_prgm_benefits_pvt.update_prgm_benefits(p_api_version_number,
253: p_init_msg_list,
254: p_commit,
255: p_validation_level,
256: x_return_status,

Line 293: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;

289: , x_msg_data out nocopy VARCHAR2
290: )
291:
292: as
293: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;
294: ddindx binary_integer; indx binary_integer;
295: begin
296:
297: -- copy data to the local IN or IN-OUT args, if any

Line 319: pv_prgm_benefits_pvt.validate_prgm_benefits(p_api_version_number,

315:
316:
317:
318: -- here's the delegated call to the old PL/SQL routine
319: pv_prgm_benefits_pvt.validate_prgm_benefits(p_api_version_number,
320: p_init_msg_list,
321: p_validation_level,
322: ddp_prgm_benefits_rec,
323: p_validation_mode,

Line 355: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;

351: , x_return_status out nocopy VARCHAR2
352: )
353:
354: as
355: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;
356: ddindx binary_integer; indx binary_integer;
357: begin
358:
359: -- copy data to the local IN or IN-OUT args, if any

Line 376: pv_prgm_benefits_pvt.check_items(ddp_prgm_benefits_rec,

372:
373:
374:
375: -- here's the delegated call to the old PL/SQL routine
376: pv_prgm_benefits_pvt.check_items(ddp_prgm_benefits_rec,
377: p_validation_mode,
378: x_return_status);
379:
380: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 406: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;

402: , p_validation_mode VARCHAR2
403: )
404:
405: as
406: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;
407: ddindx binary_integer; indx binary_integer;
408: begin
409:
410: -- copy data to the local IN or IN-OUT args, if any

Line 431: pv_prgm_benefits_pvt.validate_rec(p_api_version_number,

427: ddp_prgm_benefits_rec.creation_date := rosetta_g_miss_date_in_map(p5_a11);
428:
429:
430: -- here's the delegated call to the old PL/SQL routine
431: pv_prgm_benefits_pvt.validate_rec(p_api_version_number,
432: p_init_msg_list,
433: x_return_status,
434: x_msg_count,
435: x_msg_data,

Line 475: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;

471: , p1_a11 out nocopy DATE
472: )
473:
474: as
475: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;
476: ddx_complete_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;
477: ddindx binary_integer; indx binary_integer;
478: begin
479:

Line 476: ddx_complete_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;

472: )
473:
474: as
475: ddp_prgm_benefits_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;
476: ddx_complete_rec pv_prgm_benefits_pvt.prgm_benefits_rec_type;
477: ddindx binary_integer; indx binary_integer;
478: begin
479:
480: -- copy data to the local IN or IN-OUT args, if any

Line 496: pv_prgm_benefits_pvt.complete_rec(ddp_prgm_benefits_rec,

492: ddp_prgm_benefits_rec.creation_date := rosetta_g_miss_date_in_map(p0_a11);
493:
494:
495: -- here's the delegated call to the old PL/SQL routine
496: pv_prgm_benefits_pvt.complete_rec(ddp_prgm_benefits_rec,
497: ddx_complete_rec);
498:
499: -- copy data back from the local variables to OUT or IN-OUT args, if any
500:

Line 515: end pv_prgm_benefits_pvt_w;

511: p1_a10 := ddx_complete_rec.created_by;
512: p1_a11 := ddx_complete_rec.creation_date;
513: end;
514:
515: end pv_prgm_benefits_pvt_w;