APPS.OKL_PTL_QUALITYS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 8: , p6_a0 JTF_NUMBER_TABLE

4: , p_init_msg_list VARCHAR2
5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p6_a0 JTF_NUMBER_TABLE
9: , p6_a1 JTF_NUMBER_TABLE
10: , p6_a2 JTF_NUMBER_TABLE
11: , p6_a3 JTF_VARCHAR2_TABLE_200
12: , p6_a4 JTF_VARCHAR2_TABLE_2000

Line 9: , p6_a1 JTF_NUMBER_TABLE

5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p6_a0 JTF_NUMBER_TABLE
9: , p6_a1 JTF_NUMBER_TABLE
10: , p6_a2 JTF_NUMBER_TABLE
11: , p6_a3 JTF_VARCHAR2_TABLE_200
12: , p6_a4 JTF_VARCHAR2_TABLE_2000
13: , p6_a5 JTF_DATE_TABLE

Line 10: , p6_a2 JTF_NUMBER_TABLE

6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p6_a0 JTF_NUMBER_TABLE
9: , p6_a1 JTF_NUMBER_TABLE
10: , p6_a2 JTF_NUMBER_TABLE
11: , p6_a3 JTF_VARCHAR2_TABLE_200
12: , p6_a4 JTF_VARCHAR2_TABLE_2000
13: , p6_a5 JTF_DATE_TABLE
14: , p6_a6 JTF_DATE_TABLE

Line 15: , p6_a7 JTF_NUMBER_TABLE

11: , p6_a3 JTF_VARCHAR2_TABLE_200
12: , p6_a4 JTF_VARCHAR2_TABLE_2000
13: , p6_a5 JTF_DATE_TABLE
14: , p6_a6 JTF_DATE_TABLE
15: , p6_a7 JTF_NUMBER_TABLE
16: , p6_a8 JTF_DATE_TABLE
17: , p6_a9 JTF_NUMBER_TABLE
18: , p6_a10 JTF_DATE_TABLE
19: , p6_a11 JTF_NUMBER_TABLE

Line 17: , p6_a9 JTF_NUMBER_TABLE

13: , p6_a5 JTF_DATE_TABLE
14: , p6_a6 JTF_DATE_TABLE
15: , p6_a7 JTF_NUMBER_TABLE
16: , p6_a8 JTF_DATE_TABLE
17: , p6_a9 JTF_NUMBER_TABLE
18: , p6_a10 JTF_DATE_TABLE
19: , p6_a11 JTF_NUMBER_TABLE
20: , p7_a0 out nocopy NUMBER
21: , p7_a1 out nocopy NUMBER

Line 19: , p6_a11 JTF_NUMBER_TABLE

15: , p6_a7 JTF_NUMBER_TABLE
16: , p6_a8 JTF_DATE_TABLE
17: , p6_a9 JTF_NUMBER_TABLE
18: , p6_a10 JTF_DATE_TABLE
19: , p6_a11 JTF_NUMBER_TABLE
20: , p7_a0 out nocopy NUMBER
21: , p7_a1 out nocopy NUMBER
22: , p7_a2 out nocopy VARCHAR2
23: , p7_a3 out nocopy VARCHAR2

Line 31: , p8_a0 out nocopy JTF_NUMBER_TABLE

27: , p7_a7 out nocopy DATE
28: , p7_a8 out nocopy NUMBER
29: , p7_a9 out nocopy DATE
30: , p7_a10 out nocopy NUMBER
31: , p8_a0 out nocopy JTF_NUMBER_TABLE
32: , p8_a1 out nocopy JTF_NUMBER_TABLE
33: , p8_a2 out nocopy JTF_NUMBER_TABLE
34: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
35: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 32: , p8_a1 out nocopy JTF_NUMBER_TABLE

28: , p7_a8 out nocopy NUMBER
29: , p7_a9 out nocopy DATE
30: , p7_a10 out nocopy NUMBER
31: , p8_a0 out nocopy JTF_NUMBER_TABLE
32: , p8_a1 out nocopy JTF_NUMBER_TABLE
33: , p8_a2 out nocopy JTF_NUMBER_TABLE
34: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
35: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
36: , p8_a5 out nocopy JTF_DATE_TABLE

Line 33: , p8_a2 out nocopy JTF_NUMBER_TABLE

29: , p7_a9 out nocopy DATE
30: , p7_a10 out nocopy NUMBER
31: , p8_a0 out nocopy JTF_NUMBER_TABLE
32: , p8_a1 out nocopy JTF_NUMBER_TABLE
33: , p8_a2 out nocopy JTF_NUMBER_TABLE
34: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
35: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
36: , p8_a5 out nocopy JTF_DATE_TABLE
37: , p8_a6 out nocopy JTF_DATE_TABLE

Line 38: , p8_a7 out nocopy JTF_NUMBER_TABLE

34: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
35: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
36: , p8_a5 out nocopy JTF_DATE_TABLE
37: , p8_a6 out nocopy JTF_DATE_TABLE
38: , p8_a7 out nocopy JTF_NUMBER_TABLE
39: , p8_a8 out nocopy JTF_DATE_TABLE
40: , p8_a9 out nocopy JTF_NUMBER_TABLE
41: , p8_a10 out nocopy JTF_DATE_TABLE
42: , p8_a11 out nocopy JTF_NUMBER_TABLE

Line 40: , p8_a9 out nocopy JTF_NUMBER_TABLE

36: , p8_a5 out nocopy JTF_DATE_TABLE
37: , p8_a6 out nocopy JTF_DATE_TABLE
38: , p8_a7 out nocopy JTF_NUMBER_TABLE
39: , p8_a8 out nocopy JTF_DATE_TABLE
40: , p8_a9 out nocopy JTF_NUMBER_TABLE
41: , p8_a10 out nocopy JTF_DATE_TABLE
42: , p8_a11 out nocopy JTF_NUMBER_TABLE
43: , p5_a0 NUMBER := 0-1962.0724
44: , p5_a1 NUMBER := 0-1962.0724

Line 42: , p8_a11 out nocopy JTF_NUMBER_TABLE

38: , p8_a7 out nocopy JTF_NUMBER_TABLE
39: , p8_a8 out nocopy JTF_DATE_TABLE
40: , p8_a9 out nocopy JTF_NUMBER_TABLE
41: , p8_a10 out nocopy JTF_DATE_TABLE
42: , p8_a11 out nocopy JTF_NUMBER_TABLE
43: , p5_a0 NUMBER := 0-1962.0724
44: , p5_a1 NUMBER := 0-1962.0724
45: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

Line 60: , p6_a0 JTF_NUMBER_TABLE

56: , p_init_msg_list VARCHAR2
57: , x_return_status out nocopy VARCHAR2
58: , x_msg_count out nocopy NUMBER
59: , x_msg_data out nocopy VARCHAR2
60: , p6_a0 JTF_NUMBER_TABLE
61: , p6_a1 JTF_NUMBER_TABLE
62: , p6_a2 JTF_NUMBER_TABLE
63: , p6_a3 JTF_VARCHAR2_TABLE_200
64: , p6_a4 JTF_VARCHAR2_TABLE_2000

