APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_BATCH_RANGES

Line 1764: FROM ben_batch_ranges ran

1760: CURSOR c_range_for_thread (v_benefit_action_id IN NUMBER)
1761: IS
1762: SELECT ran.range_id, ran.starting_person_action_id,
1763: ran.ending_person_action_id
1764: FROM ben_batch_ranges ran
1765: WHERE ran.range_status_cd = 'U'
1766: AND ran.benefit_action_id = v_benefit_action_id
1767: AND ROWNUM < 2
1768: FOR UPDATE OF ran.range_status_cd;

Line 1881: 'Marking ben_batch_ranges for range_id '

1877: || l_end_person_action_id
1878: || ' is selected'
1879: );
1880: g_actn :=
1881: 'Marking ben_batch_ranges for range_id '
1882: || l_range_id
1883: || ' as processed...';
1884: WRITE (g_actn);
1885:

Line 1886: UPDATE ben_batch_ranges ran

1882: || l_range_id
1883: || ' as processed...';
1884: WRITE (g_actn);
1885:
1886: UPDATE ben_batch_ranges ran
1887: SET ran.range_status_cd = 'P'
1888: WHERE ran.range_id = l_range_id;
1889:
1890: COMMIT;

Line 2074: WRITE ( 'Time before inserting ben batch ranges '

2070: p_perd_id (l_count),
2071: p_bg_id (l_count),
2072: 1);
2073:
2074: WRITE ( 'Time before inserting ben batch ranges '
2075: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
2076:
2077: INSERT INTO ben_batch_ranges
2078: (range_id,

Line 2077: INSERT INTO ben_batch_ranges

2073:
2074: WRITE ( 'Time before inserting ben batch ranges '
2075: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
2076:
2077: INSERT INTO ben_batch_ranges
2078: (range_id,
2079: benefit_action_id,
2080: range_status_cd,
2081: starting_person_action_id,

Line 2085: ben_batch_ranges_s.NEXTVAL,

2081: starting_person_action_id,
2082: ending_person_action_id,
2083: object_version_number)
2084: VALUES (
2085: ben_batch_ranges_s.NEXTVAL,
2086: p_benefit_action_id,
2087: 'U',
2088: p_per_actn_id_array (1),
2089: p_per_actn_id_array (l_num_rows),