[Home] [Help]
1494: AND quota_id IS NULL;
1495:
1496: l_get_payrun_rec get_payrun%ROWTYPE; -- Payrun
1497: l_get_prd_statuses get_prd_statuses%ROWTYPE; -- Period
1498: l_pmt_trans_rec cn_pmt_trans_pkg.pmt_trans_rec_type; -- PmtTrans
1499: l_batch_rec cn_prepostbatches.posting_batch_rec_type;
1500: l_tmp NUMBER := 0;
1501: l_calc_status cn_srp_intel_periods.processing_status_code%TYPE;
1502: l_ispayee NUMBER := 0;
1667: END IF;
1668:
1669: -- Main Insert started for Create Worksheet
1670: -- Call the Table hander to Insert Records
1671: cn_pmt_trans_pkg.insert_record(p_pay_by_transaction => nvl(l_pbt_profile_value, 'N'),
1672: p_salesrep_id => p_worksheet_rec.salesrep_id,
1673: p_payrun_id => p_worksheet_rec.payrun_id,
1674: p_pay_date => l_get_payrun_rec.pay_date,
1675: p_incentive_type => l_incentive_type,
1812: --R12
1813: l_pmt_trans_rec.org_id := p_worksheet_rec.org_id;
1814: l_pmt_trans_rec.object_version_number := 1;
1815: -- Create the Payment Plan Record
1816: cn_pmt_trans_pkg.insert_record(p_tran_rec => l_pmt_trans_rec);
1817: END IF;
1818:
1819: IF l_calc_rec_tbl(i).quota_id <> -1000
1820: OR abs(nvl(l_calc_rec_tbl(i).pmt_amount_calc, 0)) + abs(nvl(l_calc_rec_tbl(i).pmt_amount_adj_rec, 0)) +
2379: l_calc_pmt_amount NUMBER;
2380: l_adj_pmt_amount_rec NUMBER;
2381: l_adj_pmt_amount_nrec NUMBER;
2382: l_pmt_amount_rec NUMBER;
2383: l_pmt_trans_rec cn_pmt_trans_pkg.pmt_trans_rec_type; -- PmtTrans
2384: l_pmt_amount_ctr NUMBER;
2385: l_rowid VARCHAR2(30);
2386: -- changes for bug#2568937
2387: -- for payroll integration population of account
3128: wksht_rec.salesrep_id,
3129: wksht_rec.org_id,
3130: wksht_rec.pay_date);
3131: -- Create the Payment Plan Record
3132: cn_pmt_trans_pkg.insert_record(p_tran_rec => l_pmt_trans_rec);
3133: END IF;
3134: ELSE
3135: UPDATE cn_payment_transactions cnpt
3136: SET amount = 0,