DBA Data[Home] [Help]

APPS.CSM_COUNTER_EVENT_PKG dependencies on CSM_PROFILE_PKG

Line 485: l_max_counter_readings := NVL(csm_profile_pkg.get_max_readings_per_counter(l_user_id),0);

481: l_user_id := r_user_id_rec.user_id;
482: l_counter_value_id := r_user_id_rec.counter_value_id;
483: l_counter_id := r_user_id_rec.counter_id;
484: l_instance_id := r_user_id_rec.instance_id;
485: l_max_counter_readings := NVL(csm_profile_pkg.get_max_readings_per_counter(l_user_id),0);
486:
487: -- Call Insert ACC
488: CSM_ACC_PKG.Insert_Acc
489: ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name

Line 720: EXIT WHEN ((l_counter_value_csr%NOTFOUND) OR (l_counter_value_csr%ROWCOUNT > csm_profile_pkg.get_max_readings_per_counter(p_user_id)));

716:
717: OPEN l_counter_value_csr(p_counter_id, p_instance_id, p_user_id);
718: LOOP
719: FETCH l_counter_value_csr INTO r_counter_value_rec;
720: EXIT WHEN ((l_counter_value_csr%NOTFOUND) OR (l_counter_value_csr%ROWCOUNT > csm_profile_pkg.get_max_readings_per_counter(p_user_id)));
721:
722: l_counter_value_id := r_counter_value_rec.counter_value_id;
723:
724: --Call Insert ACC