117: Counter := 0;
118:
119: /* Get the value of the profile "OIC: Skip Credit Allocation" */
120: l_skip_credit_flag := 'Y';
121: IF (Fnd_Profile.DEFINED('CN_SKIP_CREDIT_ALLOCATION')) THEN
122: l_skip_credit_flag := NVL(Fnd_Profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
123: END IF;
124:
125: -- this is used to make it more restrict for handling reversal trx later on
118:
119: /* Get the value of the profile "OIC: Skip Credit Allocation" */
120: l_skip_credit_flag := 'Y';
121: IF (Fnd_Profile.DEFINED('CN_SKIP_CREDIT_ALLOCATION')) THEN
122: l_skip_credit_flag := NVL(Fnd_Profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
123: END IF;
124:
125: -- this is used to make it more restrict for handling reversal trx later on
126: SELECT cn_commission_headers_s.NEXTVAL
1349: END IF;
1350:
1351: /* Get the value of the profile "OIC: Skip Credit Allocation" */
1352: l_skip_credit_flag := 'Y';
1353: IF (Fnd_Profile.DEFINED('CN_SKIP_CREDIT_ALLOCATION')) THEN
1354: l_skip_credit_flag := NVL(Fnd_Profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
1355: END IF;
1356:
1357: -- Check Data in API table
1350:
1351: /* Get the value of the profile "OIC: Skip Credit Allocation" */
1352: l_skip_credit_flag := 'Y';
1353: IF (Fnd_Profile.DEFINED('CN_SKIP_CREDIT_ALLOCATION')) THEN
1354: l_skip_credit_flag := NVL(Fnd_Profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
1355: END IF;
1356:
1357: -- Check Data in API table
1358: cn_transaction_load_pkg.check_api_data(p_start_date => p_start_date,