APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_CTR_ITEM_ASSOCIATIONS

Line 4648: FROM csi_ctr_item_associations

4644: */
4645: SELECT group_id,
4646: associated_to_group,--Added for bug 9142776
4647: COUNTER_ID --Added for bug 9142776
4648: FROM csi_ctr_item_associations
4649: WHERE inventory_item_id = p_src_object_id;
4650: BEGIN
4651: -- Standard Start of API savepoint
4652: SAVEPOINT create_item_instance_pvt;

Line 6188: FROM csi_ctr_item_associations

6184: --l_counter_group_id := NULL;
6185: BEGIN
6186: SELECT count(*)
6187: INTO l_counter_group_id
6188: FROM csi_ctr_item_associations
6189: WHERE inventory_item_id = p_instance_rec.inventory_item_id
6190: AND ROWNUM = 1;
6191: EXCEPTION
6192: WHEN NO_DATA_FOUND THEN

Line 6196: -- csi_ctr_item_associations with a particular inv_id.

6192: WHEN NO_DATA_FOUND THEN
6193: NULL;
6194: -- Too many rows exception will not arise
6195: -- as ctr API will make sure there will be only one record in
6196: -- csi_ctr_item_associations with a particular inv_id.
6197: END;
6198: -- R12 Changes ...
6199: /* IF CS_Counters_PUB.Ctr_Grp_Template_Exists(p_instance_rec.inventory_item_id) THEN
6200: CS_Counters_PUB.AutoInstantiate_Counters */

Line 11758: FROM csi_ctr_item_associations

11754: CURSOR CTR_GROUP(p_src_object_id IN NUMBER) IS
11755: SELECT group_id,
11756: associated_to_group, --Added for bug 9142776
11757: COUNTER_ID --Added for bug 9142776
11758: FROM csi_ctr_item_associations
11759: WHERE inventory_item_id = p_src_object_id;
11760:
11761: CURSOR party_owner_rec (p_instance_id NUMBER) is
11762: SELECT

Line 14829: FROM csi_ctr_item_associations

14825: --l_counter_group_id := NULL;
14826: BEGIN
14827: SELECT COUNT(*)
14828: INTO l_counter_group_id
14829: FROM csi_ctr_item_associations
14830: WHERE inventory_item_id = l_get_instance_rec.inventory_item_id
14831: AND ROWNUM=1;
14832: EXCEPTION
14833: WHEN NO_DATA_FOUND THEN