DBA Data[Home] [Help]

APPS.OKL_PDT_QUALITYS_PVT_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 32: , p8_a0 out nocopy JTF_NUMBER_TABLE

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

Line 33: , p8_a1 out nocopy JTF_NUMBER_TABLE

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

Line 34: , p8_a2 out nocopy JTF_NUMBER_TABLE

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

Line 39: , p8_a7 out nocopy JTF_NUMBER_TABLE

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

Line 41: , p8_a9 out nocopy JTF_NUMBER_TABLE

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

Line 43: , p8_a11 out nocopy JTF_NUMBER_TABLE

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

Line 62: , p6_a0 JTF_NUMBER_TABLE

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

Line 63: , p6_a1 JTF_NUMBER_TABLE

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

Line 64: , p6_a2 JTF_NUMBER_TABLE

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

Line 69: , p6_a7 JTF_NUMBER_TABLE

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

Line 71: , p6_a9 JTF_NUMBER_TABLE

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

Line 73: , p6_a11 JTF_NUMBER_TABLE

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

Line 86: , p8_a0 out nocopy JTF_NUMBER_TABLE

82: , p7_a8 out nocopy DATE
83: , p7_a9 out nocopy NUMBER
84: , p7_a10 out nocopy DATE
85: , p7_a11 out nocopy NUMBER
86: , p8_a0 out nocopy JTF_NUMBER_TABLE
87: , p8_a1 out nocopy JTF_NUMBER_TABLE
88: , p8_a2 out nocopy JTF_NUMBER_TABLE
89: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
90: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 87: , p8_a1 out nocopy JTF_NUMBER_TABLE

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

Line 88: , p8_a2 out nocopy JTF_NUMBER_TABLE

84: , p7_a10 out nocopy DATE
85: , p7_a11 out nocopy NUMBER
86: , p8_a0 out nocopy JTF_NUMBER_TABLE
87: , p8_a1 out nocopy JTF_NUMBER_TABLE
88: , p8_a2 out nocopy JTF_NUMBER_TABLE
89: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
90: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
91: , p8_a5 out nocopy JTF_DATE_TABLE
92: , p8_a6 out nocopy JTF_DATE_TABLE

Line 93: , p8_a7 out nocopy JTF_NUMBER_TABLE

89: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
90: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
91: , p8_a5 out nocopy JTF_DATE_TABLE
92: , p8_a6 out nocopy JTF_DATE_TABLE
93: , p8_a7 out nocopy JTF_NUMBER_TABLE
94: , p8_a8 out nocopy JTF_DATE_TABLE
95: , p8_a9 out nocopy JTF_NUMBER_TABLE
96: , p8_a10 out nocopy JTF_DATE_TABLE
97: , p8_a11 out nocopy JTF_NUMBER_TABLE

Line 95: , p8_a9 out nocopy JTF_NUMBER_TABLE

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

Line 97: , p8_a11 out nocopy JTF_NUMBER_TABLE

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

Line 116: , p6_a0 JTF_NUMBER_TABLE

112: , p_init_msg_list VARCHAR2
113: , x_return_status out nocopy VARCHAR2
114: , x_msg_count out nocopy NUMBER
115: , x_msg_data out nocopy VARCHAR2
116: , p6_a0 JTF_NUMBER_TABLE
117: , p6_a1 JTF_NUMBER_TABLE
118: , p6_a2 JTF_NUMBER_TABLE
119: , p6_a3 JTF_VARCHAR2_TABLE_200
120: , p6_a4 JTF_VARCHAR2_TABLE_2000

Line 117: , p6_a1 JTF_NUMBER_TABLE

113: , x_return_status out nocopy VARCHAR2
114: , x_msg_count out nocopy NUMBER
115: , x_msg_data out nocopy VARCHAR2
116: , p6_a0 JTF_NUMBER_TABLE
117: , p6_a1 JTF_NUMBER_TABLE
118: , p6_a2 JTF_NUMBER_TABLE
119: , p6_a3 JTF_VARCHAR2_TABLE_200
120: , p6_a4 JTF_VARCHAR2_TABLE_2000
121: , p6_a5 JTF_DATE_TABLE

Line 118: , p6_a2 JTF_NUMBER_TABLE

114: , x_msg_count out nocopy NUMBER
115: , x_msg_data out nocopy VARCHAR2
116: , p6_a0 JTF_NUMBER_TABLE
117: , p6_a1 JTF_NUMBER_TABLE
118: , p6_a2 JTF_NUMBER_TABLE
119: , p6_a3 JTF_VARCHAR2_TABLE_200
120: , p6_a4 JTF_VARCHAR2_TABLE_2000
121: , p6_a5 JTF_DATE_TABLE
122: , p6_a6 JTF_DATE_TABLE

Line 123: , p6_a7 JTF_NUMBER_TABLE

119: , p6_a3 JTF_VARCHAR2_TABLE_200
120: , p6_a4 JTF_VARCHAR2_TABLE_2000
121: , p6_a5 JTF_DATE_TABLE
122: , p6_a6 JTF_DATE_TABLE
123: , p6_a7 JTF_NUMBER_TABLE
124: , p6_a8 JTF_DATE_TABLE
125: , p6_a9 JTF_NUMBER_TABLE
126: , p6_a10 JTF_DATE_TABLE
127: , p6_a11 JTF_NUMBER_TABLE

Line 125: , p6_a9 JTF_NUMBER_TABLE

