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 34: cn_payruns_all pr

30: - (SUM(nvl(balance4_bbd, 0) - nvl(balance4_bbc, 0))) - (SUM(nvl(balance4_dtd, 0) - nvl(balance4_ctd, 0)))
31: INTO l_bb_earn,
32: l_bb_pmt_recover
33: FROM cn_srp_periods_all s,
34: cn_payruns_all pr
35: WHERE s.salesrep_id = p_salesrep_id
36: AND s.org_id = pr.org_id
37: AND pr.payrun_id = p_payrun_id
38: AND s.quota_id IS NULL

Line 68: cn_payruns_all pr

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

Line 107: p_org_id IN cn_payruns.org_id%TYPE,

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

Line 156: p_org_id IN cn_payruns.org_id%TYPE

152: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,
153: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,
154: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: --R12
156: p_org_id IN cn_payruns.org_id%TYPE
157: ) IS
158: 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
159: SELECT MAX(p.period_id) max_period_id
160: FROM cn_period_statuses p,

Line 232: p_payrun_id IN cn_payruns.payrun_id%TYPE,

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

Line 234: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,

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

Line 322: p_org_id IN cn_payruns.org_id%TYPE

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

Line 379: p_period_id IN cn_payruns.pay_period_id%TYPE,

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

Line 383: p_org_id IN cn_payruns.org_id%TYPE

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

Line 483: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,

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

Line 484: p_payrun_id IN cn_payruns.payrun_id%TYPE,

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

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

Line 516: cn_payruns cnp

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

Line 566: cn_payruns cnp

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

Line 893: p_period_id IN cn_payruns.pay_period_id%TYPE,

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

Line 894: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,

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

Line 895: p_payrun_id IN cn_payruns.payrun_id%TYPE,

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

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

Line 1382: cn_payruns

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

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

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;
1389:
1390: -- Get the Payrun informations

Line 1396: FROM cn_payruns

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

Line 1406: FROM cn_payruns

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

Line 2077: p_org_id IN cn_payruns.org_id%TYPE

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

Line 2182: p_name cn_payruns.NAME%TYPE

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

Line 2192: l_org_id cn_payruns.org_id%TYPE;

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

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

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

Line 2203: FROM cn_payruns cp

2199: CURSOR get_payrun_id_curs(c_name cn_payruns.NAME%TYPE, c_org_id cn_payruns.org_id%TYPE) IS
2200: SELECT cp.payrun_id,
2201: cp.org_id,
2202: cp.status
2203: FROM cn_payruns cp
2204: WHERE cp.NAME = c_name
2205: AND cp.org_id = c_org_id;
2206:
2207: l_has_access BOOLEAN;

Line 2255: FROM cn_payruns cnp,

2251: SELECT salesrep_id,ceil(rownum / l_batch_sz)
2252: BULK COLLECT INTO salesrep_t
2253: FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2254: cns.NAME salesrep_name
2255: FROM cn_payruns cnp,
2256: cn_srp_pay_groups cnspg,
2257: cn_salesreps cns,
2258: cn_period_statuses cnps
2259: WHERE cnp.payrun_id = l_payrun_id

Line 2357: cn_payruns cnp

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

Line 2452: cn_payruns_all pr

2448: l_payroll_flag,
2449: l_payables_flag
2450: FROM cn_salesreps s,
2451: cn_repositories_all r,
2452: cn_payruns_all pr
2453: WHERE s.salesrep_id = wksht_rec.salesrep_id
2454: AND s.org_id = r.org_id
2455: AND pr.org_id = r.org_id
2456: AND pr.payrun_id = wksht_rec.payrun_id;

Line 3524: cn_payruns pr

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

Line 3719: cn_payruns p

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

Line 3905: cn_payruns p

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

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

4087: l_sleep_time NUMBER := to_number(nvl(fnd_profile.VALUE('CN_SLEEP_TIME'), '20'));
4088: duration NUMBER(7, 1);
4089: errmsg VARCHAR2(4000) := '';
4090: err_num NUMBER := NULL;
4091: l_org_id cn_payruns.org_id%TYPE;
4092: BEGIN
4093: -- Standard Start of API savepoint
4094: SAVEPOINT generic_conc_processor;
4095: -- SUBMIT BATCHES

Line 4103: FROM cn_payruns pr

4099: -- lock payrun when when batching
4100: BEGIN
4101: SELECT pr.PAYRUN_ID
4102: INTO l_payrun_id
4103: FROM cn_payruns pr
4104: WHERE pr.PAYRUN_ID = p_payrun_id
4105: FOR UPDATE NOWAIT;
4106:
4107: EXCEPTION

Line 4299: p_name cn_payruns.NAME%TYPE

4295: PROCEDURE refresh_worksheet_parent
4296: (
4297: errbuf OUT NOCOPY VARCHAR2,
4298: retcode OUT NOCOPY NUMBER,
4299: p_name cn_payruns.NAME%TYPE
4300: ) IS
4301: salesrep_t salesrep_tab_typ;
4302: l_batch_sz NUMBER := 80;
4303: errmsg VARCHAR2(4000) := '';

Line 4311: l_org_id cn_payruns.org_id%TYPE;

4307: x_reps_exist NUMBER := 0;
4308:
4309: l_status VARCHAR2(30);
4310: --R12
4311: l_org_id cn_payruns.org_id%TYPE;
4312: l_conc_params conc_params ;
4313: l_has_access BOOLEAN;
4314:
4315: CURSOR get_payrun_id_curs IS

Line 4318: FROM cn_payruns pr

4314:
4315: CURSOR get_payrun_id_curs IS
4316: SELECT payrun_id,
4317: status
4318: FROM cn_payruns pr
4319: WHERE NAME = p_name
4320: AND org_id = mo_global.get_current_org_id;
4321: BEGIN
4322: fnd_file.put_line(fnd_file.log, 'Input Parameters Payrun_Name =' || p_name);

Line 4411: p_org_id IN cn_payruns.org_id%TYPE

4407: p_batch_id IN NUMBER,
4408: p_payrun_id IN NUMBER,
4409: p_logical_batch_id IN NUMBER,
4410: --R12
4411: p_org_id IN cn_payruns.org_id%TYPE
4412: ) IS
4413: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;
4414: x_msg_count NUMBER;
4415: x_msg_data VARCHAR2(4000);