[Home] [Help]
123: function table_contents return varchar2 is
124: l_appls varchar2(4000); -- Bug 3214063
125: l_max number;
126: BEGIN
127: hr_utility.set_location('IN hrhirapl.table_contents',490);
128: l_max := p_table.COUNT;
129: hr_utility.trace('table rows : '||to_char(l_max));
130: for v_index in 1..l_max loop
131:
125: l_max number;
126: BEGIN
127: hr_utility.set_location('IN hrhirapl.table_contents',490);
128: l_max := p_table.COUNT;
129: hr_utility.trace('table rows : '||to_char(l_max));
130: for v_index in 1..l_max loop
131:
132: l_appls := l_appls||' ('||to_char(p_table(v_index).id)||')'
133: ||p_table(v_index).process_flag;
132: l_appls := l_appls||' ('||to_char(p_table(v_index).id)||')'
133: ||p_table(v_index).process_flag;
134:
135: END LOOP;
136: hr_utility.set_location('OUT hrhirapl.table_contents',495);
137: return(l_appls);
138: END;
139: --
140: --
157: -- END WWBUG fix for 1390173
158: --
159: --
160: begin
161: hr_utility.set_location('hr_person.get_period_of_service',1);
162: --
163: if p_emp_apl ='Y' then
164: begin
165: select pps.period_of_service_id
173: return v_dummy;
174: --
175: exception
176: when no_data_found then
177: hr_utility.set_message(801,'HR_6346_EMP_ASS_NO_POS');
178: hr_utility.raise_error;
179: when others then
180: null;
181: end;
174: --
175: exception
176: when no_data_found then
177: hr_utility.set_message(801,'HR_6346_EMP_ASS_NO_POS');
178: hr_utility.raise_error;
179: when others then
180: null;
181: end;
182: else
179: when others then
180: null;
181: end;
182: else
183: hr_utility.set_location('hr_person.get_period_of_service',2);
184: begin
185: select per_periods_of_service_s.nextval
186: into v_dummy
187: from sys.dual;
186: into v_dummy
187: from sys.dual;
188: exception
189: when no_data_found then
190: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
191: hr_utility.set_message_token('PROCEDURE','get_period_of_service');
192: hr_utility.set_message_token('STEP',1);
193: hr_utility.raise_error;
194: when others then null;
187: from sys.dual;
188: exception
189: when no_data_found then
190: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
191: hr_utility.set_message_token('PROCEDURE','get_period_of_service');
192: hr_utility.set_message_token('STEP',1);
193: hr_utility.raise_error;
194: when others then null;
195: end;
188: exception
189: when no_data_found then
190: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
191: hr_utility.set_message_token('PROCEDURE','get_period_of_service');
192: hr_utility.set_message_token('STEP',1);
193: hr_utility.raise_error;
194: when others then null;
195: end;
196: --
189: when no_data_found then
190: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
191: hr_utility.set_message_token('PROCEDURE','get_period_of_service');
192: hr_utility.set_message_token('STEP',1);
193: hr_utility.raise_error;
194: when others then null;
195: end;
196: --
197: hr_utility.set_location('hr_person.get_period_of_service',3);
193: hr_utility.raise_error;
194: when others then null;
195: end;
196: --
197: hr_utility.set_location('hr_person.get_period_of_service',3);
198: begin
199: insert into per_periods_of_service
200: (period_of_service_id
201: ,business_group_id
222: --
223: -- Bug No 4457579 Moved this check above call to ben_pps_ler.ler_chk
224: --
225: if SQL%ROWCOUNT < 1 then
226: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
227: hr_utility.set_message_token('PROCEDURE','get_period_of_service');
228: hr_utility.set_message_token('STEP',2);
229: hr_utility.raise_error;
230: end if;
223: -- Bug No 4457579 Moved this check above call to ben_pps_ler.ler_chk
224: --
225: if SQL%ROWCOUNT < 1 then
226: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
227: hr_utility.set_message_token('PROCEDURE','get_period_of_service');
228: hr_utility.set_message_token('STEP',2);
229: hr_utility.raise_error;
230: end if;
231: hr_utility.set_location('hr_person.get_period_of_service',4);
224: --
225: if SQL%ROWCOUNT < 1 then
226: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
227: hr_utility.set_message_token('PROCEDURE','get_period_of_service');
228: hr_utility.set_message_token('STEP',2);
229: hr_utility.raise_error;
230: end if;
231: hr_utility.set_location('hr_person.get_period_of_service',4);
232: --
225: if SQL%ROWCOUNT < 1 then
226: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
227: hr_utility.set_message_token('PROCEDURE','get_period_of_service');
228: hr_utility.set_message_token('STEP',2);
229: hr_utility.raise_error;
230: end if;
231: hr_utility.set_location('hr_person.get_period_of_service',4);
232: --
233: -- START WWBUG fix for 1390173
227: hr_utility.set_message_token('PROCEDURE','get_period_of_service');
228: hr_utility.set_message_token('STEP',2);
229: hr_utility.raise_error;
230: end if;
231: hr_utility.set_location('hr_person.get_period_of_service',4);
232: --
233: -- START WWBUG fix for 1390173
234: --
235: l_new.PERSON_ID := p_person_id;
273: --
274: --
275: begin
276: --
277: hr_utility.set_location('hr_person.update_primary_assignment',1);
278: --
279: insert into per_assignments_f
280: (assignment_id
281: ,effective_start_date
483: -- effective start date of the current assignment.(#1981550)
484: --
485: --
486: --if SQL%ROWCOUNT < 1 THEN
487: -- hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
488: -- hr_utility.set_message_token('PROCEDURE','update_primary_assignment');
489: -- hr_utility.set_message_token('STEP','1');
490: -- hr_utility.raise_error;
491: --end if;
484: --
485: --
486: --if SQL%ROWCOUNT < 1 THEN
487: -- hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
488: -- hr_utility.set_message_token('PROCEDURE','update_primary_assignment');
489: -- hr_utility.set_message_token('STEP','1');
490: -- hr_utility.raise_error;
491: --end if;
492: --
485: --
486: --if SQL%ROWCOUNT < 1 THEN
487: -- hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
488: -- hr_utility.set_message_token('PROCEDURE','update_primary_assignment');
489: -- hr_utility.set_message_token('STEP','1');
490: -- hr_utility.raise_error;
491: --end if;
492: --
493: end update_primary_assignment;
486: --if SQL%ROWCOUNT < 1 THEN
487: -- hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
488: -- hr_utility.set_message_token('PROCEDURE','update_primary_assignment');
489: -- hr_utility.set_message_token('STEP','1');
490: -- hr_utility.raise_error;
491: --end if;
492: --
493: end update_primary_assignment;
494: -- +-----------------------------------------------------------------------+
697: begin
698: -- # 2366672
699: -- Application needs to be end dated before the apl asg get updated.
700: --
701: hr_utility.set_location('hrhirapl.make_secondary',1);
702: -- +-----------------------------------------------------------------------+
703: -- +------------------------ End Application -----------------------------+
704: -- +-----------------------------------------------------------------------+
705: -- Does the Retain value exist in the table ?
708: -- we are "double-checking" that previous updates were successfull
709: -- that is why where clause checks for accepted and unaccepted, despite
710: -- the fact the table does not have stored a retain value .
711: --
712: hr_utility.set_location('hrhiapl.make_secondary',2);
713: --
714: update per_applications pap
715: set date_end = p_start_date -1,
716: successful_flag = 'Y'
746: and pa.effective_end_date);
747:
748: if SQL%NOTFOUND then
749: -- could not update the application
750: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
751: hr_utility.set_message_token('PROCEDURE','make_secondary ');
752: hr_utility.set_message_token('STEP','5');
753: hr_utility.raise_error;
754: end if;
747:
748: if SQL%NOTFOUND then
749: -- could not update the application
750: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
751: hr_utility.set_message_token('PROCEDURE','make_secondary ');
752: hr_utility.set_message_token('STEP','5');
753: hr_utility.raise_error;
754: end if;
755: end if; -- retain value in table?
748: if SQL%NOTFOUND then
749: -- could not update the application
750: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
751: hr_utility.set_message_token('PROCEDURE','make_secondary ');
752: hr_utility.set_message_token('STEP','5');
753: hr_utility.raise_error;
754: end if;
755: end if; -- retain value in table?
756: --
749: -- could not update the application
750: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
751: hr_utility.set_message_token('PROCEDURE','make_secondary ');
752: hr_utility.set_message_token('STEP','5');
753: hr_utility.raise_error;
754: end if;
755: end if; -- retain value in table?
756: --
757:
758: open get_flex_def;
759: fetch get_flex_def into l_col_name;
760: close get_flex_def;
761: --
762: hr_utility.set_location('hrhirapl.make_secondary',2);
763: --
764: -- Update all accepted assignments making them all
765: -- secondary (also end dates the assignment type 'A'
766: -- Unless the update primary_flag is set, in which case
766: -- Unless the update primary_flag is set, in which case
767: -- update all save the chosen assignment.
768: --
769: /* fix for the bug 5498344
770: hr_utility.set_location('p_update_primary_flag '||p_update_primary_flag,2);
771: if p_update_primary_flag not in ('C','N') then commented for bug 5589928*/
772:
773: open ass_cur;
774: loop
782: -- Ensure (R)etain or (E)nd date flags have not been set
783: if hr_employee_applicant_api.is_convert(p_table
784: ,l_asg_rec.assignment_id)
785: then
786: hr_utility.set_location('hrhirapl.make_secondary',333);
787: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
788: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
789:
790: -- +--------------------------------------------------+
783: if hr_employee_applicant_api.is_convert(p_table
784: ,l_asg_rec.assignment_id)
785: then
786: hr_utility.set_location('hrhirapl.make_secondary',333);
787: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
788: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
789:
790: -- +--------------------------------------------------+
791: -- +--- End Date assignment type 'A' -----------------+
784: ,l_asg_rec.assignment_id)
785: then
786: hr_utility.set_location('hrhirapl.make_secondary',333);
787: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
788: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
789:
790: -- +--------------------------------------------------+
791: -- +--- End Date assignment type 'A' -----------------+
792: -- +--------------------------------------------------+
980: ,l_asg_rec.job_post_source_name -- added for 4486233
981: ,l_asg_rec.supervisor_assignment_id); ---#4053244
982: exception
983: when others then
984: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
985: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
986: ||to_char(l_asg_rec.assignment_id));
987: hr_utility.set_message_token('STEP','2');
988: hr_utility.raise_error;
981: ,l_asg_rec.supervisor_assignment_id); ---#4053244
982: exception
983: when others then
984: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
985: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
986: ||to_char(l_asg_rec.assignment_id));
987: hr_utility.set_message_token('STEP','2');
988: hr_utility.raise_error;
989:
983: when others then
984: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
985: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
986: ||to_char(l_asg_rec.assignment_id));
987: hr_utility.set_message_token('STEP','2');
988: hr_utility.raise_error;
989:
990: end;
991: -- +----------- END end date of assignment -----------+
984: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
985: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
986: ||to_char(l_asg_rec.assignment_id));
987: hr_utility.set_message_token('STEP','2');
988: hr_utility.raise_error;
989:
990: end;
991: -- +----------- END end date of assignment -----------+
992: -- +--------------------------------------------------+
1157: ,p_employee_number
1158: ,p_assignment_sequence
1159: ,p_assignment_number);
1160: --
1161: hr_utility.set_location('hrhirapl.make_secondary',3);
1162: --
1163: -- fix for 7120387
1164: declare
1165:
1179: open appl_rec_det(l_asg_rec.application_id) ;
1180: fetch appl_rec_det into l_proj_hire_date;
1181: close appl_rec_det;
1182:
1183: hr_utility.set_location('l_asg_rec .assignment_id :'||l_asg_rec.assignment_id,20);
1184: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,20);
1185: hr_utility.set_location('make secondary proj end details ',20);
1186: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,20);
1187:
1180: fetch appl_rec_det into l_proj_hire_date;
1181: close appl_rec_det;
1182:
1183: hr_utility.set_location('l_asg_rec .assignment_id :'||l_asg_rec.assignment_id,20);
1184: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,20);
1185: hr_utility.set_location('make secondary proj end details ',20);
1186: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,20);
1187:
1188: if l_proj_hire_date is null then
1181: close appl_rec_det;
1182:
1183: hr_utility.set_location('l_asg_rec .assignment_id :'||l_asg_rec.assignment_id,20);
1184: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,20);
1185: hr_utility.set_location('make secondary proj end details ',20);
1186: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,20);
1187:
1188: if l_proj_hire_date is null then
1189:
1182:
1183: hr_utility.set_location('l_asg_rec .assignment_id :'||l_asg_rec.assignment_id,20);
1184: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,20);
1185: hr_utility.set_location('make secondary proj end details ',20);
1186: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,20);
1187:
1188: if l_proj_hire_date is null then
1189:
1190: if ( l_asg_rec.probation_period is not null)
1191: and
1192: (l_asg_rec.probation_unit is not null ) then
1193:
1194:
1195: hr_utility.set_location('p_start_date :'||p_start_date,11);
1196: hr_utility.set_location('l_asg_rec.assignment_id :'||l_asg_rec.assignment_id,11);
1197: hr_utility.set_location('l_asg_probation_det.probation_period :'||l_asg_rec.probation_period,12);
1198: hr_utility.set_location('l_asg_probation_det.probation_unit :'||l_asg_rec.probation_unit,15);
1199: l_date_probation_end :=NULL;
1192: (l_asg_rec.probation_unit is not null ) then
1193:
1194:
1195: hr_utility.set_location('p_start_date :'||p_start_date,11);
1196: hr_utility.set_location('l_asg_rec.assignment_id :'||l_asg_rec.assignment_id,11);
1197: hr_utility.set_location('l_asg_probation_det.probation_period :'||l_asg_rec.probation_period,12);
1198: hr_utility.set_location('l_asg_probation_det.probation_unit :'||l_asg_rec.probation_unit,15);
1199: l_date_probation_end :=NULL;
1200: hr_assignment.gen_probation_end
1193:
1194:
1195: hr_utility.set_location('p_start_date :'||p_start_date,11);
1196: hr_utility.set_location('l_asg_rec.assignment_id :'||l_asg_rec.assignment_id,11);
1197: hr_utility.set_location('l_asg_probation_det.probation_period :'||l_asg_rec.probation_period,12);
1198: hr_utility.set_location('l_asg_probation_det.probation_unit :'||l_asg_rec.probation_unit,15);
1199: l_date_probation_end :=NULL;
1200: hr_assignment.gen_probation_end
1201: (p_assignment_id => l_asg_rec.assignment_id
1194:
1195: hr_utility.set_location('p_start_date :'||p_start_date,11);
1196: hr_utility.set_location('l_asg_rec.assignment_id :'||l_asg_rec.assignment_id,11);
1197: hr_utility.set_location('l_asg_probation_det.probation_period :'||l_asg_rec.probation_period,12);
1198: hr_utility.set_location('l_asg_probation_det.probation_unit :'||l_asg_rec.probation_unit,15);
1199: l_date_probation_end :=NULL;
1200: hr_assignment.gen_probation_end
1201: (p_assignment_id => l_asg_rec.assignment_id
1202: ,p_probation_period => l_asg_rec.probation_period
1203: ,p_probation_unit => l_asg_rec.probation_unit
1204: ,p_start_date => p_start_date
1205: ,p_date_probation_end => l_date_probation_end
1206: );
1207: hr_utility.set_location('l_date_probation_end :'||l_date_probation_end,10);
1208: l_asg_rec.date_probation_end :=l_date_probation_end;
1209: end if;
1210: end if; -- proj hire end
1211:
1261: , pa.date_probation_end =l_asg_rec.date_probation_end --7120387
1262: where current of ass_cur; -- pa.rowid = p_rowid;
1263: exception
1264: when others then
1265: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1266: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1267: ||to_char(l_asg_rec.assignment_id));
1268: hr_utility.set_message_token('STEP','3');
1269: hr_utility.raise_error;
1262: where current of ass_cur; -- pa.rowid = p_rowid;
1263: exception
1264: when others then
1265: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1266: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1267: ||to_char(l_asg_rec.assignment_id));
1268: hr_utility.set_message_token('STEP','3');
1269: hr_utility.raise_error;
1270:
1264: when others then
1265: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1266: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1267: ||to_char(l_asg_rec.assignment_id));
1268: hr_utility.set_message_token('STEP','3');
1269: hr_utility.raise_error;
1270:
1271: end;
1272: -- Start of fix 3564129
1265: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1266: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1267: ||to_char(l_asg_rec.assignment_id));
1268: hr_utility.set_message_token('STEP','3');
1269: hr_utility.raise_error;
1270:
1271: end;
1272: -- Start of fix 3564129
1273: IRC_ASG_STATUS_API.create_irc_asg_status
1286: );
1287: -- End of fix 7289811
1288: -- Bug 401669
1289: --
1290: hr_utility.set_location('hrhirapl.make_secondary',4);
1291: --
1292: hr_assignment.load_budget_values(p_assignment_id
1293: ,p_business_group_id
1294: ,p_user_id
1320: -- +--------------------------------------------------+
1321: -- +--- End Date assignment --------------------------+
1322: -- +--------------------------------------------------+
1323: --
1324: hr_utility.set_location('hrhirapl.make_secondary',5);
1325: l_chk_assg_end_dated := 'Y'; -- bug 6310975
1326: begin
1327: update per_assignments_f
1328: set effective_end_date = p_start_date -1
1328: set effective_end_date = p_start_date -1
1329: where current of ass_cur;
1330: exception
1331: when others then
1332: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1333: to_char(l_asg_rec.assignment_id),66);
1334: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1336: hr_utility.set_message_token('STEP','4');
1330: exception
1331: when others then
1332: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1333: to_char(l_asg_rec.assignment_id),66);
1334: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1336: hr_utility.set_message_token('STEP','4');
1337: hr_utility.raise_error;
1338: end;
1331: when others then
1332: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1333: to_char(l_asg_rec.assignment_id),66);
1334: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1336: hr_utility.set_message_token('STEP','4');
1337: hr_utility.raise_error;
1338: end;
1339: end if; -- convert flag is set.
1332: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1333: to_char(l_asg_rec.assignment_id),66);
1334: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1336: hr_utility.set_message_token('STEP','4');
1337: hr_utility.raise_error;
1338: end;
1339: end if; -- convert flag is set.
1340: --
1333: to_char(l_asg_rec.assignment_id),66);
1334: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1336: hr_utility.set_message_token('STEP','4');
1337: hr_utility.raise_error;
1338: end;
1339: end if; -- convert flag is set.
1340: --
1341:
1364: */
1365: --
1366: --bug fix 6310975
1367:
1368: hr_utility.set_location('hrhirapl.make_secondary',500);
1369: IF l_chk_assg_end_dated <> 'Y' THEN
1370:
1371:
1372: OPEN get_pay_proposal(l_asg_rec.assignment_id);
1372: OPEN get_pay_proposal(l_asg_rec.assignment_id);
1373: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1374: if get_pay_proposal%found then
1375: close get_pay_proposal;
1376: hr_utility.set_location('hrhirapl.make_secondary',501);
1377: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1378: hr_utility.set_location(' make_secondary.l_dummy_change_date '||l_dummy_change_date,502);
1379: hr_utility.set_location(' make_secondary.l_pay_pspl_id '||l_pay_pspl_id,502);
1380: hr_utility.set_location(' make_secondary.l_proposed_sal_n '|| l_proposed_sal_n,502);
1373: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1374: if get_pay_proposal%found then
1375: close get_pay_proposal;
1376: hr_utility.set_location('hrhirapl.make_secondary',501);
1377: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1378: hr_utility.set_location(' make_secondary.l_dummy_change_date '||l_dummy_change_date,502);
1379: hr_utility.set_location(' make_secondary.l_pay_pspl_id '||l_pay_pspl_id,502);
1380: hr_utility.set_location(' make_secondary.l_proposed_sal_n '|| l_proposed_sal_n,502);
1381:
1374: if get_pay_proposal%found then
1375: close get_pay_proposal;
1376: hr_utility.set_location('hrhirapl.make_secondary',501);
1377: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1378: hr_utility.set_location(' make_secondary.l_dummy_change_date '||l_dummy_change_date,502);
1379: hr_utility.set_location(' make_secondary.l_pay_pspl_id '||l_pay_pspl_id,502);
1380: hr_utility.set_location(' make_secondary.l_proposed_sal_n '|| l_proposed_sal_n,502);
1381:
1382: -- fix for the bug 7636109 passing the value as null as requested by sal admin team.
1375: close get_pay_proposal;
1376: hr_utility.set_location('hrhirapl.make_secondary',501);
1377: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1378: hr_utility.set_location(' make_secondary.l_dummy_change_date '||l_dummy_change_date,502);
1379: hr_utility.set_location(' make_secondary.l_pay_pspl_id '||l_pay_pspl_id,502);
1380: hr_utility.set_location(' make_secondary.l_proposed_sal_n '|| l_proposed_sal_n,502);
1381:
1382: -- fix for the bug 7636109 passing the value as null as requested by sal admin team.
1383: l_pay_pspl_id:=null;
1376: hr_utility.set_location('hrhirapl.make_secondary',501);
1377: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1378: hr_utility.set_location(' make_secondary.l_dummy_change_date '||l_dummy_change_date,502);
1379: hr_utility.set_location(' make_secondary.l_pay_pspl_id '||l_pay_pspl_id,502);
1380: hr_utility.set_location(' make_secondary.l_proposed_sal_n '|| l_proposed_sal_n,502);
1381:
1382: -- fix for the bug 7636109 passing the value as null as requested by sal admin team.
1383: l_pay_pspl_id:=null;
1384: l_pay_obj_number:=null;
1407: OPEN get_pay_proposal(l_asg_rec.assignment_id);
1408: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1409: if get_pay_proposal%found then
1410: close get_pay_proposal;
1411: hr_utility.set_location('hrhirapl.make_secondary',521);
1412: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1413:
1414: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
1415: p_validate => false,
1408: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1409: if get_pay_proposal%found then
1410: close get_pay_proposal;
1411: hr_utility.set_location('hrhirapl.make_secondary',521);
1412: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1413:
1414: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
1415: p_validate => false,
1416: p_pay_proposal_id => l_pay_pspl_id ,
1423: p_approved_warning => l_approved_warning,
1424: p_payroll_warning => l_payroll_warning,
1425: p_proposed_salary_n => l_proposed_sal_n,
1426: p_business_group_id => p_business_group_id);
1427: hr_utility.set_location('hrhirapl.make_secondary',522);
1428: else
1429: close get_pay_proposal;
1430: end if;
1431:
1429: close get_pay_proposal;
1430: end if;
1431:
1432: end if;
1433: hr_utility.set_location('hrhirapl.make_secondary',524);
1434:
1435: --
1436: --bug fix 6310975
1437: --added by amigarg for bug 4882512 end
1443: /*else
1444: -- fix for the bug
1445: -- first process the primary assignment id so that the assignment number is
1446: -- correclty generated
1447: hr_utility.set_location('hrhirapl.make_secondary',400);
1448: open csr_ass_cur_for_primary;
1449: loop
1450: fetch csr_ass_cur_for_primary into l_asg_rec; --#2119831
1451: exit when csr_ass_cur_for_primary%NOTFOUND;
1457: -- Ensure (R)etain or (E)nd date flags have not been set
1458: if hr_employee_applicant_api.is_convert(p_table
1459: ,l_asg_rec.assignment_id)
1460: then
1461: hr_utility.set_location('hrhirapl.make_secondary',401);
1462: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
1463: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
1464:
1465: -- +--------------------------------------------------+
1458: if hr_employee_applicant_api.is_convert(p_table
1459: ,l_asg_rec.assignment_id)
1460: then
1461: hr_utility.set_location('hrhirapl.make_secondary',401);
1462: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
1463: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
1464:
1465: -- +--------------------------------------------------+
1466: -- +--- End Date assignment type 'A' -----------------+
1459: ,l_asg_rec.assignment_id)
1460: then
1461: hr_utility.set_location('hrhirapl.make_secondary',401);
1462: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
1463: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
1464:
1465: -- +--------------------------------------------------+
1466: -- +--- End Date assignment type 'A' -----------------+
1467: -- +--------------------------------------------------+
1655: ,l_asg_rec.job_post_source_name -- added for 4486233
1656: ,l_asg_rec.supervisor_assignment_id); ---#4053244
1657: exception
1658: when others then
1659: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1660: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1661: ||to_char(l_asg_rec.assignment_id));
1662: hr_utility.set_message_token('STEP','2');
1663: hr_utility.raise_error;
1656: ,l_asg_rec.supervisor_assignment_id); ---#4053244
1657: exception
1658: when others then
1659: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1660: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1661: ||to_char(l_asg_rec.assignment_id));
1662: hr_utility.set_message_token('STEP','2');
1663: hr_utility.raise_error;
1664:
1658: when others then
1659: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1660: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1661: ||to_char(l_asg_rec.assignment_id));
1662: hr_utility.set_message_token('STEP','2');
1663: hr_utility.raise_error;
1664:
1665: end;
1666: -- +----------- END end date of assignment -----------+
1659: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1660: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1661: ||to_char(l_asg_rec.assignment_id));
1662: hr_utility.set_message_token('STEP','2');
1663: hr_utility.raise_error;
1664:
1665: end;
1666: -- +----------- END end date of assignment -----------+
1667: -- +--------------------------------------------------+
1831: ,p_employee_number
1832: ,p_assignment_sequence
1833: ,p_assignment_number);
1834: --
1835: hr_utility.set_location('hrhirapl.make_secondary',402);
1836: begin
1837: update per_assignments_f pa
1838: set pa.assignment_status_type_id = p_assignment_status_type_id
1839: , pa.assignment_type = 'E'
1881: , pa.ass_attribute30 = l_ass_attribute30
1882: where current of csr_ass_cur_for_primary; -- pa.rowid = p_rowid;
1883: exception
1884: when others then
1885: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1886: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1887: ||to_char(l_asg_rec.assignment_id));
1888: hr_utility.set_message_token('STEP','3');
1889: hr_utility.raise_error;
1882: where current of csr_ass_cur_for_primary; -- pa.rowid = p_rowid;
1883: exception
1884: when others then
1885: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1886: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1887: ||to_char(l_asg_rec.assignment_id));
1888: hr_utility.set_message_token('STEP','3');
1889: hr_utility.raise_error;
1890:
1884: when others then
1885: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1886: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1887: ||to_char(l_asg_rec.assignment_id));
1888: hr_utility.set_message_token('STEP','3');
1889: hr_utility.raise_error;
1890:
1891: end;
1892: -- Start of fix 3564129
1885: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1886: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
1887: ||to_char(l_asg_rec.assignment_id));
1888: hr_utility.set_message_token('STEP','3');
1889: hr_utility.raise_error;
1890:
1891: end;
1892: -- Start of fix 3564129
1893: IRC_ASG_STATUS_API.create_irc_asg_status
1898: ,p_object_version_number => l_asg_status_ovn);
1899: -- End of fix 3564129
1900: -- Bug 401669
1901: --
1902: hr_utility.set_location('hrhirapl.make_secondary',4);
1903: --
1904: hr_assignment.load_budget_values(p_assignment_id
1905: ,p_business_group_id
1906: ,p_user_id
1931: -- +--------------------------------------------------+
1932: -- +--- End Date assignment --------------------------+
1933: -- +--------------------------------------------------+
1934: --
1935: hr_utility.set_location('hrhirapl.make_secondary',5);
1936: begin
1937: update per_assignments_f
1938: set effective_end_date = p_start_date -1
1939: where current of csr_ass_cur_for_primary;
1938: set effective_end_date = p_start_date -1
1939: where current of csr_ass_cur_for_primary;
1940: exception
1941: when others then
1942: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1943: to_char(l_asg_rec.assignment_id),66);
1944: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1945: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1946: hr_utility.set_message_token('STEP','4');
1940: exception
1941: when others then
1942: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1943: to_char(l_asg_rec.assignment_id),66);
1944: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1945: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1946: hr_utility.set_message_token('STEP','4');
1947: hr_utility.raise_error;
1948: end;
1941: when others then
1942: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1943: to_char(l_asg_rec.assignment_id),66);
1944: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1945: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1946: hr_utility.set_message_token('STEP','4');
1947: hr_utility.raise_error;
1948: end;
1949: end if; -- convert flag is set.
1942: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1943: to_char(l_asg_rec.assignment_id),66);
1944: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1945: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1946: hr_utility.set_message_token('STEP','4');
1947: hr_utility.raise_error;
1948: end;
1949: end if; -- convert flag is set.
1950: --
1943: to_char(l_asg_rec.assignment_id),66);
1944: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1945: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1946: hr_utility.set_message_token('STEP','4');
1947: hr_utility.raise_error;
1948: end;
1949: end if; -- convert flag is set.
1950: --
1951:
1980:
1981: -- now process all seconday or non primary assignments
1982:
1983:
1984: hr_utility.set_location('hrhirapl.make_secondary',403);
1985: open csr_ass_cur_for_nonprimary;
1986: loop
1987: fetch csr_ass_cur_for_nonprimary into l_asg_rec; --#2119831
1988: exit when csr_ass_cur_for_nonprimary%NOTFOUND;
1994: -- Ensure (R)etain or (E)nd date flags have not been set
1995: if hr_employee_applicant_api.is_convert(p_table
1996: ,l_asg_rec.assignment_id)
1997: then
1998: hr_utility.set_location('hrhirapl.make_secondary',404);
1999: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
2000: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
2001:
2002: -- +--------------------------------------------------+
1995: if hr_employee_applicant_api.is_convert(p_table
1996: ,l_asg_rec.assignment_id)
1997: then
1998: hr_utility.set_location('hrhirapl.make_secondary',404);
1999: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
2000: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
2001:
2002: -- +--------------------------------------------------+
2003: -- +--- End Date assignment type 'A' -----------------+
1996: ,l_asg_rec.assignment_id)
1997: then
1998: hr_utility.set_location('hrhirapl.make_secondary',404);
1999: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
2000: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
2001:
2002: -- +--------------------------------------------------+
2003: -- +--- End Date assignment type 'A' -----------------+
2004: -- +--------------------------------------------------+
2192: ,l_asg_rec.job_post_source_name -- added for 4486233
2193: ,l_asg_rec.supervisor_assignment_id); ---#4053244
2194: exception
2195: when others then
2196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2197: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
2198: ||to_char(l_asg_rec.assignment_id));
2199: hr_utility.set_message_token('STEP','2');
2200: hr_utility.raise_error;
2193: ,l_asg_rec.supervisor_assignment_id); ---#4053244
2194: exception
2195: when others then
2196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2197: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
2198: ||to_char(l_asg_rec.assignment_id));
2199: hr_utility.set_message_token('STEP','2');
2200: hr_utility.raise_error;
2201:
2195: when others then
2196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2197: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
2198: ||to_char(l_asg_rec.assignment_id));
2199: hr_utility.set_message_token('STEP','2');
2200: hr_utility.raise_error;
2201:
2202: end;
2203: -- +----------- END end date of assignment -----------+
2196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2197: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
2198: ||to_char(l_asg_rec.assignment_id));
2199: hr_utility.set_message_token('STEP','2');
2200: hr_utility.raise_error;
2201:
2202: end;
2203: -- +----------- END end date of assignment -----------+
2204: -- +--------------------------------------------------+
2368: ,p_employee_number
2369: ,p_assignment_sequence
2370: ,p_assignment_number);
2371: --
2372: hr_utility.set_location('hrhirapl.make_secondary',405);
2373: begin
2374: update per_assignments_f pa
2375: set pa.assignment_status_type_id = p_assignment_status_type_id
2376: , pa.assignment_type = 'E'
2418: , pa.ass_attribute30 = l_ass_attribute30
2419: where current of csr_ass_cur_for_nonprimary; -- pa.rowid = p_rowid;
2420: exception
2421: when others then
2422: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2423: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
2424: ||to_char(l_asg_rec.assignment_id));
2425: hr_utility.set_message_token('STEP','3');
2426: hr_utility.raise_error;
2419: where current of csr_ass_cur_for_nonprimary; -- pa.rowid = p_rowid;
2420: exception
2421: when others then
2422: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2423: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
2424: ||to_char(l_asg_rec.assignment_id));
2425: hr_utility.set_message_token('STEP','3');
2426: hr_utility.raise_error;
2427:
2421: when others then
2422: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2423: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
2424: ||to_char(l_asg_rec.assignment_id));
2425: hr_utility.set_message_token('STEP','3');
2426: hr_utility.raise_error;
2427:
2428: end;
2429: -- Start of fix 3564129
2422: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2423: hr_utility.set_message_token('PROCEDURE','make_secondary => ASGID: '
2424: ||to_char(l_asg_rec.assignment_id));
2425: hr_utility.set_message_token('STEP','3');
2426: hr_utility.raise_error;
2427:
2428: end;
2429: -- Start of fix 3564129
2430: IRC_ASG_STATUS_API.create_irc_asg_status
2435: ,p_object_version_number => l_asg_status_ovn);
2436: -- End of fix 3564129
2437: -- Bug 401669
2438: --
2439: hr_utility.set_location('hrhirapl.make_secondary',406);
2440: --
2441: hr_assignment.load_budget_values(p_assignment_id
2442: ,p_business_group_id
2443: ,p_user_id
2468: -- +--------------------------------------------------+
2469: -- +--- End Date assignment --------------------------+
2470: -- +--------------------------------------------------+
2471: --
2472: hr_utility.set_location('hrhirapl.make_secondary',407);
2473: begin
2474: update per_assignments_f
2475: set effective_end_date = p_start_date -1
2476: where current of csr_ass_cur_for_nonprimary;
2475: set effective_end_date = p_start_date -1
2476: where current of csr_ass_cur_for_nonprimary;
2477: exception
2478: when others then
2479: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
2480: to_char(l_asg_rec.assignment_id),408);
2481: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2482: hr_utility.set_message_token('PROCEDURE','make_secondary ');
2483: hr_utility.set_message_token('STEP','4');
2477: exception
2478: when others then
2479: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
2480: to_char(l_asg_rec.assignment_id),408);
2481: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2482: hr_utility.set_message_token('PROCEDURE','make_secondary ');
2483: hr_utility.set_message_token('STEP','4');
2484: hr_utility.raise_error;
2485: end;
2478: when others then
2479: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
2480: to_char(l_asg_rec.assignment_id),408);
2481: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2482: hr_utility.set_message_token('PROCEDURE','make_secondary ');
2483: hr_utility.set_message_token('STEP','4');
2484: hr_utility.raise_error;
2485: end;
2486: end if; -- convert flag is set.
2479: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
2480: to_char(l_asg_rec.assignment_id),408);
2481: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2482: hr_utility.set_message_token('PROCEDURE','make_secondary ');
2483: hr_utility.set_message_token('STEP','4');
2484: hr_utility.raise_error;
2485: end;
2486: end if; -- convert flag is set.
2487: --
2480: to_char(l_asg_rec.assignment_id),408);
2481: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2482: hr_utility.set_message_token('PROCEDURE','make_secondary ');
2483: hr_utility.set_message_token('STEP','4');
2484: hr_utility.raise_error;
2485: end;
2486: end if; -- convert flag is set.
2487: --
2488:
2513:
2514: end loop;
2515: --
2516: close csr_ass_cur_for_nonprimary;
2517: hr_utility.set_location('hrhirapl.make_secondary',409);
2518: end if;
2519: hr_utility.set_location('hrhirapl.make_secondary',410);
2520: -- end of bug 5498344
2521: commented for bug 5589928*/
2515: --
2516: close csr_ass_cur_for_nonprimary;
2517: hr_utility.set_location('hrhirapl.make_secondary',409);
2518: end if;
2519: hr_utility.set_location('hrhirapl.make_secondary',410);
2520: -- end of bug 5498344
2521: commented for bug 5589928*/
2522: --
2523: -- add condition: number of updates should be the same as number
2523: -- add condition: number of updates should be the same as number
2524: -- of inserts
2525: /*
2526: if ass_cur%ROWCOUNT > v_count then
2527: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2528: hr_utility.set_message_token('PROCEDURE','make_secondary');
2529: hr_utility.set_message_token('STEP','2');
2530: hr_utility.raise_error;
2531: end if;
2524: -- of inserts
2525: /*
2526: if ass_cur%ROWCOUNT > v_count then
2527: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2528: hr_utility.set_message_token('PROCEDURE','make_secondary');
2529: hr_utility.set_message_token('STEP','2');
2530: hr_utility.raise_error;
2531: end if;
2532: */
2525: /*
2526: if ass_cur%ROWCOUNT > v_count then
2527: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2528: hr_utility.set_message_token('PROCEDURE','make_secondary');
2529: hr_utility.set_message_token('STEP','2');
2530: hr_utility.raise_error;
2531: end if;
2532: */
2533: --
2526: if ass_cur%ROWCOUNT > v_count then
2527: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2528: hr_utility.set_message_token('PROCEDURE','make_secondary');
2529: hr_utility.set_message_token('STEP','2');
2530: hr_utility.raise_error;
2531: end if;
2532: */
2533: --
2534: --
2559: l_asg_start_date date;
2560: l_asg_end_date date;
2561:
2562: begin
2563: hr_utility.set_location('IN Verify future assignments',901);
2564: open fut_asg;
2565: loop
2566: fetch fut_asg into l_rowid, l_future_asg_id,l_asg_start_date, l_asg_end_date
2567: ;
2590: close fut_asg;
2591: --
2592: -- Show any errors raised by previous routines
2593: --
2594: hr_utility.raise_error;
2595: end;
2596: end loop;
2597: close fut_asg;
2598: hr_utility.set_location('OUT Verify future assignments',903);
2594: hr_utility.raise_error;
2595: end;
2596: end loop;
2597: close fut_asg;
2598: hr_utility.set_location('OUT Verify future assignments',903);
2599: end Verify_future_assignments;
2600: --
2601: --
2602: -- +-----------------------------------------------------------------------+
2721: l_asg_start_date date;
2722: l_asg_end_date date;
2723:
2724: begin
2725: hr_utility.set_location('IN Delete future assignments',201);
2726: open fut_asg;
2727: loop
2728: fetch fut_asg into l_rowid, l_future_asg_id,l_asg_start_date, l_asg_end_date
2729: ;
2736:
2737: exception
2738: when others then
2739: close fut_asg;
2740: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2741: hr_utility.set_message_token('PROCEDURE','Delete_future_assignments');
2742: hr_utility.set_message_token('STEP','911');
2743: hr_utility.raise_error;
2744: end;
2737: exception
2738: when others then
2739: close fut_asg;
2740: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2741: hr_utility.set_message_token('PROCEDURE','Delete_future_assignments');
2742: hr_utility.set_message_token('STEP','911');
2743: hr_utility.raise_error;
2744: end;
2745: end loop;
2738: when others then
2739: close fut_asg;
2740: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2741: hr_utility.set_message_token('PROCEDURE','Delete_future_assignments');
2742: hr_utility.set_message_token('STEP','911');
2743: hr_utility.raise_error;
2744: end;
2745: end loop;
2746: close fut_asg;
2739: close fut_asg;
2740: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2741: hr_utility.set_message_token('PROCEDURE','Delete_future_assignments');
2742: hr_utility.set_message_token('STEP','911');
2743: hr_utility.raise_error;
2744: end;
2745: end loop;
2746: close fut_asg;
2747: hr_utility.set_location('OUT Delete future assignments',203);
2743: hr_utility.raise_error;
2744: end;
2745: end loop;
2746: close fut_asg;
2747: hr_utility.set_location('OUT Delete future assignments',203);
2748: end Delete_future_assignments;
2749: --
2750: --
2751: begin
2749: --
2750: --
2751: begin
2752: --
2753: hr_utility.set_location('hrhirapl.create_primary_assignment',1);
2754: --
2755: -- VT 06/14/00
2756: open cur_apl_asg;
2757: fetch cur_apl_asg into apl_asg_rec;
2780: and p_start_date between pa.effective_start_date
2781: and pa.effective_end_date;
2782: --
2783: if SQL%ROWCOUNT <1 then
2784: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2785: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
2786: hr_utility.set_message_token('STEP','1');
2787: hr_utility.raise_error;
2788: end if;
2781: and pa.effective_end_date;
2782: --
2783: if SQL%ROWCOUNT <1 then
2784: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2785: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
2786: hr_utility.set_message_token('STEP','1');
2787: hr_utility.raise_error;
2788: end if;
2789: end;
2782: --
2783: if SQL%ROWCOUNT <1 then
2784: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2785: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
2786: hr_utility.set_message_token('STEP','1');
2787: hr_utility.raise_error;
2788: end if;
2789: end;
2790: end if;
2783: if SQL%ROWCOUNT <1 then
2784: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2785: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
2786: hr_utility.set_message_token('STEP','1');
2787: hr_utility.raise_error;
2788: end if;
2789: end;
2790: end if;
2791: --
2788: end if;
2789: end;
2790: end if;
2791: --
2792: hr_utility.set_location('hrhirapl.create_primary_assignment',2);
2793: --
2794: begin
2795: --
2796: --
2835: and pa.effective_end_date;
2836: --
2837: --
2838: if SQL%ROWCOUNT <1 then
2839: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2840: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
2841: hr_utility.set_message_token('STEP','2');
2842: hr_utility.raise_error;
2843: end if;
2836: --
2837: --
2838: if SQL%ROWCOUNT <1 then
2839: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2840: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
2841: hr_utility.set_message_token('STEP','2');
2842: hr_utility.raise_error;
2843: end if;
2844: --
2837: --
2838: if SQL%ROWCOUNT <1 then
2839: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2840: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
2841: hr_utility.set_message_token('STEP','2');
2842: hr_utility.raise_error;
2843: end if;
2844: --
2845: -- Bug #4462906 Moved the hrutility call
2838: if SQL%ROWCOUNT <1 then
2839: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2840: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
2841: hr_utility.set_message_token('STEP','2');
2842: hr_utility.raise_error;
2843: end if;
2844: --
2845: -- Bug #4462906 Moved the hrutility call
2846: -- after SQL%ROWCOUNT check
2844: --
2845: -- Bug #4462906 Moved the hrutility call
2846: -- after SQL%ROWCOUNT check
2847: --
2848: hr_utility.set_location('hrhirapl.employ_applicant',99);
2849: --
2850: hrentmnt.maintain_entries_asg(p_new_primary_id
2851: ,p_business_group_id
2852: ,'HIRE_APPL' -- ,'ASG_CRITERIA' for bug 5547271
2858: ,p_end_of_time);
2859: end;
2860: else
2861: --
2862: hr_utility.set_location('hrhirapl.create_primary_assignment',3);
2863: --
2864:
2865: declare
2866: --
2934: --
2935: -- VT 06/14/00
2936: if p_update_primary_flag = 'Y' then
2937:
2938: hr_utility.set_location('primary_flag = Y',480);
2939: hr_utility.trace(' p_start_date = '||to_char(p_start_date,'dd-MON-yyyy'));
2940: hr_utility.trace(' p_end_of_time = '||to_char(p_end_of_time,'dd-MON-yyyy'));
2941: hr_utility.trace(' assignment_id = '||to_char(p_assignment_id));
2942: hr_utility.trace(' l_asg_end_date = '||to_char(l_asg_end_date,'dd-MON-yyyy'));
2935: -- VT 06/14/00
2936: if p_update_primary_flag = 'Y' then
2937:
2938: hr_utility.set_location('primary_flag = Y',480);
2939: hr_utility.trace(' p_start_date = '||to_char(p_start_date,'dd-MON-yyyy'));
2940: hr_utility.trace(' p_end_of_time = '||to_char(p_end_of_time,'dd-MON-yyyy'));
2941: hr_utility.trace(' assignment_id = '||to_char(p_assignment_id));
2942: hr_utility.trace(' l_asg_end_date = '||to_char(l_asg_end_date,'dd-MON-yyyy'));
2943: --
2936: if p_update_primary_flag = 'Y' then
2937:
2938: hr_utility.set_location('primary_flag = Y',480);
2939: hr_utility.trace(' p_start_date = '||to_char(p_start_date,'dd-MON-yyyy'));
2940: hr_utility.trace(' p_end_of_time = '||to_char(p_end_of_time,'dd-MON-yyyy'));
2941: hr_utility.trace(' assignment_id = '||to_char(p_assignment_id));
2942: hr_utility.trace(' l_asg_end_date = '||to_char(l_asg_end_date,'dd-MON-yyyy'));
2943: --
2944: -- Start of BEN Call
2937:
2938: hr_utility.set_location('primary_flag = Y',480);
2939: hr_utility.trace(' p_start_date = '||to_char(p_start_date,'dd-MON-yyyy'));
2940: hr_utility.trace(' p_end_of_time = '||to_char(p_end_of_time,'dd-MON-yyyy'));
2941: hr_utility.trace(' assignment_id = '||to_char(p_assignment_id));
2942: hr_utility.trace(' l_asg_end_date = '||to_char(l_asg_end_date,'dd-MON-yyyy'));
2943: --
2944: -- Start of BEN Call
2945: -- Bug 3506363
2938: hr_utility.set_location('primary_flag = Y',480);
2939: hr_utility.trace(' p_start_date = '||to_char(p_start_date,'dd-MON-yyyy'));
2940: hr_utility.trace(' p_end_of_time = '||to_char(p_end_of_time,'dd-MON-yyyy'));
2941: hr_utility.trace(' assignment_id = '||to_char(p_assignment_id));
2942: hr_utility.trace(' l_asg_end_date = '||to_char(l_asg_end_date,'dd-MON-yyyy'));
2943: --
2944: -- Start of BEN Call
2945: -- Bug 3506363
2946: hr_utility.set_location('OAB Call',485);
2942: hr_utility.trace(' l_asg_end_date = '||to_char(l_asg_end_date,'dd-MON-yyyy'));
2943: --
2944: -- Start of BEN Call
2945: -- Bug 3506363
2946: hr_utility.set_location('OAB Call',485);
2947: ben_dt_trgr_handle.assignment
2948: (p_rowid => p_rowid
2949: ,p_assignment_id => p_assignment_id
2950: ,p_business_group_id => p_business_group_id
2999: ,p_ass_attribute28 => apl_asg_rec.ass_attribute28
3000: ,p_ass_attribute29 => apl_asg_rec.ass_attribute29
3001: ,p_ass_attribute30 => apl_asg_rec.ass_attribute30
3002: );
3003: hr_utility.set_location('After OAB Call',490);
3004: -- End of Bug 3506363
3005: -- End of BEN Call
3006: -- 7120387
3007: open appl_rec_det1(apl_asg_rec.application_id);
3007: open appl_rec_det1(apl_asg_rec.application_id);
3008: fetch appl_rec_det1 into l_proj_hire_date;
3009: close appl_rec_det1;
3010:
3011: hr_utility.set_location('l_asg_probation_det.assignment_id :'|| apl_asg_rec.assignment_id,10);
3012: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3013: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3014:
3015: if l_proj_hire_date is null then -- proj hire date
3008: fetch appl_rec_det1 into l_proj_hire_date;
3009: close appl_rec_det1;
3010:
3011: hr_utility.set_location('l_asg_probation_det.assignment_id :'|| apl_asg_rec.assignment_id,10);
3012: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3013: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3014:
3015: if l_proj_hire_date is null then -- proj hire date
3016:
3009: close appl_rec_det1;
3010:
3011: hr_utility.set_location('l_asg_probation_det.assignment_id :'|| apl_asg_rec.assignment_id,10);
3012: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3013: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3014:
3015: if l_proj_hire_date is null then -- proj hire date
3016:
3017: if ( apl_asg_rec.probation_period is not null)
3017: if ( apl_asg_rec.probation_period is not null)
3018: and
3019: (apl_asg_rec.probation_unit is not null ) then
3020:
3021: hr_utility.set_location('p_start_date :'||p_start_date,10);
3022: hr_utility.set_location('l_asg_probation_det.assignment_id :'||apl_asg_rec.assignment_id,10);
3023: hr_utility.set_location('l_asg_probation_det.probation_period :'||apl_asg_rec.probation_period,10);
3024: hr_utility.set_location('l_asg_probation_det.probation_unit :'||apl_asg_rec.probation_unit,10);
3025: l_date_probation_end :=NULL;
3018: and
3019: (apl_asg_rec.probation_unit is not null ) then
3020:
3021: hr_utility.set_location('p_start_date :'||p_start_date,10);
3022: hr_utility.set_location('l_asg_probation_det.assignment_id :'||apl_asg_rec.assignment_id,10);
3023: hr_utility.set_location('l_asg_probation_det.probation_period :'||apl_asg_rec.probation_period,10);
3024: hr_utility.set_location('l_asg_probation_det.probation_unit :'||apl_asg_rec.probation_unit,10);
3025: l_date_probation_end :=NULL;
3026: hr_assignment.gen_probation_end
3019: (apl_asg_rec.probation_unit is not null ) then
3020:
3021: hr_utility.set_location('p_start_date :'||p_start_date,10);
3022: hr_utility.set_location('l_asg_probation_det.assignment_id :'||apl_asg_rec.assignment_id,10);
3023: hr_utility.set_location('l_asg_probation_det.probation_period :'||apl_asg_rec.probation_period,10);
3024: hr_utility.set_location('l_asg_probation_det.probation_unit :'||apl_asg_rec.probation_unit,10);
3025: l_date_probation_end :=NULL;
3026: hr_assignment.gen_probation_end
3027: (p_assignment_id => apl_asg_rec.assignment_id
3020:
3021: hr_utility.set_location('p_start_date :'||p_start_date,10);
3022: hr_utility.set_location('l_asg_probation_det.assignment_id :'||apl_asg_rec.assignment_id,10);
3023: hr_utility.set_location('l_asg_probation_det.probation_period :'||apl_asg_rec.probation_period,10);
3024: hr_utility.set_location('l_asg_probation_det.probation_unit :'||apl_asg_rec.probation_unit,10);
3025: l_date_probation_end :=NULL;
3026: hr_assignment.gen_probation_end
3027: (p_assignment_id => apl_asg_rec.assignment_id
3028: ,p_probation_period => apl_asg_rec.probation_period
3029: ,p_probation_unit => apl_asg_rec.probation_unit
3030: ,p_start_date => p_start_date
3031: ,p_date_probation_end => l_date_probation_end
3032: );
3033: hr_utility.set_location('l_date_probation_end :'||l_date_probation_end,10);
3034: apl_asg_rec.date_probation_end :=l_date_probation_end;
3035:
3036: end if;
3037: end if; --proj hire date
3111: where pa.rowid = p_rowid;
3112: --
3113: -- Added for the bug 6497082 starts here
3114:
3115: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment ',3979);
3116: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||apl_asg_rec.assignment_status_type_id,3989);
3117: per_people3_pkg.get_default_person_type
3118: (p_required_type => 'ACTIVE_ASSIGN'
3119: ,p_business_group_id => p_business_group_id
3112: --
3113: -- Added for the bug 6497082 starts here
3114:
3115: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment ',3979);
3116: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||apl_asg_rec.assignment_status_type_id,3989);
3117: per_people3_pkg.get_default_person_type
3118: (p_required_type => 'ACTIVE_ASSIGN'
3119: ,p_business_group_id => p_business_group_id
3120: ,p_legislation_code => p_legislation_code
3119: ,p_business_group_id => p_business_group_id
3120: ,p_legislation_code => p_legislation_code
3121: ,p_person_type => l_assignment_status_type_id
3122: );
3123: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||l_assignment_status_type_id,3999);
3124:
3125: -- Fix For Bug # 7046591 Starts. Added If Clause ---
3126: if emp_asg_rec.vacancy_id is not null then
3127: IRC_ASG_STATUS_API.create_irc_asg_status
3135:
3136: -- Added for the bug 6497082 Ends here
3137:
3138:
3139: hr_utility.set_location('Updated EMP assignment',11);
3140: -- # 1769702
3141:
3142: -- add the sal admin call here
3143: -- Code for the bug 6512520 starts here
3197: Delete_future_assignments;
3198: --
3199: -- VT 06/14/00
3200: elsif p_update_primary_flag = 'V' then
3201: hr_utility.set_location('Overwrite EMP assignment',15);
3202: -- overwrite some columns from applicant assignment
3203: if apl_asg_rec.organization_id is not null then
3204: emp_asg_rec.organization_id := apl_asg_rec.organization_id;
3205: end if;
3372: if apl_asg_rec.EMPLOYEE_CATEGORY is not null then
3373: emp_asg_rec.EMPLOYEE_CATEGORY := apl_asg_rec.EMPLOYEE_CATEGORY;
3374: end if;
3375: if apl_asg_rec.COLLECTIVE_AGREEMENT_id is not null then
3376: hr_utility.set_location('Updated EMP assignment',90);
3377: emp_asg_rec.COLLECTIVE_AGREEMENT_id := apl_asg_rec.COLLECTIVE_AGREEMENT_id;
3378: end if;
3379: -- fix for the bug 5513751
3380: --
3383: open appl_rec_det1(apl_asg_rec.application_id);
3384: fetch appl_rec_det1 into l_proj_hire_date;
3385: close appl_rec_det1;
3386:
3387: hr_utility.set_location('l_asg_probation_det.assignment_id :'|| apl_asg_rec.assignment_id,10);
3388: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3389: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3390:
3391: if l_proj_hire_date is null then -- proj hire date
3384: fetch appl_rec_det1 into l_proj_hire_date;
3385: close appl_rec_det1;
3386:
3387: hr_utility.set_location('l_asg_probation_det.assignment_id :'|| apl_asg_rec.assignment_id,10);
3388: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3389: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3390:
3391: if l_proj_hire_date is null then -- proj hire date
3392:
3385: close appl_rec_det1;
3386:
3387: hr_utility.set_location('l_asg_probation_det.assignment_id :'|| apl_asg_rec.assignment_id,10);
3388: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3389: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
3390:
3391: if l_proj_hire_date is null then -- proj hire date
3392:
3393: if ( apl_asg_rec.probation_period is not null)
3393: if ( apl_asg_rec.probation_period is not null)
3394: and
3395: (apl_asg_rec.probation_unit is not null ) then
3396:
3397: hr_utility.set_location('p_start_date :'||p_start_date,10);
3398: hr_utility.set_location('l_asg_probation_det.assignment_id :'||apl_asg_rec.assignment_id,10);
3399: hr_utility.set_location('l_asg_probation_det.probation_period :'||apl_asg_rec.probation_period,10);
3400: hr_utility.set_location('l_asg_probation_det.probation_unit :'||apl_asg_rec.probation_unit,10);
3401: l_date_probation_end :=NULL;
3394: and
3395: (apl_asg_rec.probation_unit is not null ) then
3396:
3397: hr_utility.set_location('p_start_date :'||p_start_date,10);
3398: hr_utility.set_location('l_asg_probation_det.assignment_id :'||apl_asg_rec.assignment_id,10);
3399: hr_utility.set_location('l_asg_probation_det.probation_period :'||apl_asg_rec.probation_period,10);
3400: hr_utility.set_location('l_asg_probation_det.probation_unit :'||apl_asg_rec.probation_unit,10);
3401: l_date_probation_end :=NULL;
3402: hr_assignment.gen_probation_end
3395: (apl_asg_rec.probation_unit is not null ) then
3396:
3397: hr_utility.set_location('p_start_date :'||p_start_date,10);
3398: hr_utility.set_location('l_asg_probation_det.assignment_id :'||apl_asg_rec.assignment_id,10);
3399: hr_utility.set_location('l_asg_probation_det.probation_period :'||apl_asg_rec.probation_period,10);
3400: hr_utility.set_location('l_asg_probation_det.probation_unit :'||apl_asg_rec.probation_unit,10);
3401: l_date_probation_end :=NULL;
3402: hr_assignment.gen_probation_end
3403: (p_assignment_id => apl_asg_rec.assignment_id
3396:
3397: hr_utility.set_location('p_start_date :'||p_start_date,10);
3398: hr_utility.set_location('l_asg_probation_det.assignment_id :'||apl_asg_rec.assignment_id,10);
3399: hr_utility.set_location('l_asg_probation_det.probation_period :'||apl_asg_rec.probation_period,10);
3400: hr_utility.set_location('l_asg_probation_det.probation_unit :'||apl_asg_rec.probation_unit,10);
3401: l_date_probation_end :=NULL;
3402: hr_assignment.gen_probation_end
3403: (p_assignment_id => apl_asg_rec.assignment_id
3404: ,p_probation_period => apl_asg_rec.probation_period
3405: ,p_probation_unit => apl_asg_rec.probation_unit
3406: ,p_start_date => p_start_date
3407: ,p_date_probation_end => l_date_probation_end
3408: );
3409: hr_utility.set_location('l_date_probation_end :'||l_date_probation_end,10);
3410: apl_asg_rec.date_probation_end :=l_date_probation_end;
3411: emp_asg_rec.date_probation_end := apl_asg_rec.date_probation_end;
3412: end if;
3413: end if; --proj hire date
3449:
3450:
3451: -- Start of BEN Call
3452: -- Bug 3506363
3453: hr_utility.set_location('Start OAB Call',487);
3454: ben_dt_trgr_handle.assignment
3455: (p_rowid => p_rowid
3456: ,p_assignment_id => p_assignment_id
3457: ,p_business_group_id => p_business_group_id
3506: ,p_ass_attribute28 => emp_asg_rec.ass_attribute28
3507: ,p_ass_attribute29 => emp_asg_rec.ass_attribute29
3508: ,p_ass_attribute30 => emp_asg_rec.ass_attribute30
3509: );
3510: hr_utility.set_location('End of OAB Call',489);
3511: -- End of Bug 3506363
3512: -- End of BEN Call
3513:
3514: --
3511: -- End of Bug 3506363
3512: -- End of BEN Call
3513:
3514: --
3515: hr_utility.set_location('hrhirapl.create_primary_assignment',10);
3516:
3517: --
3518: -- Changed the value for set_of_books_if from p_set_of_books_id to
3519: -- emp_asg_rec.set_of_books_id bug #2398327
3590: where pa.rowid = p_rowid;
3591: --
3592: -- Added for the bug 6497082 starts here
3593:
3594: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment',3981);
3595: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment'||emp_asg_rec.assignment_status_type_id,3991);
3596: per_people3_pkg.get_default_person_type
3597: (p_required_type => 'ACTIVE_ASSIGN'
3598: ,p_business_group_id => p_business_group_id
3591: --
3592: -- Added for the bug 6497082 starts here
3593:
3594: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment',3981);
3595: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment'||emp_asg_rec.assignment_status_type_id,3991);
3596: per_people3_pkg.get_default_person_type
3597: (p_required_type => 'ACTIVE_ASSIGN'
3598: ,p_business_group_id => p_business_group_id
3599: ,p_legislation_code => p_legislation_code
3671: -- Code for the bug 6512520 ends here
3672:
3673: -- All future dated assignments should get ovewritten.
3674: --
3675: hr_utility.set_location('IN Overwrite future dated assignments',14);
3676: open future_ass_cur;
3677: loop
3678: fetch future_ass_cur into l_future_asg_id,p_rowid
3679: ,l_fut_start_date, l_fut_end_date;
3775:
3776: if p_legislation_code = 'US'
3777: and l_prev_location_id <> apl_asg_rec.location_id then
3778:
3779: hr_utility.set_location('Updating tax records..',16);
3780:
3781: -- code added by sneelapa for bug 6409982 starts
3782: p_old_assignment_id := l_future_asg_id;
3783:
3800: ,p_location_id => emp_asg_rec.location_id
3801: ,p_return_code => l_return_code
3802: ,p_return_text => l_return_text
3803: );
3804: hr_utility.set_location('END Updating tax records..',17);
3805: end if;
3806: end if; -- leg=US
3807: -- end 2433154
3808: --
3808: --
3809: end loop; -- updating future dated assignments
3810: close future_ass_cur; -- fix for bug#3057451
3811: -- # 1769702
3812: hr_utility.set_location('OUT Overwrite future dated assignments',18);
3813: else
3814: null;
3815: end if;
3816: -- Start of bug fix 2933750
3894: -- end 2433154
3895: end loop;
3896: --
3897: if ass_cur%ROWCOUNT <1 then
3898: hr_utility.set_location('hrhirapl.create_primary_assignment',33);
3899: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3900: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3901: hr_utility.set_message_token('STEP','3');
3902: hr_utility.raise_error;
3895: end loop;
3896: --
3897: if ass_cur%ROWCOUNT <1 then
3898: hr_utility.set_location('hrhirapl.create_primary_assignment',33);
3899: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3900: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3901: hr_utility.set_message_token('STEP','3');
3902: hr_utility.raise_error;
3903: end if;
3896: --
3897: if ass_cur%ROWCOUNT <1 then
3898: hr_utility.set_location('hrhirapl.create_primary_assignment',33);
3899: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3900: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3901: hr_utility.set_message_token('STEP','3');
3902: hr_utility.raise_error;
3903: end if;
3904: close ass_cur;
3897: if ass_cur%ROWCOUNT <1 then
3898: hr_utility.set_location('hrhirapl.create_primary_assignment',33);
3899: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3900: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3901: hr_utility.set_message_token('STEP','3');
3902: hr_utility.raise_error;
3903: end if;
3904: close ass_cur;
3905: -- +---- End Date chosen APL primary assignment id ------+
3898: hr_utility.set_location('hrhirapl.create_primary_assignment',33);
3899: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3900: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3901: hr_utility.set_message_token('STEP','3');
3902: hr_utility.raise_error;
3903: end if;
3904: close ass_cur;
3905: -- +---- End Date chosen APL primary assignment id ------+
3906: begin
3911: and p_start_date between pa.effective_start_date
3912: and pa.effective_end_date
3913: for update of pa.effective_end_date;
3914: begin
3915: hr_utility.set_location('hrhirapl.create_primary_assignment',22);
3916: hr_utility.trace(' Update APL asg id => '||to_char(p_new_primary_id));
3917: open app_cur;
3918: loop
3919: fetch app_cur into p_rowid;
3912: and pa.effective_end_date
3913: for update of pa.effective_end_date;
3914: begin
3915: hr_utility.set_location('hrhirapl.create_primary_assignment',22);
3916: hr_utility.trace(' Update APL asg id => '||to_char(p_new_primary_id));
3917: open app_cur;
3918: loop
3919: fetch app_cur into p_rowid;
3920: exit when app_cur%notfound;
3917: open app_cur;
3918: loop
3919: fetch app_cur into p_rowid;
3920: exit when app_cur%notfound;
3921: hr_utility.set_location('hrhirapl.create_primary_assignment',23);
3922: update per_assignments_f
3923: set effective_end_date = p_start_date - 1
3924: where rowid = p_rowid;
3925: end loop;
3923: set effective_end_date = p_start_date - 1
3924: where rowid = p_rowid;
3925: end loop;
3926: if app_cur%ROWCOUNT <1 then
3927: hr_utility.set_location('hrhirapl.create_primary_assignment',44);
3928: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3929: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3930: hr_utility.set_message_token('STEP','4');
3931: hr_utility.raise_error;
3924: where rowid = p_rowid;
3925: end loop;
3926: if app_cur%ROWCOUNT <1 then
3927: hr_utility.set_location('hrhirapl.create_primary_assignment',44);
3928: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3929: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3930: hr_utility.set_message_token('STEP','4');
3931: hr_utility.raise_error;
3932: end if;
3925: end loop;
3926: if app_cur%ROWCOUNT <1 then
3927: hr_utility.set_location('hrhirapl.create_primary_assignment',44);
3928: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3929: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3930: hr_utility.set_message_token('STEP','4');
3931: hr_utility.raise_error;
3932: end if;
3933: close app_cur;
3926: if app_cur%ROWCOUNT <1 then
3927: hr_utility.set_location('hrhirapl.create_primary_assignment',44);
3928: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3929: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3930: hr_utility.set_message_token('STEP','4');
3931: hr_utility.raise_error;
3932: end if;
3933: close app_cur;
3934: end;
3927: hr_utility.set_location('hrhirapl.create_primary_assignment',44);
3928: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3929: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3930: hr_utility.set_message_token('STEP','4');
3931: hr_utility.raise_error;
3932: end if;
3933: close app_cur;
3934: end;
3935: end;
3958: --
3959: -- *** MAIN employ_applicant ***
3960: begin
3961: --
3962: -- hr_utility.trace_on;
3963: hr_utility.set_location('hr_person.employ_applicant',1);
3964: --
3965: v_tabrows := table_contents; -- #2264569
3966: hr_utility.trace(' ***** Table ==> '||v_tabrows);
3959: -- *** MAIN employ_applicant ***
3960: begin
3961: --
3962: -- hr_utility.trace_on;
3963: hr_utility.set_location('hr_person.employ_applicant',1);
3964: --
3965: v_tabrows := table_contents; -- #2264569
3966: hr_utility.trace(' ***** Table ==> '||v_tabrows);
3967: --
3962: -- hr_utility.trace_on;
3963: hr_utility.set_location('hr_person.employ_applicant',1);
3964: --
3965: v_tabrows := table_contents; -- #2264569
3966: hr_utility.trace(' ***** Table ==> '||v_tabrows);
3967: --
3968: -- Get new or existing period of service.
3969: --
3970: v_period_of_service_id := get_period_of_service(p_business_group_id
3975: --
3976: if p_emp_apl = 'Y' then
3977: if p_update_primary_flag in ('Y','C','V') then
3978: --
3979: hr_utility.set_location('hr_person.employ_applicant',2);
3980: --
3981: --
3982: -- Date effectively end the current primary assignment
3983: --
3990: ,p_login_id
3991: );
3992: end if;
3993: --
3994: hr_utility.set_location('hr_person.employ_applicant',3);
3995: --
3996: --
3997: -- Make other accepted rows secondary
3998: --
4009: ,p_employee_number
4010: ,p_set_of_books_id
4011: ,p_current_date);
4012: --
4013: hr_utility.set_location('hr_person.employ_applicant',4);
4014: --
4015: --
4016: -- Make a new primary assignment.
4017: --
4030: );
4031: end if;
4032: else -- update_primary_flag = 'N'
4033: --
4034: hr_utility.set_location('hr_person.employ_applicant',5);
4035: --
4036: --
4037: -- Create the accepted assignments as secondary assignments
4038: --
4052: end if;
4053:
4054: else -- employing an applicant; update_primary_flag = 'N'
4055: --
4056: hr_utility.set_location('hr_person.employ_applicant',6);
4057: --
4058: --
4059: -- Create the accepted as secondary but make the chosen a primary.
4060: --
4072: ,p_set_of_books_id
4073: ,p_current_date);
4074: --
4075: --
4076: hr_utility.set_location('hr_person.employ_applicant',7);
4077: --
4078: create_primary_assignment(p_business_group_id
4079: ,p_person_id
4080: ,p_new_primary_id
4104: --
4105:
4106: end if;
4107: --
4108: -- hr_utility.trace_off;
4109: --
4110: --start WWBUG 2130950 hrwf synchronization --tpapired
4111: --
4112: declare
4166: open appl_rec_det(l_asg_probation_det.application_id) ;
4167: fetch appl_rec_det into l_proj_hire_date;
4168: close appl_rec_det;
4169:
4170: hr_utility.set_location('l_asg_probation_det.assignment_id :'||l_asg_probation_det.assignment_id,7);
4171: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
4172: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
4173:
4174: if l_proj_hire_date is null then
4167: fetch appl_rec_det into l_proj_hire_date;
4168: close appl_rec_det;
4169:
4170: hr_utility.set_location('l_asg_probation_det.assignment_id :'||l_asg_probation_det.assignment_id,7);
4171: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
4172: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
4173:
4174: if l_proj_hire_date is null then
4175:
4168: close appl_rec_det;
4169:
4170: hr_utility.set_location('l_asg_probation_det.assignment_id :'||l_asg_probation_det.assignment_id,7);
4171: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
4172: hr_utility.set_location('l_proj_hire_date :'||l_proj_hire_date,10);
4173:
4174: if l_proj_hire_date is null then
4175:
4176: if ( l_asg_probation_det.probation_period is not null)
4177: and
4178: (l_asg_probation_det.probation_unit is not null ) then
4179:
4180:
4181: hr_utility.set_location('p_start_date :'||p_start_date,10);
4182: hr_utility.set_location('l_asg_probation_det.assignment_id :'||l_asg_probation_det.assignment_id,10);
4183: hr_utility.set_location('l_asg_probation_det.probation_period :'||l_asg_probation_det.probation_period,10);
4184: hr_utility.set_location('l_asg_probation_det.probation_unit :'||l_asg_probation_det.probation_unit,10);
4185: l_date_probation_end :=NULL;
4178: (l_asg_probation_det.probation_unit is not null ) then
4179:
4180:
4181: hr_utility.set_location('p_start_date :'||p_start_date,10);
4182: hr_utility.set_location('l_asg_probation_det.assignment_id :'||l_asg_probation_det.assignment_id,10);
4183: hr_utility.set_location('l_asg_probation_det.probation_period :'||l_asg_probation_det.probation_period,10);
4184: hr_utility.set_location('l_asg_probation_det.probation_unit :'||l_asg_probation_det.probation_unit,10);
4185: l_date_probation_end :=NULL;
4186: hr_assignment.gen_probation_end
4179:
4180:
4181: hr_utility.set_location('p_start_date :'||p_start_date,10);
4182: hr_utility.set_location('l_asg_probation_det.assignment_id :'||l_asg_probation_det.assignment_id,10);
4183: hr_utility.set_location('l_asg_probation_det.probation_period :'||l_asg_probation_det.probation_period,10);
4184: hr_utility.set_location('l_asg_probation_det.probation_unit :'||l_asg_probation_det.probation_unit,10);
4185: l_date_probation_end :=NULL;
4186: hr_assignment.gen_probation_end
4187: (p_assignment_id => l_asg_probation_det.assignment_id
4180:
4181: hr_utility.set_location('p_start_date :'||p_start_date,10);
4182: hr_utility.set_location('l_asg_probation_det.assignment_id :'||l_asg_probation_det.assignment_id,10);
4183: hr_utility.set_location('l_asg_probation_det.probation_period :'||l_asg_probation_det.probation_period,10);
4184: hr_utility.set_location('l_asg_probation_det.probation_unit :'||l_asg_probation_det.probation_unit,10);
4185: l_date_probation_end :=NULL;
4186: hr_assignment.gen_probation_end
4187: (p_assignment_id => l_asg_probation_det.assignment_id
4188: ,p_probation_period => l_asg_probation_det.probation_period
4189: ,p_probation_unit => l_asg_probation_det.probation_unit
4190: ,p_start_date => p_start_date
4191: ,p_date_probation_end => l_date_probation_end
4192: );
4193: hr_utility.set_location('l_date_probation_end :'||l_date_probation_end,10);
4194:
4195:
4196: update per_all_assignments_f
4197: set date_probation_end =l_date_probation_end
4218: -- end of date probation end
4219: -- fix 7120387
4220: -- Re-evaluate security access for the person.
4221: --
4222: hr_utility.set_location('hr_person.employ_applicant',8);
4223: --
4224: -- Bug 2534026
4225: -- Hard-code p_emp and p_apl as 'Y'. This will cause both employee and
4226: -- applicant assignments to beincluded when security access is re-evaluated
4289: from per_periods_of_service pps
4290: where pps.person_id =p_person_id;
4291:
4292: begin
4293: hr_utility.set_location('Entering : hr_person.ins_per_list',5);
4294: open check_past_pds;
4295: fetch check_past_pds into l_dummy;
4296: if check_past_pds%FOUND then
4297: close check_past_pds;
4294: open check_past_pds;
4295: fetch check_past_pds into l_dummy;
4296: if check_past_pds%FOUND then
4297: close check_past_pds;
4298: hr_utility.set_location('hr_person.ins_per_list',10);
4299: hr_security_internal.clear_from_person_list(p_person_id);
4300: else
4301: close check_past_pds;
4302: open check_pds;
4302: open check_pds;
4303: fetch check_pds into l_dummy;
4304: if check_pds%notfound then
4305: close check_pds;
4306: hr_utility.set_location('hr_person.ins_per_list',15);
4307: hr_security_internal.clear_from_person_list(p_person_id);
4308: else
4309: close check_pds;
4310: end if;
4309: close check_pds;
4310: end if;
4311: end if;
4312: --
4313: hr_utility.set_location('hr_person.ins_per_list',20);
4314: --
4315: for asg_rec in ass_cur loop
4316: hr_security_internal.add_to_person_list
4317: (p_assignment_id => asg_rec.assignment_id
4317: (p_assignment_id => asg_rec.assignment_id
4318: ,p_effective_date => asg_rec.effective_start_date);
4319: end loop;
4320: --
4321: hr_utility.set_location('Leaving : hr_person.ins_per_list',30);
4322: --
4323: end ins_per_list;
4324: -- +------------------END: ins_per_list ----------------------------------+
4325: --
4389: l_end_date := p_end_date -1;
4390: --
4391: -- #2264569
4392: --
4393: hr_utility.set_location('IN hrhirapl.end_unaccepted_app_assign',303);
4394: open unacc_cur;
4395: loop
4396: fetch unacc_cur into l_asgid;
4397: exit when unacc_cur%NOTFOUND;
4396: fetch unacc_cur into l_asgid;
4397: exit when unacc_cur%NOTFOUND;
4398: begin
4399: if hr_employee_applicant_api.end_date_exists(p_table,l_asgid) <> 2 then
4400: hr_utility.set_location('hrhirapl.end_unaccepted_app_assign',305);
4401: hr_utility.trace(' **** Asg ID : '||to_char(l_asgid));
4402:
4403: update per_assignments pa
4404: set pa.effective_end_date = l_end_date
4397: exit when unacc_cur%NOTFOUND;
4398: begin
4399: if hr_employee_applicant_api.end_date_exists(p_table,l_asgid) <> 2 then
4400: hr_utility.set_location('hrhirapl.end_unaccepted_app_assign',305);
4401: hr_utility.trace(' **** Asg ID : '||to_char(l_asgid));
4402:
4403: update per_assignments pa
4404: set pa.effective_end_date = l_end_date
4405: where current of unacc_cur;
4431: end if;
4432: exception
4433: when others then
4434: close unacc_cur;
4435: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4436: hr_utility.set_message_token('PROCEDURE','end_unaccepted_app_assign');
4437: hr_utility.set_message_token('STEP','1');
4438: hr_utility.raise_error;
4439: end;
4432: exception
4433: when others then
4434: close unacc_cur;
4435: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4436: hr_utility.set_message_token('PROCEDURE','end_unaccepted_app_assign');
4437: hr_utility.set_message_token('STEP','1');
4438: hr_utility.raise_error;
4439: end;
4440: end loop;
4433: when others then
4434: close unacc_cur;
4435: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4436: hr_utility.set_message_token('PROCEDURE','end_unaccepted_app_assign');
4437: hr_utility.set_message_token('STEP','1');
4438: hr_utility.raise_error;
4439: end;
4440: end loop;
4441: close unacc_cur;
4434: close unacc_cur;
4435: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4436: hr_utility.set_message_token('PROCEDURE','end_unaccepted_app_assign');
4437: hr_utility.set_message_token('STEP','1');
4438: hr_utility.raise_error;
4439: end;
4440: end loop;
4441: close unacc_cur;
4442: hr_utility.set_location('OUT hrhirapl.end_unaccepted_app_assign',310);
4438: hr_utility.raise_error;
4439: end;
4440: end loop;
4441: close unacc_cur;
4442: hr_utility.set_location('OUT hrhirapl.end_unaccepted_app_assign',310);
4443:
4444: end end_unaccepted_app_assign;
4445: --
4446: -- +----------------------END: end_unaccepted_app_assign -------------+
4518: where event_id = l_event_id;
4519: l_final_no := l_final_no - sql%rowcount;
4520: end loop;
4521: if l_final_no <> 0 then
4522: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4523: hr_utility.set_message_token('PROCEDURE','end_bookings');
4524: hr_utility.set_message_token('STEP','10');
4525: hr_utility.raise_error;
4526: end if;
4519: l_final_no := l_final_no - sql%rowcount;
4520: end loop;
4521: if l_final_no <> 0 then
4522: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4523: hr_utility.set_message_token('PROCEDURE','end_bookings');
4524: hr_utility.set_message_token('STEP','10');
4525: hr_utility.raise_error;
4526: end if;
4527: --
4520: end loop;
4521: if l_final_no <> 0 then
4522: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4523: hr_utility.set_message_token('PROCEDURE','end_bookings');
4524: hr_utility.set_message_token('STEP','10');
4525: hr_utility.raise_error;
4526: end if;
4527: --
4528: end end_bookings;
4521: if l_final_no <> 0 then
4522: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4523: hr_utility.set_message_token('PROCEDURE','end_bookings');
4524: hr_utility.set_message_token('STEP','10');
4525: hr_utility.raise_error;
4526: end if;
4527: --
4528: end end_bookings;
4529: ----------------------------END: end_bookings --------------------