APPS.PQH_GSP_HR_TO_STAGE dependencies on PQH_CPD_HR_TO_STAGE

Line 2424: l_cpd_exists := pqh_cpd_hr_to_stage.check_cpd_row(p_copy_entity_txn_id);

2420: l_rule_exists := 'Y';
2421: end if;
2422: end if;
2423: if p_business_area = 'PQH_CORPS_TASK_LIST' then
2424: l_cpd_exists := pqh_cpd_hr_to_stage.check_cpd_row(p_copy_entity_txn_id);
2425: l_cdd_exists := pqh_cpd_hr_to_stage.check_cdd_row(p_copy_entity_txn_id);
2426: else
2427: l_cpd_exists := '';
2428: l_cdd_exists := '';

Line 2425: l_cdd_exists := pqh_cpd_hr_to_stage.check_cdd_row(p_copy_entity_txn_id);

2421: end if;
2422: end if;
2423: if p_business_area = 'PQH_CORPS_TASK_LIST' then
2424: l_cpd_exists := pqh_cpd_hr_to_stage.check_cpd_row(p_copy_entity_txn_id);
2425: l_cdd_exists := pqh_cpd_hr_to_stage.check_cdd_row(p_copy_entity_txn_id);
2426: else
2427: l_cpd_exists := '';
2428: l_cdd_exists := '';
2429: end if;

Line 3453: pqh_cpd_hr_to_stage.corps_to_stage(p_copy_entity_txn_id => p_copy_entity_txn_id,

3449: end;
3450: end loop;
3451: hr_utility.set_location('done reading all rows ',120);
3452: if p_business_area = 'PQH_CORPS_TASK_LIST' and l_pgm_id is not null then
3453: pqh_cpd_hr_to_stage.corps_to_stage(p_copy_entity_txn_id => p_copy_entity_txn_id,
3454: p_pgm_id => l_pgm_id,
3455: p_effective_date => p_effective_date,
3456: p_pgm_cer_id => l_pgm_cer_id);
3457: end if;

Line 3499: pqh_cpd_hr_to_stage.get_point_details(p_point_id => l_point_id,

3495: p_spinal_point => l_spinal_point);
3496: hr_utility.set_location('point is '||l_spinal_point,20);
3497: hr_utility.set_location('bus_area is '||p_business_area,20);
3498: if p_business_area ='PQH_CORPS_TASK_LIST' then
3499: pqh_cpd_hr_to_stage.get_point_details(p_point_id => l_point_id,
3500: p_information_category => l_information_category,
3501: p_information1 => l_information1,
3502: p_information2 => l_information2,
3503: p_information3 => l_information3,

Line 3711: pqh_cpd_hr_to_stage.get_corp(p_pgm_cer_id => p_parent_cer_id,

3707: p_grd_max => l_grd_max);
3708: hr_utility.set_location('grade value is'||l_grd_value,40);
3709: if p_business_area ='PQH_CORPS_TASK_LIST' then
3710: hr_utility.set_location('getting quota for plip',40);
3711: pqh_cpd_hr_to_stage.get_corp(p_pgm_cer_id => p_parent_cer_id,
3712: p_corps_id => l_corps_definition_id,
3713: p_cet_id => l_cet_id);
3714: hr_utility.set_location('corps is '||l_corps_definition_id,40);
3715: hr_utility.set_location('cet is '||l_cet_id,40);

Line 3717: pqh_cpd_hr_to_stage.get_grd_quota(p_pgm_cer_id => p_parent_cer_id,

3713: p_cet_id => l_cet_id);
3714: hr_utility.set_location('corps is '||l_corps_definition_id,40);
3715: hr_utility.set_location('cet is '||l_cet_id,40);
3716: if l_corps_definition_id >0 AND l_cet_id >0 THEN
3717: pqh_cpd_hr_to_stage.get_grd_quota(p_pgm_cer_id => p_parent_cer_id,
3718: p_grade_id => p_grade_id,
3719: p_corps_definition_id => l_corps_definition_id,
3720: p_cet_id => l_cet_id,
3721: p_perc_quota => l_perc_quota,

Line 3856: pqh_cpd_hr_to_stage.pull_career_path(p_copy_entity_txn_id => p_copy_entity_txn_id,

3852: else
3853: hr_utility.set_location('oipl_cer_id is '||p_oipl_cer_id,130);
3854: end if;
3855: if p_business_area = 'PQH_CORPS_TASK_LIST' and l_step_id is not null then
3856: pqh_cpd_hr_to_stage.pull_career_path(p_copy_entity_txn_id => p_copy_entity_txn_id,
3857: p_step_id => l_step_id,
3858: p_effective_date => p_effective_date,
3859: p_grade_id => l_grade_id);
3860: end if;

Line 4237: pqh_cpd_hr_to_stage.get_scale_ddf_det(p_scale_id => p_scale_id,

4233: else
4234: hr_utility.set_location('no scale table route exists',55);
4235: end if;
4236: if p_business_area ='PQH_CORPS_TASK_LIST' then
4237: pqh_cpd_hr_to_stage.get_scale_ddf_det(p_scale_id => p_scale_id,
4238: p_information_category => l_information_category,
4239: p_information1 => l_information1,
4240: p_information2 => l_information2);
4241: end if;

Line 5463: pqh_cpd_hr_to_stage.get_point_details(p_point_id => p_point_id,

5459: p_point_seq => l_point_seq,
5460: p_point_ovn => l_point_ovn,
5461: p_spinal_point => l_spinal_point);
5462: if p_business_area = 'PQH_CORPS_TASK_LIST' then
5463: pqh_cpd_hr_to_stage.get_point_details(p_point_id => p_point_id,
5464: p_information_category => l_information_category,
5465: p_information1 => l_information1,
5466: p_information2 => l_information2,
5467: p_information3 => l_information3,