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_ORG_UNIT_VLD_PVT dependencies on FND_API

Line 118: IF ((p_start_date IS NULL) OR (p_start_date = FND_API.G_MISS_DATE)) THEN

114: FROM csi_item_instances
115: WHERE instance_id = p_instance_id ;
116: l_date_rec c1%ROWTYPE;
117: BEGIN
118: IF ((p_start_date IS NULL) OR (p_start_date = FND_API.G_MISS_DATE)) THEN
119: p_start_date := SYSDATE;
120: RETURN l_return_value;
121: END IF;
122:

Line 125: (p_end_date <> FND_API.G_MISS_DATE)

121: END IF;
122:
123: IF ((p_end_date is NOT NULL)
124: AND
125: (p_end_date <> FND_API.G_MISS_DATE)
126: AND
127: (p_start_date > p_end_date)) THEN
128: l_return_value := FALSE;
129: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');

Line 195: IF ((p_instance_ou_id IS NULL) OR (p_instance_ou_id = FND_API.G_MISS_NUM)) THEN

191: WHERE instance_id = p_instance_id ;
192: l_date_rec c1%ROWTYPE;
193:
194: BEGIN
195: IF ((p_instance_ou_id IS NULL) OR (p_instance_ou_id = FND_API.G_MISS_NUM)) THEN
196: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
197: IF p_end_date < sysdate THEN
198: l_return_value := FALSE;
199: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');

Line 196: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN

192: l_date_rec c1%ROWTYPE;
193:
194: BEGIN
195: IF ((p_instance_ou_id IS NULL) OR (p_instance_ou_id = FND_API.G_MISS_NUM)) THEN
196: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
197: IF p_end_date < sysdate THEN
198: l_return_value := FALSE;
199: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');
200: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);

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

225: RETURN l_return_value;
226: END IF;
227: END IF;
228:
229: IF ((p_end_date is not null) and (p_end_date <> fnd_api.g_miss_date)) then
230: OPEN c1;
231: FETCH c1 INTO l_date_rec;
232: IF (p_end_date > NVL(l_date_rec.active_end_date, p_end_date))
233: OR

Line 505: IF (p_org_unit_rec.instance_id = FND_API.G_MISS_NUM) AND

501: )
502: RETURN BOOLEAN
503: IS
504: BEGIN
505: IF (p_org_unit_rec.instance_id = FND_API.G_MISS_NUM) AND
506: (p_org_unit_rec.operating_unit_id = FND_API.G_MISS_NUM) AND
507: (p_org_unit_rec.relationship_type_code = FND_API.G_MISS_CHAR) AND
508: (p_org_unit_rec.active_start_date = FND_API.G_MISS_DATE) AND
509: (p_org_unit_rec.active_end_date = SYSDATE) AND

Line 506: (p_org_unit_rec.operating_unit_id = FND_API.G_MISS_NUM) AND

502: RETURN BOOLEAN
503: IS
504: BEGIN
505: IF (p_org_unit_rec.instance_id = FND_API.G_MISS_NUM) AND
506: (p_org_unit_rec.operating_unit_id = FND_API.G_MISS_NUM) AND
507: (p_org_unit_rec.relationship_type_code = FND_API.G_MISS_CHAR) AND
508: (p_org_unit_rec.active_start_date = FND_API.G_MISS_DATE) AND
509: (p_org_unit_rec.active_end_date = SYSDATE) AND
510: (p_org_unit_rec.context = FND_API.G_MISS_CHAR) AND

Line 507: (p_org_unit_rec.relationship_type_code = FND_API.G_MISS_CHAR) AND

503: IS
504: BEGIN
505: IF (p_org_unit_rec.instance_id = FND_API.G_MISS_NUM) AND
506: (p_org_unit_rec.operating_unit_id = FND_API.G_MISS_NUM) AND
507: (p_org_unit_rec.relationship_type_code = FND_API.G_MISS_CHAR) AND
508: (p_org_unit_rec.active_start_date = FND_API.G_MISS_DATE) AND
509: (p_org_unit_rec.active_end_date = SYSDATE) AND
510: (p_org_unit_rec.context = FND_API.G_MISS_CHAR) AND
511: (p_org_unit_rec.attribute1 = FND_API.G_MISS_CHAR) AND

Line 508: (p_org_unit_rec.active_start_date = FND_API.G_MISS_DATE) AND

