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_CWB_POST_PROCESS dependencies on BEN_CWB_ASG_UPDATE

Line 46: * 19-Feb-03 maagrawa 115.13 Make calls to ben_cwb_asg_update to

42: * full table scan.
43: * 03-Sep-02 maagrawa 115.11 Added new procedures for promotion
44: * and performance rating updates.
45: * 08-Nov-02 aprabhak 115.12 Included the changes for itemization.
46: * 19-Feb-03 maagrawa 115.13 Make calls to ben_cwb_asg_update to
47: * update performance and promotions.
48: * 05-Feb-03 aprabhak 115.14 Fixed 2815207
49: * 11-Mar-03 pbodla 115.15 Changes for : 2695023 - When pay proposal
50: * is created link it to associated

Line 3980: l_perf_txn ben_cwb_asg_update.g_txn%ROWTYPE;

3976: l_assignment_extra_info_id NUMBER;
3977: l_cache_cwb_rpt_person g_cache_cwb_rpt_person_rec;
3978: l_bg_and_mgr_name c_bg_and_mgr_name%ROWTYPE;
3979: l_amount NUMBER := NULL;
3980: l_perf_txn ben_cwb_asg_update.g_txn%ROWTYPE;
3981: l_asg_txn ben_cwb_asg_update.g_txn%ROWTYPE;
3982: l_rate_ovn c_rate_ovn%ROWTYPE;
3983: l_grp_ovn c_grp_ovn%ROWTYPE;
3984: l_emp_num_and_emp_name c_emp_num_and_emp_name%ROWTYPE;

Line 3981: l_asg_txn ben_cwb_asg_update.g_txn%ROWTYPE;

3977: l_cache_cwb_rpt_person g_cache_cwb_rpt_person_rec;
3978: l_bg_and_mgr_name c_bg_and_mgr_name%ROWTYPE;
3979: l_amount NUMBER := NULL;
3980: l_perf_txn ben_cwb_asg_update.g_txn%ROWTYPE;
3981: l_asg_txn ben_cwb_asg_update.g_txn%ROWTYPE;
3982: l_rate_ovn c_rate_ovn%ROWTYPE;
3983: l_grp_ovn c_grp_ovn%ROWTYPE;
3984: l_emp_num_and_emp_name c_emp_num_and_emp_name%ROWTYPE;
3985: l_rating_status VARCHAR2 (200);

Line 4114: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,

4110:
4111: END IF;
4112:
4113: if l_perf_revw_strt_dt is not null then
4114: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4115: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
4116: ||l_interview_typ_cd);
4117:
4118: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;

Line 4115: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')

4111: END IF;
4112:
4113: if l_perf_revw_strt_dt is not null then
4114: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4115: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
4116: ||l_interview_typ_cd);
4117:
4118: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;
4119: CLOSE ben_cwb_asg_update.g_txn;

Line 4118: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;

4114: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4115: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
4116: ||l_interview_typ_cd);
4117:
4118: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;
4119: CLOSE ben_cwb_asg_update.g_txn;
4120: end if;
4121:
4122: if l_asg_updt_eff_date is not null then

Line 4119: CLOSE ben_cwb_asg_update.g_txn;

4115: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
4116: ||l_interview_typ_cd);
4117:
4118: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;
4119: CLOSE ben_cwb_asg_update.g_txn;
4120: end if;
4121:
4122: if l_asg_updt_eff_date is not null then
4123: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,

Line 4123: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,

4119: CLOSE ben_cwb_asg_update.g_txn;
4120: end if;
4121:
4122: if l_asg_updt_eff_date is not null then
4123: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4124: ben_cwb_asg_update.g_ws_asg_rec_type||to_char(l_asg_updt_eff_date, 'yyyy/mm/dd'));
4125:
4126: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;
4127: CLOSE ben_cwb_asg_update.g_txn;

