[Home] [Help]
1823: abs(nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0)) + abs(nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 0)) +
1824: abs(nvl(l_calc_rec_tbl(i).pmt_amount_rec, 0)) + abs(nvl(l_calc_rec_tbl(i).held_amount, 0)) <> 0
1825: THEN
1826: -- Create the Worksheet at the Quota Level
1827: cn_payment_worksheets_pkg.insert_record(x_payrun_id => p_worksheet_rec.payrun_id,
1828: x_salesrep_id => p_worksheet_rec.salesrep_id,
1829: x_quota_id => l_calc_rec_tbl(i).quota_id,
1830: x_credit_type_id => g_credit_type_id,
1831: x_calc_pmt_amount => nvl(l_calc_rec_tbl(i).pmt_amount_calc, 0),
1883: NULL;
1884: END;
1885:
1886: -- Create the Summary Record in the Worksheet
1887: cn_payment_worksheets_pkg.insert_record(x_payrun_id => p_worksheet_rec.payrun_id,
1888: x_salesrep_id => p_worksheet_rec.salesrep_id,
1889: x_credit_type_id => g_credit_type_id,
1890: x_calc_pmt_amount => nvl(l_calc_pmt_amount, 0),
1891: x_adj_pmt_amount_rec => nvl(l_adj_pmt_amount_rec, 0),
3226: abs(nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0)) + abs(nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 0)) +
3227: abs(nvl(l_calc_rec_tbl(i).pmt_amount_rec, 0)) <> 0)
3228: THEN
3229: -- Create the Worksheet at the Quota Level
3230: cn_payment_worksheets_pkg.insert_record(x_payrun_id => wksht_rec.payrun_id,
3231: x_salesrep_id => wksht_rec.salesrep_id,
3232: x_quota_id => l_calc_rec_tbl(i).quota_id,
3233: x_credit_type_id => -1000,
3234: x_calc_pmt_amount => nvl(l_calc_rec_tbl(i).pmt_amount_calc, 0),
3694: x_msg_count => x_msg_count,
3695: x_msg_data => x_msg_data);
3696:
3697: -- Delete the Worksheets
3698: cn_payment_worksheets_pkg.delete_record(p_salesrep_id => wksht.salesrep_id, p_payrun_id => wksht.payrun_id);
3699: END LOOP;
3700:
3701: -- End of API body.
3702: -- Standard check of p_commit.