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.AHL_UC_UTILIZATION_PVT dependencies on CSI_ITEM_INSTANCES

Line 252: FROM csi_item_instances

248:
249: -- For instance_id.
250: CURSOR csi_item_instance_csr(c_instance_number VARCHAR2) IS
251: SELECT instance_id
252: FROM csi_item_instances
253: WHERE instance_number = c_instance_number;
254:
255: l_return_val BOOLEAN;
256: l_lookup_code fnd_lookups.lookup_code%TYPE;

Line 378: CURSOR csi_item_instances_csr(c_instance_id NUMBER) IS

374: x_found OUT NOCOPY VARCHAR2,
375: x_based_on OUT NOCOPY VARCHAR2)
376: IS
377: -- Get location type code.
378: CURSOR csi_item_instances_csr(c_instance_id NUMBER) IS
379: SELECT location_type_code
380: FROM csi_item_instances
381: WHERE instance_id = c_instance_id
382: AND TRUNC(sysdate) < TRUNC(NVL(active_end_date, sysdate+1));

Line 380: FROM csi_item_instances

376: IS
377: -- Get location type code.
378: CURSOR csi_item_instances_csr(c_instance_id NUMBER) IS
379: SELECT location_type_code
380: FROM csi_item_instances
381: WHERE instance_id = c_instance_id
382: AND TRUNC(sysdate) < TRUNC(NVL(active_end_date, sysdate+1));
383:
384: -- Validate Counter ID.

Line 401: FROM csi_item_instances csi

397: SELECT instance_id,
398: instance_usage_code,
399: active_start_date,
400: active_end_date
401: FROM csi_item_instances csi
402: WHERE inventory_item_id = c_inventory_item_id
403: AND last_vld_organization_id = c_organization_id
404: AND serial_number = c_serial_number;
405:

Line 446: l_location_type_code csi_item_instances.location_type_code%TYPE;

442: l_master_config_name ahl_mc_headers_b.name%TYPE;
443: l_master_config_id NUMBER;
444:
445: l_unit_config_name ahl_unit_config_headers.name%TYPE;
446: l_location_type_code csi_item_instances.location_type_code%TYPE;
447: l_active_end_date DATE;
448: l_active_start_date DATE;
449:
450: l_found VARCHAR2(50) := NULL;

Line 475: OPEN csi_item_instances_csr(l_csi_item_instance_id);

471: l_based_on := l_based_on || ':' || 'COUNTERID';
472: l_found := l_found || ':' || 'COUNTER';
473:
474: -- Find out the csi item status code.
475: OPEN csi_item_instances_csr(l_csi_item_instance_id);
476: FETCH csi_item_instances_csr INTO l_location_type_code;
477: IF (csi_item_instances_csr%NOTFOUND) THEN
478: FND_MESSAGE.set_name('AHL','AHL_UC_CSII_INVALID');
479: FND_MESSAGE.set_token('CSII',p_utilization_rec.csi_item_instance_id);

Line 476: FETCH csi_item_instances_csr INTO l_location_type_code;

472: l_found := l_found || ':' || 'COUNTER';
473:
474: -- Find out the csi item status code.
475: OPEN csi_item_instances_csr(l_csi_item_instance_id);
476: FETCH csi_item_instances_csr INTO l_location_type_code;
477: IF (csi_item_instances_csr%NOTFOUND) THEN
478: FND_MESSAGE.set_name('AHL','AHL_UC_CSII_INVALID');
479: FND_MESSAGE.set_token('CSII',p_utilization_rec.csi_item_instance_id);
480: FND_MSG_PUB.add;

Line 477: IF (csi_item_instances_csr%NOTFOUND) THEN

473:
474: -- Find out the csi item status code.
475: OPEN csi_item_instances_csr(l_csi_item_instance_id);
476: FETCH csi_item_instances_csr INTO l_location_type_code;
477: IF (csi_item_instances_csr%NOTFOUND) THEN
478: FND_MESSAGE.set_name('AHL','AHL_UC_CSII_INVALID');
479: FND_MESSAGE.set_token('CSII',p_utilization_rec.csi_item_instance_id);
480: FND_MSG_PUB.add;
481: --dbms_output.put_line('CSI Item Instance not found');

