eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_EXTEND_ATTRIB_VLD_PVT dependencies on FND_API

Line 260: IF (p_ext_attrib_rec.attribute_id = FND_API.G_MISS_NUM ) AND

256: )
257: RETURN BOOLEAN
258: IS
259: BEGIN
260: IF (p_ext_attrib_rec.attribute_id = FND_API.G_MISS_NUM ) AND
261: (p_ext_attrib_rec.instance_id = FND_API.G_MISS_NUM ) AND
262: (p_ext_attrib_rec.attribute_value = FND_API.G_MISS_CHAR) AND
263: (p_ext_attrib_rec.active_start_date = FND_API.G_MISS_DATE) AND
264: (p_ext_attrib_rec.active_end_date = SYSDATE) AND

Line 261: (p_ext_attrib_rec.instance_id = FND_API.G_MISS_NUM ) AND

257: RETURN BOOLEAN
258: IS
259: BEGIN
260: IF (p_ext_attrib_rec.attribute_id = FND_API.G_MISS_NUM ) AND
261: (p_ext_attrib_rec.instance_id = FND_API.G_MISS_NUM ) AND
262: (p_ext_attrib_rec.attribute_value = FND_API.G_MISS_CHAR) AND
263: (p_ext_attrib_rec.active_start_date = FND_API.G_MISS_DATE) AND
264: (p_ext_attrib_rec.active_end_date = SYSDATE) AND
265: (p_ext_attrib_rec.context = FND_API.G_MISS_CHAR) AND

Line 262: (p_ext_attrib_rec.attribute_value = FND_API.G_MISS_CHAR) AND

258: IS
259: BEGIN
260: IF (p_ext_attrib_rec.attribute_id = FND_API.G_MISS_NUM ) AND
261: (p_ext_attrib_rec.instance_id = FND_API.G_MISS_NUM ) AND
262: (p_ext_attrib_rec.attribute_value = FND_API.G_MISS_CHAR) AND
263: (p_ext_attrib_rec.active_start_date = FND_API.G_MISS_DATE) AND
264: (p_ext_attrib_rec.active_end_date = SYSDATE) AND
265: (p_ext_attrib_rec.context = FND_API.G_MISS_CHAR) AND
266: (p_ext_attrib_rec.attribute1 = FND_API.G_MISS_CHAR) AND

Line 263: (p_ext_attrib_rec.active_start_date = FND_API.G_MISS_DATE) AND

259: BEGIN
260: IF (p_ext_attrib_rec.attribute_id = FND_API.G_MISS_NUM ) AND
261: (p_ext_attrib_rec.instance_id = FND_API.G_MISS_NUM ) AND
262: (p_ext_attrib_rec.attribute_value = FND_API.G_MISS_CHAR) AND
263: (p_ext_attrib_rec.active_start_date = FND_API.G_MISS_DATE) AND
264: (p_ext_attrib_rec.active_end_date = SYSDATE) AND
265: (p_ext_attrib_rec.context = FND_API.G_MISS_CHAR) AND
266: (p_ext_attrib_rec.attribute1 = FND_API.G_MISS_CHAR) AND
267: (p_ext_attrib_rec.attribute2 = FND_API.G_MISS_CHAR) AND

Line 265: (p_ext_attrib_rec.context = FND_API.G_MISS_CHAR) AND

261: (p_ext_attrib_rec.instance_id = FND_API.G_MISS_NUM ) AND
262: (p_ext_attrib_rec.attribute_value = FND_API.G_MISS_CHAR) AND
263: (p_ext_attrib_rec.active_start_date = FND_API.G_MISS_DATE) AND
264: (p_ext_attrib_rec.active_end_date = SYSDATE) AND
265: (p_ext_attrib_rec.context = FND_API.G_MISS_CHAR) AND
266: (p_ext_attrib_rec.attribute1 = FND_API.G_MISS_CHAR) AND
267: (p_ext_attrib_rec.attribute2 = FND_API.G_MISS_CHAR) AND
268: (p_ext_attrib_rec.attribute3 = FND_API.G_MISS_CHAR) AND
269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND

Line 266: (p_ext_attrib_rec.attribute1 = FND_API.G_MISS_CHAR) AND

262: (p_ext_attrib_rec.attribute_value = FND_API.G_MISS_CHAR) AND
263: (p_ext_attrib_rec.active_start_date = FND_API.G_MISS_DATE) AND
264: (p_ext_attrib_rec.active_end_date = SYSDATE) AND
265: (p_ext_attrib_rec.context = FND_API.G_MISS_CHAR) AND
266: (p_ext_attrib_rec.attribute1 = FND_API.G_MISS_CHAR) AND
267: (p_ext_attrib_rec.attribute2 = FND_API.G_MISS_CHAR) AND
268: (p_ext_attrib_rec.attribute3 = FND_API.G_MISS_CHAR) AND
269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND
270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND

Line 267: (p_ext_attrib_rec.attribute2 = FND_API.G_MISS_CHAR) AND