Line 61: , p6_a1 JTF_NUMBER_TABLE

57: , x_return_status out nocopy VARCHAR2
58: , x_msg_count out nocopy NUMBER
59: , x_msg_data out nocopy VARCHAR2
60: , p6_a0 JTF_NUMBER_TABLE
61: , p6_a1 JTF_NUMBER_TABLE
62: , p6_a2 JTF_NUMBER_TABLE
63: , p6_a3 JTF_VARCHAR2_TABLE_200
64: , p6_a4 JTF_VARCHAR2_TABLE_2000
65: , p6_a5 JTF_DATE_TABLE

Line 62: , p6_a2 JTF_NUMBER_TABLE

58: , x_msg_count out nocopy NUMBER
59: , x_msg_data out nocopy VARCHAR2
60: , p6_a0 JTF_NUMBER_TABLE
61: , p6_a1 JTF_NUMBER_TABLE
62: , p6_a2 JTF_NUMBER_TABLE
63: , p6_a3 JTF_VARCHAR2_TABLE_200
64: , p6_a4 JTF_VARCHAR2_TABLE_2000
65: , p6_a5 JTF_DATE_TABLE
66: , p6_a6 JTF_DATE_TABLE

Line 67: , p6_a7 JTF_NUMBER_TABLE

63: , p6_a3 JTF_VARCHAR2_TABLE_200
64: , p6_a4 JTF_VARCHAR2_TABLE_2000
65: , p6_a5 JTF_DATE_TABLE
66: , p6_a6 JTF_DATE_TABLE
67: , p6_a7 JTF_NUMBER_TABLE
68: , p6_a8 JTF_DATE_TABLE
69: , p6_a9 JTF_NUMBER_TABLE
70: , p6_a10 JTF_DATE_TABLE
71: , p6_a11 JTF_NUMBER_TABLE

Line 69: , p6_a9 JTF_NUMBER_TABLE

65: , p6_a5 JTF_DATE_TABLE
66: , p6_a6 JTF_DATE_TABLE
67: , p6_a7 JTF_NUMBER_TABLE
68: , p6_a8 JTF_DATE_TABLE
69: , p6_a9 JTF_NUMBER_TABLE
70: , p6_a10 JTF_DATE_TABLE
71: , p6_a11 JTF_NUMBER_TABLE
72: , p7_a0 out nocopy NUMBER
73: , p7_a1 out nocopy NUMBER

Line 71: , p6_a11 JTF_NUMBER_TABLE

67: , p6_a7 JTF_NUMBER_TABLE
68: , p6_a8 JTF_DATE_TABLE
69: , p6_a9 JTF_NUMBER_TABLE
70: , p6_a10 JTF_DATE_TABLE
71: , p6_a11 JTF_NUMBER_TABLE
72: , p7_a0 out nocopy NUMBER
73: , p7_a1 out nocopy NUMBER
74: , p7_a2 out nocopy VARCHAR2
75: , p7_a3 out nocopy VARCHAR2

Line 83: , p8_a0 out nocopy JTF_NUMBER_TABLE

79: , p7_a7 out nocopy DATE
80: , p7_a8 out nocopy NUMBER
81: , p7_a9 out nocopy DATE
82: , p7_a10 out nocopy NUMBER
83: , p8_a0 out nocopy JTF_NUMBER_TABLE
84: , p8_a1 out nocopy JTF_NUMBER_TABLE
85: , p8_a2 out nocopy JTF_NUMBER_TABLE
86: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
87: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 84: , p8_a1 out nocopy JTF_NUMBER_TABLE

80: , p7_a8 out nocopy NUMBER
81: , p7_a9 out nocopy DATE
82: , p7_a10 out nocopy NUMBER
83: , p8_a0 out nocopy JTF_NUMBER_TABLE
84: , p8_a1 out nocopy JTF_NUMBER_TABLE
85: , p8_a2 out nocopy JTF_NUMBER_TABLE
86: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
87: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
88: , p8_a5 out nocopy JTF_DATE_TABLE

Line 85: , p8_a2 out nocopy JTF_NUMBER_TABLE

81: , p7_a9 out nocopy DATE
82: , p7_a10 out nocopy NUMBER
83: , p8_a0 out nocopy JTF_NUMBER_TABLE
84: , p8_a1 out nocopy JTF_NUMBER_TABLE
85: , p8_a2 out nocopy JTF_NUMBER_TABLE
86: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
87: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
88: , p8_a5 out nocopy JTF_DATE_TABLE
89: , p8_a6 out nocopy JTF_DATE_TABLE

Line 90: , p8_a7 out nocopy JTF_NUMBER_TABLE

86: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
87: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
88: , p8_a5 out nocopy JTF_DATE_TABLE
89: , p8_a6 out nocopy JTF_DATE_TABLE
90: , p8_a7 out nocopy JTF_NUMBER_TABLE
91: , p8_a8 out nocopy JTF_DATE_TABLE
92: , p8_a9 out nocopy JTF_NUMBER_TABLE
93: , p8_a10 out nocopy JTF_DATE_TABLE
94: , p8_a11 out nocopy JTF_NUMBER_TABLE

Line 92: , p8_a9 out nocopy JTF_NUMBER_TABLE

88: , p8_a5 out nocopy JTF_DATE_TABLE
89: , p8_a6 out nocopy JTF_DATE_TABLE
90: , p8_a7 out nocopy JTF_NUMBER_TABLE
91: , p8_a8 out nocopy JTF_DATE_TABLE
92: , p8_a9 out nocopy JTF_NUMBER_TABLE
93: , p8_a10 out nocopy JTF_DATE_TABLE
94: , p8_a11 out nocopy JTF_NUMBER_TABLE
95: , p5_a0 NUMBER := 0-1962.0724
96: , p5_a1 NUMBER := 0-1962.0724

Line 94: , p8_a11 out nocopy JTF_NUMBER_TABLE

90: , p8_a7 out nocopy JTF_NUMBER_TABLE
91: , p8_a8 out nocopy JTF_DATE_TABLE
92: , p8_a9 out nocopy JTF_NUMBER_TABLE
93: , p8_a10 out nocopy JTF_DATE_TABLE
94: , p8_a11 out nocopy JTF_NUMBER_TABLE
95: , p5_a0 NUMBER := 0-1962.0724
96: , p5_a1 NUMBER := 0-1962.0724
97: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

Line 112: , p6_a0 JTF_NUMBER_TABLE

108: , p_init_msg_list VARCHAR2
109: , x_return_status out nocopy VARCHAR2
110: , x_msg_count out nocopy NUMBER
111: , x_msg_data out nocopy VARCHAR2
112: , p6_a0 JTF_NUMBER_TABLE
113: , p6_a1 JTF_NUMBER_TABLE
114: , p6_a2 JTF_NUMBER_TABLE
115: , p6_a3 JTF_VARCHAR2_TABLE_200
116: , p6_a4 JTF_VARCHAR2_TABLE_2000