504: BEGIN
505: IF (p_org_unit_rec.instance_id = FND_API.G_MISS_NUM) AND
506: (p_org_unit_rec.operating_unit_id = FND_API.G_MISS_NUM) AND
507: (p_org_unit_rec.relationship_type_code = FND_API.G_MISS_CHAR) AND
508: (p_org_unit_rec.active_start_date = FND_API.G_MISS_DATE) AND
509: (p_org_unit_rec.active_end_date = SYSDATE) AND
510: (p_org_unit_rec.context = FND_API.G_MISS_CHAR) AND
511: (p_org_unit_rec.attribute1 = FND_API.G_MISS_CHAR) AND
512: (p_org_unit_rec.attribute2 = FND_API.G_MISS_CHAR) AND

Line 510: (p_org_unit_rec.context = FND_API.G_MISS_CHAR) AND

506: (p_org_unit_rec.operating_unit_id = FND_API.G_MISS_NUM) AND
507: (p_org_unit_rec.relationship_type_code = FND_API.G_MISS_CHAR) AND
508: (p_org_unit_rec.active_start_date = FND_API.G_MISS_DATE) AND
509: (p_org_unit_rec.active_end_date = SYSDATE) AND
510: (p_org_unit_rec.context = FND_API.G_MISS_CHAR) AND
511: (p_org_unit_rec.attribute1 = FND_API.G_MISS_CHAR) AND
512: (p_org_unit_rec.attribute2 = FND_API.G_MISS_CHAR) AND
513: (p_org_unit_rec.attribute3 = FND_API.G_MISS_CHAR) AND
514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND

Line 511: (p_org_unit_rec.attribute1 = FND_API.G_MISS_CHAR) AND

507: (p_org_unit_rec.relationship_type_code = FND_API.G_MISS_CHAR) AND
508: (p_org_unit_rec.active_start_date = FND_API.G_MISS_DATE) AND
509: (p_org_unit_rec.active_end_date = SYSDATE) AND
510: (p_org_unit_rec.context = FND_API.G_MISS_CHAR) AND
511: (p_org_unit_rec.attribute1 = FND_API.G_MISS_CHAR) AND
512: (p_org_unit_rec.attribute2 = FND_API.G_MISS_CHAR) AND
513: (p_org_unit_rec.attribute3 = FND_API.G_MISS_CHAR) AND
514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND
515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND

Line 512: (p_org_unit_rec.attribute2 = FND_API.G_MISS_CHAR) AND

508: (p_org_unit_rec.active_start_date = FND_API.G_MISS_DATE) AND
509: (p_org_unit_rec.active_end_date = SYSDATE) AND
510: (p_org_unit_rec.context = FND_API.G_MISS_CHAR) AND
511: (p_org_unit_rec.attribute1 = FND_API.G_MISS_CHAR) AND
512: (p_org_unit_rec.attribute2 = FND_API.G_MISS_CHAR) AND
513: (p_org_unit_rec.attribute3 = FND_API.G_MISS_CHAR) AND
514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND
515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND
516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND

Line 513: (p_org_unit_rec.attribute3 = FND_API.G_MISS_CHAR) AND

509: (p_org_unit_rec.active_end_date = SYSDATE) AND
510: (p_org_unit_rec.context = FND_API.G_MISS_CHAR) AND
511: (p_org_unit_rec.attribute1 = FND_API.G_MISS_CHAR) AND
512: (p_org_unit_rec.attribute2 = FND_API.G_MISS_CHAR) AND
513: (p_org_unit_rec.attribute3 = FND_API.G_MISS_CHAR) AND
514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND
515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND
516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND
517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND

Line 514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND

510: (p_org_unit_rec.context = FND_API.G_MISS_CHAR) AND
511: (p_org_unit_rec.attribute1 = FND_API.G_MISS_CHAR) AND
512: (p_org_unit_rec.attribute2 = FND_API.G_MISS_CHAR) AND
513: (p_org_unit_rec.attribute3 = FND_API.G_MISS_CHAR) AND
514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND
515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND
516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND
517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND
518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND

Line 515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND

511: (p_org_unit_rec.attribute1 = FND_API.G_MISS_CHAR) AND
512: (p_org_unit_rec.attribute2 = FND_API.G_MISS_CHAR) AND
513: (p_org_unit_rec.attribute3 = FND_API.G_MISS_CHAR) AND
514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND
515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND
516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND
517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND
518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND
519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND

Line 516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND

512: (p_org_unit_rec.attribute2 = FND_API.G_MISS_CHAR) AND
513: (p_org_unit_rec.attribute3 = FND_API.G_MISS_CHAR) AND
514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND
515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND
516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND
517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND
518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND
519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND
520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND

Line 517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND

