eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_PAYMENT_WORKSHEETS_PKG

Line 1825: cn_payment_worksheets_pkg.insert_record(x_payrun_id => p_worksheet_rec.payrun_id,

1821: abs(nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0)) + abs(nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 0)) +
1822: abs(nvl(l_calc_rec_tbl(i).pmt_amount_rec, 0)) + abs(nvl(l_calc_rec_tbl(i).held_amount, 0)) <> 0
1823: THEN
1824: -- Create the Worksheet at the Quota Level
1825: cn_payment_worksheets_pkg.insert_record(x_payrun_id => p_worksheet_rec.payrun_id,
1826: x_salesrep_id => p_worksheet_rec.salesrep_id,
1827: x_quota_id => l_calc_rec_tbl(i).quota_id,
1828: x_credit_type_id => g_credit_type_id,
1829: x_calc_pmt_amount => nvl(l_calc_rec_tbl(i).pmt_amount_calc, 0),

Line 1885: cn_payment_worksheets_pkg.insert_record(x_payrun_id => p_worksheet_rec.payrun_id,

1881: NULL;
1882: END;
1883:
1884: -- Create the Summary Record in the Worksheet
1885: cn_payment_worksheets_pkg.insert_record(x_payrun_id => p_worksheet_rec.payrun_id,
1886: x_salesrep_id => p_worksheet_rec.salesrep_id,
1887: x_credit_type_id => g_credit_type_id,
1888: x_calc_pmt_amount => nvl(l_calc_pmt_amount, 0),
1889: x_adj_pmt_amount_rec => nvl(l_adj_pmt_amount_rec, 0),

Line 3184: cn_payment_worksheets_pkg.insert_record(x_payrun_id => wksht_rec.payrun_id,

3180: abs(nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0)) + abs(nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 0)) +
3181: abs(nvl(l_calc_rec_tbl(i).pmt_amount_rec, 0)) <> 0)
3182: THEN
3183: -- Create the Worksheet at the Quota Level
3184: cn_payment_worksheets_pkg.insert_record(x_payrun_id => wksht_rec.payrun_id,
3185: x_salesrep_id => wksht_rec.salesrep_id,
3186: x_quota_id => l_calc_rec_tbl(i).quota_id,
3187: x_credit_type_id => -1000,
3188: x_calc_pmt_amount => nvl(l_calc_rec_tbl(i).pmt_amount_calc, 0),

Line 3652: cn_payment_worksheets_pkg.delete_record(p_salesrep_id => wksht.salesrep_id, p_payrun_id => wksht.payrun_id);

3648: x_msg_count => x_msg_count,
3649: x_msg_data => x_msg_data);
3650:
3651: -- Delete the Worksheets
3652: cn_payment_worksheets_pkg.delete_record(p_salesrep_id => wksht.salesrep_id, p_payrun_id => wksht.payrun_id);
3653: END LOOP;
3654:
3655: -- End of API body.
3656: -- Standard check of p_commit.