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 1052: FROM CSI_ITEM_INSTANCES

1048: VERSION_NUMBER = p_mr_version_number;
1049:
1050: CURSOR l_get_item_instance_id_csr(p_instance_number IN VARCHAR2) IS
1051: SELECT INSTANCE_ID
1052: FROM CSI_ITEM_INSTANCES
1053: WHERE INSTANCE_NUMBER = p_instance_number;
1054:
1055: CURSOR l_get_status_code_csr(p_status_meaning IN VARCHAR2) IS
1056: SELECT LOOKUP_CODE

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

1141:
1142: --performace tuning related change
1143:
1144: /*SELECT c.counter_id
1145: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue
1146: WHERE C.COUNTER_GROUP_ID(+) = CTRGRP.COUNTER_GROUP_ID
1147: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
1148: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
1149: AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

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

1213:
1214: --performace tuning related change
1215: /*
1216: SELECT c.counter_id
1217: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue
1218: WHERE C.COUNTER_GROUP_ID(+) = CTRGRP.COUNTER_GROUP_ID
1219: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
1220: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
1221: AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 1362: csi_item_instances CSI

1358: -- For bug# 4172783.
1359: CURSOR l_ue_err_details_csr (p_ue_id IN NUMBER) IS
1360: SELECT CSI.instance_number, UE.due_date, MR.title
1361: FROM ahl_unit_effectivities_b UE, ahl_mr_headers_b MR,
1362: csi_item_instances CSI
1363: WHERE UE.unit_effectivity_id = p_ue_id
1364: AND UE.mr_header_id = MR.mr_header_id
1365: AND UE.csi_item_instance_id = CSI.instance_id;
1366:

Line 1400: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;

1396: l_temp_deferral_flag BOOLEAN;
1397:
1398: l_prior_ue_status VARCHAR2(20);
1399:
1400: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;
1401: l_err_due_date DATE;
1402: l_err_title ahl_mr_headers_b.title%TYPE;
1403: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;
1404: l_service_line_id ahl_unit_effectivities_b.service_line_id%TYPE;

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

3636: /* Fix for bug# 6956784. Replace CS_COUNTERS with CSI_COUNTERS_VL.
3637: * Use COUNTER_TEMPLATE_NAME for counter name
3638: * Uptake R12 Counters Changes.
3639: SELECT c.name
3640: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII--, MTL_SYSTEM_ITEMS_KFV MSITEM
3641: WHERE C.COUNTER_GROUP_ID = CTRGRP.COUNTER_GROUP_ID
3642: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
3643: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
3644: --AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 3650: csi_counter_associations cca --, CSI_ITEM_INSTANCES CII

3646: AND CII.INSTANCE_ID = p_instance_id
3647: */
3648: SELECT cc.COUNTER_TEMPLATE_NAME counter_name
3649: FROM csi_counters_vl cc,
3650: csi_counter_associations cca --, CSI_ITEM_INSTANCES CII
3651: WHERE cc.counter_id = cca.counter_id
3652: and cca.source_object_code = 'CP'
3653: and cca.source_object_id = p_instance_id
3654: MINUS

Line 4912: CURSOR csi_item_instances_csr(p_csi_instance_number IN VARCHAR2) IS

4908: PROCEDURE Convert_Instance (p_x_csi_item_instance_id IN OUT NOCOPY NUMBER,
4909: p_csi_instance_number IN VARCHAR2)
4910: IS
4911:
4912: CURSOR csi_item_instances_csr(p_csi_instance_number IN VARCHAR2) IS
4913: SELECT instance_id
4914: FROM csi_item_instances
4915: WHERE instance_number = p_csi_instance_number
4916: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));

Line 4914: FROM csi_item_instances

4910: IS
4911:
4912: CURSOR csi_item_instances_csr(p_csi_instance_number IN VARCHAR2) IS
4913: SELECT instance_id
4914: FROM csi_item_instances
4915: WHERE instance_number = p_csi_instance_number
4916: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
4917:
4918: l_csi_item_instance_id NUMBER;

Line 4927: OPEN csi_item_instances_csr (p_csi_instance_number);

