[Home] [Help]
224: --
225: PROCEDURE process_attachments(p_transaction_id IN NUMBER) IS
226: CURSOR csr_clob(p_transaction_id IN NUMBER) IS
227: SELECT transaction_document
228: FROM hr_api_transactions
229: WHERE transaction_id = p_transaction_id;
230: txnClob CLOB;
231: txnXml xmldom.DOMElement;
232: nl xmldom.DOMNodeList;
457: fetch get_score_cards into l_sc_id, l_sc_ovn;
458: close get_score_cards;
459: if( l_sc_id is not null ) then
460: hr_personal_scorecard_swi.update_scorecard_status
461: (p_validate => hr_Api.g_false_num
462: ,p_effective_date => trunc(sysdate) -- to be
463: ,p_scorecard_id => l_sc_id
464: ,p_object_version_number => l_sc_ovn
465: ,p_status_code => 'TRANSFER'
495: api_return_status := null;
496:
497: --dbms_output.put_line( ' processing score_card_list.scorecard_id ');
498: hr_personal_scorecard_swi.update_scorecard_status
499: (p_validate => hr_Api.g_false_num
500: ,p_effective_date => trunc(sysdate) -- to be
501: ,p_scorecard_id => score_card_list.scorecard_id
502: ,p_object_version_number => l_temp_ovn
503: ,p_status_code => 'TRANSFER'
550: where orig_system_id = p_person_id
551: and orig_system = 'PER';
552:
553: item_key_number number;
554: item_key hr_api_transactions.item_key%type default '';
555: item_type hr_api_transactions.item_type%type default 'HRWPM';
556: mgr_name per_all_people_f.global_name%TYPE;
557: mgr_role wf_local_roles.name%TYPE;
558:
551: and orig_system = 'PER';
552:
553: item_key_number number;
554: item_key hr_api_transactions.item_key%type default '';
555: item_type hr_api_transactions.item_type%type default 'HRWPM';
556: mgr_name per_all_people_f.global_name%TYPE;
557: mgr_role wf_local_roles.name%TYPE;
558:
559: l_sc_latest_ovn_list varchar2(1000) default null;
731: and trunc(sysdate) between people.effective_start_date and people.effective_end_date;
732: -- to be see that the cursor retreives only one id
733: cursor get_score_card_txn(p_score_card_id number, txn_owner per_all_people_f.person_id%TYPE)
734: IS
735: select transaction_id from hr_api_transactions
736: where transaction_ref_id = p_score_card_id
737: and transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
738: and creator_person_id = txn_owner;
739:
815: savepoint start_process_scorecard;
816:
817: if( score_card_txn_id is null) then
818: hr_personal_scorecard_swi.update_scorecard_status
819: (p_validate => hr_Api.g_false_num
820: ,p_effective_date => trunc(sysdate) -- to be
821: ,p_scorecard_id => to_number(next_score_card)
822: ,p_object_version_number => next_sc_ovn
823: ,p_status_code => 'WKR'
833: */
834:
835: api_return_status := hr_transaction_swi.commit_transaction(
836: p_transaction_id => score_card_txn_id,
837: p_validate => hr_Api.g_false_num);
838: end if;
839:
840:
841: --dbms_output.put_line(' *** api_return_status *** ' || api_return_status);
857: if ( api_return_status = 'E' ) then
858: rollback to start_process_scorecard;
859:
860: hr_personal_scorecard_swi.update_scorecard_status
861: (p_validate => hr_Api.g_false_num
862: ,p_effective_date => trunc(sysdate) -- to be
863: ,p_scorecard_id => to_number(next_score_card)
864: ,p_object_version_number => next_sc_ovn
865: ,p_status_code => 'ERROR'
919:
920: begin
921:
922: hr_personal_scorecard_swi.update_scorecard_status
923: (p_validate => hr_Api.g_false_num
924: ,p_effective_date => trunc(sysdate) -- to be
925: ,p_scorecard_id => to_number(next_score_card)
926: ,p_object_version_number => next_sc_ovn
927: ,p_status_code => 'WKR'
942: p_object_version_number => next_sc_ovn,
943: p_error_log => l_error_log,
944: p_duplicate_name_warning => l_duplsicate_name_warning);
945:
946: hr_transaction_swi.delete_transaction(score_card_txn_id,hr_Api.g_false_num);
947:
948: exception when others then
949:
950: for i in 1 .. fnd_msg_pub.count_msg Loop