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 2195: l_range_id ben_batch_ranges.range_id%type;

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

Line 2214: from ben_batch_ranges ran

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

Line 2222: from ben_batch_ranges ran

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

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

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

Line 2435: update ben_batch_ranges

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

Line 2486: update ben_batch_ranges

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

Line 5468: l_range_id ben_batch_ranges.range_id%type;

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

Line 5469: l_object_version_number ben_batch_ranges.object_version_number%type;

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

Line 6020: select ben_batch_ranges_s.nextval

6016: l_benefit_action_id,
6017: 'U',
6018: 1);
6019: --
6020: select ben_batch_ranges_s.nextval
6021: into l_range_id
6022: from sys.dual;
6023: --
6024: l_start_person_action_id := l_person_action_id(1);

Line 6027: insert into ben_batch_ranges

6023: --
6024: l_start_person_action_id := l_person_action_id(1);
6025: l_end_person_action_id := l_person_action_id(l_num_rows);
6026: --
6027: insert into ben_batch_ranges
6028: (range_id,
6029: benefit_action_id,
6030: range_status_cd,
6031: starting_person_action_id,

Line 6086: select ben_batch_ranges_s.nextval

6082: l_num_range := l_num_range + 1;
6083: --
6084: -- Get next sequence for the range
6085: --
6086: select ben_batch_ranges_s.nextval
6087: into l_range_id
6088: from sys.dual;
6089: --
6090: l_start_person_action_id := l_person_action_id(1);

Line 6093: insert into ben_batch_ranges

6089: --
6090: l_start_person_action_id := l_person_action_id(1);
6091: l_end_person_action_id := l_person_action_id(l_num_rows);
6092: --
6093: insert into ben_batch_ranges
6094: (range_id,
6095: benefit_action_id,
6096: range_status_cd,
6097: starting_person_action_id,

Line 6701: from ben_batch_ranges ran

6697:
6698:
6699: cursor c_range_err is
6700: select *
6701: from ben_batch_ranges ran
6702: where ran.range_status_cd = 'E'
6703: and ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID;
6704:
6705:

Line 6763: update ben_batch_ranges

6759: ,p_end_person_action_id => rng.ending_person_action_id
6760: ,p_effective_date => l_parameters.process_date
6761: ) ;
6762: ---- range_id is updated
6763: update ben_batch_ranges
6764: set range_Status_cd = 'U'
6765: where range_id = rng.range_id ;
6766: end loop ;
6767: end if ;

Line 7015: from ben_batch_ranges ran

7011: l_parameters c_parameters%rowtype;
7012:
7013: cursor c_range_err is
7014: select *
7015: from ben_batch_ranges ran
7016: where ran.range_status_cd in ( 'E', 'W')
7017: and ran.benefit_action_id = l_benefit_action_id;
7018:
7019:

Line 7080: update ben_batch_ranges

7076: ,p_end_person_action_id => rng.ending_person_action_id
7077: ,p_effective_date => l_parameters.process_date
7078: ) ;
7079: -- range_id is updated
7080: update ben_batch_ranges
7081: set range_status_cd = 'U'
7082: where range_id = rng.range_id;
7083: end loop;
7084: end if ;