APPS.OKL_CAH_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cah_pvt.cah_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_cah_pvt_w as
2: /* $Header: OKLICAHS.pls 120.3 2005/09/20 13:42:05 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cah_pvt.cah_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_cah_pvt_w as
2: /* $Header: OKLICAHS.pls 120.3 2005/09/20 13:42:05 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cah_pvt.cah_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cah_pvt.cah_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500

Line 25: , a22 JTF_NUMBER_TABLE

21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_cah_pvt.cah_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 30: , a27 JTF_NUMBER_TABLE

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_cah_pvt.cah_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_200
34: , a2 out nocopy JTF_NUMBER_TABLE

Line 32: procedure rosetta_table_copy_out_p2(t okl_cah_pvt.cah_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_cah_pvt.cah_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_200
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_VARCHAR2_TABLE_100
36: , a4 out nocopy JTF_NUMBER_TABLE

Line 34: , a2 out nocopy JTF_NUMBER_TABLE

30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_cah_pvt.cah_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_200
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_VARCHAR2_TABLE_100
36: , a4 out nocopy JTF_NUMBER_TABLE
37: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
38: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , a4 out nocopy JTF_NUMBER_TABLE

32: procedure rosetta_table_copy_out_p2(t okl_cah_pvt.cah_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_200
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_VARCHAR2_TABLE_100
36: , a4 out nocopy JTF_NUMBER_TABLE
37: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
38: , a6 out nocopy JTF_VARCHAR2_TABLE_100
39: , a7 out nocopy JTF_VARCHAR2_TABLE_500
40: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 54: , a22 out nocopy JTF_NUMBER_TABLE

50: , a18 out nocopy JTF_VARCHAR2_TABLE_500
51: , a19 out nocopy JTF_VARCHAR2_TABLE_500
52: , a20 out nocopy JTF_VARCHAR2_TABLE_500
53: , a21 out nocopy JTF_VARCHAR2_TABLE_500
54: , a22 out nocopy JTF_NUMBER_TABLE
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE

Line 55: , a23 out nocopy JTF_NUMBER_TABLE

51: , a19 out nocopy JTF_VARCHAR2_TABLE_500
52: , a20 out nocopy JTF_VARCHAR2_TABLE_500
53: , a21 out nocopy JTF_VARCHAR2_TABLE_500
54: , a22 out nocopy JTF_NUMBER_TABLE
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE

Line 57: , a25 out nocopy JTF_NUMBER_TABLE

53: , a21 out nocopy JTF_VARCHAR2_TABLE_500
54: , a22 out nocopy JTF_NUMBER_TABLE
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:

Line 59: , a27 out nocopy JTF_NUMBER_TABLE

55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_cah_pvt.cahv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE

Line 62: procedure rosetta_table_copy_in_p5(t out nocopy okl_cah_pvt.cahv_tbl_type, a0 JTF_NUMBER_TABLE

58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_cah_pvt.cahv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_VARCHAR2_TABLE_200
65: , a3 JTF_VARCHAR2_TABLE_2000
66: , a4 JTF_NUMBER_TABLE

Line 63: , a1 JTF_NUMBER_TABLE

59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_cah_pvt.cahv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_VARCHAR2_TABLE_200
65: , a3 JTF_VARCHAR2_TABLE_2000
66: , a4 JTF_NUMBER_TABLE
67: , a5 JTF_VARCHAR2_TABLE_100

Line 66: , a4 JTF_NUMBER_TABLE

62: procedure rosetta_table_copy_in_p5(t out nocopy okl_cah_pvt.cahv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_VARCHAR2_TABLE_200
65: , a3 JTF_VARCHAR2_TABLE_2000
66: , a4 JTF_NUMBER_TABLE
67: , a5 JTF_VARCHAR2_TABLE_100
68: , a6 JTF_VARCHAR2_TABLE_500
69: , a7 JTF_VARCHAR2_TABLE_500
70: , a8 JTF_VARCHAR2_TABLE_500

Line 83: , a21 JTF_NUMBER_TABLE

79: , a17 JTF_VARCHAR2_TABLE_500
80: , a18 JTF_VARCHAR2_TABLE_500
81: , a19 JTF_VARCHAR2_TABLE_500
82: , a20 JTF_VARCHAR2_TABLE_500
83: , a21 JTF_NUMBER_TABLE
84: , a22 JTF_VARCHAR2_TABLE_100
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_DATE_TABLE
87: , a25 JTF_NUMBER_TABLE

Line 85: , a23 JTF_NUMBER_TABLE

81: , a19 JTF_VARCHAR2_TABLE_500
82: , a20 JTF_VARCHAR2_TABLE_500
83: , a21 JTF_NUMBER_TABLE
84: , a22 JTF_VARCHAR2_TABLE_100
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_DATE_TABLE
87: , a25 JTF_NUMBER_TABLE
88: , a26 JTF_DATE_TABLE
89: , a27 JTF_NUMBER_TABLE

Line 87: , a25 JTF_NUMBER_TABLE

83: , a21 JTF_NUMBER_TABLE
84: , a22 JTF_VARCHAR2_TABLE_100
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_DATE_TABLE
87: , a25 JTF_NUMBER_TABLE
88: , a26 JTF_DATE_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 89: , a27 JTF_NUMBER_TABLE

85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_DATE_TABLE
87: , a25 JTF_NUMBER_TABLE
88: , a26 JTF_DATE_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 91: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

87: , a25 JTF_NUMBER_TABLE
88: , a26 JTF_DATE_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_200
94: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
95: , a4 out nocopy JTF_NUMBER_TABLE

Line 92: , a1 out nocopy JTF_NUMBER_TABLE

88: , a26 JTF_DATE_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_200
94: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 95: , a4 out nocopy JTF_NUMBER_TABLE

91: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_200
94: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_VARCHAR2_TABLE_500
98: , a7 out nocopy JTF_VARCHAR2_TABLE_500
99: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 112: , a21 out nocopy JTF_NUMBER_TABLE

108: , a17 out nocopy JTF_VARCHAR2_TABLE_500
109: , a18 out nocopy JTF_VARCHAR2_TABLE_500
110: , a19 out nocopy JTF_VARCHAR2_TABLE_500
111: , a20 out nocopy JTF_VARCHAR2_TABLE_500
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_VARCHAR2_TABLE_100
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE

Line 114: , a23 out nocopy JTF_NUMBER_TABLE

110: , a19 out nocopy JTF_VARCHAR2_TABLE_500
111: , a20 out nocopy JTF_VARCHAR2_TABLE_500
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_VARCHAR2_TABLE_100
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: , a26 out nocopy JTF_DATE_TABLE
118: , a27 out nocopy JTF_NUMBER_TABLE

Line 116: , a25 out nocopy JTF_NUMBER_TABLE

112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_VARCHAR2_TABLE_100
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: , a26 out nocopy JTF_DATE_TABLE
118: , a27 out nocopy JTF_NUMBER_TABLE
119: );
120:

Line 118: , a27 out nocopy JTF_NUMBER_TABLE

114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: , a26 out nocopy JTF_DATE_TABLE
118: , a27 out nocopy JTF_NUMBER_TABLE
119: );
120:
121: procedure insert_row(p_api_version NUMBER
122: , p_init_msg_list VARCHAR2

Line 188: , p5_a0 JTF_NUMBER_TABLE

184: , p_init_msg_list VARCHAR2
185: , x_return_status out nocopy VARCHAR2
186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_VARCHAR2_TABLE_200
191: , p5_a3 JTF_VARCHAR2_TABLE_2000
192: , p5_a4 JTF_NUMBER_TABLE

Line 189: , p5_a1 JTF_NUMBER_TABLE

185: , x_return_status out nocopy VARCHAR2
186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_VARCHAR2_TABLE_200
191: , p5_a3 JTF_VARCHAR2_TABLE_2000
192: , p5_a4 JTF_NUMBER_TABLE
193: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 192: , p5_a4 JTF_NUMBER_TABLE

188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_VARCHAR2_TABLE_200
191: , p5_a3 JTF_VARCHAR2_TABLE_2000
192: , p5_a4 JTF_NUMBER_TABLE
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_VARCHAR2_TABLE_500
195: , p5_a7 JTF_VARCHAR2_TABLE_500
196: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 209: , p5_a21 JTF_NUMBER_TABLE

205: , p5_a17 JTF_VARCHAR2_TABLE_500
206: , p5_a18 JTF_VARCHAR2_TABLE_500
207: , p5_a19 JTF_VARCHAR2_TABLE_500
208: , p5_a20 JTF_VARCHAR2_TABLE_500
209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_100
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE

Line 211: , p5_a23 JTF_NUMBER_TABLE

207: , p5_a19 JTF_VARCHAR2_TABLE_500
208: , p5_a20 JTF_VARCHAR2_TABLE_500
209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_100
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p5_a26 JTF_DATE_TABLE
215: , p5_a27 JTF_NUMBER_TABLE

Line 213: , p5_a25 JTF_NUMBER_TABLE

209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_100
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p5_a26 JTF_DATE_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 215: , p5_a27 JTF_NUMBER_TABLE

211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p5_a26 JTF_DATE_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 216: , p6_a0 out nocopy JTF_NUMBER_TABLE

212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p5_a26 JTF_DATE_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
220: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 217: , p6_a1 out nocopy JTF_NUMBER_TABLE

213: , p5_a25 JTF_NUMBER_TABLE
214: , p5_a26 JTF_DATE_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
220: , p6_a4 out nocopy JTF_NUMBER_TABLE
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 220: , p6_a4 out nocopy JTF_NUMBER_TABLE

216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
220: , p6_a4 out nocopy JTF_NUMBER_TABLE
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
224: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 237: , p6_a21 out nocopy JTF_NUMBER_TABLE

233: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
234: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
235: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
236: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
237: , p6_a21 out nocopy JTF_NUMBER_TABLE
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_DATE_TABLE
241: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 239: , p6_a23 out nocopy JTF_NUMBER_TABLE

235: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
236: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
237: , p6_a21 out nocopy JTF_NUMBER_TABLE
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_DATE_TABLE
241: , p6_a25 out nocopy JTF_NUMBER_TABLE
242: , p6_a26 out nocopy JTF_DATE_TABLE
243: , p6_a27 out nocopy JTF_NUMBER_TABLE

Line 241: , p6_a25 out nocopy JTF_NUMBER_TABLE

237: , p6_a21 out nocopy JTF_NUMBER_TABLE
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_DATE_TABLE
241: , p6_a25 out nocopy JTF_NUMBER_TABLE
242: , p6_a26 out nocopy JTF_DATE_TABLE
243: , p6_a27 out nocopy JTF_NUMBER_TABLE
244: );
245: procedure lock_row(p_api_version NUMBER

Line 243: , p6_a27 out nocopy JTF_NUMBER_TABLE

239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_DATE_TABLE
241: , p6_a25 out nocopy JTF_NUMBER_TABLE
242: , p6_a26 out nocopy JTF_DATE_TABLE
243: , p6_a27 out nocopy JTF_NUMBER_TABLE
244: );
245: procedure lock_row(p_api_version NUMBER
246: , p_init_msg_list VARCHAR2
247: , x_return_status out nocopy VARCHAR2

Line 284: , p5_a0 JTF_NUMBER_TABLE

280: , p_init_msg_list VARCHAR2
281: , x_return_status out nocopy VARCHAR2
282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_VARCHAR2_TABLE_200
287: , p5_a3 JTF_VARCHAR2_TABLE_2000
288: , p5_a4 JTF_NUMBER_TABLE

Line 285: , p5_a1 JTF_NUMBER_TABLE

281: , x_return_status out nocopy VARCHAR2
282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_VARCHAR2_TABLE_200
287: , p5_a3 JTF_VARCHAR2_TABLE_2000
288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 288: , p5_a4 JTF_NUMBER_TABLE

284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_VARCHAR2_TABLE_200
287: , p5_a3 JTF_VARCHAR2_TABLE_2000
288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_VARCHAR2_TABLE_500
291: , p5_a7 JTF_VARCHAR2_TABLE_500
292: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 305: , p5_a21 JTF_NUMBER_TABLE

301: , p5_a17 JTF_VARCHAR2_TABLE_500
302: , p5_a18 JTF_VARCHAR2_TABLE_500
303: , p5_a19 JTF_VARCHAR2_TABLE_500
304: , p5_a20 JTF_VARCHAR2_TABLE_500
305: , p5_a21 JTF_NUMBER_TABLE
306: , p5_a22 JTF_VARCHAR2_TABLE_100
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_DATE_TABLE
309: , p5_a25 JTF_NUMBER_TABLE

Line 307: , p5_a23 JTF_NUMBER_TABLE

303: , p5_a19 JTF_VARCHAR2_TABLE_500
304: , p5_a20 JTF_VARCHAR2_TABLE_500
305: , p5_a21 JTF_NUMBER_TABLE
306: , p5_a22 JTF_VARCHAR2_TABLE_100
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_DATE_TABLE
309: , p5_a25 JTF_NUMBER_TABLE
310: , p5_a26 JTF_DATE_TABLE
311: , p5_a27 JTF_NUMBER_TABLE

Line 309: , p5_a25 JTF_NUMBER_TABLE

305: , p5_a21 JTF_NUMBER_TABLE
306: , p5_a22 JTF_VARCHAR2_TABLE_100
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_DATE_TABLE
309: , p5_a25 JTF_NUMBER_TABLE
310: , p5_a26 JTF_DATE_TABLE
311: , p5_a27 JTF_NUMBER_TABLE
312: );
313: procedure update_row(p_api_version NUMBER

Line 311: , p5_a27 JTF_NUMBER_TABLE

307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_DATE_TABLE
309: , p5_a25 JTF_NUMBER_TABLE
310: , p5_a26 JTF_DATE_TABLE
311: , p5_a27 JTF_NUMBER_TABLE
312: );
313: procedure update_row(p_api_version NUMBER
314: , p_init_msg_list VARCHAR2
315: , x_return_status out nocopy VARCHAR2

Line 380: , p5_a0 JTF_NUMBER_TABLE

376: , p_init_msg_list VARCHAR2
377: , x_return_status out nocopy VARCHAR2
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_VARCHAR2_TABLE_200
383: , p5_a3 JTF_VARCHAR2_TABLE_2000
384: , p5_a4 JTF_NUMBER_TABLE

Line 381: , p5_a1 JTF_NUMBER_TABLE

377: , x_return_status out nocopy VARCHAR2
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_VARCHAR2_TABLE_200
383: , p5_a3 JTF_VARCHAR2_TABLE_2000
384: , p5_a4 JTF_NUMBER_TABLE
385: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 384: , p5_a4 JTF_NUMBER_TABLE

380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_VARCHAR2_TABLE_200
383: , p5_a3 JTF_VARCHAR2_TABLE_2000
384: , p5_a4 JTF_NUMBER_TABLE
385: , p5_a5 JTF_VARCHAR2_TABLE_100
386: , p5_a6 JTF_VARCHAR2_TABLE_500
387: , p5_a7 JTF_VARCHAR2_TABLE_500
388: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 401: , p5_a21 JTF_NUMBER_TABLE

397: , p5_a17 JTF_VARCHAR2_TABLE_500
398: , p5_a18 JTF_VARCHAR2_TABLE_500
399: , p5_a19 JTF_VARCHAR2_TABLE_500
400: , p5_a20 JTF_VARCHAR2_TABLE_500
401: , p5_a21 JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_100
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_DATE_TABLE
405: , p5_a25 JTF_NUMBER_TABLE

Line 403: , p5_a23 JTF_NUMBER_TABLE

399: , p5_a19 JTF_VARCHAR2_TABLE_500
400: , p5_a20 JTF_VARCHAR2_TABLE_500
401: , p5_a21 JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_100
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_DATE_TABLE
405: , p5_a25 JTF_NUMBER_TABLE
406: , p5_a26 JTF_DATE_TABLE
407: , p5_a27 JTF_NUMBER_TABLE

Line 405: , p5_a25 JTF_NUMBER_TABLE

401: , p5_a21 JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_100
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_DATE_TABLE
405: , p5_a25 JTF_NUMBER_TABLE
406: , p5_a26 JTF_DATE_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 407: , p5_a27 JTF_NUMBER_TABLE

403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_DATE_TABLE
405: , p5_a25 JTF_NUMBER_TABLE
406: , p5_a26 JTF_DATE_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
411: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 408: , p6_a0 out nocopy JTF_NUMBER_TABLE

404: , p5_a24 JTF_DATE_TABLE
405: , p5_a25 JTF_NUMBER_TABLE
406: , p5_a26 JTF_DATE_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
411: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
412: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 409: , p6_a1 out nocopy JTF_NUMBER_TABLE

405: , p5_a25 JTF_NUMBER_TABLE
406: , p5_a26 JTF_DATE_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
411: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
412: , p6_a4 out nocopy JTF_NUMBER_TABLE
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 412: , p6_a4 out nocopy JTF_NUMBER_TABLE

408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
411: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
412: , p6_a4 out nocopy JTF_NUMBER_TABLE
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
416: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 429: , p6_a21 out nocopy JTF_NUMBER_TABLE

425: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
426: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
427: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
428: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
429: , p6_a21 out nocopy JTF_NUMBER_TABLE
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_DATE_TABLE
433: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 431: , p6_a23 out nocopy JTF_NUMBER_TABLE

427: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
428: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
429: , p6_a21 out nocopy JTF_NUMBER_TABLE
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_DATE_TABLE
433: , p6_a25 out nocopy JTF_NUMBER_TABLE
434: , p6_a26 out nocopy JTF_DATE_TABLE
435: , p6_a27 out nocopy JTF_NUMBER_TABLE

Line 433: , p6_a25 out nocopy JTF_NUMBER_TABLE

429: , p6_a21 out nocopy JTF_NUMBER_TABLE
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_DATE_TABLE
433: , p6_a25 out nocopy JTF_NUMBER_TABLE
434: , p6_a26 out nocopy JTF_DATE_TABLE
435: , p6_a27 out nocopy JTF_NUMBER_TABLE
436: );
437: procedure delete_row(p_api_version NUMBER

Line 435: , p6_a27 out nocopy JTF_NUMBER_TABLE

431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_DATE_TABLE
433: , p6_a25 out nocopy JTF_NUMBER_TABLE
434: , p6_a26 out nocopy JTF_DATE_TABLE
435: , p6_a27 out nocopy JTF_NUMBER_TABLE
436: );
437: procedure delete_row(p_api_version NUMBER
438: , p_init_msg_list VARCHAR2
439: , x_return_status out nocopy VARCHAR2

Line 476: , p5_a0 JTF_NUMBER_TABLE

472: , p_init_msg_list VARCHAR2
473: , x_return_status out nocopy VARCHAR2
474: , x_msg_count out nocopy NUMBER
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_200
479: , p5_a3 JTF_VARCHAR2_TABLE_2000
480: , p5_a4 JTF_NUMBER_TABLE

Line 477: , p5_a1 JTF_NUMBER_TABLE

473: , x_return_status out nocopy VARCHAR2
474: , x_msg_count out nocopy NUMBER
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_200
479: , p5_a3 JTF_VARCHAR2_TABLE_2000
480: , p5_a4 JTF_NUMBER_TABLE
481: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 480: , p5_a4 JTF_NUMBER_TABLE

476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_200
479: , p5_a3 JTF_VARCHAR2_TABLE_2000
480: , p5_a4 JTF_NUMBER_TABLE
481: , p5_a5 JTF_VARCHAR2_TABLE_100
482: , p5_a6 JTF_VARCHAR2_TABLE_500
483: , p5_a7 JTF_VARCHAR2_TABLE_500
484: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 497: , p5_a21 JTF_NUMBER_TABLE

493: , p5_a17 JTF_VARCHAR2_TABLE_500
494: , p5_a18 JTF_VARCHAR2_TABLE_500
495: , p5_a19 JTF_VARCHAR2_TABLE_500
496: , p5_a20 JTF_VARCHAR2_TABLE_500
497: , p5_a21 JTF_NUMBER_TABLE
498: , p5_a22 JTF_VARCHAR2_TABLE_100
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_DATE_TABLE
501: , p5_a25 JTF_NUMBER_TABLE

Line 499: , p5_a23 JTF_NUMBER_TABLE

495: , p5_a19 JTF_VARCHAR2_TABLE_500
496: , p5_a20 JTF_VARCHAR2_TABLE_500
497: , p5_a21 JTF_NUMBER_TABLE
498: , p5_a22 JTF_VARCHAR2_TABLE_100
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_DATE_TABLE
501: , p5_a25 JTF_NUMBER_TABLE
502: , p5_a26 JTF_DATE_TABLE
503: , p5_a27 JTF_NUMBER_TABLE

Line 501: , p5_a25 JTF_NUMBER_TABLE

497: , p5_a21 JTF_NUMBER_TABLE
498: , p5_a22 JTF_VARCHAR2_TABLE_100
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_DATE_TABLE
501: , p5_a25 JTF_NUMBER_TABLE
502: , p5_a26 JTF_DATE_TABLE
503: , p5_a27 JTF_NUMBER_TABLE
504: );
505: procedure validate_row(p_api_version NUMBER

Line 503: , p5_a27 JTF_NUMBER_TABLE

499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_DATE_TABLE
501: , p5_a25 JTF_NUMBER_TABLE
502: , p5_a26 JTF_DATE_TABLE
503: , p5_a27 JTF_NUMBER_TABLE
504: );
505: procedure validate_row(p_api_version NUMBER
506: , p_init_msg_list VARCHAR2
507: , x_return_status out nocopy VARCHAR2

Line 544: , p5_a0 JTF_NUMBER_TABLE

540: , p_init_msg_list VARCHAR2
541: , x_return_status out nocopy VARCHAR2
542: , x_msg_count out nocopy NUMBER
543: , x_msg_data out nocopy VARCHAR2
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_VARCHAR2_TABLE_200
547: , p5_a3 JTF_VARCHAR2_TABLE_2000
548: , p5_a4 JTF_NUMBER_TABLE

Line 545: , p5_a1 JTF_NUMBER_TABLE

541: , x_return_status out nocopy VARCHAR2
542: , x_msg_count out nocopy NUMBER
543: , x_msg_data out nocopy VARCHAR2
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_VARCHAR2_TABLE_200
547: , p5_a3 JTF_VARCHAR2_TABLE_2000
548: , p5_a4 JTF_NUMBER_TABLE
549: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 548: , p5_a4 JTF_NUMBER_TABLE

544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_VARCHAR2_TABLE_200
547: , p5_a3 JTF_VARCHAR2_TABLE_2000
548: , p5_a4 JTF_NUMBER_TABLE
549: , p5_a5 JTF_VARCHAR2_TABLE_100
550: , p5_a6 JTF_VARCHAR2_TABLE_500
551: , p5_a7 JTF_VARCHAR2_TABLE_500
552: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 565: , p5_a21 JTF_NUMBER_TABLE

561: , p5_a17 JTF_VARCHAR2_TABLE_500
562: , p5_a18 JTF_VARCHAR2_TABLE_500
563: , p5_a19 JTF_VARCHAR2_TABLE_500
564: , p5_a20 JTF_VARCHAR2_TABLE_500
565: , p5_a21 JTF_NUMBER_TABLE
566: , p5_a22 JTF_VARCHAR2_TABLE_100
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_DATE_TABLE
569: , p5_a25 JTF_NUMBER_TABLE

Line 567: , p5_a23 JTF_NUMBER_TABLE

563: , p5_a19 JTF_VARCHAR2_TABLE_500
564: , p5_a20 JTF_VARCHAR2_TABLE_500
565: , p5_a21 JTF_NUMBER_TABLE
566: , p5_a22 JTF_VARCHAR2_TABLE_100
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_DATE_TABLE
569: , p5_a25 JTF_NUMBER_TABLE
570: , p5_a26 JTF_DATE_TABLE
571: , p5_a27 JTF_NUMBER_TABLE

Line 569: , p5_a25 JTF_NUMBER_TABLE

565: , p5_a21 JTF_NUMBER_TABLE
566: , p5_a22 JTF_VARCHAR2_TABLE_100
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_DATE_TABLE
569: , p5_a25 JTF_NUMBER_TABLE
570: , p5_a26 JTF_DATE_TABLE
571: , p5_a27 JTF_NUMBER_TABLE
572: );
573: end okl_cah_pvt_w;

Line 571: , p5_a27 JTF_NUMBER_TABLE

567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_DATE_TABLE
569: , p5_a25 JTF_NUMBER_TABLE
570: , p5_a26 JTF_DATE_TABLE
571: , p5_a27 JTF_NUMBER_TABLE
572: );
573: end okl_cah_pvt_w;