APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTER_READINGS_S

Line 615: select CSI_COUNTER_READINGS_S.nextval

611: --
612: -- Generate the Value_id for insert
613: l_process_flag := TRUE;
614: WHILE l_process_flag LOOP
615: select CSI_COUNTER_READINGS_S.nextval
616: into l_ctr_rdg_rec.counter_value_id from dual;
617: IF NOT Counter_Value_Exists(l_ctr_rdg_rec.counter_value_id) THEN
618: l_process_flag := FALSE;
619: END IF;

Line 2214: select CSI_COUNTER_READINGS_S.nextval

2210: -- Check and Generate Counter_value_id
2211: IF p_ctr_rdg_rec.counter_value_id IS NULL OR
2212: p_ctr_rdg_rec.counter_value_id = FND_API.G_MISS_NUM THEN
2213: WHILE l_process_flag LOOP
2214: select CSI_COUNTER_READINGS_S.nextval
2215: into p_ctr_rdg_rec.counter_value_id from dual;
2216: IF NOT Counter_Value_Exists(p_ctr_rdg_rec.counter_value_id) THEN
2217: l_process_flag := FALSE;
2218: END IF;

Line 2738: select CSI_COUNTER_READINGS_S.nextval

2734: --
2735: -- Generate the Value_id
2736: l_process_flag := TRUE;
2737: WHILE l_process_flag LOOP
2738: select CSI_COUNTER_READINGS_S.nextval
2739: into l_reset_rdg_rec.counter_value_id from dual;
2740: IF NOT Counter_Value_Exists(l_reset_rdg_rec.counter_value_id) THEN
2741: l_process_flag := FALSE;
2742: END IF;

Line 3215: select CSI_COUNTER_READINGS_S.nextval

3211: IF SQL%ROWCOUNT = 0 THEN -- If update was not successfull
3212: -- Generate the Value_id for insert
3213: l_process_flag := TRUE;
3214: WHILE l_process_flag LOOP
3215: select CSI_COUNTER_READINGS_S.nextval
3216: into l_ctr_value_id from dual;
3217: IF NOT Counter_Value_Exists(l_ctr_value_id) THEN
3218: l_process_flag := FALSE;
3219: END IF;

Line 3891: select CSI_COUNTER_READINGS_S.nextval

3887: ELSIF p_mode = 'CREATE' THEN
3888: -- Generate the Value_id for insert
3889: l_process_flag := TRUE;
3890: WHILE l_process_flag LOOP
3891: select CSI_COUNTER_READINGS_S.nextval
3892: into l_ctr_value_id from dual;
3893: IF NOT Counter_Value_Exists(l_ctr_value_id) THEN
3894: l_process_flag := FALSE;
3895: END IF;

Line 4868: select CSI_COUNTER_READINGS_S.nextval

4864: --
4865: -- Generate the Value_id for insert
4866: l_process_flag := TRUE;
4867: WHILE l_process_flag LOOP
4868: select CSI_COUNTER_READINGS_S.nextval
4869: into l_ctr_rdg_rec.counter_value_id from dual;
4870: IF NOT Counter_Value_Exists(l_ctr_rdg_rec.counter_value_id) THEN
4871: l_process_flag := FALSE;
4872: END IF;