DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on FND_PROFILE

Line 2214: l_batch_sz := nvl(fnd_profile.value('CN_PMT_SRP_BATCH_SIZE'),251);

2210: retcode := 0;
2211: --Added for R12 payment security check begin.
2212: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_wksht_create);
2213: --Get the salesrep batch size from profile option.
2214: l_batch_sz := nvl(fnd_profile.value('CN_PMT_SRP_BATCH_SIZE'),251);
2215: fnd_file.put_line(fnd_file.log,'Batch size : ' ||l_batch_sz);
2216:
2217: IF l_batch_sz < 1
2218: THEN

Line 4087: l_sleep_time NUMBER := to_number(nvl(fnd_profile.VALUE('CN_SLEEP_TIME'), '20'));

4083: l_error_count NUMBER := 0;
4084: l_warning_count NUMBER := 0;
4085: mysysdate CONSTANT DATE := SYSDATE;
4086: l_request_id NUMBER := 0;
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;

Line 4325: l_batch_sz := nvl(fnd_profile.value('CN_PMT_SRP_BATCH_SIZE'),251);

4321: BEGIN
4322: fnd_file.put_line(fnd_file.log, 'Input Parameters Payrun_Name =' || p_name);
4323: 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);
4324: --Get the salesrep batch size from profile option.
4325: l_batch_sz := nvl(fnd_profile.value('CN_PMT_SRP_BATCH_SIZE'),251);
4326: fnd_file.put_line(fnd_file.log, 'Batch Size =' || to_char(l_batch_sz));
4327:
4328: IF l_batch_sz < 1
4329: THEN