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.PQH_GSP_HR_TO_STAGE dependencies on PQH_GSP_UTILITY

Line 504: l_sot date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);

500: p_vpf_value in number,
501: p_crset_id in number,
502: p_crr_cer_id out nocopy number) is
503: l_eot date := to_date('31-12-4712','DD-MM-RRRR');
504: l_sot date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
505: l_abr_cer_id number;
506: l_grd_st_dt date;
507: l_continue boolean := true;
508: begin

Line 1333: pqh_gsp_utility.chk_duplicate_crset_exists(

1329: if p_crset_id is not null then
1330: open crset_rec;
1331: fetch crset_rec into l_crset_name,l_loc_id,l_job_id,l_org_id,l_rule_id,l_pt_id,l_sa_id,l_bu_cd,l_fp_cd,l_pr_cd,l_event_type;
1332: if crset_rec%found then
1333: pqh_gsp_utility.chk_duplicate_crset_exists(
1334: p_copy_entity_txn_id => p_copy_entity_txn_id,
1335: p_effective_date => p_effective_date,
1336: p_cset_id => p_crset_id,
1337: p_location_id => l_loc_id,

Line 4369: --pqh_gsp_utility.del_gl_details_from_stage(p_pqh_copy_entity_txn_id => l_cet_id);

4365: fetch csr_txns into l_cet_id;
4366: if csr_txns%found then
4367: --close csr_txns;
4368: hr_utility.set_location('deleting details',20);
4369: --pqh_gsp_utility.del_gl_details_from_stage(p_pqh_copy_entity_txn_id => l_cet_id);
4370: pqh_gsp_utility.delete_transaction(p_pqh_copy_entity_txn_id =>l_cet_id);
4371:
4372: end if;
4373: close csr_txns;

Line 4370: pqh_gsp_utility.delete_transaction(p_pqh_copy_entity_txn_id =>l_cet_id);

4366: if csr_txns%found then
4367: --close csr_txns;
4368: hr_utility.set_location('deleting details',20);
4369: --pqh_gsp_utility.del_gl_details_from_stage(p_pqh_copy_entity_txn_id => l_cet_id);
4370: pqh_gsp_utility.delete_transaction(p_pqh_copy_entity_txn_id =>l_cet_id);
4371:
4372: end if;
4373: close csr_txns;
4374: l_txn_name := pqh_gsp_utility.gen_txn_display_name

Line 4374: l_txn_name := pqh_gsp_utility.gen_txn_display_name

4370: pqh_gsp_utility.delete_transaction(p_pqh_copy_entity_txn_id =>l_cet_id);
4371:
4372: end if;
4373: close csr_txns;
4374: l_txn_name := pqh_gsp_utility.gen_txn_display_name
4375: (p_program_name => p_pgm_name,
4376: p_mode => 'V');
4377: hr_utility.set_location('starting cet row ',30);
4378: start_gsp_txn(p_copy_entity_txn_id => l_cet_id

Line 4448: pqh_gsp_utility.delete_transaction(p_pqh_copy_entity_txn_id => l_copy_entity_txn_id);

4444: if l_copy_entity_txn_id is not null then
4445: hr_utility.set_location('stage has data',16);
4446: if p_action_type ='REFRESH' then
4447: hr_utility.set_location('staging data to be refreshed',18);
4448: pqh_gsp_utility.delete_transaction(p_pqh_copy_entity_txn_id => l_copy_entity_txn_id);
4449: l_rec_found := FALSE;
4450: elsif p_action_type ='CONTINUE' then
4451: hr_utility.set_location('staging data to be used',18);
4452: p_copy_entity_txn_id := l_copy_entity_txn_id;

Line 4461: l_txn_name := pqh_gsp_utility.gen_txn_display_name

4457: hr_utility.set_location('nothing in staging',18);
4458: end if;
4459: if not l_rec_found then
4460: -- create txn_name
4461: l_txn_name := pqh_gsp_utility.gen_txn_display_name
4462: (p_program_name => p_pgm_name,
4463: p_mode => 'U');
4464: -- create txn
4465: start_gsp_txn(p_copy_entity_txn_id => l_copy_entity_txn_id

Line 5506: pqh_gsp_utility.update_frps_point_rate(p_point_cer_id => p_opt_cer_id,

5502: hr_utility.set_location('issue in creation opt cer '||p_point_id,400);
5503: raise;
5504: end;
5505: if p_business_area = 'PQH_CORPS_TASK_LIST' then
5506: pqh_gsp_utility.update_frps_point_rate(p_point_cer_id => p_opt_cer_id,
5507: p_copy_entity_txn_id => p_copy_entity_txn_id,
5508: p_business_group_id => p_business_group_id,
5509: p_salary_rate => l_information2,
5510: p_gross_index => l_information1,

Line 5683: l_sot := pqh_gsp_utility.get_gsp_plntyp_str_date(grd_rt.business_group_id,p_copy_entity_txn_id);

5679: -- if the pay rate is Grade then we may have to create rows for ABR/ HRRATE for plan
5680: -- in case of scale, it will be for the point associated.
5681: -- if new rates are created then plip and oipl rows should be updated to show standard rate
5682: for grd_rt in csr_grd_rt loop
5683: l_sot := pqh_gsp_utility.get_gsp_plntyp_str_date(grd_rt.business_group_id,p_copy_entity_txn_id);
5684: if grd_rt.rate_type = 'G' then
5685: l_grade_id := grd_rt.grade_or_spinal_point_id;
5686: hr_utility.set_location('grade id is '||l_grade_id,13);
5687: -- check grade is part of grade ladder or not

Line 5778: l_sot date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);

5774: p_copy_entity_txn_id in number,
5775: p_business_group_id in number,
5776: p_point_value in number,
5777: p_effective_date in date) is
5778: l_sot date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
5779: l_abr_cer_id number;
5780: l_hrr_cer_id number;
5781: begin
5782: if p_point_cer_id is not null then

Line 5873: l_sot date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);

5869: l_abr_cer_id number;
5870: l_opt_cer_id number;
5871: l_grade_id number;
5872: l_point_id number;
5873: l_sot date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
5874: l_grd_st_dt date;
5875: begin
5876:
5877: OPEN csr_pgm_details;