APPS.OKL_INS_PRODUCTS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 8: , p5_a0 JTF_NUMBER_TABLE

4: , p_init_msg_list VARCHAR2
5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE

Line 9: , p5_a1 JTF_NUMBER_TABLE

5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 11: , p5_a3 JTF_NUMBER_TABLE

7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 12: , p5_a4 JTF_NUMBER_TABLE

8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_300
16: , p5_a8 JTF_NUMBER_TABLE

Line 16: , p5_a8 JTF_NUMBER_TABLE

12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_300
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_DATE_TABLE
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_DATE_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 18: , p5_a10 JTF_NUMBER_TABLE

14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_300
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_DATE_TABLE
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_DATE_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_100
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_NUMBER_TABLE

Line 22: , p5_a14 JTF_NUMBER_TABLE

18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_DATE_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_100
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_NUMBER_TABLE
26: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 23: , p5_a15 JTF_NUMBER_TABLE

19: , p5_a11 JTF_DATE_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_100
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_NUMBER_TABLE
26: , p5_a18 JTF_VARCHAR2_TABLE_100
27: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 24: , p5_a16 JTF_NUMBER_TABLE

20: , p5_a12 JTF_VARCHAR2_TABLE_100
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_NUMBER_TABLE
26: , p5_a18 JTF_VARCHAR2_TABLE_100
27: , p5_a19 JTF_VARCHAR2_TABLE_100
28: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 25: , p5_a17 JTF_NUMBER_TABLE

21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_NUMBER_TABLE
26: , p5_a18 JTF_VARCHAR2_TABLE_100
27: , p5_a19 JTF_VARCHAR2_TABLE_100
28: , p5_a20 JTF_VARCHAR2_TABLE_500
29: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 43: , p5_a35 JTF_NUMBER_TABLE

39: , p5_a31 JTF_VARCHAR2_TABLE_500
40: , p5_a32 JTF_VARCHAR2_TABLE_500
41: , p5_a33 JTF_VARCHAR2_TABLE_500
42: , p5_a34 JTF_VARCHAR2_TABLE_500
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE

Line 45: , p5_a37 JTF_NUMBER_TABLE

41: , p5_a33 JTF_VARCHAR2_TABLE_500
42: , p5_a34 JTF_VARCHAR2_TABLE_500
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 47: , p5_a39 JTF_NUMBER_TABLE

43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE
50: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 48: , p6_a0 out nocopy JTF_NUMBER_TABLE

44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE
50: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , p6_a3 out nocopy JTF_NUMBER_TABLE
52: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 49: , p6_a1 out nocopy JTF_NUMBER_TABLE

45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE
50: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , p6_a3 out nocopy JTF_NUMBER_TABLE
52: , p6_a4 out nocopy JTF_NUMBER_TABLE
53: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , p6_a3 out nocopy JTF_NUMBER_TABLE

47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE
50: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , p6_a3 out nocopy JTF_NUMBER_TABLE
52: , p6_a4 out nocopy JTF_NUMBER_TABLE
53: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 52: , p6_a4 out nocopy JTF_NUMBER_TABLE

48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE
50: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , p6_a3 out nocopy JTF_NUMBER_TABLE
52: , p6_a4 out nocopy JTF_NUMBER_TABLE
53: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 56: , p6_a8 out nocopy JTF_NUMBER_TABLE

52: , p6_a4 out nocopy JTF_NUMBER_TABLE
53: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , p6_a8 out nocopy JTF_NUMBER_TABLE
57: , p6_a9 out nocopy JTF_DATE_TABLE
58: , p6_a10 out nocopy JTF_NUMBER_TABLE
59: , p6_a11 out nocopy JTF_DATE_TABLE
60: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , p6_a10 out nocopy JTF_NUMBER_TABLE

54: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , p6_a8 out nocopy JTF_NUMBER_TABLE
57: , p6_a9 out nocopy JTF_DATE_TABLE
58: , p6_a10 out nocopy JTF_NUMBER_TABLE
59: , p6_a11 out nocopy JTF_DATE_TABLE
60: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
62: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 62: , p6_a14 out nocopy JTF_NUMBER_TABLE

58: , p6_a10 out nocopy JTF_NUMBER_TABLE
59: , p6_a11 out nocopy JTF_DATE_TABLE
60: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
62: , p6_a14 out nocopy JTF_NUMBER_TABLE
63: , p6_a15 out nocopy JTF_NUMBER_TABLE
64: , p6_a16 out nocopy JTF_NUMBER_TABLE
65: , p6_a17 out nocopy JTF_NUMBER_TABLE
66: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 63: , p6_a15 out nocopy JTF_NUMBER_TABLE

59: , p6_a11 out nocopy JTF_DATE_TABLE
60: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
62: , p6_a14 out nocopy JTF_NUMBER_TABLE
63: , p6_a15 out nocopy JTF_NUMBER_TABLE
64: , p6_a16 out nocopy JTF_NUMBER_TABLE
65: , p6_a17 out nocopy JTF_NUMBER_TABLE
66: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
67: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , p6_a16 out nocopy JTF_NUMBER_TABLE

