DBA Data[Home] [Help]

APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on HR_GENERAL

Line 1097: hr_general.decode_lookup('BEN_WS_ACC', 'UP' ),

1093: l_notify.group_per_in_ler_id,
1094: l_notify.plan_name,
1095: null,
1096: null,
1097: hr_general.decode_lookup('BEN_WS_ACC', 'UP' ),
1098: 'Your worksheet is now available for further updates. Please make any changes as required and re-submit for approval.' ,
1099: fnd_date.date_to_canonical(sysdate),
1100: hr_general.decode_lookup('BEN_WS_ACC', l_grp_ovn.access_cd ),
1101: null, --l_requestor_first_name,

Line 1100: hr_general.decode_lookup('BEN_WS_ACC', l_grp_ovn.access_cd ),

1096: null,
1097: hr_general.decode_lookup('BEN_WS_ACC', 'UP' ),
1098: 'Your worksheet is now available for further updates. Please make any changes as required and re-submit for approval.' ,
1099: fnd_date.date_to_canonical(sysdate),
1100: hr_general.decode_lookup('BEN_WS_ACC', l_grp_ovn.access_cd ),
1101: null, --l_requestor_first_name,
1102: 'System Administrator' --l_requestor_last_name
1103: )
1104: returning transaction_id into l_transaction_id ;

Line 1641: , substr(hr_general.decode_lookup('PROPOSAL_REASON',g_cache_cwb_rpt_person (i).reason),1,30) -- bug : 7042887/10149579

1637: , g_cache_cwb_rpt_person (i).pay_basis_id
1638: , g_cache_cwb_rpt_person (i).element_entry_id
1639: , g_cache_cwb_rpt_person (i).exchange_rate
1640: , g_cache_cwb_rpt_person (i).effective_date
1641: , substr(hr_general.decode_lookup('PROPOSAL_REASON',g_cache_cwb_rpt_person (i).reason),1,30) -- bug : 7042887/10149579
1642: , g_cache_cwb_rpt_person (i).eligibility
1643: , g_cache_cwb_rpt_person (i).fte_factor
1644: , g_cache_cwb_rpt_person (i).element_input_value
1645: , nvl(g_cache_cwb_rpt_person (i).amount_posted,0)

Line 3146: l_perf_person_rec.rating_date := hr_general.end_of_time;

3142:
3143: END IF;
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);

Line 3172: l_perf_person_rec.performance_rating := substrb(hr_general.decode_lookup('PERFORMANCE_RATING',l_perf_txn.attribute3),1,30);

3168: l_perf_revw_strt_dt := l_perf_revw_strt_dt;
3169: end if;
3170: l_perf_person_rec.rating_date := l_perf_revw_strt_dt;
3171: l_perf_person_rec.rating_type := l_perf_txn.attribute2;
3172: l_perf_person_rec.performance_rating := substrb(hr_general.decode_lookup('PERFORMANCE_RATING',l_perf_txn.attribute3),1,30);
3173: if(l_error) then
3174: fnd_message.raise_error;
3175: end if;
3176:

Line 3225: l_perf_person_rec.rating_date := hr_general.end_of_time;

3221: WRITE (g_actn);
3222: END;
3223: END IF;
3224: ELSE
3225: l_perf_person_rec.rating_date := hr_general.end_of_time;
3226: l_perf_person_rec.status := 'SC';
3227: END IF;
3228:
3229: BEGIN