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_API

Line 1068: l_ispayee := cn_api.is_payee(p_period_id => p_period_id, p_salesrep_id => p_salesrep_id, p_org_id => p_org_id);

1064: ' WHERE (spayee.salesrep_id = v.salesrep_id OR ' || ' spayee.payee_id = v.salesrep_id)' || ' AND v.prd_end_date >= spayee.start_date' ||
1065: ' AND spayee.org_id = :p_org_id' || --R12
1066: ' AND v.prd_start_date <= Nvl(spayee.end_date, v.prd_end_date) )' || ' )';
1067: -- Bug 3140343 : Payee Design. Check if this salesrep is a Payee
1068: l_ispayee := cn_api.is_payee(p_period_id => p_period_id, p_salesrep_id => p_salesrep_id, p_org_id => p_org_id);
1069:
1070: -- if not a payee
1071: IF l_ispayee <> 1
1072: THEN

Line 1542: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.payrun_id,

1538: -- Salesrep should not be on hold -cn_salesreps.hold_payment
1539: -- Subledger entry should exist for salesrep, credit_type and period
1540: -- cn_srp_periods
1541: -- Mandatory parameters check for payrun_id, salesrep_id
1542: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.payrun_id,
1543: p_obj_name => cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1544: p_loading_status => x_loading_status,
1545: x_loading_status => x_loading_status)) = fnd_api.g_true)
1546: THEN

Line 1543: p_obj_name => cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),

1539: -- Subledger entry should exist for salesrep, credit_type and period
1540: -- cn_srp_periods
1541: -- Mandatory parameters check for payrun_id, salesrep_id
1542: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.payrun_id,
1543: p_obj_name => cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1544: p_loading_status => x_loading_status,
1545: x_loading_status => x_loading_status)) = fnd_api.g_true)
1546: THEN
1547: RAISE fnd_api.g_exc_error;

Line 1550: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.salesrep_id,

1546: THEN
1547: RAISE fnd_api.g_exc_error;
1548: END IF;
1549:
1550: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.salesrep_id,
1551: p_obj_name => cn_api.get_lkup_meaning('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),
1552: p_loading_status => x_loading_status,
1553: x_loading_status => x_loading_status)) = fnd_api.g_true)
1554: THEN

Line 1551: p_obj_name => cn_api.get_lkup_meaning('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),

1547: RAISE fnd_api.g_exc_error;
1548: END IF;
1549:
1550: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.salesrep_id,
1551: p_obj_name => cn_api.get_lkup_meaning('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),
1552: p_loading_status => x_loading_status,
1553: x_loading_status => x_loading_status)) = fnd_api.g_true)
1554: THEN
1555: RAISE fnd_api.g_exc_error;

Line 1559: IF cn_api.chk_payrun_status_paid(p_payrun_id => p_worksheet_rec.payrun_id, p_loading_status => x_loading_status, x_loading_status => x_loading_status) =

1555: RAISE fnd_api.g_exc_error;
1556: END IF;
1557:
1558: -- Check Payrun Status
1559: IF cn_api.chk_payrun_status_paid(p_payrun_id => p_worksheet_rec.payrun_id, p_loading_status => x_loading_status, x_loading_status => x_loading_status) =
1560: fnd_api.g_true
1561: THEN
1562: RAISE fnd_api.g_exc_error;
1563: END IF;