121: , p6_a5 JTF_DATE_TABLE
122: , p6_a6 JTF_DATE_TABLE
123: , p6_a7 JTF_NUMBER_TABLE
124: , p6_a8 JTF_DATE_TABLE
125: , p6_a9 JTF_NUMBER_TABLE
126: , p6_a10 JTF_DATE_TABLE
127: , p6_a11 JTF_NUMBER_TABLE
128: , p5_a0 NUMBER := 0-1962.0724
129: , p5_a1 NUMBER := 0-1962.0724

Line 127: , p6_a11 JTF_NUMBER_TABLE

123: , p6_a7 JTF_NUMBER_TABLE
124: , p6_a8 JTF_DATE_TABLE
125: , p6_a9 JTF_NUMBER_TABLE
126: , p6_a10 JTF_DATE_TABLE
127: , p6_a11 JTF_NUMBER_TABLE
128: , p5_a0 NUMBER := 0-1962.0724
129: , p5_a1 NUMBER := 0-1962.0724
130: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

Line 146: , p5_a0 JTF_NUMBER_TABLE

142: , p_init_msg_list VARCHAR2
143: , x_return_status out nocopy VARCHAR2
144: , x_msg_count out nocopy NUMBER
145: , x_msg_data out nocopy VARCHAR2
146: , p5_a0 JTF_NUMBER_TABLE
147: , p5_a1 JTF_NUMBER_TABLE
148: , p5_a2 JTF_VARCHAR2_TABLE_200
149: , p5_a3 JTF_VARCHAR2_TABLE_2000
150: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 147: , p5_a1 JTF_NUMBER_TABLE

143: , x_return_status out nocopy VARCHAR2
144: , x_msg_count out nocopy NUMBER
145: , x_msg_data out nocopy VARCHAR2
146: , p5_a0 JTF_NUMBER_TABLE
147: , p5_a1 JTF_NUMBER_TABLE
148: , p5_a2 JTF_VARCHAR2_TABLE_200
149: , p5_a3 JTF_VARCHAR2_TABLE_2000
150: , p5_a4 JTF_VARCHAR2_TABLE_100
151: , p5_a5 JTF_DATE_TABLE

Line 153: , p5_a7 JTF_NUMBER_TABLE

149: , p5_a3 JTF_VARCHAR2_TABLE_2000
150: , p5_a4 JTF_VARCHAR2_TABLE_100
151: , p5_a5 JTF_DATE_TABLE
152: , p5_a6 JTF_DATE_TABLE
153: , p5_a7 JTF_NUMBER_TABLE
154: , p5_a8 JTF_DATE_TABLE
155: , p5_a9 JTF_NUMBER_TABLE
156: , p5_a10 JTF_DATE_TABLE
157: , p5_a11 JTF_NUMBER_TABLE

Line 155: , p5_a9 JTF_NUMBER_TABLE

151: , p5_a5 JTF_DATE_TABLE
152: , p5_a6 JTF_DATE_TABLE
153: , p5_a7 JTF_NUMBER_TABLE
154: , p5_a8 JTF_DATE_TABLE
155: , p5_a9 JTF_NUMBER_TABLE
156: , p5_a10 JTF_DATE_TABLE
157: , p5_a11 JTF_NUMBER_TABLE
158: , p6_a0 out nocopy JTF_NUMBER_TABLE
159: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 157: , p5_a11 JTF_NUMBER_TABLE

153: , p5_a7 JTF_NUMBER_TABLE
154: , p5_a8 JTF_DATE_TABLE
155: , p5_a9 JTF_NUMBER_TABLE
156: , p5_a10 JTF_DATE_TABLE
157: , p5_a11 JTF_NUMBER_TABLE
158: , p6_a0 out nocopy JTF_NUMBER_TABLE
159: , p6_a1 out nocopy JTF_NUMBER_TABLE
160: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 158: , p6_a0 out nocopy JTF_NUMBER_TABLE

154: , p5_a8 JTF_DATE_TABLE
155: , p5_a9 JTF_NUMBER_TABLE
156: , p5_a10 JTF_DATE_TABLE
157: , p5_a11 JTF_NUMBER_TABLE
158: , p6_a0 out nocopy JTF_NUMBER_TABLE
159: , p6_a1 out nocopy JTF_NUMBER_TABLE
160: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
162: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 159: , p6_a1 out nocopy JTF_NUMBER_TABLE

155: , p5_a9 JTF_NUMBER_TABLE
156: , p5_a10 JTF_DATE_TABLE
157: , p5_a11 JTF_NUMBER_TABLE
158: , p6_a0 out nocopy JTF_NUMBER_TABLE
159: , p6_a1 out nocopy JTF_NUMBER_TABLE
160: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
162: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , p6_a5 out nocopy JTF_DATE_TABLE

Line 165: , p6_a7 out nocopy JTF_NUMBER_TABLE

161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
162: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , p6_a5 out nocopy JTF_DATE_TABLE
164: , p6_a6 out nocopy JTF_DATE_TABLE
165: , p6_a7 out nocopy JTF_NUMBER_TABLE
166: , p6_a8 out nocopy JTF_DATE_TABLE
167: , p6_a9 out nocopy JTF_NUMBER_TABLE
168: , p6_a10 out nocopy JTF_DATE_TABLE
169: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 167: , p6_a9 out nocopy JTF_NUMBER_TABLE

