APPS.CE_UK_VALIDATIONS_DATA_LDR dependencies on CE_UK_VALIDATIONS_INTERFACE

Line 124: FROM CE_UK_VALIDATIONS_INTERFACE

120: log_msg('begin validate_sub_codes');
121:
122: FOR c_sub_codes IN (
123: SELECT INTERFACE_LINE_ID, SOURCE_VALUE1, SOURCE_VALUE2, SOURCE_VALUE3
124: FROM CE_UK_VALIDATIONS_INTERFACE
125: ORDER BY INTERFACE_LINE_ID)
126: LOOP
127: /* Check if ORIG_SORT_CODE is numeric and is of correct length*/
128: IF (NOT regexp_like(c_sub_codes.SOURCE_VALUE1,'^[0-9]*$') OR

Line 198: CE_UK_VALIDATIONS_INTERFACE;

194: FND_GLOBAL.user_id,
195: sysdate,
196: FND_GLOBAL.user_id
197: FROM
198: CE_UK_VALIDATIONS_INTERFACE;
199: log_msg(SQL%Rowcount||' record(s) inserted.');
200:
201: log_msg('end transfer_sub_codes');
202:

Line 283: CE_UK_VALIDATIONS_INTERFACE

279: SOURCE_VALUE16,
280: SOURCE_VALUE17,
281: SOURCE_VALUE18
282: FROM
283: CE_UK_VALIDATIONS_INTERFACE
284: ORDER BY
285: INTERFACE_LINE_ID)
286: LOOP
287: /* Check if FROM_SORT_CODE is numeric and length is ok */

Line 426: CE_UK_VALIDATIONS_INTERFACE;

422: FND_GLOBAL.user_id,
423: sysdate,
424: FND_GLOBAL.user_id
425: FROM
426: CE_UK_VALIDATIONS_INTERFACE;
427: log_msg(SQL%Rowcount||' record(s) inserted.');
428:
429: log_msg('end transfer_modulus_weights');
430: END transfer_modulus_weights;

Line 657: FROM CE_UK_VALIDATIONS_INTERFACE;

653:
654: -- Check if sql*loader has completed successfully and loaded records
655: SELECT count(*)
656: INTO l_cnt
657: FROM CE_UK_VALIDATIONS_INTERFACE;
658:
659: IF NOT (l_dev_phase = 'COMPLETE' AND l_dev_status = 'NORMAL')
660: THEN
661: log_msg('Error in SQL*loader: l_message='||l_message);

Line 677: FROM CE_UK_VALIDATIONS_INTERFACE;

673: -- If file has corruptions/not as per expected format then all the
674: -- records will not be loaded into the table.
675: SELECT MAX(INTERFACE_LINE_ID) - COUNT(*)
676: INTO l_cnt
677: FROM CE_UK_VALIDATIONS_INTERFACE;
678:
679: IF l_cnt <> 0
680: THEN
681: log_msg('All records from data file were not loaded.');