APPS.OKL_ITY_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_ity_pvt_w as
2: /* $Header: OKLIITYS.pls 120.1 2005/07/13 09:29:00 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_ity_pvt_w as
2: /* $Header: OKLIITYS.pls 120.1 2005/07/13 09:29:00 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

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

Line 24: , a21 JTF_NUMBER_TABLE

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

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_NUMBER_TABLE

Line 31: , a1 out nocopy JTF_NUMBER_TABLE

27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 34: , a4 out nocopy JTF_NUMBER_TABLE

30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
37: , a7 out nocopy JTF_VARCHAR2_TABLE_500
38: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 51: , a21 out nocopy JTF_NUMBER_TABLE

47: , a17 out nocopy JTF_VARCHAR2_TABLE_500
48: , a18 out nocopy JTF_VARCHAR2_TABLE_500
49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE

Line 53: , a23 out nocopy JTF_NUMBER_TABLE

49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:

Line 55: , a25 out nocopy JTF_NUMBER_TABLE

51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_VARCHAR2_TABLE_100

Line 58: procedure rosetta_table_copy_in_p5(t out nocopy okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 JTF_NUMBER_TABLE

54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_VARCHAR2_TABLE_100
60: , a2 JTF_VARCHAR2_TABLE_100
61: , a3 JTF_VARCHAR2_TABLE_100
62: , a4 JTF_VARCHAR2_TABLE_200

Line 64: , a6 JTF_NUMBER_TABLE

60: , a2 JTF_VARCHAR2_TABLE_100
61: , a3 JTF_VARCHAR2_TABLE_100
62: , a4 JTF_VARCHAR2_TABLE_200
63: , a5 JTF_VARCHAR2_TABLE_2000
64: , a6 JTF_NUMBER_TABLE
65: , a7 JTF_DATE_TABLE
66: , a8 JTF_NUMBER_TABLE
67: , a9 JTF_DATE_TABLE
68: , a10 JTF_NUMBER_TABLE

Line 66: , a8 JTF_NUMBER_TABLE

62: , a4 JTF_VARCHAR2_TABLE_200
63: , a5 JTF_VARCHAR2_TABLE_2000
64: , a6 JTF_NUMBER_TABLE
65: , a7 JTF_DATE_TABLE
66: , a8 JTF_NUMBER_TABLE
67: , a9 JTF_DATE_TABLE
68: , a10 JTF_NUMBER_TABLE
69: );
70: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 68: , a10 JTF_NUMBER_TABLE

64: , a6 JTF_NUMBER_TABLE
65: , a7 JTF_DATE_TABLE
66: , a8 JTF_NUMBER_TABLE
67: , a9 JTF_DATE_TABLE
68: , a10 JTF_NUMBER_TABLE
69: );
70: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_VARCHAR2_TABLE_100
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

66: , a8 JTF_NUMBER_TABLE
67: , a9 JTF_DATE_TABLE
68: , a10 JTF_NUMBER_TABLE
69: );
70: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_VARCHAR2_TABLE_100
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 76: , a6 out nocopy JTF_NUMBER_TABLE

72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_VARCHAR2_TABLE_200
75: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_DATE_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_DATE_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE

Line 78: , a8 out nocopy JTF_NUMBER_TABLE

74: , a4 out nocopy JTF_VARCHAR2_TABLE_200
75: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_DATE_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_DATE_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: );
82:

Line 80: , a10 out nocopy JTF_NUMBER_TABLE

76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_DATE_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_DATE_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: );
82:
83: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
84: , a1 JTF_NUMBER_TABLE

Line 83: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE

79: , a9 out nocopy JTF_DATE_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: );
82:
83: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_VARCHAR2_TABLE_100
86: , a3 JTF_NUMBER_TABLE
87: , a4 JTF_VARCHAR2_TABLE_200

Line 84: , a1 JTF_NUMBER_TABLE

80: , a10 out nocopy JTF_NUMBER_TABLE
81: );
82:
83: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_VARCHAR2_TABLE_100
86: , a3 JTF_NUMBER_TABLE
87: , a4 JTF_VARCHAR2_TABLE_200
88: , a5 JTF_VARCHAR2_TABLE_2000

Line 86: , a3 JTF_NUMBER_TABLE

82:
83: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_VARCHAR2_TABLE_100
86: , a3 JTF_NUMBER_TABLE
87: , a4 JTF_VARCHAR2_TABLE_200
88: , a5 JTF_VARCHAR2_TABLE_2000
89: , a6 JTF_VARCHAR2_TABLE_100
90: , a7 JTF_VARCHAR2_TABLE_100

Line 107: , a24 JTF_NUMBER_TABLE

103: , a20 JTF_VARCHAR2_TABLE_500
104: , a21 JTF_VARCHAR2_TABLE_500
105: , a22 JTF_VARCHAR2_TABLE_500
106: , a23 JTF_VARCHAR2_TABLE_500
107: , a24 JTF_NUMBER_TABLE
108: , a25 JTF_DATE_TABLE
109: , a26 JTF_NUMBER_TABLE
110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE

Line 109: , a26 JTF_NUMBER_TABLE

105: , a22 JTF_VARCHAR2_TABLE_500
106: , a23 JTF_VARCHAR2_TABLE_500
107: , a24 JTF_NUMBER_TABLE
108: , a25 JTF_DATE_TABLE
109: , a26 JTF_NUMBER_TABLE
110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE
112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 111: , a28 JTF_NUMBER_TABLE

107: , a24 JTF_NUMBER_TABLE
108: , a25 JTF_DATE_TABLE
109: , a26 JTF_NUMBER_TABLE
110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE
112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_NUMBER_TABLE
115: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

109: , a26 JTF_NUMBER_TABLE
110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE
112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_NUMBER_TABLE
115: , a2 out nocopy JTF_VARCHAR2_TABLE_100
116: , a3 out nocopy JTF_NUMBER_TABLE
117: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 114: , a1 out nocopy JTF_NUMBER_TABLE

110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE
112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_NUMBER_TABLE
115: , a2 out nocopy JTF_VARCHAR2_TABLE_100
116: , a3 out nocopy JTF_NUMBER_TABLE
117: , a4 out nocopy JTF_VARCHAR2_TABLE_200
118: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 116: , a3 out nocopy JTF_NUMBER_TABLE

112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_NUMBER_TABLE
115: , a2 out nocopy JTF_VARCHAR2_TABLE_100
116: , a3 out nocopy JTF_NUMBER_TABLE
117: , a4 out nocopy JTF_VARCHAR2_TABLE_200
118: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
119: , a6 out nocopy JTF_VARCHAR2_TABLE_100
120: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: , a24 out nocopy JTF_NUMBER_TABLE

133: , a20 out nocopy JTF_VARCHAR2_TABLE_500
134: , a21 out nocopy JTF_VARCHAR2_TABLE_500
135: , a22 out nocopy JTF_VARCHAR2_TABLE_500
136: , a23 out nocopy JTF_VARCHAR2_TABLE_500
137: , a24 out nocopy JTF_NUMBER_TABLE
138: , a25 out nocopy JTF_DATE_TABLE
139: , a26 out nocopy JTF_NUMBER_TABLE
140: , a27 out nocopy JTF_DATE_TABLE
141: , a28 out nocopy JTF_NUMBER_TABLE

Line 139: , a26 out nocopy JTF_NUMBER_TABLE

135: , a22 out nocopy JTF_VARCHAR2_TABLE_500
136: , a23 out nocopy JTF_VARCHAR2_TABLE_500
137: , a24 out nocopy JTF_NUMBER_TABLE
138: , a25 out nocopy JTF_DATE_TABLE
139: , a26 out nocopy JTF_NUMBER_TABLE
140: , a27 out nocopy JTF_DATE_TABLE
141: , a28 out nocopy JTF_NUMBER_TABLE
142: );
143:

Line 141: , a28 out nocopy JTF_NUMBER_TABLE

137: , a24 out nocopy JTF_NUMBER_TABLE
138: , a25 out nocopy JTF_DATE_TABLE
139: , a26 out nocopy JTF_NUMBER_TABLE
140: , a27 out nocopy JTF_DATE_TABLE
141: , a28 out nocopy JTF_NUMBER_TABLE
142: );
143:
144: procedure insert_row(p_api_version NUMBER
145: , p_init_msg_list VARCHAR2

Line 213: , p5_a0 JTF_NUMBER_TABLE

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

Line 214: , p5_a1 JTF_NUMBER_TABLE

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

Line 216: , p5_a3 JTF_NUMBER_TABLE

212: , x_msg_data out nocopy VARCHAR2
213: , p5_a0 JTF_NUMBER_TABLE
214: , p5_a1 JTF_NUMBER_TABLE
215: , p5_a2 JTF_VARCHAR2_TABLE_100
216: , p5_a3 JTF_NUMBER_TABLE
217: , p5_a4 JTF_VARCHAR2_TABLE_200
218: , p5_a5 JTF_VARCHAR2_TABLE_2000
219: , p5_a6 JTF_VARCHAR2_TABLE_100
220: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 237: , p5_a24 JTF_NUMBER_TABLE

233: , p5_a20 JTF_VARCHAR2_TABLE_500
234: , p5_a21 JTF_VARCHAR2_TABLE_500
235: , p5_a22 JTF_VARCHAR2_TABLE_500
236: , p5_a23 JTF_VARCHAR2_TABLE_500
237: , p5_a24 JTF_NUMBER_TABLE
238: , p5_a25 JTF_DATE_TABLE
239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE

Line 239: , p5_a26 JTF_NUMBER_TABLE

235: , p5_a22 JTF_VARCHAR2_TABLE_500
236: , p5_a23 JTF_VARCHAR2_TABLE_500
237: , p5_a24 JTF_NUMBER_TABLE
238: , p5_a25 JTF_DATE_TABLE
239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 241: , p5_a28 JTF_NUMBER_TABLE

237: , p5_a24 JTF_NUMBER_TABLE
238: , p5_a25 JTF_DATE_TABLE
239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 242: , p6_a0 out nocopy JTF_NUMBER_TABLE

238: , p5_a25 JTF_DATE_TABLE
239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a3 out nocopy JTF_NUMBER_TABLE
246: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 243: , p6_a1 out nocopy JTF_NUMBER_TABLE

239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a3 out nocopy JTF_NUMBER_TABLE
246: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
247: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 245: , p6_a3 out nocopy JTF_NUMBER_TABLE

241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a3 out nocopy JTF_NUMBER_TABLE
246: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
247: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
248: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , p6_a24 out nocopy JTF_NUMBER_TABLE

262: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
263: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
264: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
265: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
266: , p6_a24 out nocopy JTF_NUMBER_TABLE
267: , p6_a25 out nocopy JTF_DATE_TABLE
268: , p6_a26 out nocopy JTF_NUMBER_TABLE
269: , p6_a27 out nocopy JTF_DATE_TABLE
270: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 268: , p6_a26 out nocopy JTF_NUMBER_TABLE

264: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
265: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
266: , p6_a24 out nocopy JTF_NUMBER_TABLE
267: , p6_a25 out nocopy JTF_DATE_TABLE
268: , p6_a26 out nocopy JTF_NUMBER_TABLE
269: , p6_a27 out nocopy JTF_DATE_TABLE
270: , p6_a28 out nocopy JTF_NUMBER_TABLE
271: );
272: procedure lock_row(p_api_version NUMBER

Line 270: , p6_a28 out nocopy JTF_NUMBER_TABLE

266: , p6_a24 out nocopy JTF_NUMBER_TABLE
267: , p6_a25 out nocopy JTF_DATE_TABLE
268: , p6_a26 out nocopy JTF_NUMBER_TABLE
269: , p6_a27 out nocopy JTF_DATE_TABLE
270: , p6_a28 out nocopy JTF_NUMBER_TABLE
271: );
272: procedure lock_row(p_api_version NUMBER
273: , p_init_msg_list VARCHAR2
274: , x_return_status out nocopy VARCHAR2

Line 312: , p5_a0 JTF_NUMBER_TABLE

308: , p_init_msg_list VARCHAR2
309: , x_return_status out nocopy VARCHAR2
310: , x_msg_count out nocopy NUMBER
311: , x_msg_data out nocopy VARCHAR2
312: , p5_a0 JTF_NUMBER_TABLE
313: , p5_a1 JTF_NUMBER_TABLE
314: , p5_a2 JTF_VARCHAR2_TABLE_100
315: , p5_a3 JTF_NUMBER_TABLE
316: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 313: , p5_a1 JTF_NUMBER_TABLE

309: , x_return_status out nocopy VARCHAR2
310: , x_msg_count out nocopy NUMBER
311: , x_msg_data out nocopy VARCHAR2
312: , p5_a0 JTF_NUMBER_TABLE
313: , p5_a1 JTF_NUMBER_TABLE
314: , p5_a2 JTF_VARCHAR2_TABLE_100
315: , p5_a3 JTF_NUMBER_TABLE
316: , p5_a4 JTF_VARCHAR2_TABLE_200
317: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 315: , p5_a3 JTF_NUMBER_TABLE

311: , x_msg_data out nocopy VARCHAR2
312: , p5_a0 JTF_NUMBER_TABLE
313: , p5_a1 JTF_NUMBER_TABLE
314: , p5_a2 JTF_VARCHAR2_TABLE_100
315: , p5_a3 JTF_NUMBER_TABLE
316: , p5_a4 JTF_VARCHAR2_TABLE_200
317: , p5_a5 JTF_VARCHAR2_TABLE_2000
318: , p5_a6 JTF_VARCHAR2_TABLE_100
319: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 336: , p5_a24 JTF_NUMBER_TABLE

332: , p5_a20 JTF_VARCHAR2_TABLE_500
333: , p5_a21 JTF_VARCHAR2_TABLE_500
334: , p5_a22 JTF_VARCHAR2_TABLE_500
335: , p5_a23 JTF_VARCHAR2_TABLE_500
336: , p5_a24 JTF_NUMBER_TABLE
337: , p5_a25 JTF_DATE_TABLE
338: , p5_a26 JTF_NUMBER_TABLE
339: , p5_a27 JTF_DATE_TABLE
340: , p5_a28 JTF_NUMBER_TABLE

Line 338: , p5_a26 JTF_NUMBER_TABLE

334: , p5_a22 JTF_VARCHAR2_TABLE_500
335: , p5_a23 JTF_VARCHAR2_TABLE_500
336: , p5_a24 JTF_NUMBER_TABLE
337: , p5_a25 JTF_DATE_TABLE
338: , p5_a26 JTF_NUMBER_TABLE
339: , p5_a27 JTF_DATE_TABLE
340: , p5_a28 JTF_NUMBER_TABLE
341: );
342: procedure update_row(p_api_version NUMBER

Line 340: , p5_a28 JTF_NUMBER_TABLE

336: , p5_a24 JTF_NUMBER_TABLE
337: , p5_a25 JTF_DATE_TABLE
338: , p5_a26 JTF_NUMBER_TABLE
339: , p5_a27 JTF_DATE_TABLE
340: , p5_a28 JTF_NUMBER_TABLE
341: );
342: procedure update_row(p_api_version NUMBER
343: , p_init_msg_list VARCHAR2
344: , x_return_status out nocopy VARCHAR2

Line 411: , p5_a0 JTF_NUMBER_TABLE

407: , p_init_msg_list VARCHAR2
408: , x_return_status out nocopy VARCHAR2
409: , x_msg_count out nocopy NUMBER
410: , x_msg_data out nocopy VARCHAR2
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 412: , p5_a1 JTF_NUMBER_TABLE

408: , x_return_status out nocopy VARCHAR2
409: , x_msg_count out nocopy NUMBER
410: , x_msg_data out nocopy VARCHAR2
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_VARCHAR2_TABLE_200
416: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 414: , p5_a3 JTF_NUMBER_TABLE

410: , x_msg_data out nocopy VARCHAR2
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_VARCHAR2_TABLE_200
416: , p5_a5 JTF_VARCHAR2_TABLE_2000
417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 435: , p5_a24 JTF_NUMBER_TABLE

431: , p5_a20 JTF_VARCHAR2_TABLE_500
432: , p5_a21 JTF_VARCHAR2_TABLE_500
433: , p5_a22 JTF_VARCHAR2_TABLE_500
434: , p5_a23 JTF_VARCHAR2_TABLE_500
435: , p5_a24 JTF_NUMBER_TABLE
436: , p5_a25 JTF_DATE_TABLE
437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE

Line 437: , p5_a26 JTF_NUMBER_TABLE

433: , p5_a22 JTF_VARCHAR2_TABLE_500
434: , p5_a23 JTF_VARCHAR2_TABLE_500
435: , p5_a24 JTF_NUMBER_TABLE
436: , p5_a25 JTF_DATE_TABLE
437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 439: , p5_a28 JTF_NUMBER_TABLE

435: , p5_a24 JTF_NUMBER_TABLE
436: , p5_a25 JTF_DATE_TABLE
437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE
442: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 440: , p6_a0 out nocopy JTF_NUMBER_TABLE

436: , p5_a25 JTF_DATE_TABLE
437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE
442: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p6_a3 out nocopy JTF_NUMBER_TABLE
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 441: , p6_a1 out nocopy JTF_NUMBER_TABLE

437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE
442: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p6_a3 out nocopy JTF_NUMBER_TABLE
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
445: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 443: , p6_a3 out nocopy JTF_NUMBER_TABLE

439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE
442: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p6_a3 out nocopy JTF_NUMBER_TABLE
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
445: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
446: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
447: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 464: , p6_a24 out nocopy JTF_NUMBER_TABLE

460: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
461: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
462: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
463: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
464: , p6_a24 out nocopy JTF_NUMBER_TABLE
465: , p6_a25 out nocopy JTF_DATE_TABLE
466: , p6_a26 out nocopy JTF_NUMBER_TABLE
467: , p6_a27 out nocopy JTF_DATE_TABLE
468: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 466: , p6_a26 out nocopy JTF_NUMBER_TABLE

462: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
463: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
464: , p6_a24 out nocopy JTF_NUMBER_TABLE
465: , p6_a25 out nocopy JTF_DATE_TABLE
466: , p6_a26 out nocopy JTF_NUMBER_TABLE
467: , p6_a27 out nocopy JTF_DATE_TABLE
468: , p6_a28 out nocopy JTF_NUMBER_TABLE
469: );
470: procedure delete_row(p_api_version NUMBER

Line 468: , p6_a28 out nocopy JTF_NUMBER_TABLE

464: , p6_a24 out nocopy JTF_NUMBER_TABLE
465: , p6_a25 out nocopy JTF_DATE_TABLE
466: , p6_a26 out nocopy JTF_NUMBER_TABLE
467: , p6_a27 out nocopy JTF_DATE_TABLE
468: , p6_a28 out nocopy JTF_NUMBER_TABLE
469: );
470: procedure delete_row(p_api_version NUMBER
471: , p_init_msg_list VARCHAR2
472: , x_return_status out nocopy VARCHAR2

Line 510: , p5_a0 JTF_NUMBER_TABLE

506: , p_init_msg_list VARCHAR2
507: , x_return_status out nocopy VARCHAR2
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_VARCHAR2_TABLE_100
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 511: , p5_a1 JTF_NUMBER_TABLE

507: , x_return_status out nocopy VARCHAR2
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_VARCHAR2_TABLE_100
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_200
515: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 513: , p5_a3 JTF_NUMBER_TABLE

509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_VARCHAR2_TABLE_100
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_200
515: , p5_a5 JTF_VARCHAR2_TABLE_2000
516: , p5_a6 JTF_VARCHAR2_TABLE_100
517: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 534: , p5_a24 JTF_NUMBER_TABLE

530: , p5_a20 JTF_VARCHAR2_TABLE_500
531: , p5_a21 JTF_VARCHAR2_TABLE_500
532: , p5_a22 JTF_VARCHAR2_TABLE_500
533: , p5_a23 JTF_VARCHAR2_TABLE_500
534: , p5_a24 JTF_NUMBER_TABLE
535: , p5_a25 JTF_DATE_TABLE
536: , p5_a26 JTF_NUMBER_TABLE
537: , p5_a27 JTF_DATE_TABLE
538: , p5_a28 JTF_NUMBER_TABLE

Line 536: , p5_a26 JTF_NUMBER_TABLE

532: , p5_a22 JTF_VARCHAR2_TABLE_500
533: , p5_a23 JTF_VARCHAR2_TABLE_500
534: , p5_a24 JTF_NUMBER_TABLE
535: , p5_a25 JTF_DATE_TABLE
536: , p5_a26 JTF_NUMBER_TABLE
537: , p5_a27 JTF_DATE_TABLE
538: , p5_a28 JTF_NUMBER_TABLE
539: );
540: procedure validate_row(p_api_version NUMBER

Line 538: , p5_a28 JTF_NUMBER_TABLE

534: , p5_a24 JTF_NUMBER_TABLE
535: , p5_a25 JTF_DATE_TABLE
536: , p5_a26 JTF_NUMBER_TABLE
537: , p5_a27 JTF_DATE_TABLE
538: , p5_a28 JTF_NUMBER_TABLE
539: );
540: procedure validate_row(p_api_version NUMBER
541: , p_init_msg_list VARCHAR2
542: , x_return_status out nocopy VARCHAR2

Line 580: , p5_a0 JTF_NUMBER_TABLE

576: , p_init_msg_list VARCHAR2
577: , x_return_status out nocopy VARCHAR2
578: , x_msg_count out nocopy NUMBER
579: , x_msg_data out nocopy VARCHAR2
580: , p5_a0 JTF_NUMBER_TABLE
581: , p5_a1 JTF_NUMBER_TABLE
582: , p5_a2 JTF_VARCHAR2_TABLE_100
583: , p5_a3 JTF_NUMBER_TABLE
584: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 581: , p5_a1 JTF_NUMBER_TABLE

577: , x_return_status out nocopy VARCHAR2
578: , x_msg_count out nocopy NUMBER
579: , x_msg_data out nocopy VARCHAR2
580: , p5_a0 JTF_NUMBER_TABLE
581: , p5_a1 JTF_NUMBER_TABLE
582: , p5_a2 JTF_VARCHAR2_TABLE_100
583: , p5_a3 JTF_NUMBER_TABLE
584: , p5_a4 JTF_VARCHAR2_TABLE_200
585: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 583: , p5_a3 JTF_NUMBER_TABLE

579: , x_msg_data out nocopy VARCHAR2
580: , p5_a0 JTF_NUMBER_TABLE
581: , p5_a1 JTF_NUMBER_TABLE
582: , p5_a2 JTF_VARCHAR2_TABLE_100
583: , p5_a3 JTF_NUMBER_TABLE
584: , p5_a4 JTF_VARCHAR2_TABLE_200
585: , p5_a5 JTF_VARCHAR2_TABLE_2000
586: , p5_a6 JTF_VARCHAR2_TABLE_100
587: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 604: , p5_a24 JTF_NUMBER_TABLE

600: , p5_a20 JTF_VARCHAR2_TABLE_500
601: , p5_a21 JTF_VARCHAR2_TABLE_500
602: , p5_a22 JTF_VARCHAR2_TABLE_500
603: , p5_a23 JTF_VARCHAR2_TABLE_500
604: , p5_a24 JTF_NUMBER_TABLE
605: , p5_a25 JTF_DATE_TABLE
606: , p5_a26 JTF_NUMBER_TABLE
607: , p5_a27 JTF_DATE_TABLE
608: , p5_a28 JTF_NUMBER_TABLE

Line 606: , p5_a26 JTF_NUMBER_TABLE

602: , p5_a22 JTF_VARCHAR2_TABLE_500
603: , p5_a23 JTF_VARCHAR2_TABLE_500
604: , p5_a24 JTF_NUMBER_TABLE
605: , p5_a25 JTF_DATE_TABLE
606: , p5_a26 JTF_NUMBER_TABLE
607: , p5_a27 JTF_DATE_TABLE
608: , p5_a28 JTF_NUMBER_TABLE
609: );
610: end okl_ity_pvt_w;

Line 608: , p5_a28 JTF_NUMBER_TABLE

604: , p5_a24 JTF_NUMBER_TABLE
605: , p5_a25 JTF_DATE_TABLE
606: , p5_a26 JTF_NUMBER_TABLE
607: , p5_a27 JTF_DATE_TABLE
608: , p5_a28 JTF_NUMBER_TABLE
609: );
610: end okl_ity_pvt_w;