DBA Data[Home] [Help]

APPS.GHR_MTO_PKG dependencies on GHR_API

Line 771: l_occ_series := ghr_api.get_job_occ_series_job

767: l_office_symbol,
768: l_position_organization,
769: l_pos_grp1_rec);
770:
771: l_occ_series := ghr_api.get_job_occ_series_job
772: (p_job_id => per.job_id
773: ,p_business_group_id => per.business_group_id
774: );
775:

Line 1214: l_position_title := ghr_api.get_position_title_pos

1210: pr('After check sel flg value is ',l_sel_flg,l_sel_status);
1211: null;
1212: end if;
1213:
1214: l_position_title := ghr_api.get_position_title_pos
1215: (p_position_id => l_position_id
1216: ,p_business_group_id => l_business_group_id ) ;
1217:
1218: l_sub_element_code := ghr_api.get_position_agency_code_pos

Line 1218: l_sub_element_code := ghr_api.get_position_agency_code_pos

1214: l_position_title := ghr_api.get_position_title_pos
1215: (p_position_id => l_position_id
1216: ,p_business_group_id => l_business_group_id ) ;
1217:
1218: l_sub_element_code := ghr_api.get_position_agency_code_pos
1219: (l_position_id,l_business_group_id);
1220:
1221: l_occ_series := ghr_api.get_job_occ_series_job
1222: (p_job_id => per.job_id

Line 1221: l_occ_series := ghr_api.get_job_occ_series_job

1217:
1218: l_sub_element_code := ghr_api.get_position_agency_code_pos
1219: (l_position_id,l_business_group_id);
1220:
1221: l_occ_series := ghr_api.get_job_occ_series_job
1222: (p_job_id => per.job_id
1223: ,p_business_group_id => per.business_group_id
1224: );
1225:

Line 1226: l_position_number := ghr_api.get_position_desc_no_pos

1222: (p_job_id => per.job_id
1223: ,p_business_group_id => per.business_group_id
1224: );
1225:
1226: l_position_number := ghr_api.get_position_desc_no_pos
1227: (p_position_id => l_position_id
1228: ,p_business_group_id => per.business_group_id
1229: );
1230:

Line 1231: l_position_seq_no := ghr_api.get_position_sequence_no_pos

1227: (p_position_id => l_position_id
1228: ,p_business_group_id => per.business_group_id
1229: );
1230:
1231: l_position_seq_no := ghr_api.get_position_sequence_no_pos
1232: (p_position_id => l_position_id
1233: ,p_business_group_id => per.business_group_id
1234: );
1235:

Line 1374: l_position_title := ghr_api.get_position_title_pos

1370: := l_effective_date + 1;
1371: -- End Bug 3531540
1372: l_business_group_id := per_vacant.business_group_iD;
1373:
1374: l_position_title := ghr_api.get_position_title_pos
1375: (p_position_id => l_position_id
1376: ,p_business_group_id => l_business_group_id ) ;
1377:
1378: ---Added by AVR Check eligibility is missing 03/30/00

Line 1379: l_sub_element_code := ghr_api.get_position_agency_code_pos

1375: (p_position_id => l_position_id
1376: ,p_business_group_id => l_business_group_id ) ;
1377:
1378: ---Added by AVR Check eligibility is missing 03/30/00
1379: l_sub_element_code := ghr_api.get_position_agency_code_pos
1380: (l_position_id,l_business_group_id);
1381:
1382: get_pos_grp1_ddf(l_position_id,
1383: l_effective_date,

Line 1805: ghr_api.g_api_dml := TRUE;

1801: end if;
1802:
1803: if l_position_extra_info_id is not null then
1804: ----- Set the global variable not to fire the trigger
1805: ghr_api.g_api_dml := TRUE;
1806: ghr_position_extra_info_api.update_position_extra_info
1807: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
1808: ,P_EFFECTIVE_DATE => trunc(l_eff_date)
1809: ,P_OBJECT_VERSION_NUMBER => l_object_version_number

Line 1815: ghr_api.g_api_dml := FALSE;

1811: ,p_poei_INFORMATION16 => p_comment
1812: ,p_poei_INFORMATION17 => to_char(p_mtfr_id)
1813: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS');
1814: ----- Reset the global variable
1815: ghr_api.g_api_dml := FALSE;
1816: else
1817: -- Bug#4125231 Set the global variable not to fire the trigger
1818: ghr_api.g_api_dml := TRUE;
1819: ghr_position_extra_info_api.create_position_extra_info

Line 1818: ghr_api.g_api_dml := TRUE;

1814: ----- Reset the global variable
1815: ghr_api.g_api_dml := FALSE;
1816: else
1817: -- Bug#4125231 Set the global variable not to fire the trigger
1818: ghr_api.g_api_dml := TRUE;
1819: ghr_position_extra_info_api.create_position_extra_info
1820: (P_POSITION_ID => p_position_id
1821: ,P_INFORMATION_TYPE => 'GHR_US_POS_MASS_ACTIONS'
1822: ,P_EFFECTIVE_DATE => trunc(l_eff_date)

Line 1830: ghr_api.g_api_dml := FALSE;

1826: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS'
1827: ,P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
1828: ,P_OBJECT_VERSION_NUMBER => l_object_version_number);
1829: --Bug#4215231 Reset the global variable
1830: ghr_api.g_api_dml := FALSE;
1831: end if;
1832: hr_utility.set_location('Exiting ' || l_proc,10);
1833:
1834: -- There is a trigger on Position extra Info. Whenever updated/created the

Line 1886: ghr_api.g_api_dml := TRUE;

1882: l_object_version_number := l_pos_ei_data.object_version_number;
1883:
1884: if l_position_extra_info_id is not null then
1885: ----- Set the global variable not to fire the trigger
1886: ghr_api.g_api_dml := TRUE;
1887: ghr_position_extra_info_api.update_position_extra_info
1888: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
1889: ,P_EFFECTIVE_DATE => trunc(l_eff_date)
1890: ,P_OBJECT_VERSION_NUMBER => l_object_version_number

Line 1895: ghr_api.g_api_dml := FALSE;

1891: ,p_poei_INFORMATION15 => NULL
1892: ,p_poei_INFORMATION16 => NULL
1893: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS');
1894: ----- Reset the global variable
1895: ghr_api.g_api_dml := FALSE;
1896:
1897:
1898: --- Commented the following two lines to remove Validation functionality on Position.
1899: -- ghr_validate_perwsdpo.validate_perwsdpo(p_position_id);

Line 2723: ghr_api.g_api_dml := TRUE;

2719: l_object_version_number := l_pos_ei_data.object_version_number;
2720:
2721: if l_position_extra_info_id is not null then
2722: ----- Set the global variable not to fire the trigger
2723: ghr_api.g_api_dml := TRUE;
2724: ghr_position_extra_info_api.update_position_extra_info
2725: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
2726: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2727: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS'

Line 2733: ghr_api.g_api_dml := FALSE;

2729: ,P_POEI_INFORMATION15 => null
2730: ,P_POEI_INFORMATION16 => null
2731: ,P_POEI_INFORMATION17 => null);
2732: ----- Reset the global variable
2733: ghr_api.g_api_dml := FALSE;
2734:
2735:
2736: --- Commented the following two lines to remove Validation functionality on Position.
2737: -- ghr_validate_perwsdpo.validate_perwsdpo(p_position_id);

Line 2932: ghr_api.g_api_dml := TRUE;

2928: l_object_version_number := l_per_ei_data.object_version_number;
2929:
2930: if l_person_extra_info_id is not null then
2931: ----- Set the global variable not to fire the trigger
2932: ghr_api.g_api_dml := TRUE;
2933: ghr_person_extra_info_api.update_person_extra_info
2934: (P_PERSON_EXTRA_INFO_ID => l_PERSON_extra_info_id
2935: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2936: ,P_PEI_INFORMATION_CATEGORY => 'GHR_US_PER_MASS_ACTIONS'

Line 2943: ghr_api.g_api_dml := FALSE;

2939: );
2940: -- ,P_PEI_INFORMATION16 => null
2941: -- ,P_PEI_INFORMATION17 => null);
2942: ----- Reset the global variable
2943: ghr_api.g_api_dml := FALSE;
2944: end if;
2945:
2946: End;
2947: END GHR_MTO_PKG;