APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on BEN_CWB_ASG_UPDATE

Line 2765: ,p_txn_rec in ben_cwb_asg_update.g_txn%rowtype

2761: -- ============================================================================
2762: --
2763: procedure backout_rating
2764: (p_person_id in number
2765: ,p_txn_rec in ben_cwb_asg_update.g_txn%rowtype
2766: ,p_business_group_id in number
2767: ,p_audit_log in varchar2 default 'N'
2768: ,p_process_status in out nocopy varchar2
2769: ,p_group_per_in_ler_id in number default null

Line 2920: l_perf_txn ben_cwb_asg_update.g_txn%ROWTYPE;

2916: l_assignment_extra_info_id NUMBER;
2917: l_cache_cwb_rpt_person g_cache_cwb_rpt_person_rec;
2918: l_bg_and_mgr_name c_bg_and_mgr_name%ROWTYPE;
2919: l_amount NUMBER := NULL;
2920: l_perf_txn ben_cwb_asg_update.g_txn%ROWTYPE;
2921: l_asg_txn ben_cwb_asg_update.g_txn%ROWTYPE;
2922: l_rate_ovn c_rate_ovn%ROWTYPE;
2923: l_grp_ovn c_grp_ovn%ROWTYPE;
2924: l_emp_num_and_emp_name c_emp_num_and_emp_name%ROWTYPE;

Line 2921: l_asg_txn ben_cwb_asg_update.g_txn%ROWTYPE;

2917: l_cache_cwb_rpt_person g_cache_cwb_rpt_person_rec;
2918: l_bg_and_mgr_name c_bg_and_mgr_name%ROWTYPE;
2919: l_amount NUMBER := NULL;
2920: l_perf_txn ben_cwb_asg_update.g_txn%ROWTYPE;
2921: l_asg_txn ben_cwb_asg_update.g_txn%ROWTYPE;
2922: l_rate_ovn c_rate_ovn%ROWTYPE;
2923: l_grp_ovn c_grp_ovn%ROWTYPE;
2924: l_emp_num_and_emp_name c_emp_num_and_emp_name%ROWTYPE;
2925: l_rating_status VARCHAR2 (200);

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

3144:
3145: IF(p_is_backout_perf = 'Y') THEN
3146: l_perf_person_rec.rating_date := hr_general.end_of_time;
3147: if l_perf_revw_strt_dt is not null then
3148: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
3149: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
3150: ||l_interview_typ_cd);
3151:
3152: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;

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

3145: IF(p_is_backout_perf = 'Y') THEN
3146: l_perf_person_rec.rating_date := hr_general.end_of_time;
3147: if l_perf_revw_strt_dt is not null then
3148: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
3149: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
3150: ||l_interview_typ_cd);
3151:
3152: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;
3153: CLOSE ben_cwb_asg_update.g_txn;

Line 3152: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;

3148: OPEN ben_cwb_asg_update.g_txn (l_emp_num_and_emp_name.assignment_id,
3149: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
3150: ||l_interview_typ_cd);
3151:
3152: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;
3153: CLOSE ben_cwb_asg_update.g_txn;
3154: end if;
3155: IF((l_perf_txn.attribute1 is not null and l_perf_txn.attribute3 is not null)
3156: and (l_is_eligible = TRUE)

Line 3153: CLOSE ben_cwb_asg_update.g_txn;

3149: ben_cwb_asg_update.g_ws_perf_rec_type||to_char(l_perf_revw_strt_dt, 'yyyy/mm/dd')
3150: ||l_interview_typ_cd);
3151:
3152: FETCH ben_cwb_asg_update.g_txn INTO l_perf_txn;
3153: CLOSE ben_cwb_asg_update.g_txn;
3154: end if;
3155: IF((l_perf_txn.attribute1 is not null and l_perf_txn.attribute3 is not null)
3156: and (l_is_eligible = TRUE)
3157: ) THEN