DBA Data[Home] [Help]

APPS.CSM_COUNTER_EVENT_PKG dependencies on CS_COUNTER_GRP_LOG

Line 412: PROCEDURE CTR_VAL_MAKE_DIRTY_FOREACHUSER(p_ctr_grp_log_id cs_counter_grp_log.counter_grp_log_id%type,

408: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_I_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);
409: RAISE;
410: END CTR_MAKE_DIRTY_I_FOREACHUSER;
411:
412: PROCEDURE CTR_VAL_MAKE_DIRTY_FOREACHUSER(p_ctr_grp_log_id cs_counter_grp_log.counter_grp_log_id%type,
413: p_error_msg OUT NOCOPY VARCHAR2,
414: x_return_status IN OUT NOCOPY VARCHAR2)
415: IS
416: l_counter_value_id CSI_COUNTER_READINGS.counter_value_id%TYPE;

Line 423: CURSOR l_user_ids_csr (p_counter_grp_log_id cs_counter_grp_log.counter_grp_log_id%TYPE)

419: l_counter_id NUMBER;
420: l_instance_id NUMBER;
421: l_max_counter_readings NUMBER;
422:
423: CURSOR l_user_ids_csr (p_counter_grp_log_id cs_counter_grp_log.counter_grp_log_id%TYPE)
424: IS
425: SELECT acc.user_id,
426: cval.counter_value_id,
427: ctr.counter_id,

Line 556: PROCEDURE CTR_VAL_MDIRTY_U_FOREACHUSER(p_ctr_grp_log_id cs_counter_grp_log.counter_grp_log_id%type,

552: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MAKE_DIRTY_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);
553: RAISE;
554: END CTR_VAL_MAKE_DIRTY_FOREACHUSER;
555:
556: PROCEDURE CTR_VAL_MDIRTY_U_FOREACHUSER(p_ctr_grp_log_id cs_counter_grp_log.counter_grp_log_id%type,
557: p_error_msg OUT NOCOPY VARCHAR2,
558: x_return_status IN OUT NOCOPY VARCHAR2)
559: IS
560: l_err_msg VARCHAR2(4000);

Line 571: CURSOR l_user_ids_csr (p_counter_grp_log_id cs_counter_grp_log.counter_grp_log_id%type)

567: l_time_stamp DATE;
568: l_counter_value_count NUMBER;
569: l_markdirty boolean;
570:
571: CURSOR l_user_ids_csr (p_counter_grp_log_id cs_counter_grp_log.counter_grp_log_id%type)
572: IS
573: SELECT acc.user_id,
574: acc.access_id,
575: cv.counter_value_id