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_PAYRUNS

Line 36: cn_payruns_all pr

32: INTO l_bb_earn,
33: l_bb_pmt_recover,
34: l_bb4_begin
35: FROM cn_srp_periods_all s,
36: cn_payruns_all pr
37: WHERE s.salesrep_id = p_salesrep_id
38: AND s.org_id = pr.org_id
39: AND pr.payrun_id = p_payrun_id
40: AND s.quota_id IS NULL

Line 70: cn_payruns_all pr

66: INTO l_bonus_ptd,
67: l_comm_ptd
68: FROM cn_srp_period_quotas_all cspq,
69: cn_quotas_all quota,
70: cn_payruns_all pr
71: WHERE cspq.quota_id = quota.quota_id
72: AND quota.quota_id > 0
73: AND quota.org_id = cspq.org_id
74: AND pr.pay_period_id = cspq.period_id

Line 109: p_org_id IN cn_payruns.org_id%TYPE,

105: p_description IN VARCHAR2,
106: p_logical_batch_id IN NUMBER,
107: p_batch_id IN NUMBER,
108: p_payrun_id IN NUMBER,
109: p_org_id IN cn_payruns.org_id%TYPE,
110: p_params IN conc_params,
111: x_request_id OUT NOCOPY NUMBER
112: ) IS
113: BEGIN

Line 158: p_org_id IN cn_payruns.org_id%TYPE

154: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,
156: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,
157: --R12
158: p_org_id IN cn_payruns.org_id%TYPE
159: ) IS
160: CURSOR get_max_period_id_in_qtr(p_quarter_num cn_period_statuses.quarter_num%TYPE, p_period_year cn_period_statuses.period_year%TYPE) IS
161: SELECT MAX(p.period_id) max_period_id
162: FROM cn_period_statuses p,

Line 234: p_payrun_id IN cn_payruns.payrun_id%TYPE,

230: -- Calls :
231: -- ===========================================================================
232: PROCEDURE reset_payrun_id
233: (
234: p_payrun_id IN cn_payruns.payrun_id%TYPE,
235: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
236: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,
237: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE
238: ) IS

Line 236: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,

232: PROCEDURE reset_payrun_id
233: (
234: p_payrun_id IN cn_payruns.payrun_id%TYPE,
235: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
236: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,
237: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE
238: ) IS
239: BEGIN
240: IF p_incentive_type = 'ALL'

Line 324: p_org_id IN cn_payruns.org_id%TYPE

320: p_end_date IN cn_period_statuses.end_date%TYPE,
321: x_interval_start_date OUT NOCOPY cn_period_statuses.start_date%TYPE,
322: x_interval_end_date OUT NOCOPY cn_period_statuses.end_date%TYPE,
323: --R12
324: p_org_id IN cn_payruns.org_id%TYPE
325: ) IS
326: l_interval_start_date cn_period_statuses.start_date%TYPE;
327: l_interval_end_date cn_period_statuses.end_date%TYPE;
328: BEGIN

Line 381: p_period_id IN cn_payruns.pay_period_id%TYPE,

377: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
378: p_pmt_amount_adj_rec IN NUMBER,
379: p_pmt_amount_adj_nrec IN NUMBER,
380: p_payment_group_code IN cn_srp_pmt_plans_v.payment_group_code%TYPE,
381: p_period_id IN cn_payruns.pay_period_id%TYPE,
382: p_incentive_type IN cn_quotas.incentive_type_code%TYPE,
383: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,
384: --R12
385: p_org_id IN cn_payruns.org_id%TYPE

Line 385: p_org_id IN cn_payruns.org_id%TYPE

381: p_period_id IN cn_payruns.pay_period_id%TYPE,
382: p_incentive_type IN cn_quotas.incentive_type_code%TYPE,
383: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,
384: --R12
385: p_org_id IN cn_payruns.org_id%TYPE
386: ) IS
387: CURSOR get_pe_pg_count(p_payment_group_code VARCHAR2) IS
388: SELECT COUNT(DISTINCT cnq.quota_id) num_pe
389: FROM cn_srp_period_quotas cspq,

Line 485: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,

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.
489: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,

Line 486: p_payrun_id IN cn_payruns.payrun_id%TYPE,

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.
489: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,
490: --R12

Line 491: p_org_id IN cn_payruns.org_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.
489: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,
490: --R12
491: p_org_id IN cn_payruns.org_id%TYPE
492: ) IS
493: -- 2/7/03 AC Bug 2792037 get list of PE from cn_payment_transactions
494: -- 2/12/03 AC Bug 2800968 union all to old cursor(against cn_srp_periods)
495: -- to take care srp with no transaction but want to apply pmt plan

Line 518: cn_payruns cnp

514: SELECT cnsp.quota_id,
515: cnq.payment_group_code
516: FROM cn_srp_period_quotas cnsp,
517: cn_quotas_all cnq,
518: cn_payruns cnp
519: WHERE cnsp.salesrep_id = p_salesrep_id
520: AND cnq.credit_type_id = g_credit_type_id
521: AND cnq.incentive_type_code = nvl(p_incentive_type, cnq.incentive_type_code)
522: AND cnp.payrun_id = p_payrun_id

