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 85: UPDATE cn_payment_worksheets_all w

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

Line 482: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,

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

Line 892: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,

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

Line 1381: FROM cn_payment_worksheets,

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

Line 1383: WHERE cn_payment_worksheets.salesrep_id = p_worksheet_rec.salesrep_id

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

Line 1384: AND cn_payment_worksheets.payrun_id = cn_payruns.payrun_id

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

Line 1491: FROM cn_payment_worksheets

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

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 1862: FROM cn_payment_worksheets

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

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 1960: FROM cn_payment_worksheets pw

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

Line 1998: cn_payment_worksheets wksht

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

Line 2270: FROM cn_payment_worksheets_all cnpw

2266: AND cnp.org_id = cnspg.org_id
2267: AND cnp.org_id = cns.org_id
2268: AND ((cnspg.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspg.end_date, cnps.start_date)))
2269: AND NOT EXISTS (SELECT 1
2270: FROM cn_payment_worksheets_all cnpw
2271: WHERE cnpw.salesrep_id = cnspg.salesrep_id
2272: AND cnp.payrun_id = cnpw.payrun_id)
2273: AND (EXISTS (SELECT 1
2274: FROM cn_srp_payee_assigns cnspa

Line 2356: FROM cn_payment_worksheets cnpw,

2352: decode(cnp.incentive_type_code, 'ALL', '', cnp.incentive_type_code) incentive_type_code,
2353: cnp.pay_date,
2354: cnpw.object_version_number ovn,
2355: cnpw.org_id
2356: FROM cn_payment_worksheets cnpw,
2357: cn_payruns cnp
2358: WHERE payment_worksheet_id = p_worksheet_id
2359: AND cnpw.payrun_id = cnp.payrun_id;
2360:

Line 2368: cn_payment_worksheets wk

2364: SELECT payables_flag,
2365: payroll_flag,
2366: payables_ccid_level
2367: FROM cn_repositories rp,
2368: cn_payment_worksheets wk
2369: WHERE rp.org_id = wk.org_id;
2370:
2371: wksht_rec get_worksheet_id%ROWTYPE;
2372: l_status cn_payment_worksheets.worksheet_status%TYPE;

Line 2372: l_status cn_payment_worksheets.worksheet_status%TYPE;

2368: cn_payment_worksheets wk
2369: WHERE rp.org_id = wk.org_id;
2370:
2371: wksht_rec get_worksheet_id%ROWTYPE;
2372: l_status cn_payment_worksheets.worksheet_status%TYPE;
2373: l_posting_batch_id NUMBER;
2374: recv_posting_batch_id NUMBER;
2375: carryover_posting_batch_id NUMBER;
2376:

Line 3163: UPDATE cn_payment_worksheets

3159: AND cnpt.org_id = wksht_rec.org_id;
3160: END IF; -- End IF l_calc_rec_tbl(i).pmt_amount_adj_rec <> 0
3161:
3162: -- Update the Worksheet at the Quota Level
3163: UPDATE cn_payment_worksheets
3164: SET pmt_amount_calc = nvl(l_calc_rec_tbl(i).pmt_amount_calc, 0),
3165: pmt_amount_adj_rec = nvl(l_calc_rec_tbl(i).pmt_amount_adj_rec, 0),
3166: pmt_amount_adj_nrec = nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0),
3167: pmt_amount_adj = nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 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 3211: UPDATE cn_payment_worksheets

3207: END LOOP;
3208: END IF; -- end IF l_calc_rec_tbl.COUNT > 0 THEN
3209:
3210: -- UPDATE the Summary Record in the Worksheet
3211: UPDATE cn_payment_worksheets
3212: SET pmt_amount_calc = l_calc_pmt_amount,
3213: pmt_amount_adj_rec = l_adj_pmt_amount_rec,
3214: pmt_amount_adj_nrec = l_adj_pmt_amount_nrec,
3215: pmt_amount_adj = l_pmt_amount_ctr,

Line 3266: FROM cn_payment_worksheets pw

3262: ELSE
3263:
3264: SELECT DISTINCT pw.quota_id
3265: BULK COLLECT INTO l_wk_plan_elements
3266: FROM cn_payment_worksheets pw
3267: WHERE pw.payrun_id = wksht_rec.payrun_id
3268: AND pw.salesrep_id = wksht_rec.salesrep_id
3269: AND pw.quota_id IS NOT NULL ;
3270:

Line 3305: cn_payment_worksheets wksht

3301: AND org_id = wksht_rec.org_id
3302: AND clk.srp_payee_assign_id IS NOT NULL
3303: AND EXISTS (SELECT 1
3304: FROM cn_srp_payee_assigns_all spayee,
3305: cn_payment_worksheets wksht
3306: WHERE clk.srp_payee_assign_id = spayee.srp_payee_assign_id
3307: AND spayee.quota_id = wksht.quota_id
3308: AND spayee.payee_id = wksht_rec.salesrep_id
3309: AND wksht.payrun_id = wksht_rec.payrun_id

Line 3449: UPDATE cn_payment_worksheets

3445: END IF;
3446: END IF;
3447:
3448: --Update object_version_number
3449: UPDATE cn_payment_worksheets
3450: SET object_version_number = nvl(object_version_number, 0) + 1,
3451: last_update_date = SYSDATE,
3452: last_updated_by = g_last_updated_by,
3453: last_update_login = g_last_update_login

Line 3456: FROM cn_payment_worksheets

3452: last_updated_by = g_last_updated_by,
3453: last_update_login = g_last_update_login
3454: WHERE (payrun_id, salesrep_id) IN (SELECT payrun_id,
3455: salesrep_id
3456: FROM cn_payment_worksheets
3457: WHERE payment_worksheet_id = p_worksheet_id);
3458:
3459: SELECT object_version_number
3460: INTO x_ovn

Line 3461: FROM cn_payment_worksheets

3457: WHERE payment_worksheet_id = p_worksheet_id);
3458:
3459: SELECT object_version_number
3460: INTO x_ovn
3461: FROM cn_payment_worksheets
3462: WHERE payment_worksheet_id = p_worksheet_id;
3463:
3464: -- End of API body.
3465: -- Standard check of p_commit.

Line 3523: FROM cn_payment_worksheets wk,

3519: SELECT wk.salesrep_id,
3520: wk.payrun_id,
3521: wk.org_id,
3522: pr.payrun_mode
3523: FROM cn_payment_worksheets wk,
3524: cn_payruns pr
3525: WHERE payment_worksheet_id = p_worksheet_id
3526: AND wk.payrun_id = pr.payrun_id;
3527:

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.

Line 3718: FROM cn_payment_worksheets w,

3714: p.status payrun_status,
3715: p.pay_period_id,
3716: p.payrun_id,
3717: w.org_id --R12
3718: FROM cn_payment_worksheets w,
3719: cn_payruns p
3720: WHERE w.payment_worksheet_id = p_worksheet_id
3721: AND w.payrun_id = p.payrun_id
3722: --R12

Line 3775: -- get data from cn_payment_worksheets

3771: IF (l_wksht_rec.quota_id IS NULL)
3772: THEN
3773: IF ((l_wksht_rec.payrun_status <> 'UNPAID') OR (l_wksht_rec.wksht_status <> 'UNPAID'))
3774: THEN
3775: -- get data from cn_payment_worksheets
3776: SELECT bb_prior_period_adj,
3777: bb_pmt_recovery_plans,
3778: current_earnings
3779: INTO x_bb_prior_period_adj,

Line 3782: FROM cn_payment_worksheets

3778: current_earnings
3779: INTO x_bb_prior_period_adj,
3780: x_bb_pmt_recovery_plans,
3781: x_curr_earnings
3782: FROM cn_payment_worksheets
3783: WHERE payment_worksheet_id = p_worksheet_id;
3784: ELSE
3785: -- get data from cn_srp_periods
3786: BEGIN

Line 3904: FROM cn_payment_worksheets w,

3900: p.status payrun_status,
3901: p.pay_period_id,
3902: p.payrun_id,
3903: w.org_id
3904: FROM cn_payment_worksheets w,
3905: cn_payruns p
3906: WHERE w.payment_worksheet_id = p_worksheet_id
3907: AND w.payrun_id = p.payrun_id;
3908:

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

3907: AND w.payrun_id = p.payrun_id;
3908:
3909: l_status_rec c_status_csr%ROWTYPE;
3910:
3911: CURSOR c_wksht_sum_csr(l_payrun_id cn_payruns.payrun_id%TYPE, l_srp_id cn_payment_worksheets.salesrep_id%TYPE,
3912: --R12
3913: p_org_id cn_payment_worksheets.org_id%TYPE) IS
3914: SELECT w.payment_worksheet_id,
3915: w.quota_id,

Line 3913: p_org_id cn_payment_worksheets.org_id%TYPE) IS

