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 3918: l_perf_txn ben_cwb_asg_update.g_txn%ROWTYPE;

3914: l_assignment_extra_info_id NUMBER;
3915: l_cache_cwb_rpt_person g_cache_cwb_rpt_person_rec;
3916: l_bg_and_mgr_name c_bg_and_mgr_name%ROWTYPE;
3917: l_amount NUMBER := NULL;
3918: l_perf_txn ben_cwb_asg_update.g_txn%ROWTYPE;
3919: l_asg_txn ben_cwb_asg_update.g_txn%ROWTYPE;
3920: l_rate_ovn c_rate_ovn%ROWTYPE;
3921: l_grp_ovn c_grp_ovn%ROWTYPE;
3922: l_emp_num_and_emp_name c_emp_num_and_emp_name%ROWTYPE;

Line 3919: l_asg_txn ben_cwb_asg_update.g_txn%ROWTYPE;

3915: l_cache_cwb_rpt_person g_cache_cwb_rpt_person_rec;
3916: l_bg_and_mgr_name c_bg_and_mgr_name%ROWTYPE;
3917: l_amount NUMBER := NULL;
3918: l_perf_txn ben_cwb_asg_update.g_txn%ROWTYPE;
3919: l_asg_txn ben_cwb_asg_update.g_txn%ROWTYPE;
3920: l_rate_ovn c_rate_ovn%ROWTYPE;
3921: l_grp_ovn c_grp_ovn%ROWTYPE;
3922: l_emp_num_and_emp_name c_emp_num_and_emp_name%ROWTYPE;
3923: l_rating_status VARCHAR2 (200);

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

4036: g_person_errored := TRUE;
4037: END;
4038:
4039: if l_perf_revw_strt_dt is not null then
4040: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4041: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
4042: ||l_interview_typ_cd);
4043:
4044: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;

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

4037: END;
4038:
4039: if l_perf_revw_strt_dt is not null then
4040: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4041: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
4042: ||l_interview_typ_cd);
4043:
4044: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;
4045: CLOSE ben_cwb_asg_update.g_txn;

Line 4044: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;

4040: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4041: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
4042: ||l_interview_typ_cd);
4043:
4044: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;
4045: CLOSE ben_cwb_asg_update.g_txn;
4046: end if;
4047:
4048: if l_asg_updt_eff_date is not null then

Line 4045: CLOSE ben_cwb_asg_update.g_txn;

4041: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
4042: ||l_interview_typ_cd);
4043:
4044: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;
4045: CLOSE ben_cwb_asg_update.g_txn;
4046: end if;
4047:
4048: if l_asg_updt_eff_date is not null then
4049: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,

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

4045: CLOSE ben_cwb_asg_update.g_txn;
4046: end if;
4047:
4048: if l_asg_updt_eff_date is not null then
4049: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4050: ben_cwb_asg_update.g_ws_asg_rec_type||to_char(l_asg_updt_eff_date, 'yyyy/mm/dd'));
4051:
4052: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;
4053: CLOSE ben_cwb_asg_update.g_txn;

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

4046: end if;
4047:
4048: if l_asg_updt_eff_date is not null then
4049: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4050: ben_cwb_asg_update.g_ws_asg_rec_type||to_char(l_asg_updt_eff_date, 'yyyy/mm/dd'));
4051:
4052: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;
4053: CLOSE ben_cwb_asg_update.g_txn;
4054: end if;

Line 4052: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;

4048: if l_asg_updt_eff_date is not null then
4049: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4050: ben_cwb_asg_update.g_ws_asg_rec_type||to_char(l_asg_updt_eff_date, 'yyyy/mm/dd'));
4051:
4052: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;
4053: CLOSE ben_cwb_asg_update.g_txn;
4054: end if;
4055:
4056: IF l_asg_txn.assignment_id is not null or l_perf_txn.assignment_id IS NOT NULL THEN

Line 4053: CLOSE ben_cwb_asg_update.g_txn;

4049: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
4050: ben_cwb_asg_update.g_ws_asg_rec_type||to_char(l_asg_updt_eff_date, 'yyyy/mm/dd'));
4051:
4052: FETCH ben_cwb_asg_update.g_txn INTO l_asg_txn;
4053: CLOSE ben_cwb_asg_update.g_txn;
4054: end if;
4055:
4056: IF l_asg_txn.assignment_id is not null or l_perf_txn.assignment_id IS NOT NULL THEN
4057: --

Line 4112: ben_cwb_asg_update.process_rating (p_person_id => p_person_id

4108: if(l_error) then
4109: fnd_message.raise_error;
4110: end if;
4111:
4112: ben_cwb_asg_update.process_rating (p_person_id => p_person_id
4113: , p_txn_rec => l_perf_txn
4114: , p_business_group_id => l_emp_num_and_emp_name.business_group_id
4115: , p_audit_log => p_audit_log
4116: , p_process_status => l_rating_status

Line 4205: ben_cwb_asg_update.g_ws_asg_rec_type

4201: l_promo_person_rec.prior_grade := l_prior_assignment_dtls.grade;
4202: l_promo_person_rec.prior_group := l_prior_assignment_dtls.group_name;
4203:
4204: OPEN c_proposed_promotions(to_number(l_emp_num_and_emp_name.assignment_id),
4205: ben_cwb_asg_update.g_ws_asg_rec_type
4206: ||l_asg_txn.attribute1);
4207: FETCH c_proposed_promotions into l_proposed_promotions;
4208: CLOSE c_proposed_promotions;
4209: WRITE(ben_cwb_asg_update.g_ws_asg_rec_type||l_asg_txn.attribute1);

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

4205: ben_cwb_asg_update.g_ws_asg_rec_type
4206: ||l_asg_txn.attribute1);
4207: FETCH c_proposed_promotions into l_proposed_promotions;
4208: CLOSE c_proposed_promotions;
4209: WRITE(ben_cwb_asg_update.g_ws_asg_rec_type||l_asg_txn.attribute1);
4210:
4211: l_promo_person_rec.proposed_job := l_proposed_promotions.job;
4212: l_promo_person_rec.proposed_position := l_proposed_promotions.position;
4213: l_promo_person_rec.proposed_grade := l_proposed_promotions.grade;

Line 4283: ben_cwb_asg_update.process_promotions (p_person_id => p_person_id

4279: if(l_error) then
4280: fnd_message.raise_error;
4281: end if;
4282:
4283: ben_cwb_asg_update.process_promotions (p_person_id => p_person_id
4284: , p_asg_txn_rec => l_asg_txn
4285: , p_business_group_id => l_emp_num_and_emp_name.business_group_id
4286: , p_audit_log => p_audit_log
4287: , p_process_status => l_promotion_status