APPS.OKL_PFC_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pfc_pvt.pfcv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_pfc_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIPFCS.pls 115.1 2002/12/19 23:25:57 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pfc_pvt.pfcv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_pfc_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIPFCS.pls 115.1 2002/12/19 23:25:57 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pfc_pvt.pfcv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200

Line 7: , a4 JTF_NUMBER_TABLE

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

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_VARCHAR2_TABLE_300

Line 12: , a9 JTF_NUMBER_TABLE

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

Line 30: , a27 JTF_NUMBER_TABLE

26: , a23 JTF_VARCHAR2_TABLE_300
27: , a24 JTF_VARCHAR2_TABLE_300
28: , a25 JTF_VARCHAR2_TABLE_300
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE

Line 32: , a29 JTF_NUMBER_TABLE

28: , a25 JTF_VARCHAR2_TABLE_300
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_pfc_pvt.pfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 34: , a31 JTF_NUMBER_TABLE

30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_pfc_pvt.pfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 36: procedure rosetta_table_copy_out_p2(t okl_pfc_pvt.pfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_pfc_pvt.pfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_300
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE

Line 37: , a1 out nocopy JTF_NUMBER_TABLE

33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_pfc_pvt.pfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_300
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 40: , a4 out nocopy JTF_NUMBER_TABLE

36: procedure rosetta_table_copy_out_p2(t okl_pfc_pvt.pfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_300
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_200
42: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE

Line 43: , a7 out nocopy JTF_NUMBER_TABLE

39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_200
42: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_DATE_TABLE
47: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 44: , a8 out nocopy JTF_NUMBER_TABLE

40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_200
42: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_DATE_TABLE
47: , a11 out nocopy JTF_VARCHAR2_TABLE_300
48: , a12 out nocopy JTF_VARCHAR2_TABLE_300

Line 45: , a9 out nocopy JTF_NUMBER_TABLE

41: , a5 out nocopy JTF_VARCHAR2_TABLE_200
42: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_DATE_TABLE
47: , a11 out nocopy JTF_VARCHAR2_TABLE_300
48: , a12 out nocopy JTF_VARCHAR2_TABLE_300
49: , a13 out nocopy JTF_VARCHAR2_TABLE_300

Line 63: , a27 out nocopy JTF_NUMBER_TABLE

59: , a23 out nocopy JTF_VARCHAR2_TABLE_300
60: , a24 out nocopy JTF_VARCHAR2_TABLE_300
61: , a25 out nocopy JTF_VARCHAR2_TABLE_300
62: , a26 out nocopy JTF_VARCHAR2_TABLE_300
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE

Line 65: , a29 out nocopy JTF_NUMBER_TABLE

61: , a25 out nocopy JTF_VARCHAR2_TABLE_300
62: , a26 out nocopy JTF_VARCHAR2_TABLE_300
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:

Line 67: , a31 out nocopy JTF_NUMBER_TABLE

63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfc_pvt.pfc_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100

Line 70: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfc_pvt.pfc_tbl_type, a0 JTF_NUMBER_TABLE

66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfc_pvt.pfc_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE

Line 72: , a2 JTF_NUMBER_TABLE

68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfc_pvt.pfc_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_NUMBER_TABLE

Line 73: , a3 JTF_NUMBER_TABLE

69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfc_pvt.pfc_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_DATE_TABLE

Line 74: , a4 JTF_NUMBER_TABLE

70: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfc_pvt.pfc_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_DATE_TABLE
78: , a8 JTF_VARCHAR2_TABLE_300

Line 75: , a5 JTF_NUMBER_TABLE

71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_DATE_TABLE
78: , a8 JTF_VARCHAR2_TABLE_300
79: , a9 JTF_VARCHAR2_TABLE_300

Line 76: , a6 JTF_NUMBER_TABLE

72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_DATE_TABLE
78: , a8 JTF_VARCHAR2_TABLE_300
79: , a9 JTF_VARCHAR2_TABLE_300
80: , a10 JTF_VARCHAR2_TABLE_300

Line 94: , a24 JTF_NUMBER_TABLE

90: , a20 JTF_VARCHAR2_TABLE_300
91: , a21 JTF_VARCHAR2_TABLE_300
92: , a22 JTF_VARCHAR2_TABLE_300
93: , a23 JTF_VARCHAR2_TABLE_300
94: , a24 JTF_NUMBER_TABLE
95: , a25 JTF_DATE_TABLE
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_DATE_TABLE
98: , a28 JTF_NUMBER_TABLE

Line 96: , a26 JTF_NUMBER_TABLE

92: , a22 JTF_VARCHAR2_TABLE_300
93: , a23 JTF_VARCHAR2_TABLE_300
94: , a24 JTF_NUMBER_TABLE
95: , a25 JTF_DATE_TABLE
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_DATE_TABLE
98: , a28 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 98: , a28 JTF_NUMBER_TABLE

94: , a24 JTF_NUMBER_TABLE
95: , a25 JTF_DATE_TABLE
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_DATE_TABLE
98: , a28 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , a2 out nocopy JTF_NUMBER_TABLE

Line 100: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_DATE_TABLE
98: , a28 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_NUMBER_TABLE

Line 102: , a2 out nocopy JTF_NUMBER_TABLE

98: , a28 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_NUMBER_TABLE
105: , a5 out nocopy JTF_NUMBER_TABLE
106: , a6 out nocopy JTF_NUMBER_TABLE

Line 103: , a3 out nocopy JTF_NUMBER_TABLE

99: );
100: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_NUMBER_TABLE
105: , a5 out nocopy JTF_NUMBER_TABLE
106: , a6 out nocopy JTF_NUMBER_TABLE
107: , a7 out nocopy JTF_DATE_TABLE

Line 104: , a4 out nocopy JTF_NUMBER_TABLE

100: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_NUMBER_TABLE
105: , a5 out nocopy JTF_NUMBER_TABLE
106: , a6 out nocopy JTF_NUMBER_TABLE
107: , a7 out nocopy JTF_DATE_TABLE
108: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 105: , a5 out nocopy JTF_NUMBER_TABLE

101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_NUMBER_TABLE
105: , a5 out nocopy JTF_NUMBER_TABLE
106: , a6 out nocopy JTF_NUMBER_TABLE
107: , a7 out nocopy JTF_DATE_TABLE
108: , a8 out nocopy JTF_VARCHAR2_TABLE_300
109: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 106: , a6 out nocopy JTF_NUMBER_TABLE

102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_NUMBER_TABLE
105: , a5 out nocopy JTF_NUMBER_TABLE
106: , a6 out nocopy JTF_NUMBER_TABLE
107: , a7 out nocopy JTF_DATE_TABLE
108: , a8 out nocopy JTF_VARCHAR2_TABLE_300
109: , a9 out nocopy JTF_VARCHAR2_TABLE_300
110: , a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 124: , a24 out nocopy JTF_NUMBER_TABLE

120: , a20 out nocopy JTF_VARCHAR2_TABLE_300
121: , a21 out nocopy JTF_VARCHAR2_TABLE_300
122: , a22 out nocopy JTF_VARCHAR2_TABLE_300
123: , a23 out nocopy JTF_VARCHAR2_TABLE_300
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE

Line 126: , a26 out nocopy JTF_NUMBER_TABLE

122: , a22 out nocopy JTF_VARCHAR2_TABLE_300
123: , a23 out nocopy JTF_VARCHAR2_TABLE_300
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: );
130:

