eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MTI_INT dependencies on PER_PEOPLE_F

Line 349: p_person_id out NOCOPY per_people_f.person_id%type,

345: p_business_group_id number,
346: p_person_type_id number,
347: p_effective_date date,
348: p_tran ghr_mt_people_f_v%rowtype,
349: p_person_id out NOCOPY per_people_f.person_id%type,
350: p_result out NOCOPY varchar2) is
351:
352: l_proc_name varchar2(30) := 'transfer_person_in';
353: l_proc varchar2(72) := g_package||l_proc_name;

Line 359: l_applicant_number per_people_f.applicant_number%type;

355: l_accept_date date;
356: l_message varchar2(1000);
357:
358: -- out parameters for create_us_applicant
359: l_applicant_number per_people_f.applicant_number%type;
360: l_person_id per_people_f.person_id%type;
361: -- Bug#3718167 Added variable l_exists_full_name
362: l_exists_full_name per_people_f.full_name%type;
363: l_exists_person_id per_people_f.person_id%type;

Line 360: l_person_id per_people_f.person_id%type;

356: l_message varchar2(1000);
357:
358: -- out parameters for create_us_applicant
359: l_applicant_number per_people_f.applicant_number%type;
360: l_person_id per_people_f.person_id%type;
361: -- Bug#3718167 Added variable l_exists_full_name
362: l_exists_full_name per_people_f.full_name%type;
363: l_exists_person_id per_people_f.person_id%type;
364: l_assignment_id number;

Line 362: l_exists_full_name per_people_f.full_name%type;

358: -- out parameters for create_us_applicant
359: l_applicant_number per_people_f.applicant_number%type;
360: l_person_id per_people_f.person_id%type;
361: -- Bug#3718167 Added variable l_exists_full_name
362: l_exists_full_name per_people_f.full_name%type;
363: l_exists_person_id per_people_f.person_id%type;
364: l_assignment_id number;
365: l_assignment_status_type_id number; ---AVR
366: l_address_id number;

Line 363: l_exists_person_id per_people_f.person_id%type;

359: l_applicant_number per_people_f.applicant_number%type;
360: l_person_id per_people_f.person_id%type;
361: -- Bug#3718167 Added variable l_exists_full_name
362: l_exists_full_name per_people_f.full_name%type;
363: l_exists_person_id per_people_f.person_id%type;
364: l_assignment_id number;
365: l_assignment_status_type_id number; ---AVR
366: l_address_id number;
367: l_application_id number;

Line 373: l_full_name per_people_f.full_name%type;

369: l_asg_object_version_number number;
370: l_apl_object_version_number number;
371: l_per_effective_start_date date;
372: l_per_effective_end_date date;
373: l_full_name per_people_f.full_name%type;
374: l_per_comment_id number;
375: l_assignment_sequence number;
376: l_name_combination_warning boolean;
377: l_orig_hire_warning boolean;

Line 429: from per_people_f

425:
426: -- Bug#3718167 Added full_name in the selection
427: cursor cur_person_exists is
428: select person_id, full_name
429: from per_people_f
430: where national_identifier = p_tran.national_identifier
431: and business_group_id = p_business_group_id
432: and p_effective_date
433: between effective_start_date and effective_end_date;

Line 918: l_person_id per_people_f.person_id%type;

914: l_transfer_name ghr_mass_transfers.name%type;
915: l_effective_date ghr_mass_transfers.effective_date%type;
916: l_person_row ghr_mt_people_f_v%rowtype;
917: l_result varchar2(1);
918: l_person_id per_people_f.person_id%type;
919: l_inter_bg_transfer varchar2(1);
920:
921: l_error_count number := 0;
922: l_transfer_count number := 0;