1: package ahl_repair_categories_pvt_w as
2: /* $Header: AHLWRCTS.pls 120.0 2005/07/04 03:58 tamdas noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_repair_categories_pvt.repair_category_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_NUMBER_TABLE
1: package ahl_repair_categories_pvt_w as
2: /* $Header: AHLWRCTS.pls 120.0 2005/07/04 03:58 tamdas noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_repair_categories_pvt.repair_category_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_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
1: package ahl_repair_categories_pvt_w as
2: /* $Header: AHLWRCTS.pls 120.0 2005/07/04 03:58 tamdas noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_repair_categories_pvt.repair_category_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_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_repair_categories_pvt.repair_category_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_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_VARCHAR2_TABLE_100
25: );
26: procedure rosetta_table_copy_out_p3(t ahl_repair_categories_pvt.repair_category_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , a4 out nocopy JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_VARCHAR2_TABLE_100
25: );
26: procedure rosetta_table_copy_out_p3(t ahl_repair_categories_pvt.repair_category_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , a4 out nocopy JTF_NUMBER_TABLE
31: , a5 out nocopy JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: );
26: procedure rosetta_table_copy_out_p3(t ahl_repair_categories_pvt.repair_category_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , a4 out nocopy JTF_NUMBER_TABLE
31: , a5 out nocopy JTF_VARCHAR2_TABLE_100
32: , a6 out nocopy JTF_VARCHAR2_TABLE_200
26: procedure rosetta_table_copy_out_p3(t ahl_repair_categories_pvt.repair_category_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , a4 out nocopy JTF_NUMBER_TABLE
31: , a5 out nocopy JTF_VARCHAR2_TABLE_100
32: , a6 out nocopy JTF_VARCHAR2_TABLE_200
33: , a7 out nocopy JTF_VARCHAR2_TABLE_200
34: , a8 out nocopy JTF_VARCHAR2_TABLE_200
55: , p_module_type VARCHAR2
56: , x_return_status out nocopy VARCHAR2
57: , x_msg_count out nocopy NUMBER
58: , x_msg_data out nocopy VARCHAR2
59: , p9_a0 in out nocopy JTF_NUMBER_TABLE
60: , p9_a1 in out nocopy JTF_NUMBER_TABLE
61: , p9_a2 in out nocopy JTF_NUMBER_TABLE
62: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
63: , p9_a4 in out nocopy JTF_NUMBER_TABLE
56: , x_return_status out nocopy VARCHAR2
57: , x_msg_count out nocopy NUMBER
58: , x_msg_data out nocopy VARCHAR2
59: , p9_a0 in out nocopy JTF_NUMBER_TABLE
60: , p9_a1 in out nocopy JTF_NUMBER_TABLE
61: , p9_a2 in out nocopy JTF_NUMBER_TABLE
62: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
63: , p9_a4 in out nocopy JTF_NUMBER_TABLE
64: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
57: , x_msg_count out nocopy NUMBER
58: , x_msg_data out nocopy VARCHAR2
59: , p9_a0 in out nocopy JTF_NUMBER_TABLE
60: , p9_a1 in out nocopy JTF_NUMBER_TABLE
61: , p9_a2 in out nocopy JTF_NUMBER_TABLE
62: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
63: , p9_a4 in out nocopy JTF_NUMBER_TABLE
64: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
65: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200
59: , p9_a0 in out nocopy JTF_NUMBER_TABLE
60: , p9_a1 in out nocopy JTF_NUMBER_TABLE
61: , p9_a2 in out nocopy JTF_NUMBER_TABLE
62: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
63: , p9_a4 in out nocopy JTF_NUMBER_TABLE
64: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
65: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200
66: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200
67: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_200