1024: -- Get Primary Key value
1025: --
1026: select ben_person_actions_s.nextval
1027: into l_person_action_id(l_num_rows)
1028: from sys.dual;
1029: --
1030: -- Extend person_id type
1031: --
1032: l_person_id.extend(1);
1058: -- Select next sequence number for the range
1059: --
1060: select ben_batch_ranges_s.nextval
1061: into l_range_id
1062: from sys.dual;
1063: --
1064: -- Calculate start and end points of the range
1065: --
1066: l_start_person_action_id := l_person_action_id(1);
1124: -- Get next sequence for the range
1125: --
1126: select ben_batch_ranges_s.nextval
1127: into l_range_id
1128: from sys.dual;
1129: --
1130: l_start_person_action_id := l_person_action_id(1);
1131: l_end_person_action_id := l_person_action_id(l_num_rows);
1132: --