[Home] [Help]
134: l_comp_element_outcome_id per_comp_element_outcomes.comp_element_outcome_id%type;
135: l_proc varchar2(200);
136: Begin
137: l_proc := g_package || 'writeTo_transTbl';
138: hr_utility.set_location(' Entering:' || l_proc,5);
139: --
140: IF (p_comp_element_outcome_id = -1) Then
141: hr_utility.set_location(' Entering:' || l_proc,10);
142: l_comp_element_outcome_id := null;
137: l_proc := g_package || 'writeTo_transTbl';
138: hr_utility.set_location(' Entering:' || l_proc,5);
139: --
140: IF (p_comp_element_outcome_id = -1) Then
141: hr_utility.set_location(' Entering:' || l_proc,10);
142: l_comp_element_outcome_id := null;
143: else
144: hr_utility.set_location(' Entering:' || l_proc,15);
145: l_comp_element_outcome_id := p_comp_element_outcome_id;
140: IF (p_comp_element_outcome_id = -1) Then
141: hr_utility.set_location(' Entering:' || l_proc,10);
142: l_comp_element_outcome_id := null;
143: else
144: hr_utility.set_location(' Entering:' || l_proc,15);
145: l_comp_element_outcome_id := p_comp_element_outcome_id;
146: END if;
147: hr_utility.set_location(l_proc,20);
148: --
143: else
144: hr_utility.set_location(' Entering:' || l_proc,15);
145: l_comp_element_outcome_id := p_comp_element_outcome_id;
146: END if;
147: hr_utility.set_location(l_proc,20);
148: --
149: If p_trans_step_id is null then
150: hr_utility.set_location(l_proc,25);
151: hr_transaction_api.create_transaction_step
146: END if;
147: hr_utility.set_location(l_proc,20);
148: --
149: If p_trans_step_id is null then
150: hr_utility.set_location(l_proc,25);
151: hr_transaction_api.create_transaction_step
152: (p_validate => false
153: ,p_creator_person_id => p_login_person_id
154: ,p_transaction_id => p_trans_id
159: ,p_transaction_step_id => p_trans_step_id
160: ,p_object_version_number => x_trans_ovn);
161: --
162: End if;
163: hr_utility.set_location(l_proc,30);
164: l_count := 1;
165: l_trans_tbl(l_count).param_name := 'P_COMP_ELEMENT_OUTCOME_ID';
166: l_trans_tbl(l_count).param_value := l_comp_element_outcome_id;
167: l_trans_tbl(l_count).param_data_type := 'NUMBER';
211: l_trans_tbl(l_count).param_value := p_competence_id;
212: l_trans_tbl(l_count).param_data_type := 'NUMBER';
213: --
214: If p_upg_from_rec_id <> -1 then
215: hr_utility.set_location(l_proc,35);
216: l_count := l_count + 1;
217: l_trans_tbl(l_count).param_name := 'P_UPGRADED_FROM_REC_ID';
218: l_trans_tbl(l_count).param_value := p_upg_from_rec_id;
219: l_trans_tbl(l_count).param_data_type := 'NUMBER';
234: l_count := l_count + 1;
235: l_trans_tbl(l_count).param_name := 'P_REVIEW_PROC_CALL';
236: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
237: l_trans_tbl(l_count).param_value := l_review_region;
238: hr_utility.set_location(l_proc,40);
239: save_transaction_step(p_item_type => p_item_type
240: ,p_item_key => p_item_key
241: ,p_actid => p_actid
242: ,p_login_person_id => p_login_person_id
300: ----------------------------------
301: Begin
302: l_obj_ver_num := 1;
303: l_proc := g_package || 'process_save';
304: hr_utility.set_location(' Entering:' || l_proc,5);
305: l_user_date_format := g_date_format ;
306: l_date_from := to_date(p_date_from,l_user_date_format);
307: l_obj_ver_num := p_preupd_obj_vers_num;
308: --
306: l_date_from := to_date(p_date_from,l_user_date_format);
307: l_obj_ver_num := p_preupd_obj_vers_num;
308: --
309: IF p_comp_element_outcome_id IS NULL then
310: hr_utility.set_location(' Entering:' || l_proc,10);
311: l_comp_element_outcome_id := -1;
312: Else
313: l_comp_element_outcome_id := p_comp_element_outcome_id;
314: IF p_preupd_obj_vers_num IS NULL then
317: l_obj_ver_num := ovn.object_version_number;
318: END loop;
319: END if;
320: END if;
321: hr_utility.set_location(' Entering:' || l_proc,20);
322: api_validate_compout_record
323: (p_validate => TRUE
324: ,p_competence_element_id => p_competence_element_id
325: ,p_outcome_id => p_outcome_id
334: ,p_error_message => p_error_message);
335: if p_error_message is not null then
336: Return;
337: end if;
338: hr_utility.set_location(' Entering:' || l_proc,25);
339: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => p_item_type
340: ,p_item_key => p_item_key);
341: --
342: IF l_transaction_id is null THEN
339: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => p_item_type
340: ,p_item_key => p_item_key);
341: --
342: IF l_transaction_id is null THEN
343: hr_utility.set_location(' Entering:' || l_proc,30);
344: -- Start a Transaction
345: hr_transaction_ss.start_transaction
346: (itemtype => p_item_type
347: ,itemkey => p_item_key
348: ,actid => to_number(p_actid)
349: ,funmode => 'RUN'
350: ,p_login_person_id => fnd_global.employee_id
351: ,result => l_result);
352: hr_utility.set_location(' Entering:' || l_proc,40);
353: l_transaction_id := hr_transaction_ss.get_transaction_id
354: (p_item_type => p_item_type
355: ,p_item_key => p_item_key);
356: END IF;
355: ,p_item_key => p_item_key);
356: END IF;
357: --
358: IF p_transaction_step_id IS NULL then
359: hr_utility.set_location(' Entering:' || l_proc,50);
360: hr_transaction_api.create_transaction_step
361: (p_validate => false
362: ,p_creator_person_id => fnd_global.employee_id
363: ,p_transaction_id => l_transaction_id
368: ,p_transaction_step_id => p_transaction_step_id
369: ,p_object_version_number => l_trans_obj_vers_num);
370: end if;
371: --
372: hr_utility.set_location(' Entering:' || l_proc,60);
373: writeTo_transTbl (
374: p_item_type => p_item_type
375: ,p_item_key => p_item_key
376: ,p_actid => To_Number(p_actid)
392: ,p_upg_from_rec_id => l_comp_element_outcome_id);
393: --
394: EXCEPTION
395: When g_invalid_entry then
396: hr_utility.set_location(' Entering:' || l_proc,70);
397: raise g_invalid_entry;
398: --
399: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
400: hr_utility.set_location(' Entering:' || l_proc,80);
396: hr_utility.set_location(' Entering:' || l_proc,70);
397: raise g_invalid_entry;
398: --
399: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
400: hr_utility.set_location(' Entering:' || l_proc,80);
401: raise hr_utility.hr_error;
402: --
403: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
404: hr_utility.set_location(' Entering:' || l_proc,90);
397: raise g_invalid_entry;
398: --
399: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
400: hr_utility.set_location(' Entering:' || l_proc,80);
401: raise hr_utility.hr_error;
402: --
403: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
404: hr_utility.set_location(' Entering:' || l_proc,90);
405: raise hr_utility.hr_error;
400: hr_utility.set_location(' Entering:' || l_proc,80);
401: raise hr_utility.hr_error;
402: --
403: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
404: hr_utility.set_location(' Entering:' || l_proc,90);
405: raise hr_utility.hr_error;
406: --
407: When others THEN
408: hr_utility.set_location(' Entering:' || l_proc,100);
401: raise hr_utility.hr_error;
402: --
403: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
404: hr_utility.set_location(' Entering:' || l_proc,90);
405: raise hr_utility.hr_error;
406: --
407: When others THEN
408: hr_utility.set_location(' Entering:' || l_proc,100);
409: raise g_invalid_entry ;
404: hr_utility.set_location(' Entering:' || l_proc,90);
405: raise hr_utility.hr_error;
406: --
407: When others THEN
408: hr_utility.set_location(' Entering:' || l_proc,100);
409: raise g_invalid_entry ;
410: End process_save;
411: --
412: -- ---------------------------------------------------------------------------
538: l_comp_ele_outcome_id per_Comp_Element_Outcomes.comp_Element_Outcome_id%type;
539: l_obj_ver_no number;
540: l_proc varchar2(200) ;
541: begin
542: -- hr_utility.trace_on(null,'COMPQUAL');
543: l_proc := g_package || ' call_process_api';
544: hr_utility.set_location(' Entering:' || l_proc,10);
545: --hr_utility.set_location(' p_validate:' || to_char(p_validate),10);
546: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
540: l_proc varchar2(200) ;
541: begin
542: -- hr_utility.trace_on(null,'COMPQUAL');
543: l_proc := g_package || ' call_process_api';
544: hr_utility.set_location(' Entering:' || l_proc,10);
545: --hr_utility.set_location(' p_validate:' || to_char(p_validate),10);
546: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
547: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,10);
548: hr_utility.set_location(' p_competence_id:' || p_competence_id,10);
541: begin
542: -- hr_utility.trace_on(null,'COMPQUAL');
543: l_proc := g_package || ' call_process_api';
544: hr_utility.set_location(' Entering:' || l_proc,10);
545: --hr_utility.set_location(' p_validate:' || to_char(p_validate),10);
546: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
547: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,10);
548: hr_utility.set_location(' p_competence_id:' || p_competence_id,10);
549: hr_utility.set_location(' p_item_type:' || p_item_type,10);
542: -- hr_utility.trace_on(null,'COMPQUAL');
543: l_proc := g_package || ' call_process_api';
544: hr_utility.set_location(' Entering:' || l_proc,10);
545: --hr_utility.set_location(' p_validate:' || to_char(p_validate),10);
546: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
547: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,10);
548: hr_utility.set_location(' p_competence_id:' || p_competence_id,10);
549: hr_utility.set_location(' p_item_type:' || p_item_type,10);
550: hr_utility.set_location(' p_item_key:' || p_item_key,10);
543: l_proc := g_package || ' call_process_api';
544: hr_utility.set_location(' Entering:' || l_proc,10);
545: --hr_utility.set_location(' p_validate:' || to_char(p_validate),10);
546: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
547: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,10);
548: hr_utility.set_location(' p_competence_id:' || p_competence_id,10);
549: hr_utility.set_location(' p_item_type:' || p_item_type,10);
550: hr_utility.set_location(' p_item_key:' || p_item_key,10);
551: hr_utility.set_location(' p_activity_id:' || p_activity_id,10);
544: hr_utility.set_location(' Entering:' || l_proc,10);
545: --hr_utility.set_location(' p_validate:' || to_char(p_validate),10);
546: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
547: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,10);
548: hr_utility.set_location(' p_competence_id:' || p_competence_id,10);
549: hr_utility.set_location(' p_item_type:' || p_item_type,10);
550: hr_utility.set_location(' p_item_key:' || p_item_key,10);
551: hr_utility.set_location(' p_activity_id:' || p_activity_id,10);
552: hr_utility.set_location(' p_person_id:' || p_person_id,10);
545: --hr_utility.set_location(' p_validate:' || to_char(p_validate),10);
546: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
547: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,10);
548: hr_utility.set_location(' p_competence_id:' || p_competence_id,10);
549: hr_utility.set_location(' p_item_type:' || p_item_type,10);
550: hr_utility.set_location(' p_item_key:' || p_item_key,10);
551: hr_utility.set_location(' p_activity_id:' || p_activity_id,10);
552: hr_utility.set_location(' p_person_id:' || p_person_id,10);
553: hr_utility.set_location(' p_effective_date:' || to_char(p_effective_date,'DD-MON-YYYY'),10);
546: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
547: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,10);
548: hr_utility.set_location(' p_competence_id:' || p_competence_id,10);
549: hr_utility.set_location(' p_item_type:' || p_item_type,10);
550: hr_utility.set_location(' p_item_key:' || p_item_key,10);
551: hr_utility.set_location(' p_activity_id:' || p_activity_id,10);
552: hr_utility.set_location(' p_person_id:' || p_person_id,10);
553: hr_utility.set_location(' p_effective_date:' || to_char(p_effective_date,'DD-MON-YYYY'),10);
554: savepoint save_comp_element_outcome;
547: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,10);
548: hr_utility.set_location(' p_competence_id:' || p_competence_id,10);
549: hr_utility.set_location(' p_item_type:' || p_item_type,10);
550: hr_utility.set_location(' p_item_key:' || p_item_key,10);
551: hr_utility.set_location(' p_activity_id:' || p_activity_id,10);
552: hr_utility.set_location(' p_person_id:' || p_person_id,10);
553: hr_utility.set_location(' p_effective_date:' || to_char(p_effective_date,'DD-MON-YYYY'),10);
554: savepoint save_comp_element_outcome;
555: l_count := 0;
548: hr_utility.set_location(' p_competence_id:' || p_competence_id,10);
549: hr_utility.set_location(' p_item_type:' || p_item_type,10);
550: hr_utility.set_location(' p_item_key:' || p_item_key,10);
551: hr_utility.set_location(' p_activity_id:' || p_activity_id,10);
552: hr_utility.set_location(' p_person_id:' || p_person_id,10);
553: hr_utility.set_location(' p_effective_date:' || to_char(p_effective_date,'DD-MON-YYYY'),10);
554: savepoint save_comp_element_outcome;
555: l_count := 0;
556: --
549: hr_utility.set_location(' p_item_type:' || p_item_type,10);
550: hr_utility.set_location(' p_item_key:' || p_item_key,10);
551: hr_utility.set_location(' p_activity_id:' || p_activity_id,10);
552: hr_utility.set_location(' p_person_id:' || p_person_id,10);
553: hr_utility.set_location(' p_effective_date:' || to_char(p_effective_date,'DD-MON-YYYY'),10);
554: savepoint save_comp_element_outcome;
555: l_count := 0;
556: --
557: FOR outids IN get_enddate_outcome_ids(p_competence_element_id)
561: ,p_to_date => trunc(sysdate)
562: ,p_object_version_number => outids.object_version_number );
563: delete_transaction_step_id(outids.transaction_step_id);
564: END loop;
565: hr_utility.set_location(' Entering:' || l_proc,20);
566: --
567: FOR txnids IN get_txn_step_id(
568: p_comp_id => p_competence_id
569: ,p_comp_ele_id => p_competence_element_id
569: ,p_comp_ele_id => p_competence_element_id
570: ,p_person_id => p_person_id
571: ,p_eff_date => p_effective_date)
572: loop
573: hr_utility.set_location(' Entering:' || l_proc,30);
574: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,30);
575: hr_utility.set_location(' p_effective_date:' || l_proc,30);
576: hr_utility.set_location(' p_transaction_step_id: ' || txnids.transaction_step_id,30);
577: HR_COMP_OUTCOME_PROFILE_SS.process_api(
570: ,p_person_id => p_person_id
571: ,p_eff_date => p_effective_date)
572: loop
573: hr_utility.set_location(' Entering:' || l_proc,30);
574: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,30);
575: hr_utility.set_location(' p_effective_date:' || l_proc,30);
576: hr_utility.set_location(' p_transaction_step_id: ' || txnids.transaction_step_id,30);
577: HR_COMP_OUTCOME_PROFILE_SS.process_api(
578: p_validate => p_validate
571: ,p_eff_date => p_effective_date)
572: loop
573: hr_utility.set_location(' Entering:' || l_proc,30);
574: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,30);
575: hr_utility.set_location(' p_effective_date:' || l_proc,30);
576: hr_utility.set_location(' p_transaction_step_id: ' || txnids.transaction_step_id,30);
577: HR_COMP_OUTCOME_PROFILE_SS.process_api(
578: p_validate => p_validate
579: ,p_competence_element_id => p_new_competence_element_id
572: loop
573: hr_utility.set_location(' Entering:' || l_proc,30);
574: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,30);
575: hr_utility.set_location(' p_effective_date:' || l_proc,30);
576: hr_utility.set_location(' p_transaction_step_id: ' || txnids.transaction_step_id,30);
577: HR_COMP_OUTCOME_PROFILE_SS.process_api(
578: p_validate => p_validate
579: ,p_competence_element_id => p_new_competence_element_id
580: ,p_effective_date => p_effective_date
579: ,p_competence_element_id => p_new_competence_element_id
580: ,p_effective_date => p_effective_date
581: ,p_transaction_step_id => txnids.transaction_step_id);
582: END loop;
583: hr_utility.set_location(' Entering:' || l_proc,40);
584: hr_utility.set_location(' p_competence_element_id: ' || p_competence_element_id,40);
585: hr_utility.set_location(' p_new_competence_element_id: ' || p_new_competence_element_id,40);
586: hr_utility.set_location(' l_count :' || l_count,40);
587: --
580: ,p_effective_date => p_effective_date
581: ,p_transaction_step_id => txnids.transaction_step_id);
582: END loop;
583: hr_utility.set_location(' Entering:' || l_proc,40);
584: hr_utility.set_location(' p_competence_element_id: ' || p_competence_element_id,40);
585: hr_utility.set_location(' p_new_competence_element_id: ' || p_new_competence_element_id,40);
586: hr_utility.set_location(' l_count :' || l_count,40);
587: --
588: l_count := 0;
581: ,p_transaction_step_id => txnids.transaction_step_id);
582: END loop;
583: hr_utility.set_location(' Entering:' || l_proc,40);
584: hr_utility.set_location(' p_competence_element_id: ' || p_competence_element_id,40);
585: hr_utility.set_location(' p_new_competence_element_id: ' || p_new_competence_element_id,40);
586: hr_utility.set_location(' l_count :' || l_count,40);
587: --
588: l_count := 0;
589: IF p_competence_element_id <> p_new_competence_element_id then
582: END loop;
583: hr_utility.set_location(' Entering:' || l_proc,40);
584: hr_utility.set_location(' p_competence_element_id: ' || p_competence_element_id,40);
585: hr_utility.set_location(' p_new_competence_element_id: ' || p_new_competence_element_id,40);
586: hr_utility.set_location(' l_count :' || l_count,40);
587: --
588: l_count := 0;
589: IF p_competence_element_id <> p_new_competence_element_id then
590: FOR unchangedRec IN get_unchngd_outcomes(p_competence_element_id)
620: l_End_Date := unchangedRec.date_to;
621: -- End if;
622: -- End if;
623: --
624: hr_utility.set_location(' Entering l_comp_ele_outcome_id:' || l_comp_ele_outcome_id,50);
625: hr_utility.set_location(' Entering p_new_competence_element_id:' || p_new_competence_element_id,50);
626: hr_utility.set_location(' Entering l_obj_ver_no:' || l_obj_ver_no,50);
627: hr_utility.set_location(' Entering unchangedRec.outcome_id:' || unchangedRec.outcome_id,50);
628: hr_utility.set_location(' Entering l_Start_Date:' || l_Start_Date,50);
621: -- End if;
622: -- End if;
623: --
624: hr_utility.set_location(' Entering l_comp_ele_outcome_id:' || l_comp_ele_outcome_id,50);
625: hr_utility.set_location(' Entering p_new_competence_element_id:' || p_new_competence_element_id,50);
626: hr_utility.set_location(' Entering l_obj_ver_no:' || l_obj_ver_no,50);
627: hr_utility.set_location(' Entering unchangedRec.outcome_id:' || unchangedRec.outcome_id,50);
628: hr_utility.set_location(' Entering l_Start_Date:' || l_Start_Date,50);
629: hr_utility.set_location(' Entering l_End_Date:' || l_End_Date,50);
622: -- End if;
623: --
624: hr_utility.set_location(' Entering l_comp_ele_outcome_id:' || l_comp_ele_outcome_id,50);
625: hr_utility.set_location(' Entering p_new_competence_element_id:' || p_new_competence_element_id,50);
626: hr_utility.set_location(' Entering l_obj_ver_no:' || l_obj_ver_no,50);
627: hr_utility.set_location(' Entering unchangedRec.outcome_id:' || unchangedRec.outcome_id,50);
628: hr_utility.set_location(' Entering l_Start_Date:' || l_Start_Date,50);
629: hr_utility.set_location(' Entering l_End_Date:' || l_End_Date,50);
630: hr_utility.set_location(' Entering unchangedRec.date_From:' || unchangedRec.date_From,50);
623: --
624: hr_utility.set_location(' Entering l_comp_ele_outcome_id:' || l_comp_ele_outcome_id,50);
625: hr_utility.set_location(' Entering p_new_competence_element_id:' || p_new_competence_element_id,50);
626: hr_utility.set_location(' Entering l_obj_ver_no:' || l_obj_ver_no,50);
627: hr_utility.set_location(' Entering unchangedRec.outcome_id:' || unchangedRec.outcome_id,50);
628: hr_utility.set_location(' Entering l_Start_Date:' || l_Start_Date,50);
629: hr_utility.set_location(' Entering l_End_Date:' || l_End_Date,50);
630: hr_utility.set_location(' Entering unchangedRec.date_From:' || unchangedRec.date_From,50);
631: hr_utility.set_location(' Entering unchangedRec.date_to:' || unchangedRec.date_to,50);
624: hr_utility.set_location(' Entering l_comp_ele_outcome_id:' || l_comp_ele_outcome_id,50);
625: hr_utility.set_location(' Entering p_new_competence_element_id:' || p_new_competence_element_id,50);
626: hr_utility.set_location(' Entering l_obj_ver_no:' || l_obj_ver_no,50);
627: hr_utility.set_location(' Entering unchangedRec.outcome_id:' || unchangedRec.outcome_id,50);
628: hr_utility.set_location(' Entering l_Start_Date:' || l_Start_Date,50);
629: hr_utility.set_location(' Entering l_End_Date:' || l_End_Date,50);
630: hr_utility.set_location(' Entering unchangedRec.date_From:' || unchangedRec.date_From,50);
631: hr_utility.set_location(' Entering unchangedRec.date_to:' || unchangedRec.date_to,50);
632: hr_utility.set_location(' Entering trunc(sysdate) :' || trunc(sysdate),50);
625: hr_utility.set_location(' Entering p_new_competence_element_id:' || p_new_competence_element_id,50);
626: hr_utility.set_location(' Entering l_obj_ver_no:' || l_obj_ver_no,50);
627: hr_utility.set_location(' Entering unchangedRec.outcome_id:' || unchangedRec.outcome_id,50);
628: hr_utility.set_location(' Entering l_Start_Date:' || l_Start_Date,50);
629: hr_utility.set_location(' Entering l_End_Date:' || l_End_Date,50);
630: hr_utility.set_location(' Entering unchangedRec.date_From:' || unchangedRec.date_From,50);
631: hr_utility.set_location(' Entering unchangedRec.date_to:' || unchangedRec.date_to,50);
632: hr_utility.set_location(' Entering trunc(sysdate) :' || trunc(sysdate),50);
633: per_ceo_ins.ins(
626: hr_utility.set_location(' Entering l_obj_ver_no:' || l_obj_ver_no,50);
627: hr_utility.set_location(' Entering unchangedRec.outcome_id:' || unchangedRec.outcome_id,50);
628: hr_utility.set_location(' Entering l_Start_Date:' || l_Start_Date,50);
629: hr_utility.set_location(' Entering l_End_Date:' || l_End_Date,50);
630: hr_utility.set_location(' Entering unchangedRec.date_From:' || unchangedRec.date_From,50);
631: hr_utility.set_location(' Entering unchangedRec.date_to:' || unchangedRec.date_to,50);
632: hr_utility.set_location(' Entering trunc(sysdate) :' || trunc(sysdate),50);
633: per_ceo_ins.ins(
634: p_comp_element_outcome_id => l_comp_ele_outcome_id
627: hr_utility.set_location(' Entering unchangedRec.outcome_id:' || unchangedRec.outcome_id,50);
628: hr_utility.set_location(' Entering l_Start_Date:' || l_Start_Date,50);
629: hr_utility.set_location(' Entering l_End_Date:' || l_End_Date,50);
630: hr_utility.set_location(' Entering unchangedRec.date_From:' || unchangedRec.date_From,50);
631: hr_utility.set_location(' Entering unchangedRec.date_to:' || unchangedRec.date_to,50);
632: hr_utility.set_location(' Entering trunc(sysdate) :' || trunc(sysdate),50);
633: per_ceo_ins.ins(
634: p_comp_element_outcome_id => l_comp_ele_outcome_id
635: ,p_competence_element_id => p_new_competence_element_id
628: hr_utility.set_location(' Entering l_Start_Date:' || l_Start_Date,50);
629: hr_utility.set_location(' Entering l_End_Date:' || l_End_Date,50);
630: hr_utility.set_location(' Entering unchangedRec.date_From:' || unchangedRec.date_From,50);
631: hr_utility.set_location(' Entering unchangedRec.date_to:' || unchangedRec.date_to,50);
632: hr_utility.set_location(' Entering trunc(sysdate) :' || trunc(sysdate),50);
633: per_ceo_ins.ins(
634: p_comp_element_outcome_id => l_comp_ele_outcome_id
635: ,p_competence_element_id => p_new_competence_element_id
636: ,p_object_version_number => l_obj_ver_no
639: ,p_date_to => unchangedRec.date_to
640: ,p_effective_date => trunc(sysdate));
641: --
642: END loop;
643: hr_utility.set_location(' Entering:' || l_proc,80);
644: END if;
645: -- hr_utility.trace_off;
646: --
647: EXCEPTION
641: --
642: END loop;
643: hr_utility.set_location(' Entering:' || l_proc,80);
644: END if;
645: -- hr_utility.trace_off;
646: --
647: EXCEPTION
648: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
649: hr_utility.set_location(' Entering:' || l_proc,90);
645: -- hr_utility.trace_off;
646: --
647: EXCEPTION
648: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
649: hr_utility.set_location(' Entering:' || l_proc,90);
650: raise hr_utility.hr_error;
651: --
652: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
653: hr_utility.set_location(' Entering:' || l_proc,100);
646: --
647: EXCEPTION
648: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
649: hr_utility.set_location(' Entering:' || l_proc,90);
650: raise hr_utility.hr_error;
651: --
652: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
653: hr_utility.set_location(' Entering:' || l_proc,100);
654: raise hr_utility.hr_error;
649: hr_utility.set_location(' Entering:' || l_proc,90);
650: raise hr_utility.hr_error;
651: --
652: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
653: hr_utility.set_location(' Entering:' || l_proc,100);
654: raise hr_utility.hr_error;
655: --
656: When others THEN
657: hr_utility.set_location(' Entering:' || l_proc,110);
650: raise hr_utility.hr_error;
651: --
652: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
653: hr_utility.set_location(' Entering:' || l_proc,100);
654: raise hr_utility.hr_error;
655: --
656: When others THEN
657: hr_utility.set_location(' Entering:' || l_proc,110);
658: raise hr_utility.hr_error;
653: hr_utility.set_location(' Entering:' || l_proc,100);
654: raise hr_utility.hr_error;
655: --
656: When others THEN
657: hr_utility.set_location(' Entering:' || l_proc,110);
658: raise hr_utility.hr_error;
659: --
660: END call_process_api;
661: -- ---------------------------- < process_api > ------------------------------
654: raise hr_utility.hr_error;
655: --
656: When others THEN
657: hr_utility.set_location(' Entering:' || l_proc,110);
658: raise hr_utility.hr_error;
659: --
660: END call_process_api;
661: -- ---------------------------- < process_api > ------------------------------
662: -- ---------------------------------------------------------------------------
688: --
689: Begin
690: --
691: l_proc := g_package || 'process_api';
692: hr_utility.set_location(' p_transaction_step_id:' || p_transaction_step_id,10);
693: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
694: hr_utility.set_location(' Entering:' || l_proc,10);
695: hr_utility.set_location(' Entering:' || l_proc,10);
696: hr_utility.set_location(' Entering:' || l_proc,10);
689: Begin
690: --
691: l_proc := g_package || 'process_api';
692: hr_utility.set_location(' p_transaction_step_id:' || p_transaction_step_id,10);
693: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
694: hr_utility.set_location(' Entering:' || l_proc,10);
695: hr_utility.set_location(' Entering:' || l_proc,10);
696: hr_utility.set_location(' Entering:' || l_proc,10);
697: hr_utility.set_location(' Entering:' || l_proc,10);
690: --
691: l_proc := g_package || 'process_api';
692: hr_utility.set_location(' p_transaction_step_id:' || p_transaction_step_id,10);
693: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
694: hr_utility.set_location(' Entering:' || l_proc,10);
695: hr_utility.set_location(' Entering:' || l_proc,10);
696: hr_utility.set_location(' Entering:' || l_proc,10);
697: hr_utility.set_location(' Entering:' || l_proc,10);
698: l_count := 0;
691: l_proc := g_package || 'process_api';
692: hr_utility.set_location(' p_transaction_step_id:' || p_transaction_step_id,10);
693: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
694: hr_utility.set_location(' Entering:' || l_proc,10);
695: hr_utility.set_location(' Entering:' || l_proc,10);
696: hr_utility.set_location(' Entering:' || l_proc,10);
697: hr_utility.set_location(' Entering:' || l_proc,10);
698: l_count := 0;
699: l_cmpout_element_rec.comp_element_outcome_id :=
692: hr_utility.set_location(' p_transaction_step_id:' || p_transaction_step_id,10);
693: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
694: hr_utility.set_location(' Entering:' || l_proc,10);
695: hr_utility.set_location(' Entering:' || l_proc,10);
696: hr_utility.set_location(' Entering:' || l_proc,10);
697: hr_utility.set_location(' Entering:' || l_proc,10);
698: l_count := 0;
699: l_cmpout_element_rec.comp_element_outcome_id :=
700: hr_transaction_api.get_number_value
693: hr_utility.set_location(' p_competence_element_id:' || p_competence_element_id,10);
694: hr_utility.set_location(' Entering:' || l_proc,10);
695: hr_utility.set_location(' Entering:' || l_proc,10);
696: hr_utility.set_location(' Entering:' || l_proc,10);
697: hr_utility.set_location(' Entering:' || l_proc,10);
698: l_count := 0;
699: l_cmpout_element_rec.comp_element_outcome_id :=
700: hr_transaction_api.get_number_value
701: (p_transaction_step_id => p_transaction_step_id
738: ,p_name => 'P_UPGRADED_FROM_REC_ID');
739: --
740: /* IF l_system_generated = 'N' AND
741: l_upgraded_from_rec_id is not null THEN
742: hr_utility.set_location(' Entering:' || l_proc,20);
743: l_cmpout_element_rec.comp_element_outcome_id := null;
744: END IF;*/
745: --
746: -- set a savepoint before calling api
745: --
746: -- set a savepoint before calling api
747: --
748: IF (l_cmpout_element_rec.comp_element_outcome_id IS NULL OR l_cmpout_element_rec.comp_element_outcome_id = -1) then
749: hr_utility.set_location(' Entering: Inserting new record' || l_proc,30);
750: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
751: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
752: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
753: hr_utility.set_location(' l_cmpout_element_rec.outcome_id :' || l_cmpout_element_rec.outcome_id ,30);
746: -- set a savepoint before calling api
747: --
748: IF (l_cmpout_element_rec.comp_element_outcome_id IS NULL OR l_cmpout_element_rec.comp_element_outcome_id = -1) then
749: hr_utility.set_location(' Entering: Inserting new record' || l_proc,30);
750: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
751: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
752: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
753: hr_utility.set_location(' l_cmpout_element_rec.outcome_id :' || l_cmpout_element_rec.outcome_id ,30);
754: hr_utility.set_location(' l_cmpout_element_rec.date_from :' || l_cmpout_element_rec.date_from ,30);
747: --
748: IF (l_cmpout_element_rec.comp_element_outcome_id IS NULL OR l_cmpout_element_rec.comp_element_outcome_id = -1) then
749: hr_utility.set_location(' Entering: Inserting new record' || l_proc,30);
750: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
751: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
752: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
753: hr_utility.set_location(' l_cmpout_element_rec.outcome_id :' || l_cmpout_element_rec.outcome_id ,30);
754: hr_utility.set_location(' l_cmpout_element_rec.date_from :' || l_cmpout_element_rec.date_from ,30);
755: hr_utility.set_location(' l_cmpout_element_rec.date_to :' || l_cmpout_element_rec.date_to ,30);
748: IF (l_cmpout_element_rec.comp_element_outcome_id IS NULL OR l_cmpout_element_rec.comp_element_outcome_id = -1) then
749: hr_utility.set_location(' Entering: Inserting new record' || l_proc,30);
750: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
751: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
752: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
753: hr_utility.set_location(' l_cmpout_element_rec.outcome_id :' || l_cmpout_element_rec.outcome_id ,30);
754: hr_utility.set_location(' l_cmpout_element_rec.date_from :' || l_cmpout_element_rec.date_from ,30);
755: hr_utility.set_location(' l_cmpout_element_rec.date_to :' || l_cmpout_element_rec.date_to ,30);
756: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
749: hr_utility.set_location(' Entering: Inserting new record' || l_proc,30);
750: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
751: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
752: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
753: hr_utility.set_location(' l_cmpout_element_rec.outcome_id :' || l_cmpout_element_rec.outcome_id ,30);
754: hr_utility.set_location(' l_cmpout_element_rec.date_from :' || l_cmpout_element_rec.date_from ,30);
755: hr_utility.set_location(' l_cmpout_element_rec.date_to :' || l_cmpout_element_rec.date_to ,30);
756: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
757: per_ceo_ins.ins(
750: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
751: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
752: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
753: hr_utility.set_location(' l_cmpout_element_rec.outcome_id :' || l_cmpout_element_rec.outcome_id ,30);
754: hr_utility.set_location(' l_cmpout_element_rec.date_from :' || l_cmpout_element_rec.date_from ,30);
755: hr_utility.set_location(' l_cmpout_element_rec.date_to :' || l_cmpout_element_rec.date_to ,30);
756: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
757: per_ceo_ins.ins(
758: p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
751: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
752: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
753: hr_utility.set_location(' l_cmpout_element_rec.outcome_id :' || l_cmpout_element_rec.outcome_id ,30);
754: hr_utility.set_location(' l_cmpout_element_rec.date_from :' || l_cmpout_element_rec.date_from ,30);
755: hr_utility.set_location(' l_cmpout_element_rec.date_to :' || l_cmpout_element_rec.date_to ,30);
756: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
757: per_ceo_ins.ins(
758: p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
759: ,p_competence_element_id => p_competence_element_id
752: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
753: hr_utility.set_location(' l_cmpout_element_rec.outcome_id :' || l_cmpout_element_rec.outcome_id ,30);
754: hr_utility.set_location(' l_cmpout_element_rec.date_from :' || l_cmpout_element_rec.date_from ,30);
755: hr_utility.set_location(' l_cmpout_element_rec.date_to :' || l_cmpout_element_rec.date_to ,30);
756: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
757: per_ceo_ins.ins(
758: p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
759: ,p_competence_element_id => p_competence_element_id
760: ,p_object_version_number => l_cmpout_element_rec.object_version_number
769: rec.OUTCOME_ID = l_cmpout_element_rec.outcome_id and
770: rec.DATE_FROM = l_cmpout_element_rec.date_from and
771: ((rec.DATE_TO IS NULL AND l_cmpout_element_rec.date_to IS null) or
772: (rec.DATE_TO = l_cmpout_element_rec.date_to)) then
773: hr_utility.set_location(' Entering: in if record is same' || l_proc,30);
774: else
775: IF l_system_generated = 'Y' AND
776: l_cmpout_element_rec.competence_element_id = p_competence_element_id THEN
777: hr_utility.set_location(' Entering:' || l_proc,30);
773: hr_utility.set_location(' Entering: in if record is same' || l_proc,30);
774: else
775: IF l_system_generated = 'Y' AND
776: l_cmpout_element_rec.competence_element_id = p_competence_element_id THEN
777: hr_utility.set_location(' Entering:' || l_proc,30);
778: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
779: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
780: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
781: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
774: else
775: IF l_system_generated = 'Y' AND
776: l_cmpout_element_rec.competence_element_id = p_competence_element_id THEN
777: hr_utility.set_location(' Entering:' || l_proc,30);
778: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
779: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
780: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
781: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
782: -- IF rec.DATE_FROM < l_cmpout_element_rec.date_from then
775: IF l_system_generated = 'Y' AND
776: l_cmpout_element_rec.competence_element_id = p_competence_element_id THEN
777: hr_utility.set_location(' Entering:' || l_proc,30);
778: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
779: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
780: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
781: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
782: -- IF rec.DATE_FROM < l_cmpout_element_rec.date_from then
783: process_upd_api(p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
776: l_cmpout_element_rec.competence_element_id = p_competence_element_id THEN
777: hr_utility.set_location(' Entering:' || l_proc,30);
778: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
779: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
780: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
781: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
782: -- IF rec.DATE_FROM < l_cmpout_element_rec.date_from then
783: process_upd_api(p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
784: ,p_to_date => trunc(sysdate)
777: hr_utility.set_location(' Entering:' || l_proc,30);
778: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
779: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
780: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
781: hr_utility.set_location(' l_upgraded_from_rec_id :' || l_upgraded_from_rec_id ,30);
782: -- IF rec.DATE_FROM < l_cmpout_element_rec.date_from then
783: process_upd_api(p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
784: ,p_to_date => trunc(sysdate)
785: ,p_object_version_number => l_cmpout_element_rec.object_version_number);
800: ,p_effective_date => trunc(sysdate));
801: END if;
802: --*/
803: ELSIF l_cmpout_element_rec.competence_element_id = p_competence_element_id THEN
804: hr_utility.set_location(' Entering:' || l_proc,40);
805: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
806: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
807: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
808: hr_utility.set_location(' l_cmpout_element_rec.date_from:' || l_cmpout_element_rec.date_from,30);
801: END if;
802: --*/
803: ELSIF l_cmpout_element_rec.competence_element_id = p_competence_element_id THEN
804: hr_utility.set_location(' Entering:' || l_proc,40);
805: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
806: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
807: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
808: hr_utility.set_location(' l_cmpout_element_rec.date_from:' || l_cmpout_element_rec.date_from,30);
809: hr_utility.set_location(' l_upgraded_from_rec_id:' || l_upgraded_from_rec_id,30);
802: --*/
803: ELSIF l_cmpout_element_rec.competence_element_id = p_competence_element_id THEN
804: hr_utility.set_location(' Entering:' || l_proc,40);
805: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
806: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
807: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
808: hr_utility.set_location(' l_cmpout_element_rec.date_from:' || l_cmpout_element_rec.date_from,30);
809: hr_utility.set_location(' l_upgraded_from_rec_id:' || l_upgraded_from_rec_id,30);
810: hr_utility.set_location(' rec.DATE_FROM' || rec.DATE_FROM,40);
803: ELSIF l_cmpout_element_rec.competence_element_id = p_competence_element_id THEN
804: hr_utility.set_location(' Entering:' || l_proc,40);
805: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
806: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
807: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
808: hr_utility.set_location(' l_cmpout_element_rec.date_from:' || l_cmpout_element_rec.date_from,30);
809: hr_utility.set_location(' l_upgraded_from_rec_id:' || l_upgraded_from_rec_id,30);
810: hr_utility.set_location(' rec.DATE_FROM' || rec.DATE_FROM,40);
811: hr_utility.set_location(' l_cmpout_element_rec.date_from' || l_cmpout_element_rec.date_from,40);
804: hr_utility.set_location(' Entering:' || l_proc,40);
805: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
806: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
807: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
808: hr_utility.set_location(' l_cmpout_element_rec.date_from:' || l_cmpout_element_rec.date_from,30);
809: hr_utility.set_location(' l_upgraded_from_rec_id:' || l_upgraded_from_rec_id,30);
810: hr_utility.set_location(' rec.DATE_FROM' || rec.DATE_FROM,40);
811: hr_utility.set_location(' l_cmpout_element_rec.date_from' || l_cmpout_element_rec.date_from,40);
812: -- IF rec.DATE_FROM < l_cmpout_element_rec.date_from then
805: hr_utility.set_location(' l_cmpout_element_rec.comp_element_outcome_id:' || l_cmpout_element_rec.comp_element_outcome_id,30);
806: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
807: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
808: hr_utility.set_location(' l_cmpout_element_rec.date_from:' || l_cmpout_element_rec.date_from,30);
809: hr_utility.set_location(' l_upgraded_from_rec_id:' || l_upgraded_from_rec_id,30);
810: hr_utility.set_location(' rec.DATE_FROM' || rec.DATE_FROM,40);
811: hr_utility.set_location(' l_cmpout_element_rec.date_from' || l_cmpout_element_rec.date_from,40);
812: -- IF rec.DATE_FROM < l_cmpout_element_rec.date_from then
813: process_upd_api(p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
806: hr_utility.set_location(' l_cmpout_element_rec.object_version_number:' || l_cmpout_element_rec.object_version_number,30);
807: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
808: hr_utility.set_location(' l_cmpout_element_rec.date_from:' || l_cmpout_element_rec.date_from,30);
809: hr_utility.set_location(' l_upgraded_from_rec_id:' || l_upgraded_from_rec_id,30);
810: hr_utility.set_location(' rec.DATE_FROM' || rec.DATE_FROM,40);
811: hr_utility.set_location(' l_cmpout_element_rec.date_from' || l_cmpout_element_rec.date_from,40);
812: -- IF rec.DATE_FROM < l_cmpout_element_rec.date_from then
813: process_upd_api(p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
814: ,p_to_date => trunc(sysdate)
807: hr_utility.set_location(' l_cmpout_element_rec.date_to:' ||to_char(l_cmpout_element_rec.date_to,'DD-MON-YYYY'),30);
808: hr_utility.set_location(' l_cmpout_element_rec.date_from:' || l_cmpout_element_rec.date_from,30);
809: hr_utility.set_location(' l_upgraded_from_rec_id:' || l_upgraded_from_rec_id,30);
810: hr_utility.set_location(' rec.DATE_FROM' || rec.DATE_FROM,40);
811: hr_utility.set_location(' l_cmpout_element_rec.date_from' || l_cmpout_element_rec.date_from,40);
812: -- IF rec.DATE_FROM < l_cmpout_element_rec.date_from then
813: process_upd_api(p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
814: ,p_to_date => trunc(sysdate)
815: ,p_object_version_number => l_cmpout_element_rec.object_version_number);
830: ,p_effective_date => trunc(sysdate));
831: END if;*/
832: --
833: ELSE
834: hr_utility.set_location(' Entering:' || l_proc,50);
835: per_ceo_ins.ins(
836: p_comp_element_outcome_id => l_cmpout_element_rec.comp_element_outcome_id
837: ,p_competence_element_id => p_competence_element_id
838: ,p_object_version_number => l_cmpout_element_rec.object_version_number
846: END if;
847: --
848: --
849: Exception
850: When hr_utility.hr_error THEN
851: hr_utility.set_location(' Entering:' || l_proc,60);
852: rollback to save_comp_element_outcome;
853: IF NOT (l_upgraded_from_rec_id IS NOT NULL AND
854: hr_message.last_message_name = 'HR_51648_CEL_PER_DATES_OVLAP') THEN
847: --
848: --
849: Exception
850: When hr_utility.hr_error THEN
851: hr_utility.set_location(' Entering:' || l_proc,60);
852: rollback to save_comp_element_outcome;
853: IF NOT (l_upgraded_from_rec_id IS NOT NULL AND
854: hr_message.last_message_name = 'HR_51648_CEL_PER_DATES_OVLAP') THEN
855: hr_utility.set_location(' Entering:' || l_proc,70);
851: hr_utility.set_location(' Entering:' || l_proc,60);
852: rollback to save_comp_element_outcome;
853: IF NOT (l_upgraded_from_rec_id IS NOT NULL AND
854: hr_message.last_message_name = 'HR_51648_CEL_PER_DATES_OVLAP') THEN
855: hr_utility.set_location(' Entering:' || l_proc,70);
856: raise;
857: END IF;
858: --
859: When others THEN
856: raise;
857: END IF;
858: --
859: When others THEN
860: hr_utility.set_location(' Entering:' || l_proc,80);
861: raise;
862: --
863: End process_api;
864: --
874: x_to_date date;
875: l_proc varchar2(200) ;
876: begin
877: l_proc := g_package || 'process_upd_api';
878: hr_utility.set_location(' Entering:' || l_proc,10);
879: l_object_version_number := p_object_version_number;
880: IF p_to_date IS NULL then
881: x_to_date := trunc(sysdate);
882: else
946: l_out_dates_cur get_out_dates%RowType;
947: l_proc varchar2(200);
948: --
949: Begin
950: -- hr_utility.trace_on(null,'OUTCOME');
951: l_proc := g_package || 'api_validate_com_out_rec_ss';
952: hr_utility.set_location(' Entering:' || l_proc, 5);
953: IF (p_transaction_step_id = -1 ) then
954: hr_utility.set_location(' Entering:' || l_proc, 10);
948: --
949: Begin
950: -- hr_utility.trace_on(null,'OUTCOME');
951: l_proc := g_package || 'api_validate_com_out_rec_ss';
952: hr_utility.set_location(' Entering:' || l_proc, 5);
953: IF (p_transaction_step_id = -1 ) then
954: hr_utility.set_location(' Entering:' || l_proc, 10);
955: p_transaction_step_id := Null;
956: ENd IF;
950: -- hr_utility.trace_on(null,'OUTCOME');
951: l_proc := g_package || 'api_validate_com_out_rec_ss';
952: hr_utility.set_location(' Entering:' || l_proc, 5);
953: IF (p_transaction_step_id = -1 ) then
954: hr_utility.set_location(' Entering:' || l_proc, 10);
955: p_transaction_step_id := Null;
956: ENd IF;
957: --
958: IF p_comp_element_outcome_id IS not null then
955: p_transaction_step_id := Null;
956: ENd IF;
957: --
958: IF p_comp_element_outcome_id IS not null then
959: hr_utility.set_location(' Entering:' || l_proc,15);
960: x_comp_ele_out_Id := to_number(p_comp_element_outcome_id);
961: END if;
962: --
963: if p_competence_element_id IS not NULL then
960: x_comp_ele_out_Id := to_number(p_comp_element_outcome_id);
961: END if;
962: --
963: if p_competence_element_id IS not NULL then
964: hr_utility.set_location(' Entering:' || l_proc,20);
965: x_comp_ele_id := to_number(p_competence_element_id);
966: END if;
967: --
968: if p_competence_id IS not NULL then
965: x_comp_ele_id := to_number(p_competence_element_id);
966: END if;
967: --
968: if p_competence_id IS not NULL then
969: hr_utility.set_location(' Entering:' || l_proc,25);
970: x_comp_id := to_number(p_competence_id);
971: End if;
972: l_mode := p_change_mode;
973: IF (p_comp_element_outcome_id is not NULL) THEN
970: x_comp_id := to_number(p_competence_id);
971: End if;
972: l_mode := p_change_mode;
973: IF (p_comp_element_outcome_id is not NULL) THEN
974: hr_utility.set_location(' Entering:' || l_proc,30);
975: hr_comp_outcome_profile_ss.check_if_cmpocm_rec_changed
976: (p_comp_element_outcome_id => x_comp_ele_out_Id
977: ,p_competence_element_id => x_comp_ele_id
978: ,p_competence_id => x_comp_id
982: ,p_change_mode => p_change_mode
983: ,p_rec_changed => l_changed);
984: --
985: if l_changed = false THEN
986: hr_utility.set_location(' Entering:' || l_proc,35);
987: IF (p_transaction_step_id IS NOT Null) THEN
988: hr_utility.set_location(' Entering:' || l_proc,40);
989: delete_transaction_step_id(p_transaction_step_id);
990: END IF;
984: --
985: if l_changed = false THEN
986: hr_utility.set_location(' Entering:' || l_proc,35);
987: IF (p_transaction_step_id IS NOT Null) THEN
988: hr_utility.set_location(' Entering:' || l_proc,40);
989: delete_transaction_step_id(p_transaction_step_id);
990: END IF;
991: return; -- added on 17-Nov-2004
992: end if;
994: --
995: END IF;
996: --
997: IF ( p_date_from IS NULL OR to_date(p_date_from,g_date_format) IS null ) then
998: hr_utility.set_location(' Entering:' || l_proc,45);
999: p_error_message := 'HR_OUT_ELMT_DATE_INVL';
1000: --
1001: RETURN;
1002: --
1000: --
1001: RETURN;
1002: --
1003: END if;
1004: hr_utility.set_location(' Entering:' || l_proc,50);
1005: IF ( to_date(p_date_from,g_date_format) > trunc(sysdate) ) then
1006: hr_utility.set_location(' Entering:' || l_proc,55);
1007: p_error_message := 'HR_OUT_DT_ACHVD_INVL';
1008: --
1002: --
1003: END if;
1004: hr_utility.set_location(' Entering:' || l_proc,50);
1005: IF ( to_date(p_date_from,g_date_format) > trunc(sysdate) ) then
1006: hr_utility.set_location(' Entering:' || l_proc,55);
1007: p_error_message := 'HR_OUT_DT_ACHVD_INVL';
1008: --
1009: RETURN;
1010: --
1012: --
1013: OPEN get_out_dates(p_outcome_id => p_outcome_id);
1014: FETCH get_out_dates into l_out_dates_cur;
1015: IF get_out_dates%NOTFOUND THEN
1016: hr_utility.set_location(' Entering:' || l_proc,60);
1017: l_date_to := p_date_to;
1018: ELSE
1019: hr_utility.set_location(' Entering:' || l_proc,65);
1020: IF (l_out_dates_cur.start_date IS NOT NULL AND
1015: IF get_out_dates%NOTFOUND THEN
1016: hr_utility.set_location(' Entering:' || l_proc,60);
1017: l_date_to := p_date_to;
1018: ELSE
1019: hr_utility.set_location(' Entering:' || l_proc,65);
1020: IF (l_out_dates_cur.start_date IS NOT NULL AND
1021: l_out_dates_cur.start_date > to_date(p_date_from, g_date_format) ) THEN
1022: hr_utility.set_location(' Entering:' || l_proc,70);
1023: p_error_message := 'HR_OUT_DATE_INVL';
1018: ELSE
1019: hr_utility.set_location(' Entering:' || l_proc,65);
1020: IF (l_out_dates_cur.start_date IS NOT NULL AND
1021: l_out_dates_cur.start_date > to_date(p_date_from, g_date_format) ) THEN
1022: hr_utility.set_location(' Entering:' || l_proc,70);
1023: p_error_message := 'HR_OUT_DATE_INVL';
1024: CLOSE get_out_dates;
1025: RETURN;
1026: END IF;
1024: CLOSE get_out_dates;
1025: RETURN;
1026: END IF;
1027: IF p_date_to IS NULL THEN
1028: hr_utility.set_location(' Entering:' || l_proc,75);
1029: l_date_to := l_out_dates_cur.end_date;
1030: ELSIF (l_out_dates_cur.end_Date IS NOT NULL AND
1031: l_out_dates_cur.end_date < to_date(p_date_to, g_date_format) ) THEN
1032: p_error_message := 'HR_OUT_DATE_INVL';
1032: p_error_message := 'HR_OUT_DATE_INVL';
1033: CLOSE get_out_dates;
1034: RETURN;
1035: ELSE
1036: hr_utility.set_location(' Entering:' || l_proc,80);
1037: l_date_to := to_date(p_date_to, g_date_format);
1038: END IF;
1039: END IF ;
1040: IF p_comp_from_date IS NOT NULL then
1037: l_date_to := to_date(p_date_to, g_date_format);
1038: END IF;
1039: END IF ;
1040: IF p_comp_from_date IS NOT NULL then
1041: hr_utility.set_location(' Entering:' || l_proc,85);
1042: IF to_date(p_date_from,g_date_format) < to_date(p_comp_from_date,g_date_format) Then
1043: hr_utility.set_location(' Entering:' || l_proc,90);
1044: p_error_message := 'HR_OUT_ACHVD_DT_INVL';
1045: RETURN;
1039: END IF ;
1040: IF p_comp_from_date IS NOT NULL then
1041: hr_utility.set_location(' Entering:' || l_proc,85);
1042: IF to_date(p_date_from,g_date_format) < to_date(p_comp_from_date,g_date_format) Then
1043: hr_utility.set_location(' Entering:' || l_proc,90);
1044: p_error_message := 'HR_OUT_ACHVD_DT_INVL';
1045: RETURN;
1046: END if;
1047: --
1047: --
1048: END if;
1049: --
1050: IF p_comp_to_date IS NOT NULL OR trim(p_comp_to_date) <> '' then
1051: hr_utility.set_location(' Entering:' || l_proc,95);
1052: IF to_date(p_date_to,g_date_format) > to_date(p_comp_to_date,g_date_format) Then
1053: hr_utility.set_location(' Entering:' || l_proc,100);
1054: p_error_message := 'HR_OUT_ACHVD_DT_INVL';
1055: RETURN;
1049: --
1050: IF p_comp_to_date IS NOT NULL OR trim(p_comp_to_date) <> '' then
1051: hr_utility.set_location(' Entering:' || l_proc,95);
1052: IF to_date(p_date_to,g_date_format) > to_date(p_comp_to_date,g_date_format) Then
1053: hr_utility.set_location(' Entering:' || l_proc,100);
1054: p_error_message := 'HR_OUT_ACHVD_DT_INVL';
1055: RETURN;
1056: END if;
1057: --
1059: --
1060: IF get_out_dates%ISOPEN then
1061: CLOSE get_out_dates;
1062: END if;
1063: hr_utility.set_location(' Entering:' || l_proc,105);
1064: hr_utility.set_location(' Entering x_comp_ele_id :' || x_comp_ele_id,105);
1065: hr_utility.set_location(' Entering p_outcome_id :' || p_outcome_id,105);
1066: hr_utility.set_location(' Entering l_date_to :' || l_date_to,105);
1067: hr_utility.set_location(' Entering g_date_format :' || g_date_format,105);
1060: IF get_out_dates%ISOPEN then
1061: CLOSE get_out_dates;
1062: END if;
1063: hr_utility.set_location(' Entering:' || l_proc,105);
1064: hr_utility.set_location(' Entering x_comp_ele_id :' || x_comp_ele_id,105);
1065: hr_utility.set_location(' Entering p_outcome_id :' || p_outcome_id,105);
1066: hr_utility.set_location(' Entering l_date_to :' || l_date_to,105);
1067: hr_utility.set_location(' Entering g_date_format :' || g_date_format,105);
1068: hr_utility.set_location(' Entering p_date_from:' || p_date_from,105);
1061: CLOSE get_out_dates;
1062: END if;
1063: hr_utility.set_location(' Entering:' || l_proc,105);
1064: hr_utility.set_location(' Entering x_comp_ele_id :' || x_comp_ele_id,105);
1065: hr_utility.set_location(' Entering p_outcome_id :' || p_outcome_id,105);
1066: hr_utility.set_location(' Entering l_date_to :' || l_date_to,105);
1067: hr_utility.set_location(' Entering g_date_format :' || g_date_format,105);
1068: hr_utility.set_location(' Entering p_date_from:' || p_date_from,105);
1069: x_count :=0;
1062: END if;
1063: hr_utility.set_location(' Entering:' || l_proc,105);
1064: hr_utility.set_location(' Entering x_comp_ele_id :' || x_comp_ele_id,105);
1065: hr_utility.set_location(' Entering p_outcome_id :' || p_outcome_id,105);
1066: hr_utility.set_location(' Entering l_date_to :' || l_date_to,105);
1067: hr_utility.set_location(' Entering g_date_format :' || g_date_format,105);
1068: hr_utility.set_location(' Entering p_date_from:' || p_date_from,105);
1069: x_count :=0;
1070: IF x_comp_ele_out_id IS NULL then
1063: hr_utility.set_location(' Entering:' || l_proc,105);
1064: hr_utility.set_location(' Entering x_comp_ele_id :' || x_comp_ele_id,105);
1065: hr_utility.set_location(' Entering p_outcome_id :' || p_outcome_id,105);
1066: hr_utility.set_location(' Entering l_date_to :' || l_date_to,105);
1067: hr_utility.set_location(' Entering g_date_format :' || g_date_format,105);
1068: hr_utility.set_location(' Entering p_date_from:' || p_date_from,105);
1069: x_count :=0;
1070: IF x_comp_ele_out_id IS NULL then
1071: Select count(*) INTO x_count
1064: hr_utility.set_location(' Entering x_comp_ele_id :' || x_comp_ele_id,105);
1065: hr_utility.set_location(' Entering p_outcome_id :' || p_outcome_id,105);
1066: hr_utility.set_location(' Entering l_date_to :' || l_date_to,105);
1067: hr_utility.set_location(' Entering g_date_format :' || g_date_format,105);
1068: hr_utility.set_location(' Entering p_date_from:' || p_date_from,105);
1069: x_count :=0;
1070: IF x_comp_ele_out_id IS NULL then
1071: Select count(*) INTO x_count
1072: from per_comp_element_outcomes ceo
1083: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1084: and c.transaction_step_id = s.transaction_step_id
1085: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1086: AND C.NUMBER_VALUE = CEO.COMP_ELEMENT_OUTCOME_ID);
1087: hr_utility.set_location(' Entering x_count:' || x_count,107);
1088: IF x_count > 0 then
1089: hr_utility.set_location(' Entering:' || l_proc,107);
1090: -- changed for 4188407
1091: p_error_message := 'HR_449132_QUA_FWK_OUTCM_EXISTS';
1085: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1086: AND C.NUMBER_VALUE = CEO.COMP_ELEMENT_OUTCOME_ID);
1087: hr_utility.set_location(' Entering x_count:' || x_count,107);
1088: IF x_count > 0 then
1089: hr_utility.set_location(' Entering:' || l_proc,107);
1090: -- changed for 4188407
1091: p_error_message := 'HR_449132_QUA_FWK_OUTCM_EXISTS';
1092: --End changes for 4188407
1093: return;
1107: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1108: and c.transaction_step_id = s.transaction_step_id
1109: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1110: AND C.NUMBER_VALUE = CEO.COMP_ELEMENT_OUTCOME_ID);
1111: hr_utility.set_location(' Entering x_count:' || x_count,108);
1112: else
1113: Select count(*) INTO x_count
1114: from per_comp_element_outcomes ceo
1115: where competence_element_id = x_comp_ele_id
1125: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1126: and c.transaction_step_id = s.transaction_step_id
1127: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1128: AND C.NUMBER_VALUE = CEO.COMP_ELEMENT_OUTCOME_ID);
1129: hr_utility.set_location(' Entering x_count:' || x_count,109);
1130: END if; -- l_date_to IS NULL
1131: IF x_count > 0 then
1132: hr_utility.set_location(' Entering:' || l_proc,107);
1133: p_error_message := 'HR_OUT_DATE_INVL';
1128: AND C.NUMBER_VALUE = CEO.COMP_ELEMENT_OUTCOME_ID);
1129: hr_utility.set_location(' Entering x_count:' || x_count,109);
1130: END if; -- l_date_to IS NULL
1131: IF x_count > 0 then
1132: hr_utility.set_location(' Entering:' || l_proc,107);
1133: p_error_message := 'HR_OUT_DATE_INVL';
1134: return;
1135: END if;
1136: END IF; -- x_comp_ele_out_id IS NULL
1135: END if;
1136: END IF; -- x_comp_ele_out_id IS NULL
1137: --
1138: if x_comp_ele_out_Id is not null then
1139: hr_utility.set_location(' Entering:' || l_proc,110);
1140: OPEN get_prev_start_date(x_comp_ele_out_Id);
1141: FETCH get_prev_start_date into l_prev_date;
1142: -- IF get_prev_start_date%notfound THEN
1143: -- raise hr_comp_outcome_profile_ss.g_fatal_error;
1146: l_prev_start_date := l_prev_date;
1147: --
1148: end if;
1149: if p_transaction_step_id is not null then
1150: hr_utility.set_location(' Entering:' || l_proc,120);
1151: delete_transaction_step_id(p_transaction_step_id);
1152: p_transaction_step_id := null;
1153: end if;
1154: hr_utility.set_location(' Entering:' || l_proc,130);
1150: hr_utility.set_location(' Entering:' || l_proc,120);
1151: delete_transaction_step_id(p_transaction_step_id);
1152: p_transaction_step_id := null;
1153: end if;
1154: hr_utility.set_location(' Entering:' || l_proc,130);
1155: process_save(p_item_type => p_item_type
1156: ,p_item_key => p_item_key
1157: ,p_actid => p_activity_id
1158: ,p_change_mode => l_mode
1167: ,p_prev_start_date => to_char(l_prev_start_date,g_date_format)
1168: ,p_transaction_step_id => p_transaction_step_id
1169: ,p_person_id => p_person_id
1170: ,p_error_message => p_error_message);
1171: hr_utility.set_location(' Entering:' || l_proc,140);
1172: check_delete_rec(p_item_type => p_item_type
1173: ,p_item_key => p_item_key
1174: ,p_actid => p_activity_id
1175: ,p_person_id => p_person_id
1176: ,p_outcome_id => p_outcome_id);
1177: --
1178: Exception
1179: when g_invalid_entry then
1180: hr_utility.set_location(' Entering:' || l_proc,150);
1181: null;
1182: when others then
1183: hr_utility.set_location(' Entering:' || l_proc,160);
1184: raise g_invalid_entry;
1179: when g_invalid_entry then
1180: hr_utility.set_location(' Entering:' || l_proc,150);
1181: null;
1182: when others then
1183: hr_utility.set_location(' Entering:' || l_proc,160);
1184: raise g_invalid_entry;
1185: End api_validate_com_out_rec_ss;
1186: --
1187: -------------------------------------------------------------------------------
1281: l_count Number:=0;
1282: l_proc varchar2(200);
1283: BEGIN
1284: l_proc := g_package || 'save_transaction_step';
1285: hr_utility.set_location(' Entering:' || l_proc,10);
1286: l_count := p_transaction_data.COUNT;
1287: FOR i IN 1..l_count LOOP
1288: BEGIN
1289: IF p_transaction_data(i).param_data_type = 'DATE' THEN
1303: ,p_value => p_transaction_data(i).param_value);
1304: END IF;
1305: --
1306: Exception When others then
1307: hr_utility.set_location(' Entering:' || l_proc,100);
1308: RAISE hr_utility.hr_error;
1309: END;
1310: END LOOP;
1311: EXCEPTION
1304: END IF;
1305: --
1306: Exception When others then
1307: hr_utility.set_location(' Entering:' || l_proc,100);
1308: RAISE hr_utility.hr_error;
1309: END;
1310: END LOOP;
1311: EXCEPTION
1312: WHEN OTHERS THEN
1309: END;
1310: END LOOP;
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: hr_utility.set_location(' Entering:' || l_proc,110);
1314: hr_utility.trace('EXCEPTION SAVE_TRANSACTION_STEP'||'STS#');
1315: raise hr_utility.hr_error;
1316: END save_transaction_step;
1317: --
1310: END LOOP;
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: hr_utility.set_location(' Entering:' || l_proc,110);
1314: hr_utility.trace('EXCEPTION SAVE_TRANSACTION_STEP'||'STS#');
1315: raise hr_utility.hr_error;
1316: END save_transaction_step;
1317: --
1318: -----------------------------------
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: hr_utility.set_location(' Entering:' || l_proc,110);
1314: hr_utility.trace('EXCEPTION SAVE_TRANSACTION_STEP'||'STS#');
1315: raise hr_utility.hr_error;
1316: END save_transaction_step;
1317: --
1318: -----------------------------------
1319: PROCEDURE delete_all_ids
1404: l_proc varchar2(200) ;
1405: -------------
1406: begin
1407: l_proc := g_package || 'save_update_details';
1408: hr_utility.set_location(' Entering:' || l_proc,10);
1409: l_user_date_format := g_date_format;
1410: l_transaction_step_id := p_transaction_step_id;
1411: --
1412: OPEN get_prev_start_date(p_comp_element_outcome_id => p_comp_element_outcome_id);
1411: --
1412: OPEN get_prev_start_date(p_comp_element_outcome_id => p_comp_element_outcome_id);
1413: FETCH get_prev_start_date into l_prev_date;
1414: IF get_prev_start_date%notfound THEN
1415: hr_utility.set_location(' Entering:' || l_proc,20);
1416: close get_out_name;
1417: raise hr_comp_outcome_profile_ss.g_fatal_error;
1418: ELSE
1419: hr_utility.set_location(' Entering:' || l_proc,30);
1415: hr_utility.set_location(' Entering:' || l_proc,20);
1416: close get_out_name;
1417: raise hr_comp_outcome_profile_ss.g_fatal_error;
1418: ELSE
1419: hr_utility.set_location(' Entering:' || l_proc,30);
1420: CLOSE get_prev_start_date;
1421: END IF;
1422: --
1423: l_prev_start_date := l_prev_date;
1421: END IF;
1422: --
1423: l_prev_start_date := l_prev_date;
1424: --
1425: hr_utility.set_location(' Entering:' || l_proc,40);
1426: api_validate_compout_record
1427: (p_validate => true
1428: ,p_competence_element_id => p_competence_element_id
1429: ,p_outcome_id => p_outcome_id
1437: ,p_person_id => p_person_id
1438: ,p_error_message => p_error_message);
1439: --
1440: IF p_error_message is not null then
1441: hr_utility.set_location(' Entering:' || l_proc,50);
1442: Return;
1443: END IF;
1444: hr_utility.set_location(' Entering:' || l_proc,60);
1445: --
1440: IF p_error_message is not null then
1441: hr_utility.set_location(' Entering:' || l_proc,50);
1442: Return;
1443: END IF;
1444: hr_utility.set_location(' Entering:' || l_proc,60);
1445: --
1446: l_count := l_count + 1;
1447: l_trans_tbl(l_count).param_name := 'P_PREV_START_DATE';
1448: l_trans_tbl(l_count).param_value := to_char(l_prev_start_date,g_date_format);
1475: l_trans_tbl(l_count).param_value := p_outcome_id;
1476: l_trans_tbl(l_count).param_data_type := 'NUMBER';
1477: --
1478: -- End add
1479: hr_utility.set_location(' Entering:' || l_proc,70);
1480: save_transaction_step
1481: (p_item_type => p_item_type
1482: ,p_item_key => p_item_key
1483: ,p_actid => to_number(p_activity_id)
1486: ,p_transaction_data => l_trans_tbl);
1487: ------------------
1488: EXCEPTION
1489: when g_invalid_entry then
1490: hr_utility.set_location(' Entering:' || l_proc,80);
1491: raise g_invalid_entry;
1492: --
1493: when others then
1494: hr_utility.set_location(' Entering:' || l_proc,90);
1490: hr_utility.set_location(' Entering:' || l_proc,80);
1491: raise g_invalid_entry;
1492: --
1493: when others then
1494: hr_utility.set_location(' Entering:' || l_proc,90);
1495: raise g_invalid_entry;
1496: --
1497: end save_update_details;
1498: --
1543: l_proc varchar2(200);
1544: begin
1545: --
1546: l_proc := g_package || 'delete_add_page';
1547: hr_utility.set_location(' Entering:' || l_proc,10);
1548: FOR txnStepIds IN get_step_ids(p_transaction_step_id) loop
1549: --
1550: --
1551: delete from hr_api_transaction_values where transaction_step_id = txnStepIds.transaction_step_id;
1588: --
1589: l_proc := g_package || 'api_validate_compout_record';
1590: l_user_date_format :=g_date_format;
1591: Begin
1592: hr_utility.set_location(' Entering:' || l_proc,10);
1593: IF p_date_from is not null THEN
1594: hr_utility.set_location(' Entering:' || l_proc,20);
1595: l_date_from := to_date(p_date_from, l_user_date_format);
1596: END IF;
1590: l_user_date_format :=g_date_format;
1591: Begin
1592: hr_utility.set_location(' Entering:' || l_proc,10);
1593: IF p_date_from is not null THEN
1594: hr_utility.set_location(' Entering:' || l_proc,20);
1595: l_date_from := to_date(p_date_from, l_user_date_format);
1596: END IF;
1597: ---
1598: IF l_date_from > trunc(sysdate) THEN
1595: l_date_from := to_date(p_date_from, l_user_date_format);
1596: END IF;
1597: ---
1598: IF l_date_from > trunc(sysdate) THEN
1599: hr_utility.set_location(' Entering:' || l_proc,30);
1600: p_error_message := 'HR_WEB_DISALLOW_FUTURE_STARTDT';
1601: l_date_error := true;
1602: END IF;
1603: --
1602: END IF;
1603: --
1604: EXCEPTION
1605: When others then
1606: hr_utility.set_location(' Entering:' || l_proc,40);
1607: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
1608: (p_error_message => p_error_message,
1609: p_attr_name => 'DateFrom',
1610: p_app_short_name => 'PER',
1614: --
1615: Begin
1616: --
1617: IF p_date_to is not null THEN
1618: hr_utility.set_location(' Entering:' || l_proc,50);
1619: l_date_to := to_date(p_date_to, l_user_date_format);
1620: END IF;
1621: --
1622: IF l_date_from is not null then
1619: l_date_to := to_date(p_date_to, l_user_date_format);
1620: END IF;
1621: --
1622: IF l_date_from is not null then
1623: hr_utility.set_location(' Entering:' || l_proc,60);
1624: IF l_date_to < l_date_from THEN
1625: hr_utility.set_location(' Entering:' || l_proc,70);
1626: p_error_message := 'HR_WEB_CEL_DATES_INVL';
1627: l_date_error := true;
1621: --
1622: IF l_date_from is not null then
1623: hr_utility.set_location(' Entering:' || l_proc,60);
1624: IF l_date_to < l_date_from THEN
1625: hr_utility.set_location(' Entering:' || l_proc,70);
1626: p_error_message := 'HR_WEB_CEL_DATES_INVL';
1627: l_date_error := true;
1628: END IF;
1629: End IF;
1629: End IF;
1630: --
1631: EXCEPTION
1632: When others then
1633: hr_utility.set_location(' Entering:' || l_proc,80);
1634: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
1635: (p_error_message => p_error_message,
1636: p_attr_name => 'EndDate',
1637: p_app_short_name => 'PER',
1647: --
1648: savepoint validate_output_rec;
1649: --
1650: IF l_date_error THEN
1651: hr_utility.set_location(' Entering:' || l_proc,90);
1652: goto finish_processing;
1653: END IF;
1654: --
1655: -- UPGRADE
1653: END IF;
1654: --
1655: -- UPGRADE
1656: IF p_comp_element_outcome_id IS NOT null THEN
1657: hr_utility.set_location(' Entering:' || l_proc,100);
1658: l_object_version_number := p_preupd_obj_vers_num;
1659: per_ceo_upd.upd(p_comp_element_outcome_id => p_comp_element_outcome_id
1660: ,p_competence_element_id => p_competence_element_id
1661: ,p_outcome_id => p_outcome_id
1664: ,p_date_to => l_date_to
1665: ,p_effective_date => trunc(sysdate));
1666: --
1667: ELSE -- Add New Record Mode
1668: hr_utility.set_location(' Entering:' || l_proc,110);
1669: per_ceo_ins.ins(p_comp_element_outcome_id => l_new_comp_element_outcome_id
1670: ,p_competence_element_id => p_competence_element_id
1671: ,p_object_version_number => l_new_obj_vers_num
1672: ,p_outcome_id => p_outcome_id
1675: ,p_effective_date => trunc(sysdate));
1676: END IF;
1677: --
1678: IF p_validate = true THEN
1679: hr_utility.set_location(' Entering:' || l_proc,120);
1680: rollback to validate_output_rec;
1681: END IF;
1682: --
1683: --
1683: --
1684: <
1685: --
1686: if l_date_error then
1687: hr_utility.set_location(' Entering:' || l_proc,130);
1688: rollback to validate_output_rec;
1689: end if;
1690: --
1691: p_date_from_date_type := l_date_from;
1692: p_date_to_date_type := l_date_to;
1693: --
1694: EXCEPTION
1695: When g_invalid_entry then
1696: hr_utility.set_location(' Entering:' || l_proc,140);
1697: rollback to validate_output_rec;
1698: When others then
1699: hr_utility.set_location(' Entering:' || l_proc,150);
1700: rollback to validate_output_rec;
1695: When g_invalid_entry then
1696: hr_utility.set_location(' Entering:' || l_proc,140);
1697: rollback to validate_output_rec;
1698: When others then
1699: hr_utility.set_location(' Entering:' || l_proc,150);
1700: rollback to validate_output_rec;
1701: --
1702: End api_validate_compout_record;
1703: --
1736: --
1737: --
1738: Begin
1739: l_proc := g_package || 'check_if_cmpocm_rec_changed';
1740: hr_utility.set_location(' Entering:' || l_proc,10);
1741: l_changed := false;
1742: --
1743: --
1744: FOR l_preupd_rec IN csr_get_preupd_cmpocm_rec LOOP
1741: l_changed := false;
1742: --
1743: --
1744: FOR l_preupd_rec IN csr_get_preupd_cmpocm_rec LOOP
1745: hr_utility.set_location(' Entering:' || l_proc || ' in loop for ',20);
1746: IF l_preupd_rec.outcome_id = p_outcome_id AND l_preupd_rec.competence_element_id = p_competence_element_id THEN
1747: null;
1748: ELSE
1749: raise hr_comp_outcome_profile_ss.g_fatal_error;
1781: END IF;
1782: --
1783: --
1784: END LOOP;
1785: hr_utility.set_location(' Entering:' || l_proc || ' out of loop ',90);
1786: --
1787: p_rec_changed := l_changed;
1788: -- p_warning_exists := l_warning_exists;
1789: --
1788: -- p_warning_exists := l_warning_exists;
1789: --
1790: Exception
1791: When others then
1792: hr_utility.set_location(' Entering:' || l_proc ,100);
1793: raise;
1794: --
1795: End check_if_cmpocm_rec_changed;
1796: ----------------
1810: l_transaction_step_id Number DEFAULT null;
1811: l_proc varchar2(200);
1812: begin
1813: l_proc := g_package || 'mark_for_delete';
1814: hr_utility.set_location(' Entering:' || l_proc ,10);
1815: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => p_item_type
1816: ,p_item_key => p_item_key);
1817: --
1818: IF l_transaction_id is null THEN
1815: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => p_item_type
1816: ,p_item_key => p_item_key);
1817: --
1818: IF l_transaction_id is null THEN
1819: hr_utility.set_location(' Entering:' || l_proc ,20);
1820: -- Start a Transaction
1821: hr_transaction_ss.start_transaction
1822: (itemtype => p_item_type
1823: ,itemkey => p_item_key
1824: ,actid => to_number(p_activity_id)
1825: ,funmode => 'RUN'
1826: ,p_login_person_id => fnd_global.employee_id
1827: ,result => l_result);
1828: hr_utility.set_location(' Entering:' || l_proc ,30);
1829: l_transaction_id := hr_transaction_ss.get_transaction_id
1830: (p_item_type => p_item_type
1831: ,p_item_key => p_item_key);
1832: END IF;
1830: (p_item_type => p_item_type
1831: ,p_item_key => p_item_key);
1832: END IF;
1833: If p_transaction_step_id is NULL OR p_transaction_step_id = '-1' then
1834: hr_utility.set_location(' Entering:' || l_proc ,40);
1835: hr_transaction_api.create_transaction_step
1836: (p_validate => false
1837: ,p_creator_person_id => fnd_global.employee_id
1838: ,p_transaction_id => l_transaction_id
1842: ,p_activity_id => p_activity_id
1843: ,p_transaction_step_id => l_transaction_step_id
1844: ,p_object_version_number => x_trans_ovn);
1845: else
1846: hr_utility.set_location(' Entering:' || l_proc ,50);
1847: l_transaction_step_id := p_transaction_step_id;
1848: End if;
1849: hr_utility.set_location(' Entering:' || l_proc ,60);
1850: l_count := 1;
1845: else
1846: hr_utility.set_location(' Entering:' || l_proc ,50);
1847: l_transaction_step_id := p_transaction_step_id;
1848: End if;
1849: hr_utility.set_location(' Entering:' || l_proc ,60);
1850: l_count := 1;
1851: l_trans_tbl(l_count).param_name := 'P_COMP_ELEMENT_OUTCOME_ID';
1852: l_trans_tbl(l_count).param_value := p_comp_element_outcome_id;
1853: l_trans_tbl(l_count).param_data_type := 'NUMBER';
1871: l_txn_step_id hr_api_transaction_steps.transaction_step_id%type;
1872: l_proc varchar2(200);
1873: begin
1874: l_proc := g_package || 'check_delete_rec';
1875: hr_utility.set_location(' Entering:' || l_proc ,10);
1876: SELECT s.transaction_step_id INTO l_txn_step_id
1877: FROM hr_api_transaction_steps S,
1878: hr_api_transaction_values C,
1879: per_comp_element_outcomes ceo,
1888: AND ceo.Competence_Element_id = pce.competence_element_id
1889: AND pce.PERSON_ID = p_person_id
1890: AND ceo.comp_element_outcome_id = C.number_value;
1891: IF l_txn_step_id IS NOT NULL then
1892: hr_utility.set_location(' Entering:' || l_proc ,20);
1893: delete_transaction_step_id(l_txn_step_id);
1894: END if;
1895: --
1896: EXCEPTION
1894: END if;
1895: --
1896: EXCEPTION
1897: When NO_DATA_FOUND then
1898: hr_utility.set_location(' Entering:' || l_proc ,30);
1899: null;
1900: When OTHERS then
1901: hr_utility.set_location(' Entering:' || l_proc ,40);
1902: raise;
1897: When NO_DATA_FOUND then
1898: hr_utility.set_location(' Entering:' || l_proc ,30);
1899: null;
1900: When OTHERS then
1901: hr_utility.set_location(' Entering:' || l_proc ,40);
1902: raise;
1903: /**
1904: --
1905: */
1918: l_proc varchar2(200);
1919: Begin
1920: p_rec_changed := false;
1921: l_proc := g_package || 'check_if_cmptnce_rec_changed';
1922: hr_utility.set_location(' Entering:' || l_proc ,10);
1923: hr_utility.set_location(' Entering p_item_type :' || p_item_type ,10);
1924: hr_utility.set_location(' Entering p_item_key :' || p_item_key ,10);
1925: hr_utility.set_location(' Entering p_activity_id :' || p_activity_id ,10);
1926: hr_utility.set_location(' Entering p_pid :' || p_pid ,10);
1919: Begin
1920: p_rec_changed := false;
1921: l_proc := g_package || 'check_if_cmptnce_rec_changed';
1922: hr_utility.set_location(' Entering:' || l_proc ,10);
1923: hr_utility.set_location(' Entering p_item_type :' || p_item_type ,10);
1924: hr_utility.set_location(' Entering p_item_key :' || p_item_key ,10);
1925: hr_utility.set_location(' Entering p_activity_id :' || p_activity_id ,10);
1926: hr_utility.set_location(' Entering p_pid :' || p_pid ,10);
1927: hr_utility.set_location(' Entering p_competence_element_id :' || p_competence_element_id ,10);
1920: p_rec_changed := false;
1921: l_proc := g_package || 'check_if_cmptnce_rec_changed';
1922: hr_utility.set_location(' Entering:' || l_proc ,10);
1923: hr_utility.set_location(' Entering p_item_type :' || p_item_type ,10);
1924: hr_utility.set_location(' Entering p_item_key :' || p_item_key ,10);
1925: hr_utility.set_location(' Entering p_activity_id :' || p_activity_id ,10);
1926: hr_utility.set_location(' Entering p_pid :' || p_pid ,10);
1927: hr_utility.set_location(' Entering p_competence_element_id :' || p_competence_element_id ,10);
1928: hr_utility.set_location(' Entering p_competence_id :' || p_competence_id ,10);
1921: l_proc := g_package || 'check_if_cmptnce_rec_changed';
1922: hr_utility.set_location(' Entering:' || l_proc ,10);
1923: hr_utility.set_location(' Entering p_item_type :' || p_item_type ,10);
1924: hr_utility.set_location(' Entering p_item_key :' || p_item_key ,10);
1925: hr_utility.set_location(' Entering p_activity_id :' || p_activity_id ,10);
1926: hr_utility.set_location(' Entering p_pid :' || p_pid ,10);
1927: hr_utility.set_location(' Entering p_competence_element_id :' || p_competence_element_id ,10);
1928: hr_utility.set_location(' Entering p_competence_id :' || p_competence_id ,10);
1929: Select Count(*) INTO l_count
1922: hr_utility.set_location(' Entering:' || l_proc ,10);
1923: hr_utility.set_location(' Entering p_item_type :' || p_item_type ,10);
1924: hr_utility.set_location(' Entering p_item_key :' || p_item_key ,10);
1925: hr_utility.set_location(' Entering p_activity_id :' || p_activity_id ,10);
1926: hr_utility.set_location(' Entering p_pid :' || p_pid ,10);
1927: hr_utility.set_location(' Entering p_competence_element_id :' || p_competence_element_id ,10);
1928: hr_utility.set_location(' Entering p_competence_id :' || p_competence_id ,10);
1929: Select Count(*) INTO l_count
1930: FROM hr_api_transaction_steps s, per_competence_outcomes_vl co,
1923: hr_utility.set_location(' Entering p_item_type :' || p_item_type ,10);
1924: hr_utility.set_location(' Entering p_item_key :' || p_item_key ,10);
1925: hr_utility.set_location(' Entering p_activity_id :' || p_activity_id ,10);
1926: hr_utility.set_location(' Entering p_pid :' || p_pid ,10);
1927: hr_utility.set_location(' Entering p_competence_element_id :' || p_competence_element_id ,10);
1928: hr_utility.set_location(' Entering p_competence_id :' || p_competence_id ,10);
1929: Select Count(*) INTO l_count
1930: FROM hr_api_transaction_steps s, per_competence_outcomes_vl co,
1931: hr_api_transaction_values a, hr_api_transaction_values b,
1924: hr_utility.set_location(' Entering p_item_key :' || p_item_key ,10);
1925: hr_utility.set_location(' Entering p_activity_id :' || p_activity_id ,10);
1926: hr_utility.set_location(' Entering p_pid :' || p_pid ,10);
1927: hr_utility.set_location(' Entering p_competence_element_id :' || p_competence_element_id ,10);
1928: hr_utility.set_location(' Entering p_competence_id :' || p_competence_id ,10);
1929: Select Count(*) INTO l_count
1930: FROM hr_api_transaction_steps s, per_competence_outcomes_vl co,
1931: hr_api_transaction_values a, hr_api_transaction_values b,
1932: hr_api_transaction_values c, hr_api_transaction_values p
1949: and p.transaction_step_id = s.transaction_step_id
1950: and p.name = 'P_PERSON_ID'
1951: and p.Number_Value = p_pid;
1952: IF l_count > 0 then
1953: hr_utility.set_location(' Entering:' || l_proc ,20);
1954: p_rec_changed := true;
1955: END if;
1956: hr_utility.set_location(' Entering:' || l_proc ,30);
1957: SELECT COUNT(*) INTO l_count
1952: IF l_count > 0 then
1953: hr_utility.set_location(' Entering:' || l_proc ,20);
1954: p_rec_changed := true;
1955: END if;
1956: hr_utility.set_location(' Entering:' || l_proc ,30);
1957: SELECT COUNT(*) INTO l_count
1958: FROM hr_api_transaction_steps S,
1959: hr_api_transaction_values C,
1960: per_comp_element_outcomes ceo
1966: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1967: AND ceo.Competence_Element_id = p_competence_element_id
1968: AND ceo.comp_element_outcome_id = C.number_value;
1969: IF l_count > 0 then
1970: hr_utility.set_location(' Entering:' || l_proc ,40);
1971: p_rec_changed := true;
1972: END if;
1973: --
1974: EXCEPTION
1972: END if;
1973: --
1974: EXCEPTION
1975: When OTHERS then
1976: hr_utility.set_location(' Entering:' || l_proc ,50);
1977: raise;
1978: END check_if_cmptnce_rec_changed;
1979: Procedure delete(p_validate in boolean default false
1980: ,p_transaction_step_id in number