DBA Data[Home] [Help]

APPS.OKL_IPT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_ipt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIIPTS.pls 115.6 2003/01/28 01:49:45 smoduga noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_ipt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIIPTS.pls 115.6 2003/01/28 01:49:45 smoduga noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_ipt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIIPTS.pls 115.6 2003/01/28 01:49:45 smoduga noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
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_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

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

Line 12: , a9 JTF_NUMBER_TABLE

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

Line 13: , a10 JTF_NUMBER_TABLE

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

Line 14: , a11 JTF_NUMBER_TABLE

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

Line 15: , a12 JTF_NUMBER_TABLE

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

Line 35: , a32 JTF_NUMBER_TABLE

31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE

Line 37: , a34 JTF_NUMBER_TABLE

33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 39: , a36 JTF_NUMBER_TABLE

35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE

Line 41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE

Line 42: , a1 out nocopy JTF_NUMBER_TABLE

38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 43: , a2 out nocopy JTF_NUMBER_TABLE

39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 45: , a4 out nocopy JTF_NUMBER_TABLE

41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE

Line 48: , a7 out nocopy JTF_NUMBER_TABLE

44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE

Line 49: , a8 out nocopy JTF_NUMBER_TABLE

45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE

Line 50: , a9 out nocopy JTF_NUMBER_TABLE

46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_DATE_TABLE

Line 51: , a10 out nocopy JTF_NUMBER_TABLE

47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_DATE_TABLE
55: , a14 out nocopy JTF_DATE_TABLE

Line 52: , a11 out nocopy JTF_NUMBER_TABLE

48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_DATE_TABLE
55: , a14 out nocopy JTF_DATE_TABLE
56: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a12 out nocopy JTF_NUMBER_TABLE

49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_DATE_TABLE
55: , a14 out nocopy JTF_DATE_TABLE
56: , a15 out nocopy JTF_VARCHAR2_TABLE_100
57: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 73: , a32 out nocopy JTF_NUMBER_TABLE

69: , a28 out nocopy JTF_VARCHAR2_TABLE_500
70: , a29 out nocopy JTF_VARCHAR2_TABLE_500
71: , a30 out nocopy JTF_VARCHAR2_TABLE_500
72: , a31 out nocopy JTF_VARCHAR2_TABLE_500
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE

Line 75: , a34 out nocopy JTF_NUMBER_TABLE

71: , a30 out nocopy JTF_VARCHAR2_TABLE_500
72: , a31 out nocopy JTF_VARCHAR2_TABLE_500
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:

Line 77: , a36 out nocopy JTF_NUMBER_TABLE

73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_VARCHAR2_TABLE_100

Line 80: procedure rosetta_table_copy_in_p5(t out nocopy okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 JTF_NUMBER_TABLE

76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_VARCHAR2_TABLE_100
82: , a2 JTF_VARCHAR2_TABLE_100
83: , a3 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_VARCHAR2_TABLE_300

Line 86: , a6 JTF_NUMBER_TABLE

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

Line 88: , a8 JTF_NUMBER_TABLE

84: , a4 JTF_VARCHAR2_TABLE_300
85: , a5 JTF_VARCHAR2_TABLE_100
86: , a6 JTF_NUMBER_TABLE
87: , a7 JTF_DATE_TABLE
88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_DATE_TABLE
90: , a10 JTF_NUMBER_TABLE
91: );
92: procedure rosetta_table_copy_out_p5(t okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 90: , a10 JTF_NUMBER_TABLE

86: , a6 JTF_NUMBER_TABLE
87: , a7 JTF_DATE_TABLE
88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_DATE_TABLE
90: , a10 JTF_NUMBER_TABLE
91: );
92: procedure rosetta_table_copy_out_p5(t okl_ipt_pvt.okl_ins_products_tl_tbl_type, 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_ipt_pvt.okl_ins_products_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_DATE_TABLE
90: , a10 JTF_NUMBER_TABLE
91: );
92: procedure rosetta_table_copy_out_p5(t okl_ipt_pvt.okl_ins_products_tl_tbl_type, 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_300

Line 98: , a6 out nocopy JTF_NUMBER_TABLE

94: , a2 out nocopy JTF_VARCHAR2_TABLE_100
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_300
97: , a5 out nocopy JTF_VARCHAR2_TABLE_100
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_DATE_TABLE
102: , a10 out nocopy JTF_NUMBER_TABLE

Line 100: , a8 out nocopy JTF_NUMBER_TABLE

96: , a4 out nocopy JTF_VARCHAR2_TABLE_300
97: , a5 out nocopy JTF_VARCHAR2_TABLE_100
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_DATE_TABLE
102: , a10 out nocopy JTF_NUMBER_TABLE
103: );
104:

Line 102: , a10 out nocopy JTF_NUMBER_TABLE

98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_DATE_TABLE
102: , a10 out nocopy JTF_NUMBER_TABLE
103: );
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE

Line 105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE

101: , a9 out nocopy JTF_DATE_TABLE
102: , a10 out nocopy JTF_NUMBER_TABLE
103: );
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_100
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_NUMBER_TABLE

Line 106: , a1 JTF_NUMBER_TABLE

102: , a10 out nocopy JTF_NUMBER_TABLE
103: );
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_100
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_NUMBER_TABLE
110: , a5 JTF_VARCHAR2_TABLE_100

Line 108: , a3 JTF_NUMBER_TABLE

104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_100
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_NUMBER_TABLE
110: , a5 JTF_VARCHAR2_TABLE_100
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_300

Line 109: , a4 JTF_NUMBER_TABLE

105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_100
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_NUMBER_TABLE
110: , a5 JTF_VARCHAR2_TABLE_100
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_300
113: , a8 JTF_NUMBER_TABLE

Line 113: , a8 JTF_NUMBER_TABLE

109: , a4 JTF_NUMBER_TABLE
110: , a5 JTF_VARCHAR2_TABLE_100
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_300
113: , a8 JTF_NUMBER_TABLE
114: , a9 JTF_DATE_TABLE
115: , a10 JTF_NUMBER_TABLE
116: , a11 JTF_DATE_TABLE
117: , a12 JTF_VARCHAR2_TABLE_100

