DBA Data[Home] [Help]

APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_SYSTEM_PARAMETERS

Line 543: IF (cn_system_parameters.VALUE('CN_PRIOR_ADJUSTMENT', p_org_id) = 'N') THEN

539: /*****************************************/
540: /* The following Updates do a check for */
541: /* no prior adjustment if profile option set to 'Y'*/
542: /*****************************************/
543: IF (cn_system_parameters.VALUE('CN_PRIOR_ADJUSTMENT', p_org_id) = 'N') THEN
544: DECLARE
545: x_latest_processed_date DATE;
546: BEGIN
547: SELECT NVL(latest_processed_date, TO_DATE('01/01/1900', 'DD/MM/YYYY'))

Line 1069: l_cn_reset_error_trx := cn_system_parameters.VALUE('CN_RESET_ERROR_TRX', p_org_id);

1065:
1066: -- new statment
1067:
1068: -- performance bug 2035228
1069: l_cn_reset_error_trx := cn_system_parameters.VALUE('CN_RESET_ERROR_TRX', p_org_id);
1070: debugmsg('Loader : OSC Profile - Reset Error Transaction is ' || l_cn_reset_error_trx);
1071:
1072: IF l_cn_reset_error_trx = 'Y' THEN
1073: debugmsg('Reset load status of error transactions to UNLOADED');