APPS.OKL_ALS_PVT_W dependencies on FND_API

Line 76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

72: , p6_a10 out nocopy DATE
73: , p6_a11 out nocopy NUMBER
74: , p5_a0 NUMBER := 0-1962.0724
75: , p5_a1 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a6 NUMBER := 0-1962.0724

Line 77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

73: , p6_a11 out nocopy NUMBER
74: , p5_a0 NUMBER := 0-1962.0724
75: , p5_a1 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a6 NUMBER := 0-1962.0724
81: , p5_a7 NUMBER := 0-1962.0724

Line 78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

74: , p5_a0 NUMBER := 0-1962.0724
75: , p5_a1 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a6 NUMBER := 0-1962.0724
81: , p5_a7 NUMBER := 0-1962.0724
82: , p5_a8 DATE := fnd_api.g_miss_date

Line 79: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

75: , p5_a1 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a6 NUMBER := 0-1962.0724
81: , p5_a7 NUMBER := 0-1962.0724
82: , p5_a8 DATE := fnd_api.g_miss_date
83: , p5_a9 NUMBER := 0-1962.0724

Line 82: , p5_a8 DATE := fnd_api.g_miss_date

78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a6 NUMBER := 0-1962.0724
81: , p5_a7 NUMBER := 0-1962.0724
82: , p5_a8 DATE := fnd_api.g_miss_date
83: , p5_a9 NUMBER := 0-1962.0724
84: , p5_a10 DATE := fnd_api.g_miss_date
85: , p5_a11 NUMBER := 0-1962.0724
86: );

Line 84: , p5_a10 DATE := fnd_api.g_miss_date

80: , p5_a6 NUMBER := 0-1962.0724
81: , p5_a7 NUMBER := 0-1962.0724
82: , p5_a8 DATE := fnd_api.g_miss_date
83: , p5_a9 NUMBER := 0-1962.0724
84: , p5_a10 DATE := fnd_api.g_miss_date
85: , p5_a11 NUMBER := 0-1962.0724
86: );
87: procedure insert_row(p_api_version NUMBER
88: , p_init_msg_list VARCHAR2

Line 124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

120: , x_msg_count out nocopy NUMBER
121: , x_msg_data out nocopy VARCHAR2
122: , p5_a0 NUMBER := 0-1962.0724
123: , p5_a1 NUMBER := 0-1962.0724
124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a6 NUMBER := 0-1962.0724

Line 125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

121: , x_msg_data out nocopy VARCHAR2
122: , p5_a0 NUMBER := 0-1962.0724
123: , p5_a1 NUMBER := 0-1962.0724
124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a6 NUMBER := 0-1962.0724
129: , p5_a7 NUMBER := 0-1962.0724

Line 126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

122: , p5_a0 NUMBER := 0-1962.0724
123: , p5_a1 NUMBER := 0-1962.0724
124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a6 NUMBER := 0-1962.0724
129: , p5_a7 NUMBER := 0-1962.0724
130: , p5_a8 DATE := fnd_api.g_miss_date

Line 127: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

123: , p5_a1 NUMBER := 0-1962.0724
124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a6 NUMBER := 0-1962.0724
129: , p5_a7 NUMBER := 0-1962.0724
130: , p5_a8 DATE := fnd_api.g_miss_date
131: , p5_a9 NUMBER := 0-1962.0724

Line 130: , p5_a8 DATE := fnd_api.g_miss_date

126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a6 NUMBER := 0-1962.0724
129: , p5_a7 NUMBER := 0-1962.0724
130: , p5_a8 DATE := fnd_api.g_miss_date
131: , p5_a9 NUMBER := 0-1962.0724
132: , p5_a10 DATE := fnd_api.g_miss_date
133: , p5_a11 NUMBER := 0-1962.0724
134: );

Line 132: , p5_a10 DATE := fnd_api.g_miss_date

128: , p5_a6 NUMBER := 0-1962.0724
129: , p5_a7 NUMBER := 0-1962.0724
130: , p5_a8 DATE := fnd_api.g_miss_date
131: , p5_a9 NUMBER := 0-1962.0724
132: , p5_a10 DATE := fnd_api.g_miss_date
133: , p5_a11 NUMBER := 0-1962.0724
134: );
135: procedure lock_row(p_api_version NUMBER
136: , p_init_msg_list VARCHAR2

Line 172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

168: , p6_a10 out nocopy DATE
169: , p6_a11 out nocopy NUMBER
170: , p5_a0 NUMBER := 0-1962.0724
171: , p5_a1 NUMBER := 0-1962.0724
172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a6 NUMBER := 0-1962.0724

Line 173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

169: , p6_a11 out nocopy NUMBER
170: , p5_a0 NUMBER := 0-1962.0724
171: , p5_a1 NUMBER := 0-1962.0724
172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a6 NUMBER := 0-1962.0724
177: , p5_a7 NUMBER := 0-1962.0724

Line 174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

170: , p5_a0 NUMBER := 0-1962.0724
171: , p5_a1 NUMBER := 0-1962.0724
172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a6 NUMBER := 0-1962.0724
177: , p5_a7 NUMBER := 0-1962.0724
178: , p5_a8 DATE := fnd_api.g_miss_date

Line 175: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

171: , p5_a1 NUMBER := 0-1962.0724
172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a6 NUMBER := 0-1962.0724
177: , p5_a7 NUMBER := 0-1962.0724
178: , p5_a8 DATE := fnd_api.g_miss_date
179: , p5_a9 NUMBER := 0-1962.0724

Line 178: , p5_a8 DATE := fnd_api.g_miss_date

174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a6 NUMBER := 0-1962.0724
177: , p5_a7 NUMBER := 0-1962.0724
178: , p5_a8 DATE := fnd_api.g_miss_date
179: , p5_a9 NUMBER := 0-1962.0724
180: , p5_a10 DATE := fnd_api.g_miss_date
181: , p5_a11 NUMBER := 0-1962.0724
182: );

