DBA Data[Home] [Help]

APPS.GHR_POI_FLEX_DDF dependencies on PER_POSITION_EXTRA_INFO

Line 300: ,p_date_from in per_position_extra_info.poei_information1%TYPE

296: -- ---------------------------------------------------------------------------------------------------
297: --
298: procedure chk_date_from
299: (p_position_description_id in ghr_position_descriptions.position_description_id%TYPE
300: ,p_date_from in per_position_extra_info.poei_information1%TYPE
301: ) is
302: --
303: l_proc varchar2(72) := 'chk_date_from';
304: l_api_updating boolean;

Line 322: (p_position_extra_info_id in per_position_extra_info.position_extra_info_id%TYPE

318: -- |------------------------------- < chk_pos_desc_id > ---------------------------------------------|
319: -- ---------------------------------------------------------------------------------------------------
320: --
321: procedure chk_pos_desc_id
322: (p_position_extra_info_id in per_position_extra_info.position_extra_info_id%TYPE
323: ,p_pos_desc_id in per_position_extra_info.poei_information3%TYPE
324: ) is
325: --
326: l_exists varchar2(1);

Line 323: ,p_pos_desc_id in per_position_extra_info.poei_information3%TYPE

319: -- ---------------------------------------------------------------------------------------------------
320: --
321: procedure chk_pos_desc_id
322: (p_position_extra_info_id in per_position_extra_info.position_extra_info_id%TYPE
323: ,p_pos_desc_id in per_position_extra_info.poei_information3%TYPE
324: ) is
325: --
326: l_exists varchar2(1);
327: l_proc varchar2(72) := 'chk_pos_desc_id';

Line 364: (p_position_extra_info_id in per_position_extra_info.position_extra_info_id%TYPE

360: -- |------------------------------------ < chk_date_to >---------------------------------------------|
361: -- ---------------------------------------------------------------------------------------------------
362: --
363: procedure chk_date_to
364: (p_position_extra_info_id in per_position_extra_info.position_extra_info_id%TYPE
365: ,p_date_to in per_position_extra_info.poei_information2%TYPE
366: ,p_date_from in per_position_extra_info.poei_information1%TYPE
367: ) is
368: --

Line 365: ,p_date_to in per_position_extra_info.poei_information2%TYPE

361: -- ---------------------------------------------------------------------------------------------------
362: --
363: procedure chk_date_to
364: (p_position_extra_info_id in per_position_extra_info.position_extra_info_id%TYPE
365: ,p_date_to in per_position_extra_info.poei_information2%TYPE
366: ,p_date_from in per_position_extra_info.poei_information1%TYPE
367: ) is
368: --
369: l_proc varchar2(72) := 'chk_date_to';

Line 366: ,p_date_from in per_position_extra_info.poei_information1%TYPE

362: --
363: procedure chk_date_to
364: (p_position_extra_info_id in per_position_extra_info.position_extra_info_id%TYPE
365: ,p_date_to in per_position_extra_info.poei_information2%TYPE
366: ,p_date_from in per_position_extra_info.poei_information1%TYPE
367: ) is
368: --
369: l_proc varchar2(72) := 'chk_date_to';
370: l_api_updating boolean;