APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_SYSTEM_PARAMETERS

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

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

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

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