APPS.AHL_UMP_SR_PVT dependencies on CSI_ITEM_INSTANCES

Line 231: FROM csi_item_instances

227: -- Validate Item Instance
228: CURSOR validate_instance ( c_instance_id in NUMBER)
229: IS
230: SELECT instance_id, instance_number, active_end_date
231: FROM csi_item_instances
232: WHERE instance_id = c_instance_id;
233:
234: -- bachandr Bug # 13916897
235: CURSOR c_get_incident_occ_date(c_incident_id IN NUMBER) IS

Line 399: --Ensuring that the instance exists in csi_item_instances.

395: FND_MSG_PUB.add;
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398:
399: --Ensuring that the instance exists in csi_item_instances.
400: OPEN validate_instance(l_customer_product_id);
401: FETCH validate_instance into l_instance_id, l_instance_number, l_active_end_date;
402: --Raise an error if the instance is not a valid CSI Instance
403: IF (validate_instance%NOTFOUND) THEN

Line 1116: FROM CSI_ITEM_INSTANCES

1112: WHERE MR_HEADER_ID = p_mr_header_id;
1113:
1114: CURSOR validate_instance_id_csr(p_csi_instance_id IN NUMBER) IS
1115: SELECT INSTANCE_NUMBER
1116: FROM CSI_ITEM_INSTANCES
1117: WHERE INSTANCE_ID = p_csi_instance_id;
1118:
1119: --amsriniv. adding cursor to check if the instances on which the MRs are applicable are part of the SR Instance tree. ER 5883257
1120: CURSOR validate_sr_mr_intance_rel(c_mr_instance_id IN NUMBER,c_sr_instance_id IN NUMBER) IS

Line 1134: from csi_item_instances

1130: and trunc(nvl(ACTIVE_START_DATE, sysdate)) <= trunc(sysdate)
1131: and trunc(nvl(ACTIVE_END_DATE, sysdate + 1)) > trunc(sysdate)
1132: UNION ALL
1133: select 'X'
1134: from csi_item_instances
1135: where instance_id = c_sr_instance_id
1136: and instance_id = c_mr_instance_id;
1137:
1138: l_dummy VARCHAR2(1);

Line 1664: UE.CSI_ITEM_INSTANCE_ID = (SELECT INSTANCE_ID FROM CSI_ITEM_INSTANCES

1660: WHERE MR_HEADER_ID like DECODE(p_mr_header_id, null, '%', p_mr_header_id) AND
1661: TITLE like DECODE(p_mr_header_id, null, p_mr_title, '%') AND
1662: VERSION_NUMBER like DECODE(p_mr_header_id, null, p_mr_version, '%')) AND
1663: VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')) AND
1664: UE.CSI_ITEM_INSTANCE_ID = (SELECT INSTANCE_ID FROM CSI_ITEM_INSTANCES
1665: WHERE INSTANCE_ID like DECODE(p_csi_instance_id, null, '%', p_csi_instance_id) AND
1666: INSTANCE_NUMBER like DECODE(p_csi_instance_id, null, p_csi_instance_number, '%')) AND
1667: EXISTS (SELECT 'x' FROM AHL_UE_RELATIONSHIPS
1668: WHERE UE_ID = p_sr_ue_id AND

Line 1684: FROM CSI_ITEM_INSTANCES

1680: AND VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')
1681: )
1682: AND UE.CSI_ITEM_INSTANCE_ID =
1683: (SELECT INSTANCE_ID
1684: FROM CSI_ITEM_INSTANCES
1685: WHERE INSTANCE_ID = NVL(p_csi_instance_id,INSTANCE_ID)
1686: AND INSTANCE_NUMBER like DECODE(p_csi_instance_id, null, p_csi_instance_number, '%')
1687: )
1688: AND EXISTS

Line 1746: FROM CSI_ITEM_INSTANCES

1742: VERSION_NUMBER = p_mr_version;
1743:
1744: CURSOR get_csi_instance_id_csr(p_csi_instance_number IN VARCHAR2) IS
1745: SELECT INSTANCE_ID
1746: FROM CSI_ITEM_INSTANCES
1747: WHERE INSTANCE_NUMBER = p_csi_instance_number;
1748:
1749: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Get_New_Asso_Val_To_Id';
1750: l_get_mr_flag BOOLEAN := true;