Line 113: , p6_a1 JTF_NUMBER_TABLE

109: , x_return_status out nocopy VARCHAR2
110: , x_msg_count out nocopy NUMBER
111: , x_msg_data out nocopy VARCHAR2
112: , p6_a0 JTF_NUMBER_TABLE
113: , p6_a1 JTF_NUMBER_TABLE
114: , p6_a2 JTF_NUMBER_TABLE
115: , p6_a3 JTF_VARCHAR2_TABLE_200
116: , p6_a4 JTF_VARCHAR2_TABLE_2000
117: , p6_a5 JTF_DATE_TABLE

Line 114: , p6_a2 JTF_NUMBER_TABLE

110: , x_msg_count out nocopy NUMBER
111: , x_msg_data out nocopy VARCHAR2
112: , p6_a0 JTF_NUMBER_TABLE
113: , p6_a1 JTF_NUMBER_TABLE
114: , p6_a2 JTF_NUMBER_TABLE
115: , p6_a3 JTF_VARCHAR2_TABLE_200
116: , p6_a4 JTF_VARCHAR2_TABLE_2000
117: , p6_a5 JTF_DATE_TABLE
118: , p6_a6 JTF_DATE_TABLE

Line 119: , p6_a7 JTF_NUMBER_TABLE

115: , p6_a3 JTF_VARCHAR2_TABLE_200
116: , p6_a4 JTF_VARCHAR2_TABLE_2000
117: , p6_a5 JTF_DATE_TABLE
118: , p6_a6 JTF_DATE_TABLE
119: , p6_a7 JTF_NUMBER_TABLE
120: , p6_a8 JTF_DATE_TABLE
121: , p6_a9 JTF_NUMBER_TABLE
122: , p6_a10 JTF_DATE_TABLE
123: , p6_a11 JTF_NUMBER_TABLE

Line 121: , p6_a9 JTF_NUMBER_TABLE

117: , p6_a5 JTF_DATE_TABLE
118: , p6_a6 JTF_DATE_TABLE
119: , p6_a7 JTF_NUMBER_TABLE
120: , p6_a8 JTF_DATE_TABLE
121: , p6_a9 JTF_NUMBER_TABLE
122: , p6_a10 JTF_DATE_TABLE
123: , p6_a11 JTF_NUMBER_TABLE
124: , p5_a0 NUMBER := 0-1962.0724
125: , p5_a1 NUMBER := 0-1962.0724

Line 123: , p6_a11 JTF_NUMBER_TABLE

119: , p6_a7 JTF_NUMBER_TABLE
120: , p6_a8 JTF_DATE_TABLE
121: , p6_a9 JTF_NUMBER_TABLE
122: , p6_a10 JTF_DATE_TABLE
123: , p6_a11 JTF_NUMBER_TABLE
124: , p5_a0 NUMBER := 0-1962.0724
125: , p5_a1 NUMBER := 0-1962.0724
126: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

Line 141: , p5_a0 JTF_NUMBER_TABLE

137: , p_init_msg_list VARCHAR2
138: , x_return_status out nocopy VARCHAR2
139: , x_msg_count out nocopy NUMBER
140: , x_msg_data out nocopy VARCHAR2
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_NUMBER_TABLE
143: , p5_a2 JTF_VARCHAR2_TABLE_200
144: , p5_a3 JTF_VARCHAR2_TABLE_2000
145: , p5_a4 JTF_DATE_TABLE

Line 142: , p5_a1 JTF_NUMBER_TABLE

138: , x_return_status out nocopy VARCHAR2
139: , x_msg_count out nocopy NUMBER
140: , x_msg_data out nocopy VARCHAR2
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_NUMBER_TABLE
143: , p5_a2 JTF_VARCHAR2_TABLE_200
144: , p5_a3 JTF_VARCHAR2_TABLE_2000
145: , p5_a4 JTF_DATE_TABLE
146: , p5_a5 JTF_DATE_TABLE

Line 147: , p5_a6 JTF_NUMBER_TABLE

143: , p5_a2 JTF_VARCHAR2_TABLE_200
144: , p5_a3 JTF_VARCHAR2_TABLE_2000
145: , p5_a4 JTF_DATE_TABLE
146: , p5_a5 JTF_DATE_TABLE
147: , p5_a6 JTF_NUMBER_TABLE
148: , p5_a7 JTF_DATE_TABLE
149: , p5_a8 JTF_NUMBER_TABLE
150: , p5_a9 JTF_DATE_TABLE
151: , p5_a10 JTF_NUMBER_TABLE

Line 149: , p5_a8 JTF_NUMBER_TABLE

145: , p5_a4 JTF_DATE_TABLE
146: , p5_a5 JTF_DATE_TABLE
147: , p5_a6 JTF_NUMBER_TABLE
148: , p5_a7 JTF_DATE_TABLE
149: , p5_a8 JTF_NUMBER_TABLE
150: , p5_a9 JTF_DATE_TABLE
151: , p5_a10 JTF_NUMBER_TABLE
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 151: , p5_a10 JTF_NUMBER_TABLE

147: , p5_a6 JTF_NUMBER_TABLE
148: , p5_a7 JTF_DATE_TABLE
149: , p5_a8 JTF_NUMBER_TABLE
150: , p5_a9 JTF_DATE_TABLE
151: , p5_a10 JTF_NUMBER_TABLE
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
155: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 152: , p6_a0 out nocopy JTF_NUMBER_TABLE

148: , p5_a7 JTF_DATE_TABLE
149: , p5_a8 JTF_NUMBER_TABLE
150: , p5_a9 JTF_DATE_TABLE
151: , p5_a10 JTF_NUMBER_TABLE
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
155: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
156: , p6_a4 out nocopy JTF_DATE_TABLE

Line 153: , p6_a1 out nocopy JTF_NUMBER_TABLE

149: , p5_a8 JTF_NUMBER_TABLE
150: , p5_a9 JTF_DATE_TABLE
151: , p5_a10 JTF_NUMBER_TABLE
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
155: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
156: , p6_a4 out nocopy JTF_DATE_TABLE
157: , p6_a5 out nocopy JTF_DATE_TABLE

Line 158: , p6_a6 out nocopy JTF_NUMBER_TABLE

154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
155: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
156: , p6_a4 out nocopy JTF_DATE_TABLE
157: , p6_a5 out nocopy JTF_DATE_TABLE
158: , p6_a6 out nocopy JTF_NUMBER_TABLE
159: , p6_a7 out nocopy JTF_DATE_TABLE
160: , p6_a8 out nocopy JTF_NUMBER_TABLE
161: , p6_a9 out nocopy JTF_DATE_TABLE
162: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 160: , p6_a8 out nocopy JTF_NUMBER_TABLE