4923: p_x_csi_item_instance_id = FND_API.G_MISS_NUM) THEN
4924: IF (p_csi_instance_number IS NOT NULL AND
4925: p_csi_instance_number <> FND_API.G_MISS_CHAR) THEN
4926: -- get instance_id.
4927: OPEN csi_item_instances_csr (p_csi_instance_number);
4928: FETCH csi_item_instances_csr INTO l_csi_item_instance_id;
4929: IF (csi_item_instances_csr%NOTFOUND) THEN
4930: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_INST_NOTFOUND');
4931: FND_MESSAGE.Set_Token('NUMBER',p_csi_instance_number);

Line 4928: FETCH csi_item_instances_csr INTO l_csi_item_instance_id;

4924: IF (p_csi_instance_number IS NOT NULL AND
4925: p_csi_instance_number <> FND_API.G_MISS_CHAR) THEN
4926: -- get instance_id.
4927: OPEN csi_item_instances_csr (p_csi_instance_number);
4928: FETCH csi_item_instances_csr INTO l_csi_item_instance_id;
4929: IF (csi_item_instances_csr%NOTFOUND) THEN
4930: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_INST_NOTFOUND');
4931: FND_MESSAGE.Set_Token('NUMBER',p_csi_instance_number);
4932: FND_MSG_PUB.ADD;

Line 4929: IF (csi_item_instances_csr%NOTFOUND) THEN

4925: p_csi_instance_number <> FND_API.G_MISS_CHAR) THEN
4926: -- get instance_id.
4927: OPEN csi_item_instances_csr (p_csi_instance_number);
4928: FETCH csi_item_instances_csr INTO l_csi_item_instance_id;
4929: IF (csi_item_instances_csr%NOTFOUND) THEN
4930: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_INST_NOTFOUND');
4931: FND_MESSAGE.Set_Token('NUMBER',p_csi_instance_number);
4932: FND_MSG_PUB.ADD;
4933: ELSE

Line 4936: CLOSE csi_item_instances_csr;

4932: FND_MSG_PUB.ADD;
4933: ELSE
4934: p_x_csi_item_instance_id := l_csi_item_instance_id;
4935: END IF;
4936: CLOSE csi_item_instances_csr;
4937: END IF;
4938: END IF;
4939:
4940: END Convert_Instance;

Line 4956: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

4952: FROM ahl_mr_headers_app_v
4953: WHERE mr_header_id = p_mr_header_id;
4954:
4955: -- To validate instance.
4956: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
4957: SELECT instance_number, active_end_date
4958: FROM csi_item_instances
4959: WHERE instance_id = p_csi_item_instance_id;
4960:

Line 4958: FROM csi_item_instances

4954:
4955: -- To validate instance.
4956: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
4957: SELECT instance_number, active_end_date
4958: FROM csi_item_instances
4959: WHERE instance_id = p_csi_item_instance_id;
4960:
4961: -- To validate unit.
4962: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS

Line 4975: l_instance_number csi_item_instances.instance_number%TYPE;

4971: l_csi_item_instance_id NUMBER;
4972: l_active_end_date DATE;
4973: l_active_start_date DATE;
4974: l_name ahl_unit_config_headers.name%TYPE;
4975: l_instance_number csi_item_instances.instance_number%TYPE;
4976:
4977: BEGIN
4978:
4979: -- validate mr id.

Line 5005: OPEN csi_item_instances_csr (p_x_csi_item_instance_id);

5001: END IF;
5002:
5003: -- validate item instance.
5004: IF (p_x_csi_item_instance_id IS NOT NULL) THEN
5005: OPEN csi_item_instances_csr (p_x_csi_item_instance_id);
5006: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
5007: IF (csi_item_instances_csr%NOTFOUND) THEN
5008: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5009: FND_MESSAGE.Set_Token('INST_ID', p_x_csi_item_instance_id);

Line 5006: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;

5002:
5003: -- validate item instance.
5004: IF (p_x_csi_item_instance_id IS NOT NULL) THEN
5005: OPEN csi_item_instances_csr (p_x_csi_item_instance_id);
5006: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
5007: IF (csi_item_instances_csr%NOTFOUND) THEN
5008: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5009: FND_MESSAGE.Set_Token('INST_ID', p_x_csi_item_instance_id);
5010: FND_MSG_PUB.ADD;

Line 5007: IF (csi_item_instances_csr%NOTFOUND) THEN

