APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on BEN_BATCH_RANGES

Line 416: l_range_id ben_batch_ranges.range_id%type;

412: l_person_id ben_person_actions.person_id%type;
413: l_person_action_id ben_person_actions.person_action_id%type;
414: l_object_version_number ben_person_actions.object_version_number%type;
415: l_ler_id ben_person_actions.ler_id%type;
416: l_range_id ben_batch_ranges.range_id%type;
417: l_record_number number := 0;
418: l_start_person_action_id number := 0;
419: l_end_person_action_id number := 0;
420: l_actn varchar2(80);

Line 432: From ben_batch_ranges ran

428: Cursor c_range_thread is
429: Select ran.range_id
430: ,ran.starting_person_action_id
431: ,ran.ending_person_action_id
432: From ben_batch_ranges ran
433: Where ran.range_status_cd = 'U'
434: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
435: And rownum < 2
436: For update of ran.range_status_cd

Line 541: l_actn := 'Updating ben_batch_ranges row...';

537: exit when c_range_thread%notfound;
538: close c_range_thread;
539: If(l_range_id is not NULL) then
540: --
541: l_actn := 'Updating ben_batch_ranges row...';
542: --
543: update ben_batch_ranges ran set ran.range_status_cd = 'P'
544: where ran.range_id = l_range_id;
545: commit;

Line 543: update ben_batch_ranges ran set ran.range_status_cd = 'P'

539: If(l_range_id is not NULL) then
540: --
541: l_actn := 'Updating ben_batch_ranges row...';
542: --
543: update ben_batch_ranges ran set ran.range_status_cd = 'P'
544: where ran.range_id = l_range_id;
545: commit;
546: End if;
547: --

Line 750: l_range_id ben_batch_ranges.range_id%type;

746: l_proc varchar2(80) := g_package||'.process';
747: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
748: l_object_version_number ben_benefit_actions.object_version_number%type;
749: l_person_id_out per_people_f.person_id%type;
750: l_range_id ben_batch_ranges.range_id%type;
751: l_chunk_size number;
752: l_threads number;
753: l_start_person_action_id number := 0;
754: l_end_person_action_id number := 0;

Line 1060: select ben_batch_ranges_s.nextval

1056: l_num_ranges := l_num_ranges + 1;
1057: --
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

Line 1069: insert into ben_batch_ranges

1065: --
1066: l_start_person_action_id := l_person_action_id(1);
1067: l_end_person_action_id := l_person_action_id(l_num_rows);
1068: --
1069: insert into ben_batch_ranges
1070: (range_id,
1071: benefit_action_id,
1072: range_status_cd,
1073: starting_person_action_id,

Line 1126: select ben_batch_ranges_s.nextval

1122: l_num_ranges := l_num_ranges + 1;
1123: --
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);

Line 1133: insert into ben_batch_ranges

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: --
1133: insert into ben_batch_ranges
1134: (range_id,
1135: benefit_action_id,
1136: range_status_cd,
1137: starting_person_action_id,