[Home] [Help]
1: Package Body BEN_CWB_WS_IMPORT_PKG as
2: /* $Header: bencwbwsim.pkb 120.13.12010000.2 2008/08/05 14:38:11 ubhat ship $ */
3:
4: g_package Varchar2(30) := 'BEN_CWB_WS_IMPORT_PKG.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: /*
8: This procedure is used by worksheet when rank is updated to
9: prevent any duplicates getting created.
40: ,p_aei_information4 => p_level_number
41: ,p_assignment_extra_info_id => p_assignment_extra_info_id
42: ,p_object_version_number => p_object_version_number);
43: else
44: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
45: hr_utility.raise_error;
46: end if;
47:
48: end insert_new_rank;
41: ,p_assignment_extra_info_id => p_assignment_extra_info_id
42: ,p_object_version_number => p_object_version_number);
43: else
44: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
45: hr_utility.raise_error;
46: end if;
47:
48: end insert_new_rank;
49: --
87:
88: BEGIN
89:
90: if g_debug then
91: hr_utility.set_location('Entering '||l_proc,10);
92: hr_utility.set_location('P_GROUP_PER_IN_LER_ID '||P_GROUP_PER_IN_LER_ID,20);
93: hr_utility.set_location('P_RANK '||P_RANK,30);
94: hr_utility.set_location('P_USER_ID '||P_USER_ID,35);
95: end if;
88: BEGIN
89:
90: if g_debug then
91: hr_utility.set_location('Entering '||l_proc,10);
92: hr_utility.set_location('P_GROUP_PER_IN_LER_ID '||P_GROUP_PER_IN_LER_ID,20);
93: hr_utility.set_location('P_RANK '||P_RANK,30);
94: hr_utility.set_location('P_USER_ID '||P_USER_ID,35);
95: end if;
96:
89:
90: if g_debug then
91: hr_utility.set_location('Entering '||l_proc,10);
92: hr_utility.set_location('P_GROUP_PER_IN_LER_ID '||P_GROUP_PER_IN_LER_ID,20);
93: hr_utility.set_location('P_RANK '||P_RANK,30);
94: hr_utility.set_location('P_USER_ID '||P_USER_ID,35);
95: end if;
96:
97: Open Csr_Assignment_ID;
90: if g_debug then
91: hr_utility.set_location('Entering '||l_proc,10);
92: hr_utility.set_location('P_GROUP_PER_IN_LER_ID '||P_GROUP_PER_IN_LER_ID,20);
93: hr_utility.set_location('P_RANK '||P_RANK,30);
94: hr_utility.set_location('P_USER_ID '||P_USER_ID,35);
95: end if;
96:
97: Open Csr_Assignment_ID;
98: Fetch Csr_Assignment_ID into l_assignment_Id, l_lvl_num;
98: Fetch Csr_Assignment_ID into l_assignment_Id, l_lvl_num;
99: Close Csr_Assignment_ID;
100:
101: if g_debug then
102: hr_utility.set_location('l_assignment_Id '||l_assignment_Id,70);
103: end if;
104:
105:
106: IF (l_assignment_Id IS NOT NULL) THEN
130:
131: END IF;
132:
133: if g_debug then
134: hr_utility.set_location('Leaving '||l_proc,100);
135: end if;
136:
137: END UPDATE_RANK;
138:
185: l_ws_rt_start_date DATE;
186: BEGIN
187:
188: if g_debug then
189: hr_utility.set_location('Entering '||l_proc,10);
190: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
191: hr_utility.set_location('P_WS_VAL '||l_WS_VAL,30);
192: hr_utility.set_location('P_USER_ID '||P_USER_ID,36);
193: end if;
186: BEGIN
187:
188: if g_debug then
189: hr_utility.set_location('Entering '||l_proc,10);
190: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
191: hr_utility.set_location('P_WS_VAL '||l_WS_VAL,30);
192: hr_utility.set_location('P_USER_ID '||P_USER_ID,36);
193: end if;
194:
187:
188: if g_debug then
189: hr_utility.set_location('Entering '||l_proc,10);
190: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
191: hr_utility.set_location('P_WS_VAL '||l_WS_VAL,30);
192: hr_utility.set_location('P_USER_ID '||P_USER_ID,36);
193: end if;
194:
195: IF (P_USER_ID IS NOT NULL) THEN
188: if g_debug then
189: hr_utility.set_location('Entering '||l_proc,10);
190: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
191: hr_utility.set_location('P_WS_VAL '||l_WS_VAL,30);
192: hr_utility.set_location('P_USER_ID '||P_USER_ID,36);
193: end if;
194:
195: IF (P_USER_ID IS NOT NULL) THEN
196: l_USER_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_USER_ID);
193: end if;
194:
195: IF (P_USER_ID IS NOT NULL) THEN
196: l_USER_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_USER_ID);
197: hr_utility.set_location('l_USER_ID :'||l_USER_ID,45);
198: END IF;
199:
200: Open Csr_Person_Id(l_USER_ID);
201: Fetch Csr_Person_Id into l_person_id;
234: End if;
235: Close Csr_PlRt_Dtls;
236:
237: if g_debug then
238: hr_utility.set_location('Leaving '||l_proc,100);
239: end if;
240:
241: return l_diff;
242:
278: l_ovn Number;
279: l_lf_evt_ocrd_dt Date;
280: BEGIN
281:
282: hr_utility.set_location('Entering :'||l_proc,10);
283:
284: If P_PERSON_RATE_ID IS NOT NULL then
285: l_rate_id := P_PERSON_RATE_ID;
286: Elsif P_OPT1_PERSON_RATE_ID IS NOT NULL then
292: Elsif P_OPT4_PERSON_RATE_ID IS NOT NULL then
293: l_rate_id := P_OPT4_PERSON_RATE_ID;
294: End if;
295:
296: hr_utility.set_location('l_rate_id :'||l_rate_id,20);
297:
298: Open csr_person_rate_info(l_rate_id);
299: Fetch csr_person_rate_info into l_group_pl_id,l_lf_evt_ocrd_dt;
300: Close csr_person_rate_info;
298: Open csr_person_rate_info(l_rate_id);
299: Fetch csr_person_rate_info into l_group_pl_id,l_lf_evt_ocrd_dt;
300: Close csr_person_rate_info;
301:
302: hr_utility.set_location('l_group_pl_id :'||l_group_pl_id,50);
303: hr_utility.set_location('l_lf_evt_ocrd_dt :'||l_lf_evt_ocrd_dt,60);
304:
305:
306: Open csr_person_tasks_info(l_group_pl_id,l_lf_evt_ocrd_dt );
299: Fetch csr_person_rate_info into l_group_pl_id,l_lf_evt_ocrd_dt;
300: Close csr_person_rate_info;
301:
302: hr_utility.set_location('l_group_pl_id :'||l_group_pl_id,50);
303: hr_utility.set_location('l_lf_evt_ocrd_dt :'||l_lf_evt_ocrd_dt,60);
304:
305:
306: Open csr_person_tasks_info(l_group_pl_id,l_lf_evt_ocrd_dt );
307: Fetch csr_person_tasks_info into l_status_cd,l_ovn;
306: Open csr_person_tasks_info(l_group_pl_id,l_lf_evt_ocrd_dt );
307: Fetch csr_person_tasks_info into l_status_cd,l_ovn;
308: Close csr_person_tasks_info;
309:
310: hr_utility.set_location('l_status_cd :'||l_status_cd,70);
311: hr_utility.set_location('l_ovn :'||l_ovn,80);
312:
313: If l_status_cd = 'NS' then
314: BEN_CWB_PERSON_TASKS_API.update_person_task
307: Fetch csr_person_tasks_info into l_status_cd,l_ovn;
308: Close csr_person_tasks_info;
309:
310: hr_utility.set_location('l_status_cd :'||l_status_cd,70);
311: hr_utility.set_location('l_ovn :'||l_ovn,80);
312:
313: If l_status_cd = 'NS' then
314: BEN_CWB_PERSON_TASKS_API.update_person_task
315: ( p_group_per_in_ler_id => P_SEC_MGR_LER_ID
321: ,p_object_version_number => l_ovn
322: );
323: End If;
324:
325: hr_utility.set_location('Leaving :'||l_proc,100);
326:
327: END REFRESH_PERSON_TASKS;
328:
329: --
349:
350:
351: BEGIN
352:
353: hr_utility.set_location('Entering :'||l_proc,10);
354:
355: If P_PERSON_RATE_ID IS NOT NULL then
356: l_rate_id := P_PERSON_RATE_ID;
357: Elsif P_OPT1_PERSON_RATE_ID IS NOT NULL then
363: Elsif P_OPT4_PERSON_RATE_ID IS NOT NULL then
364: l_rate_id := P_OPT4_PERSON_RATE_ID;
365: End if;
366:
367: hr_utility.set_location('l_rate_id :'||l_rate_id,20);
368:
369: Open csr_group_per_in_ler_id(l_rate_id);
370: Fetch csr_group_per_in_ler_id into l_group_per_in_ler_id;
371: Close csr_group_per_in_ler_id;
369: Open csr_group_per_in_ler_id(l_rate_id);
370: Fetch csr_group_per_in_ler_id into l_group_per_in_ler_id;
371: Close csr_group_per_in_ler_id;
372:
373: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
374: hr_utility.set_location('Leaving :'||l_proc,100);
375:
376: return l_group_per_in_ler_id;
377:
370: Fetch csr_group_per_in_ler_id into l_group_per_in_ler_id;
371: Close csr_group_per_in_ler_id;
372:
373: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
374: hr_utility.set_location('Leaving :'||l_proc,100);
375:
376: return l_group_per_in_ler_id;
377:
378: End get_group_per_in_ler_id;
407: and hrchy.lvl_num = 1;
408: l_submit_cd ben_cwb_person_groups.submit_cd%TYPE;
409:
410: BEGIN
411: hr_utility.set_location('Entering :'||l_proc,10);
412:
413: l_group_per_in_ler_id := get_group_per_in_ler_id (P_PERSON_RATE_ID =>P_PERSON_RATE_ID
414: ,P_OPT1_PERSON_RATE_ID => P_OPT1_PERSON_RATE_ID
415: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID
415: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID
416: ,P_OPT3_PERSON_RATE_ID => P_OPT3_PERSON_RATE_ID
417: ,P_OPT4_PERSON_RATE_ID => P_OPT4_PERSON_RATE_ID);
418:
419: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
420:
421: Open csr_PP_STAT_CD(l_group_per_in_ler_id);
422: Fetch csr_PP_STAT_CD into l_pp_stat_cd;
423: Close csr_PP_STAT_CD;
421: Open csr_PP_STAT_CD(l_group_per_in_ler_id);
422: Fetch csr_PP_STAT_CD into l_pp_stat_cd;
423: Close csr_PP_STAT_CD;
424:
425: hr_utility.set_location('l_pp_stat_cd :'||l_pp_stat_cd,50);
426:
427: if l_pp_stat_cd IS NOT NULL then
428: hr_utility.set_message(805,'BEN_93752_CWB_PROCESSES_EMP');
429: hr_utility.raise_error;
424:
425: hr_utility.set_location('l_pp_stat_cd :'||l_pp_stat_cd,50);
426:
427: if l_pp_stat_cd IS NOT NULL then
428: hr_utility.set_message(805,'BEN_93752_CWB_PROCESSES_EMP');
429: hr_utility.raise_error;
430: End if;
431:
432: -- added by kmg for fixing bug#6830922
425: hr_utility.set_location('l_pp_stat_cd :'||l_pp_stat_cd,50);
426:
427: if l_pp_stat_cd IS NOT NULL then
428: hr_utility.set_message(805,'BEN_93752_CWB_PROCESSES_EMP');
429: hr_utility.raise_error;
430: End if;
431:
432: -- added by kmg for fixing bug#6830922
433: OPEN csr_ws_stat_cd(l_group_per_in_ler_id);
433: OPEN csr_ws_stat_cd(l_group_per_in_ler_id);
434: FETCH csr_ws_stat_cd INTO l_submit_cd;
435: CLOSE csr_ws_stat_cd;
436: IF NVL(l_submit_cd,'NS') = 'SU' THEN
437: hr_utility.set_message(805,'BEN_94711_CWB_WS_SUBMITTED');
438: hr_utility.raise_error;
439: END IF;
440:
441: hr_utility.set_location('Leaving :'||l_proc,200);
434: FETCH csr_ws_stat_cd INTO l_submit_cd;
435: CLOSE csr_ws_stat_cd;
436: IF NVL(l_submit_cd,'NS') = 'SU' THEN
437: hr_utility.set_message(805,'BEN_94711_CWB_WS_SUBMITTED');
438: hr_utility.raise_error;
439: END IF;
440:
441: hr_utility.set_location('Leaving :'||l_proc,200);
442: END chk_processed_emp;
437: hr_utility.set_message(805,'BEN_94711_CWB_WS_SUBMITTED');
438: hr_utility.raise_error;
439: END IF;
440:
441: hr_utility.set_location('Leaving :'||l_proc,200);
442: END chk_processed_emp;
443:
444:
445:
486: l_person_info Csr_person_info%RowType;
487: l_pl_dsgn_info Csr_pl_dsgn_info%RowType;
488:
489: Begin
490: hr_utility.set_location('Entering :'||l_proc,10);
491: --If P_PROPOSED_PERFORMANCE_RATING IS NOT NULL Then
492: l_group_per_in_ler_id := get_group_per_in_ler_id (P_PERSON_RATE_ID =>P_PERSON_RATE_ID
493: ,P_OPT1_PERSON_RATE_ID => P_OPT1_PERSON_RATE_ID
494: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID
494: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID
495: ,P_OPT3_PERSON_RATE_ID => P_OPT3_PERSON_RATE_ID
496: ,P_OPT4_PERSON_RATE_ID => P_OPT4_PERSON_RATE_ID);
497:
498: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
499:
500:
501: Open csr_person_info(l_group_per_in_ler_id);
502: Fetch csr_person_info into l_person_info;
501: Open csr_person_info(l_group_per_in_ler_id);
502: Fetch csr_person_info into l_person_info;
503: Close csr_person_info;
504:
505: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
506: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
507: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
508: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
509:
502: Fetch csr_person_info into l_person_info;
503: Close csr_person_info;
504:
505: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
506: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
507: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
508: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
509:
510: Open Csr_pl_dsgn_info(l_group_per_in_ler_id);
503: Close csr_person_info;
504:
505: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
506: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
507: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
508: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
509:
510: Open Csr_pl_dsgn_info(l_group_per_in_ler_id);
511: Fetch Csr_pl_dsgn_info into l_pl_dsgn_info;
504:
505: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
506: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
507: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
508: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
509:
510: Open Csr_pl_dsgn_info(l_group_per_in_ler_id);
511: Fetch Csr_pl_dsgn_info into l_pl_dsgn_info;
512: Close Csr_pl_dsgn_info;
511: Fetch Csr_pl_dsgn_info into l_pl_dsgn_info;
512: Close Csr_pl_dsgn_info;
513:
514:
515: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);
516: hr_utility.set_location('l_pl_dsgn_info.perf_revw_strt_dt :'||l_pl_dsgn_info.perf_revw_strt_dt,130);
517:
518: ben_cwb_asg_update.process_rating
519: (p_validate_data => 'Y'
512: Close Csr_pl_dsgn_info;
513:
514:
515: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);
516: hr_utility.set_location('l_pl_dsgn_info.perf_revw_strt_dt :'||l_pl_dsgn_info.perf_revw_strt_dt,130);
517:
518: ben_cwb_asg_update.process_rating
519: (p_validate_data => 'Y'
520: ,p_assignment_id => l_person_info.Assignment_id
531:
532:
533:
534: --End If;
535: hr_utility.set_location('Leaving :'||l_proc,100);
536: End update_perf_rating;
537:
538: --
539: --------------------------- REFRESH_SUMMARY_GROUP_PL -----------------------------
972:
973: BEGIN
974:
975: If g_debug then
976: hr_utility.set_location('Entering '||l_proc,10);
977: End if;
978:
979: --Clear message
980: hr_utility.clear_message;
976: hr_utility.set_location('Entering '||l_proc,10);
977: End if;
978:
979: --Clear message
980: hr_utility.clear_message;
981:
982: -- Issue Savepoint
983: savepoint update_data;
984: --
992: AND P_P_OPT2_PERSON_RATE_ID IS NULL
993: AND P_P_OPT3_PERSON_RATE_ID IS NULL
994: AND P_P_OPT4_PERSON_RATE_ID IS NULL) THEN
995:
996: hr_utility.set_message(805,'BEN_CWB_PL_OPT_NOT_EXISTS');
997: hr_utility.raise_error;
998: END IF;
999:
1000: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN
993: AND P_P_OPT3_PERSON_RATE_ID IS NULL
994: AND P_P_OPT4_PERSON_RATE_ID IS NULL) THEN
995:
996: hr_utility.set_message(805,'BEN_CWB_PL_OPT_NOT_EXISTS');
997: hr_utility.raise_error;
998: END IF;
999:
1000: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN
1001: l_PL_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_PL_PERSON_RATE_ID);
999:
1000: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN
1001: l_PL_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_PL_PERSON_RATE_ID);
1002: If g_debug then
1003: hr_utility.set_location('l_PL_PERSON_RATE_ID :'||l_PL_PERSON_RATE_ID,20);
1004: End if;
1005: END IF;
1006:
1007: IF (P_P_OPT1_PERSON_RATE_ID IS NOT NULL) THEN
1006:
1007: IF (P_P_OPT1_PERSON_RATE_ID IS NOT NULL) THEN
1008: l_OPT1_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT1_PERSON_RATE_ID);
1009: If g_debug then
1010: hr_utility.set_location('l_OPT1_PERSON_RATE_ID :'||l_OPT1_PERSON_RATE_ID,30);
1011: End if;
1012: END IF;
1013:
1014: IF (P_P_OPT2_PERSON_RATE_ID IS NOT NULL) THEN
1013:
1014: IF (P_P_OPT2_PERSON_RATE_ID IS NOT NULL) THEN
1015: l_OPT2_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT2_PERSON_RATE_ID);
1016: If g_debug then
1017: hr_utility.set_location('l_OPT2_PERSON_RATE_ID :'||l_OPT2_PERSON_RATE_ID,40);
1018: End if;
1019: END IF;
1020:
1021: IF (P_P_OPT3_PERSON_RATE_ID IS NOT NULL) THEN
1020:
1021: IF (P_P_OPT3_PERSON_RATE_ID IS NOT NULL) THEN
1022: l_OPT3_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT3_PERSON_RATE_ID);
1023: If g_debug then
1024: hr_utility.set_location('l_OPT3_PERSON_RATE_ID :'||l_OPT3_PERSON_RATE_ID,50);
1025: End if;
1026: END IF;
1027:
1028: IF (P_P_OPT4_PERSON_RATE_ID IS NOT NULL) THEN
1027:
1028: IF (P_P_OPT4_PERSON_RATE_ID IS NOT NULL) THEN
1029: l_OPT4_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT4_PERSON_RATE_ID);
1030: If g_debug then
1031: hr_utility.set_location('l_OPT4_PERSON_RATE_ID :'||l_OPT4_PERSON_RATE_ID,60);
1032: End if;
1033: END IF;
1034:
1035: IF (P_TASK_ID IS NOT NULL) THEN
1034:
1035: IF (P_TASK_ID IS NOT NULL) THEN
1036: l_TASK_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_TASK_ID);
1037: If g_debug then
1038: hr_utility.set_location('l_TASK_ID :'||l_TASK_ID,65);
1039: End if;
1040: END IF;
1041:
1042: IF (P_SEC_MGR_LER_ID IS NOT NULL) THEN
1041:
1042: IF (P_SEC_MGR_LER_ID IS NOT NULL) THEN
1043: l_SEC_MGR_LER_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_SEC_MGR_LER_ID);
1044: If g_debug then
1045: hr_utility.set_location('l_SEC_MGR_LER_ID :'||l_SEC_MGR_LER_ID,67);
1046: End if;
1047: END IF;
1048:
1049: IF (P_ACTING_PERSON_ID IS NOT NULL) THEN
1048:
1049: IF (P_ACTING_PERSON_ID IS NOT NULL) THEN
1050: l_ACTING_PERSON_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_ACTING_PERSON_ID);
1051: If g_debug then
1052: hr_utility.set_location('P_ACTING_PERSON_ID :'||l_ACTING_PERSON_ID,68);
1053: End if;
1054: END IF;
1055:
1056: -- Using hexadecimal to store the upload column availability information.
1059: l_decrypt_switch := BEN_CWB_WEBADI_UTILS.decrypt(p_download_switch);
1060: l_download_switch := lpad(ben_cwb_webadi_utils.int2bin(ben_cwb_webadi_utils.hex2int(substr(l_decrypt_switch,1,7))),28,0);
1061: l_download_switch := nvl(l_download_switch || lpad(nvl(ben_cwb_webadi_utils.int2bin(ben_cwb_webadi_utils.hex2int(substr(rtrim(l_decrypt_switch),8,14))),'0'),28,0),'0');
1062: if g_debug then
1063: hr_utility.set_location('p_download_switch (Decrypted) :'||l_decrypt_switch,69);
1064: End if;
1065: l_download_switch := REPLACE(REPLACE(l_download_switch,'1','2'),'0','1');
1066: if g_debug then
1067: hr_utility.set_location('l_final_download_Switch :'||l_download_switch,70);
1063: hr_utility.set_location('p_download_switch (Decrypted) :'||l_decrypt_switch,69);
1064: End if;
1065: l_download_switch := REPLACE(REPLACE(l_download_switch,'1','2'),'0','1');
1066: if g_debug then
1067: hr_utility.set_location('l_final_download_Switch :'||l_download_switch,70);
1068: End if;
1069: END IF;
1070:
1071: If g_debug then
1068: End if;
1069: END IF;
1070:
1071: If g_debug then
1072: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1073: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1074: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1075: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1076: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);
1069: END IF;
1070:
1071: If g_debug then
1072: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1073: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1074: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1075: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1076: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);
1077: End if;
1070:
1071: If g_debug then
1072: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1073: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1074: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1075: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1076: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);
1077: End if;
1078:
1071: If g_debug then
1072: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1073: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1074: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1075: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1076: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);
1077: End if;
1078:
1079:
1072: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1073: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1074: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1075: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1076: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);
1077: End if;
1078:
1079:
1080: -- Check for people that have already been Processed.
1092: AND l_OPT3_PERSON_RATE_ID IS NULL
1093: AND l_OPT4_PERSON_RATE_ID IS NULL ) THEN
1094:
1095: If g_debug then
1096: hr_utility.set_location('No Options Exists',120);
1097: end if;
1098:
1099: IF(substr(l_DOWNLOAD_SWITCH,1,1) = '2') THEN
1100: l_diff := UPDATE_WS_AMOUNT(P_PERSON_RATE_ID => l_PL_PERSON_RATE_ID
1101: ,P_WS_VAL => P_PL_WS_VAL
1102: ,P_USER_ID => P_USER_ID
1103: ,P_WS_RT_START_DATE =>P_PL_RT_START_DATE );
1104: If g_debug then
1105: hr_utility.set_location('Updated Plan WS Amt Sucessfully',130);
1106: End if;
1107: End If;
1108:
1109:
1111: ELSE
1112: -- Update Option Record with Modified Option Worksheet Amount
1113:
1114: If g_debug then
1115: hr_utility.set_location('Options Exists',140);
1116: end if;
1117:
1118: -- Plan :
1119: -- If Option Rates exists for a Plan
1123: Fetch Csr_get_pl_ws_val into l_pl_ws_val;
1124: Close Csr_get_pl_ws_val;
1125:
1126: If g_debug then
1127: hr_utility.set_location('l_pl_ws_val :'||l_pl_ws_val,150);
1128: end if;
1129:
1130: IF (l_pl_ws_val <> P_PL_WS_VAL) THEN
1131: hr_utility.set_message(805,'BEN_7830_CWB_NOT_UPD_PL_WSVAL');
1127: hr_utility.set_location('l_pl_ws_val :'||l_pl_ws_val,150);
1128: end if;
1129:
1130: IF (l_pl_ws_val <> P_PL_WS_VAL) THEN
1131: hr_utility.set_message(805,'BEN_7830_CWB_NOT_UPD_PL_WSVAL');
1132: hr_utility.raise_error;
1133: END IF;
1134:
1135: -- Option 1 :
1128: end if;
1129:
1130: IF (l_pl_ws_val <> P_PL_WS_VAL) THEN
1131: hr_utility.set_message(805,'BEN_7830_CWB_NOT_UPD_PL_WSVAL');
1132: hr_utility.raise_error;
1133: END IF;
1134:
1135: -- Option 1 :
1136: IF (l_OPT1_PERSON_RATE_ID IS NOT NULL AND substr(l_DOWNLOAD_SWITCH,2,1) = '2') THEN
1146: ,p_add_val => l_diff
1147: ,P_USER_ID => P_USER_ID
1148: ,P_WS_RT_START_DATE => P_PL_RT_START_DATE);
1149: If g_debug then
1150: hr_utility.set_location('Updated Option1 WS Amt Sucessfully',160);
1151: end if;
1152:
1153: END IF;
1154:
1164: ,p_add_val => l_diff
1165: ,P_USER_ID => P_USER_ID
1166: ,P_WS_RT_START_DATE => P_PL_RT_START_DATE);
1167: If g_debug then
1168: hr_utility.set_location('Updated Option2 WS Amt Sucessfully',170);
1169: end if;
1170:
1171: END IF;
1172:
1182: ,p_add_val => l_diff
1183: ,P_USER_ID => P_USER_ID
1184: ,P_WS_RT_START_DATE => P_PL_RT_START_DATE);
1185: If g_debug then
1186: hr_utility.set_location('Updated Option3 WS Amt Sucessfully',180);
1187: end if;
1188:
1189:
1190: END IF;
1201: ,p_add_val => l_diff
1202: ,P_USER_ID => P_USER_ID
1203: ,P_WS_RT_START_DATE => P_PL_RT_START_DATE);
1204: If g_debug then
1205: hr_utility.set_location('Updated Option4 WS Amt Sucessfully',190);
1206: end if;
1207:
1208:
1209: END IF;
1210:
1211: END IF;
1212:
1213: If g_debug then
1214: hr_utility.set_location('Updated Worksheet Amount Sucessfully ',200);
1215: End if;
1216:
1217:
1218: -- Update Rank
1223: l_OPT3_PERSON_RATE_ID,
1224: l_OPT4_PERSON_RATE_ID);
1225:
1226: If g_debug then
1227: hr_utility.set_location('l_group_per_in_ler_id : '||l_group_per_in_ler_id,210);
1228: End if;
1229:
1230: IF(substr(l_DOWNLOAD_SWITCH,7,1) = '2') THEN
1231:
1232: UPDATE_RANK(P_GROUP_PER_IN_LER_ID => l_group_per_in_ler_id
1233: ,P_RANK => P_RANK
1234: ,P_USER_ID => l_ACTING_PERSON_ID);
1235: If g_debug then
1236: hr_utility.set_location('Updated Rank Sucessfully ',220);
1237: End if;
1238:
1239: END IF;
1240:
1240:
1241: BEN_CWB_SUMMARY_PKG.save_pl_sql_tab;
1242:
1243: If g_debug then
1244: hr_utility.set_location('save_pl_sql_tab Sucessfully ',230);
1245: End if;
1246:
1247: -- Proposed Performance Rating
1248:
1254: ,P_OPT2_PERSON_RATE_ID => l_OPT2_PERSON_RATE_ID
1255: ,P_OPT3_PERSON_RATE_ID => l_OPT3_PERSON_RATE_ID
1256: ,P_OPT4_PERSON_RATE_ID => l_OPT4_PERSON_RATE_ID);
1257: If g_debug then
1258: hr_utility.set_location('Updated Proposed Performance Rating Sucessfully ',240);
1259: End if;
1260:
1261: END IF;
1262:
1269: ,P_TASK_ID => l_TASK_ID
1270: ,P_SEC_MGR_LER_ID => l_SEC_MGR_LER_ID );
1271:
1272: If g_debug then
1273: hr_utility.set_location('Update Person Tasks Table Sucessfully ',250);
1274: End if;
1275:
1276: -- Update the CPI Flex
1277: -- Update CPI Flex
1396: IF(l_is_read_only.interface_seq_num = '200' AND l_is_read_only.read_only = 'N') THEN
1397: IF(substr(l_DOWNLOAD_SWITCH,8,1) = '2') THEN
1398: l_cpi_attribute1 := check_varchar_col_avble(l_cpi_attribute1 ,p_cpi_attribute1);
1399: If g_debug then
1400: hr_utility.set_location('Upload CPI Attribute1',251);
1401: End if;
1402: END IF;
1403: END IF;
1404: IF(l_is_read_only.interface_seq_num = '201' AND l_is_read_only.read_only = 'N') THEN
1404: IF(l_is_read_only.interface_seq_num = '201' AND l_is_read_only.read_only = 'N') THEN
1405: IF(substr(l_DOWNLOAD_SWITCH,9,1) = '2') THEN
1406: l_cpi_attribute2 := check_varchar_col_avble(l_cpi_attribute2 ,p_cpi_attribute2);
1407: If g_debug then
1408: hr_utility.set_location('Upload CPI Attribute2',252);
1409: End if;
1410: END IF;
1411: END IF;
1412: IF(l_is_read_only.interface_seq_num = '202' AND l_is_read_only.read_only = 'N') THEN
1412: IF(l_is_read_only.interface_seq_num = '202' AND l_is_read_only.read_only = 'N') THEN
1413: IF(substr(l_DOWNLOAD_SWITCH,10,1) = '2') THEN
1414: l_cpi_attribute3 := check_varchar_col_avble(l_cpi_attribute3 ,p_cpi_attribute3);
1415: If g_debug then
1416: hr_utility.set_location('Upload CPI Attribute3',253);
1417: End if;
1418: END IF;
1419: END IF;
1420: IF(l_is_read_only.interface_seq_num = '203' AND l_is_read_only.read_only = 'N') THEN
1420: IF(l_is_read_only.interface_seq_num = '203' AND l_is_read_only.read_only = 'N') THEN
1421: IF(substr(l_DOWNLOAD_SWITCH,11,1) = '2') THEN
1422: l_cpi_attribute4 := check_varchar_col_avble(l_cpi_attribute4 ,p_cpi_attribute4);
1423: If g_debug then
1424: hr_utility.set_location('Upload CPI Attribute4',254);
1425: End if;
1426: END IF;
1427: END IF;
1428: IF(l_is_read_only.interface_seq_num = '204' AND l_is_read_only.read_only = 'N') THEN
1428: IF(l_is_read_only.interface_seq_num = '204' AND l_is_read_only.read_only = 'N') THEN
1429: IF(substr(l_DOWNLOAD_SWITCH,12,1) = '2') THEN
1430: l_cpi_attribute5 := check_varchar_col_avble(l_cpi_attribute5 ,p_cpi_attribute5);
1431: If g_debug then
1432: hr_utility.set_location('Upload CPI Attribute5',255);
1433: End if;
1434: END IF;
1435: END IF;
1436: IF(l_is_read_only.interface_seq_num = '205' AND l_is_read_only.read_only = 'N') THEN
1436: IF(l_is_read_only.interface_seq_num = '205' AND l_is_read_only.read_only = 'N') THEN
1437: IF(substr(l_DOWNLOAD_SWITCH,13,1) = '2') THEN
1438: l_cpi_attribute6 := check_varchar_col_avble(l_cpi_attribute6 ,p_cpi_attribute6);
1439: If g_debug then
1440: hr_utility.set_location('Upload CPI Attribute6',256);
1441: End if;
1442: END IF;
1443: END IF;
1444: IF(l_is_read_only.interface_seq_num = '206' AND l_is_read_only.read_only = 'N') THEN
1444: IF(l_is_read_only.interface_seq_num = '206' AND l_is_read_only.read_only = 'N') THEN
1445: IF(substr(l_DOWNLOAD_SWITCH,14,1) = '2') THEN
1446: l_cpi_attribute7 := check_varchar_col_avble(l_cpi_attribute7 ,p_cpi_attribute7);
1447: If g_debug then
1448: hr_utility.set_location('Upload CPI Attribute7',257);
1449: End if;
1450: END IF;
1451: END IF;
1452: IF(l_is_read_only.interface_seq_num = '207' AND l_is_read_only.read_only = 'N') THEN
1452: IF(l_is_read_only.interface_seq_num = '207' AND l_is_read_only.read_only = 'N') THEN
1453: IF(substr(l_DOWNLOAD_SWITCH,15,1) = '2') THEN
1454: l_cpi_attribute8 := check_varchar_col_avble(l_cpi_attribute8 ,p_cpi_attribute8);
1455: If g_debug then
1456: hr_utility.set_location('Upload CPI Attribute8',258);
1457: End if;
1458: END IF;
1459: END IF;
1460: IF(l_is_read_only.interface_seq_num = '208' AND l_is_read_only.read_only = 'N') THEN
1460: IF(l_is_read_only.interface_seq_num = '208' AND l_is_read_only.read_only = 'N') THEN
1461: IF(substr(l_DOWNLOAD_SWITCH,16,1) = '2') THEN
1462: l_cpi_attribute9 := check_varchar_col_avble(l_cpi_attribute9 ,p_cpi_attribute9);
1463: If g_debug then
1464: hr_utility.set_location('Upload CPI Attribute9',259);
1465: End if;
1466: END IF;
1467: END IF;
1468: IF(l_is_read_only.interface_seq_num = '209' AND l_is_read_only.read_only = 'N') THEN
1468: IF(l_is_read_only.interface_seq_num = '209' AND l_is_read_only.read_only = 'N') THEN
1469: IF(substr(l_DOWNLOAD_SWITCH,17,1) = '2') THEN
1470: l_cpi_attribute10 := check_varchar_col_avble(l_cpi_attribute10 ,p_cpi_attribute10);
1471: If g_debug then
1472: hr_utility.set_location('Upload CPI Attribute10',260);
1473: End if;
1474: END IF;
1475: END IF;
1476: IF(l_is_read_only.interface_seq_num = '210' AND l_is_read_only.read_only = 'N') THEN
1476: IF(l_is_read_only.interface_seq_num = '210' AND l_is_read_only.read_only = 'N') THEN
1477: IF(substr(l_DOWNLOAD_SWITCH,18,1) = '2') THEN
1478: l_cpi_attribute11 := check_varchar_col_avble(l_cpi_attribute11 ,p_cpi_attribute11);
1479: If g_debug then
1480: hr_utility.set_location('Upload CPI Attribute11',261);
1481: End if;
1482: END IF;
1483: END IF;
1484: IF(l_is_read_only.interface_seq_num = '211' AND l_is_read_only.read_only = 'N') THEN
1484: IF(l_is_read_only.interface_seq_num = '211' AND l_is_read_only.read_only = 'N') THEN
1485: IF(substr(l_DOWNLOAD_SWITCH,19,1) = '2') THEN
1486: l_cpi_attribute12 := check_varchar_col_avble(l_cpi_attribute12 ,p_cpi_attribute12);
1487: If g_debug then
1488: hr_utility.set_location('Upload CPI Attribute12',262);
1489: End if;
1490: END IF;
1491: END IF;
1492: IF(l_is_read_only.interface_seq_num = '212' AND l_is_read_only.read_only = 'N') THEN
1492: IF(l_is_read_only.interface_seq_num = '212' AND l_is_read_only.read_only = 'N') THEN
1493: IF(substr(l_DOWNLOAD_SWITCH,20,1) = '2') THEN
1494: l_cpi_attribute13 := check_varchar_col_avble(l_cpi_attribute13 ,p_cpi_attribute13);
1495: If g_debug then
1496: hr_utility.set_location('Upload CPI Attribute13',263);
1497: End if;
1498: END IF;
1499: END IF;
1500: IF(l_is_read_only.interface_seq_num = '213' AND l_is_read_only.read_only = 'N') THEN
1500: IF(l_is_read_only.interface_seq_num = '213' AND l_is_read_only.read_only = 'N') THEN
1501: IF(substr(l_DOWNLOAD_SWITCH,21,1) = '2') THEN
1502: l_cpi_attribute14 := check_varchar_col_avble(l_cpi_attribute14 ,p_cpi_attribute14);
1503: If g_debug then
1504: hr_utility.set_location('Upload CPI Attribute14',264);
1505: End if;
1506: END IF;
1507: END IF;
1508: IF(l_is_read_only.interface_seq_num = '214' AND l_is_read_only.read_only = 'N') THEN
1508: IF(l_is_read_only.interface_seq_num = '214' AND l_is_read_only.read_only = 'N') THEN
1509: IF(substr(l_DOWNLOAD_SWITCH,22,1) = '2') THEN
1510: l_cpi_attribute15 := check_varchar_col_avble(l_cpi_attribute15 ,p_cpi_attribute15);
1511: If g_debug then
1512: hr_utility.set_location('Upload CPI Attribute15',265);
1513: End if;
1514: END IF;
1515: END IF;
1516: IF(l_is_read_only.interface_seq_num = '215' AND l_is_read_only.read_only = 'N') THEN
1516: IF(l_is_read_only.interface_seq_num = '215' AND l_is_read_only.read_only = 'N') THEN
1517: IF(substr(l_DOWNLOAD_SWITCH,23,1) = '2') THEN
1518: l_cpi_attribute16 := check_varchar_col_avble(l_cpi_attribute16 ,p_cpi_attribute16);
1519: If g_debug then
1520: hr_utility.set_location('Upload CPI Attribute16',266);
1521: End if;
1522: END IF;
1523: END IF;
1524: IF(l_is_read_only.interface_seq_num = '216' AND l_is_read_only.read_only = 'N') THEN
1524: IF(l_is_read_only.interface_seq_num = '216' AND l_is_read_only.read_only = 'N') THEN
1525: IF(substr(l_DOWNLOAD_SWITCH,24,1) = '2') THEN
1526: l_cpi_attribute17 := check_varchar_col_avble(l_cpi_attribute17 ,p_cpi_attribute17);
1527: If g_debug then
1528: hr_utility.set_location('Upload CPI Attribute17',267);
1529: End if;
1530: END IF;
1531: END IF;
1532: IF(l_is_read_only.interface_seq_num = '217' AND l_is_read_only.read_only = 'N') THEN
1532: IF(l_is_read_only.interface_seq_num = '217' AND l_is_read_only.read_only = 'N') THEN
1533: IF(substr(l_DOWNLOAD_SWITCH,25,1) = '2') THEN
1534: l_cpi_attribute18 := check_varchar_col_avble(l_cpi_attribute18 ,p_cpi_attribute18);
1535: If g_debug then
1536: hr_utility.set_location('Upload CPI Attribute18',268);
1537: End if;
1538: END IF;
1539: END IF;
1540: IF(l_is_read_only.interface_seq_num = '218' AND l_is_read_only.read_only = 'N') THEN
1540: IF(l_is_read_only.interface_seq_num = '218' AND l_is_read_only.read_only = 'N') THEN
1541: IF(substr(l_DOWNLOAD_SWITCH,26,1) = '2') THEN
1542: l_cpi_attribute19 := check_varchar_col_avble(l_cpi_attribute19 ,p_cpi_attribute19);
1543: If g_debug then
1544: hr_utility.set_location('Upload CPI Attribute19',269);
1545: End if;
1546: END IF;
1547: END IF;
1548: IF(l_is_read_only.interface_seq_num = '219' AND l_is_read_only.read_only = 'N') THEN
1548: IF(l_is_read_only.interface_seq_num = '219' AND l_is_read_only.read_only = 'N') THEN
1549: IF(substr(l_DOWNLOAD_SWITCH,27,1) = '2') THEN
1550: l_cpi_attribute20 := check_varchar_col_avble(l_cpi_attribute20 ,p_cpi_attribute20);
1551: If g_debug then
1552: hr_utility.set_location('Upload CPI Attribute20',270);
1553: End if;
1554: END IF;
1555: END IF;
1556: IF(l_is_read_only.interface_seq_num = '220' AND l_is_read_only.read_only = 'N') THEN
1556: IF(l_is_read_only.interface_seq_num = '220' AND l_is_read_only.read_only = 'N') THEN
1557: IF(substr(l_DOWNLOAD_SWITCH,28,1) = '2') THEN
1558: l_cpi_attribute21 := check_varchar_col_avble(l_cpi_attribute21 ,p_cpi_attribute21);
1559: If g_debug then
1560: hr_utility.set_location('Upload CPI Attribute21',271);
1561: End if;
1562: END IF;
1563: END IF;
1564: IF(l_is_read_only.interface_seq_num = '221' AND l_is_read_only.read_only = 'N') THEN
1564: IF(l_is_read_only.interface_seq_num = '221' AND l_is_read_only.read_only = 'N') THEN
1565: IF(substr(l_DOWNLOAD_SWITCH,29,1) = '2') THEN
1566: l_cpi_attribute22 := check_varchar_col_avble(l_cpi_attribute22 ,p_cpi_attribute22);
1567: If g_debug then
1568: hr_utility.set_location('Upload CPI Attribute22',272);
1569: End if;
1570: END IF;
1571: END IF;
1572: IF(l_is_read_only.interface_seq_num = '222' AND l_is_read_only.read_only = 'N') THEN
1572: IF(l_is_read_only.interface_seq_num = '222' AND l_is_read_only.read_only = 'N') THEN
1573: IF(substr(l_DOWNLOAD_SWITCH,30,1) = '2') THEN
1574: l_cpi_attribute23 := check_varchar_col_avble(l_cpi_attribute23 ,p_cpi_attribute23);
1575: If g_debug then
1576: hr_utility.set_location('Upload CPI Attribute23',273);
1577: End if;
1578: END IF;
1579: END IF;
1580: IF(l_is_read_only.interface_seq_num = '223' AND l_is_read_only.read_only = 'N') THEN
1580: IF(l_is_read_only.interface_seq_num = '223' AND l_is_read_only.read_only = 'N') THEN
1581: IF(substr(l_DOWNLOAD_SWITCH,31,1) = '2') THEN
1582: l_cpi_attribute24 := check_varchar_col_avble(l_cpi_attribute24 ,p_cpi_attribute24);
1583: If g_debug then
1584: hr_utility.set_location('Upload CPI Attribute24',274);
1585: End if;
1586: END IF;
1587: END IF;
1588: IF(l_is_read_only.interface_seq_num = '224' AND l_is_read_only.read_only = 'N') THEN
1588: IF(l_is_read_only.interface_seq_num = '224' AND l_is_read_only.read_only = 'N') THEN
1589: IF(substr(l_DOWNLOAD_SWITCH,32,1) = '2') THEN
1590: l_cpi_attribute25 := check_varchar_col_avble(l_cpi_attribute25 ,p_cpi_attribute25);
1591: If g_debug then
1592: hr_utility.set_location('Upload CPI Attribute25',275);
1593: End if;
1594: END IF;
1595: END IF;
1596: IF(l_is_read_only.interface_seq_num = '225' AND l_is_read_only.read_only = 'N') THEN
1596: IF(l_is_read_only.interface_seq_num = '225' AND l_is_read_only.read_only = 'N') THEN
1597: IF(substr(l_DOWNLOAD_SWITCH,33,1) = '2') THEN
1598: l_cpi_attribute26 := check_varchar_col_avble(l_cpi_attribute26 ,p_cpi_attribute26);
1599: If g_debug then
1600: hr_utility.set_location('Upload CPI Attribute26',276);
1601: End if;
1602: END IF;
1603: END IF;
1604: IF(l_is_read_only.interface_seq_num = '226' AND l_is_read_only.read_only = 'N') THEN
1604: IF(l_is_read_only.interface_seq_num = '226' AND l_is_read_only.read_only = 'N') THEN
1605: IF(substr(l_DOWNLOAD_SWITCH,34,1) = '2') THEN
1606: l_cpi_attribute27 := check_varchar_col_avble(l_cpi_attribute27 ,p_cpi_attribute27);
1607: If g_debug then
1608: hr_utility.set_location('Upload CPI Attribute27',277);
1609: End if;
1610: END IF;
1611: END IF;
1612: IF(l_is_read_only.interface_seq_num = '227' AND l_is_read_only.read_only = 'N') THEN
1612: IF(l_is_read_only.interface_seq_num = '227' AND l_is_read_only.read_only = 'N') THEN
1613: IF(substr(l_DOWNLOAD_SWITCH,35,1) = '2') THEN
1614: l_cpi_attribute28 := check_varchar_col_avble(l_cpi_attribute28 ,p_cpi_attribute28);
1615: If g_debug then
1616: hr_utility.set_location('Upload CPI Attribute28',278);
1617: End if;
1618: END IF;
1619: END IF;
1620: IF(l_is_read_only.interface_seq_num = '228' AND l_is_read_only.read_only = 'N') THEN
1620: IF(l_is_read_only.interface_seq_num = '228' AND l_is_read_only.read_only = 'N') THEN
1621: IF(substr(l_DOWNLOAD_SWITCH,36,1) = '2') THEN
1622: l_cpi_attribute29 := check_varchar_col_avble(l_cpi_attribute29 ,p_cpi_attribute29);
1623: If g_debug then
1624: hr_utility.set_location('Upload CPI Attribute29',279);
1625: End if;
1626: END IF;
1627: END IF;
1628: IF(l_is_read_only.interface_seq_num = '229' AND l_is_read_only.read_only = 'N') THEN
1628: IF(l_is_read_only.interface_seq_num = '229' AND l_is_read_only.read_only = 'N') THEN
1629: IF(substr(l_DOWNLOAD_SWITCH,37,1) = '2') THEN
1630: l_cpi_attribute30 := check_varchar_col_avble(l_cpi_attribute30 ,p_cpi_attribute30);
1631: If g_debug then
1632: hr_utility.set_location('Upload CPI Attribute30',280);
1633: End if;
1634: END IF;
1635: END IF;
1636:
1690: ,P_CUSTOM_SEGMENT19 => l_CUSTOM_SEGMENT19
1691: ,P_CUSTOM_SEGMENT20 => l_CUSTOM_SEGMENT20
1692: ,P_OBJECT_VERSION_NUMBER => L_OVN);
1693: If g_debug then
1694: hr_utility.set_location('Updated CPI Flex Rating Sucessfully ',281);
1695: End if;
1696:
1697: --
1698: -- Call the routine for dynamic calculations.
1708: ,p_raise_error => true);
1709: --
1710:
1711: If g_debug then
1712: hr_utility.set_location('Leaving '||l_proc,290);
1713: End if;
1714:
1715: EXCEPTION
1716: WHEN Others THEN
1714:
1715: EXCEPTION
1716: WHEN Others THEN
1717: if g_debug then
1718: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 300);
1719: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 301);
1720: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 302);
1721: end if;
1722:
1715: EXCEPTION
1716: WHEN Others THEN
1717: if g_debug then
1718: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 300);
1719: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 301);
1720: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 302);
1721: end if;
1722:
1723: Rollback to Update_data;
1716: WHEN Others THEN
1717: if g_debug then
1718: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 300);
1719: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 301);
1720: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 302);
1721: end if;
1722:
1723: Rollback to Update_data;
1724: