APPS.CE_UK_VALIDATIONS_DATA_LDR dependencies on CE_UK_VAL_MODULUS_WEIGHTS

Line 352: | CE_UK_VAL_MODULUS_WEIGHTS |

348: | transfer_modulus_weights |
349: | |
350: | DESCRIPTION |
351: | Transfer modulus weights from interface table to actual table |
352: | CE_UK_VAL_MODULUS_WEIGHTS |
353: | |
354: | HISTORY |
355: | 18-Dec-2012 rtumati Created |
356: --------------------------------------------------------------------- */

Line 363: -- Delete data from CE_UK_VAL_MODULUS_WEIGHTS table.

359: G_debug_proc := 'transfer_modulus_weights';
360: log_msg('begin transfer_modulus_weights');
361:
362: --
363: -- Delete data from CE_UK_VAL_MODULUS_WEIGHTS table.
364: --
365: log_msg('Removing existing data from table');
366: DELETE FROM CE_UK_VAL_MODULUS_WEIGHTS;
367: log_msg(SQL%Rowcount||' record(s) deleted.');

Line 366: DELETE FROM CE_UK_VAL_MODULUS_WEIGHTS;

362: --
363: -- Delete data from CE_UK_VAL_MODULUS_WEIGHTS table.
364: --
365: log_msg('Removing existing data from table');
366: DELETE FROM CE_UK_VAL_MODULUS_WEIGHTS;
367: log_msg(SQL%Rowcount||' record(s) deleted.');
368:
369: --
370: -- Insert data into CE_UK_VAL_MODULUS_WEIGHTS table.

Line 370: -- Insert data into CE_UK_VAL_MODULUS_WEIGHTS table.

366: DELETE FROM CE_UK_VAL_MODULUS_WEIGHTS;
367: log_msg(SQL%Rowcount||' record(s) deleted.');
368:
369: --
370: -- Insert data into CE_UK_VAL_MODULUS_WEIGHTS table.
371: --
372: log_msg('Inserting new data into table');
373: INSERT INTO CE_UK_VAL_MODULUS_WEIGHTS(
374: MODULUS_CHECK_ID,

Line 373: INSERT INTO CE_UK_VAL_MODULUS_WEIGHTS(

369: --
370: -- Insert data into CE_UK_VAL_MODULUS_WEIGHTS table.
371: --
372: log_msg('Inserting new data into table');
373: INSERT INTO CE_UK_VAL_MODULUS_WEIGHTS(
374: MODULUS_CHECK_ID,
375: FROM_SORT_CODE ,
376: TO_SORT_CODE,
377: CHECK_TYPE ,

Line 438: | CE_UK_VAL_MODULUS_WEIGHTS after succesful load |

434: | List_modulus_weights |
435: | |
436: | DESCRIPTION |
437: | This procedure lists Modulus Weights Data stored in the table |
438: | CE_UK_VAL_MODULUS_WEIGHTS after succesful load |
439: | |
440: | HISTORY |
441: | 18-Dec-2012 rtumati Created |
442: --------------------------------------------------------------------- */

Line 463: CE_UK_VAL_MODULUS_WEIGHTS ORDER BY MODULUS_CHECK_ID)

459: WEIGHT_G, WEIGHT_H,
460: EXCEPTION_CODE,
461: LAST_UPDATE_DATE
462: FROM
463: CE_UK_VAL_MODULUS_WEIGHTS ORDER BY MODULUS_CHECK_ID)
464: LOOP
465: log_msg('Listing MODULUS_CHECK_ID='||modWeightRec.MODULUS_CHECK_ID);
466:
467: put_starttag('modWeightRec');

Line 694: -- CE_UK_VAL_MODULUS_WEIGHTS

690: -- Validate modulus weights data being loaded
691: validate_modulus_weights;
692:
693: -- Transfer modulus weights from interface table to actual table
694: -- CE_UK_VAL_MODULUS_WEIGHTS
695: transfer_modulus_weights;
696:
697: -- Write data to XML
698: List_modulus_weights;