Line 128: , a28 out nocopy JTF_NUMBER_TABLE

124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: );
130:
131: procedure rosetta_table_copy_in_p8(t out nocopy okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 JTF_NUMBER_TABLE
132: , a1 JTF_VARCHAR2_TABLE_300

Line 131: procedure rosetta_table_copy_in_p8(t out nocopy okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 JTF_NUMBER_TABLE

127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: );
130:
131: procedure rosetta_table_copy_in_p8(t out nocopy okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 JTF_NUMBER_TABLE
132: , a1 JTF_VARCHAR2_TABLE_300
133: , a2 JTF_VARCHAR2_TABLE_300
134: , a3 JTF_VARCHAR2_TABLE_300
135: , a4 JTF_VARCHAR2_TABLE_200

Line 137: , a6 JTF_NUMBER_TABLE

133: , a2 JTF_VARCHAR2_TABLE_300
134: , a3 JTF_VARCHAR2_TABLE_300
135: , a4 JTF_VARCHAR2_TABLE_200
136: , a5 JTF_VARCHAR2_TABLE_2000
137: , a6 JTF_NUMBER_TABLE
138: , a7 JTF_DATE_TABLE
139: , a8 JTF_NUMBER_TABLE
140: , a9 JTF_DATE_TABLE
141: , a10 JTF_NUMBER_TABLE

Line 139: , a8 JTF_NUMBER_TABLE

135: , a4 JTF_VARCHAR2_TABLE_200
136: , a5 JTF_VARCHAR2_TABLE_2000
137: , a6 JTF_NUMBER_TABLE
138: , a7 JTF_DATE_TABLE
139: , a8 JTF_NUMBER_TABLE
140: , a9 JTF_DATE_TABLE
141: , a10 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 141: , a10 JTF_NUMBER_TABLE

137: , a6 JTF_NUMBER_TABLE
138: , a7 JTF_DATE_TABLE
139: , a8 JTF_NUMBER_TABLE
140: , a9 JTF_DATE_TABLE
141: , a10 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_VARCHAR2_TABLE_300
145: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 143: procedure rosetta_table_copy_out_p8(t okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

139: , a8 JTF_NUMBER_TABLE
140: , a9 JTF_DATE_TABLE
141: , a10 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_VARCHAR2_TABLE_300
145: , a2 out nocopy JTF_VARCHAR2_TABLE_300
146: , a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 149: , a6 out nocopy JTF_NUMBER_TABLE

145: , a2 out nocopy JTF_VARCHAR2_TABLE_300
146: , a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , a4 out nocopy JTF_VARCHAR2_TABLE_200
148: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
149: , a6 out nocopy JTF_NUMBER_TABLE
150: , a7 out nocopy JTF_DATE_TABLE
151: , a8 out nocopy JTF_NUMBER_TABLE
152: , a9 out nocopy JTF_DATE_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE

Line 151: , a8 out nocopy JTF_NUMBER_TABLE

147: , a4 out nocopy JTF_VARCHAR2_TABLE_200
148: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
149: , a6 out nocopy JTF_NUMBER_TABLE
150: , a7 out nocopy JTF_DATE_TABLE
151: , a8 out nocopy JTF_NUMBER_TABLE
152: , a9 out nocopy JTF_DATE_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: );
155:

Line 153: , a10 out nocopy JTF_NUMBER_TABLE

149: , a6 out nocopy JTF_NUMBER_TABLE
150: , a7 out nocopy JTF_DATE_TABLE
151: , a8 out nocopy JTF_NUMBER_TABLE
152: , a9 out nocopy JTF_DATE_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: );
155:
156: procedure insert_row(p_api_version NUMBER
157: , p_init_msg_list VARCHAR2

Line 231: , p5_a0 JTF_NUMBER_TABLE

227: , p_init_msg_list VARCHAR2
228: , x_return_status out nocopy VARCHAR2
229: , x_msg_count out nocopy NUMBER
230: , x_msg_data out nocopy VARCHAR2
231: , p5_a0 JTF_NUMBER_TABLE
232: , p5_a1 JTF_NUMBER_TABLE
233: , p5_a2 JTF_VARCHAR2_TABLE_300
234: , p5_a3 JTF_VARCHAR2_TABLE_100
235: , p5_a4 JTF_NUMBER_TABLE

Line 232: , p5_a1 JTF_NUMBER_TABLE

228: , x_return_status out nocopy VARCHAR2
229: , x_msg_count out nocopy NUMBER
230: , x_msg_data out nocopy VARCHAR2
231: , p5_a0 JTF_NUMBER_TABLE
232: , p5_a1 JTF_NUMBER_TABLE
233: , p5_a2 JTF_VARCHAR2_TABLE_300
234: , p5_a3 JTF_VARCHAR2_TABLE_100
235: , p5_a4 JTF_NUMBER_TABLE
236: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 235: , p5_a4 JTF_NUMBER_TABLE

231: , p5_a0 JTF_NUMBER_TABLE
232: , p5_a1 JTF_NUMBER_TABLE
233: , p5_a2 JTF_VARCHAR2_TABLE_300
234: , p5_a3 JTF_VARCHAR2_TABLE_100
235: , p5_a4 JTF_NUMBER_TABLE
236: , p5_a5 JTF_VARCHAR2_TABLE_200
237: , p5_a6 JTF_VARCHAR2_TABLE_2000
238: , p5_a7 JTF_NUMBER_TABLE
239: , p5_a8 JTF_NUMBER_TABLE

Line 238: , p5_a7 JTF_NUMBER_TABLE

234: , p5_a3 JTF_VARCHAR2_TABLE_100
235: , p5_a4 JTF_NUMBER_TABLE
236: , p5_a5 JTF_VARCHAR2_TABLE_200
237: , p5_a6 JTF_VARCHAR2_TABLE_2000
238: , p5_a7 JTF_NUMBER_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_NUMBER_TABLE
241: , p5_a10 JTF_DATE_TABLE
242: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 239: , p5_a8 JTF_NUMBER_TABLE

235: , p5_a4 JTF_NUMBER_TABLE
236: , p5_a5 JTF_VARCHAR2_TABLE_200
237: , p5_a6 JTF_VARCHAR2_TABLE_2000
238: , p5_a7 JTF_NUMBER_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_NUMBER_TABLE
241: , p5_a10 JTF_DATE_TABLE
242: , p5_a11 JTF_VARCHAR2_TABLE_300
243: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 240: , p5_a9 JTF_NUMBER_TABLE

236: , p5_a5 JTF_VARCHAR2_TABLE_200
237: , p5_a6 JTF_VARCHAR2_TABLE_2000
238: , p5_a7 JTF_NUMBER_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_NUMBER_TABLE
241: , p5_a10 JTF_DATE_TABLE
242: , p5_a11 JTF_VARCHAR2_TABLE_300
243: , p5_a12 JTF_VARCHAR2_TABLE_300
244: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 258: , p5_a27 JTF_NUMBER_TABLE

254: , p5_a23 JTF_VARCHAR2_TABLE_300
255: , p5_a24 JTF_VARCHAR2_TABLE_300
256: , p5_a25 JTF_VARCHAR2_TABLE_300
257: , p5_a26 JTF_VARCHAR2_TABLE_300
258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE

Line 260: , p5_a29 JTF_NUMBER_TABLE

256: , p5_a25 JTF_VARCHAR2_TABLE_300
257: , p5_a26 JTF_VARCHAR2_TABLE_300
258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 262: , p5_a31 JTF_NUMBER_TABLE

258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
266: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 263: , p6_a0 out nocopy JTF_NUMBER_TABLE

259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
266: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
267: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 264: , p6_a1 out nocopy JTF_NUMBER_TABLE

260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
266: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 267: , p6_a4 out nocopy JTF_NUMBER_TABLE

263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
266: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
270: , p6_a7 out nocopy JTF_NUMBER_TABLE
271: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 270: , p6_a7 out nocopy JTF_NUMBER_TABLE

266: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
270: , p6_a7 out nocopy JTF_NUMBER_TABLE
271: , p6_a8 out nocopy JTF_NUMBER_TABLE
272: , p6_a9 out nocopy JTF_NUMBER_TABLE
273: , p6_a10 out nocopy JTF_DATE_TABLE
274: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 271: , p6_a8 out nocopy JTF_NUMBER_TABLE

267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
270: , p6_a7 out nocopy JTF_NUMBER_TABLE
271: , p6_a8 out nocopy JTF_NUMBER_TABLE
272: , p6_a9 out nocopy JTF_NUMBER_TABLE
273: , p6_a10 out nocopy JTF_DATE_TABLE
274: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
275: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300

Line 272: , p6_a9 out nocopy JTF_NUMBER_TABLE

268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
270: , p6_a7 out nocopy JTF_NUMBER_TABLE
271: , p6_a8 out nocopy JTF_NUMBER_TABLE
272: , p6_a9 out nocopy JTF_NUMBER_TABLE
273: , p6_a10 out nocopy JTF_DATE_TABLE
274: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
275: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
276: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300

Line 290: , p6_a27 out nocopy JTF_NUMBER_TABLE

286: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
287: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
288: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
289: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
290: , p6_a27 out nocopy JTF_NUMBER_TABLE
291: , p6_a28 out nocopy JTF_DATE_TABLE
292: , p6_a29 out nocopy JTF_NUMBER_TABLE
293: , p6_a30 out nocopy JTF_DATE_TABLE
294: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 292: , p6_a29 out nocopy JTF_NUMBER_TABLE

288: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
289: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
290: , p6_a27 out nocopy JTF_NUMBER_TABLE
291: , p6_a28 out nocopy JTF_DATE_TABLE
292: , p6_a29 out nocopy JTF_NUMBER_TABLE
293: , p6_a30 out nocopy JTF_DATE_TABLE
294: , p6_a31 out nocopy JTF_NUMBER_TABLE
295: );
296: procedure lock_row(p_api_version NUMBER

Line 294: , p6_a31 out nocopy JTF_NUMBER_TABLE

290: , p6_a27 out nocopy JTF_NUMBER_TABLE
291: , p6_a28 out nocopy JTF_DATE_TABLE
292: , p6_a29 out nocopy JTF_NUMBER_TABLE
293: , p6_a30 out nocopy JTF_DATE_TABLE
294: , p6_a31 out nocopy JTF_NUMBER_TABLE
295: );
296: procedure lock_row(p_api_version NUMBER
297: , p_init_msg_list VARCHAR2
298: , x_return_status out nocopy VARCHAR2

Line 339: , p5_a0 JTF_NUMBER_TABLE

335: , p_init_msg_list VARCHAR2
336: , x_return_status out nocopy VARCHAR2
337: , x_msg_count out nocopy NUMBER
338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_NUMBER_TABLE
341: , p5_a2 JTF_VARCHAR2_TABLE_300
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE

Line 340: , p5_a1 JTF_NUMBER_TABLE

336: , x_return_status out nocopy VARCHAR2
337: , x_msg_count out nocopy NUMBER
338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_NUMBER_TABLE
341: , p5_a2 JTF_VARCHAR2_TABLE_300
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 343: , p5_a4 JTF_NUMBER_TABLE

339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_NUMBER_TABLE
341: , p5_a2 JTF_VARCHAR2_TABLE_300
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_VARCHAR2_TABLE_200
345: , p5_a6 JTF_VARCHAR2_TABLE_2000
346: , p5_a7 JTF_NUMBER_TABLE
347: , p5_a8 JTF_NUMBER_TABLE

Line 346: , p5_a7 JTF_NUMBER_TABLE

342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_VARCHAR2_TABLE_200
345: , p5_a6 JTF_VARCHAR2_TABLE_2000
346: , p5_a7 JTF_NUMBER_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_NUMBER_TABLE
349: , p5_a10 JTF_DATE_TABLE
350: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 347: , p5_a8 JTF_NUMBER_TABLE

343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_VARCHAR2_TABLE_200
345: , p5_a6 JTF_VARCHAR2_TABLE_2000
346: , p5_a7 JTF_NUMBER_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_NUMBER_TABLE
349: , p5_a10 JTF_DATE_TABLE
350: , p5_a11 JTF_VARCHAR2_TABLE_300
351: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 348: , p5_a9 JTF_NUMBER_TABLE

344: , p5_a5 JTF_VARCHAR2_TABLE_200
345: , p5_a6 JTF_VARCHAR2_TABLE_2000
346: , p5_a7 JTF_NUMBER_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_NUMBER_TABLE
349: , p5_a10 JTF_DATE_TABLE
350: , p5_a11 JTF_VARCHAR2_TABLE_300
351: , p5_a12 JTF_VARCHAR2_TABLE_300
352: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 366: , p5_a27 JTF_NUMBER_TABLE

362: , p5_a23 JTF_VARCHAR2_TABLE_300
363: , p5_a24 JTF_VARCHAR2_TABLE_300
364: , p5_a25 JTF_VARCHAR2_TABLE_300
365: , p5_a26 JTF_VARCHAR2_TABLE_300
366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_DATE_TABLE
370: , p5_a31 JTF_NUMBER_TABLE

Line 368: , p5_a29 JTF_NUMBER_TABLE

364: , p5_a25 JTF_VARCHAR2_TABLE_300
365: , p5_a26 JTF_VARCHAR2_TABLE_300
366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_DATE_TABLE
370: , p5_a31 JTF_NUMBER_TABLE
371: );
372: procedure update_row(p_api_version NUMBER

Line 370: , p5_a31 JTF_NUMBER_TABLE

366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_DATE_TABLE
370: , p5_a31 JTF_NUMBER_TABLE
371: );
372: procedure update_row(p_api_version NUMBER
373: , p_init_msg_list VARCHAR2
374: , x_return_status out nocopy VARCHAR2

Line 447: , p5_a0 JTF_NUMBER_TABLE

443: , p_init_msg_list VARCHAR2
444: , x_return_status out nocopy VARCHAR2
445: , x_msg_count out nocopy NUMBER
446: , x_msg_data out nocopy VARCHAR2
447: , p5_a0 JTF_NUMBER_TABLE
448: , p5_a1 JTF_NUMBER_TABLE
449: , p5_a2 JTF_VARCHAR2_TABLE_300
450: , p5_a3 JTF_VARCHAR2_TABLE_100
451: , p5_a4 JTF_NUMBER_TABLE

Line 448: , p5_a1 JTF_NUMBER_TABLE

444: , x_return_status out nocopy VARCHAR2
445: , x_msg_count out nocopy NUMBER
446: , x_msg_data out nocopy VARCHAR2
447: , p5_a0 JTF_NUMBER_TABLE
448: , p5_a1 JTF_NUMBER_TABLE
449: , p5_a2 JTF_VARCHAR2_TABLE_300
450: , p5_a3 JTF_VARCHAR2_TABLE_100
451: , p5_a4 JTF_NUMBER_TABLE
452: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 451: , p5_a4 JTF_NUMBER_TABLE

447: , p5_a0 JTF_NUMBER_TABLE
448: , p5_a1 JTF_NUMBER_TABLE
449: , p5_a2 JTF_VARCHAR2_TABLE_300
450: , p5_a3 JTF_VARCHAR2_TABLE_100
451: , p5_a4 JTF_NUMBER_TABLE
452: , p5_a5 JTF_VARCHAR2_TABLE_200
453: , p5_a6 JTF_VARCHAR2_TABLE_2000
454: , p5_a7 JTF_NUMBER_TABLE
455: , p5_a8 JTF_NUMBER_TABLE

Line 454: , p5_a7 JTF_NUMBER_TABLE

450: , p5_a3 JTF_VARCHAR2_TABLE_100
451: , p5_a4 JTF_NUMBER_TABLE
452: , p5_a5 JTF_VARCHAR2_TABLE_200
453: , p5_a6 JTF_VARCHAR2_TABLE_2000
454: , p5_a7 JTF_NUMBER_TABLE
455: , p5_a8 JTF_NUMBER_TABLE
456: , p5_a9 JTF_NUMBER_TABLE
457: , p5_a10 JTF_DATE_TABLE
458: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 455: , p5_a8 JTF_NUMBER_TABLE

451: , p5_a4 JTF_NUMBER_TABLE
452: , p5_a5 JTF_VARCHAR2_TABLE_200
453: , p5_a6 JTF_VARCHAR2_TABLE_2000
454: , p5_a7 JTF_NUMBER_TABLE
455: , p5_a8 JTF_NUMBER_TABLE
456: , p5_a9 JTF_NUMBER_TABLE
457: , p5_a10 JTF_DATE_TABLE
458: , p5_a11 JTF_VARCHAR2_TABLE_300
459: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 456: , p5_a9 JTF_NUMBER_TABLE

452: , p5_a5 JTF_VARCHAR2_TABLE_200
453: , p5_a6 JTF_VARCHAR2_TABLE_2000
454: , p5_a7 JTF_NUMBER_TABLE
455: , p5_a8 JTF_NUMBER_TABLE
456: , p5_a9 JTF_NUMBER_TABLE
457: , p5_a10 JTF_DATE_TABLE
458: , p5_a11 JTF_VARCHAR2_TABLE_300
459: , p5_a12 JTF_VARCHAR2_TABLE_300
460: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 474: , p5_a27 JTF_NUMBER_TABLE

470: , p5_a23 JTF_VARCHAR2_TABLE_300
471: , p5_a24 JTF_VARCHAR2_TABLE_300
472: , p5_a25 JTF_VARCHAR2_TABLE_300
473: , p5_a26 JTF_VARCHAR2_TABLE_300
474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE

Line 476: , p5_a29 JTF_NUMBER_TABLE

472: , p5_a25 JTF_VARCHAR2_TABLE_300
473: , p5_a26 JTF_VARCHAR2_TABLE_300
474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 478: , p5_a31 JTF_NUMBER_TABLE

474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
482: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 479: , p6_a0 out nocopy JTF_NUMBER_TABLE

475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
482: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
483: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 480: , p6_a1 out nocopy JTF_NUMBER_TABLE

476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
482: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
483: , p6_a4 out nocopy JTF_NUMBER_TABLE
484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 483: , p6_a4 out nocopy JTF_NUMBER_TABLE

479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
482: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
483: , p6_a4 out nocopy JTF_NUMBER_TABLE
484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
485: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
486: , p6_a7 out nocopy JTF_NUMBER_TABLE
487: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 486: , p6_a7 out nocopy JTF_NUMBER_TABLE

482: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
483: , p6_a4 out nocopy JTF_NUMBER_TABLE
484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
485: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
486: , p6_a7 out nocopy JTF_NUMBER_TABLE
487: , p6_a8 out nocopy JTF_NUMBER_TABLE
488: , p6_a9 out nocopy JTF_NUMBER_TABLE
489: , p6_a10 out nocopy JTF_DATE_TABLE
490: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 487: , p6_a8 out nocopy JTF_NUMBER_TABLE

483: , p6_a4 out nocopy JTF_NUMBER_TABLE
484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
485: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
486: , p6_a7 out nocopy JTF_NUMBER_TABLE
487: , p6_a8 out nocopy JTF_NUMBER_TABLE
488: , p6_a9 out nocopy JTF_NUMBER_TABLE
489: , p6_a10 out nocopy JTF_DATE_TABLE
490: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
491: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300

Line 488: , p6_a9 out nocopy JTF_NUMBER_TABLE

484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
485: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
486: , p6_a7 out nocopy JTF_NUMBER_TABLE
487: , p6_a8 out nocopy JTF_NUMBER_TABLE
488: , p6_a9 out nocopy JTF_NUMBER_TABLE
489: , p6_a10 out nocopy JTF_DATE_TABLE
490: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
491: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
492: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300

Line 506: , p6_a27 out nocopy JTF_NUMBER_TABLE

502: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
503: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
504: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
505: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
506: , p6_a27 out nocopy JTF_NUMBER_TABLE
507: , p6_a28 out nocopy JTF_DATE_TABLE
508: , p6_a29 out nocopy JTF_NUMBER_TABLE
509: , p6_a30 out nocopy JTF_DATE_TABLE
510: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 508: , p6_a29 out nocopy JTF_NUMBER_TABLE

504: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
505: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
506: , p6_a27 out nocopy JTF_NUMBER_TABLE
507: , p6_a28 out nocopy JTF_DATE_TABLE
508: , p6_a29 out nocopy JTF_NUMBER_TABLE
509: , p6_a30 out nocopy JTF_DATE_TABLE
510: , p6_a31 out nocopy JTF_NUMBER_TABLE
511: );
512: procedure delete_row(p_api_version NUMBER

Line 510: , p6_a31 out nocopy JTF_NUMBER_TABLE

506: , p6_a27 out nocopy JTF_NUMBER_TABLE
507: , p6_a28 out nocopy JTF_DATE_TABLE
508: , p6_a29 out nocopy JTF_NUMBER_TABLE
509: , p6_a30 out nocopy JTF_DATE_TABLE
510: , p6_a31 out nocopy JTF_NUMBER_TABLE
511: );
512: procedure delete_row(p_api_version NUMBER
513: , p_init_msg_list VARCHAR2
514: , x_return_status out nocopy VARCHAR2

Line 555: , p5_a0 JTF_NUMBER_TABLE

551: , p_init_msg_list VARCHAR2
552: , x_return_status out nocopy VARCHAR2
553: , x_msg_count out nocopy NUMBER
554: , x_msg_data out nocopy VARCHAR2
555: , p5_a0 JTF_NUMBER_TABLE
556: , p5_a1 JTF_NUMBER_TABLE
557: , p5_a2 JTF_VARCHAR2_TABLE_300
558: , p5_a3 JTF_VARCHAR2_TABLE_100
559: , p5_a4 JTF_NUMBER_TABLE

Line 556: , p5_a1 JTF_NUMBER_TABLE

552: , x_return_status out nocopy VARCHAR2
553: , x_msg_count out nocopy NUMBER
554: , x_msg_data out nocopy VARCHAR2
555: , p5_a0 JTF_NUMBER_TABLE
556: , p5_a1 JTF_NUMBER_TABLE
557: , p5_a2 JTF_VARCHAR2_TABLE_300
558: , p5_a3 JTF_VARCHAR2_TABLE_100
559: , p5_a4 JTF_NUMBER_TABLE
560: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 559: , p5_a4 JTF_NUMBER_TABLE

555: , p5_a0 JTF_NUMBER_TABLE
556: , p5_a1 JTF_NUMBER_TABLE
557: , p5_a2 JTF_VARCHAR2_TABLE_300
558: , p5_a3 JTF_VARCHAR2_TABLE_100
559: , p5_a4 JTF_NUMBER_TABLE
560: , p5_a5 JTF_VARCHAR2_TABLE_200
561: , p5_a6 JTF_VARCHAR2_TABLE_2000
562: , p5_a7 JTF_NUMBER_TABLE
563: , p5_a8 JTF_NUMBER_TABLE

Line 562: , p5_a7 JTF_NUMBER_TABLE

558: , p5_a3 JTF_VARCHAR2_TABLE_100
559: , p5_a4 JTF_NUMBER_TABLE
560: , p5_a5 JTF_VARCHAR2_TABLE_200
561: , p5_a6 JTF_VARCHAR2_TABLE_2000
562: , p5_a7 JTF_NUMBER_TABLE
563: , p5_a8 JTF_NUMBER_TABLE
564: , p5_a9 JTF_NUMBER_TABLE
565: , p5_a10 JTF_DATE_TABLE
566: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 563: , p5_a8 JTF_NUMBER_TABLE

559: , p5_a4 JTF_NUMBER_TABLE
560: , p5_a5 JTF_VARCHAR2_TABLE_200
561: , p5_a6 JTF_VARCHAR2_TABLE_2000
562: , p5_a7 JTF_NUMBER_TABLE
563: , p5_a8 JTF_NUMBER_TABLE
564: , p5_a9 JTF_NUMBER_TABLE
565: , p5_a10 JTF_DATE_TABLE
566: , p5_a11 JTF_VARCHAR2_TABLE_300
567: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 564: , p5_a9 JTF_NUMBER_TABLE

560: , p5_a5 JTF_VARCHAR2_TABLE_200
561: , p5_a6 JTF_VARCHAR2_TABLE_2000
562: , p5_a7 JTF_NUMBER_TABLE
563: , p5_a8 JTF_NUMBER_TABLE
564: , p5_a9 JTF_NUMBER_TABLE
565: , p5_a10 JTF_DATE_TABLE
566: , p5_a11 JTF_VARCHAR2_TABLE_300
567: , p5_a12 JTF_VARCHAR2_TABLE_300
568: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 582: , p5_a27 JTF_NUMBER_TABLE

578: , p5_a23 JTF_VARCHAR2_TABLE_300
579: , p5_a24 JTF_VARCHAR2_TABLE_300
580: , p5_a25 JTF_VARCHAR2_TABLE_300
581: , p5_a26 JTF_VARCHAR2_TABLE_300
582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_DATE_TABLE
586: , p5_a31 JTF_NUMBER_TABLE

Line 584: , p5_a29 JTF_NUMBER_TABLE

580: , p5_a25 JTF_VARCHAR2_TABLE_300
581: , p5_a26 JTF_VARCHAR2_TABLE_300
582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_DATE_TABLE
586: , p5_a31 JTF_NUMBER_TABLE
587: );
588: procedure validate_row(p_api_version NUMBER

Line 586: , p5_a31 JTF_NUMBER_TABLE

582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_DATE_TABLE
586: , p5_a31 JTF_NUMBER_TABLE
587: );
588: procedure validate_row(p_api_version NUMBER
589: , p_init_msg_list VARCHAR2
590: , x_return_status out nocopy VARCHAR2

Line 631: , p5_a0 JTF_NUMBER_TABLE

627: , p_init_msg_list VARCHAR2
628: , x_return_status out nocopy VARCHAR2
629: , x_msg_count out nocopy NUMBER
630: , x_msg_data out nocopy VARCHAR2
631: , p5_a0 JTF_NUMBER_TABLE
632: , p5_a1 JTF_NUMBER_TABLE
633: , p5_a2 JTF_VARCHAR2_TABLE_300
634: , p5_a3 JTF_VARCHAR2_TABLE_100
635: , p5_a4 JTF_NUMBER_TABLE

Line 632: , p5_a1 JTF_NUMBER_TABLE

628: , x_return_status out nocopy VARCHAR2
629: , x_msg_count out nocopy NUMBER
630: , x_msg_data out nocopy VARCHAR2
631: , p5_a0 JTF_NUMBER_TABLE
632: , p5_a1 JTF_NUMBER_TABLE
633: , p5_a2 JTF_VARCHAR2_TABLE_300
634: , p5_a3 JTF_VARCHAR2_TABLE_100
635: , p5_a4 JTF_NUMBER_TABLE
636: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 635: , p5_a4 JTF_NUMBER_TABLE

631: , p5_a0 JTF_NUMBER_TABLE
632: , p5_a1 JTF_NUMBER_TABLE
633: , p5_a2 JTF_VARCHAR2_TABLE_300
634: , p5_a3 JTF_VARCHAR2_TABLE_100
635: , p5_a4 JTF_NUMBER_TABLE
636: , p5_a5 JTF_VARCHAR2_TABLE_200
637: , p5_a6 JTF_VARCHAR2_TABLE_2000
638: , p5_a7 JTF_NUMBER_TABLE
639: , p5_a8 JTF_NUMBER_TABLE

Line 638: , p5_a7 JTF_NUMBER_TABLE

634: , p5_a3 JTF_VARCHAR2_TABLE_100
635: , p5_a4 JTF_NUMBER_TABLE
636: , p5_a5 JTF_VARCHAR2_TABLE_200
637: , p5_a6 JTF_VARCHAR2_TABLE_2000
638: , p5_a7 JTF_NUMBER_TABLE
639: , p5_a8 JTF_NUMBER_TABLE
640: , p5_a9 JTF_NUMBER_TABLE
641: , p5_a10 JTF_DATE_TABLE
642: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 639: , p5_a8 JTF_NUMBER_TABLE

635: , p5_a4 JTF_NUMBER_TABLE
636: , p5_a5 JTF_VARCHAR2_TABLE_200
637: , p5_a6 JTF_VARCHAR2_TABLE_2000
638: , p5_a7 JTF_NUMBER_TABLE
639: , p5_a8 JTF_NUMBER_TABLE
640: , p5_a9 JTF_NUMBER_TABLE
641: , p5_a10 JTF_DATE_TABLE
642: , p5_a11 JTF_VARCHAR2_TABLE_300
643: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 640: , p5_a9 JTF_NUMBER_TABLE

636: , p5_a5 JTF_VARCHAR2_TABLE_200
637: , p5_a6 JTF_VARCHAR2_TABLE_2000
638: , p5_a7 JTF_NUMBER_TABLE
639: , p5_a8 JTF_NUMBER_TABLE
640: , p5_a9 JTF_NUMBER_TABLE
641: , p5_a10 JTF_DATE_TABLE
642: , p5_a11 JTF_VARCHAR2_TABLE_300
643: , p5_a12 JTF_VARCHAR2_TABLE_300
644: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 658: , p5_a27 JTF_NUMBER_TABLE

654: , p5_a23 JTF_VARCHAR2_TABLE_300
655: , p5_a24 JTF_VARCHAR2_TABLE_300
656: , p5_a25 JTF_VARCHAR2_TABLE_300
657: , p5_a26 JTF_VARCHAR2_TABLE_300
658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_DATE_TABLE
662: , p5_a31 JTF_NUMBER_TABLE

Line 660: , p5_a29 JTF_NUMBER_TABLE

656: , p5_a25 JTF_VARCHAR2_TABLE_300
657: , p5_a26 JTF_VARCHAR2_TABLE_300
658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_DATE_TABLE
662: , p5_a31 JTF_NUMBER_TABLE
663: );
664: end okl_pfc_pvt_w;

Line 662: , p5_a31 JTF_NUMBER_TABLE

658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_DATE_TABLE
662: , p5_a31 JTF_NUMBER_TABLE
663: );
664: end okl_pfc_pvt_w;