Line 485: CLOSE csi_item_instances_csr;

481: --dbms_output.put_line('CSI Item Instance not found');
482: ELSE
483: l_tmp_instance_id := l_csi_item_instance_id;
484: END IF; -- csi not found.
485: CLOSE csi_item_instances_csr;
486: END IF;
487: CLOSE cs_counters_csr;
488: END IF;
489: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 495: -- Check if Inventory item and serial number are valid and exist in csi_item_instances.

491: L_DEBUG_KEY,
492: 'Validated Counter Id.');
493: END IF;
494:
495: -- Check if Inventory item and serial number are valid and exist in csi_item_instances.
496: IF (p_utilization_rec.inventory_item_id IS NOT NULL) AND
497: (p_utilization_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
498: OPEN csi_item_serial_csr(p_utilization_rec.inventory_item_id,
499: p_utilization_rec.organization_id,

Line 531: OPEN csi_item_instances_csr(p_utilization_rec.csi_item_instance_id);

527:
528: -- Check if csi_item_instance_id present.
529: IF (p_utilization_rec.csi_item_instance_id IS NOT NULL) AND
530: (p_utilization_rec.csi_item_instance_id <> FND_API.G_MISS_NUM) THEN
531: OPEN csi_item_instances_csr(p_utilization_rec.csi_item_instance_id);
532: FETCH csi_item_instances_csr INTO l_location_type_code;
533: IF (csi_item_instances_csr%NOTFOUND) THEN
534: FND_MESSAGE.set_name('AHL','AHL_UC_CSII_INVALID');
535: FND_MESSAGE.set_token('CSII',p_utilization_rec.csi_item_instance_id);

Line 532: FETCH csi_item_instances_csr INTO l_location_type_code;

528: -- Check if csi_item_instance_id present.
529: IF (p_utilization_rec.csi_item_instance_id IS NOT NULL) AND
530: (p_utilization_rec.csi_item_instance_id <> FND_API.G_MISS_NUM) THEN
531: OPEN csi_item_instances_csr(p_utilization_rec.csi_item_instance_id);
532: FETCH csi_item_instances_csr INTO l_location_type_code;
533: IF (csi_item_instances_csr%NOTFOUND) THEN
534: FND_MESSAGE.set_name('AHL','AHL_UC_CSII_INVALID');
535: FND_MESSAGE.set_token('CSII',p_utilization_rec.csi_item_instance_id);
536: FND_MSG_PUB.add;

Line 533: IF (csi_item_instances_csr%NOTFOUND) THEN

529: IF (p_utilization_rec.csi_item_instance_id IS NOT NULL) AND
530: (p_utilization_rec.csi_item_instance_id <> FND_API.G_MISS_NUM) THEN
531: OPEN csi_item_instances_csr(p_utilization_rec.csi_item_instance_id);
532: FETCH csi_item_instances_csr INTO l_location_type_code;
533: IF (csi_item_instances_csr%NOTFOUND) THEN
534: FND_MESSAGE.set_name('AHL','AHL_UC_CSII_INVALID');
535: FND_MESSAGE.set_token('CSII',p_utilization_rec.csi_item_instance_id);
536: FND_MSG_PUB.add;
537: --dbms_output.put_line('CSI Item Instance not found');

Line 546: CLOSE csi_item_instances_csr;

542: --dbms_output.put_line('CSI Item Instance location invalid');
543: ELSE
544: l_found := l_found || ':' || 'INSTANCE';
545: END IF; /* csi item_instance */
546: CLOSE csi_item_instances_csr;
547: END IF;
548: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
549: FND_LOG.STRING(G_LEVEL_STATEMENT,
550: L_DEBUG_KEY,