DBA Data[Home] [Help]

APPS.BEN_DM_UTILITY dependencies on BEN_BATCH_PARAMETER

Line 24: -- to use by looking at ben_batch_parameters which is striped by business

20: -- start
21:
22: -- ------------------------- number_of_threads ------------------------
23: -- Description: Finds the number of threads for the concurrent manager
24: -- to use by looking at ben_batch_parameters which is striped by business
25: -- group id. Fetch the first Thread count found and use that which will
26: -- be irrepective of a BG due to that fact the Person Migrator can work
27: -- across Business Groups and there is no way to change the threads which
28: -- are spawned during a Migrator processing.

Line 53: FROM ben_batch_parameter

49:
50:
51: CURSOR csr_threads IS
52: SELECT thread_cnt_num
53: FROM ben_batch_parameter
54: WHERE (batch_exe_cd = 'BENDM');
55:
56: --
57: BEGIN

Line 75: 'ben_batch_parameters - using default value', 12);

71: -- set default value if no entry exists for the current business group
72: IF (l_threads IS NULL) THEN
73: l_threads := 3;
74: message('INFO','No value for the number of threads found in ' ||
75: 'ben_batch_parameters - using default value', 12);
76: END IF;
77:
78: -- make sure that we have at least one thread
79: IF (l_threads <1) THEN