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

Line 87: UPDATE cn_payment_worksheets_all w

83: l_comm_ptd := 0 ;
84: l_bonus_ptd := 0 ;
85: END;
86:
87: UPDATE cn_payment_worksheets_all w
88: SET w.comm_ptd = l_comm_ptd,
89: w.bonus_ptd = l_bonus_ptd,
90: w.comm_due_bb = l_bal
91: WHERE w.salesrep_id = p_salesrep_id

Line 484: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,

480: -- Calls :
481: -- ===========================================================================
482: PROCEDURE proc_pmt_trans_by_pe
483: (
484: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,
485: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,
486: p_payrun_id IN cn_payruns.payrun_id%TYPE,
487: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE, --bug 3175375 by jjhuang.
488: p_applied_pgc IN dbms_sql.varchar2_table, --bug 3198445 by jjhuang.

Line 894: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,

890: -- Calls :
891: -- ===========================================================================
892: PROCEDURE calculate_totals
893: (
894: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,
895: p_period_id IN cn_payruns.pay_period_id%TYPE,
896: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,
897: p_payrun_id IN cn_payruns.payrun_id%TYPE,
898: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,

Line 1383: FROM cn_payment_worksheets,

1379: WHERE org_id = p_worksheet_rec.org_id;
1380:
1381: CURSOR get_worksheet IS
1382: SELECT 1
1383: FROM cn_payment_worksheets,
1384: cn_payruns
1385: WHERE cn_payment_worksheets.salesrep_id = p_worksheet_rec.salesrep_id
1386: AND cn_payment_worksheets.payrun_id = cn_payruns.payrun_id
1387: AND quota_id IS NULL

Line 1385: WHERE cn_payment_worksheets.salesrep_id = p_worksheet_rec.salesrep_id

1381: CURSOR get_worksheet IS
1382: SELECT 1
1383: FROM cn_payment_worksheets,
1384: cn_payruns
1385: WHERE cn_payment_worksheets.salesrep_id = p_worksheet_rec.salesrep_id
1386: AND cn_payment_worksheets.payrun_id = cn_payruns.payrun_id
1387: AND quota_id IS NULL
1388: AND cn_payruns.status <> 'PAID';
1389:

Line 1386: AND cn_payment_worksheets.payrun_id = cn_payruns.payrun_id

1382: SELECT 1
1383: FROM cn_payment_worksheets,
1384: cn_payruns
1385: WHERE cn_payment_worksheets.salesrep_id = p_worksheet_rec.salesrep_id
1386: AND cn_payment_worksheets.payrun_id = cn_payruns.payrun_id
1387: AND quota_id IS NULL
1388: AND cn_payruns.status <> 'PAID';
1389:
1390: err_num NUMBER;

Line 1493: FROM cn_payment_worksheets

1489: AND spayee.org_id = p_worksheet_rec.org_id;
1490:
1491: CURSOR get_worksheet_id IS
1492: SELECT payment_worksheet_id
1493: FROM cn_payment_worksheets
1494: WHERE payrun_id = p_worksheet_rec.payrun_id
1495: AND salesrep_id = p_worksheet_rec.salesrep_id
1496: AND quota_id IS NULL;
1497:

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

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),

Line 1864: FROM cn_payment_worksheets

1860: l_tmp := 0;
1861:
1862: SELECT 1
1863: INTO l_tmp
1864: FROM cn_payment_worksheets
1865: WHERE payrun_id = p_worksheet_rec.payrun_id
1866: AND salesrep_id = p_worksheet_rec.salesrep_id
1867: AND quota_id IS NULL;
1868:

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

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),

Line 1962: FROM cn_payment_worksheets pw

1958: ELSE
1959:
1960: SELECT DISTINCT pw.quota_id
1961: BULK COLLECT INTO l_wk_plan_elements
1962: FROM cn_payment_worksheets pw
1963: WHERE pw.payrun_id = l_get_payrun_rec.payrun_id
1964: AND pw.salesrep_id = p_worksheet_rec.salesrep_id
1965: AND pw.quota_id IS NOT NULL ;
1966:

Line 2000: cn_payment_worksheets wksht

