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

Line 569: FROM ben_batch_ranges ran

565: IS
566: SELECT ran.range_id
567: , ran.starting_person_action_id
568: , ran.ending_person_action_id
569: FROM ben_batch_ranges ran
570: WHERE ran.range_status_cd = 'U'
571: AND ran.benefit_action_id = v_benefit_action_id
572: AND ROWNUM < 2
573: FOR UPDATE OF ran.range_status_cd;

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

1594: , 1
1595: , decode(p_is_placeholder (l_count),1,'Y','N')
1596: );
1597:
1598: write_m ('Time before inserting ben batch ranges '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
1599: INSERT INTO ben_batch_ranges
1600: (range_id
1601: , benefit_action_id
1602: , range_status_cd

Line 1599: INSERT INTO ben_batch_ranges

1595: , decode(p_is_placeholder (l_count),1,'Y','N')
1596: );
1597:
1598: write_m ('Time before inserting ben batch ranges '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
1599: INSERT INTO ben_batch_ranges
1600: (range_id
1601: , benefit_action_id
1602: , range_status_cd
1603: , starting_person_action_id

Line 1607: VALUES (ben_batch_ranges_s.NEXTVAL

1603: , starting_person_action_id
1604: , ending_person_action_id
1605: , object_version_number
1606: )
1607: VALUES (ben_batch_ranges_s.NEXTVAL
1608: , p_benefit_action_id
1609: , 'U'
1610: , p_per_actn_id_array (1)
1611: , p_per_actn_id_array (l_num_rows)

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

4872: write_h ('Range with range_id ' || l_range_id || ' with Starting person action id '
4873: || l_start_person_action_id
4874: );
4875: write_h (' and Ending Person Action id ' || l_end_person_action_id || ' is selected');
4876: g_actn := 'Marking ben_batch_ranges for range_id ' || l_range_id || ' as processed...';
4877: WRITE (g_actn);
4878:
4879: UPDATE ben_batch_ranges ran
4880: SET ran.range_status_cd = 'P'

Line 4879: UPDATE ben_batch_ranges ran

4875: write_h (' and Ending Person Action id ' || l_end_person_action_id || ' is selected');
4876: g_actn := 'Marking ben_batch_ranges for range_id ' || l_range_id || ' as processed...';
4877: WRITE (g_actn);
4878:
4879: UPDATE ben_batch_ranges ran
4880: SET ran.range_status_cd = 'P'
4881: WHERE ran.range_id = l_range_id;
4882:
4883: COMMIT;