1103: x_active_from out NOCOPY varchar2,
1104: x_active_to out NOCOPY varchar2,
1105: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is
1106:
1107: l_application_id AME_CALLING_APPS.FND_APPLICATION_ID%TYPE;
1108: l_transaction_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
1109:
1110: cursor get_reg_req_info_from_userid (p_user_id in FND_USER.USER_ID%TYPE) is
1111: select reg_request_id, status_code, ame_application_id,
1104: x_active_to out NOCOPY varchar2,
1105: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is
1106:
1107: l_application_id AME_CALLING_APPS.FND_APPLICATION_ID%TYPE;
1108: l_transaction_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
1109:
1110: cursor get_reg_req_info_from_userid (p_user_id in FND_USER.USER_ID%TYPE) is
1111: select reg_request_id, status_code, ame_application_id,
1112: ame_transaction_type_id, requested_username, justification