60: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
62: , p6_a14 out nocopy JTF_NUMBER_TABLE
63: , p6_a15 out nocopy JTF_NUMBER_TABLE
64: , p6_a16 out nocopy JTF_NUMBER_TABLE
65: , p6_a17 out nocopy JTF_NUMBER_TABLE
66: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
67: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
68: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 65: , p6_a17 out nocopy JTF_NUMBER_TABLE

61: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
62: , p6_a14 out nocopy JTF_NUMBER_TABLE
63: , p6_a15 out nocopy JTF_NUMBER_TABLE
64: , p6_a16 out nocopy JTF_NUMBER_TABLE
65: , p6_a17 out nocopy JTF_NUMBER_TABLE
66: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
67: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
68: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
69: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 83: , p6_a35 out nocopy JTF_NUMBER_TABLE

79: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
80: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
81: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
82: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
83: , p6_a35 out nocopy JTF_NUMBER_TABLE
84: , p6_a36 out nocopy JTF_DATE_TABLE
85: , p6_a37 out nocopy JTF_NUMBER_TABLE
86: , p6_a38 out nocopy JTF_DATE_TABLE
87: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 85: , p6_a37 out nocopy JTF_NUMBER_TABLE

81: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
82: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
83: , p6_a35 out nocopy JTF_NUMBER_TABLE
84: , p6_a36 out nocopy JTF_DATE_TABLE
85: , p6_a37 out nocopy JTF_NUMBER_TABLE
86: , p6_a38 out nocopy JTF_DATE_TABLE
87: , p6_a39 out nocopy JTF_NUMBER_TABLE
88: );
89: procedure insert_ins_products(p_api_version NUMBER

Line 87: , p6_a39 out nocopy JTF_NUMBER_TABLE

83: , p6_a35 out nocopy JTF_NUMBER_TABLE
84: , p6_a36 out nocopy JTF_DATE_TABLE
85: , p6_a37 out nocopy JTF_NUMBER_TABLE
86: , p6_a38 out nocopy JTF_DATE_TABLE
87: , p6_a39 out nocopy JTF_NUMBER_TABLE
88: );
89: procedure insert_ins_products(p_api_version NUMBER
90: , p_init_msg_list VARCHAR2
91: , x_return_status out nocopy VARCHAR2

Line 180: , p5_a0 JTF_NUMBER_TABLE

176: , p_init_msg_list VARCHAR2
177: , x_return_status out nocopy VARCHAR2
178: , x_msg_count out nocopy NUMBER
179: , x_msg_data out nocopy VARCHAR2
180: , p5_a0 JTF_NUMBER_TABLE
181: , p5_a1 JTF_NUMBER_TABLE
182: , p5_a2 JTF_VARCHAR2_TABLE_100
183: , p5_a3 JTF_NUMBER_TABLE
184: , p5_a4 JTF_NUMBER_TABLE

Line 181: , p5_a1 JTF_NUMBER_TABLE

177: , x_return_status out nocopy VARCHAR2
178: , x_msg_count out nocopy NUMBER
179: , x_msg_data out nocopy VARCHAR2
180: , p5_a0 JTF_NUMBER_TABLE
181: , p5_a1 JTF_NUMBER_TABLE
182: , p5_a2 JTF_VARCHAR2_TABLE_100
183: , p5_a3 JTF_NUMBER_TABLE
184: , p5_a4 JTF_NUMBER_TABLE
185: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 183: , p5_a3 JTF_NUMBER_TABLE

179: , x_msg_data out nocopy VARCHAR2
180: , p5_a0 JTF_NUMBER_TABLE
181: , p5_a1 JTF_NUMBER_TABLE
182: , p5_a2 JTF_VARCHAR2_TABLE_100
183: , p5_a3 JTF_NUMBER_TABLE
184: , p5_a4 JTF_NUMBER_TABLE
185: , p5_a5 JTF_VARCHAR2_TABLE_100
186: , p5_a6 JTF_VARCHAR2_TABLE_100
187: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 184: , p5_a4 JTF_NUMBER_TABLE

180: , p5_a0 JTF_NUMBER_TABLE
181: , p5_a1 JTF_NUMBER_TABLE
182: , p5_a2 JTF_VARCHAR2_TABLE_100
183: , p5_a3 JTF_NUMBER_TABLE
184: , p5_a4 JTF_NUMBER_TABLE
185: , p5_a5 JTF_VARCHAR2_TABLE_100
186: , p5_a6 JTF_VARCHAR2_TABLE_100
187: , p5_a7 JTF_VARCHAR2_TABLE_300
188: , p5_a8 JTF_NUMBER_TABLE

Line 188: , p5_a8 JTF_NUMBER_TABLE

184: , p5_a4 JTF_NUMBER_TABLE
185: , p5_a5 JTF_VARCHAR2_TABLE_100
186: , p5_a6 JTF_VARCHAR2_TABLE_100
187: , p5_a7 JTF_VARCHAR2_TABLE_300
188: , p5_a8 JTF_NUMBER_TABLE
189: , p5_a9 JTF_DATE_TABLE
190: , p5_a10 JTF_NUMBER_TABLE
191: , p5_a11 JTF_DATE_TABLE
192: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 190: , p5_a10 JTF_NUMBER_TABLE

186: , p5_a6 JTF_VARCHAR2_TABLE_100
187: , p5_a7 JTF_VARCHAR2_TABLE_300
188: , p5_a8 JTF_NUMBER_TABLE
189: , p5_a9 JTF_DATE_TABLE
190: , p5_a10 JTF_NUMBER_TABLE
191: , p5_a11 JTF_DATE_TABLE
192: , p5_a12 JTF_VARCHAR2_TABLE_100
193: , p5_a13 JTF_VARCHAR2_TABLE_100
194: , p5_a14 JTF_NUMBER_TABLE

Line 194: , p5_a14 JTF_NUMBER_TABLE

190: , p5_a10 JTF_NUMBER_TABLE
191: , p5_a11 JTF_DATE_TABLE
192: , p5_a12 JTF_VARCHAR2_TABLE_100
193: , p5_a13 JTF_VARCHAR2_TABLE_100
194: , p5_a14 JTF_NUMBER_TABLE
195: , p5_a15 JTF_NUMBER_TABLE
196: , p5_a16 JTF_NUMBER_TABLE
197: , p5_a17 JTF_NUMBER_TABLE
198: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 195: , p5_a15 JTF_NUMBER_TABLE

191: , p5_a11 JTF_DATE_TABLE
192: , p5_a12 JTF_VARCHAR2_TABLE_100
193: , p5_a13 JTF_VARCHAR2_TABLE_100
194: , p5_a14 JTF_NUMBER_TABLE
195: , p5_a15 JTF_NUMBER_TABLE
196: , p5_a16 JTF_NUMBER_TABLE
197: , p5_a17 JTF_NUMBER_TABLE
198: , p5_a18 JTF_VARCHAR2_TABLE_100
199: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 196: , p5_a16 JTF_NUMBER_TABLE

192: , p5_a12 JTF_VARCHAR2_TABLE_100
193: , p5_a13 JTF_VARCHAR2_TABLE_100
194: , p5_a14 JTF_NUMBER_TABLE
195: , p5_a15 JTF_NUMBER_TABLE
196: , p5_a16 JTF_NUMBER_TABLE
197: , p5_a17 JTF_NUMBER_TABLE
198: , p5_a18 JTF_VARCHAR2_TABLE_100
199: , p5_a19 JTF_VARCHAR2_TABLE_100
200: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 197: , p5_a17 JTF_NUMBER_TABLE

193: , p5_a13 JTF_VARCHAR2_TABLE_100
194: , p5_a14 JTF_NUMBER_TABLE
195: , p5_a15 JTF_NUMBER_TABLE
196: , p5_a16 JTF_NUMBER_TABLE
197: , p5_a17 JTF_NUMBER_TABLE
198: , p5_a18 JTF_VARCHAR2_TABLE_100
199: , p5_a19 JTF_VARCHAR2_TABLE_100
200: , p5_a20 JTF_VARCHAR2_TABLE_500
201: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 215: , p5_a35 JTF_NUMBER_TABLE

211: , p5_a31 JTF_VARCHAR2_TABLE_500
212: , p5_a32 JTF_VARCHAR2_TABLE_500
213: , p5_a33 JTF_VARCHAR2_TABLE_500
214: , p5_a34 JTF_VARCHAR2_TABLE_500
215: , p5_a35 JTF_NUMBER_TABLE
216: , p5_a36 JTF_DATE_TABLE
217: , p5_a37 JTF_NUMBER_TABLE
218: , p5_a38 JTF_DATE_TABLE
219: , p5_a39 JTF_NUMBER_TABLE

Line 217: , p5_a37 JTF_NUMBER_TABLE

213: , p5_a33 JTF_VARCHAR2_TABLE_500
214: , p5_a34 JTF_VARCHAR2_TABLE_500
215: , p5_a35 JTF_NUMBER_TABLE
216: , p5_a36 JTF_DATE_TABLE
217: , p5_a37 JTF_NUMBER_TABLE
218: , p5_a38 JTF_DATE_TABLE
219: , p5_a39 JTF_NUMBER_TABLE
220: );
221: procedure lock_ins_products(p_api_version NUMBER

Line 219: , p5_a39 JTF_NUMBER_TABLE

215: , p5_a35 JTF_NUMBER_TABLE
216: , p5_a36 JTF_DATE_TABLE
217: , p5_a37 JTF_NUMBER_TABLE
218: , p5_a38 JTF_DATE_TABLE
219: , p5_a39 JTF_NUMBER_TABLE
220: );
221: procedure lock_ins_products(p_api_version NUMBER
222: , p_init_msg_list VARCHAR2
223: , x_return_status out nocopy VARCHAR2

Line 272: , p5_a0 JTF_NUMBER_TABLE

268: , p_init_msg_list VARCHAR2
269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE

Line 273: , p5_a1 JTF_NUMBER_TABLE

269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 275: , p5_a3 JTF_NUMBER_TABLE

271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_VARCHAR2_TABLE_100
278: , p5_a6 JTF_VARCHAR2_TABLE_100
279: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 276: , p5_a4 JTF_NUMBER_TABLE

272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_VARCHAR2_TABLE_100
278: , p5_a6 JTF_VARCHAR2_TABLE_100
279: , p5_a7 JTF_VARCHAR2_TABLE_300
280: , p5_a8 JTF_NUMBER_TABLE

Line 280: , p5_a8 JTF_NUMBER_TABLE

276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_VARCHAR2_TABLE_100
278: , p5_a6 JTF_VARCHAR2_TABLE_100
279: , p5_a7 JTF_VARCHAR2_TABLE_300
280: , p5_a8 JTF_NUMBER_TABLE
281: , p5_a9 JTF_DATE_TABLE
282: , p5_a10 JTF_NUMBER_TABLE
283: , p5_a11 JTF_DATE_TABLE
284: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 282: , p5_a10 JTF_NUMBER_TABLE

278: , p5_a6 JTF_VARCHAR2_TABLE_100
279: , p5_a7 JTF_VARCHAR2_TABLE_300
280: , p5_a8 JTF_NUMBER_TABLE
281: , p5_a9 JTF_DATE_TABLE
282: , p5_a10 JTF_NUMBER_TABLE
283: , p5_a11 JTF_DATE_TABLE
284: , p5_a12 JTF_VARCHAR2_TABLE_100
285: , p5_a13 JTF_VARCHAR2_TABLE_100
286: , p5_a14 JTF_NUMBER_TABLE

Line 286: , p5_a14 JTF_NUMBER_TABLE

282: , p5_a10 JTF_NUMBER_TABLE
283: , p5_a11 JTF_DATE_TABLE
284: , p5_a12 JTF_VARCHAR2_TABLE_100
285: , p5_a13 JTF_VARCHAR2_TABLE_100
286: , p5_a14 JTF_NUMBER_TABLE
287: , p5_a15 JTF_NUMBER_TABLE
288: , p5_a16 JTF_NUMBER_TABLE
289: , p5_a17 JTF_NUMBER_TABLE
290: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 287: , p5_a15 JTF_NUMBER_TABLE

283: , p5_a11 JTF_DATE_TABLE
284: , p5_a12 JTF_VARCHAR2_TABLE_100
285: , p5_a13 JTF_VARCHAR2_TABLE_100
286: , p5_a14 JTF_NUMBER_TABLE
287: , p5_a15 JTF_NUMBER_TABLE
288: , p5_a16 JTF_NUMBER_TABLE
289: , p5_a17 JTF_NUMBER_TABLE
290: , p5_a18 JTF_VARCHAR2_TABLE_100
291: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 288: , p5_a16 JTF_NUMBER_TABLE

284: , p5_a12 JTF_VARCHAR2_TABLE_100
285: , p5_a13 JTF_VARCHAR2_TABLE_100
286: , p5_a14 JTF_NUMBER_TABLE
287: , p5_a15 JTF_NUMBER_TABLE
288: , p5_a16 JTF_NUMBER_TABLE
289: , p5_a17 JTF_NUMBER_TABLE
290: , p5_a18 JTF_VARCHAR2_TABLE_100
291: , p5_a19 JTF_VARCHAR2_TABLE_100
292: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 289: , p5_a17 JTF_NUMBER_TABLE

285: , p5_a13 JTF_VARCHAR2_TABLE_100
286: , p5_a14 JTF_NUMBER_TABLE
287: , p5_a15 JTF_NUMBER_TABLE
288: , p5_a16 JTF_NUMBER_TABLE
289: , p5_a17 JTF_NUMBER_TABLE
290: , p5_a18 JTF_VARCHAR2_TABLE_100
291: , p5_a19 JTF_VARCHAR2_TABLE_100
292: , p5_a20 JTF_VARCHAR2_TABLE_500
293: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 307: , p5_a35 JTF_NUMBER_TABLE

303: , p5_a31 JTF_VARCHAR2_TABLE_500
304: , p5_a32 JTF_VARCHAR2_TABLE_500
305: , p5_a33 JTF_VARCHAR2_TABLE_500
306: , p5_a34 JTF_VARCHAR2_TABLE_500
307: , p5_a35 JTF_NUMBER_TABLE
308: , p5_a36 JTF_DATE_TABLE
309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE

Line 309: , p5_a37 JTF_NUMBER_TABLE

305: , p5_a33 JTF_VARCHAR2_TABLE_500
306: , p5_a34 JTF_VARCHAR2_TABLE_500
307: , p5_a35 JTF_NUMBER_TABLE
308: , p5_a36 JTF_DATE_TABLE
309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 311: , p5_a39 JTF_NUMBER_TABLE

307: , p5_a35 JTF_NUMBER_TABLE
308: , p5_a36 JTF_DATE_TABLE
309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 312: , p6_a0 out nocopy JTF_NUMBER_TABLE

308: , p5_a36 JTF_DATE_TABLE
309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a3 out nocopy JTF_NUMBER_TABLE
316: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 313: , p6_a1 out nocopy JTF_NUMBER_TABLE

309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a3 out nocopy JTF_NUMBER_TABLE
316: , p6_a4 out nocopy JTF_NUMBER_TABLE
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 315: , p6_a3 out nocopy JTF_NUMBER_TABLE

311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a3 out nocopy JTF_NUMBER_TABLE
316: , p6_a4 out nocopy JTF_NUMBER_TABLE
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 316: , p6_a4 out nocopy JTF_NUMBER_TABLE

312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a3 out nocopy JTF_NUMBER_TABLE
316: , p6_a4 out nocopy JTF_NUMBER_TABLE
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
320: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 320: , p6_a8 out nocopy JTF_NUMBER_TABLE

316: , p6_a4 out nocopy JTF_NUMBER_TABLE
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
320: , p6_a8 out nocopy JTF_NUMBER_TABLE
321: , p6_a9 out nocopy JTF_DATE_TABLE
322: , p6_a10 out nocopy JTF_NUMBER_TABLE
323: , p6_a11 out nocopy JTF_DATE_TABLE
324: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 322: , p6_a10 out nocopy JTF_NUMBER_TABLE

318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
320: , p6_a8 out nocopy JTF_NUMBER_TABLE
321: , p6_a9 out nocopy JTF_DATE_TABLE
322: , p6_a10 out nocopy JTF_NUMBER_TABLE
323: , p6_a11 out nocopy JTF_DATE_TABLE
324: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 326: , p6_a14 out nocopy JTF_NUMBER_TABLE

322: , p6_a10 out nocopy JTF_NUMBER_TABLE
323: , p6_a11 out nocopy JTF_DATE_TABLE
324: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a14 out nocopy JTF_NUMBER_TABLE
327: , p6_a15 out nocopy JTF_NUMBER_TABLE
328: , p6_a16 out nocopy JTF_NUMBER_TABLE
329: , p6_a17 out nocopy JTF_NUMBER_TABLE
330: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 327: , p6_a15 out nocopy JTF_NUMBER_TABLE

323: , p6_a11 out nocopy JTF_DATE_TABLE
324: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a14 out nocopy JTF_NUMBER_TABLE
327: , p6_a15 out nocopy JTF_NUMBER_TABLE
328: , p6_a16 out nocopy JTF_NUMBER_TABLE
329: , p6_a17 out nocopy JTF_NUMBER_TABLE
330: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 328: , p6_a16 out nocopy JTF_NUMBER_TABLE

324: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a14 out nocopy JTF_NUMBER_TABLE
327: , p6_a15 out nocopy JTF_NUMBER_TABLE
328: , p6_a16 out nocopy JTF_NUMBER_TABLE
329: , p6_a17 out nocopy JTF_NUMBER_TABLE
330: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 329: , p6_a17 out nocopy JTF_NUMBER_TABLE

325: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a14 out nocopy JTF_NUMBER_TABLE
327: , p6_a15 out nocopy JTF_NUMBER_TABLE
328: , p6_a16 out nocopy JTF_NUMBER_TABLE
329: , p6_a17 out nocopy JTF_NUMBER_TABLE
330: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 347: , p6_a35 out nocopy JTF_NUMBER_TABLE

343: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
344: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
345: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
346: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
347: , p6_a35 out nocopy JTF_NUMBER_TABLE
348: , p6_a36 out nocopy JTF_DATE_TABLE
349: , p6_a37 out nocopy JTF_NUMBER_TABLE
350: , p6_a38 out nocopy JTF_DATE_TABLE
351: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 349: , p6_a37 out nocopy JTF_NUMBER_TABLE

345: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
346: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
347: , p6_a35 out nocopy JTF_NUMBER_TABLE
348: , p6_a36 out nocopy JTF_DATE_TABLE
349: , p6_a37 out nocopy JTF_NUMBER_TABLE
350: , p6_a38 out nocopy JTF_DATE_TABLE
351: , p6_a39 out nocopy JTF_NUMBER_TABLE
352: );
353: procedure update_ins_products(p_api_version NUMBER

Line 351: , p6_a39 out nocopy JTF_NUMBER_TABLE

347: , p6_a35 out nocopy JTF_NUMBER_TABLE
348: , p6_a36 out nocopy JTF_DATE_TABLE
349: , p6_a37 out nocopy JTF_NUMBER_TABLE
350: , p6_a38 out nocopy JTF_DATE_TABLE
351: , p6_a39 out nocopy JTF_NUMBER_TABLE
352: );
353: procedure update_ins_products(p_api_version NUMBER
354: , p_init_msg_list VARCHAR2
355: , x_return_status out nocopy VARCHAR2

Line 444: , p5_a0 JTF_NUMBER_TABLE

440: , p_init_msg_list VARCHAR2
441: , x_return_status out nocopy VARCHAR2
442: , x_msg_count out nocopy NUMBER
443: , x_msg_data out nocopy VARCHAR2
444: , p5_a0 JTF_NUMBER_TABLE
445: , p5_a1 JTF_NUMBER_TABLE
446: , p5_a2 JTF_VARCHAR2_TABLE_100
447: , p5_a3 JTF_NUMBER_TABLE
448: , p5_a4 JTF_NUMBER_TABLE

Line 445: , p5_a1 JTF_NUMBER_TABLE

441: , x_return_status out nocopy VARCHAR2
442: , x_msg_count out nocopy NUMBER
443: , x_msg_data out nocopy VARCHAR2
444: , p5_a0 JTF_NUMBER_TABLE
445: , p5_a1 JTF_NUMBER_TABLE
446: , p5_a2 JTF_VARCHAR2_TABLE_100
447: , p5_a3 JTF_NUMBER_TABLE
448: , p5_a4 JTF_NUMBER_TABLE
449: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 447: , p5_a3 JTF_NUMBER_TABLE

443: , x_msg_data out nocopy VARCHAR2
444: , p5_a0 JTF_NUMBER_TABLE
445: , p5_a1 JTF_NUMBER_TABLE
446: , p5_a2 JTF_VARCHAR2_TABLE_100
447: , p5_a3 JTF_NUMBER_TABLE
448: , p5_a4 JTF_NUMBER_TABLE
449: , p5_a5 JTF_VARCHAR2_TABLE_100
450: , p5_a6 JTF_VARCHAR2_TABLE_100
451: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 448: , p5_a4 JTF_NUMBER_TABLE

444: , p5_a0 JTF_NUMBER_TABLE
445: , p5_a1 JTF_NUMBER_TABLE
446: , p5_a2 JTF_VARCHAR2_TABLE_100
447: , p5_a3 JTF_NUMBER_TABLE
448: , p5_a4 JTF_NUMBER_TABLE
449: , p5_a5 JTF_VARCHAR2_TABLE_100
450: , p5_a6 JTF_VARCHAR2_TABLE_100
451: , p5_a7 JTF_VARCHAR2_TABLE_300
452: , p5_a8 JTF_NUMBER_TABLE

Line 452: , p5_a8 JTF_NUMBER_TABLE

448: , p5_a4 JTF_NUMBER_TABLE
449: , p5_a5 JTF_VARCHAR2_TABLE_100
450: , p5_a6 JTF_VARCHAR2_TABLE_100
451: , p5_a7 JTF_VARCHAR2_TABLE_300
452: , p5_a8 JTF_NUMBER_TABLE
453: , p5_a9 JTF_DATE_TABLE
454: , p5_a10 JTF_NUMBER_TABLE
455: , p5_a11 JTF_DATE_TABLE
456: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 454: , p5_a10 JTF_NUMBER_TABLE

450: , p5_a6 JTF_VARCHAR2_TABLE_100
451: , p5_a7 JTF_VARCHAR2_TABLE_300
452: , p5_a8 JTF_NUMBER_TABLE
453: , p5_a9 JTF_DATE_TABLE
454: , p5_a10 JTF_NUMBER_TABLE
455: , p5_a11 JTF_DATE_TABLE
456: , p5_a12 JTF_VARCHAR2_TABLE_100
457: , p5_a13 JTF_VARCHAR2_TABLE_100
458: , p5_a14 JTF_NUMBER_TABLE

Line 458: , p5_a14 JTF_NUMBER_TABLE

454: , p5_a10 JTF_NUMBER_TABLE
455: , p5_a11 JTF_DATE_TABLE
456: , p5_a12 JTF_VARCHAR2_TABLE_100
457: , p5_a13 JTF_VARCHAR2_TABLE_100
458: , p5_a14 JTF_NUMBER_TABLE
459: , p5_a15 JTF_NUMBER_TABLE
460: , p5_a16 JTF_NUMBER_TABLE
461: , p5_a17 JTF_NUMBER_TABLE
462: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 459: , p5_a15 JTF_NUMBER_TABLE

455: , p5_a11 JTF_DATE_TABLE
456: , p5_a12 JTF_VARCHAR2_TABLE_100
457: , p5_a13 JTF_VARCHAR2_TABLE_100
458: , p5_a14 JTF_NUMBER_TABLE
459: , p5_a15 JTF_NUMBER_TABLE
460: , p5_a16 JTF_NUMBER_TABLE
461: , p5_a17 JTF_NUMBER_TABLE
462: , p5_a18 JTF_VARCHAR2_TABLE_100
463: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 460: , p5_a16 JTF_NUMBER_TABLE

456: , p5_a12 JTF_VARCHAR2_TABLE_100
457: , p5_a13 JTF_VARCHAR2_TABLE_100
458: , p5_a14 JTF_NUMBER_TABLE
459: , p5_a15 JTF_NUMBER_TABLE
460: , p5_a16 JTF_NUMBER_TABLE
461: , p5_a17 JTF_NUMBER_TABLE
462: , p5_a18 JTF_VARCHAR2_TABLE_100
463: , p5_a19 JTF_VARCHAR2_TABLE_100
464: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 461: , p5_a17 JTF_NUMBER_TABLE

457: , p5_a13 JTF_VARCHAR2_TABLE_100
458: , p5_a14 JTF_NUMBER_TABLE
459: , p5_a15 JTF_NUMBER_TABLE
460: , p5_a16 JTF_NUMBER_TABLE
461: , p5_a17 JTF_NUMBER_TABLE
462: , p5_a18 JTF_VARCHAR2_TABLE_100
463: , p5_a19 JTF_VARCHAR2_TABLE_100
464: , p5_a20 JTF_VARCHAR2_TABLE_500
465: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 479: , p5_a35 JTF_NUMBER_TABLE

475: , p5_a31 JTF_VARCHAR2_TABLE_500
476: , p5_a32 JTF_VARCHAR2_TABLE_500
477: , p5_a33 JTF_VARCHAR2_TABLE_500
478: , p5_a34 JTF_VARCHAR2_TABLE_500
479: , p5_a35 JTF_NUMBER_TABLE
480: , p5_a36 JTF_DATE_TABLE
481: , p5_a37 JTF_NUMBER_TABLE
482: , p5_a38 JTF_DATE_TABLE
483: , p5_a39 JTF_NUMBER_TABLE

Line 481: , p5_a37 JTF_NUMBER_TABLE

477: , p5_a33 JTF_VARCHAR2_TABLE_500
478: , p5_a34 JTF_VARCHAR2_TABLE_500
479: , p5_a35 JTF_NUMBER_TABLE
480: , p5_a36 JTF_DATE_TABLE
481: , p5_a37 JTF_NUMBER_TABLE
482: , p5_a38 JTF_DATE_TABLE
483: , p5_a39 JTF_NUMBER_TABLE
484: );
485: procedure delete_ins_products(p_api_version NUMBER

Line 483: , p5_a39 JTF_NUMBER_TABLE

479: , p5_a35 JTF_NUMBER_TABLE
480: , p5_a36 JTF_DATE_TABLE
481: , p5_a37 JTF_NUMBER_TABLE
482: , p5_a38 JTF_DATE_TABLE
483: , p5_a39 JTF_NUMBER_TABLE
484: );
485: procedure delete_ins_products(p_api_version NUMBER
486: , p_init_msg_list VARCHAR2
487: , x_return_status out nocopy VARCHAR2

Line 536: , p5_a0 JTF_NUMBER_TABLE

532: , p_init_msg_list VARCHAR2
533: , x_return_status out nocopy VARCHAR2
534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_100
539: , p5_a3 JTF_NUMBER_TABLE
540: , p5_a4 JTF_NUMBER_TABLE

Line 537: , p5_a1 JTF_NUMBER_TABLE

533: , x_return_status out nocopy VARCHAR2
534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_100
539: , p5_a3 JTF_NUMBER_TABLE
540: , p5_a4 JTF_NUMBER_TABLE
541: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 539: , p5_a3 JTF_NUMBER_TABLE

535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_100
539: , p5_a3 JTF_NUMBER_TABLE
540: , p5_a4 JTF_NUMBER_TABLE
541: , p5_a5 JTF_VARCHAR2_TABLE_100
542: , p5_a6 JTF_VARCHAR2_TABLE_100
543: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 540: , p5_a4 JTF_NUMBER_TABLE

536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_100
539: , p5_a3 JTF_NUMBER_TABLE
540: , p5_a4 JTF_NUMBER_TABLE
541: , p5_a5 JTF_VARCHAR2_TABLE_100
542: , p5_a6 JTF_VARCHAR2_TABLE_100
543: , p5_a7 JTF_VARCHAR2_TABLE_300
544: , p5_a8 JTF_NUMBER_TABLE

Line 544: , p5_a8 JTF_NUMBER_TABLE

540: , p5_a4 JTF_NUMBER_TABLE
541: , p5_a5 JTF_VARCHAR2_TABLE_100
542: , p5_a6 JTF_VARCHAR2_TABLE_100
543: , p5_a7 JTF_VARCHAR2_TABLE_300
544: , p5_a8 JTF_NUMBER_TABLE
545: , p5_a9 JTF_DATE_TABLE
546: , p5_a10 JTF_NUMBER_TABLE
547: , p5_a11 JTF_DATE_TABLE
548: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 546: , p5_a10 JTF_NUMBER_TABLE

542: , p5_a6 JTF_VARCHAR2_TABLE_100
543: , p5_a7 JTF_VARCHAR2_TABLE_300
544: , p5_a8 JTF_NUMBER_TABLE
545: , p5_a9 JTF_DATE_TABLE
546: , p5_a10 JTF_NUMBER_TABLE
547: , p5_a11 JTF_DATE_TABLE
548: , p5_a12 JTF_VARCHAR2_TABLE_100
549: , p5_a13 JTF_VARCHAR2_TABLE_100
550: , p5_a14 JTF_NUMBER_TABLE

Line 550: , p5_a14 JTF_NUMBER_TABLE

546: , p5_a10 JTF_NUMBER_TABLE
547: , p5_a11 JTF_DATE_TABLE
548: , p5_a12 JTF_VARCHAR2_TABLE_100
549: , p5_a13 JTF_VARCHAR2_TABLE_100
550: , p5_a14 JTF_NUMBER_TABLE
551: , p5_a15 JTF_NUMBER_TABLE
552: , p5_a16 JTF_NUMBER_TABLE
553: , p5_a17 JTF_NUMBER_TABLE
554: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 551: , p5_a15 JTF_NUMBER_TABLE

547: , p5_a11 JTF_DATE_TABLE
548: , p5_a12 JTF_VARCHAR2_TABLE_100
549: , p5_a13 JTF_VARCHAR2_TABLE_100
550: , p5_a14 JTF_NUMBER_TABLE
551: , p5_a15 JTF_NUMBER_TABLE
552: , p5_a16 JTF_NUMBER_TABLE
553: , p5_a17 JTF_NUMBER_TABLE
554: , p5_a18 JTF_VARCHAR2_TABLE_100
555: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 552: , p5_a16 JTF_NUMBER_TABLE

548: , p5_a12 JTF_VARCHAR2_TABLE_100
549: , p5_a13 JTF_VARCHAR2_TABLE_100
550: , p5_a14 JTF_NUMBER_TABLE
551: , p5_a15 JTF_NUMBER_TABLE
552: , p5_a16 JTF_NUMBER_TABLE
553: , p5_a17 JTF_NUMBER_TABLE
554: , p5_a18 JTF_VARCHAR2_TABLE_100
555: , p5_a19 JTF_VARCHAR2_TABLE_100
556: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 553: , p5_a17 JTF_NUMBER_TABLE

549: , p5_a13 JTF_VARCHAR2_TABLE_100
550: , p5_a14 JTF_NUMBER_TABLE
551: , p5_a15 JTF_NUMBER_TABLE
552: , p5_a16 JTF_NUMBER_TABLE
553: , p5_a17 JTF_NUMBER_TABLE
554: , p5_a18 JTF_VARCHAR2_TABLE_100
555: , p5_a19 JTF_VARCHAR2_TABLE_100
556: , p5_a20 JTF_VARCHAR2_TABLE_500
557: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 571: , p5_a35 JTF_NUMBER_TABLE

567: , p5_a31 JTF_VARCHAR2_TABLE_500
568: , p5_a32 JTF_VARCHAR2_TABLE_500
569: , p5_a33 JTF_VARCHAR2_TABLE_500
570: , p5_a34 JTF_VARCHAR2_TABLE_500
571: , p5_a35 JTF_NUMBER_TABLE
572: , p5_a36 JTF_DATE_TABLE
573: , p5_a37 JTF_NUMBER_TABLE
574: , p5_a38 JTF_DATE_TABLE
575: , p5_a39 JTF_NUMBER_TABLE

Line 573: , p5_a37 JTF_NUMBER_TABLE

569: , p5_a33 JTF_VARCHAR2_TABLE_500
570: , p5_a34 JTF_VARCHAR2_TABLE_500
571: , p5_a35 JTF_NUMBER_TABLE
572: , p5_a36 JTF_DATE_TABLE
573: , p5_a37 JTF_NUMBER_TABLE
574: , p5_a38 JTF_DATE_TABLE
575: , p5_a39 JTF_NUMBER_TABLE
576: );
577: procedure validate_ins_products(p_api_version NUMBER

Line 575: , p5_a39 JTF_NUMBER_TABLE

571: , p5_a35 JTF_NUMBER_TABLE
572: , p5_a36 JTF_DATE_TABLE
573: , p5_a37 JTF_NUMBER_TABLE
574: , p5_a38 JTF_DATE_TABLE
575: , p5_a39 JTF_NUMBER_TABLE
576: );
577: procedure validate_ins_products(p_api_version NUMBER
578: , p_init_msg_list VARCHAR2
579: , x_return_status out nocopy VARCHAR2