[Home] [Help]
64: fetch get_score_cards into l_sc_id, l_sc_ovn;
65: close get_score_cards;
66: if( l_sc_id is not null ) then
67: hr_personal_scorecard_swi.update_scorecard_status
68: (p_validate => hr_Api.g_false_num
69: ,p_effective_date => trunc(sysdate) -- to be
70: ,p_scorecard_id => l_sc_id
71: ,p_object_version_number => l_sc_ovn
72: ,p_status_code => 'TRANSFER'
102: api_return_status := null;
103:
104: --dbms_output.put_line( ' processing score_card_list.scorecard_id ');
105: hr_personal_scorecard_swi.update_scorecard_status
106: (p_validate => hr_Api.g_false_num
107: ,p_effective_date => trunc(sysdate) -- to be
108: ,p_scorecard_id => score_card_list.scorecard_id
109: ,p_object_version_number => l_temp_ovn
110: ,p_status_code => 'TRANSFER'
157: where orig_system_id = p_person_id
158: and orig_system = 'PER';
159:
160: item_key_number number;
161: item_key hr_api_transactions.item_key%type default '';
162: item_type hr_api_transactions.item_type%type default 'HRWPM';
163: mgr_name per_all_people_f.global_name%TYPE;
164: mgr_role wf_local_roles.name%TYPE;
165:
158: and orig_system = 'PER';
159:
160: item_key_number number;
161: item_key hr_api_transactions.item_key%type default '';
162: item_type hr_api_transactions.item_type%type default 'HRWPM';
163: mgr_name per_all_people_f.global_name%TYPE;
164: mgr_role wf_local_roles.name%TYPE;
165:
166: l_sc_latest_ovn_list varchar2(1000) default null;
338: and sysdate between people.effective_start_date and people.effective_end_date;
339: -- to be see that the cursor retreives only one id
340: cursor get_score_card_txn(p_score_card_id number, txn_owner per_all_people_f.person_id%TYPE)
341: IS
342: select transaction_id from hr_api_transactions
343: where transaction_ref_id = p_score_card_id
344: and transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
345: and creator_person_id = txn_owner;
346:
421: savepoint start_process_scorecard;
422:
423: if( score_card_txn_id is null) then
424: hr_personal_scorecard_swi.update_scorecard_status
425: (p_validate => hr_Api.g_false_num
426: ,p_effective_date => trunc(sysdate) -- to be
427: ,p_scorecard_id => to_number(next_score_card)
428: ,p_object_version_number => next_sc_ovn
429: ,p_status_code => 'WKR'
439: */
440:
441: api_return_status := hr_transaction_swi.commit_transaction(
442: p_transaction_id => score_card_txn_id,
443: p_validate => hr_Api.g_false_num);
444: end if;
445:
446:
447: --dbms_output.put_line(' *** api_return_status *** ' || api_return_status);
463: if ( api_return_status = 'E' ) then
464: rollback to start_process_scorecard;
465:
466: hr_personal_scorecard_swi.update_scorecard_status
467: (p_validate => hr_Api.g_false_num
468: ,p_effective_date => trunc(sysdate) -- to be
469: ,p_scorecard_id => to_number(next_score_card)
470: ,p_object_version_number => next_sc_ovn
471: ,p_status_code => 'ERROR'
525:
526: begin
527:
528: hr_personal_scorecard_swi.update_scorecard_status
529: (p_validate => hr_Api.g_false_num
530: ,p_effective_date => trunc(sysdate) -- to be
531: ,p_scorecard_id => to_number(next_score_card)
532: ,p_object_version_number => next_sc_ovn
533: ,p_status_code => 'WKR'
539: p_object_version_number => next_sc_ovn,
540: p_error_log => l_error_log,
541: p_duplicate_name_warning => l_duplsicate_name_warning);
542:
543: hr_transaction_swi.delete_transaction(score_card_txn_id,hr_Api.g_false_num);
544:
545: exception when others then
546:
547: for i in 1 .. fnd_msg_pub.count_msg Loop