5003: -- validate item instance.
5004: IF (p_x_csi_item_instance_id IS NOT NULL) THEN
5005: OPEN csi_item_instances_csr (p_x_csi_item_instance_id);
5006: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
5007: IF (csi_item_instances_csr%NOTFOUND) THEN
5008: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5009: FND_MESSAGE.Set_Token('INST_ID', p_x_csi_item_instance_id);
5010: FND_MSG_PUB.ADD;
5011: CLOSE csi_item_instances_csr;

Line 5011: CLOSE csi_item_instances_csr;

5007: IF (csi_item_instances_csr%NOTFOUND) THEN
5008: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5009: FND_MESSAGE.Set_Token('INST_ID', p_x_csi_item_instance_id);
5010: FND_MSG_PUB.ADD;
5011: CLOSE csi_item_instances_csr;
5012: --dbms_output.put_line('Instance not found');
5013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5014: ELSIF (trunc(l_active_end_date) < trunc(sysdate)) THEN
5015: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');

Line 5020: CLOSE csi_item_instances_csr;

5016: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);
5017: FND_MSG_PUB.ADD;
5018: --dbms_output.put_line('Instance has expired');
5019: END IF;
5020: CLOSE csi_item_instances_csr;
5021: END IF;
5022:
5023: -- Validate unit config id.
5024: IF (p_unit_config_header_id IS NOT NULL) THEN

Line 5089: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

5085: FROM ahl_mr_headers_app_v
5086: WHERE mr_header_id = p_mr_header_id;
5087:
5088: -- To validate instance.
5089: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
5090: SELECT instance_number, active_end_date
5091: FROM csi_item_instances
5092: WHERE instance_id = p_csi_item_instance_id;
5093:

Line 5091: FROM csi_item_instances

5087:
5088: -- To validate instance.
5089: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
5090: SELECT instance_number, active_end_date
5091: FROM csi_item_instances
5092: WHERE instance_id = p_csi_item_instance_id;
5093:
5094: -- Invalid assumption post bug #4360784. Fixed by AMSRINIV
5095: -- The assumption in this package is that Validate_Input_Parameters has already been called before calling this

Line 5111: l_instance_number csi_item_instances.instance_number%TYPE;

5107: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5108: l_csi_item_instance_id NUMBER;
5109: l_active_end_date DATE;
5110: l_active_start_date DATE;
5111: l_instance_number csi_item_instances.instance_number%TYPE;
5112: l_dummy VARCHAR2(1);
5113:
5114: BEGIN
5115:

Line 5140: OPEN csi_item_instances_csr (p_csi_item_instance_id);

5136: END IF;
5137:
5138: -- validate item instance.
5139: IF (p_csi_item_instance_id IS NOT NULL) THEN
5140: OPEN csi_item_instances_csr (p_csi_item_instance_id);
5141: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
5142: IF (csi_item_instances_csr%NOTFOUND) THEN
5143: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5144: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);

Line 5141: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;

5137:
5138: -- validate item instance.
5139: IF (p_csi_item_instance_id IS NOT NULL) THEN
5140: OPEN csi_item_instances_csr (p_csi_item_instance_id);
5141: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
5142: IF (csi_item_instances_csr%NOTFOUND) THEN
5143: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5144: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
5145: FND_MSG_PUB.ADD;

Line 5142: IF (csi_item_instances_csr%NOTFOUND) THEN

5138: -- validate item instance.
5139: IF (p_csi_item_instance_id IS NOT NULL) THEN
5140: OPEN csi_item_instances_csr (p_csi_item_instance_id);
5141: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
5142: IF (csi_item_instances_csr%NOTFOUND) THEN
5143: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5144: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
5145: FND_MSG_PUB.ADD;
5146: CLOSE csi_item_instances_csr;

Line 5146: CLOSE csi_item_instances_csr;

5142: IF (csi_item_instances_csr%NOTFOUND) THEN
5143: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
5144: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
5145: FND_MSG_PUB.ADD;
5146: CLOSE csi_item_instances_csr;
5147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5148: ELSIF (trunc(l_active_end_date) < trunc(sysdate)) THEN
5149: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');
5150: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);

Line 5153: CLOSE csi_item_instances_csr;

5149: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');
5150: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);
5151: FND_MSG_PUB.ADD;
5152: END IF;
5153: CLOSE csi_item_instances_csr;
5154: END IF;
5155:
5156: -- Validate whether contract number + modifier combination exists
5157: -- Validate whether contract modifier is NOT NULL but contract number IS NULL