Line 115: , a10 JTF_NUMBER_TABLE

111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_300
113: , a8 JTF_NUMBER_TABLE
114: , a9 JTF_DATE_TABLE
115: , a10 JTF_NUMBER_TABLE
116: , a11 JTF_DATE_TABLE
117: , a12 JTF_VARCHAR2_TABLE_100
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE

Line 119: , a14 JTF_NUMBER_TABLE

115: , a10 JTF_NUMBER_TABLE
116: , a11 JTF_DATE_TABLE
117: , a12 JTF_VARCHAR2_TABLE_100
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE
120: , a15 JTF_NUMBER_TABLE
121: , a16 JTF_NUMBER_TABLE
122: , a17 JTF_NUMBER_TABLE
123: , a18 JTF_VARCHAR2_TABLE_100

Line 120: , a15 JTF_NUMBER_TABLE

116: , a11 JTF_DATE_TABLE
117: , a12 JTF_VARCHAR2_TABLE_100
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE
120: , a15 JTF_NUMBER_TABLE
121: , a16 JTF_NUMBER_TABLE
122: , a17 JTF_NUMBER_TABLE
123: , a18 JTF_VARCHAR2_TABLE_100
124: , a19 JTF_VARCHAR2_TABLE_100

Line 121: , a16 JTF_NUMBER_TABLE

117: , a12 JTF_VARCHAR2_TABLE_100
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE
120: , a15 JTF_NUMBER_TABLE
121: , a16 JTF_NUMBER_TABLE
122: , a17 JTF_NUMBER_TABLE
123: , a18 JTF_VARCHAR2_TABLE_100
124: , a19 JTF_VARCHAR2_TABLE_100
125: , a20 JTF_VARCHAR2_TABLE_500

Line 122: , a17 JTF_NUMBER_TABLE

118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE
120: , a15 JTF_NUMBER_TABLE
121: , a16 JTF_NUMBER_TABLE
122: , a17 JTF_NUMBER_TABLE
123: , a18 JTF_VARCHAR2_TABLE_100
124: , a19 JTF_VARCHAR2_TABLE_100
125: , a20 JTF_VARCHAR2_TABLE_500
126: , a21 JTF_VARCHAR2_TABLE_500

Line 140: , a35 JTF_NUMBER_TABLE

136: , a31 JTF_VARCHAR2_TABLE_500
137: , a32 JTF_VARCHAR2_TABLE_500
138: , a33 JTF_VARCHAR2_TABLE_500
139: , a34 JTF_VARCHAR2_TABLE_500
140: , a35 JTF_NUMBER_TABLE
141: , a36 JTF_DATE_TABLE
142: , a37 JTF_NUMBER_TABLE
143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE

Line 142: , a37 JTF_NUMBER_TABLE

138: , a33 JTF_VARCHAR2_TABLE_500
139: , a34 JTF_VARCHAR2_TABLE_500
140: , a35 JTF_NUMBER_TABLE
141: , a36 JTF_DATE_TABLE
142: , a37 JTF_NUMBER_TABLE
143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 144: , a39 JTF_NUMBER_TABLE

140: , a35 JTF_NUMBER_TABLE
141: , a36 JTF_DATE_TABLE
142: , a37 JTF_NUMBER_TABLE
143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

142: , a37 JTF_NUMBER_TABLE
143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_NUMBER_TABLE

Line 147: , a1 out nocopy JTF_NUMBER_TABLE

143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_NUMBER_TABLE
151: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 149: , a3 out nocopy JTF_NUMBER_TABLE

145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_NUMBER_TABLE
151: , a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 150: , a4 out nocopy JTF_NUMBER_TABLE

146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_NUMBER_TABLE
151: , a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , a7 out nocopy JTF_VARCHAR2_TABLE_300
154: , a8 out nocopy JTF_NUMBER_TABLE

Line 154: , a8 out nocopy JTF_NUMBER_TABLE

150: , a4 out nocopy JTF_NUMBER_TABLE
151: , a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , a7 out nocopy JTF_VARCHAR2_TABLE_300
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_DATE_TABLE
158: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , a10 out nocopy JTF_NUMBER_TABLE

152: , a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , a7 out nocopy JTF_VARCHAR2_TABLE_300
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_DATE_TABLE
158: , a12 out nocopy JTF_VARCHAR2_TABLE_100
159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE

Line 160: , a14 out nocopy JTF_NUMBER_TABLE

156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_DATE_TABLE
158: , a12 out nocopy JTF_VARCHAR2_TABLE_100
159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_NUMBER_TABLE
163: , a17 out nocopy JTF_NUMBER_TABLE
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: , a15 out nocopy JTF_NUMBER_TABLE

157: , a11 out nocopy JTF_DATE_TABLE
158: , a12 out nocopy JTF_VARCHAR2_TABLE_100
159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_NUMBER_TABLE
163: , a17 out nocopy JTF_NUMBER_TABLE
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 162: , a16 out nocopy JTF_NUMBER_TABLE

158: , a12 out nocopy JTF_VARCHAR2_TABLE_100
159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_NUMBER_TABLE
163: , a17 out nocopy JTF_NUMBER_TABLE
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , a19 out nocopy JTF_VARCHAR2_TABLE_100
166: , a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 163: , a17 out nocopy JTF_NUMBER_TABLE

159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_NUMBER_TABLE
163: , a17 out nocopy JTF_NUMBER_TABLE
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , a19 out nocopy JTF_VARCHAR2_TABLE_100
166: , a20 out nocopy JTF_VARCHAR2_TABLE_500
167: , a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 181: , a35 out nocopy JTF_NUMBER_TABLE

177: , a31 out nocopy JTF_VARCHAR2_TABLE_500
178: , a32 out nocopy JTF_VARCHAR2_TABLE_500
179: , a33 out nocopy JTF_VARCHAR2_TABLE_500
180: , a34 out nocopy JTF_VARCHAR2_TABLE_500
181: , a35 out nocopy JTF_NUMBER_TABLE
182: , a36 out nocopy JTF_DATE_TABLE
183: , a37 out nocopy JTF_NUMBER_TABLE
184: , a38 out nocopy JTF_DATE_TABLE
185: , a39 out nocopy JTF_NUMBER_TABLE