163: , p6_a5 out nocopy JTF_DATE_TABLE
164: , p6_a6 out nocopy JTF_DATE_TABLE
165: , p6_a7 out nocopy JTF_NUMBER_TABLE
166: , p6_a8 out nocopy JTF_DATE_TABLE
167: , p6_a9 out nocopy JTF_NUMBER_TABLE
168: , p6_a10 out nocopy JTF_DATE_TABLE
169: , p6_a11 out nocopy JTF_NUMBER_TABLE
170: );
171: procedure create_pdt_qualitys(p_api_version NUMBER

Line 169: , p6_a11 out nocopy JTF_NUMBER_TABLE

165: , p6_a7 out nocopy JTF_NUMBER_TABLE
166: , p6_a8 out nocopy JTF_DATE_TABLE
167: , p6_a9 out nocopy JTF_NUMBER_TABLE
168: , p6_a10 out nocopy JTF_DATE_TABLE
169: , p6_a11 out nocopy JTF_NUMBER_TABLE
170: );
171: procedure create_pdt_qualitys(p_api_version NUMBER
172: , p_init_msg_list VARCHAR2
173: , x_return_status out nocopy VARCHAR2

Line 206: , p5_a0 JTF_NUMBER_TABLE

202: , p_init_msg_list VARCHAR2
203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_VARCHAR2_TABLE_200
209: , p5_a3 JTF_VARCHAR2_TABLE_2000
210: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 207: , p5_a1 JTF_NUMBER_TABLE

203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_VARCHAR2_TABLE_200
209: , p5_a3 JTF_VARCHAR2_TABLE_2000
210: , p5_a4 JTF_VARCHAR2_TABLE_100
211: , p5_a5 JTF_DATE_TABLE

Line 213: , p5_a7 JTF_NUMBER_TABLE

209: , p5_a3 JTF_VARCHAR2_TABLE_2000
210: , p5_a4 JTF_VARCHAR2_TABLE_100
211: , p5_a5 JTF_DATE_TABLE
212: , p5_a6 JTF_DATE_TABLE
213: , p5_a7 JTF_NUMBER_TABLE
214: , p5_a8 JTF_DATE_TABLE
215: , p5_a9 JTF_NUMBER_TABLE
216: , p5_a10 JTF_DATE_TABLE
217: , p5_a11 JTF_NUMBER_TABLE

Line 215: , p5_a9 JTF_NUMBER_TABLE

211: , p5_a5 JTF_DATE_TABLE
212: , p5_a6 JTF_DATE_TABLE
213: , p5_a7 JTF_NUMBER_TABLE
214: , p5_a8 JTF_DATE_TABLE
215: , p5_a9 JTF_NUMBER_TABLE
216: , p5_a10 JTF_DATE_TABLE
217: , p5_a11 JTF_NUMBER_TABLE
218: );
219: procedure lock_pdt_qualitys(p_api_version NUMBER

Line 217: , p5_a11 JTF_NUMBER_TABLE

213: , p5_a7 JTF_NUMBER_TABLE
214: , p5_a8 JTF_DATE_TABLE
215: , p5_a9 JTF_NUMBER_TABLE
216: , p5_a10 JTF_DATE_TABLE
217: , p5_a11 JTF_NUMBER_TABLE
218: );
219: procedure lock_pdt_qualitys(p_api_version NUMBER
220: , p_init_msg_list VARCHAR2
221: , x_return_status out nocopy VARCHAR2

Line 242: , p5_a0 JTF_NUMBER_TABLE

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

Line 243: , p5_a1 JTF_NUMBER_TABLE

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

Line 249: , p5_a7 JTF_NUMBER_TABLE

245: , p5_a3 JTF_VARCHAR2_TABLE_2000
246: , p5_a4 JTF_VARCHAR2_TABLE_100
247: , p5_a5 JTF_DATE_TABLE
248: , p5_a6 JTF_DATE_TABLE
249: , p5_a7 JTF_NUMBER_TABLE
250: , p5_a8 JTF_DATE_TABLE
251: , p5_a9 JTF_NUMBER_TABLE
252: , p5_a10 JTF_DATE_TABLE
253: , p5_a11 JTF_NUMBER_TABLE

Line 251: , p5_a9 JTF_NUMBER_TABLE

247: , p5_a5 JTF_DATE_TABLE
248: , p5_a6 JTF_DATE_TABLE
249: , p5_a7 JTF_NUMBER_TABLE
250: , p5_a8 JTF_DATE_TABLE
251: , p5_a9 JTF_NUMBER_TABLE
252: , p5_a10 JTF_DATE_TABLE
253: , p5_a11 JTF_NUMBER_TABLE
254: , p6_a0 out nocopy JTF_NUMBER_TABLE
255: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 253: , p5_a11 JTF_NUMBER_TABLE

249: , p5_a7 JTF_NUMBER_TABLE
250: , p5_a8 JTF_DATE_TABLE
251: , p5_a9 JTF_NUMBER_TABLE
252: , p5_a10 JTF_DATE_TABLE
253: , p5_a11 JTF_NUMBER_TABLE
254: , p6_a0 out nocopy JTF_NUMBER_TABLE
255: , p6_a1 out nocopy JTF_NUMBER_TABLE
256: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
257: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 254: , p6_a0 out nocopy JTF_NUMBER_TABLE

250: , p5_a8 JTF_DATE_TABLE
251: , p5_a9 JTF_NUMBER_TABLE
252: , p5_a10 JTF_DATE_TABLE
253: , p5_a11 JTF_NUMBER_TABLE
254: , p6_a0 out nocopy JTF_NUMBER_TABLE
255: , p6_a1 out nocopy JTF_NUMBER_TABLE
256: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
257: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
258: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 255: , p6_a1 out nocopy JTF_NUMBER_TABLE

251: , p5_a9 JTF_NUMBER_TABLE
252: , p5_a10 JTF_DATE_TABLE
253: , p5_a11 JTF_NUMBER_TABLE
254: , p6_a0 out nocopy JTF_NUMBER_TABLE
255: , p6_a1 out nocopy JTF_NUMBER_TABLE
256: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
257: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
258: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a5 out nocopy JTF_DATE_TABLE

Line 261: , p6_a7 out nocopy JTF_NUMBER_TABLE

257: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
258: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a5 out nocopy JTF_DATE_TABLE
260: , p6_a6 out nocopy JTF_DATE_TABLE
261: , p6_a7 out nocopy JTF_NUMBER_TABLE
262: , p6_a8 out nocopy JTF_DATE_TABLE
263: , p6_a9 out nocopy JTF_NUMBER_TABLE
264: , p6_a10 out nocopy JTF_DATE_TABLE
265: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 263: , p6_a9 out nocopy JTF_NUMBER_TABLE

259: , p6_a5 out nocopy JTF_DATE_TABLE
260: , p6_a6 out nocopy JTF_DATE_TABLE
261: , p6_a7 out nocopy JTF_NUMBER_TABLE
262: , p6_a8 out nocopy JTF_DATE_TABLE
263: , p6_a9 out nocopy JTF_NUMBER_TABLE
264: , p6_a10 out nocopy JTF_DATE_TABLE
265: , p6_a11 out nocopy JTF_NUMBER_TABLE
266: );
267: procedure update_pdt_qualitys(p_api_version NUMBER

Line 265: , p6_a11 out nocopy JTF_NUMBER_TABLE

261: , p6_a7 out nocopy JTF_NUMBER_TABLE
262: , p6_a8 out nocopy JTF_DATE_TABLE
263: , p6_a9 out nocopy JTF_NUMBER_TABLE
264: , p6_a10 out nocopy JTF_DATE_TABLE
265: , p6_a11 out nocopy JTF_NUMBER_TABLE
266: );
267: procedure update_pdt_qualitys(p_api_version NUMBER
268: , p_init_msg_list VARCHAR2
269: , x_return_status out nocopy VARCHAR2

Line 302: , p5_a0 JTF_NUMBER_TABLE

298: , p_init_msg_list VARCHAR2
299: , x_return_status out nocopy VARCHAR2
300: , x_msg_count out nocopy NUMBER
301: , x_msg_data out nocopy VARCHAR2
302: , p5_a0 JTF_NUMBER_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_VARCHAR2_TABLE_200
305: , p5_a3 JTF_VARCHAR2_TABLE_2000
306: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 303: , p5_a1 JTF_NUMBER_TABLE

299: , x_return_status out nocopy VARCHAR2
300: , x_msg_count out nocopy NUMBER
301: , x_msg_data out nocopy VARCHAR2
302: , p5_a0 JTF_NUMBER_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_VARCHAR2_TABLE_200
305: , p5_a3 JTF_VARCHAR2_TABLE_2000
306: , p5_a4 JTF_VARCHAR2_TABLE_100
307: , p5_a5 JTF_DATE_TABLE

Line 309: , p5_a7 JTF_NUMBER_TABLE

305: , p5_a3 JTF_VARCHAR2_TABLE_2000
306: , p5_a4 JTF_VARCHAR2_TABLE_100
307: , p5_a5 JTF_DATE_TABLE
308: , p5_a6 JTF_DATE_TABLE
309: , p5_a7 JTF_NUMBER_TABLE
310: , p5_a8 JTF_DATE_TABLE
311: , p5_a9 JTF_NUMBER_TABLE
312: , p5_a10 JTF_DATE_TABLE
313: , p5_a11 JTF_NUMBER_TABLE

Line 311: , p5_a9 JTF_NUMBER_TABLE

307: , p5_a5 JTF_DATE_TABLE
308: , p5_a6 JTF_DATE_TABLE
309: , p5_a7 JTF_NUMBER_TABLE
310: , p5_a8 JTF_DATE_TABLE
311: , p5_a9 JTF_NUMBER_TABLE
312: , p5_a10 JTF_DATE_TABLE
313: , p5_a11 JTF_NUMBER_TABLE
314: );
315: procedure delete_pdt_qualitys(p_api_version NUMBER

Line 313: , p5_a11 JTF_NUMBER_TABLE

309: , p5_a7 JTF_NUMBER_TABLE
310: , p5_a8 JTF_DATE_TABLE
311: , p5_a9 JTF_NUMBER_TABLE
312: , p5_a10 JTF_DATE_TABLE
313: , p5_a11 JTF_NUMBER_TABLE
314: );
315: procedure delete_pdt_qualitys(p_api_version NUMBER
316: , p_init_msg_list VARCHAR2
317: , x_return_status out nocopy VARCHAR2

Line 338: , p5_a0 JTF_NUMBER_TABLE

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

Line 339: , p5_a1 JTF_NUMBER_TABLE

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

Line 345: , p5_a7 JTF_NUMBER_TABLE

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

Line 347: , p5_a9 JTF_NUMBER_TABLE

343: , p5_a5 JTF_DATE_TABLE
344: , p5_a6 JTF_DATE_TABLE
345: , p5_a7 JTF_NUMBER_TABLE
346: , p5_a8 JTF_DATE_TABLE
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_DATE_TABLE
349: , p5_a11 JTF_NUMBER_TABLE
350: );
351: procedure validate_pdt_qualitys(p_api_version NUMBER

Line 349: , p5_a11 JTF_NUMBER_TABLE

345: , p5_a7 JTF_NUMBER_TABLE
346: , p5_a8 JTF_DATE_TABLE
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_DATE_TABLE
349: , p5_a11 JTF_NUMBER_TABLE
350: );
351: procedure validate_pdt_qualitys(p_api_version NUMBER
352: , p_init_msg_list VARCHAR2
353: , x_return_status out nocopy VARCHAR2

Line 374: , p5_a0 JTF_NUMBER_TABLE

370: , p_init_msg_list VARCHAR2
371: , x_return_status out nocopy VARCHAR2
372: , x_msg_count out nocopy NUMBER
373: , x_msg_data out nocopy VARCHAR2
374: , p5_a0 JTF_NUMBER_TABLE
375: , p5_a1 JTF_NUMBER_TABLE
376: , p5_a2 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_200
378: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 375: , p5_a1 JTF_NUMBER_TABLE

371: , x_return_status out nocopy VARCHAR2
372: , x_msg_count out nocopy NUMBER
373: , x_msg_data out nocopy VARCHAR2
374: , p5_a0 JTF_NUMBER_TABLE
375: , p5_a1 JTF_NUMBER_TABLE
376: , p5_a2 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_200
378: , p5_a4 JTF_VARCHAR2_TABLE_2000
379: , p5_a5 JTF_DATE_TABLE

Line 376: , p5_a2 JTF_NUMBER_TABLE

372: , x_msg_count out nocopy NUMBER
373: , x_msg_data out nocopy VARCHAR2
374: , p5_a0 JTF_NUMBER_TABLE
375: , p5_a1 JTF_NUMBER_TABLE
376: , p5_a2 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_200
378: , p5_a4 JTF_VARCHAR2_TABLE_2000
379: , p5_a5 JTF_DATE_TABLE
380: , p5_a6 JTF_DATE_TABLE

Line 381: , p5_a7 JTF_NUMBER_TABLE

377: , p5_a3 JTF_VARCHAR2_TABLE_200
378: , p5_a4 JTF_VARCHAR2_TABLE_2000
379: , p5_a5 JTF_DATE_TABLE
380: , p5_a6 JTF_DATE_TABLE
381: , p5_a7 JTF_NUMBER_TABLE
382: , p5_a8 JTF_DATE_TABLE
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_DATE_TABLE
385: , p5_a11 JTF_NUMBER_TABLE

Line 383: , p5_a9 JTF_NUMBER_TABLE

379: , p5_a5 JTF_DATE_TABLE
380: , p5_a6 JTF_DATE_TABLE
381: , p5_a7 JTF_NUMBER_TABLE
382: , p5_a8 JTF_DATE_TABLE
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_DATE_TABLE
385: , p5_a11 JTF_NUMBER_TABLE
386: , p6_a0 out nocopy JTF_NUMBER_TABLE
387: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 385: , p5_a11 JTF_NUMBER_TABLE

381: , p5_a7 JTF_NUMBER_TABLE
382: , p5_a8 JTF_DATE_TABLE
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_DATE_TABLE
385: , p5_a11 JTF_NUMBER_TABLE
386: , p6_a0 out nocopy JTF_NUMBER_TABLE
387: , p6_a1 out nocopy JTF_NUMBER_TABLE
388: , p6_a2 out nocopy JTF_NUMBER_TABLE
389: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 386: , p6_a0 out nocopy JTF_NUMBER_TABLE

382: , p5_a8 JTF_DATE_TABLE
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_DATE_TABLE
385: , p5_a11 JTF_NUMBER_TABLE
386: , p6_a0 out nocopy JTF_NUMBER_TABLE
387: , p6_a1 out nocopy JTF_NUMBER_TABLE
388: , p6_a2 out nocopy JTF_NUMBER_TABLE
389: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
390: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 387: , p6_a1 out nocopy JTF_NUMBER_TABLE

383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_DATE_TABLE
385: , p5_a11 JTF_NUMBER_TABLE
386: , p6_a0 out nocopy JTF_NUMBER_TABLE
387: , p6_a1 out nocopy JTF_NUMBER_TABLE
388: , p6_a2 out nocopy JTF_NUMBER_TABLE
389: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
390: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
391: , p6_a5 out nocopy JTF_DATE_TABLE

Line 388: , p6_a2 out nocopy JTF_NUMBER_TABLE

384: , p5_a10 JTF_DATE_TABLE
385: , p5_a11 JTF_NUMBER_TABLE
386: , p6_a0 out nocopy JTF_NUMBER_TABLE
387: , p6_a1 out nocopy JTF_NUMBER_TABLE
388: , p6_a2 out nocopy JTF_NUMBER_TABLE
389: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
390: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
391: , p6_a5 out nocopy JTF_DATE_TABLE
392: , p6_a6 out nocopy JTF_DATE_TABLE

Line 393: , p6_a7 out nocopy JTF_NUMBER_TABLE

389: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
390: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
391: , p6_a5 out nocopy JTF_DATE_TABLE
392: , p6_a6 out nocopy JTF_DATE_TABLE
393: , p6_a7 out nocopy JTF_NUMBER_TABLE
394: , p6_a8 out nocopy JTF_DATE_TABLE
395: , p6_a9 out nocopy JTF_NUMBER_TABLE
396: , p6_a10 out nocopy JTF_DATE_TABLE
397: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 395: , p6_a9 out nocopy JTF_NUMBER_TABLE

391: , p6_a5 out nocopy JTF_DATE_TABLE
392: , p6_a6 out nocopy JTF_DATE_TABLE
393: , p6_a7 out nocopy JTF_NUMBER_TABLE
394: , p6_a8 out nocopy JTF_DATE_TABLE
395: , p6_a9 out nocopy JTF_NUMBER_TABLE
396: , p6_a10 out nocopy JTF_DATE_TABLE
397: , p6_a11 out nocopy JTF_NUMBER_TABLE
398: );
399: procedure create_pdt_quality_vals(p_api_version NUMBER

Line 397: , p6_a11 out nocopy JTF_NUMBER_TABLE

393: , p6_a7 out nocopy JTF_NUMBER_TABLE
394: , p6_a8 out nocopy JTF_DATE_TABLE
395: , p6_a9 out nocopy JTF_NUMBER_TABLE
396: , p6_a10 out nocopy JTF_DATE_TABLE
397: , p6_a11 out nocopy JTF_NUMBER_TABLE
398: );
399: procedure create_pdt_quality_vals(p_api_version NUMBER
400: , p_init_msg_list VARCHAR2
401: , x_return_status out nocopy VARCHAR2

Line 434: , p5_a0 JTF_NUMBER_TABLE

430: , p_init_msg_list VARCHAR2
431: , x_return_status out nocopy VARCHAR2
432: , x_msg_count out nocopy NUMBER
433: , x_msg_data out nocopy VARCHAR2
434: , p5_a0 JTF_NUMBER_TABLE
435: , p5_a1 JTF_NUMBER_TABLE
436: , p5_a2 JTF_NUMBER_TABLE
437: , p5_a3 JTF_VARCHAR2_TABLE_200
438: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 435: , p5_a1 JTF_NUMBER_TABLE

431: , x_return_status out nocopy VARCHAR2
432: , x_msg_count out nocopy NUMBER
433: , x_msg_data out nocopy VARCHAR2
434: , p5_a0 JTF_NUMBER_TABLE
435: , p5_a1 JTF_NUMBER_TABLE
436: , p5_a2 JTF_NUMBER_TABLE
437: , p5_a3 JTF_VARCHAR2_TABLE_200
438: , p5_a4 JTF_VARCHAR2_TABLE_2000
439: , p5_a5 JTF_DATE_TABLE

Line 436: , p5_a2 JTF_NUMBER_TABLE

432: , x_msg_count out nocopy NUMBER
433: , x_msg_data out nocopy VARCHAR2
434: , p5_a0 JTF_NUMBER_TABLE
435: , p5_a1 JTF_NUMBER_TABLE
436: , p5_a2 JTF_NUMBER_TABLE
437: , p5_a3 JTF_VARCHAR2_TABLE_200
438: , p5_a4 JTF_VARCHAR2_TABLE_2000
439: , p5_a5 JTF_DATE_TABLE
440: , p5_a6 JTF_DATE_TABLE

Line 441: , p5_a7 JTF_NUMBER_TABLE

437: , p5_a3 JTF_VARCHAR2_TABLE_200
438: , p5_a4 JTF_VARCHAR2_TABLE_2000
439: , p5_a5 JTF_DATE_TABLE
440: , p5_a6 JTF_DATE_TABLE
441: , p5_a7 JTF_NUMBER_TABLE
442: , p5_a8 JTF_DATE_TABLE
443: , p5_a9 JTF_NUMBER_TABLE
444: , p5_a10 JTF_DATE_TABLE
445: , p5_a11 JTF_NUMBER_TABLE

Line 443: , p5_a9 JTF_NUMBER_TABLE

439: , p5_a5 JTF_DATE_TABLE
440: , p5_a6 JTF_DATE_TABLE
441: , p5_a7 JTF_NUMBER_TABLE
442: , p5_a8 JTF_DATE_TABLE
443: , p5_a9 JTF_NUMBER_TABLE
444: , p5_a10 JTF_DATE_TABLE
445: , p5_a11 JTF_NUMBER_TABLE
446: );
447: procedure lock_pdt_quality_vals(p_api_version NUMBER

Line 445: , p5_a11 JTF_NUMBER_TABLE

441: , p5_a7 JTF_NUMBER_TABLE
442: , p5_a8 JTF_DATE_TABLE
443: , p5_a9 JTF_NUMBER_TABLE
444: , p5_a10 JTF_DATE_TABLE
445: , p5_a11 JTF_NUMBER_TABLE
446: );
447: procedure lock_pdt_quality_vals(p_api_version NUMBER
448: , p_init_msg_list VARCHAR2
449: , x_return_status out nocopy VARCHAR2

Line 470: , p5_a0 JTF_NUMBER_TABLE

466: , p_init_msg_list VARCHAR2
467: , x_return_status out nocopy VARCHAR2
468: , x_msg_count out nocopy NUMBER
469: , x_msg_data out nocopy VARCHAR2
470: , p5_a0 JTF_NUMBER_TABLE
471: , p5_a1 JTF_NUMBER_TABLE
472: , p5_a2 JTF_NUMBER_TABLE
473: , p5_a3 JTF_VARCHAR2_TABLE_200
474: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 471: , p5_a1 JTF_NUMBER_TABLE

467: , x_return_status out nocopy VARCHAR2
468: , x_msg_count out nocopy NUMBER
469: , x_msg_data out nocopy VARCHAR2
470: , p5_a0 JTF_NUMBER_TABLE
471: , p5_a1 JTF_NUMBER_TABLE
472: , p5_a2 JTF_NUMBER_TABLE
473: , p5_a3 JTF_VARCHAR2_TABLE_200
474: , p5_a4 JTF_VARCHAR2_TABLE_2000
475: , p5_a5 JTF_DATE_TABLE

Line 472: , p5_a2 JTF_NUMBER_TABLE

468: , x_msg_count out nocopy NUMBER
469: , x_msg_data out nocopy VARCHAR2
470: , p5_a0 JTF_NUMBER_TABLE
471: , p5_a1 JTF_NUMBER_TABLE
472: , p5_a2 JTF_NUMBER_TABLE
473: , p5_a3 JTF_VARCHAR2_TABLE_200
474: , p5_a4 JTF_VARCHAR2_TABLE_2000
475: , p5_a5 JTF_DATE_TABLE
476: , p5_a6 JTF_DATE_TABLE

Line 477: , p5_a7 JTF_NUMBER_TABLE

473: , p5_a3 JTF_VARCHAR2_TABLE_200
474: , p5_a4 JTF_VARCHAR2_TABLE_2000
475: , p5_a5 JTF_DATE_TABLE
476: , p5_a6 JTF_DATE_TABLE
477: , p5_a7 JTF_NUMBER_TABLE
478: , p5_a8 JTF_DATE_TABLE
479: , p5_a9 JTF_NUMBER_TABLE
480: , p5_a10 JTF_DATE_TABLE
481: , p5_a11 JTF_NUMBER_TABLE

Line 479: , p5_a9 JTF_NUMBER_TABLE

475: , p5_a5 JTF_DATE_TABLE
476: , p5_a6 JTF_DATE_TABLE
477: , p5_a7 JTF_NUMBER_TABLE
478: , p5_a8 JTF_DATE_TABLE
479: , p5_a9 JTF_NUMBER_TABLE
480: , p5_a10 JTF_DATE_TABLE
481: , p5_a11 JTF_NUMBER_TABLE
482: , p6_a0 out nocopy JTF_NUMBER_TABLE
483: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 481: , p5_a11 JTF_NUMBER_TABLE

477: , p5_a7 JTF_NUMBER_TABLE
478: , p5_a8 JTF_DATE_TABLE
479: , p5_a9 JTF_NUMBER_TABLE
480: , p5_a10 JTF_DATE_TABLE
481: , p5_a11 JTF_NUMBER_TABLE
482: , p6_a0 out nocopy JTF_NUMBER_TABLE
483: , p6_a1 out nocopy JTF_NUMBER_TABLE
484: , p6_a2 out nocopy JTF_NUMBER_TABLE
485: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 482: , p6_a0 out nocopy JTF_NUMBER_TABLE

478: , p5_a8 JTF_DATE_TABLE
479: , p5_a9 JTF_NUMBER_TABLE
480: , p5_a10 JTF_DATE_TABLE
481: , p5_a11 JTF_NUMBER_TABLE
482: , p6_a0 out nocopy JTF_NUMBER_TABLE
483: , p6_a1 out nocopy JTF_NUMBER_TABLE
484: , p6_a2 out nocopy JTF_NUMBER_TABLE
485: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
486: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 483: , p6_a1 out nocopy JTF_NUMBER_TABLE

479: , p5_a9 JTF_NUMBER_TABLE
480: , p5_a10 JTF_DATE_TABLE
481: , p5_a11 JTF_NUMBER_TABLE
482: , p6_a0 out nocopy JTF_NUMBER_TABLE
483: , p6_a1 out nocopy JTF_NUMBER_TABLE
484: , p6_a2 out nocopy JTF_NUMBER_TABLE
485: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
486: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
487: , p6_a5 out nocopy JTF_DATE_TABLE

Line 484: , p6_a2 out nocopy JTF_NUMBER_TABLE

480: , p5_a10 JTF_DATE_TABLE
481: , p5_a11 JTF_NUMBER_TABLE
482: , p6_a0 out nocopy JTF_NUMBER_TABLE
483: , p6_a1 out nocopy JTF_NUMBER_TABLE
484: , p6_a2 out nocopy JTF_NUMBER_TABLE
485: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
486: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
487: , p6_a5 out nocopy JTF_DATE_TABLE
488: , p6_a6 out nocopy JTF_DATE_TABLE

Line 489: , p6_a7 out nocopy JTF_NUMBER_TABLE

485: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
486: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
487: , p6_a5 out nocopy JTF_DATE_TABLE
488: , p6_a6 out nocopy JTF_DATE_TABLE
489: , p6_a7 out nocopy JTF_NUMBER_TABLE
490: , p6_a8 out nocopy JTF_DATE_TABLE
491: , p6_a9 out nocopy JTF_NUMBER_TABLE
492: , p6_a10 out nocopy JTF_DATE_TABLE
493: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 491: , p6_a9 out nocopy JTF_NUMBER_TABLE

487: , p6_a5 out nocopy JTF_DATE_TABLE
488: , p6_a6 out nocopy JTF_DATE_TABLE
489: , p6_a7 out nocopy JTF_NUMBER_TABLE
490: , p6_a8 out nocopy JTF_DATE_TABLE
491: , p6_a9 out nocopy JTF_NUMBER_TABLE
492: , p6_a10 out nocopy JTF_DATE_TABLE
493: , p6_a11 out nocopy JTF_NUMBER_TABLE
494: );
495: procedure update_pdt_quality_vals(p_api_version NUMBER

Line 493: , p6_a11 out nocopy JTF_NUMBER_TABLE

489: , p6_a7 out nocopy JTF_NUMBER_TABLE
490: , p6_a8 out nocopy JTF_DATE_TABLE
491: , p6_a9 out nocopy JTF_NUMBER_TABLE
492: , p6_a10 out nocopy JTF_DATE_TABLE
493: , p6_a11 out nocopy JTF_NUMBER_TABLE
494: );
495: procedure update_pdt_quality_vals(p_api_version NUMBER
496: , p_init_msg_list VARCHAR2
497: , x_return_status out nocopy VARCHAR2

Line 530: , p5_a0 JTF_NUMBER_TABLE

526: , p_init_msg_list VARCHAR2
527: , x_return_status out nocopy VARCHAR2
528: , x_msg_count out nocopy NUMBER
529: , x_msg_data out nocopy VARCHAR2
530: , p5_a0 JTF_NUMBER_TABLE
531: , p5_a1 JTF_NUMBER_TABLE
532: , p5_a2 JTF_NUMBER_TABLE
533: , p5_a3 JTF_VARCHAR2_TABLE_200
534: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 531: , p5_a1 JTF_NUMBER_TABLE

527: , x_return_status out nocopy VARCHAR2
528: , x_msg_count out nocopy NUMBER
529: , x_msg_data out nocopy VARCHAR2
530: , p5_a0 JTF_NUMBER_TABLE
531: , p5_a1 JTF_NUMBER_TABLE
532: , p5_a2 JTF_NUMBER_TABLE
533: , p5_a3 JTF_VARCHAR2_TABLE_200
534: , p5_a4 JTF_VARCHAR2_TABLE_2000
535: , p5_a5 JTF_DATE_TABLE

Line 532: , p5_a2 JTF_NUMBER_TABLE

528: , x_msg_count out nocopy NUMBER
529: , x_msg_data out nocopy VARCHAR2
530: , p5_a0 JTF_NUMBER_TABLE
531: , p5_a1 JTF_NUMBER_TABLE
532: , p5_a2 JTF_NUMBER_TABLE
533: , p5_a3 JTF_VARCHAR2_TABLE_200
534: , p5_a4 JTF_VARCHAR2_TABLE_2000
535: , p5_a5 JTF_DATE_TABLE
536: , p5_a6 JTF_DATE_TABLE

Line 537: , p5_a7 JTF_NUMBER_TABLE

533: , p5_a3 JTF_VARCHAR2_TABLE_200
534: , p5_a4 JTF_VARCHAR2_TABLE_2000
535: , p5_a5 JTF_DATE_TABLE
536: , p5_a6 JTF_DATE_TABLE
537: , p5_a7 JTF_NUMBER_TABLE
538: , p5_a8 JTF_DATE_TABLE
539: , p5_a9 JTF_NUMBER_TABLE
540: , p5_a10 JTF_DATE_TABLE
541: , p5_a11 JTF_NUMBER_TABLE

Line 539: , p5_a9 JTF_NUMBER_TABLE

535: , p5_a5 JTF_DATE_TABLE
536: , p5_a6 JTF_DATE_TABLE
537: , p5_a7 JTF_NUMBER_TABLE
538: , p5_a8 JTF_DATE_TABLE
539: , p5_a9 JTF_NUMBER_TABLE
540: , p5_a10 JTF_DATE_TABLE
541: , p5_a11 JTF_NUMBER_TABLE
542: );
543: procedure delete_pdt_quality_vals(p_api_version NUMBER

Line 541: , p5_a11 JTF_NUMBER_TABLE

537: , p5_a7 JTF_NUMBER_TABLE
538: , p5_a8 JTF_DATE_TABLE
539: , p5_a9 JTF_NUMBER_TABLE
540: , p5_a10 JTF_DATE_TABLE
541: , p5_a11 JTF_NUMBER_TABLE
542: );
543: procedure delete_pdt_quality_vals(p_api_version NUMBER
544: , p_init_msg_list VARCHAR2
545: , x_return_status out nocopy VARCHAR2

Line 566: , p5_a0 JTF_NUMBER_TABLE

562: , p_init_msg_list VARCHAR2
563: , x_return_status out nocopy VARCHAR2
564: , x_msg_count out nocopy NUMBER
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_NUMBER_TABLE
569: , p5_a3 JTF_VARCHAR2_TABLE_200
570: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 567: , p5_a1 JTF_NUMBER_TABLE

563: , x_return_status out nocopy VARCHAR2
564: , x_msg_count out nocopy NUMBER
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_NUMBER_TABLE
569: , p5_a3 JTF_VARCHAR2_TABLE_200
570: , p5_a4 JTF_VARCHAR2_TABLE_2000
571: , p5_a5 JTF_DATE_TABLE

Line 568: , p5_a2 JTF_NUMBER_TABLE

564: , x_msg_count out nocopy NUMBER
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_NUMBER_TABLE
569: , p5_a3 JTF_VARCHAR2_TABLE_200
570: , p5_a4 JTF_VARCHAR2_TABLE_2000
571: , p5_a5 JTF_DATE_TABLE
572: , p5_a6 JTF_DATE_TABLE

Line 573: , p5_a7 JTF_NUMBER_TABLE

569: , p5_a3 JTF_VARCHAR2_TABLE_200
570: , p5_a4 JTF_VARCHAR2_TABLE_2000
571: , p5_a5 JTF_DATE_TABLE
572: , p5_a6 JTF_DATE_TABLE
573: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a8 JTF_DATE_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
577: , p5_a11 JTF_NUMBER_TABLE

Line 575: , p5_a9 JTF_NUMBER_TABLE

571: , p5_a5 JTF_DATE_TABLE
572: , p5_a6 JTF_DATE_TABLE
573: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a8 JTF_DATE_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
577: , p5_a11 JTF_NUMBER_TABLE
578: );
579: procedure validate_pdt_quality_vals(p_api_version NUMBER

Line 577: , p5_a11 JTF_NUMBER_TABLE

573: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a8 JTF_DATE_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
577: , p5_a11 JTF_NUMBER_TABLE
578: );
579: procedure validate_pdt_quality_vals(p_api_version NUMBER
580: , p_init_msg_list VARCHAR2
581: , x_return_status out nocopy VARCHAR2