DBA Data[Home] [Help]

APPS.GHR_UTILITY dependencies on GHR_PA_REQUESTS

Line 179: p_effective_date in ghr_pa_requests.effective_date%type,

175: );
176:
177:
178: procedure process_nfc_auth_date(
179: p_effective_date in ghr_pa_requests.effective_date%type,
180: p_pa_request_id in ghr_pa_requests.pa_request_id%type);
181:
182: function get_nfc_prev_noa(
183: p_person_id in per_people_f.person_id%type,

Line 180: p_pa_request_id in ghr_pa_requests.pa_request_id%type);

176:
177:
178: procedure process_nfc_auth_date(
179: p_effective_date in ghr_pa_requests.effective_date%type,
180: p_pa_request_id in ghr_pa_requests.pa_request_id%type);
181:
182: function get_nfc_prev_noa(
183: p_person_id in per_people_f.person_id%type,
184: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,

Line 184: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,

180: p_pa_request_id in ghr_pa_requests.pa_request_id%type);
181:
182: function get_nfc_prev_noa(
183: p_person_id in per_people_f.person_id%type,
184: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
185: p_effective_date in ghr_pa_requests.effective_date%type)
186: RETURN VARCHAR2;
187:
188: procedure get_nfc_auth_codes(

Line 185: p_effective_date in ghr_pa_requests.effective_date%type)

181:
182: function get_nfc_prev_noa(
183: p_person_id in per_people_f.person_id%type,
184: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
185: p_effective_date in ghr_pa_requests.effective_date%type)
186: RETURN VARCHAR2;
187:
188: procedure get_nfc_auth_codes(
189: p_person_id in per_people_f.person_id%type,

Line 190: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,

186: RETURN VARCHAR2;
187:
188: procedure get_nfc_auth_codes(
189: p_person_id in per_people_f.person_id%type,
190: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
191: p_effective_date in ghr_pa_requests.effective_date%type,
192: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
193: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type);
194:

Line 191: p_effective_date in ghr_pa_requests.effective_date%type,

187:
188: procedure get_nfc_auth_codes(
189: p_person_id in per_people_f.person_id%type,
190: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
191: p_effective_date in ghr_pa_requests.effective_date%type,
192: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
193: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type);
194:
195: function get_nfc_conv_action_code(

Line 192: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,

188: procedure get_nfc_auth_codes(
189: p_person_id in per_people_f.person_id%type,
190: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
191: p_effective_date in ghr_pa_requests.effective_date%type,
192: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
193: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type);
194:
195: function get_nfc_conv_action_code(
196: p_pa_request_id in ghr_pa_requests.pa_request_id%type)

Line 193: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type);

189: p_person_id in per_people_f.person_id%type,
190: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
191: p_effective_date in ghr_pa_requests.effective_date%type,
192: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
193: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type);
194:
195: function get_nfc_conv_action_code(
196: p_pa_request_id in ghr_pa_requests.pa_request_id%type)
197: RETURN NUMBER;

Line 196: p_pa_request_id in ghr_pa_requests.pa_request_id%type)

192: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
193: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type);
194:
195: function get_nfc_conv_action_code(
196: p_pa_request_id in ghr_pa_requests.pa_request_id%type)
197: RETURN NUMBER;
198:
199: end ghr_utility;