DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_STAGES_PVT_W dependencies on AHL_VWP_VISITS_STAGES_PVT

Line 1: package ahl_vwp_visits_stages_pvt_w AUTHID CURRENT_USER as

1: package ahl_vwp_visits_stages_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWSTGS.pls 120.0.12020000.2 2012/12/14 06:44:52 shnatu ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE

1: package ahl_vwp_visits_stages_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWSTGS.pls 120.0.12020000.2 2012/12/14 06:44:52 shnatu ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 31: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
29: , a26 JTF_VARCHAR2_TABLE_200
30: );
31: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_VARCHAR2_TABLE_100
34: , a3 out nocopy JTF_NUMBER_TABLE
35: , a4 out nocopy JTF_DATE_TABLE

Line 60: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE

56: , a25 out nocopy JTF_VARCHAR2_TABLE_200
57: , a26 out nocopy JTF_VARCHAR2_TABLE_200
58: );
59:
60: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_VARCHAR2_TABLE_100
63: , a3 JTF_NUMBER_TABLE
64: , a4 JTF_NUMBER_TABLE

Line 70: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

66: , a6 JTF_DATE_TABLE
67: , a7 JTF_DATE_TABLE
68: , a8 JTF_DATE_TABLE
69: );
70: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a3 out nocopy JTF_NUMBER_TABLE
74: , a4 out nocopy JTF_NUMBER_TABLE

Line 81: procedure rosetta_table_copy_in_p7(t out nocopy ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 JTF_NUMBER_TABLE

77: , a7 out nocopy JTF_DATE_TABLE
78: , a8 out nocopy JTF_DATE_TABLE
79: );
80:
81: procedure rosetta_table_copy_in_p7(t out nocopy ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: );

Line 86: procedure rosetta_table_copy_out_p7(t ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: );
86: procedure rosetta_table_copy_out_p7(t ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_NUMBER_TABLE
88: , a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , a3 out nocopy JTF_VARCHAR2_TABLE_100
90: );

Line 92: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE

88: , a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , a3 out nocopy JTF_VARCHAR2_TABLE_100
90: );
91:
92: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE
93: , a1 JTF_NUMBER_TABLE
94: , a2 JTF_VARCHAR2_TABLE_100
95: );
96: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 96: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

92: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE
93: , a1 JTF_NUMBER_TABLE
94: , a2 JTF_VARCHAR2_TABLE_100
95: );
96: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_VARCHAR2_TABLE_100
99: );
100:

Line 101: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE

97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_VARCHAR2_TABLE_100
99: );
100:
101: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE
102: , a1 JTF_NUMBER_TABLE
103: );
104: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE

Line 104: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

100:
101: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE
102: , a1 JTF_NUMBER_TABLE
103: );
104: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE
106: );
107:
108: procedure update_stages(p_api_version NUMBER

Line 280: end ahl_vwp_visits_stages_pvt_w;

276: , x_return_status out nocopy VARCHAR2
277: , x_msg_count out nocopy NUMBER
278: , x_msg_data out nocopy VARCHAR2
279: );
280: end ahl_vwp_visits_stages_pvt_w;