APPS.PQH_GSP_STAGE_TO_HR dependencies on PQH_GSP_STAGE_TO_BEN

Line 1363: pqh_gsp_stage_to_ben.cre_update_elig_prfl(

1359: p_business_area => p_business_area);
1360:
1361: hr_utility.set_location('data pushed to hr ',20);
1362:
1363: pqh_gsp_stage_to_ben.cre_update_elig_prfl(
1364: p_copy_entity_txn_id => p_copy_entity_txn_id
1365: ,p_effective_date => p_effective_date
1366: ,p_business_group_id => p_business_group_id);
1367:

Line 1370: pqh_gsp_stage_to_ben.stage_to_ben

1366: ,p_business_group_id => p_business_group_id);
1367:
1368: hr_utility.set_location('Elpros created/updated',20);
1369:
1370: pqh_gsp_stage_to_ben.stage_to_ben
1371: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1372: p_effective_date => p_effective_date,
1373: p_business_group_id => p_business_group_id,
1374: p_datetrack_mode => l_datetrack_mode,

Line 1646: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

1642: elsif l_grade_spine_id is not null and grd_spine.information103 in ('Y','B','S') then
1643: hr_utility.set_location('grd_spine exists,ceiling step updated',10);
1644: begin
1645: hr_utility.set_location('going for upd',30);
1646: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1647: (p_table_name => 'PER_GRADE_SPINES_F',
1648: p_key_column_name => 'GRADE_SPINE_ID',
1649: p_key_column_value => l_grade_spine_id,
1650: p_effective_date => p_effective_date);

Line 1661: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode

1657: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1658: fnd_message.raise_error;
1659: else
1660: if p_datetrack_mode <> 'CORRECTION' then
1661: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
1662: (p_table_name => 'PER_GRADE_SPINES_F',
1663: p_key_column_name => 'GRADE_SPINE_ID',
1664: p_key_column_value => l_grade_spine_id,
1665: p_effective_date => p_effective_date);

Line 1843: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

1839: elsif point_rec.dml_operation in ('UPDATE','UPD_INS')
1840: and point_rec.information257 is not null
1841: and point_rec.information255 is not null then
1842: hr_utility.set_location('going for upd',30);
1843: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1844: (p_table_name => 'PER_SPINAL_POINTS',
1845: p_key_column_name => 'SPINAL_POINT_ID',
1846: p_key_column_value => l_point_id);
1847: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 1982: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

1978: hr_utility.set_location('grade ovn'||grd_rec.information222,60);
1979: l_concat_segments := get_grd_segment(p_grade_id => l_grade_id,
1980: p_grade_definition_id => grd_rec.information221);
1981: hr_utility.set_location('con seg is'||substr(l_concat_segments,1,55),61);
1982: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1983: (p_table_name => 'PER_GRADES',
1984: p_key_column_name => 'GRADE_ID',
1985: p_key_column_value => l_grade_id);
1986: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 2235: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

2231: hr_utility.set_location('scale writeback comp'||l_scale_id,40);
2232: elsif scl_rec.dml_operation ='UPDATE' and l_scale_id is not null
2233: and scl_rec.information98 is not null and l_scale_ovn is not null then
2234: hr_utility.set_location('scale is being updated'||l_proc,60);
2235: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2236: (p_table_name => 'PER_PARENT_SPINES',
2237: p_key_column_name => 'PARENT_SPINE_ID',
2238: p_key_column_value => l_scale_id);
2239: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 2457: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode

2453: hr_utility.set_location('value'||hrr_rec.information297,20);
2454: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2455: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2456: if hrr_rec.datetrack_mode <> 'CORRECTION' then
2457: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
2458: (p_table_name => 'PAY_GRADE_RULES_F',
2459: p_key_column_name => 'GRADE_RULE_ID',
2460: p_key_column_value => l_hrrate_id,
2461: p_effective_date => l_effective_date);

Line 2466: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

2462: else
2463: l_dt_mode := hrr_rec.datetrack_mode;
2464: end if;
2465: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
2466: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2467: (p_table_name => 'PAY_GRADE_RULES_F',
2468: p_key_column_name => 'GRADE_RULE_ID',
2469: p_key_column_value => l_hrrate_id,
2470: p_effective_date => l_effective_date);