1996: AND org_id = p_worksheet_rec.org_id
1997: AND clk.srp_payee_assign_id IS NOT NULL
1998: AND EXISTS (SELECT 1
1999: FROM cn_srp_payee_assigns_all spayee,
2000: cn_payment_worksheets wksht
2001: WHERE clk.srp_payee_assign_id = spayee.srp_payee_assign_id
2002: AND spayee.quota_id = wksht.quota_id
2003: AND spayee.payee_id = p_worksheet_rec.salesrep_id
2004: AND wksht.payrun_id = l_get_payrun_rec.payrun_id

Line 2227: FROM cn_payment_worksheets_all cnpw

2223: AND cnp.org_id = cnspg.org_id
2224: AND cnp.org_id = cns.org_id
2225: AND ((cnspg.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspg.end_date, cnps.start_date)))
2226: AND NOT EXISTS (SELECT 1
2227: FROM cn_payment_worksheets_all cnpw
2228: WHERE cnpw.salesrep_id = cnspg.salesrep_id
2229: AND cnp.payrun_id = cnpw.payrun_id)
2230: AND (EXISTS (SELECT 1
2231: FROM cn_srp_payee_assigns cnspa

Line 2312: FROM cn_payment_worksheets_all cnpw

2308: AND cnp.org_id = cnspg.org_id
2309: AND cnp.org_id = cns.org_id
2310: AND ((cnspg.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspg.end_date, cnps.start_date)))
2311: AND NOT EXISTS (SELECT 1
2312: FROM cn_payment_worksheets_all cnpw
2313: WHERE cnpw.salesrep_id = cnspg.salesrep_id
2314: AND cnp.payrun_id = cnpw.payrun_id)
2315: AND (EXISTS (SELECT 1
2316: FROM cn_srp_payee_assigns cnspa

Line 2402: FROM cn_payment_worksheets cnpw,

2398: decode(cnp.incentive_type_code, 'ALL', '', cnp.incentive_type_code) incentive_type_code,
2399: cnp.pay_date,
2400: cnpw.object_version_number ovn,
2401: cnpw.org_id
2402: FROM cn_payment_worksheets cnpw,
2403: cn_payruns cnp
2404: WHERE payment_worksheet_id = p_worksheet_id
2405: AND cnpw.payrun_id = cnp.payrun_id;
2406:

Line 2414: cn_payment_worksheets wk

2410: SELECT payables_flag,
2411: payroll_flag,
2412: payables_ccid_level
2413: FROM cn_repositories rp,
2414: cn_payment_worksheets wk
2415: WHERE rp.org_id = wk.org_id;
2416:
2417: wksht_rec get_worksheet_id%ROWTYPE;
2418: l_status cn_payment_worksheets.worksheet_status%TYPE;

Line 2418: l_status cn_payment_worksheets.worksheet_status%TYPE;

2414: cn_payment_worksheets wk
2415: WHERE rp.org_id = wk.org_id;
2416:
2417: wksht_rec get_worksheet_id%ROWTYPE;
2418: l_status cn_payment_worksheets.worksheet_status%TYPE;
2419: l_posting_batch_id NUMBER;
2420: recv_posting_batch_id NUMBER;
2421: carryover_posting_batch_id NUMBER;
2422:

Line 3209: UPDATE cn_payment_worksheets

3205: AND cnpt.org_id = wksht_rec.org_id;
3206: END IF; -- End IF l_calc_rec_tbl(i).pmt_amount_adj_rec <> 0
3207:
3208: -- Update the Worksheet at the Quota Level
3209: UPDATE cn_payment_worksheets
3210: SET pmt_amount_calc = nvl(l_calc_rec_tbl(i).pmt_amount_calc, 0),
3211: pmt_amount_adj_rec = nvl(l_calc_rec_tbl(i).pmt_amount_adj_rec, 0),
3212: pmt_amount_adj_nrec = nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0),
3213: pmt_amount_adj = nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 0),

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

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),

Line 3257: UPDATE cn_payment_worksheets

3253: END LOOP;
3254: END IF; -- end IF l_calc_rec_tbl.COUNT > 0 THEN
3255:
3256: -- UPDATE the Summary Record in the Worksheet
3257: UPDATE cn_payment_worksheets
3258: SET pmt_amount_calc = l_calc_pmt_amount,
3259: pmt_amount_adj_rec = l_adj_pmt_amount_rec,
3260: pmt_amount_adj_nrec = l_adj_pmt_amount_nrec,
3261: pmt_amount_adj = l_pmt_amount_ctr,

Line 3312: FROM cn_payment_worksheets pw

3308: ELSE
3309:
3310: SELECT DISTINCT pw.quota_id
3311: BULK COLLECT INTO l_wk_plan_elements
3312: FROM cn_payment_worksheets pw
3313: WHERE pw.payrun_id = wksht_rec.payrun_id
3314: AND pw.salesrep_id = wksht_rec.salesrep_id
3315: AND pw.quota_id IS NOT NULL ;
3316:

