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_RCTMNT_F_SIZING dependencies on HRI_EDW_DIM_SIZING

Line 103: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;

99: OPEN inst_cur;
100: FETCH inst_cur INTO x_instance;
101: CLOSE inst_cur;
102:
103: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
104: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
105: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
106: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
107: x_instance_fk := x_instance;

Line 104: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;

100: FETCH inst_cur INTO x_instance;
101: CLOSE inst_cur;
102:
103: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
104: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
105: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
106: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
107: x_instance_fk := x_instance;
108: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;

Line 105: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;

101: CLOSE inst_cur;
102:
103: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
104: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
105: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
106: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
107: x_instance_fk := x_instance;
108: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
109: x_organization_fk := 2 * hri_edw_dim_sizing.get_size_org_pk;

Line 106: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;

102:
103: x_age_band_fk := hri_edw_dim_sizing.get_size_agb_pk;
104: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
105: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
106: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
107: x_instance_fk := x_instance;
108: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
109: x_organization_fk := 2 * hri_edw_dim_sizing.get_size_org_pk;
110: x_person_fk := 4 * hri_edw_dim_sizing.get_size_psn_pk;

Line 108: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;

104: x_assignment_fk := hri_edw_dim_sizing.get_size_asg_pk;
105: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
106: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
107: x_instance_fk := x_instance;
108: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
109: x_organization_fk := 2 * hri_edw_dim_sizing.get_size_org_pk;
110: x_person_fk := 4 * hri_edw_dim_sizing.get_size_psn_pk;
111: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;

Line 109: x_organization_fk := 2 * hri_edw_dim_sizing.get_size_org_pk;

105: x_geography_fk := hri_edw_dim_sizing.get_size_geog_pk;
106: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
107: x_instance_fk := x_instance;
108: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
109: x_organization_fk := 2 * hri_edw_dim_sizing.get_size_org_pk;
110: x_person_fk := 4 * hri_edw_dim_sizing.get_size_psn_pk;
111: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;

Line 110: x_person_fk := 4 * hri_edw_dim_sizing.get_size_psn_pk;

106: x_grade_fk := hri_edw_dim_sizing.get_size_grd_pk;
107: x_instance_fk := x_instance;
108: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
109: x_organization_fk := 2 * hri_edw_dim_sizing.get_size_org_pk;
110: x_person_fk := 4 * hri_edw_dim_sizing.get_size_psn_pk;
111: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;
114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;

Line 111: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;

107: x_instance_fk := x_instance;
108: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
109: x_organization_fk := 2 * hri_edw_dim_sizing.get_size_org_pk;
110: x_person_fk := 4 * hri_edw_dim_sizing.get_size_psn_pk;
111: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;
114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;
115: x_requisition_vacancy_fk := hri_edw_dim_sizing.get_size_vac_pk;

Line 112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;

108: x_job_fk := hri_edw_dim_sizing.get_size_job_pk;
109: x_organization_fk := 2 * hri_edw_dim_sizing.get_size_org_pk;
110: x_person_fk := 4 * hri_edw_dim_sizing.get_size_psn_pk;
111: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;
114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;
115: x_requisition_vacancy_fk := hri_edw_dim_sizing.get_size_vac_pk;
116: x_recruitment_activity_fk := hri_edw_dim_sizing.get_size_rec_pk;

Line 113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;

109: x_organization_fk := 2 * hri_edw_dim_sizing.get_size_org_pk;
110: x_person_fk := 4 * hri_edw_dim_sizing.get_size_psn_pk;
111: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;
114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;
115: x_requisition_vacancy_fk := hri_edw_dim_sizing.get_size_vac_pk;
116: x_recruitment_activity_fk := hri_edw_dim_sizing.get_size_rec_pk;
117: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;

Line 114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;

110: x_person_fk := 4 * hri_edw_dim_sizing.get_size_psn_pk;
111: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;
114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;
115: x_requisition_vacancy_fk := hri_edw_dim_sizing.get_size_vac_pk;
116: x_recruitment_activity_fk := hri_edw_dim_sizing.get_size_rec_pk;
117: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
118: x_time_fk := 8* hri_edw_dim_sizing.get_size_time_pk;

Line 115: x_requisition_vacancy_fk := hri_edw_dim_sizing.get_size_vac_pk;

111: x_person_type_fk := hri_edw_dim_sizing.get_size_pty_pk;
112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;
114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;
115: x_requisition_vacancy_fk := hri_edw_dim_sizing.get_size_vac_pk;
116: x_recruitment_activity_fk := hri_edw_dim_sizing.get_size_rec_pk;
117: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
118: x_time_fk := 8* hri_edw_dim_sizing.get_size_time_pk;
119:

Line 116: x_recruitment_activity_fk := hri_edw_dim_sizing.get_size_rec_pk;

112: x_position_fk := hri_edw_dim_sizing.get_size_pos_pk;
113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;
114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;
115: x_requisition_vacancy_fk := hri_edw_dim_sizing.get_size_vac_pk;
116: x_recruitment_activity_fk := hri_edw_dim_sizing.get_size_rec_pk;
117: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
118: x_time_fk := 8* hri_edw_dim_sizing.get_size_time_pk;
119:
120: OPEN asg_cur;

Line 117: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;

113: x_movement_fk := 8 * hri_edw_dim_sizing.get_size_mvt_pk;
114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;
115: x_requisition_vacancy_fk := hri_edw_dim_sizing.get_size_vac_pk;
116: x_recruitment_activity_fk := hri_edw_dim_sizing.get_size_rec_pk;
117: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
118: x_time_fk := 8* hri_edw_dim_sizing.get_size_time_pk;
119:
120: OPEN asg_cur;
121: FETCH asg_cur INTO

Line 118: x_time_fk := 8* hri_edw_dim_sizing.get_size_time_pk;

114: x_reason_fk := 8 * hri_edw_dim_sizing.get_size_rsn_pk;
115: x_requisition_vacancy_fk := hri_edw_dim_sizing.get_size_vac_pk;
116: x_recruitment_activity_fk := hri_edw_dim_sizing.get_size_rec_pk;
117: x_service_band_fk := hri_edw_dim_sizing.get_size_lwb_pk;
118: x_time_fk := 8* hri_edw_dim_sizing.get_size_time_pk;
119:
120: OPEN asg_cur;
121: FETCH asg_cur INTO
122: x_application_id