APPS.OKL_PIT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pit_pvt.pit_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_pit_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIPITS.pls 120.1 2005/07/14 11:57:52 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pit_pvt.pit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_400
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_pit_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIPITS.pls 120.1 2005/07/14 11:57:52 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pit_pvt.pit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_400
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_400
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

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

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p2(t okl_pit_pvt.pit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p2(t okl_pit_pvt.pit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 18: procedure rosetta_table_copy_out_p2(t okl_pit_pvt.pit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p2(t okl_pit_pvt.pit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_VARCHAR2_TABLE_200
21: , a3 out nocopy JTF_VARCHAR2_TABLE_400
22: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 19: , a1 out nocopy JTF_NUMBER_TABLE

15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p2(t okl_pit_pvt.pit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_VARCHAR2_TABLE_200
21: , a3 out nocopy JTF_VARCHAR2_TABLE_400
22: , a4 out nocopy JTF_VARCHAR2_TABLE_100
23: , a5 out nocopy JTF_DATE_TABLE

Line 24: , a6 out nocopy JTF_NUMBER_TABLE

20: , a2 out nocopy JTF_VARCHAR2_TABLE_200
21: , a3 out nocopy JTF_VARCHAR2_TABLE_400
22: , a4 out nocopy JTF_VARCHAR2_TABLE_100
23: , a5 out nocopy JTF_DATE_TABLE
24: , a6 out nocopy JTF_NUMBER_TABLE
25: , a7 out nocopy JTF_DATE_TABLE
26: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
27: , a9 out nocopy JTF_NUMBER_TABLE
28: , a10 out nocopy JTF_DATE_TABLE

Line 27: , a9 out nocopy JTF_NUMBER_TABLE

23: , a5 out nocopy JTF_DATE_TABLE
24: , a6 out nocopy JTF_NUMBER_TABLE
25: , a7 out nocopy JTF_DATE_TABLE
26: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
27: , a9 out nocopy JTF_NUMBER_TABLE
28: , a10 out nocopy JTF_DATE_TABLE
29: , a11 out nocopy JTF_NUMBER_TABLE
30: , a12 out nocopy JTF_DATE_TABLE
31: , a13 out nocopy JTF_NUMBER_TABLE

Line 29: , a11 out nocopy JTF_NUMBER_TABLE

25: , a7 out nocopy JTF_DATE_TABLE
26: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
27: , a9 out nocopy JTF_NUMBER_TABLE
28: , a10 out nocopy JTF_DATE_TABLE
29: , a11 out nocopy JTF_NUMBER_TABLE
30: , a12 out nocopy JTF_DATE_TABLE
31: , a13 out nocopy JTF_NUMBER_TABLE
32: );
33:

Line 31: , a13 out nocopy JTF_NUMBER_TABLE

27: , a9 out nocopy JTF_NUMBER_TABLE
28: , a10 out nocopy JTF_DATE_TABLE
29: , a11 out nocopy JTF_NUMBER_TABLE
30: , a12 out nocopy JTF_DATE_TABLE
31: , a13 out nocopy JTF_NUMBER_TABLE
32: );
33:
34: procedure rosetta_table_copy_in_p5(t out nocopy okl_pit_pvt.pitv_tbl_type, a0 JTF_NUMBER_TABLE
35: , a1 JTF_NUMBER_TABLE

Line 34: procedure rosetta_table_copy_in_p5(t out nocopy okl_pit_pvt.pitv_tbl_type, a0 JTF_NUMBER_TABLE

30: , a12 out nocopy JTF_DATE_TABLE
31: , a13 out nocopy JTF_NUMBER_TABLE
32: );
33:
34: procedure rosetta_table_copy_in_p5(t out nocopy okl_pit_pvt.pitv_tbl_type, a0 JTF_NUMBER_TABLE
35: , a1 JTF_NUMBER_TABLE
36: , a2 JTF_NUMBER_TABLE
37: , a3 JTF_VARCHAR2_TABLE_200
38: , a4 JTF_VARCHAR2_TABLE_400

Line 35: , a1 JTF_NUMBER_TABLE

31: , a13 out nocopy JTF_NUMBER_TABLE
32: );
33:
34: procedure rosetta_table_copy_in_p5(t out nocopy okl_pit_pvt.pitv_tbl_type, a0 JTF_NUMBER_TABLE
35: , a1 JTF_NUMBER_TABLE
36: , a2 JTF_NUMBER_TABLE
37: , a3 JTF_VARCHAR2_TABLE_200
38: , a4 JTF_VARCHAR2_TABLE_400
39: , a5 JTF_VARCHAR2_TABLE_100

Line 36: , a2 JTF_NUMBER_TABLE

32: );
33:
34: procedure rosetta_table_copy_in_p5(t out nocopy okl_pit_pvt.pitv_tbl_type, a0 JTF_NUMBER_TABLE
35: , a1 JTF_NUMBER_TABLE
36: , a2 JTF_NUMBER_TABLE
37: , a3 JTF_VARCHAR2_TABLE_200
38: , a4 JTF_VARCHAR2_TABLE_400
39: , a5 JTF_VARCHAR2_TABLE_100
40: , a6 JTF_DATE_TABLE

Line 43: , a9 JTF_NUMBER_TABLE

39: , a5 JTF_VARCHAR2_TABLE_100
40: , a6 JTF_DATE_TABLE
41: , a7 JTF_DATE_TABLE
42: , a8 JTF_VARCHAR2_TABLE_2000
43: , a9 JTF_NUMBER_TABLE
44: , a10 JTF_DATE_TABLE
45: , a11 JTF_NUMBER_TABLE
46: , a12 JTF_DATE_TABLE
47: , a13 JTF_NUMBER_TABLE

Line 45: , a11 JTF_NUMBER_TABLE

41: , a7 JTF_DATE_TABLE
42: , a8 JTF_VARCHAR2_TABLE_2000
43: , a9 JTF_NUMBER_TABLE
44: , a10 JTF_DATE_TABLE
45: , a11 JTF_NUMBER_TABLE
46: , a12 JTF_DATE_TABLE
47: , a13 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p5(t okl_pit_pvt.pitv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 47: , a13 JTF_NUMBER_TABLE

43: , a9 JTF_NUMBER_TABLE
44: , a10 JTF_DATE_TABLE
45: , a11 JTF_NUMBER_TABLE
46: , a12 JTF_DATE_TABLE
47: , a13 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p5(t okl_pit_pvt.pitv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE

Line 49: procedure rosetta_table_copy_out_p5(t okl_pit_pvt.pitv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

45: , a11 JTF_NUMBER_TABLE
46: , a12 JTF_DATE_TABLE
47: , a13 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p5(t okl_pit_pvt.pitv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_VARCHAR2_TABLE_200
53: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 50: , a1 out nocopy JTF_NUMBER_TABLE

46: , a12 JTF_DATE_TABLE
47: , a13 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p5(t okl_pit_pvt.pitv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_VARCHAR2_TABLE_200
53: , a4 out nocopy JTF_VARCHAR2_TABLE_400
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a2 out nocopy JTF_NUMBER_TABLE

47: , a13 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p5(t okl_pit_pvt.pitv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_VARCHAR2_TABLE_200
53: , a4 out nocopy JTF_VARCHAR2_TABLE_400
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: , a6 out nocopy JTF_DATE_TABLE

Line 58: , a9 out nocopy JTF_NUMBER_TABLE

54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: , a6 out nocopy JTF_DATE_TABLE
56: , a7 out nocopy JTF_DATE_TABLE
57: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a9 out nocopy JTF_NUMBER_TABLE
59: , a10 out nocopy JTF_DATE_TABLE
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_DATE_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE

Line 60: , a11 out nocopy JTF_NUMBER_TABLE

56: , a7 out nocopy JTF_DATE_TABLE
57: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a9 out nocopy JTF_NUMBER_TABLE
59: , a10 out nocopy JTF_DATE_TABLE
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_DATE_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: );
64:

Line 62: , a13 out nocopy JTF_NUMBER_TABLE

58: , a9 out nocopy JTF_NUMBER_TABLE
59: , a10 out nocopy JTF_DATE_TABLE
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_DATE_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: );
64:
65: procedure insert_row(p_api_version NUMBER
66: , p_init_msg_list VARCHAR2

Line 104: , p5_a0 JTF_NUMBER_TABLE

100: , p_init_msg_list VARCHAR2
101: , x_return_status out nocopy VARCHAR2
102: , x_msg_count out nocopy NUMBER
103: , x_msg_data out nocopy VARCHAR2
104: , p5_a0 JTF_NUMBER_TABLE
105: , p5_a1 JTF_NUMBER_TABLE
106: , p5_a2 JTF_NUMBER_TABLE
107: , p5_a3 JTF_VARCHAR2_TABLE_200
108: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 105: , p5_a1 JTF_NUMBER_TABLE

101: , x_return_status out nocopy VARCHAR2
102: , x_msg_count out nocopy NUMBER
103: , x_msg_data out nocopy VARCHAR2
104: , p5_a0 JTF_NUMBER_TABLE
105: , p5_a1 JTF_NUMBER_TABLE
106: , p5_a2 JTF_NUMBER_TABLE
107: , p5_a3 JTF_VARCHAR2_TABLE_200
108: , p5_a4 JTF_VARCHAR2_TABLE_400
109: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 106: , p5_a2 JTF_NUMBER_TABLE

102: , x_msg_count out nocopy NUMBER
103: , x_msg_data out nocopy VARCHAR2
104: , p5_a0 JTF_NUMBER_TABLE
105: , p5_a1 JTF_NUMBER_TABLE
106: , p5_a2 JTF_NUMBER_TABLE
107: , p5_a3 JTF_VARCHAR2_TABLE_200
108: , p5_a4 JTF_VARCHAR2_TABLE_400
109: , p5_a5 JTF_VARCHAR2_TABLE_100
110: , p5_a6 JTF_DATE_TABLE

Line 113: , p5_a9 JTF_NUMBER_TABLE

109: , p5_a5 JTF_VARCHAR2_TABLE_100
110: , p5_a6 JTF_DATE_TABLE
111: , p5_a7 JTF_DATE_TABLE
112: , p5_a8 JTF_VARCHAR2_TABLE_2000
113: , p5_a9 JTF_NUMBER_TABLE
114: , p5_a10 JTF_DATE_TABLE
115: , p5_a11 JTF_NUMBER_TABLE
116: , p5_a12 JTF_DATE_TABLE
117: , p5_a13 JTF_NUMBER_TABLE

Line 115: , p5_a11 JTF_NUMBER_TABLE

111: , p5_a7 JTF_DATE_TABLE
112: , p5_a8 JTF_VARCHAR2_TABLE_2000
113: , p5_a9 JTF_NUMBER_TABLE
114: , p5_a10 JTF_DATE_TABLE
115: , p5_a11 JTF_NUMBER_TABLE
116: , p5_a12 JTF_DATE_TABLE
117: , p5_a13 JTF_NUMBER_TABLE
118: , p6_a0 out nocopy JTF_NUMBER_TABLE
119: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 117: , p5_a13 JTF_NUMBER_TABLE

113: , p5_a9 JTF_NUMBER_TABLE
114: , p5_a10 JTF_DATE_TABLE
115: , p5_a11 JTF_NUMBER_TABLE
116: , p5_a12 JTF_DATE_TABLE
117: , p5_a13 JTF_NUMBER_TABLE
118: , p6_a0 out nocopy JTF_NUMBER_TABLE
119: , p6_a1 out nocopy JTF_NUMBER_TABLE
120: , p6_a2 out nocopy JTF_NUMBER_TABLE
121: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 118: , p6_a0 out nocopy JTF_NUMBER_TABLE

114: , p5_a10 JTF_DATE_TABLE
115: , p5_a11 JTF_NUMBER_TABLE
116: , p5_a12 JTF_DATE_TABLE
117: , p5_a13 JTF_NUMBER_TABLE
118: , p6_a0 out nocopy JTF_NUMBER_TABLE
119: , p6_a1 out nocopy JTF_NUMBER_TABLE
120: , p6_a2 out nocopy JTF_NUMBER_TABLE
121: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
122: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 119: , p6_a1 out nocopy JTF_NUMBER_TABLE

115: , p5_a11 JTF_NUMBER_TABLE
116: , p5_a12 JTF_DATE_TABLE
117: , p5_a13 JTF_NUMBER_TABLE
118: , p6_a0 out nocopy JTF_NUMBER_TABLE
119: , p6_a1 out nocopy JTF_NUMBER_TABLE
120: , p6_a2 out nocopy JTF_NUMBER_TABLE
121: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
122: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
123: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 120: , p6_a2 out nocopy JTF_NUMBER_TABLE

116: , p5_a12 JTF_DATE_TABLE
117: , p5_a13 JTF_NUMBER_TABLE
118: , p6_a0 out nocopy JTF_NUMBER_TABLE
119: , p6_a1 out nocopy JTF_NUMBER_TABLE
120: , p6_a2 out nocopy JTF_NUMBER_TABLE
121: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
122: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
123: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , p6_a6 out nocopy JTF_DATE_TABLE

Line 127: , p6_a9 out nocopy JTF_NUMBER_TABLE

123: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , p6_a6 out nocopy JTF_DATE_TABLE
125: , p6_a7 out nocopy JTF_DATE_TABLE
126: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
127: , p6_a9 out nocopy JTF_NUMBER_TABLE
128: , p6_a10 out nocopy JTF_DATE_TABLE
129: , p6_a11 out nocopy JTF_NUMBER_TABLE
130: , p6_a12 out nocopy JTF_DATE_TABLE
131: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 129: , p6_a11 out nocopy JTF_NUMBER_TABLE

125: , p6_a7 out nocopy JTF_DATE_TABLE
126: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
127: , p6_a9 out nocopy JTF_NUMBER_TABLE
128: , p6_a10 out nocopy JTF_DATE_TABLE
129: , p6_a11 out nocopy JTF_NUMBER_TABLE
130: , p6_a12 out nocopy JTF_DATE_TABLE
131: , p6_a13 out nocopy JTF_NUMBER_TABLE
132: );
133: procedure lock_row(p_api_version NUMBER

Line 131: , p6_a13 out nocopy JTF_NUMBER_TABLE

127: , p6_a9 out nocopy JTF_NUMBER_TABLE
128: , p6_a10 out nocopy JTF_DATE_TABLE
129: , p6_a11 out nocopy JTF_NUMBER_TABLE
130: , p6_a12 out nocopy JTF_DATE_TABLE
131: , p6_a13 out nocopy JTF_NUMBER_TABLE
132: );
133: procedure lock_row(p_api_version NUMBER
134: , p_init_msg_list VARCHAR2
135: , x_return_status out nocopy VARCHAR2

Line 158: , p5_a0 JTF_NUMBER_TABLE

154: , p_init_msg_list VARCHAR2
155: , x_return_status out nocopy VARCHAR2
156: , x_msg_count out nocopy NUMBER
157: , x_msg_data out nocopy VARCHAR2
158: , p5_a0 JTF_NUMBER_TABLE
159: , p5_a1 JTF_NUMBER_TABLE
160: , p5_a2 JTF_NUMBER_TABLE
161: , p5_a3 JTF_VARCHAR2_TABLE_200
162: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 159: , p5_a1 JTF_NUMBER_TABLE

155: , x_return_status out nocopy VARCHAR2
156: , x_msg_count out nocopy NUMBER
157: , x_msg_data out nocopy VARCHAR2
158: , p5_a0 JTF_NUMBER_TABLE
159: , p5_a1 JTF_NUMBER_TABLE
160: , p5_a2 JTF_NUMBER_TABLE
161: , p5_a3 JTF_VARCHAR2_TABLE_200
162: , p5_a4 JTF_VARCHAR2_TABLE_400
163: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 160: , p5_a2 JTF_NUMBER_TABLE

156: , x_msg_count out nocopy NUMBER
157: , x_msg_data out nocopy VARCHAR2
158: , p5_a0 JTF_NUMBER_TABLE
159: , p5_a1 JTF_NUMBER_TABLE
160: , p5_a2 JTF_NUMBER_TABLE
161: , p5_a3 JTF_VARCHAR2_TABLE_200
162: , p5_a4 JTF_VARCHAR2_TABLE_400
163: , p5_a5 JTF_VARCHAR2_TABLE_100
164: , p5_a6 JTF_DATE_TABLE

Line 167: , p5_a9 JTF_NUMBER_TABLE

163: , p5_a5 JTF_VARCHAR2_TABLE_100
164: , p5_a6 JTF_DATE_TABLE
165: , p5_a7 JTF_DATE_TABLE
166: , p5_a8 JTF_VARCHAR2_TABLE_2000
167: , p5_a9 JTF_NUMBER_TABLE
168: , p5_a10 JTF_DATE_TABLE
169: , p5_a11 JTF_NUMBER_TABLE
170: , p5_a12 JTF_DATE_TABLE
171: , p5_a13 JTF_NUMBER_TABLE

Line 169: , p5_a11 JTF_NUMBER_TABLE

165: , p5_a7 JTF_DATE_TABLE
166: , p5_a8 JTF_VARCHAR2_TABLE_2000
167: , p5_a9 JTF_NUMBER_TABLE
168: , p5_a10 JTF_DATE_TABLE
169: , p5_a11 JTF_NUMBER_TABLE
170: , p5_a12 JTF_DATE_TABLE
171: , p5_a13 JTF_NUMBER_TABLE
172: );
173: procedure update_row(p_api_version NUMBER

Line 171: , p5_a13 JTF_NUMBER_TABLE

167: , p5_a9 JTF_NUMBER_TABLE
168: , p5_a10 JTF_DATE_TABLE
169: , p5_a11 JTF_NUMBER_TABLE
170: , p5_a12 JTF_DATE_TABLE
171: , p5_a13 JTF_NUMBER_TABLE
172: );
173: procedure update_row(p_api_version NUMBER
174: , p_init_msg_list VARCHAR2
175: , x_return_status out nocopy VARCHAR2

Line 212: , p5_a0 JTF_NUMBER_TABLE

208: , p_init_msg_list VARCHAR2
209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_VARCHAR2_TABLE_200
216: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 213: , p5_a1 JTF_NUMBER_TABLE

209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_VARCHAR2_TABLE_200
216: , p5_a4 JTF_VARCHAR2_TABLE_400
217: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 214: , p5_a2 JTF_NUMBER_TABLE

210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_VARCHAR2_TABLE_200
216: , p5_a4 JTF_VARCHAR2_TABLE_400
217: , p5_a5 JTF_VARCHAR2_TABLE_100
218: , p5_a6 JTF_DATE_TABLE

Line 221: , p5_a9 JTF_NUMBER_TABLE

217: , p5_a5 JTF_VARCHAR2_TABLE_100
218: , p5_a6 JTF_DATE_TABLE
219: , p5_a7 JTF_DATE_TABLE
220: , p5_a8 JTF_VARCHAR2_TABLE_2000
221: , p5_a9 JTF_NUMBER_TABLE
222: , p5_a10 JTF_DATE_TABLE
223: , p5_a11 JTF_NUMBER_TABLE
224: , p5_a12 JTF_DATE_TABLE
225: , p5_a13 JTF_NUMBER_TABLE

Line 223: , p5_a11 JTF_NUMBER_TABLE

219: , p5_a7 JTF_DATE_TABLE
220: , p5_a8 JTF_VARCHAR2_TABLE_2000
221: , p5_a9 JTF_NUMBER_TABLE
222: , p5_a10 JTF_DATE_TABLE
223: , p5_a11 JTF_NUMBER_TABLE
224: , p5_a12 JTF_DATE_TABLE
225: , p5_a13 JTF_NUMBER_TABLE
226: , p6_a0 out nocopy JTF_NUMBER_TABLE
227: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 225: , p5_a13 JTF_NUMBER_TABLE

221: , p5_a9 JTF_NUMBER_TABLE
222: , p5_a10 JTF_DATE_TABLE
223: , p5_a11 JTF_NUMBER_TABLE
224: , p5_a12 JTF_DATE_TABLE
225: , p5_a13 JTF_NUMBER_TABLE
226: , p6_a0 out nocopy JTF_NUMBER_TABLE
227: , p6_a1 out nocopy JTF_NUMBER_TABLE
228: , p6_a2 out nocopy JTF_NUMBER_TABLE
229: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 226: , p6_a0 out nocopy JTF_NUMBER_TABLE

222: , p5_a10 JTF_DATE_TABLE
223: , p5_a11 JTF_NUMBER_TABLE
224: , p5_a12 JTF_DATE_TABLE
225: , p5_a13 JTF_NUMBER_TABLE
226: , p6_a0 out nocopy JTF_NUMBER_TABLE
227: , p6_a1 out nocopy JTF_NUMBER_TABLE
228: , p6_a2 out nocopy JTF_NUMBER_TABLE
229: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
230: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 227: , p6_a1 out nocopy JTF_NUMBER_TABLE

223: , p5_a11 JTF_NUMBER_TABLE
224: , p5_a12 JTF_DATE_TABLE
225: , p5_a13 JTF_NUMBER_TABLE
226: , p6_a0 out nocopy JTF_NUMBER_TABLE
227: , p6_a1 out nocopy JTF_NUMBER_TABLE
228: , p6_a2 out nocopy JTF_NUMBER_TABLE
229: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
230: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
231: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 228: , p6_a2 out nocopy JTF_NUMBER_TABLE

224: , p5_a12 JTF_DATE_TABLE
225: , p5_a13 JTF_NUMBER_TABLE
226: , p6_a0 out nocopy JTF_NUMBER_TABLE
227: , p6_a1 out nocopy JTF_NUMBER_TABLE
228: , p6_a2 out nocopy JTF_NUMBER_TABLE
229: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
230: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
231: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
232: , p6_a6 out nocopy JTF_DATE_TABLE

Line 235: , p6_a9 out nocopy JTF_NUMBER_TABLE

231: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
232: , p6_a6 out nocopy JTF_DATE_TABLE
233: , p6_a7 out nocopy JTF_DATE_TABLE
234: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
235: , p6_a9 out nocopy JTF_NUMBER_TABLE
236: , p6_a10 out nocopy JTF_DATE_TABLE
237: , p6_a11 out nocopy JTF_NUMBER_TABLE
238: , p6_a12 out nocopy JTF_DATE_TABLE
239: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 237: , p6_a11 out nocopy JTF_NUMBER_TABLE

233: , p6_a7 out nocopy JTF_DATE_TABLE
234: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
235: , p6_a9 out nocopy JTF_NUMBER_TABLE
236: , p6_a10 out nocopy JTF_DATE_TABLE
237: , p6_a11 out nocopy JTF_NUMBER_TABLE
238: , p6_a12 out nocopy JTF_DATE_TABLE
239: , p6_a13 out nocopy JTF_NUMBER_TABLE
240: );
241: procedure delete_row(p_api_version NUMBER

Line 239: , p6_a13 out nocopy JTF_NUMBER_TABLE

235: , p6_a9 out nocopy JTF_NUMBER_TABLE
236: , p6_a10 out nocopy JTF_DATE_TABLE
237: , p6_a11 out nocopy JTF_NUMBER_TABLE
238: , p6_a12 out nocopy JTF_DATE_TABLE
239: , p6_a13 out nocopy JTF_NUMBER_TABLE
240: );
241: procedure delete_row(p_api_version NUMBER
242: , p_init_msg_list VARCHAR2
243: , x_return_status out nocopy VARCHAR2

Line 266: , p5_a0 JTF_NUMBER_TABLE

262: , p_init_msg_list VARCHAR2
263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_VARCHAR2_TABLE_200
270: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 267: , p5_a1 JTF_NUMBER_TABLE

263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_VARCHAR2_TABLE_200
270: , p5_a4 JTF_VARCHAR2_TABLE_400
271: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 268: , p5_a2 JTF_NUMBER_TABLE

264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_VARCHAR2_TABLE_200
270: , p5_a4 JTF_VARCHAR2_TABLE_400
271: , p5_a5 JTF_VARCHAR2_TABLE_100
272: , p5_a6 JTF_DATE_TABLE

Line 275: , p5_a9 JTF_NUMBER_TABLE

271: , p5_a5 JTF_VARCHAR2_TABLE_100
272: , p5_a6 JTF_DATE_TABLE
273: , p5_a7 JTF_DATE_TABLE
274: , p5_a8 JTF_VARCHAR2_TABLE_2000
275: , p5_a9 JTF_NUMBER_TABLE
276: , p5_a10 JTF_DATE_TABLE
277: , p5_a11 JTF_NUMBER_TABLE
278: , p5_a12 JTF_DATE_TABLE
279: , p5_a13 JTF_NUMBER_TABLE

Line 277: , p5_a11 JTF_NUMBER_TABLE

273: , p5_a7 JTF_DATE_TABLE
274: , p5_a8 JTF_VARCHAR2_TABLE_2000
275: , p5_a9 JTF_NUMBER_TABLE
276: , p5_a10 JTF_DATE_TABLE
277: , p5_a11 JTF_NUMBER_TABLE
278: , p5_a12 JTF_DATE_TABLE
279: , p5_a13 JTF_NUMBER_TABLE
280: );
281: procedure validate_row(p_api_version NUMBER

Line 279: , p5_a13 JTF_NUMBER_TABLE

275: , p5_a9 JTF_NUMBER_TABLE
276: , p5_a10 JTF_DATE_TABLE
277: , p5_a11 JTF_NUMBER_TABLE
278: , p5_a12 JTF_DATE_TABLE
279: , p5_a13 JTF_NUMBER_TABLE
280: );
281: procedure validate_row(p_api_version NUMBER
282: , p_init_msg_list VARCHAR2
283: , x_return_status out nocopy VARCHAR2

Line 306: , p5_a0 JTF_NUMBER_TABLE

302: , p_init_msg_list VARCHAR2
303: , x_return_status out nocopy VARCHAR2
304: , x_msg_count out nocopy NUMBER
305: , x_msg_data out nocopy VARCHAR2
306: , p5_a0 JTF_NUMBER_TABLE
307: , p5_a1 JTF_NUMBER_TABLE
308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_200
310: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 307: , p5_a1 JTF_NUMBER_TABLE

303: , x_return_status out nocopy VARCHAR2
304: , x_msg_count out nocopy NUMBER
305: , x_msg_data out nocopy VARCHAR2
306: , p5_a0 JTF_NUMBER_TABLE
307: , p5_a1 JTF_NUMBER_TABLE
308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_200
310: , p5_a4 JTF_VARCHAR2_TABLE_400
311: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 308: , p5_a2 JTF_NUMBER_TABLE

304: , x_msg_count out nocopy NUMBER
305: , x_msg_data out nocopy VARCHAR2
306: , p5_a0 JTF_NUMBER_TABLE
307: , p5_a1 JTF_NUMBER_TABLE
308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_200
310: , p5_a4 JTF_VARCHAR2_TABLE_400
311: , p5_a5 JTF_VARCHAR2_TABLE_100
312: , p5_a6 JTF_DATE_TABLE

Line 315: , p5_a9 JTF_NUMBER_TABLE

311: , p5_a5 JTF_VARCHAR2_TABLE_100
312: , p5_a6 JTF_DATE_TABLE
313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_VARCHAR2_TABLE_2000
315: , p5_a9 JTF_NUMBER_TABLE
316: , p5_a10 JTF_DATE_TABLE
317: , p5_a11 JTF_NUMBER_TABLE
318: , p5_a12 JTF_DATE_TABLE
319: , p5_a13 JTF_NUMBER_TABLE

Line 317: , p5_a11 JTF_NUMBER_TABLE

313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_VARCHAR2_TABLE_2000
315: , p5_a9 JTF_NUMBER_TABLE
316: , p5_a10 JTF_DATE_TABLE
317: , p5_a11 JTF_NUMBER_TABLE
318: , p5_a12 JTF_DATE_TABLE
319: , p5_a13 JTF_NUMBER_TABLE
320: );
321: end okl_pit_pvt_w;

Line 319: , p5_a13 JTF_NUMBER_TABLE

315: , p5_a9 JTF_NUMBER_TABLE
316: , p5_a10 JTF_DATE_TABLE
317: , p5_a11 JTF_NUMBER_TABLE
318: , p5_a12 JTF_DATE_TABLE
319: , p5_a13 JTF_NUMBER_TABLE
320: );
321: end okl_pit_pvt_w;