25: procedure explode_initial_estimate(p_api_version NUMBER
26: , p_init_msg_list VARCHAR2
27: , p_commit VARCHAR2
28: , p_estimate_id NUMBER
29: , p4_a0 out nocopy JTF_NUMBER_TABLE
30: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
31: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_2000
32: , p4_a3 out nocopy JTF_NUMBER_TABLE
33: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
28: , p_estimate_id NUMBER
29: , p4_a0 out nocopy JTF_NUMBER_TABLE
30: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
31: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_2000
32: , p4_a3 out nocopy JTF_NUMBER_TABLE
33: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
34: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
35: , x_return_status out nocopy VARCHAR2
36: , x_msg_count out nocopy NUMBER
81: procedure insert_all_wo_lines(p_api_version NUMBER
82: , p_init_msg_list VARCHAR2
83: , p_commit VARCHAR2
84: , p_estimate_id NUMBER
85: , p4_a0 JTF_NUMBER_TABLE
86: , p4_a1 JTF_NUMBER_TABLE
87: , p4_a2 JTF_NUMBER_TABLE
88: , p4_a3 JTF_NUMBER_TABLE
89: , p4_a4 JTF_NUMBER_TABLE
82: , p_init_msg_list VARCHAR2
83: , p_commit VARCHAR2
84: , p_estimate_id NUMBER
85: , p4_a0 JTF_NUMBER_TABLE
86: , p4_a1 JTF_NUMBER_TABLE
87: , p4_a2 JTF_NUMBER_TABLE
88: , p4_a3 JTF_NUMBER_TABLE
89: , p4_a4 JTF_NUMBER_TABLE
90: , p4_a5 JTF_VARCHAR2_TABLE_100
83: , p_commit VARCHAR2
84: , p_estimate_id NUMBER
85: , p4_a0 JTF_NUMBER_TABLE
86: , p4_a1 JTF_NUMBER_TABLE
87: , p4_a2 JTF_NUMBER_TABLE
88: , p4_a3 JTF_NUMBER_TABLE
89: , p4_a4 JTF_NUMBER_TABLE
90: , p4_a5 JTF_VARCHAR2_TABLE_100
91: , p4_a6 JTF_NUMBER_TABLE
84: , p_estimate_id NUMBER
85: , p4_a0 JTF_NUMBER_TABLE
86: , p4_a1 JTF_NUMBER_TABLE
87: , p4_a2 JTF_NUMBER_TABLE
88: , p4_a3 JTF_NUMBER_TABLE
89: , p4_a4 JTF_NUMBER_TABLE
90: , p4_a5 JTF_VARCHAR2_TABLE_100
91: , p4_a6 JTF_NUMBER_TABLE
92: , p4_a7 JTF_NUMBER_TABLE
85: , p4_a0 JTF_NUMBER_TABLE
86: , p4_a1 JTF_NUMBER_TABLE
87: , p4_a2 JTF_NUMBER_TABLE
88: , p4_a3 JTF_NUMBER_TABLE
89: , p4_a4 JTF_NUMBER_TABLE
90: , p4_a5 JTF_VARCHAR2_TABLE_100
91: , p4_a6 JTF_NUMBER_TABLE
92: , p4_a7 JTF_NUMBER_TABLE
93: , p4_a8 JTF_NUMBER_TABLE
87: , p4_a2 JTF_NUMBER_TABLE
88: , p4_a3 JTF_NUMBER_TABLE
89: , p4_a4 JTF_NUMBER_TABLE
90: , p4_a5 JTF_VARCHAR2_TABLE_100
91: , p4_a6 JTF_NUMBER_TABLE
92: , p4_a7 JTF_NUMBER_TABLE
93: , p4_a8 JTF_NUMBER_TABLE
94: , p4_a9 JTF_VARCHAR2_TABLE_100
95: , p4_a10 JTF_VARCHAR2_TABLE_300
88: , p4_a3 JTF_NUMBER_TABLE
89: , p4_a4 JTF_NUMBER_TABLE
90: , p4_a5 JTF_VARCHAR2_TABLE_100
91: , p4_a6 JTF_NUMBER_TABLE
92: , p4_a7 JTF_NUMBER_TABLE
93: , p4_a8 JTF_NUMBER_TABLE
94: , p4_a9 JTF_VARCHAR2_TABLE_100
95: , p4_a10 JTF_VARCHAR2_TABLE_300
96: , p4_a11 JTF_NUMBER_TABLE
89: , p4_a4 JTF_NUMBER_TABLE
90: , p4_a5 JTF_VARCHAR2_TABLE_100
91: , p4_a6 JTF_NUMBER_TABLE
92: , p4_a7 JTF_NUMBER_TABLE
93: , p4_a8 JTF_NUMBER_TABLE
94: , p4_a9 JTF_VARCHAR2_TABLE_100
95: , p4_a10 JTF_VARCHAR2_TABLE_300
96: , p4_a11 JTF_NUMBER_TABLE
97: , p4_a12 JTF_NUMBER_TABLE
92: , p4_a7 JTF_NUMBER_TABLE
93: , p4_a8 JTF_NUMBER_TABLE
94: , p4_a9 JTF_VARCHAR2_TABLE_100
95: , p4_a10 JTF_VARCHAR2_TABLE_300
96: , p4_a11 JTF_NUMBER_TABLE
97: , p4_a12 JTF_NUMBER_TABLE
98: , p4_a13 JTF_NUMBER_TABLE
99: , p4_a14 JTF_VARCHAR2_TABLE_100
100: , p4_a15 JTF_DATE_TABLE
93: , p4_a8 JTF_NUMBER_TABLE
94: , p4_a9 JTF_VARCHAR2_TABLE_100
95: , p4_a10 JTF_VARCHAR2_TABLE_300
96: , p4_a11 JTF_NUMBER_TABLE
97: , p4_a12 JTF_NUMBER_TABLE
98: , p4_a13 JTF_NUMBER_TABLE
99: , p4_a14 JTF_VARCHAR2_TABLE_100
100: , p4_a15 JTF_DATE_TABLE
101: , p4_a16 JTF_DATE_TABLE
94: , p4_a9 JTF_VARCHAR2_TABLE_100
95: , p4_a10 JTF_VARCHAR2_TABLE_300
96: , p4_a11 JTF_NUMBER_TABLE
97: , p4_a12 JTF_NUMBER_TABLE
98: , p4_a13 JTF_NUMBER_TABLE
99: , p4_a14 JTF_VARCHAR2_TABLE_100
100: , p4_a15 JTF_DATE_TABLE
101: , p4_a16 JTF_DATE_TABLE
102: , p4_a17 JTF_NUMBER_TABLE
98: , p4_a13 JTF_NUMBER_TABLE
99: , p4_a14 JTF_VARCHAR2_TABLE_100
100: , p4_a15 JTF_DATE_TABLE
101: , p4_a16 JTF_DATE_TABLE
102: , p4_a17 JTF_NUMBER_TABLE
103: , p4_a18 JTF_NUMBER_TABLE
104: , p4_a19 JTF_NUMBER_TABLE
105: , p4_a20 JTF_NUMBER_TABLE
106: , p4_a21 JTF_NUMBER_TABLE
99: , p4_a14 JTF_VARCHAR2_TABLE_100
100: , p4_a15 JTF_DATE_TABLE
101: , p4_a16 JTF_DATE_TABLE
102: , p4_a17 JTF_NUMBER_TABLE
103: , p4_a18 JTF_NUMBER_TABLE
104: , p4_a19 JTF_NUMBER_TABLE
105: , p4_a20 JTF_NUMBER_TABLE
106: , p4_a21 JTF_NUMBER_TABLE
107: , p4_a22 JTF_NUMBER_TABLE
100: , p4_a15 JTF_DATE_TABLE
101: , p4_a16 JTF_DATE_TABLE
102: , p4_a17 JTF_NUMBER_TABLE
103: , p4_a18 JTF_NUMBER_TABLE
104: , p4_a19 JTF_NUMBER_TABLE
105: , p4_a20 JTF_NUMBER_TABLE
106: , p4_a21 JTF_NUMBER_TABLE
107: , p4_a22 JTF_NUMBER_TABLE
108: , p4_a23 JTF_NUMBER_TABLE
101: , p4_a16 JTF_DATE_TABLE
102: , p4_a17 JTF_NUMBER_TABLE
103: , p4_a18 JTF_NUMBER_TABLE
104: , p4_a19 JTF_NUMBER_TABLE
105: , p4_a20 JTF_NUMBER_TABLE
106: , p4_a21 JTF_NUMBER_TABLE
107: , p4_a22 JTF_NUMBER_TABLE
108: , p4_a23 JTF_NUMBER_TABLE
109: , p4_a24 JTF_NUMBER_TABLE
102: , p4_a17 JTF_NUMBER_TABLE
103: , p4_a18 JTF_NUMBER_TABLE
104: , p4_a19 JTF_NUMBER_TABLE
105: , p4_a20 JTF_NUMBER_TABLE
106: , p4_a21 JTF_NUMBER_TABLE
107: , p4_a22 JTF_NUMBER_TABLE
108: , p4_a23 JTF_NUMBER_TABLE
109: , p4_a24 JTF_NUMBER_TABLE
110: , p4_a25 JTF_VARCHAR2_TABLE_300
103: , p4_a18 JTF_NUMBER_TABLE
104: , p4_a19 JTF_NUMBER_TABLE
105: , p4_a20 JTF_NUMBER_TABLE
106: , p4_a21 JTF_NUMBER_TABLE
107: , p4_a22 JTF_NUMBER_TABLE
108: , p4_a23 JTF_NUMBER_TABLE
109: , p4_a24 JTF_NUMBER_TABLE
110: , p4_a25 JTF_VARCHAR2_TABLE_300
111: , p4_a26 JTF_NUMBER_TABLE
104: , p4_a19 JTF_NUMBER_TABLE
105: , p4_a20 JTF_NUMBER_TABLE
106: , p4_a21 JTF_NUMBER_TABLE
107: , p4_a22 JTF_NUMBER_TABLE
108: , p4_a23 JTF_NUMBER_TABLE
109: , p4_a24 JTF_NUMBER_TABLE
110: , p4_a25 JTF_VARCHAR2_TABLE_300
111: , p4_a26 JTF_NUMBER_TABLE
112: , p4_a27 JTF_NUMBER_TABLE
105: , p4_a20 JTF_NUMBER_TABLE
106: , p4_a21 JTF_NUMBER_TABLE
107: , p4_a22 JTF_NUMBER_TABLE
108: , p4_a23 JTF_NUMBER_TABLE
109: , p4_a24 JTF_NUMBER_TABLE
110: , p4_a25 JTF_VARCHAR2_TABLE_300
111: , p4_a26 JTF_NUMBER_TABLE
112: , p4_a27 JTF_NUMBER_TABLE
113: , p4_a28 JTF_VARCHAR2_TABLE_4000
107: , p4_a22 JTF_NUMBER_TABLE
108: , p4_a23 JTF_NUMBER_TABLE
109: , p4_a24 JTF_NUMBER_TABLE
110: , p4_a25 JTF_VARCHAR2_TABLE_300
111: , p4_a26 JTF_NUMBER_TABLE
112: , p4_a27 JTF_NUMBER_TABLE
113: , p4_a28 JTF_VARCHAR2_TABLE_4000
114: , p4_a29 JTF_NUMBER_TABLE
115: , p4_a30 JTF_NUMBER_TABLE
108: , p4_a23 JTF_NUMBER_TABLE
109: , p4_a24 JTF_NUMBER_TABLE
110: , p4_a25 JTF_VARCHAR2_TABLE_300
111: , p4_a26 JTF_NUMBER_TABLE
112: , p4_a27 JTF_NUMBER_TABLE
113: , p4_a28 JTF_VARCHAR2_TABLE_4000
114: , p4_a29 JTF_NUMBER_TABLE
115: , p4_a30 JTF_NUMBER_TABLE
116: , p4_a31 JTF_VARCHAR2_TABLE_100
110: , p4_a25 JTF_VARCHAR2_TABLE_300
111: , p4_a26 JTF_NUMBER_TABLE
112: , p4_a27 JTF_NUMBER_TABLE
113: , p4_a28 JTF_VARCHAR2_TABLE_4000
114: , p4_a29 JTF_NUMBER_TABLE
115: , p4_a30 JTF_NUMBER_TABLE
116: , p4_a31 JTF_VARCHAR2_TABLE_100
117: , p4_a32 JTF_NUMBER_TABLE
118: , p4_a33 JTF_NUMBER_TABLE
111: , p4_a26 JTF_NUMBER_TABLE
112: , p4_a27 JTF_NUMBER_TABLE
113: , p4_a28 JTF_VARCHAR2_TABLE_4000
114: , p4_a29 JTF_NUMBER_TABLE
115: , p4_a30 JTF_NUMBER_TABLE
116: , p4_a31 JTF_VARCHAR2_TABLE_100
117: , p4_a32 JTF_NUMBER_TABLE
118: , p4_a33 JTF_NUMBER_TABLE
119: , p4_a34 JTF_NUMBER_TABLE
113: , p4_a28 JTF_VARCHAR2_TABLE_4000
114: , p4_a29 JTF_NUMBER_TABLE
115: , p4_a30 JTF_NUMBER_TABLE
116: , p4_a31 JTF_VARCHAR2_TABLE_100
117: , p4_a32 JTF_NUMBER_TABLE
118: , p4_a33 JTF_NUMBER_TABLE
119: , p4_a34 JTF_NUMBER_TABLE
120: , p4_a35 JTF_NUMBER_TABLE
121: , p4_a36 JTF_NUMBER_TABLE
114: , p4_a29 JTF_NUMBER_TABLE
115: , p4_a30 JTF_NUMBER_TABLE
116: , p4_a31 JTF_VARCHAR2_TABLE_100
117: , p4_a32 JTF_NUMBER_TABLE
118: , p4_a33 JTF_NUMBER_TABLE
119: , p4_a34 JTF_NUMBER_TABLE
120: , p4_a35 JTF_NUMBER_TABLE
121: , p4_a36 JTF_NUMBER_TABLE
122: , p4_a37 JTF_NUMBER_TABLE
115: , p4_a30 JTF_NUMBER_TABLE
116: , p4_a31 JTF_VARCHAR2_TABLE_100
117: , p4_a32 JTF_NUMBER_TABLE
118: , p4_a33 JTF_NUMBER_TABLE
119: , p4_a34 JTF_NUMBER_TABLE
120: , p4_a35 JTF_NUMBER_TABLE
121: , p4_a36 JTF_NUMBER_TABLE
122: , p4_a37 JTF_NUMBER_TABLE
123: , p4_a38 JTF_NUMBER_TABLE
116: , p4_a31 JTF_VARCHAR2_TABLE_100
117: , p4_a32 JTF_NUMBER_TABLE
118: , p4_a33 JTF_NUMBER_TABLE
119: , p4_a34 JTF_NUMBER_TABLE
120: , p4_a35 JTF_NUMBER_TABLE
121: , p4_a36 JTF_NUMBER_TABLE
122: , p4_a37 JTF_NUMBER_TABLE
123: , p4_a38 JTF_NUMBER_TABLE
124: , p4_a39 JTF_VARCHAR2_TABLE_100
117: , p4_a32 JTF_NUMBER_TABLE
118: , p4_a33 JTF_NUMBER_TABLE
119: , p4_a34 JTF_NUMBER_TABLE
120: , p4_a35 JTF_NUMBER_TABLE
121: , p4_a36 JTF_NUMBER_TABLE
122: , p4_a37 JTF_NUMBER_TABLE
123: , p4_a38 JTF_NUMBER_TABLE
124: , p4_a39 JTF_VARCHAR2_TABLE_100
125: , p4_a40 JTF_NUMBER_TABLE
118: , p4_a33 JTF_NUMBER_TABLE
119: , p4_a34 JTF_NUMBER_TABLE
120: , p4_a35 JTF_NUMBER_TABLE
121: , p4_a36 JTF_NUMBER_TABLE
122: , p4_a37 JTF_NUMBER_TABLE
123: , p4_a38 JTF_NUMBER_TABLE
124: , p4_a39 JTF_VARCHAR2_TABLE_100
125: , p4_a40 JTF_NUMBER_TABLE
126: , p4_a41 JTF_VARCHAR2_TABLE_300
119: , p4_a34 JTF_NUMBER_TABLE
120: , p4_a35 JTF_NUMBER_TABLE
121: , p4_a36 JTF_NUMBER_TABLE
122: , p4_a37 JTF_NUMBER_TABLE
123: , p4_a38 JTF_NUMBER_TABLE
124: , p4_a39 JTF_VARCHAR2_TABLE_100
125: , p4_a40 JTF_NUMBER_TABLE
126: , p4_a41 JTF_VARCHAR2_TABLE_300
127: , p4_a42 JTF_NUMBER_TABLE
121: , p4_a36 JTF_NUMBER_TABLE
122: , p4_a37 JTF_NUMBER_TABLE
123: , p4_a38 JTF_NUMBER_TABLE
124: , p4_a39 JTF_VARCHAR2_TABLE_100
125: , p4_a40 JTF_NUMBER_TABLE
126: , p4_a41 JTF_VARCHAR2_TABLE_300
127: , p4_a42 JTF_NUMBER_TABLE
128: , p4_a43 JTF_VARCHAR2_TABLE_100
129: , p4_a44 JTF_NUMBER_TABLE
123: , p4_a38 JTF_NUMBER_TABLE
124: , p4_a39 JTF_VARCHAR2_TABLE_100
125: , p4_a40 JTF_NUMBER_TABLE
126: , p4_a41 JTF_VARCHAR2_TABLE_300
127: , p4_a42 JTF_NUMBER_TABLE
128: , p4_a43 JTF_VARCHAR2_TABLE_100
129: , p4_a44 JTF_NUMBER_TABLE
130: , p4_a45 JTF_NUMBER_TABLE
131: , p4_a46 JTF_NUMBER_TABLE
125: , p4_a40 JTF_NUMBER_TABLE
126: , p4_a41 JTF_VARCHAR2_TABLE_300
127: , p4_a42 JTF_NUMBER_TABLE
128: , p4_a43 JTF_VARCHAR2_TABLE_100
129: , p4_a44 JTF_NUMBER_TABLE
130: , p4_a45 JTF_NUMBER_TABLE
131: , p4_a46 JTF_NUMBER_TABLE
132: , p4_a47 JTF_VARCHAR2_TABLE_100
133: , p4_a48 JTF_NUMBER_TABLE
126: , p4_a41 JTF_VARCHAR2_TABLE_300
127: , p4_a42 JTF_NUMBER_TABLE
128: , p4_a43 JTF_VARCHAR2_TABLE_100
129: , p4_a44 JTF_NUMBER_TABLE
130: , p4_a45 JTF_NUMBER_TABLE
131: , p4_a46 JTF_NUMBER_TABLE
132: , p4_a47 JTF_VARCHAR2_TABLE_100
133: , p4_a48 JTF_NUMBER_TABLE
134: , p4_a49 JTF_NUMBER_TABLE
127: , p4_a42 JTF_NUMBER_TABLE
128: , p4_a43 JTF_VARCHAR2_TABLE_100
129: , p4_a44 JTF_NUMBER_TABLE
130: , p4_a45 JTF_NUMBER_TABLE
131: , p4_a46 JTF_NUMBER_TABLE
132: , p4_a47 JTF_VARCHAR2_TABLE_100
133: , p4_a48 JTF_NUMBER_TABLE
134: , p4_a49 JTF_NUMBER_TABLE
135: , p4_a50 JTF_VARCHAR2_TABLE_100
129: , p4_a44 JTF_NUMBER_TABLE
130: , p4_a45 JTF_NUMBER_TABLE
131: , p4_a46 JTF_NUMBER_TABLE
132: , p4_a47 JTF_VARCHAR2_TABLE_100
133: , p4_a48 JTF_NUMBER_TABLE
134: , p4_a49 JTF_NUMBER_TABLE
135: , p4_a50 JTF_VARCHAR2_TABLE_100
136: , p4_a51 JTF_VARCHAR2_TABLE_300
137: , p4_a52 JTF_NUMBER_TABLE
130: , p4_a45 JTF_NUMBER_TABLE
131: , p4_a46 JTF_NUMBER_TABLE
132: , p4_a47 JTF_VARCHAR2_TABLE_100
133: , p4_a48 JTF_NUMBER_TABLE
134: , p4_a49 JTF_NUMBER_TABLE
135: , p4_a50 JTF_VARCHAR2_TABLE_100
136: , p4_a51 JTF_VARCHAR2_TABLE_300
137: , p4_a52 JTF_NUMBER_TABLE
138: , p4_a53 JTF_VARCHAR2_TABLE_100
133: , p4_a48 JTF_NUMBER_TABLE
134: , p4_a49 JTF_NUMBER_TABLE
135: , p4_a50 JTF_VARCHAR2_TABLE_100
136: , p4_a51 JTF_VARCHAR2_TABLE_300
137: , p4_a52 JTF_NUMBER_TABLE
138: , p4_a53 JTF_VARCHAR2_TABLE_100
139: , p4_a54 JTF_DATE_TABLE
140: , p4_a55 JTF_NUMBER_TABLE
141: , p4_a56 JTF_NUMBER_TABLE
136: , p4_a51 JTF_VARCHAR2_TABLE_300
137: , p4_a52 JTF_NUMBER_TABLE
138: , p4_a53 JTF_VARCHAR2_TABLE_100
139: , p4_a54 JTF_DATE_TABLE
140: , p4_a55 JTF_NUMBER_TABLE
141: , p4_a56 JTF_NUMBER_TABLE
142: , p4_a57 JTF_NUMBER_TABLE
143: , p4_a58 JTF_NUMBER_TABLE
144: , p4_a59 JTF_VARCHAR2_TABLE_300
137: , p4_a52 JTF_NUMBER_TABLE
138: , p4_a53 JTF_VARCHAR2_TABLE_100
139: , p4_a54 JTF_DATE_TABLE
140: , p4_a55 JTF_NUMBER_TABLE
141: , p4_a56 JTF_NUMBER_TABLE
142: , p4_a57 JTF_NUMBER_TABLE
143: , p4_a58 JTF_NUMBER_TABLE
144: , p4_a59 JTF_VARCHAR2_TABLE_300
145: , p4_a60 JTF_NUMBER_TABLE
138: , p4_a53 JTF_VARCHAR2_TABLE_100
139: , p4_a54 JTF_DATE_TABLE
140: , p4_a55 JTF_NUMBER_TABLE
141: , p4_a56 JTF_NUMBER_TABLE
142: , p4_a57 JTF_NUMBER_TABLE
143: , p4_a58 JTF_NUMBER_TABLE
144: , p4_a59 JTF_VARCHAR2_TABLE_300
145: , p4_a60 JTF_NUMBER_TABLE
146: , p4_a61 JTF_NUMBER_TABLE
139: , p4_a54 JTF_DATE_TABLE
140: , p4_a55 JTF_NUMBER_TABLE
141: , p4_a56 JTF_NUMBER_TABLE
142: , p4_a57 JTF_NUMBER_TABLE
143: , p4_a58 JTF_NUMBER_TABLE
144: , p4_a59 JTF_VARCHAR2_TABLE_300
145: , p4_a60 JTF_NUMBER_TABLE
146: , p4_a61 JTF_NUMBER_TABLE
147: , p4_a62 JTF_NUMBER_TABLE
141: , p4_a56 JTF_NUMBER_TABLE
142: , p4_a57 JTF_NUMBER_TABLE
143: , p4_a58 JTF_NUMBER_TABLE
144: , p4_a59 JTF_VARCHAR2_TABLE_300
145: , p4_a60 JTF_NUMBER_TABLE
146: , p4_a61 JTF_NUMBER_TABLE
147: , p4_a62 JTF_NUMBER_TABLE
148: , p4_a63 JTF_NUMBER_TABLE
149: , p4_a64 JTF_NUMBER_TABLE
142: , p4_a57 JTF_NUMBER_TABLE
143: , p4_a58 JTF_NUMBER_TABLE
144: , p4_a59 JTF_VARCHAR2_TABLE_300
145: , p4_a60 JTF_NUMBER_TABLE
146: , p4_a61 JTF_NUMBER_TABLE
147: , p4_a62 JTF_NUMBER_TABLE
148: , p4_a63 JTF_NUMBER_TABLE
149: , p4_a64 JTF_NUMBER_TABLE
150: , p4_a65 JTF_NUMBER_TABLE
143: , p4_a58 JTF_NUMBER_TABLE
144: , p4_a59 JTF_VARCHAR2_TABLE_300
145: , p4_a60 JTF_NUMBER_TABLE
146: , p4_a61 JTF_NUMBER_TABLE
147: , p4_a62 JTF_NUMBER_TABLE
148: , p4_a63 JTF_NUMBER_TABLE
149: , p4_a64 JTF_NUMBER_TABLE
150: , p4_a65 JTF_NUMBER_TABLE
151: , x_return_status out nocopy VARCHAR2
144: , p4_a59 JTF_VARCHAR2_TABLE_300
145: , p4_a60 JTF_NUMBER_TABLE
146: , p4_a61 JTF_NUMBER_TABLE
147: , p4_a62 JTF_NUMBER_TABLE
148: , p4_a63 JTF_NUMBER_TABLE
149: , p4_a64 JTF_NUMBER_TABLE
150: , p4_a65 JTF_NUMBER_TABLE
151: , x_return_status out nocopy VARCHAR2
152: , x_msg_count out nocopy NUMBER
145: , p4_a60 JTF_NUMBER_TABLE
146: , p4_a61 JTF_NUMBER_TABLE
147: , p4_a62 JTF_NUMBER_TABLE
148: , p4_a63 JTF_NUMBER_TABLE
149: , p4_a64 JTF_NUMBER_TABLE
150: , p4_a65 JTF_NUMBER_TABLE
151: , x_return_status out nocopy VARCHAR2
152: , x_msg_count out nocopy NUMBER
153: , x_msg_data out nocopy VARCHAR2
146: , p4_a61 JTF_NUMBER_TABLE
147: , p4_a62 JTF_NUMBER_TABLE
148: , p4_a63 JTF_NUMBER_TABLE
149: , p4_a64 JTF_NUMBER_TABLE
150: , p4_a65 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: )
335: , p_commit VARCHAR2
336: , p_init_msg_list VARCHAR2
337: , p_validation_level NUMBER
338: , p_org_id NUMBER
339: , p5_a0 in out nocopy JTF_NUMBER_TABLE
340: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
341: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_300
342: , p5_a3 in out nocopy JTF_NUMBER_TABLE
343: , p5_a4 in out nocopy JTF_DATE_TABLE
338: , p_org_id NUMBER
339: , p5_a0 in out nocopy JTF_NUMBER_TABLE
340: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
341: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_300
342: , p5_a3 in out nocopy JTF_NUMBER_TABLE
343: , p5_a4 in out nocopy JTF_DATE_TABLE
344: , p5_a5 in out nocopy JTF_DATE_TABLE
345: , x_return_status out nocopy VARCHAR2
346: , x_msg_count out nocopy NUMBER
402: , p_commit VARCHAR2
403: , p_init_msg_list VARCHAR2
404: , p_validation_level NUMBER
405: , p_cu_id NUMBER
406: , p5_a0 out nocopy JTF_NUMBER_TABLE
407: , p5_a1 out nocopy JTF_NUMBER_TABLE
408: , p5_a2 out nocopy JTF_NUMBER_TABLE
409: , p5_a3 out nocopy JTF_NUMBER_TABLE
410: , p5_a4 out nocopy JTF_NUMBER_TABLE
403: , p_init_msg_list VARCHAR2
404: , p_validation_level NUMBER
405: , p_cu_id NUMBER
406: , p5_a0 out nocopy JTF_NUMBER_TABLE
407: , p5_a1 out nocopy JTF_NUMBER_TABLE
408: , p5_a2 out nocopy JTF_NUMBER_TABLE
409: , p5_a3 out nocopy JTF_NUMBER_TABLE
410: , p5_a4 out nocopy JTF_NUMBER_TABLE
411: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
404: , p_validation_level NUMBER
405: , p_cu_id NUMBER
406: , p5_a0 out nocopy JTF_NUMBER_TABLE
407: , p5_a1 out nocopy JTF_NUMBER_TABLE
408: , p5_a2 out nocopy JTF_NUMBER_TABLE
409: , p5_a3 out nocopy JTF_NUMBER_TABLE
410: , p5_a4 out nocopy JTF_NUMBER_TABLE
411: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
412: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
405: , p_cu_id NUMBER
406: , p5_a0 out nocopy JTF_NUMBER_TABLE
407: , p5_a1 out nocopy JTF_NUMBER_TABLE
408: , p5_a2 out nocopy JTF_NUMBER_TABLE
409: , p5_a3 out nocopy JTF_NUMBER_TABLE
410: , p5_a4 out nocopy JTF_NUMBER_TABLE
411: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
412: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
413: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
406: , p5_a0 out nocopy JTF_NUMBER_TABLE
407: , p5_a1 out nocopy JTF_NUMBER_TABLE
408: , p5_a2 out nocopy JTF_NUMBER_TABLE
409: , p5_a3 out nocopy JTF_NUMBER_TABLE
410: , p5_a4 out nocopy JTF_NUMBER_TABLE
411: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
412: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
413: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
414: , p5_a8 out nocopy JTF_NUMBER_TABLE
410: , p5_a4 out nocopy JTF_NUMBER_TABLE
411: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
412: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
413: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
414: , p5_a8 out nocopy JTF_NUMBER_TABLE
415: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_300
417: , p5_a11 out nocopy JTF_NUMBER_TABLE
418: , p5_a12 out nocopy JTF_NUMBER_TABLE
413: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
414: , p5_a8 out nocopy JTF_NUMBER_TABLE
415: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_300
417: , p5_a11 out nocopy JTF_NUMBER_TABLE
418: , p5_a12 out nocopy JTF_NUMBER_TABLE
419: , p5_a13 out nocopy JTF_NUMBER_TABLE
420: , x_return_status out nocopy VARCHAR2
421: , x_msg_count out nocopy NUMBER
414: , p5_a8 out nocopy JTF_NUMBER_TABLE
415: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_300
417: , p5_a11 out nocopy JTF_NUMBER_TABLE
418: , p5_a12 out nocopy JTF_NUMBER_TABLE
419: , p5_a13 out nocopy JTF_NUMBER_TABLE
420: , x_return_status out nocopy VARCHAR2
421: , x_msg_count out nocopy NUMBER
422: , x_msg_data out nocopy VARCHAR2
415: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_300
417: , p5_a11 out nocopy JTF_NUMBER_TABLE
418: , p5_a12 out nocopy JTF_NUMBER_TABLE
419: , p5_a13 out nocopy JTF_NUMBER_TABLE
420: , x_return_status out nocopy VARCHAR2
421: , x_msg_count out nocopy NUMBER
422: , x_msg_data out nocopy VARCHAR2
423: )
679: , p_commit VARCHAR2
680: , p_init_msg_list VARCHAR2
681: , p_validation_level NUMBER
682: , p_ce_id NUMBER
683: , p5_a0 in out nocopy JTF_NUMBER_TABLE
684: , p5_a1 in out nocopy JTF_NUMBER_TABLE
685: , p5_a2 in out nocopy JTF_NUMBER_TABLE
686: , p5_a3 in out nocopy JTF_NUMBER_TABLE
687: , p5_a4 in out nocopy JTF_NUMBER_TABLE
680: , p_init_msg_list VARCHAR2
681: , p_validation_level NUMBER
682: , p_ce_id NUMBER
683: , p5_a0 in out nocopy JTF_NUMBER_TABLE
684: , p5_a1 in out nocopy JTF_NUMBER_TABLE
685: , p5_a2 in out nocopy JTF_NUMBER_TABLE
686: , p5_a3 in out nocopy JTF_NUMBER_TABLE
687: , p5_a4 in out nocopy JTF_NUMBER_TABLE
688: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
681: , p_validation_level NUMBER
682: , p_ce_id NUMBER
683: , p5_a0 in out nocopy JTF_NUMBER_TABLE
684: , p5_a1 in out nocopy JTF_NUMBER_TABLE
685: , p5_a2 in out nocopy JTF_NUMBER_TABLE
686: , p5_a3 in out nocopy JTF_NUMBER_TABLE
687: , p5_a4 in out nocopy JTF_NUMBER_TABLE
688: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
689: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_300
682: , p_ce_id NUMBER
683: , p5_a0 in out nocopy JTF_NUMBER_TABLE
684: , p5_a1 in out nocopy JTF_NUMBER_TABLE
685: , p5_a2 in out nocopy JTF_NUMBER_TABLE
686: , p5_a3 in out nocopy JTF_NUMBER_TABLE
687: , p5_a4 in out nocopy JTF_NUMBER_TABLE
688: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
689: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_300
690: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
683: , p5_a0 in out nocopy JTF_NUMBER_TABLE
684: , p5_a1 in out nocopy JTF_NUMBER_TABLE
685: , p5_a2 in out nocopy JTF_NUMBER_TABLE
686: , p5_a3 in out nocopy JTF_NUMBER_TABLE
687: , p5_a4 in out nocopy JTF_NUMBER_TABLE
688: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
689: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_300
690: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
691: , p5_a8 in out nocopy JTF_NUMBER_TABLE
687: , p5_a4 in out nocopy JTF_NUMBER_TABLE
688: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
689: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_300
690: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
691: , p5_a8 in out nocopy JTF_NUMBER_TABLE
692: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
693: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
694: , p5_a11 in out nocopy JTF_NUMBER_TABLE
695: , p5_a12 in out nocopy JTF_NUMBER_TABLE
690: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
691: , p5_a8 in out nocopy JTF_NUMBER_TABLE
692: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
693: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
694: , p5_a11 in out nocopy JTF_NUMBER_TABLE
695: , p5_a12 in out nocopy JTF_NUMBER_TABLE
696: , p5_a13 in out nocopy JTF_NUMBER_TABLE
697: , x_return_status out nocopy VARCHAR2
698: , x_msg_count out nocopy NUMBER
691: , p5_a8 in out nocopy JTF_NUMBER_TABLE
692: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
693: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
694: , p5_a11 in out nocopy JTF_NUMBER_TABLE
695: , p5_a12 in out nocopy JTF_NUMBER_TABLE
696: , p5_a13 in out nocopy JTF_NUMBER_TABLE
697: , x_return_status out nocopy VARCHAR2
698: , x_msg_count out nocopy NUMBER
699: , x_msg_data out nocopy VARCHAR2
692: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
693: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
694: , p5_a11 in out nocopy JTF_NUMBER_TABLE
695: , p5_a12 in out nocopy JTF_NUMBER_TABLE
696: , p5_a13 in out nocopy JTF_NUMBER_TABLE
697: , x_return_status out nocopy VARCHAR2
698: , x_msg_count out nocopy NUMBER
699: , x_msg_data out nocopy VARCHAR2
700: )