1: package ahl_fmp_mr_visit_types_pvt_w as
2: /* $Header: AHLWMRVS.pls 120.0 2005/05/26 02:08:36 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
1: package ahl_fmp_mr_visit_types_pvt_w as
2: /* $Header: AHLWMRVS.pls 120.0 2005/05/26 02:08:36 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
1: package ahl_fmp_mr_visit_types_pvt_w as
2: /* $Header: AHLWMRVS.pls 120.0 2005/05/26 02:08:36 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: );
31: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: );
31: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: );
31: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , a4 out nocopy JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: );
31: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , a4 out nocopy JTF_VARCHAR2_TABLE_100
36: , a5 out nocopy JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: );
31: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , a4 out nocopy JTF_VARCHAR2_TABLE_100
36: , a5 out nocopy JTF_VARCHAR2_TABLE_100
37: , a6 out nocopy JTF_VARCHAR2_TABLE_200
49: , a18 out nocopy JTF_VARCHAR2_TABLE_200
50: , a19 out nocopy JTF_VARCHAR2_TABLE_200
51: , a20 out nocopy JTF_VARCHAR2_TABLE_200
52: , a21 out nocopy JTF_DATE_TABLE
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_NUMBER_TABLE
57: , a26 out nocopy JTF_VARCHAR2_TABLE_100
51: , a20 out nocopy JTF_VARCHAR2_TABLE_200
52: , a21 out nocopy JTF_DATE_TABLE
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_NUMBER_TABLE
57: , a26 out nocopy JTF_VARCHAR2_TABLE_100
58: );
59:
52: , a21 out nocopy JTF_DATE_TABLE
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_NUMBER_TABLE
57: , a26 out nocopy JTF_VARCHAR2_TABLE_100
58: );
59:
60: procedure process_mr_visit_types(p_api_version NUMBER
65: , p_module_type VARCHAR2
66: , x_return_status out nocopy VARCHAR2
67: , x_msg_count out nocopy NUMBER
68: , x_msg_data out nocopy VARCHAR2
69: , p9_a0 in out nocopy JTF_NUMBER_TABLE
70: , p9_a1 in out nocopy JTF_NUMBER_TABLE
71: , p9_a2 in out nocopy JTF_NUMBER_TABLE
72: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
66: , x_return_status out nocopy VARCHAR2
67: , x_msg_count out nocopy NUMBER
68: , x_msg_data out nocopy VARCHAR2
69: , p9_a0 in out nocopy JTF_NUMBER_TABLE
70: , p9_a1 in out nocopy JTF_NUMBER_TABLE
71: , p9_a2 in out nocopy JTF_NUMBER_TABLE
72: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
74: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
67: , x_msg_count out nocopy NUMBER
68: , x_msg_data out nocopy VARCHAR2
69: , p9_a0 in out nocopy JTF_NUMBER_TABLE
70: , p9_a1 in out nocopy JTF_NUMBER_TABLE
71: , p9_a2 in out nocopy JTF_NUMBER_TABLE
72: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
74: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
75: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200
87: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
88: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
89: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
90: , p9_a21 in out nocopy JTF_DATE_TABLE
91: , p9_a22 in out nocopy JTF_NUMBER_TABLE
92: , p9_a23 in out nocopy JTF_DATE_TABLE
93: , p9_a24 in out nocopy JTF_NUMBER_TABLE
94: , p9_a25 in out nocopy JTF_NUMBER_TABLE
95: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
89: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
90: , p9_a21 in out nocopy JTF_DATE_TABLE
91: , p9_a22 in out nocopy JTF_NUMBER_TABLE
92: , p9_a23 in out nocopy JTF_DATE_TABLE
93: , p9_a24 in out nocopy JTF_NUMBER_TABLE
94: , p9_a25 in out nocopy JTF_NUMBER_TABLE
95: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
96: );
97: end ahl_fmp_mr_visit_types_pvt_w;
90: , p9_a21 in out nocopy JTF_DATE_TABLE
91: , p9_a22 in out nocopy JTF_NUMBER_TABLE
92: , p9_a23 in out nocopy JTF_DATE_TABLE
93: , p9_a24 in out nocopy JTF_NUMBER_TABLE
94: , p9_a25 in out nocopy JTF_NUMBER_TABLE
95: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
96: );
97: end ahl_fmp_mr_visit_types_pvt_w;