APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTER_READINGS_S

Line 504: select CSI_COUNTER_READINGS_S.nextval

500: --
501: -- Generate the Value_id for insert
502: l_process_flag := TRUE;
503: WHILE l_process_flag LOOP
504: select CSI_COUNTER_READINGS_S.nextval
505: into l_ctr_rdg_rec.counter_value_id from dual;
506: IF NOT Counter_Value_Exists(l_ctr_rdg_rec.counter_value_id) THEN
507: l_process_flag := FALSE;
508: END IF;

Line 1857: select CSI_COUNTER_READINGS_S.nextval

1853: -- Check and Generate Counter_value_id
1854: IF p_ctr_rdg_rec.counter_value_id IS NULL OR
1855: p_ctr_rdg_rec.counter_value_id = FND_API.G_MISS_NUM THEN
1856: WHILE l_process_flag LOOP
1857: select CSI_COUNTER_READINGS_S.nextval
1858: into p_ctr_rdg_rec.counter_value_id from dual;
1859: IF NOT Counter_Value_Exists(p_ctr_rdg_rec.counter_value_id) THEN
1860: l_process_flag := FALSE;
1861: END IF;

Line 2309: select CSI_COUNTER_READINGS_S.nextval

2305: --
2306: -- Generate the Value_id
2307: l_process_flag := TRUE;
2308: WHILE l_process_flag LOOP
2309: select CSI_COUNTER_READINGS_S.nextval
2310: into l_reset_rdg_rec.counter_value_id from dual;
2311: IF NOT Counter_Value_Exists(l_reset_rdg_rec.counter_value_id) THEN
2312: l_process_flag := FALSE;
2313: END IF;

Line 2734: select CSI_COUNTER_READINGS_S.nextval

2730: IF SQL%ROWCOUNT = 0 THEN -- If update was not successfull
2731: -- Generate the Value_id for insert
2732: l_process_flag := TRUE;
2733: WHILE l_process_flag LOOP
2734: select CSI_COUNTER_READINGS_S.nextval
2735: into l_ctr_value_id from dual;
2736: IF NOT Counter_Value_Exists(l_ctr_value_id) THEN
2737: l_process_flag := FALSE;
2738: END IF;

Line 3361: select CSI_COUNTER_READINGS_S.nextval

3357: ELSIF p_mode = 'CREATE' THEN
3358: -- Generate the Value_id for insert
3359: l_process_flag := TRUE;
3360: WHILE l_process_flag LOOP
3361: select CSI_COUNTER_READINGS_S.nextval
3362: into l_ctr_value_id from dual;
3363: IF NOT Counter_Value_Exists(l_ctr_value_id) THEN
3364: l_process_flag := FALSE;
3365: END IF;

Line 4168: select CSI_COUNTER_READINGS_S.nextval

4164: --
4165: -- Generate the Value_id for insert
4166: l_process_flag := TRUE;
4167: WHILE l_process_flag LOOP
4168: select CSI_COUNTER_READINGS_S.nextval
4169: into l_ctr_rdg_rec.counter_value_id from dual;
4170: IF NOT Counter_Value_Exists(l_ctr_rdg_rec.counter_value_id) THEN
4171: l_process_flag := FALSE;
4172: END IF;