513: (p_org_unit_rec.attribute3 = FND_API.G_MISS_CHAR) AND
514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND
515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND
516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND
517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND
518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND
519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND
520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND
521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND

Line 518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND

514: (p_org_unit_rec.attribute4 = FND_API.G_MISS_CHAR) AND
515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND
516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND
517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND
518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND
519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND
520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND
521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND
522: (p_org_unit_rec.attribute12 = FND_API.G_MISS_CHAR) AND

Line 519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND

515: (p_org_unit_rec.attribute5 = FND_API.G_MISS_CHAR) AND
516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND
517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND
518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND
519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND
520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND
521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND
522: (p_org_unit_rec.attribute12 = FND_API.G_MISS_CHAR) AND
523: (p_org_unit_rec.attribute13 = FND_API.G_MISS_CHAR) AND

Line 520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND

516: (p_org_unit_rec.attribute6 = FND_API.G_MISS_CHAR) AND
517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND
518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND
519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND
520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND
521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND
522: (p_org_unit_rec.attribute12 = FND_API.G_MISS_CHAR) AND
523: (p_org_unit_rec.attribute13 = FND_API.G_MISS_CHAR) AND
524: (p_org_unit_rec.attribute14 = FND_API.G_MISS_CHAR) AND

Line 521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND

517: (p_org_unit_rec.attribute7 = FND_API.G_MISS_CHAR) AND
518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND
519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND
520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND
521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND
522: (p_org_unit_rec.attribute12 = FND_API.G_MISS_CHAR) AND
523: (p_org_unit_rec.attribute13 = FND_API.G_MISS_CHAR) AND
524: (p_org_unit_rec.attribute14 = FND_API.G_MISS_CHAR) AND
525: (p_org_unit_rec.attribute15 = FND_API.G_MISS_CHAR) THEN

Line 522: (p_org_unit_rec.attribute12 = FND_API.G_MISS_CHAR) AND

518: (p_org_unit_rec.attribute8 = FND_API.G_MISS_CHAR) AND
519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND
520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND
521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND
522: (p_org_unit_rec.attribute12 = FND_API.G_MISS_CHAR) AND
523: (p_org_unit_rec.attribute13 = FND_API.G_MISS_CHAR) AND
524: (p_org_unit_rec.attribute14 = FND_API.G_MISS_CHAR) AND
525: (p_org_unit_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
526: RETURN TRUE;

Line 523: (p_org_unit_rec.attribute13 = FND_API.G_MISS_CHAR) AND

519: (p_org_unit_rec.attribute9 = FND_API.G_MISS_CHAR) AND
520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND
521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND
522: (p_org_unit_rec.attribute12 = FND_API.G_MISS_CHAR) AND
523: (p_org_unit_rec.attribute13 = FND_API.G_MISS_CHAR) AND
524: (p_org_unit_rec.attribute14 = FND_API.G_MISS_CHAR) AND
525: (p_org_unit_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
526: RETURN TRUE;
527: ELSE

Line 524: (p_org_unit_rec.attribute14 = FND_API.G_MISS_CHAR) AND

520: (p_org_unit_rec.attribute10 = FND_API.G_MISS_CHAR) AND
521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND
522: (p_org_unit_rec.attribute12 = FND_API.G_MISS_CHAR) AND
523: (p_org_unit_rec.attribute13 = FND_API.G_MISS_CHAR) AND
524: (p_org_unit_rec.attribute14 = FND_API.G_MISS_CHAR) AND
525: (p_org_unit_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
526: RETURN TRUE;
527: ELSE
528: RETURN FALSE;

Line 525: (p_org_unit_rec.attribute15 = FND_API.G_MISS_CHAR) THEN

521: (p_org_unit_rec.attribute11 = FND_API.G_MISS_CHAR) AND
522: (p_org_unit_rec.attribute12 = FND_API.G_MISS_CHAR) AND
523: (p_org_unit_rec.attribute13 = FND_API.G_MISS_CHAR) AND
524: (p_org_unit_rec.attribute14 = FND_API.G_MISS_CHAR) AND
525: (p_org_unit_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
526: RETURN TRUE;
527: ELSE
528: RETURN FALSE;
529: END IF;

Line 551: IF p_new_date = FND_API.G_MISS_DATE THEN

547: RETURN BOOLEAN
548: IS
549: BEGIN
550: IF p_old_date < SYSDATE THEN
551: IF p_new_date = FND_API.G_MISS_DATE THEN
552: IF ( p_stack_err_msg = TRUE ) THEN
553: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_UPDATABLE');
554: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_old_date);
555: FND_MSG_PUB.Add;