Line 1566: IF cn_api.chk_srp_hold_status(p_salesrep_id => p_worksheet_rec.salesrep_id,

1562: RAISE fnd_api.g_exc_error;
1563: END IF;
1564:
1565: -- Check if the salesrep is on hold
1566: IF cn_api.chk_srp_hold_status(p_salesrep_id => p_worksheet_rec.salesrep_id,
1567: --R12
1568: p_org_id => p_worksheet_rec.org_id,
1569: p_loading_status => x_loading_status,
1570: x_loading_status => x_loading_status) = fnd_api.g_true

Line 1634: l_ispayee := cn_api.is_payee(p_period_id => l_get_payrun_rec.pay_period_id,

1630: -- N - Pay by Summary Y - Pay by Transaction
1631: l_pbt_profile_value := cn_payment_security_pvt.get_pay_by_mode(p_worksheet_rec.payrun_id);
1632:
1633: -- Bug 3140343 : Payee Design. Check if this salesrep is a Payee
1634: l_ispayee := cn_api.is_payee(p_period_id => l_get_payrun_rec.pay_period_id,
1635: p_salesrep_id => p_worksheet_rec.salesrep_id,
1636: p_org_id => p_worksheet_rec.org_id);
1637:
1638: -- Check duplicate worksheet

Line 1639: IF cn_api.chk_duplicate_worksheet(p_payrun_id => p_worksheet_rec.payrun_id,

1635: p_salesrep_id => p_worksheet_rec.salesrep_id,
1636: p_org_id => p_worksheet_rec.org_id);
1637:
1638: -- Check duplicate worksheet
1639: IF cn_api.chk_duplicate_worksheet(p_payrun_id => p_worksheet_rec.payrun_id,
1640: p_salesrep_id => p_worksheet_rec.salesrep_id,
1641: p_org_id => p_worksheet_rec.org_id,
1642: p_loading_status => x_loading_status,
1643: x_loading_status => x_loading_status) = fnd_api.g_true

Line 1774: l_pay_element_type_id := cn_api.get_pay_element_id(l_calc_rec_tbl(i).quota_id,

1770: THEN
1771: -- Bug 2880233: should find pay_element for PMTPLN base on quota_id
1772:
1773: -- IF l_calc_rec_tbl(i).pmt_amount_adj_rec <> 0 THEN
1774: l_pay_element_type_id := cn_api.get_pay_element_id(l_calc_rec_tbl(i).quota_id,
1775: p_worksheet_rec.salesrep_id,
1776: --R12
1777: p_worksheet_rec.org_id,
1778: l_get_payrun_rec.pay_date);

Line 2505: l_ispayee := cn_api.is_payee(p_period_id => wksht_rec.pay_period_id, p_salesrep_id => wksht_rec.salesrep_id, p_org_id => wksht_rec.org_id);

2501: AND pr.org_id = r.org_id
2502: AND pr.payrun_id = wksht_rec.payrun_id;
2503:
2504: -- Bug 3140343 : Payee Design. Check if this salesrep is a Payee
2505: l_ispayee := cn_api.is_payee(p_period_id => wksht_rec.pay_period_id, p_salesrep_id => wksht_rec.salesrep_id, p_org_id => wksht_rec.org_id);
2506:
2507: IF p_operation = 'REFRESH'
2508: THEN
2509:

Line 2915: -- Bug 2875120 : remove cn_api function call in sql statement

2911: 'N',
2912: 'N',
2913: wksht_rec.payrun_id,
2914: nvl(cl.commission_amount, 0),
2915: -- Bug 2875120 : remove cn_api function call in sql statement
2916: decode(l_payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
2917: SYSDATE,
2918: fnd_global.user_id,
2919: --R12

Line 3014: -- Bug 2875120 : remove cn_api function call in sql statement

3010: 'N',
3011: 'N',
3012: wksht_rec.payrun_id,
3013: nvl(cl.commission_amount, 0),
3014: -- Bug 2875120 : remove cn_api function call in sql statement
3015: decode(l_payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
3016: SYSDATE,
3017: fnd_global.user_id,
3018: --R12

Line 3173: l_pmt_trans_rec.pay_element_type_id := cn_api.get_pay_element_id(l_calc_rec_tbl(i).quota_id,

3169: nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0);
3170: --R12
3171: l_pmt_trans_rec.org_id := wksht_rec.org_id;
3172: l_pmt_trans_rec.object_version_number := 1;
3173: l_pmt_trans_rec.pay_element_type_id := cn_api.get_pay_element_id(l_calc_rec_tbl(i).quota_id,
3174: wksht_rec.salesrep_id,
3175: wksht_rec.org_id,
3176: wksht_rec.pay_date);
3177: -- Create the Payment Plan Record