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.BEN_MANAGE_LIFE_EVENTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 6770: p_offer_assignment_rec in per_all_assignments_f%rowtype) ----bug 4621751 irec2

6766: p_lmt_prpnip_by_org_flag in varchar2 default 'N',
6767: p_abs_historical_mode in varchar2 default 'N',
6768: p_cbr_tmprl_evt_flag in varchar2 default 'N',
6769: p_assignment_id in number default null,
6770: p_offer_assignment_rec in per_all_assignments_f%rowtype) ----bug 4621751 irec2
6771: is
6772: --
6773: l_retcode number;
6774: l_errbuf varchar2(1000);

Line 6781: from per_all_assignments_F ass

6777:
6778: --
6779: cursor c_irec_ass_rec is
6780: select ass.*
6781: from per_all_assignments_F ass
6782: where assignment_id = p_assignment_id
6783: and to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS') between ass.effective_start_date
6784: and ass.effective_end_date;
6785:

Line 6788: from per_all_assignments_F ass

6784: and ass.effective_end_date;
6785:
6786: cursor c_irec_ass_rec_upd is
6787: select ass.*
6788: from per_all_assignments_F ass
6789: where assignment_id = p_assignment_id
6790: and to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS') between ass.effective_start_date
6791: and ass.effective_end_date;
6792:

Line 6808: -- 2. update per_all_assignments_F with p_offer_assignment_rec

6804: --
6805: -- Populate global assignment record of the applicant being processed
6806: -- by BENMNGLE in mode I into g_irec_ass_rec
6807: -- irec2 : 1. copy c_irec_ass_rec to g_irec_old_ass_rec
6808: -- 2. update per_all_assignments_F with p_offer_assignment_rec
6809: open c_irec_ass_rec;
6810: --
6811: fetch c_irec_ass_rec into ben_manage_life_events.g_irec_old_ass_rec; -- irec2
6812: if c_irec_ass_rec%notfound then

Line 6823: update per_all_assignments_F

6819: begin
6820: l_old_data_migrator_mode := hr_general.g_data_migrator_mode ;
6821: hr_general.g_data_migrator_mode := 'Y' ;
6822: -- update starts
6823: update per_all_assignments_F
6824: set
6825: BUSINESS_GROUP_ID = p_offer_assignment_rec.BUSINESS_GROUP_ID
6826: ,RECRUITER_ID = p_offer_assignment_rec.RECRUITER_ID
6827: ,GRADE_ID = p_offer_assignment_rec.GRADE_ID

Line 6936: -- move updated per_all_assignments_f record to g_irec_ass_rec.

6932: where assignment_id = p_assignment_id ;
6933: -- update ends
6934: hr_general.g_data_migrator_mode := l_old_data_migrator_mode ;
6935:
6936: -- move updated per_all_assignments_f record to g_irec_ass_rec.
6937: open c_irec_ass_rec_upd;
6938: fetch c_irec_ass_rec_upd into g_irec_ass_rec;
6939: close c_irec_ass_rec_upd;
6940:

Line 8525: l_ass_rec per_all_assignments_f%rowtype;

8521: --
8522: l_package varchar2(80);
8523: l_output_string varchar2(100);
8524: l_per_rec per_all_people_f%rowtype;
8525: l_ass_rec per_all_assignments_f%rowtype;
8526: l_bus_rec per_business_groups%rowtype;
8527: l_org_rec hr_all_organization_units%rowtype;
8528: l_org2_rec hr_all_organization_units%rowtype;
8529: l_pad_rec per_addresses%rowtype;

Line 8711: l_ass_rec per_all_assignments_f%ROWTYPE;

8707: --
8708: l_package VARCHAR2 (80);
8709: l_output_string VARCHAR2 (100);
8710: l_per_rec per_all_people_f%ROWTYPE;
8711: l_ass_rec per_all_assignments_f%ROWTYPE;
8712: l_bus_rec per_business_groups%ROWTYPE;
8713: l_org_rec hr_all_organization_units%ROWTYPE;
8714: l_org2_rec hr_all_organization_units%ROWTYPE;
8715: l_pad_rec per_addresses%ROWTYPE;

Line 9899: l_empasg_row per_all_assignments_f%rowtype;

9895: l_paropt_row ben_cobj_cache.g_opt_inst_row;
9896: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;
9897: l_per_row per_all_people_F%rowtype;
9898: l_pil_row ben_per_in_ler%rowtype;
9899: l_empasg_row per_all_assignments_f%rowtype;
9900: l_benasg_row per_all_assignments_f%rowtype;
9901: l_appasg_row ben_person_object.g_cache_ass_table;
9902: l_empasgast_row per_assignment_status_types%rowtype;
9903: l_benasgast_row per_assignment_status_types%rowtype;

Line 9900: l_benasg_row per_all_assignments_f%rowtype;

9896: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;
9897: l_per_row per_all_people_F%rowtype;
9898: l_pil_row ben_per_in_ler%rowtype;
9899: l_empasg_row per_all_assignments_f%rowtype;
9900: l_benasg_row per_all_assignments_f%rowtype;
9901: l_appasg_row ben_person_object.g_cache_ass_table;
9902: l_empasgast_row per_assignment_status_types%rowtype;
9903: l_benasgast_row per_assignment_status_types%rowtype;
9904: --

Line 12326: -- bug 4621751 irec2 updating per_all_assignments_f with g_irec_old_ass_rec

12322: ,p_effective_date => p_effective_date
12323: );
12324: --
12325: end if;
12326: -- bug 4621751 irec2 updating per_all_assignments_f with g_irec_old_ass_rec
12327: if l_mode = 'I' then
12328: begin
12329: -- dbms_output.put_line('*** G_IREC_OLD_ASS_REC.assignment_id '||G_IREC_OLD_ASS_REC.assignment_id);
12330: ben_irc_util.post_irec_process_update

Line 12340: update per_all_assignments_F

12336: l_old_data_migrator_mode := hr_general.g_data_migrator_mode ;
12337: hr_general.g_data_migrator_mode := 'Y' ;
12338:
12339: -- update starts
12340: update per_all_assignments_F
12341: set
12342: BUSINESS_GROUP_ID = G_IREC_OLD_ASS_REC.BUSINESS_GROUP_ID
12343: ,RECRUITER_ID = G_IREC_OLD_ASS_REC.RECRUITER_ID
12344: ,GRADE_ID = G_IREC_OLD_ASS_REC.GRADE_ID