APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on BEN_BATCH_RANGES

Line 430: l_range_id ben_batch_ranges.range_id%type;

426: l_person_id ben_person_actions.person_id%type;
427: l_person_action_id ben_person_actions.person_action_id%type;
428: l_object_version_number ben_person_actions.object_version_number%type;
429: l_ler_id ben_person_actions.ler_id%type;
430: l_range_id ben_batch_ranges.range_id%type;
431: l_record_number number := 0;
432: l_start_person_action_id number := 0;
433: l_end_person_action_id number := 0;
434: l_actn varchar2(80);

Line 446: From ben_batch_ranges ran

442: Cursor c_range_thread is
443: Select ran.range_id
444: ,ran.starting_person_action_id
445: ,ran.ending_person_action_id
446: From ben_batch_ranges ran
447: Where ran.range_status_cd = 'U'
448: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
449: And rownum < 2
450: For update of ran.range_status_cd

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

551: exit when c_range_thread%notfound;
552: close c_range_thread;
553: If(l_range_id is not NULL) then
554: --
555: l_actn := 'Updating ben_batch_ranges row...';
556: --
557: update ben_batch_ranges ran set ran.range_status_cd = 'P'
558: where ran.range_id = l_range_id;
559: commit;

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

553: If(l_range_id is not NULL) then
554: --
555: l_actn := 'Updating ben_batch_ranges row...';
556: --
557: update ben_batch_ranges ran set ran.range_status_cd = 'P'
558: where ran.range_id = l_range_id;
559: commit;
560: End if;
561: --

Line 764: l_range_id ben_batch_ranges.range_id%type;

760: l_proc varchar2(80) := g_package||'.process';
761: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
762: l_object_version_number ben_benefit_actions.object_version_number%type;
763: l_person_id_out per_people_f.person_id%type;
764: l_range_id ben_batch_ranges.range_id%type;
765: l_chunk_size number;
766: l_threads number;
767: l_start_person_action_id number := 0;
768: l_end_person_action_id number := 0;

Line 1074: select ben_batch_ranges_s.nextval

1070: l_num_ranges := l_num_ranges + 1;
1071: --
1072: -- Select next sequence number for the range
1073: --
1074: select ben_batch_ranges_s.nextval
1075: into l_range_id
1076: from sys.dual;
1077: --
1078: -- Calculate start and end points of the range

Line 1083: insert into ben_batch_ranges

1079: --
1080: l_start_person_action_id := l_person_action_id(1);
1081: l_end_person_action_id := l_person_action_id(l_num_rows);
1082: --
1083: insert into ben_batch_ranges
1084: (range_id,
1085: benefit_action_id,
1086: range_status_cd,
1087: starting_person_action_id,

Line 1140: select ben_batch_ranges_s.nextval

1136: l_num_ranges := l_num_ranges + 1;
1137: --
1138: -- Get next sequence for the range
1139: --
1140: select ben_batch_ranges_s.nextval
1141: into l_range_id
1142: from sys.dual;
1143: --
1144: l_start_person_action_id := l_person_action_id(1);

Line 1147: insert into ben_batch_ranges

1143: --
1144: l_start_person_action_id := l_person_action_id(1);
1145: l_end_person_action_id := l_person_action_id(l_num_rows);
1146: --
1147: insert into ben_batch_ranges
1148: (range_id,
1149: benefit_action_id,
1150: range_status_cd,
1151: starting_person_action_id,