263: (p_ext_attrib_rec.active_start_date = FND_API.G_MISS_DATE) AND
264: (p_ext_attrib_rec.active_end_date = SYSDATE) AND
265: (p_ext_attrib_rec.context = FND_API.G_MISS_CHAR) AND
266: (p_ext_attrib_rec.attribute1 = FND_API.G_MISS_CHAR) AND
267: (p_ext_attrib_rec.attribute2 = FND_API.G_MISS_CHAR) AND
268: (p_ext_attrib_rec.attribute3 = FND_API.G_MISS_CHAR) AND
269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND
270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND
271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND

Line 268: (p_ext_attrib_rec.attribute3 = FND_API.G_MISS_CHAR) AND

264: (p_ext_attrib_rec.active_end_date = SYSDATE) AND
265: (p_ext_attrib_rec.context = FND_API.G_MISS_CHAR) AND
266: (p_ext_attrib_rec.attribute1 = FND_API.G_MISS_CHAR) AND
267: (p_ext_attrib_rec.attribute2 = FND_API.G_MISS_CHAR) AND
268: (p_ext_attrib_rec.attribute3 = FND_API.G_MISS_CHAR) AND
269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND
270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND
271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND
272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND

Line 269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND

265: (p_ext_attrib_rec.context = FND_API.G_MISS_CHAR) AND
266: (p_ext_attrib_rec.attribute1 = FND_API.G_MISS_CHAR) AND
267: (p_ext_attrib_rec.attribute2 = FND_API.G_MISS_CHAR) AND
268: (p_ext_attrib_rec.attribute3 = FND_API.G_MISS_CHAR) AND
269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND
270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND
271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND
272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND
273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND

Line 270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND

266: (p_ext_attrib_rec.attribute1 = FND_API.G_MISS_CHAR) AND
267: (p_ext_attrib_rec.attribute2 = FND_API.G_MISS_CHAR) AND
268: (p_ext_attrib_rec.attribute3 = FND_API.G_MISS_CHAR) AND
269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND
270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND
271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND
272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND
273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND
274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND

Line 271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND

267: (p_ext_attrib_rec.attribute2 = FND_API.G_MISS_CHAR) AND
268: (p_ext_attrib_rec.attribute3 = FND_API.G_MISS_CHAR) AND
269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND
270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND
271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND
272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND
273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND
274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND
275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND

Line 272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND

268: (p_ext_attrib_rec.attribute3 = FND_API.G_MISS_CHAR) AND
269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND
270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND
271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND
272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND
273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND
274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND
275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND
276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND

Line 273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND

269: (p_ext_attrib_rec.attribute4 = FND_API.G_MISS_CHAR) AND
270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND
271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND
272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND
273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND
274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND
275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND
276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND
277: (p_ext_attrib_rec.attribute12 = FND_API.G_MISS_CHAR) AND

Line 274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND

270: (p_ext_attrib_rec.attribute5 = FND_API.G_MISS_CHAR) AND
271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND
272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND
273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND
274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND
275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND
276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND
277: (p_ext_attrib_rec.attribute12 = FND_API.G_MISS_CHAR) AND
278: (p_ext_attrib_rec.attribute13 = FND_API.G_MISS_CHAR) AND

Line 275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND

271: (p_ext_attrib_rec.attribute6 = FND_API.G_MISS_CHAR) AND
272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND
273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND
274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND
275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND
276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND
277: (p_ext_attrib_rec.attribute12 = FND_API.G_MISS_CHAR) AND
278: (p_ext_attrib_rec.attribute13 = FND_API.G_MISS_CHAR) AND
279: (p_ext_attrib_rec.attribute14 = FND_API.G_MISS_CHAR) AND

Line 276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND

272: (p_ext_attrib_rec.attribute7 = FND_API.G_MISS_CHAR) AND
273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND
274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND
275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND
276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND
277: (p_ext_attrib_rec.attribute12 = FND_API.G_MISS_CHAR) AND
278: (p_ext_attrib_rec.attribute13 = FND_API.G_MISS_CHAR) AND
279: (p_ext_attrib_rec.attribute14 = FND_API.G_MISS_CHAR) AND
280: (p_ext_attrib_rec.attribute15 = FND_API.G_MISS_CHAR) THEN

Line 277: (p_ext_attrib_rec.attribute12 = FND_API.G_MISS_CHAR) AND