Line 568: cn_payruns cnp

564: SELECT cnsp.quota_id,
565: cnq.payment_group_code
566: FROM cn_srp_period_quotas cnsp,
567: cn_quotas_all cnq,
568: cn_payruns cnp
569: WHERE cnsp.salesrep_id = p_salesrep_id
570: AND cnq.credit_type_id = g_credit_type_id
571: AND cnq.incentive_type_code = nvl(p_incentive_type, cnq.incentive_type_code)
572: AND cnp.payrun_id = p_payrun_id

Line 895: p_period_id IN cn_payruns.pay_period_id%TYPE,

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,
899: --R12

Line 896: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,

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,
899: --R12
900: p_org_id IN cn_payruns.org_id%TYPE

Line 897: p_payrun_id IN cn_payruns.payrun_id%TYPE,

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,
899: --R12
900: p_org_id IN cn_payruns.org_id%TYPE
901: ) IS

Line 900: p_org_id IN cn_payruns.org_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,
899: --R12
900: p_org_id IN cn_payruns.org_id%TYPE
901: ) IS
902: CURSOR get_earnings_total(p_payment_group_code VARCHAR2) IS
903: SELECT SUM(cnpt.payment_amount) payment_amount
904: FROM cn_payment_transactions cnpt,

Line 1384: cn_payruns

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
1388: AND cn_payruns.status <> 'PAID';

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 1388: AND cn_payruns.status <> 'PAID';

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;
1391:
1392: -- Get the Payrun informations

Line 1398: FROM cn_payruns

1394: SELECT payrun_id,
1395: pay_period_id,
1396: incentive_type_code,
1397: pay_date
1398: FROM cn_payruns
1399: WHERE payrun_id = p_worksheet_rec.payrun_id
1400: FOR UPDATE NOWAIT;
1401:
1402: -- Get the Payrun informations for conc program

Line 1408: FROM cn_payruns

1404: SELECT payrun_id,
1405: pay_period_id,
1406: incentive_type_code,
1407: pay_date
1408: FROM cn_payruns
1409: WHERE payrun_id = p_worksheet_rec.payrun_id;
1410:
1411: -- Get the period information
1412: CURSOR get_prd_statuses(p_period_id NUMBER) IS

Line 2079: p_org_id IN cn_payruns.org_id%TYPE

2075: p_batch_id IN NUMBER,
2076: p_payrun_id IN NUMBER,
2077: p_logical_batch_id IN NUMBER,
2078: --R12
2079: p_org_id IN cn_payruns.org_id%TYPE
2080: )
2081: IS
2082: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Multiple_Worksheets';
2083: g_api_version CONSTANT NUMBER := 1.0;

Line 2184: p_name cn_payruns.NAME%TYPE

2180: PROCEDURE create_mult_worksheet_conc
2181: (
2182: errbuf OUT NOCOPY VARCHAR2,
2183: retcode OUT NOCOPY NUMBER,
2184: p_name cn_payruns.NAME%TYPE
2185: ) IS
2186: l_proc_audit_id NUMBER;
2187: l_return_status VARCHAR2(1000);
2188: l_msg_data VARCHAR2(2000);

Line 2194: l_org_id cn_payruns.org_id%TYPE;

2190: l_loading_status VARCHAR2(1000);
2191: l_status VARCHAR2(2000);
2192: l_payrun_id NUMBER;
2193: --R12
2194: l_org_id cn_payruns.org_id%TYPE;
2195: l_conc_params conc_params;
2196: errmsg VARCHAR2(4000) := '';
2197: l_max_batch_id NUMBER;
2198: salesrep_t salesrep_tab_typ;

Line 2201: CURSOR get_payrun_id_curs(c_name cn_payruns.NAME%TYPE, c_org_id cn_payruns.org_id%TYPE) IS

2197: l_max_batch_id NUMBER;
2198: salesrep_t salesrep_tab_typ;
2199: l_batch_sz NUMBER := 80;
2200:
2201: CURSOR get_payrun_id_curs(c_name cn_payruns.NAME%TYPE, c_org_id cn_payruns.org_id%TYPE) IS
2202: SELECT cp.payrun_id,
2203: cp.org_id,
2204: cp.status
2205: FROM cn_payruns cp

Line 2205: FROM cn_payruns cp

2201: CURSOR get_payrun_id_curs(c_name cn_payruns.NAME%TYPE, c_org_id cn_payruns.org_id%TYPE) IS
2202: SELECT cp.payrun_id,
2203: cp.org_id,
2204: cp.status
2205: FROM cn_payruns cp
2206: WHERE cp.NAME = c_name
2207: AND cp.org_id = c_org_id;
2208:
2209: CURSOR c_payrun_srp(c_payrun_id cn_payruns.payrun_id%TYPE, c_batch_sz number) IS

Line 2209: CURSOR c_payrun_srp(c_payrun_id cn_payruns.payrun_id%TYPE, c_batch_sz number) IS