3909: l_status_rec c_status_csr%ROWTYPE;
3910:
3911: CURSOR c_wksht_sum_csr(l_payrun_id cn_payruns.payrun_id%TYPE, l_srp_id cn_payment_worksheets.salesrep_id%TYPE,
3912: --R12
3913: p_org_id cn_payment_worksheets.org_id%TYPE) IS
3914: SELECT w.payment_worksheet_id,
3915: w.quota_id,
3916: w.salesrep_id,
3917: w.object_version_number

Line 3918: FROM cn_payment_worksheets w

3914: SELECT w.payment_worksheet_id,
3915: w.quota_id,
3916: w.salesrep_id,
3917: w.object_version_number
3918: FROM cn_payment_worksheets w
3919: WHERE w.payrun_id = l_payrun_id
3920: AND w.salesrep_id = l_srp_id
3921: AND w.quota_id IS NULL
3922: AND w.org_id = p_org_id;

Line 4018: UPDATE cn_payment_worksheets

4014: s_curr_earnings_due := s_bb_prior_period_adj + s_bb_pmt_recovery_plans + l_curr_earnings;
4015: -- removed + l_held_amount_prior; (held amount is in s_bb_prior_period_adj)
4016:
4017: -- update worksheet record
4018: UPDATE cn_payment_worksheets
4019: SET bb_prior_period_adj = s_bb_prior_period_adj,
4020: bb_pmt_recovery_plans = s_bb_pmt_recovery_plans,
4021: current_earnings = l_curr_earnings,
4022: current_earnings_due = s_curr_earnings_due,

