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_UMP_UNITMAINT_PVT dependencies on CSI_ITEM_INSTANCES

Line 1231: FROM CSI_ITEM_INSTANCES

1227: VERSION_NUMBER = p_mr_version_number;
1228:
1229: CURSOR l_get_item_instance_id_csr(p_instance_number IN VARCHAR2) IS
1230: SELECT INSTANCE_ID
1231: FROM CSI_ITEM_INSTANCES
1232: WHERE INSTANCE_NUMBER = p_instance_number;
1233:
1234: CURSOR l_get_status_code_csr(p_status_meaning IN VARCHAR2) IS
1235: SELECT LOOKUP_CODE

Line 1324: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue

1320:
1321: --performace tuning related change
1322:
1323: /*SELECT c.counter_id
1324: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue
1325: WHERE C.COUNTER_GROUP_ID(+) = CTRGRP.COUNTER_GROUP_ID
1326: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
1327: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
1328: AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 1396: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue

1392:
1393: --performace tuning related change
1394: /*
1395: SELECT c.counter_id
1396: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue
1397: WHERE C.COUNTER_GROUP_ID(+) = CTRGRP.COUNTER_GROUP_ID
1398: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
1399: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
1400: AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 1553: csi_item_instances CSI

1549: -- For bug# 4172783.
1550: CURSOR l_ue_err_details_csr (p_ue_id IN NUMBER) IS
1551: SELECT CSI.instance_number, UE.due_date, MR.title
1552: FROM ahl_unit_effectivities_b UE, ahl_mr_headers_b MR,
1553: csi_item_instances CSI
1554: WHERE UE.unit_effectivity_id = p_ue_id
1555: AND UE.mr_header_id = MR.mr_header_id
1556: AND UE.csi_item_instance_id = CSI.instance_id;
1557:

Line 1605: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;

1601: l_temp_deferral_flag BOOLEAN;
1602:
1603: l_prior_ue_status VARCHAR2(20);
1604:
1605: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;
1606: l_err_due_date DATE;
1607: l_err_title ahl_mr_headers_b.title%TYPE;
1608: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;
1609: l_service_line_id ahl_unit_effectivities_b.service_line_id%TYPE;

Line 3953: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII--, MTL_SYSTEM_ITEMS_KFV MSITEM

3949: /* Fix for bug# 6956784. Replace CS_COUNTERS with CSI_COUNTERS_VL.
3950: * Use COUNTER_TEMPLATE_NAME for counter name
3951: * Uptake R12 Counters Changes.
3952: SELECT c.name
3953: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII--, MTL_SYSTEM_ITEMS_KFV MSITEM
3954: WHERE C.COUNTER_GROUP_ID = CTRGRP.COUNTER_GROUP_ID
3955: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
3956: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
3957: --AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 3963: csi_counter_associations cca --, CSI_ITEM_INSTANCES CII

3959: AND CII.INSTANCE_ID = p_instance_id
3960: */
3961: SELECT cc.COUNTER_TEMPLATE_NAME counter_name
3962: FROM csi_counters_vl cc,
3963: csi_counter_associations cca --, CSI_ITEM_INSTANCES CII
3964: WHERE cc.counter_id = cca.counter_id
3965: and cca.source_object_code = 'CP'
3966: and cca.source_object_id = p_instance_id
3967: MINUS

Line 5250: CURSOR csi_item_instances_csr(p_csi_instance_number IN VARCHAR2) IS

5246: PROCEDURE Convert_Instance (p_x_csi_item_instance_id IN OUT NOCOPY NUMBER,
5247: p_csi_instance_number IN VARCHAR2)
5248: IS
5249:
5250: CURSOR csi_item_instances_csr(p_csi_instance_number IN VARCHAR2) IS
5251: SELECT instance_id
5252: FROM csi_item_instances
5253: WHERE instance_number = p_csi_instance_number;
5254: -- bypass validation to fix bug# 8861642

Line 5252: FROM csi_item_instances

5248: IS
5249:
5250: CURSOR csi_item_instances_csr(p_csi_instance_number IN VARCHAR2) IS
5251: SELECT instance_id
5252: FROM csi_item_instances
5253: WHERE instance_number = p_csi_instance_number;
5254: -- bypass validation to fix bug# 8861642
5255: --AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
5256:

Line 5266: OPEN csi_item_instances_csr (p_csi_instance_number);

5262: p_x_csi_item_instance_id = FND_API.G_MISS_NUM) THEN
5263: IF (p_csi_instance_number IS NOT NULL AND
5264: p_csi_instance_number <> FND_API.G_MISS_CHAR) THEN
5265: -- get instance_id.
5266: OPEN csi_item_instances_csr (p_csi_instance_number);
5267: FETCH csi_item_instances_csr INTO l_csi_item_instance_id;
5268: IF (csi_item_instances_csr%NOTFOUND) THEN
5269: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_INST_NOTFOUND');
5270: FND_MESSAGE.Set_Token('NUMBER',p_csi_instance_number);

Line 5267: FETCH csi_item_instances_csr INTO l_csi_item_instance_id;

5263: IF (p_csi_instance_number IS NOT NULL AND
5264: p_csi_instance_number <> FND_API.G_MISS_CHAR) THEN
5265: -- get instance_id.
5266: OPEN csi_item_instances_csr (p_csi_instance_number);
5267: FETCH csi_item_instances_csr INTO l_csi_item_instance_id;
5268: IF (csi_item_instances_csr%NOTFOUND) THEN
5269: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_INST_NOTFOUND');
5270: FND_MESSAGE.Set_Token('NUMBER',p_csi_instance_number);
5271: FND_MSG_PUB.ADD;

Line 5268: IF (csi_item_instances_csr%NOTFOUND) THEN

5264: p_csi_instance_number <> FND_API.G_MISS_CHAR) THEN
5265: -- get instance_id.
5266: OPEN csi_item_instances_csr (p_csi_instance_number);
5267: FETCH csi_item_instances_csr INTO l_csi_item_instance_id;
5268: IF (csi_item_instances_csr%NOTFOUND) THEN
5269: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_INST_NOTFOUND');
5270: FND_MESSAGE.Set_Token('NUMBER',p_csi_instance_number);
5271: FND_MSG_PUB.ADD;
5272: ELSE

Line 5275: CLOSE csi_item_instances_csr;

5271: FND_MSG_PUB.ADD;
5272: ELSE
5273: p_x_csi_item_instance_id := l_csi_item_instance_id;
5274: END IF;
5275: CLOSE csi_item_instances_csr;
5276: END IF;
5277: END IF;
5278:
5279: END Convert_Instance;

Line 5297: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

5293: FROM ahl_mr_headers_app_v
5294: WHERE mr_header_id = p_mr_header_id;
5295:
5296: -- To validate instance.
5297: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
5298: SELECT instance_number --, active_end_date
5299: FROM csi_item_instances
5300: WHERE instance_id = p_csi_item_instance_id;
5301:

Line 5299: FROM csi_item_instances

5295:
5296: -- To validate instance.
5297: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
5298: SELECT instance_number --, active_end_date
5299: FROM csi_item_instances
5300: WHERE instance_id = p_csi_item_instance_id;
5301:
5302: -- To validate unit.
5303: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS

Line 5327: l_instance_number csi_item_instances.instance_number%TYPE;

5323: l_csi_item_instance_id NUMBER;
5324: l_active_end_date DATE;
5325: l_active_start_date DATE;
5326: l_name ahl_unit_config_headers.name%TYPE;
5327: l_instance_number csi_item_instances.instance_number%TYPE;
5328: l_dummy_var VARCHAR2(1);
5329:
5330: BEGIN
5331:

Line 5358: OPEN csi_item_instances_csr (p_x_csi_item_instance_id);

5354: END IF;
5355:
5356: -- validate item instance.
5357: IF (p_x_csi_item_instance_id IS NOT NULL) THEN
5358: OPEN csi_item_instances_csr (p_x_csi_item_instance_id);
5359: FETCH csi_item_instances_csr INTO l_instance_number; --, l_active_end_date;
5360: IF (csi_item_instances_csr%NOTFOUND) THEN
5361: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5362: FND_MESSAGE.Set_Token('INST_ID', p_x_csi_item_instance_id);

Line 5359: FETCH csi_item_instances_csr INTO l_instance_number; --, l_active_end_date;

5355:
5356: -- validate item instance.
5357: IF (p_x_csi_item_instance_id IS NOT NULL) THEN
5358: OPEN csi_item_instances_csr (p_x_csi_item_instance_id);
5359: FETCH csi_item_instances_csr INTO l_instance_number; --, l_active_end_date;
5360: IF (csi_item_instances_csr%NOTFOUND) THEN
5361: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5362: FND_MESSAGE.Set_Token('INST_ID', p_x_csi_item_instance_id);
5363: FND_MSG_PUB.ADD;

Line 5360: IF (csi_item_instances_csr%NOTFOUND) THEN

5356: -- validate item instance.
5357: IF (p_x_csi_item_instance_id IS NOT NULL) THEN
5358: OPEN csi_item_instances_csr (p_x_csi_item_instance_id);
5359: FETCH csi_item_instances_csr INTO l_instance_number; --, l_active_end_date;
5360: IF (csi_item_instances_csr%NOTFOUND) THEN
5361: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5362: FND_MESSAGE.Set_Token('INST_ID', p_x_csi_item_instance_id);
5363: FND_MSG_PUB.ADD;
5364: CLOSE csi_item_instances_csr;

