APPS.AHL_UMP_SR_PVT dependencies on CSI_ITEM_INSTANCES

Line 223: FROM csi_item_instances

219: -- Validate Item Instance
220: CURSOR validate_instance ( c_instance_id in NUMBER)
221: IS
222: SELECT instance_id, instance_number, active_end_date
223: FROM csi_item_instances
224: WHERE instance_id = c_instance_id;
225:
226: --Cursor Variables
227: l_incident_id NUMBER;

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

377: FND_MSG_PUB.add;
378: RAISE FND_API.G_EXC_ERROR;
379: END IF;
380:
381: --Ensuring that the instance exists in csi_item_instances.
382: OPEN validate_instance(l_customer_product_id);
383: FETCH validate_instance into l_instance_id, l_instance_number, l_active_end_date;
384: --Raise an error if the instance is not a valid CSI Instance
385: IF (validate_instance%NOTFOUND) THEN

Line 1082: FROM CSI_ITEM_INSTANCES

1078: WHERE MR_HEADER_ID = p_mr_header_id;
1079:
1080: CURSOR validate_instance_id_csr(p_csi_instance_id IN NUMBER) IS
1081: SELECT INSTANCE_NUMBER
1082: FROM CSI_ITEM_INSTANCES
1083: WHERE INSTANCE_ID = p_csi_instance_id;
1084:
1085: --amsriniv. adding cursor to check if the instances on which the MRs are applicable are part of the SR Instance tree. ER 5883257
1086: CURSOR validate_sr_mr_intance_rel(c_mr_instance_id IN NUMBER,c_sr_instance_id IN NUMBER) IS

Line 1100: from csi_item_instances

1096: and trunc(nvl(ACTIVE_START_DATE, sysdate)) <= trunc(sysdate)
1097: and trunc(nvl(ACTIVE_END_DATE, sysdate + 1)) > trunc(sysdate)
1098: UNION ALL
1099: select 'X'
1100: from csi_item_instances
1101: where instance_id = c_sr_instance_id
1102: and instance_id = c_mr_instance_id;
1103:
1104: l_dummy VARCHAR2(1);

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

1586: WHERE MR_HEADER_ID like DECODE(p_mr_header_id, null, '%', p_mr_header_id) AND
1587: TITLE like DECODE(p_mr_header_id, null, p_mr_title, '%') AND
1588: VERSION_NUMBER like DECODE(p_mr_header_id, null, p_mr_version, '%')) AND
1589: VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')) AND
1590: UE.CSI_ITEM_INSTANCE_ID = (SELECT INSTANCE_ID FROM CSI_ITEM_INSTANCES
1591: WHERE INSTANCE_ID like DECODE(p_csi_instance_id, null, '%', p_csi_instance_id) AND
1592: INSTANCE_NUMBER like DECODE(p_csi_instance_id, null, p_csi_instance_number, '%')) AND
1593: EXISTS (SELECT 'x' FROM AHL_UE_RELATIONSHIPS
1594: WHERE UE_ID = p_sr_ue_id AND

Line 1610: FROM CSI_ITEM_INSTANCES

1606: AND VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')
1607: )
1608: AND UE.CSI_ITEM_INSTANCE_ID =
1609: (SELECT INSTANCE_ID
1610: FROM CSI_ITEM_INSTANCES
1611: WHERE INSTANCE_ID = NVL(p_csi_instance_id,INSTANCE_ID)
1612: AND INSTANCE_NUMBER like DECODE(p_csi_instance_id, null, p_csi_instance_number, '%')
1613: )
1614: AND EXISTS

Line 1672: FROM CSI_ITEM_INSTANCES

1668: VERSION_NUMBER = p_mr_version;
1669:
1670: CURSOR get_csi_instance_id_csr(p_csi_instance_number IN VARCHAR2) IS
1671: SELECT INSTANCE_ID
1672: FROM CSI_ITEM_INSTANCES
1673: WHERE INSTANCE_NUMBER = p_csi_instance_number;
1674:
1675: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Get_New_Asso_Val_To_Id';
1676: l_get_mr_flag BOOLEAN := true;