APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on PER_ALL_PEOPLE_F

Line 144: txn_owner_person_id in per_all_people_f.person_id%TYPE,

140:
141: PROCEDURE MassScoreCardTransfer
142: ( score_card_list IN VARCHAR2 DEFAULT null,
143: sc_ovn_list IN VARCHAR2 DEFAULT null,
144: txn_owner_person_id in per_all_people_f.person_id%TYPE,
145: comments in varchar2,
146: result_code out nocopy VARCHAR2 )
147: IS
148: cursor get_person_name(p_person_id per_all_people_f.person_id%TYPE)

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

144: txn_owner_person_id in per_all_people_f.person_id%TYPE,
145: comments in varchar2,
146: result_code out nocopy VARCHAR2 )
147: IS
148: cursor get_person_name(p_person_id per_all_people_f.person_id%TYPE)
149: is
150: select global_name from per_people_f
151: where person_id = p_person_id
152: and trunc(sysdate) between effective_start_date and effective_end_date;

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

150: select global_name from per_people_f
151: where person_id = p_person_id
152: and trunc(sysdate) between effective_start_date and effective_end_date;
153:
154: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)
155: is
156: select name from wf_roles
157: where orig_system_id = p_person_id
158: and orig_system = 'PER';

Line 163: mgr_name per_all_people_f.global_name%TYPE;

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

Line 331: per_all_people_f people, wf_roles wf

327: cursor get_score_card_role(p_score_card_id in number)
328: IS
329: select wf.name wf_role, people.global_name emp_name, sc.scorecard_name, sc.plan_id
330: from per_personal_scorecards sc, per_all_assignments_f asgn,
331: per_all_people_f people, wf_roles wf
332: where sc.scorecard_id = p_score_card_id
333: and asgn.assignment_id = sc.assignment_id
334: and sysdate between asgn.effective_start_date and asgn.effective_end_date
335: and asgn.person_id = people.person_id

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

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

Line 366: score_card_emp_name per_all_people_f.global_name%TYPE;

362: api_return_ovn number default null;
363: score_card_wf_role wf_local_roles.name%TYPE;
364: log_message varchar2(5000) default null;
365: score_card_performer wf_local_roles.name%TYPE;
366: score_card_emp_name per_all_people_f.global_name%TYPE;
367: score_card_txn_id number default null;
368: l_error_log varchar2(20000);
369: score_card_name per_personal_scorecards.scorecard_name%TYPE;
370: txn_owner_person_id per_all_people_f.person_id%TYPE;

Line 370: txn_owner_person_id per_all_people_f.person_id%TYPE;

366: score_card_emp_name per_all_people_f.global_name%TYPE;
367: score_card_txn_id number default null;
368: l_error_log varchar2(20000);
369: score_card_name per_personal_scorecards.scorecard_name%TYPE;
370: txn_owner_person_id per_all_people_f.person_id%TYPE;
371: temp varchar2(2000);
372: l_duplsicate_name_warning boolean;
373: l_proc varchar2(72) := g_package || 'PROCESS_SCORE_CARD';
374: l_score_card_plan_id per_personal_scorecards.plan_id%TYPE;