APPS.GHR_MTI_INT dependencies on GHR_MT_PEOPLE_F_V

Line 27: function ck_parameter_list(p_person_row in ghr_mt_people_f_v%rowtype)

23: return l_message;
24:
25: end report_state;
26:
27: function ck_parameter_list(p_person_row in ghr_mt_people_f_v%rowtype)
28: return boolean is
29: l_proc varchar2(72) := g_package||'ck_parameter_list';
30:
31: begin

Line 61: update ghr_mt_people_f_v

57:
58: hr_utility.set_location('Entering:'||l_proc, 10);
59:
60: -- update interface table to indicate result of transfer
61: update ghr_mt_people_f_v
62: set mt_status = p_status_code
63: where mt_name = p_transfer_name
64: and last_name = p_last_name
65: and mt_person_id = p_person_id;

Line 348: p_tran ghr_mt_people_f_v%rowtype,

344: p_transfer_name varchar2,
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';

Line 446: 'mt_person_id from ghr_mt_people_f_v');

442: ghr_mto_int.put_line('Missing required data for transfer in');
443: ghr_mto_int.log_message(
444: p_procedure => l_proc_name,
445: p_message => 'Missing last_name and/or '||
446: 'mt_person_id from ghr_mt_people_f_v');
447:
448: -- so message gets into the log, since the caller rollsback on error
449: commit;
450:

Line 880: -- For all rows in ghr_mt_people_f_v where mt_status = 'Y' and

876:
877: end transfer_person_in;
878:
879: --
880: -- For all rows in ghr_mt_people_f_v where mt_status = 'Y' and
881: -- name = ghr_mass_transfers.name do the following:
882: -- 1. create an applicant
883: -- 2. accept the applicant
884: -- 3. copy information from the row into person and person analysis

Line 887: -- Last name and person_id must exist in ghr_mt_people_f_v for each person

883: -- 2. accept the applicant
884: -- 3. copy information from the row into person and person analysis
885: -- ddf's
886: --
887: -- Last name and person_id must exist in ghr_mt_people_f_v for each person
888: -- transfered in. Last name is required by create_us_applicant()
889: -- and person_id is necessary to differentiate between like named people
890: -- when setting the mt_status column to the transfer result (P or E)
891: --

Line 896: -- Ghr_mt_people_f_v.mt_status is set to 'P' for each successful

892: -- All rows in the interface table pertaining to a person in a transfer
893: -- group (l_transfer_name) must contain the same mt_person_id. This
894: -- is used to query data from the interface table.
895: --
896: -- Ghr_mt_people_f_v.mt_status is set to 'P' for each successful
897: -- transfer and set to 'E' if an error was encountered. The
898: -- transfer name, last_name, and national_identifier (ssn) is
899: -- expected to be unique.
900: --

Line 919: l_person_row ghr_mt_people_f_v%rowtype;

915: l_person_type_mti per_person_types.user_person_type%type;
916: l_person_type_mti_id per_person_types.person_type_id%type;
917: l_transfer_name ghr_mass_transfers.name%type;
918: l_effective_date ghr_mass_transfers.effective_date%type;
919: l_person_row ghr_mt_people_f_v%rowtype;
920: l_result varchar2(1);
921: l_person_id per_people_f.person_id%type;
922: l_inter_bg_transfer varchar2(1);
923:

Line 951: -- Rows in ghr_mt_people_f_v with mt_status of 'Y' have been

947: and l_effective_date
948: between a.effective_start_date and a.effective_end_date;
949:
950:
951: -- Rows in ghr_mt_people_f_v with mt_status of 'Y' have been
952: -- selected for transfer in
953: cursor cur_people is
954: select *
955: from ghr_mt_people_f_v

Line 955: from ghr_mt_people_f_v

951: -- Rows in ghr_mt_people_f_v with mt_status of 'Y' have been
952: -- selected for transfer in
953: cursor cur_people is
954: select *
955: from ghr_mt_people_f_v
956: where mt_name = l_transfer_name
957: and mt_status = 'Y';
958:
959: begin