Line 183: , a37 out nocopy JTF_NUMBER_TABLE

179: , a33 out nocopy JTF_VARCHAR2_TABLE_500
180: , a34 out nocopy JTF_VARCHAR2_TABLE_500
181: , a35 out nocopy JTF_NUMBER_TABLE
182: , a36 out nocopy JTF_DATE_TABLE
183: , a37 out nocopy JTF_NUMBER_TABLE
184: , a38 out nocopy JTF_DATE_TABLE
185: , a39 out nocopy JTF_NUMBER_TABLE
186: );
187:

Line 185: , a39 out nocopy JTF_NUMBER_TABLE

181: , a35 out nocopy JTF_NUMBER_TABLE
182: , a36 out nocopy JTF_DATE_TABLE
183: , a37 out nocopy JTF_NUMBER_TABLE
184: , a38 out nocopy JTF_DATE_TABLE
185: , a39 out nocopy JTF_NUMBER_TABLE
186: );
187:
188: procedure insert_row(p_api_version NUMBER
189: , p_init_msg_list VARCHAR2

Line 279: , p5_a0 JTF_NUMBER_TABLE

275: , p_init_msg_list VARCHAR2
276: , x_return_status out nocopy VARCHAR2
277: , x_msg_count out nocopy NUMBER
278: , x_msg_data out nocopy VARCHAR2
279: , p5_a0 JTF_NUMBER_TABLE
280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE

Line 280: , p5_a1 JTF_NUMBER_TABLE

276: , x_return_status out nocopy VARCHAR2
277: , x_msg_count out nocopy NUMBER
278: , x_msg_data out nocopy VARCHAR2
279: , p5_a0 JTF_NUMBER_TABLE
280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 282: , p5_a3 JTF_NUMBER_TABLE

278: , x_msg_data out nocopy VARCHAR2
279: , p5_a0 JTF_NUMBER_TABLE
280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_100
285: , p5_a6 JTF_VARCHAR2_TABLE_100
286: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 283: , p5_a4 JTF_NUMBER_TABLE

279: , p5_a0 JTF_NUMBER_TABLE
280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_100
285: , p5_a6 JTF_VARCHAR2_TABLE_100
286: , p5_a7 JTF_VARCHAR2_TABLE_300
287: , p5_a8 JTF_NUMBER_TABLE

Line 287: , p5_a8 JTF_NUMBER_TABLE

283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_100
285: , p5_a6 JTF_VARCHAR2_TABLE_100
286: , p5_a7 JTF_VARCHAR2_TABLE_300
287: , p5_a8 JTF_NUMBER_TABLE
288: , p5_a9 JTF_DATE_TABLE
289: , p5_a10 JTF_NUMBER_TABLE
290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 289: , p5_a10 JTF_NUMBER_TABLE

285: , p5_a6 JTF_VARCHAR2_TABLE_100
286: , p5_a7 JTF_VARCHAR2_TABLE_300
287: , p5_a8 JTF_NUMBER_TABLE
288: , p5_a9 JTF_DATE_TABLE
289: , p5_a10 JTF_NUMBER_TABLE
290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_VARCHAR2_TABLE_100
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE

Line 293: , p5_a14 JTF_NUMBER_TABLE

289: , p5_a10 JTF_NUMBER_TABLE
290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_VARCHAR2_TABLE_100
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE
294: , p5_a15 JTF_NUMBER_TABLE
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_NUMBER_TABLE
297: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 294: , p5_a15 JTF_NUMBER_TABLE

290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_VARCHAR2_TABLE_100
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE
294: , p5_a15 JTF_NUMBER_TABLE
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_NUMBER_TABLE
297: , p5_a18 JTF_VARCHAR2_TABLE_100
298: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 295: , p5_a16 JTF_NUMBER_TABLE

291: , p5_a12 JTF_VARCHAR2_TABLE_100
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE
294: , p5_a15 JTF_NUMBER_TABLE
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_NUMBER_TABLE
297: , p5_a18 JTF_VARCHAR2_TABLE_100
298: , p5_a19 JTF_VARCHAR2_TABLE_100
299: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 296: , p5_a17 JTF_NUMBER_TABLE

292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE
294: , p5_a15 JTF_NUMBER_TABLE
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_NUMBER_TABLE
297: , p5_a18 JTF_VARCHAR2_TABLE_100
298: , p5_a19 JTF_VARCHAR2_TABLE_100
299: , p5_a20 JTF_VARCHAR2_TABLE_500
300: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 314: , p5_a35 JTF_NUMBER_TABLE

310: , p5_a31 JTF_VARCHAR2_TABLE_500
311: , p5_a32 JTF_VARCHAR2_TABLE_500
312: , p5_a33 JTF_VARCHAR2_TABLE_500
313: , p5_a34 JTF_VARCHAR2_TABLE_500
314: , p5_a35 JTF_NUMBER_TABLE
315: , p5_a36 JTF_DATE_TABLE
316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE

Line 316: , p5_a37 JTF_NUMBER_TABLE

312: , p5_a33 JTF_VARCHAR2_TABLE_500
313: , p5_a34 JTF_VARCHAR2_TABLE_500
314: , p5_a35 JTF_NUMBER_TABLE
315: , p5_a36 JTF_DATE_TABLE
316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 318: , p5_a39 JTF_NUMBER_TABLE

314: , p5_a35 JTF_NUMBER_TABLE
315: , p5_a36 JTF_DATE_TABLE
316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 319: , p6_a0 out nocopy JTF_NUMBER_TABLE

315: , p5_a36 JTF_DATE_TABLE
316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 320: , p6_a1 out nocopy JTF_NUMBER_TABLE

316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 322: , p6_a3 out nocopy JTF_NUMBER_TABLE

318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 323: , p6_a4 out nocopy JTF_NUMBER_TABLE

319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
327: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 327: , p6_a8 out nocopy JTF_NUMBER_TABLE

323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
327: , p6_a8 out nocopy JTF_NUMBER_TABLE
328: , p6_a9 out nocopy JTF_DATE_TABLE
329: , p6_a10 out nocopy JTF_NUMBER_TABLE
330: , p6_a11 out nocopy JTF_DATE_TABLE
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 329: , p6_a10 out nocopy JTF_NUMBER_TABLE

325: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
327: , p6_a8 out nocopy JTF_NUMBER_TABLE
328: , p6_a9 out nocopy JTF_DATE_TABLE
329: , p6_a10 out nocopy JTF_NUMBER_TABLE
330: , p6_a11 out nocopy JTF_DATE_TABLE
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 333: , p6_a14 out nocopy JTF_NUMBER_TABLE

329: , p6_a10 out nocopy JTF_NUMBER_TABLE
330: , p6_a11 out nocopy JTF_DATE_TABLE
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE
334: , p6_a15 out nocopy JTF_NUMBER_TABLE
335: , p6_a16 out nocopy JTF_NUMBER_TABLE
336: , p6_a17 out nocopy JTF_NUMBER_TABLE
337: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 334: , p6_a15 out nocopy JTF_NUMBER_TABLE

330: , p6_a11 out nocopy JTF_DATE_TABLE
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE
334: , p6_a15 out nocopy JTF_NUMBER_TABLE
335: , p6_a16 out nocopy JTF_NUMBER_TABLE
336: , p6_a17 out nocopy JTF_NUMBER_TABLE
337: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 335: , p6_a16 out nocopy JTF_NUMBER_TABLE

331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE
334: , p6_a15 out nocopy JTF_NUMBER_TABLE
335: , p6_a16 out nocopy JTF_NUMBER_TABLE
336: , p6_a17 out nocopy JTF_NUMBER_TABLE
337: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 336: , p6_a17 out nocopy JTF_NUMBER_TABLE

332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE
334: , p6_a15 out nocopy JTF_NUMBER_TABLE
335: , p6_a16 out nocopy JTF_NUMBER_TABLE
336: , p6_a17 out nocopy JTF_NUMBER_TABLE
337: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
340: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 354: , p6_a35 out nocopy JTF_NUMBER_TABLE

350: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
351: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
352: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
353: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
354: , p6_a35 out nocopy JTF_NUMBER_TABLE
355: , p6_a36 out nocopy JTF_DATE_TABLE
356: , p6_a37 out nocopy JTF_NUMBER_TABLE
357: , p6_a38 out nocopy JTF_DATE_TABLE
358: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 356: , p6_a37 out nocopy JTF_NUMBER_TABLE

352: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
353: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
354: , p6_a35 out nocopy JTF_NUMBER_TABLE
355: , p6_a36 out nocopy JTF_DATE_TABLE
356: , p6_a37 out nocopy JTF_NUMBER_TABLE
357: , p6_a38 out nocopy JTF_DATE_TABLE
358: , p6_a39 out nocopy JTF_NUMBER_TABLE
359: );
360: procedure lock_row(p_api_version NUMBER

Line 358: , p6_a39 out nocopy JTF_NUMBER_TABLE

354: , p6_a35 out nocopy JTF_NUMBER_TABLE
355: , p6_a36 out nocopy JTF_DATE_TABLE
356: , p6_a37 out nocopy JTF_NUMBER_TABLE
357: , p6_a38 out nocopy JTF_DATE_TABLE
358: , p6_a39 out nocopy JTF_NUMBER_TABLE
359: );
360: procedure lock_row(p_api_version NUMBER
361: , p_init_msg_list VARCHAR2
362: , 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_NUMBER_TABLE

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_NUMBER_TABLE
416: , p5_a5 JTF_VARCHAR2_TABLE_100

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_NUMBER_TABLE
416: , p5_a5 JTF_VARCHAR2_TABLE_100
417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 415: , p5_a4 JTF_NUMBER_TABLE

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_NUMBER_TABLE
416: , p5_a5 JTF_VARCHAR2_TABLE_100
417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_300
419: , p5_a8 JTF_NUMBER_TABLE

Line 419: , p5_a8 JTF_NUMBER_TABLE

415: , p5_a4 JTF_NUMBER_TABLE
416: , p5_a5 JTF_VARCHAR2_TABLE_100
417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_300
419: , p5_a8 JTF_NUMBER_TABLE
420: , p5_a9 JTF_DATE_TABLE
421: , p5_a10 JTF_NUMBER_TABLE
422: , p5_a11 JTF_DATE_TABLE
423: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 421: , p5_a10 JTF_NUMBER_TABLE

417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_300
419: , p5_a8 JTF_NUMBER_TABLE
420: , p5_a9 JTF_DATE_TABLE
421: , p5_a10 JTF_NUMBER_TABLE
422: , p5_a11 JTF_DATE_TABLE
423: , p5_a12 JTF_VARCHAR2_TABLE_100
424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE

Line 425: , p5_a14 JTF_NUMBER_TABLE

421: , p5_a10 JTF_NUMBER_TABLE
422: , p5_a11 JTF_DATE_TABLE
423: , p5_a12 JTF_VARCHAR2_TABLE_100
424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE
426: , p5_a15 JTF_NUMBER_TABLE
427: , p5_a16 JTF_NUMBER_TABLE
428: , p5_a17 JTF_NUMBER_TABLE
429: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 426: , p5_a15 JTF_NUMBER_TABLE

422: , p5_a11 JTF_DATE_TABLE
423: , p5_a12 JTF_VARCHAR2_TABLE_100
424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE
426: , p5_a15 JTF_NUMBER_TABLE
427: , p5_a16 JTF_NUMBER_TABLE
428: , p5_a17 JTF_NUMBER_TABLE
429: , p5_a18 JTF_VARCHAR2_TABLE_100
430: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 427: , p5_a16 JTF_NUMBER_TABLE

423: , p5_a12 JTF_VARCHAR2_TABLE_100
424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE
426: , p5_a15 JTF_NUMBER_TABLE
427: , p5_a16 JTF_NUMBER_TABLE
428: , p5_a17 JTF_NUMBER_TABLE
429: , p5_a18 JTF_VARCHAR2_TABLE_100
430: , p5_a19 JTF_VARCHAR2_TABLE_100
431: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 428: , p5_a17 JTF_NUMBER_TABLE

424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE
426: , p5_a15 JTF_NUMBER_TABLE
427: , p5_a16 JTF_NUMBER_TABLE
428: , p5_a17 JTF_NUMBER_TABLE
429: , p5_a18 JTF_VARCHAR2_TABLE_100
430: , p5_a19 JTF_VARCHAR2_TABLE_100
431: , p5_a20 JTF_VARCHAR2_TABLE_500
432: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 446: , p5_a35 JTF_NUMBER_TABLE

442: , p5_a31 JTF_VARCHAR2_TABLE_500
443: , p5_a32 JTF_VARCHAR2_TABLE_500
444: , p5_a33 JTF_VARCHAR2_TABLE_500
445: , p5_a34 JTF_VARCHAR2_TABLE_500
446: , p5_a35 JTF_NUMBER_TABLE
447: , p5_a36 JTF_DATE_TABLE
448: , p5_a37 JTF_NUMBER_TABLE
449: , p5_a38 JTF_DATE_TABLE
450: , p5_a39 JTF_NUMBER_TABLE

Line 448: , p5_a37 JTF_NUMBER_TABLE

444: , p5_a33 JTF_VARCHAR2_TABLE_500
445: , p5_a34 JTF_VARCHAR2_TABLE_500
446: , p5_a35 JTF_NUMBER_TABLE
447: , p5_a36 JTF_DATE_TABLE
448: , p5_a37 JTF_NUMBER_TABLE
449: , p5_a38 JTF_DATE_TABLE
450: , p5_a39 JTF_NUMBER_TABLE
451: );
452: procedure update_row(p_api_version NUMBER

Line 450: , p5_a39 JTF_NUMBER_TABLE

446: , p5_a35 JTF_NUMBER_TABLE
447: , p5_a36 JTF_DATE_TABLE
448: , p5_a37 JTF_NUMBER_TABLE
449: , p5_a38 JTF_DATE_TABLE
450: , p5_a39 JTF_NUMBER_TABLE
451: );
452: procedure update_row(p_api_version NUMBER
453: , p_init_msg_list VARCHAR2
454: , x_return_status out nocopy VARCHAR2

Line 543: , p5_a0 JTF_NUMBER_TABLE

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

Line 544: , p5_a1 JTF_NUMBER_TABLE

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

Line 546: , p5_a3 JTF_NUMBER_TABLE

542: , x_msg_data out nocopy VARCHAR2
543: , p5_a0 JTF_NUMBER_TABLE
544: , p5_a1 JTF_NUMBER_TABLE
545: , p5_a2 JTF_VARCHAR2_TABLE_100
546: , p5_a3 JTF_NUMBER_TABLE
547: , p5_a4 JTF_NUMBER_TABLE
548: , p5_a5 JTF_VARCHAR2_TABLE_100
549: , p5_a6 JTF_VARCHAR2_TABLE_100
550: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 547: , p5_a4 JTF_NUMBER_TABLE

543: , p5_a0 JTF_NUMBER_TABLE
544: , p5_a1 JTF_NUMBER_TABLE
545: , p5_a2 JTF_VARCHAR2_TABLE_100
546: , p5_a3 JTF_NUMBER_TABLE
547: , p5_a4 JTF_NUMBER_TABLE
548: , p5_a5 JTF_VARCHAR2_TABLE_100
549: , p5_a6 JTF_VARCHAR2_TABLE_100
550: , p5_a7 JTF_VARCHAR2_TABLE_300
551: , p5_a8 JTF_NUMBER_TABLE

Line 551: , p5_a8 JTF_NUMBER_TABLE

547: , p5_a4 JTF_NUMBER_TABLE
548: , p5_a5 JTF_VARCHAR2_TABLE_100
549: , p5_a6 JTF_VARCHAR2_TABLE_100
550: , p5_a7 JTF_VARCHAR2_TABLE_300
551: , p5_a8 JTF_NUMBER_TABLE
552: , p5_a9 JTF_DATE_TABLE
553: , p5_a10 JTF_NUMBER_TABLE
554: , p5_a11 JTF_DATE_TABLE
555: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 553: , p5_a10 JTF_NUMBER_TABLE

549: , p5_a6 JTF_VARCHAR2_TABLE_100
550: , p5_a7 JTF_VARCHAR2_TABLE_300
551: , p5_a8 JTF_NUMBER_TABLE
552: , p5_a9 JTF_DATE_TABLE
553: , p5_a10 JTF_NUMBER_TABLE
554: , p5_a11 JTF_DATE_TABLE
555: , p5_a12 JTF_VARCHAR2_TABLE_100
556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE

Line 557: , p5_a14 JTF_NUMBER_TABLE

553: , p5_a10 JTF_NUMBER_TABLE
554: , p5_a11 JTF_DATE_TABLE
555: , p5_a12 JTF_VARCHAR2_TABLE_100
556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE
558: , p5_a15 JTF_NUMBER_TABLE
559: , p5_a16 JTF_NUMBER_TABLE
560: , p5_a17 JTF_NUMBER_TABLE
561: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 558: , p5_a15 JTF_NUMBER_TABLE

554: , p5_a11 JTF_DATE_TABLE
555: , p5_a12 JTF_VARCHAR2_TABLE_100
556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE
558: , p5_a15 JTF_NUMBER_TABLE
559: , p5_a16 JTF_NUMBER_TABLE
560: , p5_a17 JTF_NUMBER_TABLE
561: , p5_a18 JTF_VARCHAR2_TABLE_100
562: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 559: , p5_a16 JTF_NUMBER_TABLE

555: , p5_a12 JTF_VARCHAR2_TABLE_100
556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE
558: , p5_a15 JTF_NUMBER_TABLE
559: , p5_a16 JTF_NUMBER_TABLE
560: , p5_a17 JTF_NUMBER_TABLE
561: , p5_a18 JTF_VARCHAR2_TABLE_100
562: , p5_a19 JTF_VARCHAR2_TABLE_100
563: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 560: , p5_a17 JTF_NUMBER_TABLE

556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE
558: , p5_a15 JTF_NUMBER_TABLE
559: , p5_a16 JTF_NUMBER_TABLE
560: , p5_a17 JTF_NUMBER_TABLE
561: , p5_a18 JTF_VARCHAR2_TABLE_100
562: , p5_a19 JTF_VARCHAR2_TABLE_100
563: , p5_a20 JTF_VARCHAR2_TABLE_500
564: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 578: , p5_a35 JTF_NUMBER_TABLE

574: , p5_a31 JTF_VARCHAR2_TABLE_500
575: , p5_a32 JTF_VARCHAR2_TABLE_500
576: , p5_a33 JTF_VARCHAR2_TABLE_500
577: , p5_a34 JTF_VARCHAR2_TABLE_500
578: , p5_a35 JTF_NUMBER_TABLE
579: , p5_a36 JTF_DATE_TABLE
580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE

Line 580: , p5_a37 JTF_NUMBER_TABLE

576: , p5_a33 JTF_VARCHAR2_TABLE_500
577: , p5_a34 JTF_VARCHAR2_TABLE_500
578: , p5_a35 JTF_NUMBER_TABLE
579: , p5_a36 JTF_DATE_TABLE
580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 582: , p5_a39 JTF_NUMBER_TABLE

578: , p5_a35 JTF_NUMBER_TABLE
579: , p5_a36 JTF_DATE_TABLE
580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 583: , p6_a0 out nocopy JTF_NUMBER_TABLE

579: , p5_a36 JTF_DATE_TABLE
580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 584: , p6_a1 out nocopy JTF_NUMBER_TABLE

580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_NUMBER_TABLE
588: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 586: , p6_a3 out nocopy JTF_NUMBER_TABLE

582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_NUMBER_TABLE
588: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
589: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 587: , p6_a4 out nocopy JTF_NUMBER_TABLE

583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_NUMBER_TABLE
588: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
589: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
591: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 591: , p6_a8 out nocopy JTF_NUMBER_TABLE

587: , p6_a4 out nocopy JTF_NUMBER_TABLE
588: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
589: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
591: , p6_a8 out nocopy JTF_NUMBER_TABLE
592: , p6_a9 out nocopy JTF_DATE_TABLE
593: , p6_a10 out nocopy JTF_NUMBER_TABLE
594: , p6_a11 out nocopy JTF_DATE_TABLE
595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 593: , p6_a10 out nocopy JTF_NUMBER_TABLE

589: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
591: , p6_a8 out nocopy JTF_NUMBER_TABLE
592: , p6_a9 out nocopy JTF_DATE_TABLE
593: , p6_a10 out nocopy JTF_NUMBER_TABLE
594: , p6_a11 out nocopy JTF_DATE_TABLE
595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 597: , p6_a14 out nocopy JTF_NUMBER_TABLE

593: , p6_a10 out nocopy JTF_NUMBER_TABLE
594: , p6_a11 out nocopy JTF_DATE_TABLE
595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE
598: , p6_a15 out nocopy JTF_NUMBER_TABLE
599: , p6_a16 out nocopy JTF_NUMBER_TABLE
600: , p6_a17 out nocopy JTF_NUMBER_TABLE
601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 598: , p6_a15 out nocopy JTF_NUMBER_TABLE

594: , p6_a11 out nocopy JTF_DATE_TABLE
595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE
598: , p6_a15 out nocopy JTF_NUMBER_TABLE
599: , p6_a16 out nocopy JTF_NUMBER_TABLE
600: , p6_a17 out nocopy JTF_NUMBER_TABLE
601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
602: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 599: , p6_a16 out nocopy JTF_NUMBER_TABLE

595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE
598: , p6_a15 out nocopy JTF_NUMBER_TABLE
599: , p6_a16 out nocopy JTF_NUMBER_TABLE
600: , p6_a17 out nocopy JTF_NUMBER_TABLE
601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
602: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 600: , p6_a17 out nocopy JTF_NUMBER_TABLE

596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE
598: , p6_a15 out nocopy JTF_NUMBER_TABLE
599: , p6_a16 out nocopy JTF_NUMBER_TABLE
600: , p6_a17 out nocopy JTF_NUMBER_TABLE
601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
602: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
604: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 618: , p6_a35 out nocopy JTF_NUMBER_TABLE

614: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
615: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
616: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
617: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
618: , p6_a35 out nocopy JTF_NUMBER_TABLE
619: , p6_a36 out nocopy JTF_DATE_TABLE
620: , p6_a37 out nocopy JTF_NUMBER_TABLE
621: , p6_a38 out nocopy JTF_DATE_TABLE
622: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 620: , p6_a37 out nocopy JTF_NUMBER_TABLE

616: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
617: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
618: , p6_a35 out nocopy JTF_NUMBER_TABLE
619: , p6_a36 out nocopy JTF_DATE_TABLE
620: , p6_a37 out nocopy JTF_NUMBER_TABLE
621: , p6_a38 out nocopy JTF_DATE_TABLE
622: , p6_a39 out nocopy JTF_NUMBER_TABLE
623: );
624: procedure delete_row(p_api_version NUMBER

Line 622: , p6_a39 out nocopy JTF_NUMBER_TABLE

618: , p6_a35 out nocopy JTF_NUMBER_TABLE
619: , p6_a36 out nocopy JTF_DATE_TABLE
620: , p6_a37 out nocopy JTF_NUMBER_TABLE
621: , p6_a38 out nocopy JTF_DATE_TABLE
622: , p6_a39 out nocopy JTF_NUMBER_TABLE
623: );
624: procedure delete_row(p_api_version NUMBER
625: , p_init_msg_list VARCHAR2
626: , x_return_status out nocopy VARCHAR2

Line 675: , p5_a0 JTF_NUMBER_TABLE

671: , p_init_msg_list VARCHAR2
672: , x_return_status out nocopy VARCHAR2
673: , x_msg_count out nocopy NUMBER
674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_NUMBER_TABLE
677: , p5_a2 JTF_VARCHAR2_TABLE_100
678: , p5_a3 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE

Line 676: , p5_a1 JTF_NUMBER_TABLE

672: , x_return_status out nocopy VARCHAR2
673: , x_msg_count out nocopy NUMBER
674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_NUMBER_TABLE
677: , p5_a2 JTF_VARCHAR2_TABLE_100
678: , p5_a3 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 678: , p5_a3 JTF_NUMBER_TABLE

674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_NUMBER_TABLE
677: , p5_a2 JTF_VARCHAR2_TABLE_100
678: , p5_a3 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_VARCHAR2_TABLE_100
681: , p5_a6 JTF_VARCHAR2_TABLE_100
682: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 679: , p5_a4 JTF_NUMBER_TABLE

675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_NUMBER_TABLE
677: , p5_a2 JTF_VARCHAR2_TABLE_100
678: , p5_a3 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_VARCHAR2_TABLE_100
681: , p5_a6 JTF_VARCHAR2_TABLE_100
682: , p5_a7 JTF_VARCHAR2_TABLE_300
683: , p5_a8 JTF_NUMBER_TABLE

Line 683: , p5_a8 JTF_NUMBER_TABLE

679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_VARCHAR2_TABLE_100
681: , p5_a6 JTF_VARCHAR2_TABLE_100
682: , p5_a7 JTF_VARCHAR2_TABLE_300
683: , p5_a8 JTF_NUMBER_TABLE
684: , p5_a9 JTF_DATE_TABLE
685: , p5_a10 JTF_NUMBER_TABLE
686: , p5_a11 JTF_DATE_TABLE
687: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 685: , p5_a10 JTF_NUMBER_TABLE

681: , p5_a6 JTF_VARCHAR2_TABLE_100
682: , p5_a7 JTF_VARCHAR2_TABLE_300
683: , p5_a8 JTF_NUMBER_TABLE
684: , p5_a9 JTF_DATE_TABLE
685: , p5_a10 JTF_NUMBER_TABLE
686: , p5_a11 JTF_DATE_TABLE
687: , p5_a12 JTF_VARCHAR2_TABLE_100
688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE

Line 689: , p5_a14 JTF_NUMBER_TABLE

685: , p5_a10 JTF_NUMBER_TABLE
686: , p5_a11 JTF_DATE_TABLE
687: , p5_a12 JTF_VARCHAR2_TABLE_100
688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE
690: , p5_a15 JTF_NUMBER_TABLE
691: , p5_a16 JTF_NUMBER_TABLE
692: , p5_a17 JTF_NUMBER_TABLE
693: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 690: , p5_a15 JTF_NUMBER_TABLE

686: , p5_a11 JTF_DATE_TABLE
687: , p5_a12 JTF_VARCHAR2_TABLE_100
688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE
690: , p5_a15 JTF_NUMBER_TABLE
691: , p5_a16 JTF_NUMBER_TABLE
692: , p5_a17 JTF_NUMBER_TABLE
693: , p5_a18 JTF_VARCHAR2_TABLE_100
694: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 691: , p5_a16 JTF_NUMBER_TABLE

687: , p5_a12 JTF_VARCHAR2_TABLE_100
688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE
690: , p5_a15 JTF_NUMBER_TABLE
691: , p5_a16 JTF_NUMBER_TABLE
692: , p5_a17 JTF_NUMBER_TABLE
693: , p5_a18 JTF_VARCHAR2_TABLE_100
694: , p5_a19 JTF_VARCHAR2_TABLE_100
695: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 692: , p5_a17 JTF_NUMBER_TABLE

688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE
690: , p5_a15 JTF_NUMBER_TABLE
691: , p5_a16 JTF_NUMBER_TABLE
692: , p5_a17 JTF_NUMBER_TABLE
693: , p5_a18 JTF_VARCHAR2_TABLE_100
694: , p5_a19 JTF_VARCHAR2_TABLE_100
695: , p5_a20 JTF_VARCHAR2_TABLE_500
696: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 710: , p5_a35 JTF_NUMBER_TABLE

706: , p5_a31 JTF_VARCHAR2_TABLE_500
707: , p5_a32 JTF_VARCHAR2_TABLE_500
708: , p5_a33 JTF_VARCHAR2_TABLE_500
709: , p5_a34 JTF_VARCHAR2_TABLE_500
710: , p5_a35 JTF_NUMBER_TABLE
711: , p5_a36 JTF_DATE_TABLE
712: , p5_a37 JTF_NUMBER_TABLE
713: , p5_a38 JTF_DATE_TABLE
714: , p5_a39 JTF_NUMBER_TABLE

Line 712: , p5_a37 JTF_NUMBER_TABLE

708: , p5_a33 JTF_VARCHAR2_TABLE_500
709: , p5_a34 JTF_VARCHAR2_TABLE_500
710: , p5_a35 JTF_NUMBER_TABLE
711: , p5_a36 JTF_DATE_TABLE
712: , p5_a37 JTF_NUMBER_TABLE
713: , p5_a38 JTF_DATE_TABLE
714: , p5_a39 JTF_NUMBER_TABLE
715: );
716: procedure validate_row(p_api_version NUMBER

Line 714: , p5_a39 JTF_NUMBER_TABLE

710: , p5_a35 JTF_NUMBER_TABLE
711: , p5_a36 JTF_DATE_TABLE
712: , p5_a37 JTF_NUMBER_TABLE
713: , p5_a38 JTF_DATE_TABLE
714: , p5_a39 JTF_NUMBER_TABLE
715: );
716: procedure validate_row(p_api_version NUMBER
717: , p_init_msg_list VARCHAR2
718: , x_return_status out nocopy VARCHAR2

Line 767: , p5_a0 JTF_NUMBER_TABLE

763: , p_init_msg_list VARCHAR2
764: , x_return_status out nocopy VARCHAR2
765: , x_msg_count out nocopy NUMBER
766: , x_msg_data out nocopy VARCHAR2
767: , p5_a0 JTF_NUMBER_TABLE
768: , p5_a1 JTF_NUMBER_TABLE
769: , p5_a2 JTF_VARCHAR2_TABLE_100
770: , p5_a3 JTF_NUMBER_TABLE
771: , p5_a4 JTF_NUMBER_TABLE

Line 768: , p5_a1 JTF_NUMBER_TABLE

764: , x_return_status out nocopy VARCHAR2
765: , x_msg_count out nocopy NUMBER
766: , x_msg_data out nocopy VARCHAR2
767: , p5_a0 JTF_NUMBER_TABLE
768: , p5_a1 JTF_NUMBER_TABLE
769: , p5_a2 JTF_VARCHAR2_TABLE_100
770: , p5_a3 JTF_NUMBER_TABLE
771: , p5_a4 JTF_NUMBER_TABLE
772: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 770: , p5_a3 JTF_NUMBER_TABLE

766: , x_msg_data out nocopy VARCHAR2
767: , p5_a0 JTF_NUMBER_TABLE
768: , p5_a1 JTF_NUMBER_TABLE
769: , p5_a2 JTF_VARCHAR2_TABLE_100
770: , p5_a3 JTF_NUMBER_TABLE
771: , p5_a4 JTF_NUMBER_TABLE
772: , p5_a5 JTF_VARCHAR2_TABLE_100
773: , p5_a6 JTF_VARCHAR2_TABLE_100
774: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 771: , p5_a4 JTF_NUMBER_TABLE

767: , p5_a0 JTF_NUMBER_TABLE
768: , p5_a1 JTF_NUMBER_TABLE
769: , p5_a2 JTF_VARCHAR2_TABLE_100
770: , p5_a3 JTF_NUMBER_TABLE
771: , p5_a4 JTF_NUMBER_TABLE
772: , p5_a5 JTF_VARCHAR2_TABLE_100
773: , p5_a6 JTF_VARCHAR2_TABLE_100
774: , p5_a7 JTF_VARCHAR2_TABLE_300
775: , p5_a8 JTF_NUMBER_TABLE

Line 775: , p5_a8 JTF_NUMBER_TABLE

771: , p5_a4 JTF_NUMBER_TABLE
772: , p5_a5 JTF_VARCHAR2_TABLE_100
773: , p5_a6 JTF_VARCHAR2_TABLE_100
774: , p5_a7 JTF_VARCHAR2_TABLE_300
775: , p5_a8 JTF_NUMBER_TABLE
776: , p5_a9 JTF_DATE_TABLE
777: , p5_a10 JTF_NUMBER_TABLE
778: , p5_a11 JTF_DATE_TABLE
779: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 777: , p5_a10 JTF_NUMBER_TABLE

773: , p5_a6 JTF_VARCHAR2_TABLE_100
774: , p5_a7 JTF_VARCHAR2_TABLE_300
775: , p5_a8 JTF_NUMBER_TABLE
776: , p5_a9 JTF_DATE_TABLE
777: , p5_a10 JTF_NUMBER_TABLE
778: , p5_a11 JTF_DATE_TABLE
779: , p5_a12 JTF_VARCHAR2_TABLE_100
780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE

Line 781: , p5_a14 JTF_NUMBER_TABLE

777: , p5_a10 JTF_NUMBER_TABLE
778: , p5_a11 JTF_DATE_TABLE
779: , p5_a12 JTF_VARCHAR2_TABLE_100
780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE
782: , p5_a15 JTF_NUMBER_TABLE
783: , p5_a16 JTF_NUMBER_TABLE
784: , p5_a17 JTF_NUMBER_TABLE
785: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 782: , p5_a15 JTF_NUMBER_TABLE

778: , p5_a11 JTF_DATE_TABLE
779: , p5_a12 JTF_VARCHAR2_TABLE_100
780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE
782: , p5_a15 JTF_NUMBER_TABLE
783: , p5_a16 JTF_NUMBER_TABLE
784: , p5_a17 JTF_NUMBER_TABLE
785: , p5_a18 JTF_VARCHAR2_TABLE_100
786: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 783: , p5_a16 JTF_NUMBER_TABLE

779: , p5_a12 JTF_VARCHAR2_TABLE_100
780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE
782: , p5_a15 JTF_NUMBER_TABLE
783: , p5_a16 JTF_NUMBER_TABLE
784: , p5_a17 JTF_NUMBER_TABLE
785: , p5_a18 JTF_VARCHAR2_TABLE_100
786: , p5_a19 JTF_VARCHAR2_TABLE_100
787: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 784: , p5_a17 JTF_NUMBER_TABLE

780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE
782: , p5_a15 JTF_NUMBER_TABLE
783: , p5_a16 JTF_NUMBER_TABLE
784: , p5_a17 JTF_NUMBER_TABLE
785: , p5_a18 JTF_VARCHAR2_TABLE_100
786: , p5_a19 JTF_VARCHAR2_TABLE_100
787: , p5_a20 JTF_VARCHAR2_TABLE_500
788: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 802: , p5_a35 JTF_NUMBER_TABLE

798: , p5_a31 JTF_VARCHAR2_TABLE_500
799: , p5_a32 JTF_VARCHAR2_TABLE_500
800: , p5_a33 JTF_VARCHAR2_TABLE_500
801: , p5_a34 JTF_VARCHAR2_TABLE_500
802: , p5_a35 JTF_NUMBER_TABLE
803: , p5_a36 JTF_DATE_TABLE
804: , p5_a37 JTF_NUMBER_TABLE
805: , p5_a38 JTF_DATE_TABLE
806: , p5_a39 JTF_NUMBER_TABLE

Line 804: , p5_a37 JTF_NUMBER_TABLE

800: , p5_a33 JTF_VARCHAR2_TABLE_500
801: , p5_a34 JTF_VARCHAR2_TABLE_500
802: , p5_a35 JTF_NUMBER_TABLE
803: , p5_a36 JTF_DATE_TABLE
804: , p5_a37 JTF_NUMBER_TABLE
805: , p5_a38 JTF_DATE_TABLE
806: , p5_a39 JTF_NUMBER_TABLE
807: );
808: end okl_ipt_pvt_w;

Line 806: , p5_a39 JTF_NUMBER_TABLE

802: , p5_a35 JTF_NUMBER_TABLE
803: , p5_a36 JTF_DATE_TABLE
804: , p5_a37 JTF_NUMBER_TABLE
805: , p5_a38 JTF_DATE_TABLE
806: , p5_a39 JTF_NUMBER_TABLE
807: );
808: end okl_ipt_pvt_w;