DBA Data[Home] [Help]

APPS.GHR_UTILITY dependencies on GHR_PA_REQUESTS

Line 176: p_effective_date in ghr_pa_requests.effective_date%type,

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

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

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

Line 181: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,

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

Line 182: p_effective_date in ghr_pa_requests.effective_date%type)

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

Line 187: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,

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

Line 188: p_effective_date in ghr_pa_requests.effective_date%type,

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

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

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

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

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

Line 193: p_pa_request_id in ghr_pa_requests.pa_request_id%type)

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