APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_CTR_ITEM_ASSOCIATIONS

Line 1169: FROM csi_ctr_item_associations

1165: IF l_associated_to_group = 'Y' and l_counter_id IS NULL THEN
1166: BEGIN
1167: SELECT 'x'
1168: INTO l_item_invalid
1169: FROM csi_ctr_item_associations
1170: WHERE inventory_item_id = l_inventory_item_id
1171: AND nvl(associated_to_group,'N') = 'Y';
1172:
1173: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_INV_ITEM_ASSOC');

Line 1187: FROM csi_ctr_item_associations

1183: IF l_group_id IS NOT NULL THEN
1184: BEGIN
1185: SELECT 'x'
1186: INTO l_item_invalid
1187: FROM csi_ctr_item_associations
1188: WHERE inventory_item_id = l_inventory_item_id
1189: AND associated_to_group = l_associated_to_group
1190: -- AND group_id = l_group_id
1191: AND counter_id = l_counter_id;

Line 1211: FROM csi_ctr_item_associations

1207:
1208: BEGIN
1209: SELECT 'Y'
1210: INTO l_item_found
1211: FROM csi_ctr_item_associations
1212: WHERE inventory_item_id = l_inventory_item_id
1213: AND associated_to_group = 'Y';
1214:
1215: EXCEPTION

Line 1228: FROM csi_ctr_item_associations

1224: ELSE
1225: BEGIN
1226: SELECT 'x'
1227: INTO l_item_invalid
1228: FROM csi_ctr_item_associations
1229: WHERE inventory_item_id = l_inventory_item_id
1230: AND associated_to_group = l_associated_to_group
1231: AND group_id IS NULL
1232: AND counter_id = l_counter_id;

Line 1247: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Insert_Row(

1243: END IF;
1244: END IF;
1245:
1246: /* Call the table Handler */
1247: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Insert_Row(
1248: px_CTR_ASSOCIATION_ID => l_ctr_association_id
1249: ,p_GROUP_ID => l_group_id
1250: ,p_INVENTORY_ITEM_ID => l_inventory_item_id
1251: ,p_OBJECT_VERSION_NUMBER => 1

Line 3605: FROM csi_ctr_item_associations_v

3601: ,use_past_reading
3602: ,associated_to_group
3603: ,maint_organization_id
3604: ,primary_failure_flag
3605: FROM csi_ctr_item_associations_v
3606: WHERE ctr_association_id = p_ctr_association_id
3607: FOR UPDATE OF OBJECT_VERSION_NUMBER;
3608: l_old_item_associations_rec cur_item_assoc_rec%ROWTYPE;
3609:

Line 3853: FROM csi_ctr_item_associations

3849: IF l_item_associations_rec.inventory_item_id <> l_old_item_associations_rec.inventory_item_id THEN
3850: BEGIN
3851: SELECT 'x'
3852: INTO l_item_invalid
3853: FROM csi_ctr_item_associations
3854: WHERE inventory_item_id = l_item_associations_rec.inventory_item_id;
3855:
3856: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_INV_ITEM_ASSOC');
3857: EXCEPTION

Line 3871: FROM csi_ctr_item_associations

3867: IF l_item_associations_rec.group_id IS NOT NULL THEN
3868: BEGIN
3869: SELECT 'x'
3870: INTO l_item_invalid
3871: FROM csi_ctr_item_associations
3872: WHERE inventory_item_id = l_item_associations_rec.inventory_item_id
3873: AND associated_to_group = l_item_associations_rec.associated_to_group
3874: -- AND group_id = l_group_id
3875: AND counter_id = l_item_associations_rec.counter_id;

Line 3895: FROM csi_ctr_item_associations

3891:
3892: BEGIN
3893: SELECT 'Y'
3894: INTO l_item_found
3895: FROM csi_ctr_item_associations
3896: WHERE inventory_item_id = l_item_associations_rec.inventory_item_id
3897: AND associated_to_group = 'Y';
3898:
3899: EXCEPTION

Line 3912: FROM csi_ctr_item_associations

3908: ELSE
3909: BEGIN
3910: SELECT 'x'
3911: INTO l_item_invalid
3912: FROM csi_ctr_item_associations
3913: WHERE inventory_item_id = l_item_associations_rec.inventory_item_id
3914: AND associated_to_group = l_item_associations_rec.associated_to_group
3915: AND group_id IS NULL
3916: AND counter_id = l_item_associations_rec.counter_id;

Line 3933: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Update_Row(

3929:
3930: */
3931: -- Call the table handler
3932:
3933: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Update_Row(
3934: p_CTR_ASSOCIATION_ID => p_ctr_item_associations_rec.ctr_association_id
3935: ,p_GROUP_ID => p_ctr_item_associations_rec.group_id
3936: ,p_INVENTORY_ITEM_ID => p_ctr_item_associations_rec.inventory_item_id
3937: ,p_OBJECT_VERSION_NUMBER => p_ctr_item_associations_rec.object_version_number + 1

Line 8701: FROM csi_ctr_item_associations

8697: l_associated_to_group VARCHAR2(1);
8698:
8699: CURSOR get_item_details(p_group_id NUMBER,p_inv_id NUMBER) IS
8700: SELECT ctr_association_id, counter_id
8701: FROM csi_ctr_item_associations
8702: WHERE counter_id IS NOT NULL
8703: AND associated_to_group = 'Y'
8704: AND group_id = p_group_id
8705: AND inventory_item_id = p_inv_id;

Line 8755: FROM csi_ctr_item_associations

8751: /* Start of validation */
8752: BEGIN
8753: SELECT associated_to_group, group_id, counter_id, inventory_item_id
8754: INTO l_associated_to_group, l_group_id, l_counter_id, l_inventory_item_id
8755: FROM csi_ctr_item_associations
8756: WHERE ctr_association_id = l_ctr_associations_id;
8757:
8758: IF l_associated_to_group = 'Y' THEN
8759: FOR get_item_rec in get_item_details(l_group_id,l_inventory_item_id) LOOP

Line 8783: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row

8779:
8780: /* Now Delete the data that was verified */
8781: FOR get_item_rec in get_item_details(l_group_id,l_inventory_item_id) LOOP
8782: /* Call the table Handler */
8783: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row
8784: (p_CTR_ASSOCIATION_ID => get_item_rec.ctr_association_id);
8785:
8786: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
8787: ROLLBACK TO delete_item_association_pvt;

Line 8794: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row

8790: END LOOP;
8791:
8792: /* Now Delete the main group-item association */
8793: /* Call the table Handler */
8794: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row
8795: (p_CTR_ASSOCIATION_ID => l_ctr_associations_id);
8796:
8797: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
8798: ROLLBACK TO delete_item_association_pvt;

Line 8821: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row

8817: END;
8818: END LOOP;
8819: /* Now Delete the data that was verified */
8820: /* Call the table Handler */
8821: CSI_CTR_ITEM_ASSOCIATIONS_PKG.Delete_Row
8822: (p_CTR_ASSOCIATION_ID => l_ctr_associations_id);
8823:
8824: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
8825: ROLLBACK TO delete_item_association_pvt;