APPS.AHL_VWP_VISITS_STAGES_PVT_W dependencies on AHL_VWP_VISITS_STAGES_PVT

Line 1: package body ahl_vwp_visits_stages_pvt_w as

1: package body ahl_vwp_visits_stages_pvt_w as
2: /* $Header: AHLWSTGB.pls 120.0 2005/05/25 23:53:15 appldev 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 13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_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 ahl_vwp_visits_stages_pvt.visit_stages_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_DATE_TABLE

Line 78: procedure rosetta_table_copy_out_p2(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

74: end loop;
75: end if;
76: end if;
77: end rosetta_table_copy_in_p2;
78: procedure rosetta_table_copy_out_p2(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_DATE_TABLE

Line 217: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE

213: end if;
214: end if;
215: end rosetta_table_copy_out_p2;
216:
217: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
218: , a1 JTF_NUMBER_TABLE
219: , a2 JTF_VARCHAR2_TABLE_100
220: , a3 JTF_NUMBER_TABLE
221: , a4 JTF_NUMBER_TABLE

Line 252: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

248: end loop;
249: end if;
250: end if;
251: end rosetta_table_copy_in_p3;
252: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , a3 out nocopy JTF_NUMBER_TABLE
256: , a4 out nocopy JTF_NUMBER_TABLE

Line 352: ddp_x_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;

348: , x_msg_data out nocopy VARCHAR2
349: )
350:
351: as
352: ddp_x_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;
353: ddindx binary_integer; indx binary_integer;
354: begin
355:
356: -- copy data to the local IN or IN-OUT args, if any

Line 363: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p2(ddp_x_stages_tbl, p6_a0

359:
360:
361:
362:
363: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p2(ddp_x_stages_tbl, p6_a0
364: , p6_a1
365: , p6_a2
366: , p6_a3
367: , p6_a4

Line 393: ahl_vwp_visits_stages_pvt.update_stages(p_api_version,

389:
390:
391:
392: -- here's the delegated call to the old PL/SQL routine
393: ahl_vwp_visits_stages_pvt.update_stages(p_api_version,
394: p_init_msg_list,
395: p_commit,
396: p_validation_level,
397: p_module_type,

Line 411: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p2(ddp_x_stages_tbl, p6_a0

407:
408:
409:
410:
411: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p2(ddp_x_stages_tbl, p6_a0
412: , p6_a1
413: , p6_a2
414: , p6_a3
415: , p6_a4

Line 480: ddx_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;

476: , x_msg_data out nocopy VARCHAR2
477: )
478:
479: as
480: ddx_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;
481: ddindx binary_integer; indx binary_integer;
482: begin
483:
484: -- copy data to the local IN or IN-OUT args, if any

Line 499: ahl_vwp_visits_stages_pvt.get_stages_details(p_api_version,

495:
496:
497:
498: -- here's the delegated call to the old PL/SQL routine
499: ahl_vwp_visits_stages_pvt.get_stages_details(p_api_version,
500: p_init_msg_list,
501: p_commit,
502: p_validation_level,
503: p_module_type,

Line 522: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p2(ddx_stages_tbl, p8_a0

518:
519:
520:
521:
522: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p2(ddx_stages_tbl, p8_a0
523: , p8_a1
524: , p8_a2
525: , p8_a3
526: , p8_a4

Line 553: end ahl_vwp_visits_stages_pvt_w;

549:
550:
551: end;
552:
553: end ahl_vwp_visits_stages_pvt_w;