DBA Data[Home] [Help]

APPS.GHR_REI_FLEX_DDF dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 152: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE

148: -- |----------------------------- < chk_reason_for_submission > ------------|
149: -- -------------------------------------------------------------------------
150: --
151: procedure chk_reason_for_submission
152: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
153: ,p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
154: ,p_effective_date in date
155: ,p_object_version_number in number
156: ) is

Line 153: ,p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE

149: -- -------------------------------------------------------------------------
150: --
151: procedure chk_reason_for_submission
152: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
153: ,p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
154: ,p_effective_date in date
155: ,p_object_version_number in number
156: ) is
157: --

Line 215: (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE

211: -- |------------------------------- < chk_explanation > ----------------------------------------------|
212: -- ----------------------------------------------------------------------------------------------------
213: --
214: procedure chk_explanation
215: (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
216: ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
217: ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE
218: ,p_object_version_number in number
219: ) is

Line 216: ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE

212: -- ----------------------------------------------------------------------------------------------------
213: --
214: procedure chk_explanation
215: (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
216: ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
217: ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE
218: ,p_object_version_number in number
219: ) is
220: --

Line 217: ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE

213: --
214: procedure chk_explanation
215: (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
216: ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
217: ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE
218: ,p_object_version_number in number
219: ) is
220: --
221: l_proc varchar2(72) := 'chk_explanation';

Line 249: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE

245: -- |-------------------------------- < chk_service > ------------------------------------------------|
246: -- ---------------------------------------------------------------------------------------------------
247: --
248: procedure chk_service
249: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
250: ,p_service in ghr_pa_request_extra_info.rei_information5%TYPE
251: ,p_effective_date in date
252: ,p_object_version_number in number
253: ) is

Line 250: ,p_service in ghr_pa_request_extra_info.rei_information5%TYPE

246: -- ---------------------------------------------------------------------------------------------------
247: --
248: procedure chk_service
249: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
250: ,p_service in ghr_pa_request_extra_info.rei_information5%TYPE
251: ,p_effective_date in date
252: ,p_object_version_number in number
253: ) is
254: --