DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_HR dependencies on PQH_GSP_STAGE_TO_BEN

Line 1402: pqh_gsp_stage_to_ben.cre_update_elig_prfl(

1398: p_business_area => p_business_area);
1399:
1400: hr_utility.set_location('data pushed to hr ',20);
1401:
1402: pqh_gsp_stage_to_ben.cre_update_elig_prfl(
1403: p_copy_entity_txn_id => p_copy_entity_txn_id
1404: ,p_effective_date => p_effective_date
1405: ,p_business_group_id => p_business_group_id);
1406:

Line 1409: pqh_gsp_stage_to_ben.stage_to_ben

1405: ,p_business_group_id => p_business_group_id);
1406:
1407: hr_utility.set_location('Elpros created/updated',20);
1408:
1409: pqh_gsp_stage_to_ben.stage_to_ben
1410: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1411: p_effective_date => p_effective_date,
1412: p_business_group_id => p_business_group_id,
1413: p_datetrack_mode => l_datetrack_mode,

Line 1685: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

1681: elsif l_grade_spine_id is not null and grd_spine.information103 in ('Y','B','S') then
1682: hr_utility.set_location('grd_spine exists,ceiling step updated',10);
1683: begin
1684: hr_utility.set_location('going for upd',30);
1685: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1686: (p_table_name => 'PER_GRADE_SPINES_F',
1687: p_key_column_name => 'GRADE_SPINE_ID',
1688: p_key_column_value => l_grade_spine_id,
1689: p_effective_date => p_effective_date);

Line 1700: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode

1696: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1697: fnd_message.raise_error;
1698: else
1699: if p_datetrack_mode <> 'CORRECTION' then
1700: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
1701: (p_table_name => 'PER_GRADE_SPINES_F',
1702: p_key_column_name => 'GRADE_SPINE_ID',
1703: p_key_column_value => l_grade_spine_id,
1704: p_effective_date => p_effective_date);

Line 1882: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

1878: elsif point_rec.dml_operation in ('UPDATE','UPD_INS')
1879: and point_rec.information257 is not null
1880: and point_rec.information255 is not null then
1881: hr_utility.set_location('going for upd',30);
1882: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1883: (p_table_name => 'PER_SPINAL_POINTS',
1884: p_key_column_name => 'SPINAL_POINT_ID',
1885: p_key_column_value => l_point_id);
1886: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 2022: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

2018: hr_utility.set_location('grade ovn'||grd_rec.information222,60);
2019: l_concat_segments := get_grd_segment(p_grade_id => l_grade_id,
2020: p_grade_definition_id => grd_rec.information221);
2021: hr_utility.set_location('con seg is'||substr(l_concat_segments,1,55),61);
2022: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2023: (p_table_name => 'PER_GRADES',
2024: p_key_column_name => 'GRADE_ID',
2025: p_key_column_value => l_grade_id);
2026: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 2275: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

2271: hr_utility.set_location('scale writeback comp'||l_scale_id,40);
2272: elsif scl_rec.dml_operation ='UPDATE' and l_scale_id is not null
2273: and scl_rec.information98 is not null and l_scale_ovn is not null then
2274: hr_utility.set_location('scale is being updated'||l_proc,60);
2275: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2276: (p_table_name => 'PER_PARENT_SPINES',
2277: p_key_column_name => 'PARENT_SPINE_ID',
2278: p_key_column_value => l_scale_id);
2279: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 2498: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode

2494: hr_utility.set_location('value'||hrr_rec.information297,20);
2495: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2496: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2497: if hrr_rec.datetrack_mode <> 'CORRECTION' then
2498: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
2499: (p_table_name => 'PAY_GRADE_RULES_F',
2500: p_key_column_name => 'GRADE_RULE_ID',
2501: p_key_column_value => l_hrrate_id,
2502: p_effective_date => l_effective_date);

Line 2507: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

2503: else
2504: l_dt_mode := hrr_rec.datetrack_mode;
2505: end if;
2506: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
2507: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2508: (p_table_name => 'PAY_GRADE_RULES_F',
2509: p_key_column_name => 'GRADE_RULE_ID',
2510: p_key_column_value => l_hrrate_id,
2511: p_effective_date => l_effective_date);