Line 180: , p5_a10 DATE := fnd_api.g_miss_date

176: , p5_a6 NUMBER := 0-1962.0724
177: , p5_a7 NUMBER := 0-1962.0724
178: , p5_a8 DATE := fnd_api.g_miss_date
179: , p5_a9 NUMBER := 0-1962.0724
180: , p5_a10 DATE := fnd_api.g_miss_date
181: , p5_a11 NUMBER := 0-1962.0724
182: );
183: procedure update_row(p_api_version NUMBER
184: , p_init_msg_list VARCHAR2

Line 220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 NUMBER := 0-1962.0724
219: , p5_a1 NUMBER := 0-1962.0724
220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a6 NUMBER := 0-1962.0724

Line 221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 NUMBER := 0-1962.0724
219: , p5_a1 NUMBER := 0-1962.0724
220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a6 NUMBER := 0-1962.0724
225: , p5_a7 NUMBER := 0-1962.0724

Line 222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

218: , p5_a0 NUMBER := 0-1962.0724
219: , p5_a1 NUMBER := 0-1962.0724
220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a6 NUMBER := 0-1962.0724
225: , p5_a7 NUMBER := 0-1962.0724
226: , p5_a8 DATE := fnd_api.g_miss_date

Line 223: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

219: , p5_a1 NUMBER := 0-1962.0724
220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a6 NUMBER := 0-1962.0724
225: , p5_a7 NUMBER := 0-1962.0724
226: , p5_a8 DATE := fnd_api.g_miss_date
227: , p5_a9 NUMBER := 0-1962.0724

Line 226: , p5_a8 DATE := fnd_api.g_miss_date

222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a6 NUMBER := 0-1962.0724
225: , p5_a7 NUMBER := 0-1962.0724
226: , p5_a8 DATE := fnd_api.g_miss_date
227: , p5_a9 NUMBER := 0-1962.0724
228: , p5_a10 DATE := fnd_api.g_miss_date
229: , p5_a11 NUMBER := 0-1962.0724
230: );

Line 228: , p5_a10 DATE := fnd_api.g_miss_date

224: , p5_a6 NUMBER := 0-1962.0724
225: , p5_a7 NUMBER := 0-1962.0724
226: , p5_a8 DATE := fnd_api.g_miss_date
227: , p5_a9 NUMBER := 0-1962.0724
228: , p5_a10 DATE := fnd_api.g_miss_date
229: , p5_a11 NUMBER := 0-1962.0724
230: );
231: procedure delete_row(p_api_version NUMBER
232: , p_init_msg_list VARCHAR2

Line 256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

252: , x_msg_count out nocopy NUMBER
253: , x_msg_data out nocopy VARCHAR2
254: , p5_a0 NUMBER := 0-1962.0724
255: , p5_a1 NUMBER := 0-1962.0724
256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a6 NUMBER := 0-1962.0724

Line 257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

253: , x_msg_data out nocopy VARCHAR2
254: , p5_a0 NUMBER := 0-1962.0724
255: , p5_a1 NUMBER := 0-1962.0724
256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a6 NUMBER := 0-1962.0724
261: , p5_a7 NUMBER := 0-1962.0724

Line 258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

254: , p5_a0 NUMBER := 0-1962.0724
255: , p5_a1 NUMBER := 0-1962.0724
256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a6 NUMBER := 0-1962.0724
261: , p5_a7 NUMBER := 0-1962.0724
262: , p5_a8 DATE := fnd_api.g_miss_date

Line 259: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

255: , p5_a1 NUMBER := 0-1962.0724
256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a6 NUMBER := 0-1962.0724
261: , p5_a7 NUMBER := 0-1962.0724
262: , p5_a8 DATE := fnd_api.g_miss_date
263: , p5_a9 NUMBER := 0-1962.0724

Line 262: , p5_a8 DATE := fnd_api.g_miss_date

258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a6 NUMBER := 0-1962.0724
261: , p5_a7 NUMBER := 0-1962.0724
262: , p5_a8 DATE := fnd_api.g_miss_date
263: , p5_a9 NUMBER := 0-1962.0724
264: , p5_a10 DATE := fnd_api.g_miss_date
265: , p5_a11 NUMBER := 0-1962.0724
266: );

Line 264: , p5_a10 DATE := fnd_api.g_miss_date

260: , p5_a6 NUMBER := 0-1962.0724
261: , p5_a7 NUMBER := 0-1962.0724
262: , p5_a8 DATE := fnd_api.g_miss_date
263: , p5_a9 NUMBER := 0-1962.0724
264: , p5_a10 DATE := fnd_api.g_miss_date
265: , p5_a11 NUMBER := 0-1962.0724
266: );
267: procedure validate_row(p_api_version NUMBER
268: , p_init_msg_list VARCHAR2