APPS.OKL_ECC_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecc_pvt.okl_eccv_tbl, a0 JTF_NUMBER_TABLE

1: package okl_ecc_pvt_w as
2: /* $Header: OKLIECCS.pls 120.1 2005/10/30 04:58:35 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecc_pvt.okl_eccv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_ecc_pvt_w as
2: /* $Header: OKLIECCS.pls 120.1 2005/10/30 04:58:35 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecc_pvt.okl_eccv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_2000

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIECCS.pls 120.1 2005/10/30 04:58:35 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecc_pvt.okl_eccv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE

Line 17: , a14 JTF_NUMBER_TABLE

13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE

Line 19: , a16 JTF_NUMBER_TABLE

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
23: procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 21: , a18 JTF_NUMBER_TABLE

17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
23: procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_NUMBER_TABLE
25: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 23: procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE

19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
23: procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_NUMBER_TABLE
25: , a2 out nocopy JTF_VARCHAR2_TABLE_100
26: , a3 out nocopy JTF_NUMBER_TABLE
27: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 24: , a1 out nocopy JTF_NUMBER_TABLE

20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
23: procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_NUMBER_TABLE
25: , a2 out nocopy JTF_VARCHAR2_TABLE_100
26: , a3 out nocopy JTF_NUMBER_TABLE
27: , a4 out nocopy JTF_VARCHAR2_TABLE_300
28: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 26: , a3 out nocopy JTF_NUMBER_TABLE

22: );
23: procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_NUMBER_TABLE
25: , a2 out nocopy JTF_VARCHAR2_TABLE_100
26: , a3 out nocopy JTF_NUMBER_TABLE
27: , a4 out nocopy JTF_VARCHAR2_TABLE_300
28: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
29: , a6 out nocopy JTF_VARCHAR2_TABLE_100
30: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 34: , a11 out nocopy JTF_NUMBER_TABLE

30: , a7 out nocopy JTF_VARCHAR2_TABLE_100
31: , a8 out nocopy JTF_VARCHAR2_TABLE_100
32: , a9 out nocopy JTF_VARCHAR2_TABLE_100
33: , a10 out nocopy JTF_VARCHAR2_TABLE_100
34: , a11 out nocopy JTF_NUMBER_TABLE
35: , a12 out nocopy JTF_VARCHAR2_TABLE_100
36: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
37: , a14 out nocopy JTF_NUMBER_TABLE
38: , a15 out nocopy JTF_DATE_TABLE

Line 37: , a14 out nocopy JTF_NUMBER_TABLE

33: , a10 out nocopy JTF_VARCHAR2_TABLE_100
34: , a11 out nocopy JTF_NUMBER_TABLE
35: , a12 out nocopy JTF_VARCHAR2_TABLE_100
36: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
37: , a14 out nocopy JTF_NUMBER_TABLE
38: , a15 out nocopy JTF_DATE_TABLE
39: , a16 out nocopy JTF_NUMBER_TABLE
40: , a17 out nocopy JTF_DATE_TABLE
41: , a18 out nocopy JTF_NUMBER_TABLE

Line 39: , a16 out nocopy JTF_NUMBER_TABLE

35: , a12 out nocopy JTF_VARCHAR2_TABLE_100
36: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
37: , a14 out nocopy JTF_NUMBER_TABLE
38: , a15 out nocopy JTF_DATE_TABLE
39: , a16 out nocopy JTF_NUMBER_TABLE
40: , a17 out nocopy JTF_DATE_TABLE
41: , a18 out nocopy JTF_NUMBER_TABLE
42: );
43:

Line 41: , a18 out nocopy JTF_NUMBER_TABLE

37: , a14 out nocopy JTF_NUMBER_TABLE
38: , a15 out nocopy JTF_DATE_TABLE
39: , a16 out nocopy JTF_NUMBER_TABLE
40: , a17 out nocopy JTF_DATE_TABLE
41: , a18 out nocopy JTF_NUMBER_TABLE
42: );
43:
44: procedure rosetta_table_copy_in_p3(t out nocopy okl_ecc_pvt.okl_eccb_tbl, a0 JTF_NUMBER_TABLE
45: , a1 JTF_NUMBER_TABLE

Line 44: procedure rosetta_table_copy_in_p3(t out nocopy okl_ecc_pvt.okl_eccb_tbl, a0 JTF_NUMBER_TABLE

40: , a17 out nocopy JTF_DATE_TABLE
41: , a18 out nocopy JTF_NUMBER_TABLE
42: );
43:
44: procedure rosetta_table_copy_in_p3(t out nocopy okl_ecc_pvt.okl_eccb_tbl, a0 JTF_NUMBER_TABLE
45: , a1 JTF_NUMBER_TABLE
46: , a2 JTF_VARCHAR2_TABLE_300
47: , a3 JTF_VARCHAR2_TABLE_100
48: , a4 JTF_NUMBER_TABLE

Line 45: , a1 JTF_NUMBER_TABLE

41: , a18 out nocopy JTF_NUMBER_TABLE
42: );
43:
44: procedure rosetta_table_copy_in_p3(t out nocopy okl_ecc_pvt.okl_eccb_tbl, a0 JTF_NUMBER_TABLE
45: , a1 JTF_NUMBER_TABLE
46: , a2 JTF_VARCHAR2_TABLE_300
47: , a3 JTF_VARCHAR2_TABLE_100
48: , a4 JTF_NUMBER_TABLE
49: , a5 JTF_VARCHAR2_TABLE_100

Line 48: , a4 JTF_NUMBER_TABLE

44: procedure rosetta_table_copy_in_p3(t out nocopy okl_ecc_pvt.okl_eccb_tbl, a0 JTF_NUMBER_TABLE
45: , a1 JTF_NUMBER_TABLE
46: , a2 JTF_VARCHAR2_TABLE_300
47: , a3 JTF_VARCHAR2_TABLE_100
48: , a4 JTF_NUMBER_TABLE
49: , a5 JTF_VARCHAR2_TABLE_100
50: , a6 JTF_VARCHAR2_TABLE_100
51: , a7 JTF_VARCHAR2_TABLE_100
52: , a8 JTF_VARCHAR2_TABLE_100

Line 53: , a9 JTF_NUMBER_TABLE

49: , a5 JTF_VARCHAR2_TABLE_100
50: , a6 JTF_VARCHAR2_TABLE_100
51: , a7 JTF_VARCHAR2_TABLE_100
52: , a8 JTF_VARCHAR2_TABLE_100
53: , a9 JTF_NUMBER_TABLE
54: , a10 JTF_VARCHAR2_TABLE_100
55: , a11 JTF_VARCHAR2_TABLE_2000
56: , a12 JTF_NUMBER_TABLE
57: , a13 JTF_DATE_TABLE

Line 56: , a12 JTF_NUMBER_TABLE

52: , a8 JTF_VARCHAR2_TABLE_100
53: , a9 JTF_NUMBER_TABLE
54: , a10 JTF_VARCHAR2_TABLE_100
55: , a11 JTF_VARCHAR2_TABLE_2000
56: , a12 JTF_NUMBER_TABLE
57: , a13 JTF_DATE_TABLE
58: , a14 JTF_NUMBER_TABLE
59: , a15 JTF_DATE_TABLE
60: , a16 JTF_NUMBER_TABLE

Line 58: , a14 JTF_NUMBER_TABLE

54: , a10 JTF_VARCHAR2_TABLE_100
55: , a11 JTF_VARCHAR2_TABLE_2000
56: , a12 JTF_NUMBER_TABLE
57: , a13 JTF_DATE_TABLE
58: , a14 JTF_NUMBER_TABLE
59: , a15 JTF_DATE_TABLE
60: , a16 JTF_NUMBER_TABLE
61: );
62: procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 60: , a16 JTF_NUMBER_TABLE

56: , a12 JTF_NUMBER_TABLE
57: , a13 JTF_DATE_TABLE
58: , a14 JTF_NUMBER_TABLE
59: , a15 JTF_DATE_TABLE
60: , a16 JTF_NUMBER_TABLE
61: );
62: procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE
63: , a1 out nocopy JTF_NUMBER_TABLE
64: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 62: procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE

58: , a14 JTF_NUMBER_TABLE
59: , a15 JTF_DATE_TABLE
60: , a16 JTF_NUMBER_TABLE
61: );
62: procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE
63: , a1 out nocopy JTF_NUMBER_TABLE
64: , a2 out nocopy JTF_VARCHAR2_TABLE_300
65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_NUMBER_TABLE

Line 63: , a1 out nocopy JTF_NUMBER_TABLE

59: , a15 JTF_DATE_TABLE
60: , a16 JTF_NUMBER_TABLE
61: );
62: procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE
63: , a1 out nocopy JTF_NUMBER_TABLE
64: , a2 out nocopy JTF_VARCHAR2_TABLE_300
65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_NUMBER_TABLE
67: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 66: , a4 out nocopy JTF_NUMBER_TABLE

62: procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE
63: , a1 out nocopy JTF_NUMBER_TABLE
64: , a2 out nocopy JTF_VARCHAR2_TABLE_300
65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_NUMBER_TABLE
67: , a5 out nocopy JTF_VARCHAR2_TABLE_100
68: , a6 out nocopy JTF_VARCHAR2_TABLE_100
69: , a7 out nocopy JTF_VARCHAR2_TABLE_100
70: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 71: , a9 out nocopy JTF_NUMBER_TABLE

67: , a5 out nocopy JTF_VARCHAR2_TABLE_100
68: , a6 out nocopy JTF_VARCHAR2_TABLE_100
69: , a7 out nocopy JTF_VARCHAR2_TABLE_100
70: , a8 out nocopy JTF_VARCHAR2_TABLE_100
71: , a9 out nocopy JTF_NUMBER_TABLE
72: , a10 out nocopy JTF_VARCHAR2_TABLE_100
73: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
74: , a12 out nocopy JTF_NUMBER_TABLE
75: , a13 out nocopy JTF_DATE_TABLE

Line 74: , a12 out nocopy JTF_NUMBER_TABLE

70: , a8 out nocopy JTF_VARCHAR2_TABLE_100
71: , a9 out nocopy JTF_NUMBER_TABLE
72: , a10 out nocopy JTF_VARCHAR2_TABLE_100
73: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
74: , a12 out nocopy JTF_NUMBER_TABLE
75: , a13 out nocopy JTF_DATE_TABLE
76: , a14 out nocopy JTF_NUMBER_TABLE
77: , a15 out nocopy JTF_DATE_TABLE
78: , a16 out nocopy JTF_NUMBER_TABLE

Line 76: , a14 out nocopy JTF_NUMBER_TABLE

72: , a10 out nocopy JTF_VARCHAR2_TABLE_100
73: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
74: , a12 out nocopy JTF_NUMBER_TABLE
75: , a13 out nocopy JTF_DATE_TABLE
76: , a14 out nocopy JTF_NUMBER_TABLE
77: , a15 out nocopy JTF_DATE_TABLE
78: , a16 out nocopy JTF_NUMBER_TABLE
79: );
80:

Line 78: , a16 out nocopy JTF_NUMBER_TABLE

74: , a12 out nocopy JTF_NUMBER_TABLE
75: , a13 out nocopy JTF_DATE_TABLE
76: , a14 out nocopy JTF_NUMBER_TABLE
77: , a15 out nocopy JTF_DATE_TABLE
78: , a16 out nocopy JTF_NUMBER_TABLE
79: );
80:
81: procedure rosetta_table_copy_in_p5(t out nocopy okl_ecc_pvt.okl_ecctl_tbl, a0 JTF_NUMBER_TABLE
82: , a1 JTF_VARCHAR2_TABLE_100

Line 81: procedure rosetta_table_copy_in_p5(t out nocopy okl_ecc_pvt.okl_ecctl_tbl, a0 JTF_NUMBER_TABLE

77: , a15 out nocopy JTF_DATE_TABLE
78: , a16 out nocopy JTF_NUMBER_TABLE
79: );
80:
81: procedure rosetta_table_copy_in_p5(t out nocopy okl_ecc_pvt.okl_ecctl_tbl, a0 JTF_NUMBER_TABLE
82: , a1 JTF_VARCHAR2_TABLE_100
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_2000

Line 86: , a5 JTF_NUMBER_TABLE

82: , a1 JTF_VARCHAR2_TABLE_100
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_2000
86: , a5 JTF_NUMBER_TABLE
87: , a6 JTF_DATE_TABLE
88: , a7 JTF_NUMBER_TABLE
89: , a8 JTF_DATE_TABLE
90: , a9 JTF_NUMBER_TABLE

Line 88: , a7 JTF_NUMBER_TABLE

84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_2000
86: , a5 JTF_NUMBER_TABLE
87: , a6 JTF_DATE_TABLE
88: , a7 JTF_NUMBER_TABLE
89: , a8 JTF_DATE_TABLE
90: , a9 JTF_NUMBER_TABLE
91: );
92: procedure rosetta_table_copy_out_p5(t okl_ecc_pvt.okl_ecctl_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 90: , a9 JTF_NUMBER_TABLE

86: , a5 JTF_NUMBER_TABLE
87: , a6 JTF_DATE_TABLE
88: , a7 JTF_NUMBER_TABLE
89: , a8 JTF_DATE_TABLE
90: , a9 JTF_NUMBER_TABLE
91: );
92: procedure rosetta_table_copy_out_p5(t okl_ecc_pvt.okl_ecctl_tbl, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_VARCHAR2_TABLE_100
94: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 92: procedure rosetta_table_copy_out_p5(t okl_ecc_pvt.okl_ecctl_tbl, a0 out nocopy JTF_NUMBER_TABLE

88: , a7 JTF_NUMBER_TABLE
89: , a8 JTF_DATE_TABLE
90: , a9 JTF_NUMBER_TABLE
91: );
92: procedure rosetta_table_copy_out_p5(t okl_ecc_pvt.okl_ecctl_tbl, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_VARCHAR2_TABLE_100
94: , a2 out nocopy JTF_VARCHAR2_TABLE_100
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 97: , a5 out nocopy JTF_NUMBER_TABLE

93: , a1 out nocopy JTF_VARCHAR2_TABLE_100
94: , a2 out nocopy JTF_VARCHAR2_TABLE_100
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a5 out nocopy JTF_NUMBER_TABLE
98: , a6 out nocopy JTF_DATE_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_DATE_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE

Line 99: , a7 out nocopy JTF_NUMBER_TABLE

95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a5 out nocopy JTF_NUMBER_TABLE
98: , a6 out nocopy JTF_DATE_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_DATE_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE
102: );
103:

Line 101: , a9 out nocopy JTF_NUMBER_TABLE

97: , a5 out nocopy JTF_NUMBER_TABLE
98: , a6 out nocopy JTF_DATE_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_DATE_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE
102: );
103:
104: procedure insert_row(p_api_version NUMBER
105: , p_init_msg_list VARCHAR2

Line 153: , p5_a0 JTF_NUMBER_TABLE

149: , p_init_msg_list VARCHAR2
150: , x_return_status out nocopy VARCHAR2
151: , x_msg_count out nocopy NUMBER
152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 JTF_NUMBER_TABLE
154: , p5_a1 JTF_NUMBER_TABLE
155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 154: , p5_a1 JTF_NUMBER_TABLE

150: , x_return_status out nocopy VARCHAR2
151: , x_msg_count out nocopy NUMBER
152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 JTF_NUMBER_TABLE
154: , p5_a1 JTF_NUMBER_TABLE
155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_VARCHAR2_TABLE_300
158: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 156: , p5_a3 JTF_NUMBER_TABLE

152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 JTF_NUMBER_TABLE
154: , p5_a1 JTF_NUMBER_TABLE
155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_VARCHAR2_TABLE_300
158: , p5_a5 JTF_VARCHAR2_TABLE_2000
159: , p5_a6 JTF_VARCHAR2_TABLE_100
160: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 164: , p5_a11 JTF_NUMBER_TABLE

160: , p5_a7 JTF_VARCHAR2_TABLE_100
161: , p5_a8 JTF_VARCHAR2_TABLE_100
162: , p5_a9 JTF_VARCHAR2_TABLE_100
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_VARCHAR2_TABLE_100
166: , p5_a13 JTF_VARCHAR2_TABLE_2000
167: , p5_a14 JTF_NUMBER_TABLE
168: , p5_a15 JTF_DATE_TABLE

Line 167: , p5_a14 JTF_NUMBER_TABLE

163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_VARCHAR2_TABLE_100
166: , p5_a13 JTF_VARCHAR2_TABLE_2000
167: , p5_a14 JTF_NUMBER_TABLE
168: , p5_a15 JTF_DATE_TABLE
169: , p5_a16 JTF_NUMBER_TABLE
170: , p5_a17 JTF_DATE_TABLE
171: , p5_a18 JTF_NUMBER_TABLE

Line 169: , p5_a16 JTF_NUMBER_TABLE

165: , p5_a12 JTF_VARCHAR2_TABLE_100
166: , p5_a13 JTF_VARCHAR2_TABLE_2000
167: , p5_a14 JTF_NUMBER_TABLE
168: , p5_a15 JTF_DATE_TABLE
169: , p5_a16 JTF_NUMBER_TABLE
170: , p5_a17 JTF_DATE_TABLE
171: , p5_a18 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 171: , p5_a18 JTF_NUMBER_TABLE

167: , p5_a14 JTF_NUMBER_TABLE
168: , p5_a15 JTF_DATE_TABLE
169: , p5_a16 JTF_NUMBER_TABLE
170: , p5_a17 JTF_DATE_TABLE
171: , p5_a18 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 172: , p6_a0 out nocopy JTF_NUMBER_TABLE

168: , p5_a15 JTF_DATE_TABLE
169: , p5_a16 JTF_NUMBER_TABLE
170: , p5_a17 JTF_DATE_TABLE
171: , p5_a18 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a3 out nocopy JTF_NUMBER_TABLE
176: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 173: , p6_a1 out nocopy JTF_NUMBER_TABLE

169: , p5_a16 JTF_NUMBER_TABLE
170: , p5_a17 JTF_DATE_TABLE
171: , p5_a18 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a3 out nocopy JTF_NUMBER_TABLE
176: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
177: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 175: , p6_a3 out nocopy JTF_NUMBER_TABLE

171: , p5_a18 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a3 out nocopy JTF_NUMBER_TABLE
176: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
177: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
178: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 183: , p6_a11 out nocopy JTF_NUMBER_TABLE

179: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a11 out nocopy JTF_NUMBER_TABLE
184: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
186: , p6_a14 out nocopy JTF_NUMBER_TABLE
187: , p6_a15 out nocopy JTF_DATE_TABLE

Line 186: , p6_a14 out nocopy JTF_NUMBER_TABLE

182: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a11 out nocopy JTF_NUMBER_TABLE
184: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
186: , p6_a14 out nocopy JTF_NUMBER_TABLE
187: , p6_a15 out nocopy JTF_DATE_TABLE
188: , p6_a16 out nocopy JTF_NUMBER_TABLE
189: , p6_a17 out nocopy JTF_DATE_TABLE
190: , p6_a18 out nocopy JTF_NUMBER_TABLE

Line 188: , p6_a16 out nocopy JTF_NUMBER_TABLE

184: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
186: , p6_a14 out nocopy JTF_NUMBER_TABLE
187: , p6_a15 out nocopy JTF_DATE_TABLE
188: , p6_a16 out nocopy JTF_NUMBER_TABLE
189: , p6_a17 out nocopy JTF_DATE_TABLE
190: , p6_a18 out nocopy JTF_NUMBER_TABLE
191: );
192: procedure update_row(p_api_version NUMBER

Line 190: , p6_a18 out nocopy JTF_NUMBER_TABLE

186: , p6_a14 out nocopy JTF_NUMBER_TABLE
187: , p6_a15 out nocopy JTF_DATE_TABLE
188: , p6_a16 out nocopy JTF_NUMBER_TABLE
189: , p6_a17 out nocopy JTF_DATE_TABLE
190: , p6_a18 out nocopy JTF_NUMBER_TABLE
191: );
192: procedure update_row(p_api_version NUMBER
193: , p_init_msg_list VARCHAR2
194: , x_return_status out nocopy VARCHAR2

Line 241: , p5_a0 JTF_NUMBER_TABLE

237: , p_init_msg_list VARCHAR2
238: , x_return_status out nocopy VARCHAR2
239: , x_msg_count out nocopy NUMBER
240: , x_msg_data out nocopy VARCHAR2
241: , p5_a0 JTF_NUMBER_TABLE
242: , p5_a1 JTF_NUMBER_TABLE
243: , p5_a2 JTF_VARCHAR2_TABLE_100
244: , p5_a3 JTF_NUMBER_TABLE
245: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 242: , p5_a1 JTF_NUMBER_TABLE

238: , x_return_status out nocopy VARCHAR2
239: , x_msg_count out nocopy NUMBER
240: , x_msg_data out nocopy VARCHAR2
241: , p5_a0 JTF_NUMBER_TABLE
242: , p5_a1 JTF_NUMBER_TABLE
243: , p5_a2 JTF_VARCHAR2_TABLE_100
244: , p5_a3 JTF_NUMBER_TABLE
245: , p5_a4 JTF_VARCHAR2_TABLE_300
246: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 244: , p5_a3 JTF_NUMBER_TABLE

240: , x_msg_data out nocopy VARCHAR2
241: , p5_a0 JTF_NUMBER_TABLE
242: , p5_a1 JTF_NUMBER_TABLE
243: , p5_a2 JTF_VARCHAR2_TABLE_100
244: , p5_a3 JTF_NUMBER_TABLE
245: , p5_a4 JTF_VARCHAR2_TABLE_300
246: , p5_a5 JTF_VARCHAR2_TABLE_2000
247: , p5_a6 JTF_VARCHAR2_TABLE_100
248: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 252: , p5_a11 JTF_NUMBER_TABLE

248: , p5_a7 JTF_VARCHAR2_TABLE_100
249: , p5_a8 JTF_VARCHAR2_TABLE_100
250: , p5_a9 JTF_VARCHAR2_TABLE_100
251: , p5_a10 JTF_VARCHAR2_TABLE_100
252: , p5_a11 JTF_NUMBER_TABLE
253: , p5_a12 JTF_VARCHAR2_TABLE_100
254: , p5_a13 JTF_VARCHAR2_TABLE_2000
255: , p5_a14 JTF_NUMBER_TABLE
256: , p5_a15 JTF_DATE_TABLE

Line 255: , p5_a14 JTF_NUMBER_TABLE

251: , p5_a10 JTF_VARCHAR2_TABLE_100
252: , p5_a11 JTF_NUMBER_TABLE
253: , p5_a12 JTF_VARCHAR2_TABLE_100
254: , p5_a13 JTF_VARCHAR2_TABLE_2000
255: , p5_a14 JTF_NUMBER_TABLE
256: , p5_a15 JTF_DATE_TABLE
257: , p5_a16 JTF_NUMBER_TABLE
258: , p5_a17 JTF_DATE_TABLE
259: , p5_a18 JTF_NUMBER_TABLE

Line 257: , p5_a16 JTF_NUMBER_TABLE

253: , p5_a12 JTF_VARCHAR2_TABLE_100
254: , p5_a13 JTF_VARCHAR2_TABLE_2000
255: , p5_a14 JTF_NUMBER_TABLE
256: , p5_a15 JTF_DATE_TABLE
257: , p5_a16 JTF_NUMBER_TABLE
258: , p5_a17 JTF_DATE_TABLE
259: , p5_a18 JTF_NUMBER_TABLE
260: , p6_a0 out nocopy JTF_NUMBER_TABLE
261: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 259: , p5_a18 JTF_NUMBER_TABLE

255: , p5_a14 JTF_NUMBER_TABLE
256: , p5_a15 JTF_DATE_TABLE
257: , p5_a16 JTF_NUMBER_TABLE
258: , p5_a17 JTF_DATE_TABLE
259: , p5_a18 JTF_NUMBER_TABLE
260: , p6_a0 out nocopy JTF_NUMBER_TABLE
261: , p6_a1 out nocopy JTF_NUMBER_TABLE
262: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 260: , p6_a0 out nocopy JTF_NUMBER_TABLE

256: , p5_a15 JTF_DATE_TABLE
257: , p5_a16 JTF_NUMBER_TABLE
258: , p5_a17 JTF_DATE_TABLE
259: , p5_a18 JTF_NUMBER_TABLE
260: , p6_a0 out nocopy JTF_NUMBER_TABLE
261: , p6_a1 out nocopy JTF_NUMBER_TABLE
262: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a3 out nocopy JTF_NUMBER_TABLE
264: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 261: , p6_a1 out nocopy JTF_NUMBER_TABLE

257: , p5_a16 JTF_NUMBER_TABLE
258: , p5_a17 JTF_DATE_TABLE
259: , p5_a18 JTF_NUMBER_TABLE
260: , p6_a0 out nocopy JTF_NUMBER_TABLE
261: , p6_a1 out nocopy JTF_NUMBER_TABLE
262: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a3 out nocopy JTF_NUMBER_TABLE
264: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
265: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 263: , p6_a3 out nocopy JTF_NUMBER_TABLE

259: , p5_a18 JTF_NUMBER_TABLE
260: , p6_a0 out nocopy JTF_NUMBER_TABLE
261: , p6_a1 out nocopy JTF_NUMBER_TABLE
262: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a3 out nocopy JTF_NUMBER_TABLE
264: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
265: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
266: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
267: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 271: , p6_a11 out nocopy JTF_NUMBER_TABLE

267: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a11 out nocopy JTF_NUMBER_TABLE
272: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
274: , p6_a14 out nocopy JTF_NUMBER_TABLE
275: , p6_a15 out nocopy JTF_DATE_TABLE

Line 274: , p6_a14 out nocopy JTF_NUMBER_TABLE

270: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a11 out nocopy JTF_NUMBER_TABLE
272: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
274: , p6_a14 out nocopy JTF_NUMBER_TABLE
275: , p6_a15 out nocopy JTF_DATE_TABLE
276: , p6_a16 out nocopy JTF_NUMBER_TABLE
277: , p6_a17 out nocopy JTF_DATE_TABLE
278: , p6_a18 out nocopy JTF_NUMBER_TABLE

Line 276: , p6_a16 out nocopy JTF_NUMBER_TABLE

272: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
274: , p6_a14 out nocopy JTF_NUMBER_TABLE
275: , p6_a15 out nocopy JTF_DATE_TABLE
276: , p6_a16 out nocopy JTF_NUMBER_TABLE
277: , p6_a17 out nocopy JTF_DATE_TABLE
278: , p6_a18 out nocopy JTF_NUMBER_TABLE
279: );
280: procedure delete_row(p_api_version NUMBER

Line 278: , p6_a18 out nocopy JTF_NUMBER_TABLE

274: , p6_a14 out nocopy JTF_NUMBER_TABLE
275: , p6_a15 out nocopy JTF_DATE_TABLE
276: , p6_a16 out nocopy JTF_NUMBER_TABLE
277: , p6_a17 out nocopy JTF_DATE_TABLE
278: , p6_a18 out nocopy JTF_NUMBER_TABLE
279: );
280: procedure delete_row(p_api_version NUMBER
281: , p_init_msg_list VARCHAR2
282: , x_return_status out nocopy VARCHAR2

Line 310: , p5_a0 JTF_NUMBER_TABLE

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

Line 311: , p5_a1 JTF_NUMBER_TABLE

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

Line 313: , p5_a3 JTF_NUMBER_TABLE

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

Line 321: , p5_a11 JTF_NUMBER_TABLE

317: , p5_a7 JTF_VARCHAR2_TABLE_100
318: , p5_a8 JTF_VARCHAR2_TABLE_100
319: , p5_a9 JTF_VARCHAR2_TABLE_100
320: , p5_a10 JTF_VARCHAR2_TABLE_100
321: , p5_a11 JTF_NUMBER_TABLE
322: , p5_a12 JTF_VARCHAR2_TABLE_100
323: , p5_a13 JTF_VARCHAR2_TABLE_2000
324: , p5_a14 JTF_NUMBER_TABLE
325: , p5_a15 JTF_DATE_TABLE

Line 324: , p5_a14 JTF_NUMBER_TABLE

320: , p5_a10 JTF_VARCHAR2_TABLE_100
321: , p5_a11 JTF_NUMBER_TABLE
322: , p5_a12 JTF_VARCHAR2_TABLE_100
323: , p5_a13 JTF_VARCHAR2_TABLE_2000
324: , p5_a14 JTF_NUMBER_TABLE
325: , p5_a15 JTF_DATE_TABLE
326: , p5_a16 JTF_NUMBER_TABLE
327: , p5_a17 JTF_DATE_TABLE
328: , p5_a18 JTF_NUMBER_TABLE

Line 326: , p5_a16 JTF_NUMBER_TABLE

322: , p5_a12 JTF_VARCHAR2_TABLE_100
323: , p5_a13 JTF_VARCHAR2_TABLE_2000
324: , p5_a14 JTF_NUMBER_TABLE
325: , p5_a15 JTF_DATE_TABLE
326: , p5_a16 JTF_NUMBER_TABLE
327: , p5_a17 JTF_DATE_TABLE
328: , p5_a18 JTF_NUMBER_TABLE
329: );
330: end okl_ecc_pvt_w;

Line 328: , p5_a18 JTF_NUMBER_TABLE

324: , p5_a14 JTF_NUMBER_TABLE
325: , p5_a15 JTF_DATE_TABLE
326: , p5_a16 JTF_NUMBER_TABLE
327: , p5_a17 JTF_DATE_TABLE
328: , p5_a18 JTF_NUMBER_TABLE
329: );
330: end okl_ecc_pvt_w;