[Home] [Help]
228: /* WHEN COMING FROM WIRELESS,P_EAM_METER_READING_TBL HAS ALL THE SOURCE COUNTER ID'S
229: Added for Issue # 4 of Bug # 4932595*/
230: IF P_EAM_METER_READING_TBL.COUNT >0 THEN
231: -- GET THE SOURE METER OF THE MANDATORY METER
232: SELECT SOURCE_COUNTER_ID INTO L_SOURCE_METER_ID FROM CSI_COUNTER_RELATIONSHIPS WHERE OBJECT_COUNTER_ID = MANDATORY_COUNTER_ID_TBL(J)
233: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE(+), SYSDATE-1) AND NVL(ACTIVE_END_DATE(+), SYSDATE+1);
234: -- LOOP THROUGH P_EAM_METER_READING_TBL TO CHECK WHETHER READINGS ARE ENTERED OR NOT
235: FOR K IN P_EAM_METER_READING_TBL.FIRST..P_EAM_METER_READING_TBL.LAST LOOP
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
242: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
243: EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside If 1 - meter id'||to_char(P_EAM_METER_READING_TBL(K).METER_ID) );
244: END IF;
245: -- IF P_EAM_METER_READING_TBL HAS AN NON MANDATORY READING
246: SELECT SOURCE_COUNTER_ID INTO L_SOURCE_METER_ID_P FROM CSI_COUNTER_RELATIONSHIPS WHERE OBJECT_COUNTER_ID = P_EAM_METER_READING_TBL(K).METER_ID
247: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE(+), SYSDATE-1) AND NVL(ACTIVE_END_DATE(+), SYSDATE+1);
248: IF L_SOURCE_METER_ID_P IS NOT NULL THEN
249: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
250: EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside If 2 - meter id'||to_char(P_EAM_METER_READING_TBL(K).METER_ID) );