DBA Data[Home] [Help]

APPS.CN_SCA_TRX_PROC_PVT dependencies on FND_PROFILE

Line 31: g_cn_debug VARCHAR2(1) := fnd_profile.value('CN_DEBUG');

27: no_trx EXCEPTION;
28: conc_fail EXCEPTION;
29: api_call_failed EXCEPTION;
30: fail_populate EXCEPTION;
31: g_cn_debug VARCHAR2(1) := fnd_profile.value('CN_DEBUG');
32:
33: FUNCTION get_adjusted_by
34: RETURN VARCHAR2 IS
35: l_adjusted_by VARCHAR2(100) := '0';

Line 40: WHERE user_id = fnd_profile.value('USER_ID');

36: BEGIN
37: SELECT user_name
38: INTO l_adjusted_by
39: FROM fnd_user
40: WHERE user_id = fnd_profile.value('USER_ID');
41: RETURN l_adjusted_by;
42: EXCEPTION
43: WHEN OTHERS THEN
44: RETURN l_adjusted_by;

Line 220: l_sleep_time_char := fnd_profile.value('CN_SLEEP_TIME');

216: debugmsg('Conc_Dispatch : Total conc requests submitted : '||x_batch_total);
217:
218: debug_v := l_primary_request_stack(primary_ptr);
219:
220: l_sleep_time_char := fnd_profile.value('CN_SLEEP_TIME');
221:
222: IF l_sleep_time_char IS NOT NULL THEN
223: l_sleep_time := to_number(l_sleep_time_char);
224: END IF;

Line 514: l_worker_num := NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'), 1);

510:
511: FETCH query_cur INTO l_logical_batch_size;
512: x_size := l_logical_batch_size;
513:
514: l_worker_num := NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'), 1);
515:
516: if (l_worker_num < 1) then
517:
518: l_worker_num := 1;