APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_CTR_ITEM_ASSOCIATIONS

Line 1161: FROM csi_ctr_item_associations

1157: IF l_associated_to_group = 'Y' and l_counter_id IS NULL THEN
1158: BEGIN
1159: SELECT 'x'
1160: INTO l_item_invalid
1161: FROM csi_ctr_item_associations
1162: WHERE inventory_item_id = l_inventory_item_id
1163: AND nvl(associated_to_group,'N') = 'Y';
1164:
1165: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_INV_ITEM_ASSOC');

Line 1179: FROM csi_ctr_item_associations

1175: IF l_group_id IS NOT NULL THEN
1176: BEGIN
1177: SELECT 'x'
1178: INTO l_item_invalid
1179: FROM csi_ctr_item_associations
1180: WHERE inventory_item_id = l_inventory_item_id
1181: AND associated_to_group = l_associated_to_group
1182: -- AND group_id = l_group_id
1183: AND counter_id = l_counter_id;

Line 1203: FROM csi_ctr_item_associations

1199:
1200: BEGIN
1201: SELECT 'Y'
1202: INTO l_item_found
1203: FROM csi_ctr_item_associations
1204: WHERE inventory_item_id = l_inventory_item_id
1205: AND associated_to_group = 'Y';
1206:
1207: EXCEPTION

Line 1220: FROM csi_ctr_item_associations

1216: ELSE
1217: BEGIN
1218: SELECT 'x'
1219: INTO l_item_invalid
1220: FROM csi_ctr_item_associations
1221: WHERE inventory_item_id = l_inventory_item_id
1222: AND associated_to_group = l_associated_to_group
1223: AND group_id IS NULL
1224: AND counter_id = l_counter_id;

Line 1239: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Insert_Row(

1235: END IF;
1236: END IF;
1237:
1238: /* Call the table Handler */
1239: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Insert_Row(
1240: px_CTR_ASSOCIATION_ID => l_ctr_association_id
1241: ,p_GROUP_ID => l_group_id
1242: ,p_INVENTORY_ITEM_ID => l_inventory_item_id
1243: ,p_OBJECT_VERSION_NUMBER => 1

Line 3592: FROM csi_ctr_item_associations_v

3588: ,use_past_reading
3589: ,associated_to_group
3590: ,maint_organization_id
3591: ,primary_failure_flag
3592: FROM csi_ctr_item_associations_v
3593: WHERE ctr_association_id = p_ctr_association_id
3594: FOR UPDATE OF OBJECT_VERSION_NUMBER;
3595: l_old_item_associations_rec cur_item_assoc_rec%ROWTYPE;
3596:

Line 3840: FROM csi_ctr_item_associations

3836: IF l_item_associations_rec.inventory_item_id <> l_old_item_associations_rec.inventory_item_id THEN
3837: BEGIN
3838: SELECT 'x'
3839: INTO l_item_invalid
3840: FROM csi_ctr_item_associations
3841: WHERE inventory_item_id = l_item_associations_rec.inventory_item_id;
3842:
3843: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_INV_ITEM_ASSOC');
3844: EXCEPTION

Line 3858: FROM csi_ctr_item_associations

3854: IF l_item_associations_rec.group_id IS NOT NULL THEN
3855: BEGIN
3856: SELECT 'x'
3857: INTO l_item_invalid
3858: FROM csi_ctr_item_associations
3859: WHERE inventory_item_id = l_item_associations_rec.inventory_item_id
3860: AND associated_to_group = l_item_associations_rec.associated_to_group
3861: -- AND group_id = l_group_id
3862: AND counter_id = l_item_associations_rec.counter_id;

Line 3882: FROM csi_ctr_item_associations

3878:
3879: BEGIN
3880: SELECT 'Y'
3881: INTO l_item_found
3882: FROM csi_ctr_item_associations
3883: WHERE inventory_item_id = l_item_associations_rec.inventory_item_id
3884: AND associated_to_group = 'Y';
3885:
3886: EXCEPTION

Line 3899: FROM csi_ctr_item_associations

3895: ELSE
3896: BEGIN
3897: SELECT 'x'
3898: INTO l_item_invalid
3899: FROM csi_ctr_item_associations
3900: WHERE inventory_item_id = l_item_associations_rec.inventory_item_id
3901: AND associated_to_group = l_item_associations_rec.associated_to_group
3902: AND group_id IS NULL
3903: AND counter_id = l_item_associations_rec.counter_id;

Line 3920: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Update_Row(

3916:
3917: */
3918: -- Call the table handler
3919:
3920: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Update_Row(
3921: p_CTR_ASSOCIATION_ID => p_ctr_item_associations_rec.ctr_association_id
3922: ,p_GROUP_ID => p_ctr_item_associations_rec.group_id
3923: ,p_INVENTORY_ITEM_ID => p_ctr_item_associations_rec.inventory_item_id
3924: ,p_OBJECT_VERSION_NUMBER => p_ctr_item_associations_rec.object_version_number + 1

Line 8627: FROM csi_ctr_item_associations

8623: l_associated_to_group VARCHAR2(1);
8624:
8625: CURSOR get_item_details(p_group_id NUMBER) IS
8626: SELECT ctr_association_id, counter_id
8627: FROM csi_ctr_item_associations
8628: WHERE counter_id IS NOT NULL
8629: AND associated_to_group = 'Y'
8630: AND group_id = p_group_id;
8631:

Line 8680: FROM csi_ctr_item_associations

8676: /* Start of validation */
8677: BEGIN
8678: SELECT associated_to_group, group_id, counter_id
8679: INTO l_associated_to_group, l_group_id, l_counter_id
8680: FROM csi_ctr_item_associations
8681: WHERE ctr_association_id = l_ctr_associations_id;
8682:
8683: IF l_associated_to_group = 'Y' THEN
8684: FOR get_item_rec in get_item_details(l_group_id) LOOP

Line 8706: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row

8702:
8703: /* Now Delete the data that was verified */
8704: FOR get_item_rec in get_item_details(l_group_id) LOOP
8705: /* Call the table Handler */
8706: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row
8707: (p_CTR_ASSOCIATION_ID => get_item_rec.ctr_association_id);
8708:
8709: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
8710: ROLLBACK TO delete_item_association_pvt;

Line 8717: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row

8713: END LOOP;
8714:
8715: /* Now Delete the main group-item association */
8716: /* Call the table Handler */
8717: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row
8718: (p_CTR_ASSOCIATION_ID => l_ctr_associations_id);
8719:
8720: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
8721: ROLLBACK TO delete_item_association_pvt;

Line 8743: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row

8739: END;
8740: END LOOP;
8741: /* Now Delete the data that was verified */
8742: /* Call the table Handler */
8743: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row
8744: (p_CTR_ASSOCIATION_ID => l_ctr_associations_id);
8745:
8746: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
8747: ROLLBACK TO delete_item_association_pvt;