2205: FROM cn_payruns cp
2206: WHERE cp.NAME = c_name
2207: AND cp.org_id = c_org_id;
2208:
2209: CURSOR c_payrun_srp(c_payrun_id cn_payruns.payrun_id%TYPE, c_batch_sz number) IS
2210: SELECT salesrep_id,ceil(rownum / c_batch_sz) FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2211: cns.NAME salesrep_name
2212: FROM cn_payruns cnp,
2213: cn_srp_pay_groups cnspg,

Line 2212: FROM cn_payruns cnp,

2208:
2209: CURSOR c_payrun_srp(c_payrun_id cn_payruns.payrun_id%TYPE, c_batch_sz number) IS
2210: SELECT salesrep_id,ceil(rownum / c_batch_sz) FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2211: cns.NAME salesrep_name
2212: FROM cn_payruns cnp,
2213: cn_srp_pay_groups cnspg,
2214: cn_salesreps cns,
2215: cn_period_statuses cnps
2216: WHERE cnp.payrun_id = c_payrun_id

Line 2297: FROM cn_payruns cnp,

2293: /*SELECT salesrep_id,ceil(rownum / l_batch_sz)
2294: BULK COLLECT INTO salesrep_t
2295: FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2296: cns.NAME salesrep_name
2297: FROM cn_payruns cnp,
2298: cn_srp_pay_groups cnspg,
2299: cn_salesreps cns,
2300: cn_period_statuses cnps
2301: WHERE cnp.payrun_id = l_payrun_id

Line 2403: cn_payruns cnp

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:
2407: -- changes for bug#2568937

Line 2498: cn_payruns_all pr

2494: l_payroll_flag,
2495: l_payables_flag
2496: FROM cn_salesreps s,
2497: cn_repositories_all r,
2498: cn_payruns_all pr
2499: WHERE s.salesrep_id = wksht_rec.salesrep_id
2500: AND s.org_id = r.org_id
2501: AND pr.org_id = r.org_id
2502: AND pr.payrun_id = wksht_rec.payrun_id;

Line 3570: cn_payruns pr

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:
3574: --R12 for OA.

Line 3765: cn_payruns p

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
3769: AND w.org_id = p.org_id;

Line 3951: cn_payruns p

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:
3955: l_status_rec c_status_csr%ROWTYPE;

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 4137: l_org_id cn_payruns.org_id%TYPE;

4133: l_sleep_time NUMBER := to_number(nvl(fnd_profile.VALUE('CN_SLEEP_TIME'), '20'));
4134: duration NUMBER(7, 1);
4135: errmsg VARCHAR2(4000) := '';
4136: err_num NUMBER := NULL;
4137: l_org_id cn_payruns.org_id%TYPE;
4138: BEGIN
4139: -- Standard Start of API savepoint
4140: SAVEPOINT generic_conc_processor;
4141: -- SUBMIT BATCHES

Line 4149: FROM cn_payruns pr

4145: -- lock payrun when when batching
4146: BEGIN
4147: SELECT pr.PAYRUN_ID
4148: INTO l_payrun_id
4149: FROM cn_payruns pr
4150: WHERE pr.PAYRUN_ID = p_payrun_id
4151: FOR UPDATE NOWAIT;
4152:
4153: EXCEPTION

Line 4345: p_name cn_payruns.NAME%TYPE

4341: PROCEDURE refresh_worksheet_parent
4342: (
4343: errbuf OUT NOCOPY VARCHAR2,
4344: retcode OUT NOCOPY NUMBER,
4345: p_name cn_payruns.NAME%TYPE
4346: ) IS
4347: salesrep_t salesrep_tab_typ;
4348: l_batch_sz NUMBER := 80;
4349: errmsg VARCHAR2(4000) := '';

Line 4357: l_org_id cn_payruns.org_id%TYPE;

4353: x_reps_exist NUMBER := 0;
4354:
4355: l_status VARCHAR2(30);
4356: --R12
4357: l_org_id cn_payruns.org_id%TYPE;
4358: l_conc_params conc_params ;
4359: l_has_access BOOLEAN;
4360:
4361: CURSOR get_payrun_id_curs IS

Line 4364: FROM cn_payruns pr

4360:
4361: CURSOR get_payrun_id_curs IS
4362: SELECT payrun_id,
4363: status
4364: FROM cn_payruns pr
4365: WHERE NAME = p_name
4366: AND org_id = mo_global.get_current_org_id;
4367:
4368: CURSOR c_payrun_srp(c_payrun_id cn_payruns.payrun_id%TYPE, c_batch_sz number) IS

Line 4368: CURSOR c_payrun_srp(c_payrun_id cn_payruns.payrun_id%TYPE, c_batch_sz number) IS

4364: FROM cn_payruns pr
4365: WHERE NAME = p_name
4366: AND org_id = mo_global.get_current_org_id;
4367:
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

Line 4478: p_org_id IN cn_payruns.org_id%TYPE

4474: p_batch_id IN NUMBER,
4475: p_payrun_id IN NUMBER,
4476: p_logical_batch_id IN NUMBER,
4477: --R12
4478: p_org_id IN cn_payruns.org_id%TYPE
4479: ) IS
4480: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;
4481: x_msg_count NUMBER;
4482: x_msg_data VARCHAR2(4000);