273: (p_ext_attrib_rec.attribute8 = FND_API.G_MISS_CHAR) AND
274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND
275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND
276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND
277: (p_ext_attrib_rec.attribute12 = FND_API.G_MISS_CHAR) AND
278: (p_ext_attrib_rec.attribute13 = FND_API.G_MISS_CHAR) AND
279: (p_ext_attrib_rec.attribute14 = FND_API.G_MISS_CHAR) AND
280: (p_ext_attrib_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
281:

Line 278: (p_ext_attrib_rec.attribute13 = FND_API.G_MISS_CHAR) AND

274: (p_ext_attrib_rec.attribute9 = FND_API.G_MISS_CHAR) AND
275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND
276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND
277: (p_ext_attrib_rec.attribute12 = FND_API.G_MISS_CHAR) AND
278: (p_ext_attrib_rec.attribute13 = FND_API.G_MISS_CHAR) AND
279: (p_ext_attrib_rec.attribute14 = FND_API.G_MISS_CHAR) AND
280: (p_ext_attrib_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
281:
282: RETURN TRUE;

Line 279: (p_ext_attrib_rec.attribute14 = FND_API.G_MISS_CHAR) AND

275: (p_ext_attrib_rec.attribute10 = FND_API.G_MISS_CHAR) AND
276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND
277: (p_ext_attrib_rec.attribute12 = FND_API.G_MISS_CHAR) AND
278: (p_ext_attrib_rec.attribute13 = FND_API.G_MISS_CHAR) AND
279: (p_ext_attrib_rec.attribute14 = FND_API.G_MISS_CHAR) AND
280: (p_ext_attrib_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
281:
282: RETURN TRUE;
283: ELSE

Line 280: (p_ext_attrib_rec.attribute15 = FND_API.G_MISS_CHAR) THEN

276: (p_ext_attrib_rec.attribute11 = FND_API.G_MISS_CHAR) AND
277: (p_ext_attrib_rec.attribute12 = FND_API.G_MISS_CHAR) AND
278: (p_ext_attrib_rec.attribute13 = FND_API.G_MISS_CHAR) AND
279: (p_ext_attrib_rec.attribute14 = FND_API.G_MISS_CHAR) AND
280: (p_ext_attrib_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
281:
282: RETURN TRUE;
283: ELSE
284: RETURN FALSE;

Line 308: IF p_new_date = FND_API.G_MISS_DATE THEN

304: RETURN BOOLEAN
305: IS
306: BEGIN
307: IF p_old_date < SYSDATE THEN
308: IF p_new_date = FND_API.G_MISS_DATE THEN
309: IF ( p_stack_err_msg = TRUE ) THEN
310: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_UPDATABLE');
311: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_old_date);
312: FND_MSG_PUB.Add;

Line 313: RAISE FND_API.G_EXC_ERROR;

309: IF ( p_stack_err_msg = TRUE ) THEN
310: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_UPDATABLE');
311: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_old_date);
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: RETURN FALSE;
316: ELSE
317: RETURN TRUE;

Line 388: IF ((p_start_date is NULL) OR (p_start_date = FND_API.G_MISS_DATE)) THEN

384: WHERE instance_id = p_instance_id;
385: l_date_rec c1%ROWTYPE;
386:
387: BEGIN
388: IF ((p_start_date is NULL) OR (p_start_date = FND_API.G_MISS_DATE)) THEN
389: p_start_date := SYSDATE;
390: RETURN l_return_value;
391: END IF;
392:

Line 396: (p_end_date <> FND_API.G_MISS_DATE)

392:
393:
394: IF ((p_end_date is NOT NULL)
395: AND
396: (p_end_date <> FND_API.G_MISS_DATE)
397: AND
398: (p_start_date > p_end_date)) THEN
399: l_return_value := FALSE;
400: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');

Line 465: IF ((p_attr_value_id IS NULL) OR (p_attr_value_id = FND_API.G_MISS_NUM)) THEN

461:
462: l_date_rec c1%ROWTYPE;
463:
464: BEGIN
465: IF ((p_attr_value_id IS NULL) OR (p_attr_value_id = FND_API.G_MISS_NUM)) THEN
466: IF ((p_end_date is NOT NULL) AND (p_end_date <> fnd_api.g_miss_date)) THEN
467:
468: IF p_end_date < SYSDATE THEN
469: l_return_value := FALSE;

Line 466: IF ((p_end_date is NOT NULL) AND (p_end_date <> fnd_api.g_miss_date)) THEN

462: l_date_rec c1%ROWTYPE;
463:
464: BEGIN
465: IF ((p_attr_value_id IS NULL) OR (p_attr_value_id = FND_API.G_MISS_NUM)) THEN
466: IF ((p_end_date is NOT NULL) AND (p_end_date <> fnd_api.g_miss_date)) THEN
467:
468: IF p_end_date < SYSDATE THEN
469: l_return_value := FALSE;
470: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');

Line 481: IF ((p_end_date is NOT NULL) AND (p_end_date <> fnd_api.g_miss_date)) THEN --bug 9301695

477: RETURN l_return_value;
478:
479: ELSE
480:
481: IF ((p_end_date is NOT NULL) AND (p_end_date <> fnd_api.g_miss_date)) THEN --bug 9301695
482:
483: IF p_end_date < sysdate THEN
484: SELECT MAX(t.transaction_date)
485: INTO l_transaction_date

Line 504: IF ((p_end_date is not null) and (p_end_date <> fnd_api.g_miss_date)) then

500: END IF;
501:
502: END IF; --bug 9301695
503:
504: IF ((p_end_date is not null) and (p_end_date <> fnd_api.g_miss_date)) then
505: OPEN c1;
506: FETCH c1 INTO l_date_rec;
507:
508: IF (p_end_date > NVL(l_date_rec.active_end_date, p_end_date))