[Home] [Help]
2261: RAISE fnd_api.g_exc_error;
2262: END IF;
2263:
2264: --Added for R12 payment security check end.
2265: l_org_id := mo_global.get_current_org_id;
2266:
2267:
2268: -- get payrun id
2269: OPEN get_payrun_id_curs(p_name, l_org_id);
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
4369: SELECT salesrep_id,
4370: ceil(rownum / c_batch_sz)
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);
4377:
4378: BEGIN
4379: fnd_file.put_line(fnd_file.log, 'Input Parameters Payrun_Name =' || p_name);
4380: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_payrun_refresh);
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);*/
4427:
4428: l_conc_params.conc_program_name := 'CN_REFRESH_WKSHT_CHILD' ;
4429:
4430: -- batch
4430: -- batch
4431: generic_conc_processor(p_payrun_id => l_payrun_id,
4432: p_salesrep_tbl => salesrep_t,
4433: p_params => l_conc_params,
4434: p_org_id => mo_global.get_current_org_id,
4435: x_errbuf => errbuf,
4436: x_retcode => retcode);
4437:
4438: EXIT WHEN c_payrun_srp%NOTFOUND;