APPS.CSI_CUSTOMER_PRODUCTS_PKG dependencies on CSI_ITEM_INSTANCES

Line 861: From CSI_ITEM_INSTANCES

857: csi_gen_utility_pvt.put_line('Transfer Succes');
858: Begin
859: Select Object_Version_Number
860: Into px_Cp_Object_Version_Number
861: From CSI_ITEM_INSTANCES
862: Where instance_id = l_Instance_Rec.Instance_Id;
863: Exception
864: When Others Then
865: Null;

Line 908: From CSI_ITEM_INSTANCES

904:
905: Begin
906: Select Object_Version_Number
907: Into px_Cp_Object_Version_Number
908: From CSI_ITEM_INSTANCES
909: Where instance_id = l_Instance_Rec.Instance_Id;
910: Exception
911: When Others Then
912: Null;

Line 953: From CSI_ITEM_INSTANCES

949: IF x_Return_Status = FND_API.G_Ret_Sts_Success THEN
950: csi_gen_utility_pvt.put_line('Update Instance related info success in non Transfer Mode');
951: Select Object_Version_Number
952: Into px_Cp_Object_Version_Number
953: From CSI_ITEM_INSTANCES
954: Where instance_id = l_Instance_Rec.Instance_Id;
955: End If;
956: -- csi_gen_utility_pvt.put_line('Product Ins Obj '||px_Cp_Object_Version_Number);
957: End If;

Line 1168: FROM CSI_ITEM_INSTANCES

1164: p_COMMENTS IN VARCHAR2
1165: ) IS
1166: CURSOR C1 IS
1167: SELECT *
1168: FROM CSI_ITEM_INSTANCES
1169: WHERE INSTANCE_ID = p_CUSTOMER_PRODUCT_ID
1170: FOR UPDATE of INSTANCE_ID NOWAIT;
1171: FetchC1 C1%ROWTYPE;
1172: CURSOR C2 IS

Line 1369: FROM CSI_ITEM_INSTANCES

1365: l_dummy NUMBER;
1366: l_new_parent_cp_id NUMBER;
1367: CURSOR Get_Qty_CUR IS
1368: SELECT Quantity
1369: FROM CSI_ITEM_INSTANCES
1370: WHERE Instance_Id = p_Cp_Id;
1371:
1372: BEGIN
1373: x_return_status := FND_API.G_RET_STS_SUCCESS;