eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_THREAD dependencies on BEN_BATCH_RANGES

Line 2197: l_range_id ben_batch_ranges.range_id%type;

2193: --
2194: -- Local variable declaration
2195: --
2196: l_proc varchar2(80);
2197: l_range_id ben_batch_ranges.range_id%type;
2198: l_start_person_action_id number := 0;
2199: l_end_person_action_id number := 0;
2200: l_xrs_object_version_number number;
2201: l_line number := 0;

Line 2216: from ben_batch_ranges ran

2212: cursor c_range_thread is
2213: select ran.range_id
2214: ,ran.starting_person_action_id
2215: ,ran.ending_person_action_id
2216: from ben_batch_ranges ran
2217: where ran.range_status_cd = 'U'
2218: and ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
2219: and rownum < 2
2220: for update of ran.range_status_cd;

Line 2224: from ben_batch_ranges ran

2220: for update of ran.range_status_cd;
2221: --
2222: cursor c_range_err is
2223: select 1
2224: from ben_batch_ranges ran
2225: where ran.range_status_cd = 'E'
2226: and ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID;
2227: --
2228: l_dummy number;

Line 2371: update ben_batch_ranges ran set ran.range_status_cd = 'P'

2367: --RCHASE 115.59 - move update within cursor context.
2368: --
2369: l_line := 3;
2370: --
2371: update ben_batch_ranges ran set ran.range_status_cd = 'P'
2372: where ran.range_id = l_range_id;
2373: --
2374: commit;
2375: --

Line 2437: update ben_batch_ranges

2433: --
2434: when g_job_failure_error then
2435: --
2436: -- this will halt all other threads.
2437: update ben_batch_ranges
2438: set range_status_cd = 'E'
2439: where range_id = l_range_id;
2440: --
2441: -- write to the extract error table, so error will be reported

Line 2488: update ben_batch_ranges

2484: when others then
2485: --
2486: -- this will halt all other threads.
2487: --
2488: update ben_batch_ranges
2489: set range_status_cd = 'E'
2490: where range_id = l_range_id;
2491: --
2492: fnd_message.set_name('BEN', 'BEN_92190_THREAD_LABEL');

Line 5471: l_range_id ben_batch_ranges.range_id%type;

5467: l_request_id number;
5468: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
5469: l_person_id l_number_type := l_number_type();
5470: l_person_action_id l_number_type := l_number_type();
5471: l_range_id ben_batch_ranges.range_id%type;
5472: l_object_version_number ben_batch_ranges.object_version_number%type;
5473: l_chunk_size number(5) := 20;
5474: l_threads number(5) := 1;
5475: l_max_errors_allowed number(5) := 20;

Line 5472: l_object_version_number ben_batch_ranges.object_version_number%type;

5468: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
5469: l_person_id l_number_type := l_number_type();
5470: l_person_action_id l_number_type := l_number_type();
5471: l_range_id ben_batch_ranges.range_id%type;
5472: l_object_version_number ben_batch_ranges.object_version_number%type;
5473: l_chunk_size number(5) := 20;
5474: l_threads number(5) := 1;
5475: l_max_errors_allowed number(5) := 20;
5476: l_start_person_action_id number := 0;

Line 6052: select ben_batch_ranges_s.nextval

6048: l_benefit_action_id,
6049: 'U',
6050: 1);
6051: --
6052: select ben_batch_ranges_s.nextval
6053: into l_range_id
6054: from sys.dual;
6055: --
6056: l_start_person_action_id := l_person_action_id(1);

Line 6059: insert into ben_batch_ranges

6055: --
6056: l_start_person_action_id := l_person_action_id(1);
6057: l_end_person_action_id := l_person_action_id(l_num_rows);
6058: --
6059: insert into ben_batch_ranges
6060: (range_id,
6061: benefit_action_id,
6062: range_status_cd,
6063: starting_person_action_id,

Line 6119: select ben_batch_ranges_s.nextval

6115: l_num_range := l_num_range + 1;
6116: --
6117: -- Get next sequence for the range
6118: --
6119: select ben_batch_ranges_s.nextval
6120: into l_range_id
6121: from sys.dual;
6122: --
6123: l_start_person_action_id := l_person_action_id(1);

Line 6126: insert into ben_batch_ranges

6122: --
6123: l_start_person_action_id := l_person_action_id(1);
6124: l_end_person_action_id := l_person_action_id(l_num_rows);
6125: --
6126: insert into ben_batch_ranges
6127: (range_id,
6128: benefit_action_id,
6129: range_status_cd,
6130: starting_person_action_id,

Line 6160: from ben_batch_ranges

6156: and ACTION_STATUS_CD='U';
6157: --vkodedal 30-Mar-2009 Bug#8335771 -Restart process not spawning threads
6158: select count(*)
6159: into l_num_range
6160: from ben_batch_ranges
6161: where benefit_action_id = p_benefit_action_id
6162: and range_status_cd='U';
6163: ---
6164: l_benefit_action_id := p_benefit_action_id ;

Line 6742: from ben_batch_ranges ran

6738:
6739:
6740: cursor c_range_err is
6741: select *
6742: from ben_batch_ranges ran
6743: where ran.range_status_cd = 'E'
6744: and ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID;
6745:
6746:

Line 6804: update ben_batch_ranges

6800: ,p_end_person_action_id => rng.ending_person_action_id
6801: ,p_effective_date => l_parameters.process_date
6802: ) ;
6803: ---- range_id is updated
6804: update ben_batch_ranges
6805: set range_Status_cd = 'U'
6806: where range_id = rng.range_id ;
6807: end loop ;
6808: end if ;

Line 7056: from ben_batch_ranges ran

7052: l_parameters c_parameters%rowtype;
7053:
7054: cursor c_range_err is
7055: select *
7056: from ben_batch_ranges ran
7057: where ran.range_status_cd in ( 'E', 'W')
7058: and ran.benefit_action_id = l_benefit_action_id;
7059:
7060:

Line 7121: update ben_batch_ranges

7117: ,p_end_person_action_id => rng.ending_person_action_id
7118: ,p_effective_date => l_parameters.process_date
7119: ) ;
7120: -- range_id is updated
7121: update ben_batch_ranges
7122: set range_status_cd = 'U'
7123: where range_id = rng.range_id;
7124: end loop;
7125: end if ;