Line 4124: ben_cwb_asg_update.g_ws_asg_rec_type||to_char(l_asg_updt_eff_date, 'yyyy/mm/dd'));

4120: end if;
4121:
4122: if l_asg_updt_eff_date is not null then
4123: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4124: ben_cwb_asg_update.g_ws_asg_rec_type||to_char(l_asg_updt_eff_date, 'yyyy/mm/dd'));
4125:
4126: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;
4127: CLOSE ben_cwb_asg_update.g_txn;
4128: end if;

Line 4126: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;

4122: if l_asg_updt_eff_date is not null then
4123: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4124: ben_cwb_asg_update.g_ws_asg_rec_type||to_char(l_asg_updt_eff_date, 'yyyy/mm/dd'));
4125:
4126: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;
4127: CLOSE ben_cwb_asg_update.g_txn;
4128: end if;
4129:
4130: IF l_asg_txn.assignment_id is not null or l_perf_txn.assignment_id IS NOT NULL THEN

Line 4127: CLOSE ben_cwb_asg_update.g_txn;

4123: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4124: ben_cwb_asg_update.g_ws_asg_rec_type||to_char(l_asg_updt_eff_date, 'yyyy/mm/dd'));
4125:
4126: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;
4127: CLOSE ben_cwb_asg_update.g_txn;
4128: end if;
4129:
4130: IF l_asg_txn.assignment_id is not null or l_perf_txn.assignment_id IS NOT NULL THEN
4131: --

Line 4187: ben_cwb_asg_update.process_rating (p_person_id => p_person_id

4183: if(l_error) then
4184: fnd_message.raise_error;
4185: end if;
4186:
4187: ben_cwb_asg_update.process_rating (p_person_id => p_person_id
4188: , p_txn_rec => l_perf_txn
4189: , p_business_group_id => l_emp_num_and_emp_name.business_group_id
4190: , p_audit_log => p_audit_log
4191: , p_process_status => l_rating_status

Line 4282: ben_cwb_asg_update.g_ws_asg_rec_type

4278: l_promo_person_rec.prior_grade := l_prior_assignment_dtls.grade;
4279: l_promo_person_rec.prior_group := l_prior_assignment_dtls.group_name;
4280:
4281: OPEN c_proposed_promotions(to_number(l_emp_num_and_emp_name.assignment_id),
4282: ben_cwb_asg_update.g_ws_asg_rec_type
4283: ||l_asg_txn.attribute1);
4284: FETCH c_proposed_promotions into l_proposed_promotions;
4285: CLOSE c_proposed_promotions;
4286: WRITE(ben_cwb_asg_update.g_ws_asg_rec_type||l_asg_txn.attribute1);

Line 4286: WRITE(ben_cwb_asg_update.g_ws_asg_rec_type||l_asg_txn.attribute1);

4282: ben_cwb_asg_update.g_ws_asg_rec_type
4283: ||l_asg_txn.attribute1);
4284: FETCH c_proposed_promotions into l_proposed_promotions;
4285: CLOSE c_proposed_promotions;
4286: WRITE(ben_cwb_asg_update.g_ws_asg_rec_type||l_asg_txn.attribute1);
4287:
4288: l_promo_person_rec.proposed_job := l_proposed_promotions.job;
4289: l_promo_person_rec.proposed_position := l_proposed_promotions.position;
4290: l_promo_person_rec.proposed_grade := l_proposed_promotions.grade;

Line 4360: ben_cwb_asg_update.process_promotions (p_person_id => p_person_id

4356: if(l_error) then
4357: fnd_message.raise_error;
4358: end if;
4359:
4360: ben_cwb_asg_update.process_promotions (p_person_id => p_person_id
4361: , p_asg_txn_rec => l_asg_txn
4362: , p_business_group_id => l_emp_num_and_emp_name.business_group_id
4363: , p_audit_log => p_audit_log
4364: , p_process_status => l_promotion_status