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_CWB_BACKOUT_POST_PROCESS dependencies on BEN_BATCH_RANGES

Line 427: FROM ben_batch_ranges ran

423: IS
424: SELECT ran.range_id
425: , ran.starting_person_action_id
426: , ran.ending_person_action_id
427: FROM ben_batch_ranges ran
428: WHERE ran.range_status_cd = 'U'
429: AND ran.benefit_action_id = v_benefit_action_id
430: AND ROWNUM < 2
431: FOR UPDATE OF ran.range_status_cd;

Line 1364: write_m ('Time before inserting ben batch ranges '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));

1360: , 1
1361: , decode(p_is_placeholder (l_count),1,'Y','N')
1362: );
1363:
1364: write_m ('Time before inserting ben batch ranges '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
1365: INSERT INTO ben_batch_ranges
1366: (range_id
1367: , benefit_action_id
1368: , range_status_cd

Line 1365: INSERT INTO ben_batch_ranges

1361: , decode(p_is_placeholder (l_count),1,'Y','N')
1362: );
1363:
1364: write_m ('Time before inserting ben batch ranges '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
1365: INSERT INTO ben_batch_ranges
1366: (range_id
1367: , benefit_action_id
1368: , range_status_cd
1369: , starting_person_action_id

Line 1373: VALUES (ben_batch_ranges_s.NEXTVAL

1369: , starting_person_action_id
1370: , ending_person_action_id
1371: , object_version_number
1372: )
1373: VALUES (ben_batch_ranges_s.NEXTVAL
1374: , p_benefit_action_id
1375: , 'U'
1376: , p_per_actn_id_array (1)
1377: , p_per_actn_id_array (l_num_rows)

Line 3983: g_actn := 'Marking ben_batch_ranges for range_id ' || l_range_id || ' as processed...';

3979: write_h ('Range with range_id ' || l_range_id || ' with Starting person action id '
3980: || l_start_person_action_id
3981: );
3982: write_h (' and Ending Person Action id ' || l_end_person_action_id || ' is selected');
3983: g_actn := 'Marking ben_batch_ranges for range_id ' || l_range_id || ' as processed...';
3984: WRITE (g_actn);
3985:
3986: UPDATE ben_batch_ranges ran
3987: SET ran.range_status_cd = 'P'

Line 3986: UPDATE ben_batch_ranges ran

3982: write_h (' and Ending Person Action id ' || l_end_person_action_id || ' is selected');
3983: g_actn := 'Marking ben_batch_ranges for range_id ' || l_range_id || ' as processed...';
3984: WRITE (g_actn);
3985:
3986: UPDATE ben_batch_ranges ran
3987: SET ran.range_status_cd = 'P'
3988: WHERE ran.range_id = l_range_id;
3989:
3990: COMMIT;