APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on PER_ALL_PEOPLE_F

Line 537: txn_owner_person_id in per_all_people_f.person_id%TYPE,

533:
534: PROCEDURE MassScoreCardTransfer
535: ( score_card_list IN VARCHAR2 DEFAULT null,
536: sc_ovn_list IN VARCHAR2 DEFAULT null,
537: txn_owner_person_id in per_all_people_f.person_id%TYPE,
538: comments in varchar2,
539: result_code out nocopy VARCHAR2 )
540: IS
541: cursor get_person_name(p_person_id per_all_people_f.person_id%TYPE)

Line 541: cursor get_person_name(p_person_id per_all_people_f.person_id%TYPE)

537: txn_owner_person_id in per_all_people_f.person_id%TYPE,
538: comments in varchar2,
539: result_code out nocopy VARCHAR2 )
540: IS
541: cursor get_person_name(p_person_id per_all_people_f.person_id%TYPE)
542: is
543: select global_name from per_people_f
544: where person_id = p_person_id
545: and trunc(sysdate) between effective_start_date and effective_end_date;

Line 547: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)

543: select global_name from per_people_f
544: where person_id = p_person_id
545: and trunc(sysdate) between effective_start_date and effective_end_date;
546:
547: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)
548: is
549: select name from wf_roles
550: where orig_system_id = p_person_id
551: and orig_system = 'PER';

Line 556: mgr_name per_all_people_f.global_name%TYPE;

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;
560: BEGIN

Line 724: per_all_people_f people, wf_roles wf

720: cursor get_score_card_role(p_score_card_id in number)
721: IS
722: select wf.name wf_role, people.global_name emp_name, sc.scorecard_name, sc.plan_id
723: from per_personal_scorecards sc, per_all_assignments_f asgn,
724: per_all_people_f people, wf_roles wf
725: where sc.scorecard_id = p_score_card_id
726: and asgn.assignment_id = sc.assignment_id
727: and trunc(sysdate) between asgn.effective_start_date and asgn.effective_end_date
728: and asgn.person_id = people.person_id

Line 733: cursor get_score_card_txn(p_score_card_id number, txn_owner per_all_people_f.person_id%TYPE)

729: and wf.orig_system_id = people.person_id
730: and wf.orig_system = 'PER'
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'

Line 759: score_card_emp_name per_all_people_f.global_name%TYPE;

755: api_return_ovn number default null;
756: score_card_wf_role wf_local_roles.name%TYPE;
757: log_message varchar2(5000) default null;
758: score_card_performer wf_local_roles.name%TYPE;
759: score_card_emp_name per_all_people_f.global_name%TYPE;
760: score_card_txn_id number default null;
761: l_error_log varchar2(20000);
762: score_card_name per_personal_scorecards.scorecard_name%TYPE;
763: txn_owner_person_id per_all_people_f.person_id%TYPE;

Line 763: txn_owner_person_id per_all_people_f.person_id%TYPE;

759: score_card_emp_name per_all_people_f.global_name%TYPE;
760: score_card_txn_id number default null;
761: l_error_log varchar2(20000);
762: score_card_name per_personal_scorecards.scorecard_name%TYPE;
763: txn_owner_person_id per_all_people_f.person_id%TYPE;
764: temp varchar2(2000);
765: l_duplsicate_name_warning boolean;
766: l_proc varchar2(72) := g_package || 'PROCESS_SCORE_CARD';
767: l_score_card_plan_id per_personal_scorecards.plan_id%TYPE;