[Home] [Help]
1350: end loop;
1351: --
1352: -- Bulk bind and insert
1353: --
1354: l_table_name :='BEN_BATCH_LER_INFO';
1355: forall l_count in 1..l_num_recs
1356: --
1357: insert into ben_batch_ler_info
1358: (batch_ler_id,
1353: --
1354: l_table_name :='BEN_BATCH_LER_INFO';
1355: forall l_count in 1..l_num_recs
1356: --
1357: insert into ben_batch_ler_info
1358: (batch_ler_id,
1359: benefit_action_id,
1360: person_id,
1361: ler_id,
2394: -- hr_utility.set_location('Entering:'||l_proc, 5);
2395: --
2396: g_batch_ler_table_object.extend(1);
2397: l_count := g_batch_ler_table_object.count;
2398: select ben_batch_ler_info_s.nextval into
2399: g_batch_ler_table_object(l_count).batch_ler_id
2400: from sys.dual;
2401: --
2402: g_batch_ler_table_object(l_count).benefit_action_id := g_benefit_action_id;