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 580: FROM ben_batch_ranges ran

576: IS
577: SELECT ran.range_id
578: , ran.starting_person_action_id
579: , ran.ending_person_action_id
580: FROM ben_batch_ranges ran
581: WHERE ran.range_status_cd = 'U'
582: AND ran.benefit_action_id = v_benefit_action_id
583: AND ROWNUM < 2
584: FOR UPDATE OF ran.range_status_cd;

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

1614: , 1
1615: , decode(p_is_placeholder (l_count),1,'Y','N')
1616: );
1617:
1618: write_m ('Time before inserting ben batch ranges '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
1619: INSERT INTO ben_batch_ranges
1620: (range_id
1621: , benefit_action_id
1622: , range_status_cd

Line 1619: INSERT INTO ben_batch_ranges

1615: , decode(p_is_placeholder (l_count),1,'Y','N')
1616: );
1617:
1618: write_m ('Time before inserting ben batch ranges '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
1619: INSERT INTO ben_batch_ranges
1620: (range_id
1621: , benefit_action_id
1622: , range_status_cd
1623: , starting_person_action_id

Line 1627: VALUES (ben_batch_ranges_s.NEXTVAL

1623: , starting_person_action_id
1624: , ending_person_action_id
1625: , object_version_number
1626: )
1627: VALUES (ben_batch_ranges_s.NEXTVAL
1628: , p_benefit_action_id
1629: , 'U'
1630: , p_per_actn_id_array (1)
1631: , p_per_actn_id_array (l_num_rows)

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

4949: write_h ('Range with range_id ' || l_range_id || ' with Starting person action id '
4950: || l_start_person_action_id
4951: );
4952: write_h (' and Ending Person Action id ' || l_end_person_action_id || ' is selected');
4953: g_actn := 'Marking ben_batch_ranges for range_id ' || l_range_id || ' as processed...';
4954: WRITE (g_actn);
4955:
4956: UPDATE ben_batch_ranges ran
4957: SET ran.range_status_cd = 'P'

Line 4956: UPDATE ben_batch_ranges ran

4952: write_h (' and Ending Person Action id ' || l_end_person_action_id || ' is selected');
4953: g_actn := 'Marking ben_batch_ranges for range_id ' || l_range_id || ' as processed...';
4954: WRITE (g_actn);
4955:
4956: UPDATE ben_batch_ranges ran
4957: SET ran.range_status_cd = 'P'
4958: WHERE ran.range_id = l_range_id;
4959:
4960: COMMIT;