Line 4071: p_org_id cn_payment_worksheets.org_id%TYPE,

4067: PROCEDURE generic_conc_processor
4068: (
4069: p_payrun_id IN NUMBER,
4070: p_params IN conc_params,
4071: p_org_id cn_payment_worksheets.org_id%TYPE,
4072: p_salesrep_tbl IN salesrep_tab_typ,
4073: x_errbuf OUT NOCOPY VARCHAR2,
4074: x_retcode OUT NOCOPY NUMBER
4075: ) IS

Line 4359: FROM cn_payment_worksheets wk

4355: SELECT salesrep_id,
4356: ceil(rownum / l_batch_sz) BULK COLLECT
4357: INTO salesrep_t
4358: FROM (SELECT DISTINCT wk.salesrep_id
4359: FROM cn_payment_worksheets wk
4360: WHERE wk.worksheet_status = 'UNPAID'
4361: AND wk.quota_id IS NULL
4362: AND wk.payrun_id = l_payrun_id
4363: AND wk.org_id = mo_global.get_current_org_id);

Line 4421: l_ovn cn_payment_worksheets.object_version_number%TYPE;

4417: x_status VARCHAR2(200);
4418: x_loading_status VARCHAR2(20) := 'CN_UPDATED';
4419: l_start_time DATE;
4420: l_error_count NUMBER := 0;
4421: l_ovn cn_payment_worksheets.object_version_number%TYPE;
4422: BEGIN
4423: l_start_time := SYSDATE;
4424: fnd_file.put_line(fnd_file.log, ' Input Parameters Payrun_id = ' || p_payrun_id);
4425: fnd_file.put_line(fnd_file.log, ' Input Parameters Batch_id = ' || p_batch_id);

Line 4442: FROM cn_payment_worksheets_all wk

4438: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
4439:
4440: SELECT wk.payment_worksheet_id,wk.object_version_number
4441: INTO l_worksheet_rec.worksheet_id,l_ovn
4442: FROM cn_payment_worksheets_all wk
4443: WHERE wk.payrun_id = l_worksheet_rec.payrun_id
4444: AND wk.salesrep_id = l_worksheet_rec.salesrep_id
4445: AND quota_id IS NULL;
4446: