APPS.AHL_LTP_SIMUL_PLAN_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_simul_plan_pub.simulation_plan_tbl, a0 JTF_NUMBER_TABLE

1: package ahl_ltp_simul_plan_pub_w AUTHID CURRENT_USER as
2: /* $Header: AHLWSPNS.pls 115.4 2002/12/04 19:22:16 ssurapan noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_simul_plan_pub.simulation_plan_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package ahl_ltp_simul_plan_pub_w AUTHID CURRENT_USER as
2: /* $Header: AHLWSPNS.pls 115.4 2002/12/04 19:22:16 ssurapan noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_simul_plan_pub.simulation_plan_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_simul_plan_pub.simulation_plan_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_NUMBER_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_200
16: , a13 JTF_VARCHAR2_TABLE_200

Line 31: procedure rosetta_table_copy_out_p1(t ahl_ltp_simul_plan_pub.simulation_plan_tbl, a0 out nocopy JTF_NUMBER_TABLE

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

Line 33: , a2 out nocopy JTF_NUMBER_TABLE

29: , a26 JTF_VARCHAR2_TABLE_100
30: );
31: procedure rosetta_table_copy_out_p1(t ahl_ltp_simul_plan_pub.simulation_plan_tbl, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_DATE_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_DATE_TABLE
35: , a4 out nocopy JTF_NUMBER_TABLE
36: , a5 out nocopy JTF_NUMBER_TABLE
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 35: , a4 out nocopy JTF_NUMBER_TABLE

31: procedure rosetta_table_copy_out_p1(t ahl_ltp_simul_plan_pub.simulation_plan_tbl, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_DATE_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_DATE_TABLE
35: , a4 out nocopy JTF_NUMBER_TABLE
36: , a5 out nocopy JTF_NUMBER_TABLE
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100
38: , a7 out nocopy JTF_VARCHAR2_TABLE_100
39: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 36: , a5 out nocopy JTF_NUMBER_TABLE

32: , a1 out nocopy JTF_DATE_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_DATE_TABLE
35: , a4 out nocopy JTF_NUMBER_TABLE
36: , a5 out nocopy JTF_NUMBER_TABLE
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100
38: , a7 out nocopy JTF_VARCHAR2_TABLE_100
39: , a8 out nocopy JTF_VARCHAR2_TABLE_300
40: , a9 out nocopy JTF_NUMBER_TABLE

Line 40: , a9 out nocopy JTF_NUMBER_TABLE

36: , a5 out nocopy JTF_NUMBER_TABLE
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100
38: , a7 out nocopy JTF_VARCHAR2_TABLE_100
39: , a8 out nocopy JTF_VARCHAR2_TABLE_300
40: , a9 out nocopy JTF_NUMBER_TABLE
41: , a10 out nocopy JTF_VARCHAR2_TABLE_100
42: , a11 out nocopy JTF_VARCHAR2_TABLE_200
43: , a12 out nocopy JTF_VARCHAR2_TABLE_200
44: , a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 60: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 JTF_NUMBER_TABLE

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

Line 61: , a1 JTF_NUMBER_TABLE

57: , a26 out nocopy JTF_VARCHAR2_TABLE_100
58: );
59:
60: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_VARCHAR2_TABLE_100
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_NUMBER_TABLE

Line 62: , a2 JTF_NUMBER_TABLE

58: );
59:
60: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_VARCHAR2_TABLE_100
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_NUMBER_TABLE
66: , a6 JTF_NUMBER_TABLE

Line 64: , a4 JTF_NUMBER_TABLE

60: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_VARCHAR2_TABLE_100
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_NUMBER_TABLE
66: , a6 JTF_NUMBER_TABLE
67: , a7 JTF_NUMBER_TABLE
68: , a8 JTF_VARCHAR2_TABLE_100

Line 65: , a5 JTF_NUMBER_TABLE

61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_VARCHAR2_TABLE_100
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_NUMBER_TABLE
66: , a6 JTF_NUMBER_TABLE
67: , a7 JTF_NUMBER_TABLE
68: , a8 JTF_VARCHAR2_TABLE_100
69: );

Line 66: , a6 JTF_NUMBER_TABLE

62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_VARCHAR2_TABLE_100
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_NUMBER_TABLE
66: , a6 JTF_NUMBER_TABLE
67: , a7 JTF_NUMBER_TABLE
68: , a8 JTF_VARCHAR2_TABLE_100
69: );
70: procedure rosetta_table_copy_out_p3(t ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 67: , a7 JTF_NUMBER_TABLE

63: , a3 JTF_VARCHAR2_TABLE_100
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_NUMBER_TABLE
66: , a6 JTF_NUMBER_TABLE
67: , a7 JTF_NUMBER_TABLE
68: , a8 JTF_VARCHAR2_TABLE_100
69: );
70: procedure rosetta_table_copy_out_p3(t ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE

Line 70: procedure rosetta_table_copy_out_p3(t ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 out nocopy JTF_NUMBER_TABLE

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

Line 71: , a1 out nocopy JTF_NUMBER_TABLE

67: , a7 JTF_NUMBER_TABLE
68: , a8 JTF_VARCHAR2_TABLE_100
69: );
70: procedure rosetta_table_copy_out_p3(t ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE

Line 72: , a2 out nocopy JTF_NUMBER_TABLE

68: , a8 JTF_VARCHAR2_TABLE_100
69: );
70: procedure rosetta_table_copy_out_p3(t ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE

Line 74: , a4 out nocopy JTF_NUMBER_TABLE

70: procedure rosetta_table_copy_out_p3(t ahl_ltp_simul_plan_pub.simulation_visit_tbl, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 75: , a5 out nocopy JTF_NUMBER_TABLE

71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_VARCHAR2_TABLE_100
79: );

Line 76: , a6 out nocopy JTF_NUMBER_TABLE

72: , a2 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_VARCHAR2_TABLE_100
79: );
80:

Line 77: , a7 out nocopy JTF_NUMBER_TABLE

73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_VARCHAR2_TABLE_100
79: );
80:
81: procedure process_simulation_plan(p_api_version NUMBER

Line 86: , p5_a0 in out nocopy JTF_NUMBER_TABLE

82: , p_init_msg_list VARCHAR2
83: , p_commit VARCHAR2
84: , p_validation_level NUMBER
85: , p_module_type VARCHAR2
86: , p5_a0 in out nocopy JTF_NUMBER_TABLE
87: , p5_a1 in out nocopy JTF_DATE_TABLE
88: , p5_a2 in out nocopy JTF_NUMBER_TABLE
89: , p5_a3 in out nocopy JTF_DATE_TABLE
90: , p5_a4 in out nocopy JTF_NUMBER_TABLE

Line 88: , p5_a2 in out nocopy JTF_NUMBER_TABLE

84: , p_validation_level NUMBER
85: , p_module_type VARCHAR2
86: , p5_a0 in out nocopy JTF_NUMBER_TABLE
87: , p5_a1 in out nocopy JTF_DATE_TABLE
88: , p5_a2 in out nocopy JTF_NUMBER_TABLE
89: , p5_a3 in out nocopy JTF_DATE_TABLE
90: , p5_a4 in out nocopy JTF_NUMBER_TABLE
91: , p5_a5 in out nocopy JTF_NUMBER_TABLE
92: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 90: , p5_a4 in out nocopy JTF_NUMBER_TABLE

86: , p5_a0 in out nocopy JTF_NUMBER_TABLE
87: , p5_a1 in out nocopy JTF_DATE_TABLE
88: , p5_a2 in out nocopy JTF_NUMBER_TABLE
89: , p5_a3 in out nocopy JTF_DATE_TABLE
90: , p5_a4 in out nocopy JTF_NUMBER_TABLE
91: , p5_a5 in out nocopy JTF_NUMBER_TABLE
92: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
93: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
94: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_300

Line 91: , p5_a5 in out nocopy JTF_NUMBER_TABLE

87: , p5_a1 in out nocopy JTF_DATE_TABLE
88: , p5_a2 in out nocopy JTF_NUMBER_TABLE
89: , p5_a3 in out nocopy JTF_DATE_TABLE
90: , p5_a4 in out nocopy JTF_NUMBER_TABLE
91: , p5_a5 in out nocopy JTF_NUMBER_TABLE
92: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
93: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
94: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_300
95: , p5_a9 in out nocopy JTF_NUMBER_TABLE

Line 95: , p5_a9 in out nocopy JTF_NUMBER_TABLE

91: , p5_a5 in out nocopy JTF_NUMBER_TABLE
92: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
93: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
94: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_300
95: , p5_a9 in out nocopy JTF_NUMBER_TABLE
96: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
97: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
98: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
99: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200

Line 122: , p5_a0 in out nocopy JTF_NUMBER_TABLE

118: , p_init_msg_list VARCHAR2
119: , p_commit VARCHAR2
120: , p_validation_level NUMBER
121: , p_module_type VARCHAR2
122: , p5_a0 in out nocopy JTF_NUMBER_TABLE
123: , p5_a1 in out nocopy JTF_NUMBER_TABLE
124: , p5_a2 in out nocopy JTF_NUMBER_TABLE
125: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p5_a4 in out nocopy JTF_NUMBER_TABLE

Line 123: , p5_a1 in out nocopy JTF_NUMBER_TABLE

119: , p_commit VARCHAR2
120: , p_validation_level NUMBER
121: , p_module_type VARCHAR2
122: , p5_a0 in out nocopy JTF_NUMBER_TABLE
123: , p5_a1 in out nocopy JTF_NUMBER_TABLE
124: , p5_a2 in out nocopy JTF_NUMBER_TABLE
125: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p5_a4 in out nocopy JTF_NUMBER_TABLE
127: , p5_a5 in out nocopy JTF_NUMBER_TABLE

Line 124: , p5_a2 in out nocopy JTF_NUMBER_TABLE

120: , p_validation_level NUMBER
121: , p_module_type VARCHAR2
122: , p5_a0 in out nocopy JTF_NUMBER_TABLE
123: , p5_a1 in out nocopy JTF_NUMBER_TABLE
124: , p5_a2 in out nocopy JTF_NUMBER_TABLE
125: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p5_a4 in out nocopy JTF_NUMBER_TABLE
127: , p5_a5 in out nocopy JTF_NUMBER_TABLE
128: , p5_a6 in out nocopy JTF_NUMBER_TABLE

Line 126: , p5_a4 in out nocopy JTF_NUMBER_TABLE

122: , p5_a0 in out nocopy JTF_NUMBER_TABLE
123: , p5_a1 in out nocopy JTF_NUMBER_TABLE
124: , p5_a2 in out nocopy JTF_NUMBER_TABLE
125: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p5_a4 in out nocopy JTF_NUMBER_TABLE
127: , p5_a5 in out nocopy JTF_NUMBER_TABLE
128: , p5_a6 in out nocopy JTF_NUMBER_TABLE
129: , p5_a7 in out nocopy JTF_NUMBER_TABLE
130: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , p5_a5 in out nocopy JTF_NUMBER_TABLE

123: , p5_a1 in out nocopy JTF_NUMBER_TABLE
124: , p5_a2 in out nocopy JTF_NUMBER_TABLE
125: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p5_a4 in out nocopy JTF_NUMBER_TABLE
127: , p5_a5 in out nocopy JTF_NUMBER_TABLE
128: , p5_a6 in out nocopy JTF_NUMBER_TABLE
129: , p5_a7 in out nocopy JTF_NUMBER_TABLE
130: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
131: , x_return_status out nocopy VARCHAR2

Line 128: , p5_a6 in out nocopy JTF_NUMBER_TABLE

124: , p5_a2 in out nocopy JTF_NUMBER_TABLE
125: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p5_a4 in out nocopy JTF_NUMBER_TABLE
127: , p5_a5 in out nocopy JTF_NUMBER_TABLE
128: , p5_a6 in out nocopy JTF_NUMBER_TABLE
129: , p5_a7 in out nocopy JTF_NUMBER_TABLE
130: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
131: , x_return_status out nocopy VARCHAR2
132: , x_msg_count out nocopy NUMBER

Line 129: , p5_a7 in out nocopy JTF_NUMBER_TABLE

125: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p5_a4 in out nocopy JTF_NUMBER_TABLE
127: , p5_a5 in out nocopy JTF_NUMBER_TABLE
128: , p5_a6 in out nocopy JTF_NUMBER_TABLE
129: , p5_a7 in out nocopy JTF_NUMBER_TABLE
130: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
131: , x_return_status out nocopy VARCHAR2
132: , x_msg_count out nocopy NUMBER
133: , x_msg_data out nocopy VARCHAR2