Line 3351: cn_payment_worksheets wksht

3347: AND org_id = wksht_rec.org_id
3348: AND clk.srp_payee_assign_id IS NOT NULL
3349: AND EXISTS (SELECT 1
3350: FROM cn_srp_payee_assigns_all spayee,
3351: cn_payment_worksheets wksht
3352: WHERE clk.srp_payee_assign_id = spayee.srp_payee_assign_id
3353: AND spayee.quota_id = wksht.quota_id
3354: AND spayee.payee_id = wksht_rec.salesrep_id
3355: AND wksht.payrun_id = wksht_rec.payrun_id

Line 3495: UPDATE cn_payment_worksheets

3491: END IF;
3492: END IF;
3493:
3494: --Update object_version_number
3495: UPDATE cn_payment_worksheets
3496: SET object_version_number = nvl(object_version_number, 0) + 1,
3497: last_update_date = SYSDATE,
3498: last_updated_by = fnd_global.user_id,
3499: last_update_login = fnd_global.login_id

Line 3502: FROM cn_payment_worksheets

3498: last_updated_by = fnd_global.user_id,
3499: last_update_login = fnd_global.login_id
3500: WHERE (payrun_id, salesrep_id) IN (SELECT payrun_id,
3501: salesrep_id
3502: FROM cn_payment_worksheets
3503: WHERE payment_worksheet_id = p_worksheet_id);
3504:
3505: SELECT object_version_number
3506: INTO x_ovn

Line 3507: FROM cn_payment_worksheets

3503: WHERE payment_worksheet_id = p_worksheet_id);
3504:
3505: SELECT object_version_number
3506: INTO x_ovn
3507: FROM cn_payment_worksheets
3508: WHERE payment_worksheet_id = p_worksheet_id;
3509:
3510: -- End of API body.
3511: -- Standard check of p_commit.

Line 3569: FROM cn_payment_worksheets wk,

3565: SELECT wk.salesrep_id,
3566: wk.payrun_id,
3567: wk.org_id,
3568: pr.payrun_mode
3569: FROM cn_payment_worksheets wk,
3570: cn_payruns pr
3571: WHERE payment_worksheet_id = p_worksheet_id
3572: AND wk.payrun_id = pr.payrun_id;
3573:

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

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.

Line 3764: FROM cn_payment_worksheets w,

3760: p.status payrun_status,
3761: p.pay_period_id,
3762: p.payrun_id,
3763: w.org_id --R12
3764: FROM cn_payment_worksheets w,
3765: cn_payruns p
3766: WHERE w.payment_worksheet_id = p_worksheet_id
3767: AND w.payrun_id = p.payrun_id
3768: --R12

Line 3821: -- get data from cn_payment_worksheets

3817: IF (l_wksht_rec.quota_id IS NULL)
3818: THEN
3819: IF ((l_wksht_rec.payrun_status <> 'UNPAID') OR (l_wksht_rec.wksht_status <> 'UNPAID'))
3820: THEN
3821: -- get data from cn_payment_worksheets
3822: SELECT bb_prior_period_adj,
3823: bb_pmt_recovery_plans,
3824: current_earnings
3825: INTO x_bb_prior_period_adj,

Line 3828: FROM cn_payment_worksheets

3824: current_earnings
3825: INTO x_bb_prior_period_adj,
3826: x_bb_pmt_recovery_plans,
3827: x_curr_earnings
3828: FROM cn_payment_worksheets
3829: WHERE payment_worksheet_id = p_worksheet_id;
3830: ELSE
3831: -- get data from cn_srp_periods
3832: BEGIN

Line 3950: FROM cn_payment_worksheets w,

3946: p.status payrun_status,
3947: p.pay_period_id,
3948: p.payrun_id,
3949: w.org_id
3950: FROM cn_payment_worksheets w,
3951: cn_payruns p
3952: WHERE w.payment_worksheet_id = p_worksheet_id
3953: AND w.payrun_id = p.payrun_id;
3954:

Line 3957: CURSOR c_wksht_sum_csr(l_payrun_id cn_payruns.payrun_id%TYPE, l_srp_id cn_payment_worksheets.salesrep_id%TYPE,

3953: AND w.payrun_id = p.payrun_id;
3954:
3955: l_status_rec c_status_csr%ROWTYPE;
3956:
3957: CURSOR c_wksht_sum_csr(l_payrun_id cn_payruns.payrun_id%TYPE, l_srp_id cn_payment_worksheets.salesrep_id%TYPE,
3958: --R12
3959: p_org_id cn_payment_worksheets.org_id%TYPE) IS
3960: SELECT w.payment_worksheet_id,
3961: w.quota_id,

Line 3959: p_org_id cn_payment_worksheets.org_id%TYPE) IS

