[Home] [Help]
32: l_old_record get_old_record%ROWTYPE;
33:
34: CURSOR get_worksheets(p_org_id cn_payruns.org_id%TYPE) IS
35: SELECT payment_worksheet_id,object_version_number
36: FROM cn_payment_worksheets
37: WHERE payrun_id = p_payrun_id
38: AND quota_id IS NULL
39: AND worksheet_status = 'UNPAID'
40: --R12
826:
827:
828: CURSOR get_quotas(p_payrun cn_payruns.payrun_id%TYPE) IS
829: select distinct w.quota_id,q.name
830: from cn_payment_worksheets w,
831: cn_quotas q,cn_salesreps cns
832: where payrun_id=p_payrun
833: and w.quota_id is not null
834: and w.quota_id=q.quota_id
1461: SELECT cns.salesrep_id, pvs.vendor_id supplier_id,
1462: pvc.vendor_site_id supplier_site_id,
1463: currency_code
1464: FROM cn_salesreps cns,
1465: cn_payment_worksheets cnpw,
1466: po_vendor_sites pvs,
1467: po_vendor_contacts pvc
1468: WHERE cnpw.payrun_id = p_payrun_id
1469: AND cnpw.org_id=cns.org_id
1480:
1481: CURSOR get_salesreps IS
1482: SELECT cns.salesrep_id,cns.currency_code,cns.source_id
1483: FROM cn_salesreps cns,
1484: cn_payment_worksheets cnpw
1485: WHERE cnpw.payrun_id = p_payrun_id
1486: AND cnpw.org_id=cns.org_id
1487: AND cnpw.salesrep_id = cns.salesrep_id
1488: AND cnpw.quota_id IS NULL
1681:
1682: FUNCTION populate_ccids
1683: (
1684: p_payrun_id IN cn_payruns.payrun_id%TYPE,
1685: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,
1686: --p_start_date IN DATE,
1687: --p_end_date IN DATE,
1688: -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
1689: p_pmt_tran_id IN cn_payment_transactions.payment_transaction_id%TYPE DEFAULT NULL,
2160: l_old_record get_old_record%ROWTYPE;
2161:
2162: CURSOR get_wksht_csr IS
2163: SELECT payment_worksheet_id
2164: FROM cn_payment_worksheets
2165: WHERE payrun_id = p_payrun_id AND worksheet_status = 'UNPAID'
2166: AND quota_id IS NULL;
2167:
2168: l_has_access BOOLEAN;
2405: l_request get_conc_request%ROWTYPE;
2406:
2407: CURSOR get_worksheets IS
2408: SELECT payment_worksheet_id,object_version_number
2409: FROM cn_payment_worksheets
2410: WHERE payrun_id = p_payrun_id
2411: AND quota_id is null;
2412:
2413: G_LAST_UPDATE_DATE DATE := sysdate;
2644: l_api_version CONSTANT NUMBER := 1.0;
2645:
2646: CURSOR get_unpaid_wksht IS
2647: SELECT payment_worksheet_id, salesrep_id
2648: FROM cn_payment_worksheets
2649: WHERE payrun_id = p_payrun_id AND worksheet_status = 'UNPAID'
2650: AND quota_id IS NULL ;
2651:
2652: CURSOR get_unapprove_wksht IS
2650: AND quota_id IS NULL ;
2651:
2652: CURSOR get_unapprove_wksht IS
2653: SELECT payment_worksheet_id, salesrep_id
2654: FROM cn_payment_worksheets
2655: WHERE payrun_id = p_payrun_id AND worksheet_status <> 'APPROVED'
2656: AND quota_id IS NULL;
2657:
2658: BEGIN
2849: l_payrun_rec get_payrun%ROWTYPE;
2850:
2851: CURSOR get_salesreps_in_payrun(p_org_id cn_payruns.org_id%TYPE) IS
2852: SELECT distinct salesrep_id
2853: FROM cn_payment_worksheets
2854: WHERE payrun_id = p_payrun_id
2855: --R12
2856: AND org_id = p_org_id;
2857:
2858: CURSOR get_worksheet_data_for_pe (p_salesrep_id NUMBER, p_org_id cn_payruns.org_id%TYPE)IS
2859: SELECT salesrep_id, quota_id, credit_type_id,
2860: pmt_amount_calc, pmt_amount_adj, pmt_amount_adj_rec,
2861: pmt_amount_adj_nrec, pmt_amount_recovery
2862: FROM cn_payment_worksheets
2863: WHERE payrun_id = p_payrun_id
2864: AND salesrep_id = p_salesrep_id
2865: AND quota_id is not null;
2866:
2939: SELECT nvl(pmt_amount_calc,0),
2940: nvl(pmt_amount_adj_rec,0),
2941: nvl(pmt_amount_adj_nrec,0),
2942: -nvl(pmt_amount_recovery,0)
2943: FROM cn_payment_worksheets
2944: WHERE payrun_id = p_payrun_id
2945: AND salesrep_id = p_salesrep_id
2946: AND credit_type_id = l_credit_type_id
2947: AND (quota_id = p_quota_id