2: /* $Header: AHLWMMGS.pls 120.0.12020000.2 2012/12/13 06:00:02 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: , a2 JTF_NUMBER_TABLE
5:
6: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_VARCHAR2_TABLE_100
13: , a4 JTF_NUMBER_TABLE
7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_VARCHAR2_TABLE_100
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
9: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_VARCHAR2_TABLE_100
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_VARCHAR2_TABLE_100
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
18: , a9 JTF_VARCHAR2_TABLE_100
12: , a3 JTF_VARCHAR2_TABLE_100
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
18: , a9 JTF_VARCHAR2_TABLE_100
19: , a10 JTF_VARCHAR2_TABLE_100
20: , a11 JTF_VARCHAR2_TABLE_100
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
18: , a9 JTF_VARCHAR2_TABLE_100
19: , a10 JTF_VARCHAR2_TABLE_100
20: , a11 JTF_VARCHAR2_TABLE_100
21: , a12 JTF_VARCHAR2_TABLE_100
19: , a10 JTF_VARCHAR2_TABLE_100
20: , a11 JTF_VARCHAR2_TABLE_100
21: , a12 JTF_VARCHAR2_TABLE_100
22: );
23: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_100
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_100
27: , a4 out nocopy JTF_NUMBER_TABLE
21: , a12 JTF_VARCHAR2_TABLE_100
22: );
23: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_100
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_100
27: , a4 out nocopy JTF_NUMBER_TABLE
28: , a5 out nocopy JTF_NUMBER_TABLE
29: , a6 out nocopy JTF_VARCHAR2_TABLE_100
23: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_100
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_100
27: , a4 out nocopy JTF_NUMBER_TABLE
28: , a5 out nocopy JTF_NUMBER_TABLE
29: , a6 out nocopy JTF_VARCHAR2_TABLE_100
30: , a7 out nocopy JTF_NUMBER_TABLE
31: , a8 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_100
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_100
27: , a4 out nocopy JTF_NUMBER_TABLE
28: , a5 out nocopy JTF_NUMBER_TABLE
29: , a6 out nocopy JTF_VARCHAR2_TABLE_100
30: , a7 out nocopy JTF_NUMBER_TABLE
31: , a8 out nocopy JTF_NUMBER_TABLE
32: , a9 out nocopy JTF_VARCHAR2_TABLE_100
26: , a3 out nocopy JTF_VARCHAR2_TABLE_100
27: , a4 out nocopy JTF_NUMBER_TABLE
28: , a5 out nocopy JTF_NUMBER_TABLE
29: , a6 out nocopy JTF_VARCHAR2_TABLE_100
30: , a7 out nocopy JTF_NUMBER_TABLE
31: , a8 out nocopy JTF_NUMBER_TABLE
32: , a9 out nocopy JTF_VARCHAR2_TABLE_100
33: , a10 out nocopy JTF_VARCHAR2_TABLE_100
34: , a11 out nocopy JTF_VARCHAR2_TABLE_100
27: , a4 out nocopy JTF_NUMBER_TABLE
28: , a5 out nocopy JTF_NUMBER_TABLE
29: , a6 out nocopy JTF_VARCHAR2_TABLE_100
30: , a7 out nocopy JTF_NUMBER_TABLE
31: , a8 out nocopy JTF_NUMBER_TABLE
32: , a9 out nocopy JTF_VARCHAR2_TABLE_100
33: , a10 out nocopy JTF_VARCHAR2_TABLE_100
34: , a11 out nocopy JTF_VARCHAR2_TABLE_100
35: , a12 out nocopy JTF_VARCHAR2_TABLE_100
34: , a11 out nocopy JTF_VARCHAR2_TABLE_100
35: , a12 out nocopy JTF_VARCHAR2_TABLE_100
36: );
37:
38: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_DATE_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_VARCHAR2_TABLE_2000
35: , a12 out nocopy JTF_VARCHAR2_TABLE_100
36: );
37:
38: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_DATE_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_VARCHAR2_TABLE_2000
43: );
37:
38: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_DATE_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_VARCHAR2_TABLE_2000
43: );
44: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 JTF_DATE_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_VARCHAR2_TABLE_2000
43: );
44: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_VARCHAR2_TABLE_2000
43: );
44: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: );
43: );
44: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: );
50:
51: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: );
50:
51: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
52: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
53:
54: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: );
50:
51: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
52: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
53:
54: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE
50:
51: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
52: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
53:
54: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: );
52: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
53:
54: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: );
57: , a3 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: );
64:
65: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: );
64:
65: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE
66: , a1 JTF_VARCHAR2_TABLE_100
67: , a2 JTF_NUMBER_TABLE
68: );
69: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
63: );
64:
65: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE
66: , a1 JTF_VARCHAR2_TABLE_100
67: , a2 JTF_NUMBER_TABLE
68: );
69: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
65: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE
66: , a1 JTF_VARCHAR2_TABLE_100
67: , a2 JTF_NUMBER_TABLE
68: );
69: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: );
73:
67: , a2 JTF_NUMBER_TABLE
68: );
69: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_2000
77: );
78: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE
71: , a2 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_2000
77: );
78: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
74: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_2000
77: );
78: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
81: );
82:
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_2000
77: );
78: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
81: );
82:
83: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE);
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
81: );
82:
83: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE);
84: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE);
85:
86: procedure check_availability(p_api_version NUMBER
87: , p_init_msg_list VARCHAR2
80: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
81: );
82:
83: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE);
84: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE);
85:
86: procedure check_availability(p_api_version NUMBER
87: , p_init_msg_list VARCHAR2
88: , p_commit VARCHAR2
87: , p_init_msg_list VARCHAR2
88: , p_commit VARCHAR2
89: , p_module_type VARCHAR2
90: , p_validation_level NUMBER
91: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
92: , p6_a0 out nocopy JTF_NUMBER_TABLE
93: , p6_a1 out nocopy JTF_NUMBER_TABLE
94: , p6_a2 out nocopy JTF_DATE_TABLE
95: , p6_a3 out nocopy JTF_NUMBER_TABLE
88: , p_commit VARCHAR2
89: , p_module_type VARCHAR2
90: , p_validation_level NUMBER
91: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
92: , p6_a0 out nocopy JTF_NUMBER_TABLE
93: , p6_a1 out nocopy JTF_NUMBER_TABLE
94: , p6_a2 out nocopy JTF_DATE_TABLE
95: , p6_a3 out nocopy JTF_NUMBER_TABLE
96: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
89: , p_module_type VARCHAR2
90: , p_validation_level NUMBER
91: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
92: , p6_a0 out nocopy JTF_NUMBER_TABLE
93: , p6_a1 out nocopy JTF_NUMBER_TABLE
94: , p6_a2 out nocopy JTF_DATE_TABLE
95: , p6_a3 out nocopy JTF_NUMBER_TABLE
96: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
97: , x_return_status out nocopy VARCHAR2
91: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
92: , p6_a0 out nocopy JTF_NUMBER_TABLE
93: , p6_a1 out nocopy JTF_NUMBER_TABLE
94: , p6_a2 out nocopy JTF_DATE_TABLE
95: , p6_a3 out nocopy JTF_NUMBER_TABLE
96: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
97: , x_return_status out nocopy VARCHAR2
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
102: , p_init_msg_list VARCHAR2
103: , p_commit VARCHAR2
104: , p_module_type VARCHAR2
105: , p_validation_level NUMBER
106: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_NUMBER_TABLE
109: , p6_a2 out nocopy JTF_DATE_TABLE
110: , p6_a3 out nocopy JTF_NUMBER_TABLE
103: , p_commit VARCHAR2
104: , p_module_type VARCHAR2
105: , p_validation_level NUMBER
106: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_NUMBER_TABLE
109: , p6_a2 out nocopy JTF_DATE_TABLE
110: , p6_a3 out nocopy JTF_NUMBER_TABLE
111: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
104: , p_module_type VARCHAR2
105: , p_validation_level NUMBER
106: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_NUMBER_TABLE
109: , p6_a2 out nocopy JTF_DATE_TABLE
110: , p6_a3 out nocopy JTF_NUMBER_TABLE
111: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
112: , x_return_status out nocopy VARCHAR2
106: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_NUMBER_TABLE
109: , p6_a2 out nocopy JTF_DATE_TABLE
110: , p6_a3 out nocopy JTF_NUMBER_TABLE
111: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
112: , x_return_status out nocopy VARCHAR2
113: , x_msg_count out nocopy NUMBER
114: , x_msg_data out nocopy VARCHAR2
118: , p_commit VARCHAR2
119: , p_module_type VARCHAR2
120: , p_validation_level NUMBER
121: , p_visit_id NUMBER
122: , p6_a0 out nocopy JTF_NUMBER_TABLE
123: , p6_a1 out nocopy JTF_NUMBER_TABLE
124: , p6_a2 out nocopy JTF_DATE_TABLE
125: , p6_a3 out nocopy JTF_NUMBER_TABLE
126: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
119: , p_module_type VARCHAR2
120: , p_validation_level NUMBER
121: , p_visit_id NUMBER
122: , p6_a0 out nocopy JTF_NUMBER_TABLE
123: , p6_a1 out nocopy JTF_NUMBER_TABLE
124: , p6_a2 out nocopy JTF_DATE_TABLE
125: , p6_a3 out nocopy JTF_NUMBER_TABLE
126: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
127: , x_return_status out nocopy VARCHAR2
121: , p_visit_id NUMBER
122: , p6_a0 out nocopy JTF_NUMBER_TABLE
123: , p6_a1 out nocopy JTF_NUMBER_TABLE
124: , p6_a2 out nocopy JTF_DATE_TABLE
125: , p6_a3 out nocopy JTF_NUMBER_TABLE
126: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
127: , x_return_status out nocopy VARCHAR2
128: , x_msg_count out nocopy NUMBER
129: , x_msg_data out nocopy VARCHAR2
132: , p_init_msg_list VARCHAR2
133: , p_commit VARCHAR2
134: , p_validation_level NUMBER
135: , p_scheduled_material_id NUMBER
136: , p5_a0 JTF_NUMBER_TABLE
137: , p5_a1 JTF_VARCHAR2_TABLE_100
138: , p5_a2 JTF_NUMBER_TABLE
139: , p5_a3 JTF_VARCHAR2_TABLE_100
140: , x_mo_hdr_id out nocopy NUMBER
134: , p_validation_level NUMBER
135: , p_scheduled_material_id NUMBER
136: , p5_a0 JTF_NUMBER_TABLE
137: , p5_a1 JTF_VARCHAR2_TABLE_100
138: , p5_a2 JTF_NUMBER_TABLE
139: , p5_a3 JTF_VARCHAR2_TABLE_100
140: , x_mo_hdr_id out nocopy NUMBER
141: , x_mo_lines_tbl out nocopy JTF_NUMBER_TABLE
142: , x_return_status out nocopy VARCHAR2
137: , p5_a1 JTF_VARCHAR2_TABLE_100
138: , p5_a2 JTF_NUMBER_TABLE
139: , p5_a3 JTF_VARCHAR2_TABLE_100
140: , x_mo_hdr_id out nocopy NUMBER
141: , x_mo_lines_tbl out nocopy JTF_NUMBER_TABLE
142: , x_return_status out nocopy VARCHAR2
143: , x_msg_count out nocopy NUMBER
144: , x_msg_data out nocopy VARCHAR2
145: );
146: procedure invoke_aog_upd_notification(p_api_version NUMBER
147: , p_init_msg_list VARCHAR2
148: , p_commit VARCHAR2
149: , p_validation_level NUMBER
150: , p_asm_id_tab JTF_NUMBER_TABLE
151: , x_return_status out nocopy VARCHAR2
152: , x_msg_count out nocopy NUMBER
153: , x_msg_data out nocopy VARCHAR2
154: );
160: , p_module_type VARCHAR2
161: , x_return_status out nocopy VARCHAR2
162: , x_msg_count out nocopy NUMBER
163: , x_msg_data out nocopy VARCHAR2
164: , p9_a0 in out nocopy JTF_NUMBER_TABLE
165: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
166: , p9_a2 in out nocopy JTF_NUMBER_TABLE
167: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p9_a4 in out nocopy JTF_NUMBER_TABLE
162: , x_msg_count out nocopy NUMBER
163: , x_msg_data out nocopy VARCHAR2
164: , p9_a0 in out nocopy JTF_NUMBER_TABLE
165: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
166: , p9_a2 in out nocopy JTF_NUMBER_TABLE
167: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p9_a4 in out nocopy JTF_NUMBER_TABLE
169: , p9_a5 in out nocopy JTF_NUMBER_TABLE
170: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
164: , p9_a0 in out nocopy JTF_NUMBER_TABLE
165: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
166: , p9_a2 in out nocopy JTF_NUMBER_TABLE
167: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p9_a4 in out nocopy JTF_NUMBER_TABLE
169: , p9_a5 in out nocopy JTF_NUMBER_TABLE
170: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p9_a7 in out nocopy JTF_NUMBER_TABLE
172: , p9_a8 in out nocopy JTF_NUMBER_TABLE
165: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
166: , p9_a2 in out nocopy JTF_NUMBER_TABLE
167: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p9_a4 in out nocopy JTF_NUMBER_TABLE
169: , p9_a5 in out nocopy JTF_NUMBER_TABLE
170: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p9_a7 in out nocopy JTF_NUMBER_TABLE
172: , p9_a8 in out nocopy JTF_NUMBER_TABLE
173: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
167: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p9_a4 in out nocopy JTF_NUMBER_TABLE
169: , p9_a5 in out nocopy JTF_NUMBER_TABLE
170: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p9_a7 in out nocopy JTF_NUMBER_TABLE
172: , p9_a8 in out nocopy JTF_NUMBER_TABLE
173: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
174: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
175: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p9_a4 in out nocopy JTF_NUMBER_TABLE
169: , p9_a5 in out nocopy JTF_NUMBER_TABLE
170: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p9_a7 in out nocopy JTF_NUMBER_TABLE
172: , p9_a8 in out nocopy JTF_NUMBER_TABLE
173: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
174: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
175: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
176: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
185: , p_module_type VARCHAR2
186: , x_return_status out nocopy VARCHAR2
187: , x_msg_count out nocopy NUMBER
188: , x_msg_data out nocopy VARCHAR2
189: , p9_a0 in out nocopy JTF_NUMBER_TABLE
190: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p9_a2 in out nocopy JTF_NUMBER_TABLE
192: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p9_a4 in out nocopy JTF_NUMBER_TABLE
187: , x_msg_count out nocopy NUMBER
188: , x_msg_data out nocopy VARCHAR2
189: , p9_a0 in out nocopy JTF_NUMBER_TABLE
190: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p9_a2 in out nocopy JTF_NUMBER_TABLE
192: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p9_a4 in out nocopy JTF_NUMBER_TABLE
194: , p9_a5 in out nocopy JTF_NUMBER_TABLE
195: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
189: , p9_a0 in out nocopy JTF_NUMBER_TABLE
190: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p9_a2 in out nocopy JTF_NUMBER_TABLE
192: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p9_a4 in out nocopy JTF_NUMBER_TABLE
194: , p9_a5 in out nocopy JTF_NUMBER_TABLE
195: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
196: , p9_a7 in out nocopy JTF_NUMBER_TABLE
197: , p9_a8 in out nocopy JTF_NUMBER_TABLE
190: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p9_a2 in out nocopy JTF_NUMBER_TABLE
192: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p9_a4 in out nocopy JTF_NUMBER_TABLE
194: , p9_a5 in out nocopy JTF_NUMBER_TABLE
195: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
196: , p9_a7 in out nocopy JTF_NUMBER_TABLE
197: , p9_a8 in out nocopy JTF_NUMBER_TABLE
198: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
192: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p9_a4 in out nocopy JTF_NUMBER_TABLE
194: , p9_a5 in out nocopy JTF_NUMBER_TABLE
195: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
196: , p9_a7 in out nocopy JTF_NUMBER_TABLE
197: , p9_a8 in out nocopy JTF_NUMBER_TABLE
198: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p9_a4 in out nocopy JTF_NUMBER_TABLE
194: , p9_a5 in out nocopy JTF_NUMBER_TABLE
195: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
196: , p9_a7 in out nocopy JTF_NUMBER_TABLE
197: , p9_a8 in out nocopy JTF_NUMBER_TABLE
198: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
207: , x_msg_count out nocopy NUMBER
208: , x_msg_data out nocopy VARCHAR2
209: , x_return_status out nocopy VARCHAR2
210: , p_sch_mtl_id NUMBER
211: , p_source_org_tbl JTF_NUMBER_TABLE
212: , p_source_sub_inv_tbl JTF_VARCHAR2_TABLE_100
213: , p_source_locators_tbl JTF_NUMBER_TABLE
214: , p_serial_num_tbl JTF_VARCHAR2_TABLE_100
215: , x_requisition_num out nocopy VARCHAR2
209: , x_return_status out nocopy VARCHAR2
210: , p_sch_mtl_id NUMBER
211: , p_source_org_tbl JTF_NUMBER_TABLE
212: , p_source_sub_inv_tbl JTF_VARCHAR2_TABLE_100
213: , p_source_locators_tbl JTF_NUMBER_TABLE
214: , p_serial_num_tbl JTF_VARCHAR2_TABLE_100
215: , x_requisition_num out nocopy VARCHAR2
216: , x_requisition_hdr_id out nocopy NUMBER
217: , x_int_order_num out nocopy NUMBER
221: procedure aog_upd_notification(p_api_version NUMBER
222: , p_init_msg_list VARCHAR2
223: , p_commit VARCHAR2
224: , p_validation_level NUMBER
225: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
226: , x_return_status out nocopy VARCHAR2
227: , x_msg_count out nocopy NUMBER
228: , x_msg_data out nocopy VARCHAR2
229: );
230: procedure update_aog(p_api_version NUMBER
231: , p_init_msg_list VARCHAR2
232: , p_commit VARCHAR2
233: , p_validation_level NUMBER
234: , p4_a0 JTF_NUMBER_TABLE
235: , p4_a1 JTF_VARCHAR2_TABLE_100
236: , p4_a2 JTF_NUMBER_TABLE
237: , x_return_status out nocopy VARCHAR2
238: , x_msg_count out nocopy NUMBER
232: , p_commit VARCHAR2
233: , p_validation_level NUMBER
234: , p4_a0 JTF_NUMBER_TABLE
235: , p4_a1 JTF_VARCHAR2_TABLE_100
236: , p4_a2 JTF_NUMBER_TABLE
237: , x_return_status out nocopy VARCHAR2
238: , x_msg_count out nocopy NUMBER
239: , x_msg_data out nocopy VARCHAR2
240: );
267: , p_module_type VARCHAR2
268: , p_validation_level NUMBER
269: , p_org_id NUMBER
270: , p_inv_item_id NUMBER
271: , p7_a0 out nocopy JTF_NUMBER_TABLE
272: , p7_a1 out nocopy JTF_NUMBER_TABLE
273: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_2000
274: , x_return_status out nocopy VARCHAR2
275: , x_msg_count out nocopy NUMBER
268: , p_validation_level NUMBER
269: , p_org_id NUMBER
270: , p_inv_item_id NUMBER
271: , p7_a0 out nocopy JTF_NUMBER_TABLE
272: , p7_a1 out nocopy JTF_NUMBER_TABLE
273: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_2000
274: , x_return_status out nocopy VARCHAR2
275: , x_msg_count out nocopy NUMBER
276: , x_msg_data out nocopy VARCHAR2
279: , p_init_msg_list VARCHAR2
280: , p_commit VARCHAR2
281: , p_module_type VARCHAR2
282: , p_validation_level NUMBER
283: , p_visit_ids JTF_NUMBER_TABLE
284: , p6_a0 out nocopy JTF_NUMBER_TABLE
285: , p6_a1 out nocopy JTF_NUMBER_TABLE
286: , p6_a2 out nocopy JTF_DATE_TABLE
287: , p6_a3 out nocopy JTF_NUMBER_TABLE
280: , p_commit VARCHAR2
281: , p_module_type VARCHAR2
282: , p_validation_level NUMBER
283: , p_visit_ids JTF_NUMBER_TABLE
284: , p6_a0 out nocopy JTF_NUMBER_TABLE
285: , p6_a1 out nocopy JTF_NUMBER_TABLE
286: , p6_a2 out nocopy JTF_DATE_TABLE
287: , p6_a3 out nocopy JTF_NUMBER_TABLE
288: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
281: , p_module_type VARCHAR2
282: , p_validation_level NUMBER
283: , p_visit_ids JTF_NUMBER_TABLE
284: , p6_a0 out nocopy JTF_NUMBER_TABLE
285: , p6_a1 out nocopy JTF_NUMBER_TABLE
286: , p6_a2 out nocopy JTF_DATE_TABLE
287: , p6_a3 out nocopy JTF_NUMBER_TABLE
288: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
289: , x_return_status out nocopy VARCHAR2
283: , p_visit_ids JTF_NUMBER_TABLE
284: , p6_a0 out nocopy JTF_NUMBER_TABLE
285: , p6_a1 out nocopy JTF_NUMBER_TABLE
286: , p6_a2 out nocopy JTF_DATE_TABLE
287: , p6_a3 out nocopy JTF_NUMBER_TABLE
288: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
289: , x_return_status out nocopy VARCHAR2
290: , x_msg_count out nocopy NUMBER
291: , x_msg_data out nocopy VARCHAR2