Line 5364: CLOSE csi_item_instances_csr;

5360: IF (csi_item_instances_csr%NOTFOUND) THEN
5361: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5362: FND_MESSAGE.Set_Token('INST_ID', p_x_csi_item_instance_id);
5363: FND_MSG_PUB.ADD;
5364: CLOSE csi_item_instances_csr;
5365: --dbms_output.put_line('Instance not found');
5366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5367: /* Bypass validation to fix bug# 8567880. If instance is expired, delete UMP.
5368: Done in procedure process_unit.

Line 5376: CLOSE csi_item_instances_csr;

5372: FND_MSG_PUB.ADD;
5373: --dbms_output.put_line('Instance has expired');
5374: */
5375: END IF;
5376: CLOSE csi_item_instances_csr;
5377: END IF;
5378:
5379: -- Validate unit config id.
5380: IF (p_unit_config_header_id IS NOT NULL) THEN

Line 5457: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

5453: FROM ahl_mr_headers_app_v
5454: WHERE mr_header_id = p_mr_header_id;
5455:
5456: -- To validate instance.
5457: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
5458: SELECT instance_number --, active_end_date
5459: FROM csi_item_instances
5460: WHERE instance_id = p_csi_item_instance_id;
5461:

Line 5459: FROM csi_item_instances

5455:
5456: -- To validate instance.
5457: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
5458: SELECT instance_number --, active_end_date
5459: FROM csi_item_instances
5460: WHERE instance_id = p_csi_item_instance_id;
5461:
5462: -- Invalid assumption post bug #4360784. Fixed by AMSRINIV
5463: -- The assumption in this package is that Validate_Input_Parameters has already been called before calling this

Line 5479: l_instance_number csi_item_instances.instance_number%TYPE;

5475: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5476: l_csi_item_instance_id NUMBER;
5477: --l_active_end_date DATE;
5478: l_active_start_date DATE;
5479: l_instance_number csi_item_instances.instance_number%TYPE;
5480: l_dummy VARCHAR2(1);
5481:
5482: BEGIN
5483:

Line 5508: OPEN csi_item_instances_csr (p_csi_item_instance_id);

5504: END IF;
5505:
5506: -- validate item instance.
5507: IF (p_csi_item_instance_id IS NOT NULL) THEN
5508: OPEN csi_item_instances_csr (p_csi_item_instance_id);
5509: FETCH csi_item_instances_csr INTO l_instance_number; --, l_active_end_date;
5510: IF (csi_item_instances_csr%NOTFOUND) THEN
5511: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5512: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);

Line 5509: FETCH csi_item_instances_csr INTO l_instance_number; --, l_active_end_date;

5505:
5506: -- validate item instance.
5507: IF (p_csi_item_instance_id IS NOT NULL) THEN
5508: OPEN csi_item_instances_csr (p_csi_item_instance_id);
5509: FETCH csi_item_instances_csr INTO l_instance_number; --, l_active_end_date;
5510: IF (csi_item_instances_csr%NOTFOUND) THEN
5511: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5512: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
5513: FND_MSG_PUB.ADD;

Line 5510: IF (csi_item_instances_csr%NOTFOUND) THEN

5506: -- validate item instance.
5507: IF (p_csi_item_instance_id IS NOT NULL) THEN
5508: OPEN csi_item_instances_csr (p_csi_item_instance_id);
5509: FETCH csi_item_instances_csr INTO l_instance_number; --, l_active_end_date;
5510: IF (csi_item_instances_csr%NOTFOUND) THEN
5511: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5512: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
5513: FND_MSG_PUB.ADD;
5514: CLOSE csi_item_instances_csr;

Line 5514: CLOSE csi_item_instances_csr;

5510: IF (csi_item_instances_csr%NOTFOUND) THEN
5511: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5512: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
5513: FND_MSG_PUB.ADD;
5514: CLOSE csi_item_instances_csr;
5515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5516: /* Bypass validation to fix bug# 8567880. If instance is expired, validate and delete UMP.
5517: Done in procedure process_unit.
5518: ELSIF (l_active_end_date < sysdate) THEN

Line 5524: CLOSE csi_item_instances_csr;

5520: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);
5521: FND_MSG_PUB.ADD;
5522: */
5523: END IF;
5524: CLOSE csi_item_instances_csr;
5525: END IF;
5526:
5527: -- Validate whether contract number + modifier combination exists
5528: -- Validate whether contract modifier is NOT NULL but contract number IS NULL