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.HR_EDW_WRK_SPRTN_F_SIZING dependencies on HRI_EDW_DIM_SIZING

Line 136: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;

132: CLOSE pasg_cur;
133:
134: x_separation_pk := x_pps_prd_of_srvc_id + x_asg_person_id + x_instance_fk;
135:
136: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
137: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
138: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
139: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;

Line 137: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;

133:
134: x_separation_pk := x_pps_prd_of_srvc_id + x_asg_person_id + x_instance_fk;
135:
136: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
137: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
138: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
139: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;

Line 138: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;

134: x_separation_pk := x_pps_prd_of_srvc_id + x_asg_person_id + x_instance_fk;
135:
136: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
137: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
138: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
139: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;

Line 139: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;

135:
136: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
137: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
138: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
139: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
143: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;

Line 140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;

136: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
137: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
138: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
139: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
143: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
144: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;

Line 141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;

137: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
138: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
139: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
143: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
144: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
145: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;

Line 142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;

138: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
139: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
143: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
144: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
145: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
146: x_time_trm_accptd_fk := hri_edw_dim_sizing.get_size_time_pk;

Line 143: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;

139: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
143: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
144: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
145: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
146: x_time_trm_accptd_fk := hri_edw_dim_sizing.get_size_time_pk;
147: x_time_trm_ntfd_fk := x_time_trm_accptd_fk;

Line 144: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;

140: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
143: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
144: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
145: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
146: x_time_trm_accptd_fk := hri_edw_dim_sizing.get_size_time_pk;
147: x_time_trm_ntfd_fk := x_time_trm_accptd_fk;
148: x_time_emp_strt_fk := x_time_trm_accptd_fk;

Line 145: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;

141: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
143: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
144: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
145: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
146: x_time_trm_accptd_fk := hri_edw_dim_sizing.get_size_time_pk;
147: x_time_trm_ntfd_fk := x_time_trm_accptd_fk;
148: x_time_emp_strt_fk := x_time_trm_accptd_fk;
149: x_time_trm_prjctd_fk := x_time_trm_accptd_fk;

Line 146: x_time_trm_accptd_fk := hri_edw_dim_sizing.get_size_time_pk;

142: x_organization_fk := hri_edw_dim_sizing.get_size_org_pk;
143: x_person_fk := hri_edw_dim_sizing.get_size_psn_pk;
144: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
145: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
146: x_time_trm_accptd_fk := hri_edw_dim_sizing.get_size_time_pk;
147: x_time_trm_ntfd_fk := x_time_trm_accptd_fk;
148: x_time_emp_strt_fk := x_time_trm_accptd_fk;
149: x_time_trm_prjctd_fk := x_time_trm_accptd_fk;
150: x_time_trm_prcss_fk := x_time_trm_accptd_fk;

Line 152: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;

148: x_time_emp_strt_fk := x_time_trm_accptd_fk;
149: x_time_trm_prjctd_fk := x_time_trm_accptd_fk;
150: x_time_trm_prcss_fk := x_time_trm_accptd_fk;
151: x_time_trm_occrd_fk := x_time_trm_accptd_fk;
152: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;
153: x_movement_type_fk := hri_edw_dim_sizing.get_size_mvt_pk;
154:
155:
156: x_total_wsp := NVL(ceil( x_separation_pk + 1), 0)

Line 153: x_movement_type_fk := hri_edw_dim_sizing.get_size_mvt_pk;

149: x_time_trm_prjctd_fk := x_time_trm_accptd_fk;
150: x_time_trm_prcss_fk := x_time_trm_accptd_fk;
151: x_time_trm_occrd_fk := x_time_trm_accptd_fk;
152: x_reason_fk := hri_edw_dim_sizing.get_size_rsn_pk;
153: x_movement_type_fk := hri_edw_dim_sizing.get_size_mvt_pk;
154:
155:
156: x_total_wsp := NVL(ceil( x_separation_pk + 1), 0)
157: + NVL(ceil( x_assignment_fk + 1), 0)