156: , p6_a4 out nocopy JTF_DATE_TABLE
157: , p6_a5 out nocopy JTF_DATE_TABLE
158: , p6_a6 out nocopy JTF_NUMBER_TABLE
159: , p6_a7 out nocopy JTF_DATE_TABLE
160: , p6_a8 out nocopy JTF_NUMBER_TABLE
161: , p6_a9 out nocopy JTF_DATE_TABLE
162: , p6_a10 out nocopy JTF_NUMBER_TABLE
163: );
164: procedure create_ptl_qualitys(p_api_version NUMBER

Line 162: , p6_a10 out nocopy JTF_NUMBER_TABLE

158: , p6_a6 out nocopy JTF_NUMBER_TABLE
159: , p6_a7 out nocopy JTF_DATE_TABLE
160: , p6_a8 out nocopy JTF_NUMBER_TABLE
161: , p6_a9 out nocopy JTF_DATE_TABLE
162: , p6_a10 out nocopy JTF_NUMBER_TABLE
163: );
164: procedure create_ptl_qualitys(p_api_version NUMBER
165: , p_init_msg_list VARCHAR2
166: , x_return_status out nocopy VARCHAR2

Line 197: , p5_a0 JTF_NUMBER_TABLE

193: , p_init_msg_list VARCHAR2
194: , x_return_status out nocopy VARCHAR2
195: , x_msg_count out nocopy NUMBER
196: , x_msg_data out nocopy VARCHAR2
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_VARCHAR2_TABLE_200
200: , p5_a3 JTF_VARCHAR2_TABLE_2000
201: , p5_a4 JTF_DATE_TABLE

Line 198: , p5_a1 JTF_NUMBER_TABLE

194: , x_return_status out nocopy VARCHAR2
195: , x_msg_count out nocopy NUMBER
196: , x_msg_data out nocopy VARCHAR2
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_VARCHAR2_TABLE_200
200: , p5_a3 JTF_VARCHAR2_TABLE_2000
201: , p5_a4 JTF_DATE_TABLE
202: , p5_a5 JTF_DATE_TABLE

Line 203: , p5_a6 JTF_NUMBER_TABLE

199: , p5_a2 JTF_VARCHAR2_TABLE_200
200: , p5_a3 JTF_VARCHAR2_TABLE_2000
201: , p5_a4 JTF_DATE_TABLE
202: , p5_a5 JTF_DATE_TABLE
203: , p5_a6 JTF_NUMBER_TABLE
204: , p5_a7 JTF_DATE_TABLE
205: , p5_a8 JTF_NUMBER_TABLE
206: , p5_a9 JTF_DATE_TABLE
207: , p5_a10 JTF_NUMBER_TABLE

Line 205: , p5_a8 JTF_NUMBER_TABLE

201: , p5_a4 JTF_DATE_TABLE
202: , p5_a5 JTF_DATE_TABLE
203: , p5_a6 JTF_NUMBER_TABLE
204: , p5_a7 JTF_DATE_TABLE
205: , p5_a8 JTF_NUMBER_TABLE
206: , p5_a9 JTF_DATE_TABLE
207: , p5_a10 JTF_NUMBER_TABLE
208: );
209: procedure lock_ptl_qualitys(p_api_version NUMBER

Line 207: , p5_a10 JTF_NUMBER_TABLE

203: , p5_a6 JTF_NUMBER_TABLE
204: , p5_a7 JTF_DATE_TABLE
205: , p5_a8 JTF_NUMBER_TABLE
206: , p5_a9 JTF_DATE_TABLE
207: , p5_a10 JTF_NUMBER_TABLE
208: );
209: procedure lock_ptl_qualitys(p_api_version NUMBER
210: , p_init_msg_list VARCHAR2
211: , x_return_status out nocopy 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_200
234: , p5_a3 JTF_VARCHAR2_TABLE_2000
235: , p5_a4 JTF_DATE_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_200
234: , p5_a3 JTF_VARCHAR2_TABLE_2000
235: , p5_a4 JTF_DATE_TABLE
236: , p5_a5 JTF_DATE_TABLE

Line 237: , p5_a6 JTF_NUMBER_TABLE

233: , p5_a2 JTF_VARCHAR2_TABLE_200
234: , p5_a3 JTF_VARCHAR2_TABLE_2000
235: , p5_a4 JTF_DATE_TABLE
236: , p5_a5 JTF_DATE_TABLE
237: , p5_a6 JTF_NUMBER_TABLE
238: , p5_a7 JTF_DATE_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_DATE_TABLE
241: , p5_a10 JTF_NUMBER_TABLE

Line 239: , p5_a8 JTF_NUMBER_TABLE

235: , p5_a4 JTF_DATE_TABLE
236: , p5_a5 JTF_DATE_TABLE
237: , p5_a6 JTF_NUMBER_TABLE
238: , p5_a7 JTF_DATE_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_DATE_TABLE
241: , p5_a10 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 241: , p5_a10 JTF_NUMBER_TABLE

237: , p5_a6 JTF_NUMBER_TABLE
238: , p5_a7 JTF_DATE_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_DATE_TABLE
241: , p5_a10 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
245: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 242: , p6_a0 out nocopy JTF_NUMBER_TABLE

238: , p5_a7 JTF_DATE_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_DATE_TABLE
241: , p5_a10 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
245: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
246: , p6_a4 out nocopy JTF_DATE_TABLE

Line 243: , p6_a1 out nocopy JTF_NUMBER_TABLE

239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_DATE_TABLE
241: , p5_a10 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
245: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
246: , p6_a4 out nocopy JTF_DATE_TABLE
247: , p6_a5 out nocopy JTF_DATE_TABLE

Line 248: , p6_a6 out nocopy JTF_NUMBER_TABLE

244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
245: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
246: , p6_a4 out nocopy JTF_DATE_TABLE
247: , p6_a5 out nocopy JTF_DATE_TABLE
248: , p6_a6 out nocopy JTF_NUMBER_TABLE
249: , p6_a7 out nocopy JTF_DATE_TABLE
250: , p6_a8 out nocopy JTF_NUMBER_TABLE
251: , p6_a9 out nocopy JTF_DATE_TABLE
252: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 250: , p6_a8 out nocopy JTF_NUMBER_TABLE

246: , p6_a4 out nocopy JTF_DATE_TABLE
247: , p6_a5 out nocopy JTF_DATE_TABLE
248: , p6_a6 out nocopy JTF_NUMBER_TABLE
249: , p6_a7 out nocopy JTF_DATE_TABLE
250: , p6_a8 out nocopy JTF_NUMBER_TABLE
251: , p6_a9 out nocopy JTF_DATE_TABLE
252: , p6_a10 out nocopy JTF_NUMBER_TABLE
253: );
254: procedure update_ptl_qualitys(p_api_version NUMBER

Line 252: , p6_a10 out nocopy JTF_NUMBER_TABLE

248: , p6_a6 out nocopy JTF_NUMBER_TABLE
249: , p6_a7 out nocopy JTF_DATE_TABLE
250: , p6_a8 out nocopy JTF_NUMBER_TABLE
251: , p6_a9 out nocopy JTF_DATE_TABLE
252: , p6_a10 out nocopy JTF_NUMBER_TABLE
253: );
254: procedure update_ptl_qualitys(p_api_version NUMBER
255: , p_init_msg_list VARCHAR2
256: , x_return_status out nocopy VARCHAR2

Line 287: , p5_a0 JTF_NUMBER_TABLE

283: , p_init_msg_list VARCHAR2
284: , x_return_status out nocopy VARCHAR2
285: , x_msg_count out nocopy NUMBER
286: , x_msg_data out nocopy VARCHAR2
287: , p5_a0 JTF_NUMBER_TABLE
288: , p5_a1 JTF_NUMBER_TABLE
289: , p5_a2 JTF_VARCHAR2_TABLE_200
290: , p5_a3 JTF_VARCHAR2_TABLE_2000
291: , p5_a4 JTF_DATE_TABLE

Line 288: , p5_a1 JTF_NUMBER_TABLE

284: , x_return_status out nocopy VARCHAR2
285: , x_msg_count out nocopy NUMBER
286: , x_msg_data out nocopy VARCHAR2
287: , p5_a0 JTF_NUMBER_TABLE
288: , p5_a1 JTF_NUMBER_TABLE
289: , p5_a2 JTF_VARCHAR2_TABLE_200
290: , p5_a3 JTF_VARCHAR2_TABLE_2000
291: , p5_a4 JTF_DATE_TABLE
292: , p5_a5 JTF_DATE_TABLE

Line 293: , p5_a6 JTF_NUMBER_TABLE

289: , p5_a2 JTF_VARCHAR2_TABLE_200
290: , p5_a3 JTF_VARCHAR2_TABLE_2000
291: , p5_a4 JTF_DATE_TABLE
292: , p5_a5 JTF_DATE_TABLE
293: , p5_a6 JTF_NUMBER_TABLE
294: , p5_a7 JTF_DATE_TABLE
295: , p5_a8 JTF_NUMBER_TABLE
296: , p5_a9 JTF_DATE_TABLE
297: , p5_a10 JTF_NUMBER_TABLE

Line 295: , p5_a8 JTF_NUMBER_TABLE

291: , p5_a4 JTF_DATE_TABLE
292: , p5_a5 JTF_DATE_TABLE
293: , p5_a6 JTF_NUMBER_TABLE
294: , p5_a7 JTF_DATE_TABLE
295: , p5_a8 JTF_NUMBER_TABLE
296: , p5_a9 JTF_DATE_TABLE
297: , p5_a10 JTF_NUMBER_TABLE
298: );
299: procedure delete_ptl_qualitys(p_api_version NUMBER

Line 297: , p5_a10 JTF_NUMBER_TABLE

293: , p5_a6 JTF_NUMBER_TABLE
294: , p5_a7 JTF_DATE_TABLE
295: , p5_a8 JTF_NUMBER_TABLE
296: , p5_a9 JTF_DATE_TABLE
297: , p5_a10 JTF_NUMBER_TABLE
298: );
299: procedure delete_ptl_qualitys(p_api_version NUMBER
300: , p_init_msg_list VARCHAR2
301: , x_return_status out nocopy VARCHAR2

Line 321: , p5_a0 JTF_NUMBER_TABLE

317: , p_init_msg_list VARCHAR2
318: , x_return_status out nocopy VARCHAR2
319: , x_msg_count out nocopy NUMBER
320: , x_msg_data out nocopy VARCHAR2
321: , p5_a0 JTF_NUMBER_TABLE
322: , p5_a1 JTF_NUMBER_TABLE
323: , p5_a2 JTF_VARCHAR2_TABLE_200
324: , p5_a3 JTF_VARCHAR2_TABLE_2000
325: , p5_a4 JTF_DATE_TABLE

Line 322: , p5_a1 JTF_NUMBER_TABLE

318: , x_return_status out nocopy VARCHAR2
319: , x_msg_count out nocopy NUMBER
320: , x_msg_data out nocopy VARCHAR2
321: , p5_a0 JTF_NUMBER_TABLE
322: , p5_a1 JTF_NUMBER_TABLE
323: , p5_a2 JTF_VARCHAR2_TABLE_200
324: , p5_a3 JTF_VARCHAR2_TABLE_2000
325: , p5_a4 JTF_DATE_TABLE
326: , p5_a5 JTF_DATE_TABLE

Line 327: , p5_a6 JTF_NUMBER_TABLE

323: , p5_a2 JTF_VARCHAR2_TABLE_200
324: , p5_a3 JTF_VARCHAR2_TABLE_2000
325: , p5_a4 JTF_DATE_TABLE
326: , p5_a5 JTF_DATE_TABLE
327: , p5_a6 JTF_NUMBER_TABLE
328: , p5_a7 JTF_DATE_TABLE
329: , p5_a8 JTF_NUMBER_TABLE
330: , p5_a9 JTF_DATE_TABLE
331: , p5_a10 JTF_NUMBER_TABLE

Line 329: , p5_a8 JTF_NUMBER_TABLE

325: , p5_a4 JTF_DATE_TABLE
326: , p5_a5 JTF_DATE_TABLE
327: , p5_a6 JTF_NUMBER_TABLE
328: , p5_a7 JTF_DATE_TABLE
329: , p5_a8 JTF_NUMBER_TABLE
330: , p5_a9 JTF_DATE_TABLE
331: , p5_a10 JTF_NUMBER_TABLE
332: );
333: procedure validate_ptl_qualitys(p_api_version NUMBER

Line 331: , p5_a10 JTF_NUMBER_TABLE

327: , p5_a6 JTF_NUMBER_TABLE
328: , p5_a7 JTF_DATE_TABLE
329: , p5_a8 JTF_NUMBER_TABLE
330: , p5_a9 JTF_DATE_TABLE
331: , p5_a10 JTF_NUMBER_TABLE
332: );
333: procedure validate_ptl_qualitys(p_api_version NUMBER
334: , p_init_msg_list VARCHAR2
335: , x_return_status out nocopy VARCHAR2

Line 355: , p5_a0 JTF_NUMBER_TABLE

351: , p_init_msg_list VARCHAR2
352: , x_return_status out nocopy VARCHAR2
353: , x_msg_count out nocopy NUMBER
354: , x_msg_data out nocopy VARCHAR2
355: , p5_a0 JTF_NUMBER_TABLE
356: , p5_a1 JTF_NUMBER_TABLE
357: , p5_a2 JTF_NUMBER_TABLE
358: , p5_a3 JTF_VARCHAR2_TABLE_200
359: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 356: , p5_a1 JTF_NUMBER_TABLE

352: , x_return_status out nocopy VARCHAR2
353: , x_msg_count out nocopy NUMBER
354: , x_msg_data out nocopy VARCHAR2
355: , p5_a0 JTF_NUMBER_TABLE
356: , p5_a1 JTF_NUMBER_TABLE
357: , p5_a2 JTF_NUMBER_TABLE
358: , p5_a3 JTF_VARCHAR2_TABLE_200
359: , p5_a4 JTF_VARCHAR2_TABLE_2000
360: , p5_a5 JTF_DATE_TABLE

Line 357: , p5_a2 JTF_NUMBER_TABLE

353: , x_msg_count out nocopy NUMBER
354: , x_msg_data out nocopy VARCHAR2
355: , p5_a0 JTF_NUMBER_TABLE
356: , p5_a1 JTF_NUMBER_TABLE
357: , p5_a2 JTF_NUMBER_TABLE
358: , p5_a3 JTF_VARCHAR2_TABLE_200
359: , p5_a4 JTF_VARCHAR2_TABLE_2000
360: , p5_a5 JTF_DATE_TABLE
361: , p5_a6 JTF_DATE_TABLE

Line 362: , p5_a7 JTF_NUMBER_TABLE

358: , p5_a3 JTF_VARCHAR2_TABLE_200
359: , p5_a4 JTF_VARCHAR2_TABLE_2000
360: , p5_a5 JTF_DATE_TABLE
361: , p5_a6 JTF_DATE_TABLE
362: , p5_a7 JTF_NUMBER_TABLE
363: , p5_a8 JTF_DATE_TABLE
364: , p5_a9 JTF_NUMBER_TABLE
365: , p5_a10 JTF_DATE_TABLE
366: , p5_a11 JTF_NUMBER_TABLE

Line 364: , p5_a9 JTF_NUMBER_TABLE

360: , p5_a5 JTF_DATE_TABLE
361: , p5_a6 JTF_DATE_TABLE
362: , p5_a7 JTF_NUMBER_TABLE
363: , p5_a8 JTF_DATE_TABLE
364: , p5_a9 JTF_NUMBER_TABLE
365: , p5_a10 JTF_DATE_TABLE
366: , p5_a11 JTF_NUMBER_TABLE
367: , p6_a0 out nocopy JTF_NUMBER_TABLE
368: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 366: , p5_a11 JTF_NUMBER_TABLE

362: , p5_a7 JTF_NUMBER_TABLE
363: , p5_a8 JTF_DATE_TABLE
364: , p5_a9 JTF_NUMBER_TABLE
365: , p5_a10 JTF_DATE_TABLE
366: , p5_a11 JTF_NUMBER_TABLE
367: , p6_a0 out nocopy JTF_NUMBER_TABLE
368: , p6_a1 out nocopy JTF_NUMBER_TABLE
369: , p6_a2 out nocopy JTF_NUMBER_TABLE
370: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 367: , p6_a0 out nocopy JTF_NUMBER_TABLE

363: , p5_a8 JTF_DATE_TABLE
364: , p5_a9 JTF_NUMBER_TABLE
365: , p5_a10 JTF_DATE_TABLE
366: , p5_a11 JTF_NUMBER_TABLE
367: , p6_a0 out nocopy JTF_NUMBER_TABLE
368: , p6_a1 out nocopy JTF_NUMBER_TABLE
369: , p6_a2 out nocopy JTF_NUMBER_TABLE
370: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
371: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 368: , p6_a1 out nocopy JTF_NUMBER_TABLE

364: , p5_a9 JTF_NUMBER_TABLE
365: , p5_a10 JTF_DATE_TABLE
366: , p5_a11 JTF_NUMBER_TABLE
367: , p6_a0 out nocopy JTF_NUMBER_TABLE
368: , p6_a1 out nocopy JTF_NUMBER_TABLE
369: , p6_a2 out nocopy JTF_NUMBER_TABLE
370: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
371: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
372: , p6_a5 out nocopy JTF_DATE_TABLE

Line 369: , p6_a2 out nocopy JTF_NUMBER_TABLE

365: , p5_a10 JTF_DATE_TABLE
366: , p5_a11 JTF_NUMBER_TABLE
367: , p6_a0 out nocopy JTF_NUMBER_TABLE
368: , p6_a1 out nocopy JTF_NUMBER_TABLE
369: , p6_a2 out nocopy JTF_NUMBER_TABLE
370: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
371: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
372: , p6_a5 out nocopy JTF_DATE_TABLE
373: , p6_a6 out nocopy JTF_DATE_TABLE

Line 374: , p6_a7 out nocopy JTF_NUMBER_TABLE

370: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
371: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
372: , p6_a5 out nocopy JTF_DATE_TABLE
373: , p6_a6 out nocopy JTF_DATE_TABLE
374: , p6_a7 out nocopy JTF_NUMBER_TABLE
375: , p6_a8 out nocopy JTF_DATE_TABLE
376: , p6_a9 out nocopy JTF_NUMBER_TABLE
377: , p6_a10 out nocopy JTF_DATE_TABLE
378: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 376: , p6_a9 out nocopy JTF_NUMBER_TABLE

372: , p6_a5 out nocopy JTF_DATE_TABLE
373: , p6_a6 out nocopy JTF_DATE_TABLE
374: , p6_a7 out nocopy JTF_NUMBER_TABLE
375: , p6_a8 out nocopy JTF_DATE_TABLE
376: , p6_a9 out nocopy JTF_NUMBER_TABLE
377: , p6_a10 out nocopy JTF_DATE_TABLE
378: , p6_a11 out nocopy JTF_NUMBER_TABLE
379: );
380: procedure create_ptl_qlty_values(p_api_version NUMBER

Line 378: , p6_a11 out nocopy JTF_NUMBER_TABLE

374: , p6_a7 out nocopy JTF_NUMBER_TABLE
375: , p6_a8 out nocopy JTF_DATE_TABLE
376: , p6_a9 out nocopy JTF_NUMBER_TABLE
377: , p6_a10 out nocopy JTF_DATE_TABLE
378: , p6_a11 out nocopy JTF_NUMBER_TABLE
379: );
380: procedure create_ptl_qlty_values(p_api_version NUMBER
381: , p_init_msg_list VARCHAR2
382: , x_return_status out nocopy VARCHAR2

Line 415: , p5_a0 JTF_NUMBER_TABLE

411: , p_init_msg_list VARCHAR2
412: , x_return_status out nocopy VARCHAR2
413: , x_msg_count out nocopy NUMBER
414: , x_msg_data out nocopy VARCHAR2
415: , p5_a0 JTF_NUMBER_TABLE
416: , p5_a1 JTF_NUMBER_TABLE
417: , p5_a2 JTF_NUMBER_TABLE
418: , p5_a3 JTF_VARCHAR2_TABLE_200
419: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 416: , p5_a1 JTF_NUMBER_TABLE

412: , x_return_status out nocopy VARCHAR2
413: , x_msg_count out nocopy NUMBER
414: , x_msg_data out nocopy VARCHAR2
415: , p5_a0 JTF_NUMBER_TABLE
416: , p5_a1 JTF_NUMBER_TABLE
417: , p5_a2 JTF_NUMBER_TABLE
418: , p5_a3 JTF_VARCHAR2_TABLE_200
419: , p5_a4 JTF_VARCHAR2_TABLE_2000
420: , p5_a5 JTF_DATE_TABLE

Line 417: , p5_a2 JTF_NUMBER_TABLE

413: , x_msg_count out nocopy NUMBER
414: , x_msg_data out nocopy VARCHAR2
415: , p5_a0 JTF_NUMBER_TABLE
416: , p5_a1 JTF_NUMBER_TABLE
417: , p5_a2 JTF_NUMBER_TABLE
418: , p5_a3 JTF_VARCHAR2_TABLE_200
419: , p5_a4 JTF_VARCHAR2_TABLE_2000
420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_DATE_TABLE

Line 422: , p5_a7 JTF_NUMBER_TABLE

418: , p5_a3 JTF_VARCHAR2_TABLE_200
419: , p5_a4 JTF_VARCHAR2_TABLE_2000
420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_DATE_TABLE
422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_DATE_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_DATE_TABLE
426: , p5_a11 JTF_NUMBER_TABLE

Line 424: , p5_a9 JTF_NUMBER_TABLE

420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_DATE_TABLE
422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_DATE_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_DATE_TABLE
426: , p5_a11 JTF_NUMBER_TABLE
427: );
428: procedure lock_ptl_qlty_values(p_api_version NUMBER

Line 426: , p5_a11 JTF_NUMBER_TABLE

422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_DATE_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_DATE_TABLE
426: , p5_a11 JTF_NUMBER_TABLE
427: );
428: procedure lock_ptl_qlty_values(p_api_version NUMBER
429: , p_init_msg_list VARCHAR2
430: , x_return_status out nocopy VARCHAR2

Line 451: , p5_a0 JTF_NUMBER_TABLE

447: , p_init_msg_list VARCHAR2
448: , x_return_status out nocopy VARCHAR2
449: , x_msg_count out nocopy NUMBER
450: , x_msg_data out nocopy VARCHAR2
451: , p5_a0 JTF_NUMBER_TABLE
452: , p5_a1 JTF_NUMBER_TABLE
453: , p5_a2 JTF_NUMBER_TABLE
454: , p5_a3 JTF_VARCHAR2_TABLE_200
455: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 452: , p5_a1 JTF_NUMBER_TABLE

448: , x_return_status out nocopy VARCHAR2
449: , x_msg_count out nocopy NUMBER
450: , x_msg_data out nocopy VARCHAR2
451: , p5_a0 JTF_NUMBER_TABLE
452: , p5_a1 JTF_NUMBER_TABLE
453: , p5_a2 JTF_NUMBER_TABLE
454: , p5_a3 JTF_VARCHAR2_TABLE_200
455: , p5_a4 JTF_VARCHAR2_TABLE_2000
456: , p5_a5 JTF_DATE_TABLE

Line 453: , p5_a2 JTF_NUMBER_TABLE

449: , x_msg_count out nocopy NUMBER
450: , x_msg_data out nocopy VARCHAR2
451: , p5_a0 JTF_NUMBER_TABLE
452: , p5_a1 JTF_NUMBER_TABLE
453: , p5_a2 JTF_NUMBER_TABLE
454: , p5_a3 JTF_VARCHAR2_TABLE_200
455: , p5_a4 JTF_VARCHAR2_TABLE_2000
456: , p5_a5 JTF_DATE_TABLE
457: , p5_a6 JTF_DATE_TABLE

Line 458: , p5_a7 JTF_NUMBER_TABLE

454: , p5_a3 JTF_VARCHAR2_TABLE_200
455: , p5_a4 JTF_VARCHAR2_TABLE_2000
456: , p5_a5 JTF_DATE_TABLE
457: , p5_a6 JTF_DATE_TABLE
458: , p5_a7 JTF_NUMBER_TABLE
459: , p5_a8 JTF_DATE_TABLE
460: , p5_a9 JTF_NUMBER_TABLE
461: , p5_a10 JTF_DATE_TABLE
462: , p5_a11 JTF_NUMBER_TABLE

Line 460: , p5_a9 JTF_NUMBER_TABLE

456: , p5_a5 JTF_DATE_TABLE
457: , p5_a6 JTF_DATE_TABLE
458: , p5_a7 JTF_NUMBER_TABLE
459: , p5_a8 JTF_DATE_TABLE
460: , p5_a9 JTF_NUMBER_TABLE
461: , p5_a10 JTF_DATE_TABLE
462: , p5_a11 JTF_NUMBER_TABLE
463: , p6_a0 out nocopy JTF_NUMBER_TABLE
464: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 462: , p5_a11 JTF_NUMBER_TABLE

458: , p5_a7 JTF_NUMBER_TABLE
459: , p5_a8 JTF_DATE_TABLE
460: , p5_a9 JTF_NUMBER_TABLE
461: , p5_a10 JTF_DATE_TABLE
462: , p5_a11 JTF_NUMBER_TABLE
463: , p6_a0 out nocopy JTF_NUMBER_TABLE
464: , p6_a1 out nocopy JTF_NUMBER_TABLE
465: , p6_a2 out nocopy JTF_NUMBER_TABLE
466: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 463: , p6_a0 out nocopy JTF_NUMBER_TABLE

459: , p5_a8 JTF_DATE_TABLE
460: , p5_a9 JTF_NUMBER_TABLE
461: , p5_a10 JTF_DATE_TABLE
462: , p5_a11 JTF_NUMBER_TABLE
463: , p6_a0 out nocopy JTF_NUMBER_TABLE
464: , p6_a1 out nocopy JTF_NUMBER_TABLE
465: , p6_a2 out nocopy JTF_NUMBER_TABLE
466: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
467: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 464: , p6_a1 out nocopy JTF_NUMBER_TABLE

460: , p5_a9 JTF_NUMBER_TABLE
461: , p5_a10 JTF_DATE_TABLE
462: , p5_a11 JTF_NUMBER_TABLE
463: , p6_a0 out nocopy JTF_NUMBER_TABLE
464: , p6_a1 out nocopy JTF_NUMBER_TABLE
465: , p6_a2 out nocopy JTF_NUMBER_TABLE
466: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
467: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
468: , p6_a5 out nocopy JTF_DATE_TABLE

Line 465: , p6_a2 out nocopy JTF_NUMBER_TABLE

461: , p5_a10 JTF_DATE_TABLE
462: , p5_a11 JTF_NUMBER_TABLE
463: , p6_a0 out nocopy JTF_NUMBER_TABLE
464: , p6_a1 out nocopy JTF_NUMBER_TABLE
465: , p6_a2 out nocopy JTF_NUMBER_TABLE
466: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
467: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
468: , p6_a5 out nocopy JTF_DATE_TABLE
469: , p6_a6 out nocopy JTF_DATE_TABLE

Line 470: , p6_a7 out nocopy JTF_NUMBER_TABLE

466: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
467: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
468: , p6_a5 out nocopy JTF_DATE_TABLE
469: , p6_a6 out nocopy JTF_DATE_TABLE
470: , p6_a7 out nocopy JTF_NUMBER_TABLE
471: , p6_a8 out nocopy JTF_DATE_TABLE
472: , p6_a9 out nocopy JTF_NUMBER_TABLE
473: , p6_a10 out nocopy JTF_DATE_TABLE
474: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 472: , p6_a9 out nocopy JTF_NUMBER_TABLE

468: , p6_a5 out nocopy JTF_DATE_TABLE
469: , p6_a6 out nocopy JTF_DATE_TABLE
470: , p6_a7 out nocopy JTF_NUMBER_TABLE
471: , p6_a8 out nocopy JTF_DATE_TABLE
472: , p6_a9 out nocopy JTF_NUMBER_TABLE
473: , p6_a10 out nocopy JTF_DATE_TABLE
474: , p6_a11 out nocopy JTF_NUMBER_TABLE
475: );
476: procedure update_ptl_qlty_values(p_api_version NUMBER

Line 474: , p6_a11 out nocopy JTF_NUMBER_TABLE

470: , p6_a7 out nocopy JTF_NUMBER_TABLE
471: , p6_a8 out nocopy JTF_DATE_TABLE
472: , p6_a9 out nocopy JTF_NUMBER_TABLE
473: , p6_a10 out nocopy JTF_DATE_TABLE
474: , p6_a11 out nocopy JTF_NUMBER_TABLE
475: );
476: procedure update_ptl_qlty_values(p_api_version NUMBER
477: , p_init_msg_list VARCHAR2
478: , x_return_status out nocopy VARCHAR2

Line 511: , p5_a0 JTF_NUMBER_TABLE

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

Line 512: , p5_a1 JTF_NUMBER_TABLE

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

Line 513: , p5_a2 JTF_NUMBER_TABLE

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

Line 518: , p5_a7 JTF_NUMBER_TABLE

514: , p5_a3 JTF_VARCHAR2_TABLE_200
515: , p5_a4 JTF_VARCHAR2_TABLE_2000
516: , p5_a5 JTF_DATE_TABLE
517: , p5_a6 JTF_DATE_TABLE
518: , p5_a7 JTF_NUMBER_TABLE
519: , p5_a8 JTF_DATE_TABLE
520: , p5_a9 JTF_NUMBER_TABLE
521: , p5_a10 JTF_DATE_TABLE
522: , p5_a11 JTF_NUMBER_TABLE

Line 520: , p5_a9 JTF_NUMBER_TABLE

516: , p5_a5 JTF_DATE_TABLE
517: , p5_a6 JTF_DATE_TABLE
518: , p5_a7 JTF_NUMBER_TABLE
519: , p5_a8 JTF_DATE_TABLE
520: , p5_a9 JTF_NUMBER_TABLE
521: , p5_a10 JTF_DATE_TABLE
522: , p5_a11 JTF_NUMBER_TABLE
523: );
524: procedure delete_ptl_qlty_values(p_api_version NUMBER

Line 522: , p5_a11 JTF_NUMBER_TABLE

518: , p5_a7 JTF_NUMBER_TABLE
519: , p5_a8 JTF_DATE_TABLE
520: , p5_a9 JTF_NUMBER_TABLE
521: , p5_a10 JTF_DATE_TABLE
522: , p5_a11 JTF_NUMBER_TABLE
523: );
524: procedure delete_ptl_qlty_values(p_api_version NUMBER
525: , p_init_msg_list VARCHAR2
526: , x_return_status out nocopy VARCHAR2

Line 547: , p5_a0 JTF_NUMBER_TABLE

543: , p_init_msg_list VARCHAR2
544: , x_return_status out nocopy VARCHAR2
545: , x_msg_count out nocopy NUMBER
546: , x_msg_data out nocopy VARCHAR2
547: , p5_a0 JTF_NUMBER_TABLE
548: , p5_a1 JTF_NUMBER_TABLE
549: , p5_a2 JTF_NUMBER_TABLE
550: , p5_a3 JTF_VARCHAR2_TABLE_200
551: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 548: , p5_a1 JTF_NUMBER_TABLE

544: , x_return_status out nocopy VARCHAR2
545: , x_msg_count out nocopy NUMBER
546: , x_msg_data out nocopy VARCHAR2
547: , p5_a0 JTF_NUMBER_TABLE
548: , p5_a1 JTF_NUMBER_TABLE
549: , p5_a2 JTF_NUMBER_TABLE
550: , p5_a3 JTF_VARCHAR2_TABLE_200
551: , p5_a4 JTF_VARCHAR2_TABLE_2000
552: , p5_a5 JTF_DATE_TABLE

Line 549: , p5_a2 JTF_NUMBER_TABLE

545: , x_msg_count out nocopy NUMBER
546: , x_msg_data out nocopy VARCHAR2
547: , p5_a0 JTF_NUMBER_TABLE
548: , p5_a1 JTF_NUMBER_TABLE
549: , p5_a2 JTF_NUMBER_TABLE
550: , p5_a3 JTF_VARCHAR2_TABLE_200
551: , p5_a4 JTF_VARCHAR2_TABLE_2000
552: , p5_a5 JTF_DATE_TABLE
553: , p5_a6 JTF_DATE_TABLE

Line 554: , p5_a7 JTF_NUMBER_TABLE

550: , p5_a3 JTF_VARCHAR2_TABLE_200
551: , p5_a4 JTF_VARCHAR2_TABLE_2000
552: , p5_a5 JTF_DATE_TABLE
553: , p5_a6 JTF_DATE_TABLE
554: , p5_a7 JTF_NUMBER_TABLE
555: , p5_a8 JTF_DATE_TABLE
556: , p5_a9 JTF_NUMBER_TABLE
557: , p5_a10 JTF_DATE_TABLE
558: , p5_a11 JTF_NUMBER_TABLE

Line 556: , p5_a9 JTF_NUMBER_TABLE

552: , p5_a5 JTF_DATE_TABLE
553: , p5_a6 JTF_DATE_TABLE
554: , p5_a7 JTF_NUMBER_TABLE
555: , p5_a8 JTF_DATE_TABLE
556: , p5_a9 JTF_NUMBER_TABLE
557: , p5_a10 JTF_DATE_TABLE
558: , p5_a11 JTF_NUMBER_TABLE
559: );
560: procedure validate_ptl_qlty_values(p_api_version NUMBER

Line 558: , p5_a11 JTF_NUMBER_TABLE

554: , p5_a7 JTF_NUMBER_TABLE
555: , p5_a8 JTF_DATE_TABLE
556: , p5_a9 JTF_NUMBER_TABLE
557: , p5_a10 JTF_DATE_TABLE
558: , p5_a11 JTF_NUMBER_TABLE
559: );
560: procedure validate_ptl_qlty_values(p_api_version NUMBER
561: , p_init_msg_list VARCHAR2
562: , x_return_status out nocopy VARCHAR2