APPS.HRI_BPL_PERF_RATING dependencies on HRI_BPL_PERF_RATING

Line 1: PACKAGE BODY HRI_BPL_PERF_RATING AS

1: PACKAGE BODY HRI_BPL_PERF_RATING AS
2: /* $Header: hribpfrt.pkb 120.3 2005/12/21 03:52:20 anmajumd noship $ */
3: --
4: -- -----------------------------------------------------------------------------
5: -- The package Normalizes the Performance Review Rating and the Overall Rating

Line 526: Fnd_Message.Set_Token('PROC','HRI_BPL_PERF_RATING');

522: --
523: Fnd_Message.Set_Name('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
524: Fnd_Message.Set_Token('PARAMETER','NORMALIZED_RATING' );
525: Fnd_Message.Set_Token('FORMULA',l_ff_id);
526: Fnd_Message.Set_Token('PROC','HRI_BPL_PERF_RATING');
527: RAISE ff_returned_invalid_value;
528: --
529: END;
530: --

Line 677: hri_bpl_perf_rating.get_perf_rating_val (perf.review_date,

673: perf.last_update_date last_update_date,
674: perf.performance_review_id performance_review_id,
675: pevt.type perf_review_type,
676: NULL app_temp_name,
677: hri_bpl_perf_rating.get_perf_rating_val (perf.review_date,
678: :p_business_group_id,perf.performance_rating,pevt.type,null) nrmlsd_rating,
679: nvl(ppos.actual_termination_date,hr_general.end_of_time) termination_date
680: FROM per_performance_reviews perf,
681: per_events pevt,

Line 739: hri_bpl_perf_rating.get_perf_rating_val(papp.appraisal_date ,

735: papp.last_update_date last_update_date,
736: null performance_review_id,
737: null perf_review_type,
738: papt.name app_temp_name,
739: hri_bpl_perf_rating.get_perf_rating_val(papp.appraisal_date ,
740: :p_business_group_id,prl.step_value,null,papt.name) nrmlsd_rating,
741: nvl(ppos.actual_termination_date,hr_general.end_of_time) termination_date
742: FROM per_appraisals papp,
743: per_rating_levels prl,

Line 855: ,p_package_name => 'HRI_BPL_PERF_RATING'

851: --
852: hri_bpl_conc_log.log_process_info
853: (p_msg_type => 'WARNING'
854: ,p_note => l_message
855: ,p_package_name => 'HRI_BPL_PERF_RATING'
856: ,p_msg_sub_group => 'GET_PERF_SQL'
857: ,p_sql_err_code => SQLCODE
858: ,p_msg_group => 'ASG_EVT_FCT');
859: --

Line 882: hri_bpl_perf_rating.get_perf_rating_band

878: performance_review_id,
879: perf_review_type,
880: app_temp_name,
881: nrmlsd_rating,
882: hri_bpl_perf_rating.get_perf_rating_band
883: (nrmlsd_rating,:p_business_group_id,:p_person_id,perf_rating,
884: perf_review_type,app_temp_name ) perf_band,
885: dense_rank() over (partition by review_date
886: order by last_update_date desc) same_day_rank

Line 1023: ,p_package_name => 'HRI_BPL_PERF_RATING'

1019: --
1020: hri_bpl_conc_log.log_process_info
1021: (p_msg_type => 'WARNING'
1022: ,p_note => l_message
1023: ,p_package_name => 'HRI_BPL_PERF_RATING'
1024: ,p_msg_sub_group => 'GET_PERF_RATING_BAND'
1025: ,p_sql_err_code => SQLCODE
1026: ,p_msg_group => 'ASG_EVT_FCT');
1027: --

Line 1058: END HRI_BPL_PERF_RATING;

1054: g_concurrent_flag := 'Y';
1055: --
1056: END IF;
1057: --
1058: END HRI_BPL_PERF_RATING;