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 7173: p_offer_assignment_rec in per_all_assignments_f%rowtype) ----bug 4621751 irec2

7169: p_lmt_prpnip_by_org_flag in varchar2 default 'N',
7170: p_abs_historical_mode in varchar2 default 'N',
7171: p_cbr_tmprl_evt_flag in varchar2 default 'N',
7172: p_assignment_id in number default null,
7173: p_offer_assignment_rec in per_all_assignments_f%rowtype) ----bug 4621751 irec2
7174: is
7175: --
7176: l_retcode number;
7177: l_errbuf varchar2(1000);

Line 7184: from per_all_assignments_F ass

7180:
7181: --
7182: cursor c_irec_ass_rec is
7183: select ass.*
7184: from per_all_assignments_F ass
7185: where assignment_id = p_assignment_id
7186: and to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS') between ass.effective_start_date
7187: and ass.effective_end_date;
7188:

Line 7191: from per_all_assignments_F ass

7187: and ass.effective_end_date;
7188:
7189: cursor c_irec_ass_rec_upd is
7190: select ass.*
7191: from per_all_assignments_F ass
7192: where assignment_id = p_assignment_id
7193: and to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS') between ass.effective_start_date
7194: and ass.effective_end_date;
7195:

Line 7211: -- 2. update per_all_assignments_F with p_offer_assignment_rec

7207: --
7208: -- Populate global assignment record of the applicant being processed
7209: -- by BENMNGLE in mode I into g_irec_ass_rec
7210: -- irec2 : 1. copy c_irec_ass_rec to g_irec_old_ass_rec
7211: -- 2. update per_all_assignments_F with p_offer_assignment_rec
7212: open c_irec_ass_rec;
7213: --
7214: fetch c_irec_ass_rec into ben_manage_life_events.g_irec_old_ass_rec; -- irec2
7215: if c_irec_ass_rec%notfound then

Line 7226: update per_all_assignments_F

7222: begin
7223: l_old_data_migrator_mode := hr_general.g_data_migrator_mode ;
7224: hr_general.g_data_migrator_mode := 'Y' ;
7225: -- update starts
7226: update per_all_assignments_F
7227: set
7228: BUSINESS_GROUP_ID = p_offer_assignment_rec.BUSINESS_GROUP_ID
7229: ,RECRUITER_ID = p_offer_assignment_rec.RECRUITER_ID
7230: ,GRADE_ID = p_offer_assignment_rec.GRADE_ID

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

7338: -- Bug 10350428: Added the date condition in above update statement
7339: -- update ends
7340: hr_general.g_data_migrator_mode := l_old_data_migrator_mode ;
7341:
7342: -- move updated per_all_assignments_f record to g_irec_ass_rec.
7343: open c_irec_ass_rec_upd;
7344: fetch c_irec_ass_rec_upd into g_irec_ass_rec;
7345: close c_irec_ass_rec_upd;
7346:

Line 8933: l_ass_rec per_all_assignments_f%rowtype;

8929: --
8930: l_package varchar2(80);
8931: l_output_string nvarchar2(100);
8932: l_per_rec per_all_people_f%rowtype;
8933: l_ass_rec per_all_assignments_f%rowtype;
8934: l_bus_rec per_business_groups%rowtype;
8935: l_org_rec hr_all_organization_units%rowtype;
8936: l_org2_rec hr_all_organization_units%rowtype;
8937: l_pad_rec per_addresses%rowtype;

Line 9119: l_ass_rec per_all_assignments_f%ROWTYPE;

9115: --
9116: l_package VARCHAR2 (80);
9117: l_output_string NVARCHAR2 (100);
9118: l_per_rec per_all_people_f%ROWTYPE;
9119: l_ass_rec per_all_assignments_f%ROWTYPE;
9120: l_bus_rec per_business_groups%ROWTYPE;
9121: l_org_rec hr_all_organization_units%ROWTYPE;
9122: l_org2_rec hr_all_organization_units%ROWTYPE;
9123: l_pad_rec per_addresses%ROWTYPE;

Line 10355: l_empasg_row per_all_assignments_f%rowtype;

10351: l_paropt_row ben_cobj_cache.g_opt_inst_row;
10352: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;
10353: l_per_row per_all_people_F%rowtype;
10354: l_pil_row ben_per_in_ler%rowtype;
10355: l_empasg_row per_all_assignments_f%rowtype;
10356: l_benasg_row per_all_assignments_f%rowtype;
10357: l_appasg_row ben_person_object.g_cache_ass_table;
10358: l_empasgast_row per_assignment_status_types%rowtype;
10359: l_benasgast_row per_assignment_status_types%rowtype;

Line 10356: l_benasg_row per_all_assignments_f%rowtype;

10352: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;
10353: l_per_row per_all_people_F%rowtype;
10354: l_pil_row ben_per_in_ler%rowtype;
10355: l_empasg_row per_all_assignments_f%rowtype;
10356: l_benasg_row per_all_assignments_f%rowtype;
10357: l_appasg_row ben_person_object.g_cache_ass_table;
10358: l_empasgast_row per_assignment_status_types%rowtype;
10359: l_benasgast_row per_assignment_status_types%rowtype;
10360: --

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

12940: ,p_effective_date => p_effective_date
12941: );
12942: --
12943: end if;
12944: -- bug 4621751 irec2 updating per_all_assignments_f with g_irec_old_ass_rec
12945: if l_mode = 'I' then
12946: begin
12947: -- dbms_output.put_line('*** G_IREC_OLD_ASS_REC.assignment_id '||G_IREC_OLD_ASS_REC.assignment_id);
12948: ben_irc_util.post_irec_process_update

Line 12958: update per_all_assignments_F

12954: l_old_data_migrator_mode := hr_general.g_data_migrator_mode ;
12955: hr_general.g_data_migrator_mode := 'Y' ;
12956:
12957: -- update starts
12958: update per_all_assignments_F
12959: set
12960: BUSINESS_GROUP_ID = G_IREC_OLD_ASS_REC.BUSINESS_GROUP_ID
12961: ,RECRUITER_ID = G_IREC_OLD_ASS_REC.RECRUITER_ID
12962: ,GRADE_ID = G_IREC_OLD_ASS_REC.GRADE_ID