3955: l_status_rec c_status_csr%ROWTYPE;
3956:
3957: CURSOR c_wksht_sum_csr(l_payrun_id cn_payruns.payrun_id%TYPE, l_srp_id cn_payment_worksheets.salesrep_id%TYPE,
3958: --R12
3959: p_org_id cn_payment_worksheets.org_id%TYPE) IS
3960: SELECT w.payment_worksheet_id,
3961: w.quota_id,
3962: w.salesrep_id,
3963: w.object_version_number

Line 3964: FROM cn_payment_worksheets w

3960: SELECT w.payment_worksheet_id,
3961: w.quota_id,
3962: w.salesrep_id,
3963: w.object_version_number
3964: FROM cn_payment_worksheets w
3965: WHERE w.payrun_id = l_payrun_id
3966: AND w.salesrep_id = l_srp_id
3967: AND w.quota_id IS NULL
3968: AND w.org_id = p_org_id;

Line 4064: UPDATE cn_payment_worksheets

4060: s_curr_earnings_due := s_bb_prior_period_adj + s_bb_pmt_recovery_plans + l_curr_earnings;
4061: -- removed + l_held_amount_prior; (held amount is in s_bb_prior_period_adj)
4062:
4063: -- update worksheet record
4064: UPDATE cn_payment_worksheets
4065: SET bb_prior_period_adj = s_bb_prior_period_adj,
4066: bb_pmt_recovery_plans = s_bb_pmt_recovery_plans,
4067: current_earnings = l_curr_earnings,
4068: current_earnings_due = s_curr_earnings_due,

Line 4117: p_org_id cn_payment_worksheets.org_id%TYPE,

4113: PROCEDURE generic_conc_processor
4114: (
4115: p_payrun_id IN NUMBER,
4116: p_params IN conc_params,
4117: p_org_id cn_payment_worksheets.org_id%TYPE,
4118: p_salesrep_tbl IN salesrep_tab_typ,
4119: x_errbuf OUT NOCOPY VARCHAR2,
4120: x_retcode OUT NOCOPY NUMBER
4121: ) IS

Line 4372: FROM cn_payment_worksheets wk

4368: CURSOR c_payrun_srp(c_payrun_id cn_payruns.payrun_id%TYPE, c_batch_sz number) IS
4369: SELECT salesrep_id,
4370: ceil(rownum / c_batch_sz)
4371: FROM (SELECT DISTINCT wk.salesrep_id
4372: FROM cn_payment_worksheets wk
4373: WHERE wk.worksheet_status = 'UNPAID'
4374: AND wk.quota_id IS NULL
4375: AND wk.payrun_id = c_payrun_id
4376: AND wk.org_id = mo_global.get_current_org_id);

Line 4422: FROM cn_payment_worksheets wk

4418: /*SELECT salesrep_id,
4419: ceil(rownum / l_batch_sz) BULK COLLECT
4420: INTO salesrep_t
4421: FROM (SELECT DISTINCT wk.salesrep_id
4422: FROM cn_payment_worksheets wk
4423: WHERE wk.worksheet_status = 'UNPAID'
4424: AND wk.quota_id IS NULL
4425: AND wk.payrun_id = l_payrun_id
4426: AND wk.org_id = mo_global.get_current_org_id);*/

Line 4488: l_ovn cn_payment_worksheets.object_version_number%TYPE;

4484: x_status VARCHAR2(200);
4485: x_loading_status VARCHAR2(20) := 'CN_UPDATED';
4486: l_start_time DATE;
4487: l_error_count NUMBER := 0;
4488: l_ovn cn_payment_worksheets.object_version_number%TYPE;
4489: BEGIN
4490: l_start_time := SYSDATE;
4491: fnd_file.put_line(fnd_file.log, ' Input Parameters Payrun_id = ' || p_payrun_id);
4492: fnd_file.put_line(fnd_file.log, ' Input Parameters Batch_id = ' || p_batch_id);

Line 4509: FROM cn_payment_worksheets_all wk

4505: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
4506:
4507: SELECT wk.payment_worksheet_id,wk.object_version_number
4508: INTO l_worksheet_rec.worksheet_id,l_ovn
4509: FROM cn_payment_worksheets_all wk
4510: WHERE wk.payrun_id = l_worksheet_rec.payrun_id
4511: AND wk.salesrep_id = l_worksheet_rec.salesrep_id
4512: AND quota_id IS NULL;
4513: