1251: x_active_from out NOCOPY varchar2,
1252: x_active_to out NOCOPY varchar2,
1253: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is
1254:
1255: l_application_id AME_CALLING_APPS.FND_APPLICATION_ID%TYPE;
1256: l_transaction_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
1257:
1258: cursor get_reg_req_info_from_userid (p_user_id in FND_USER.USER_ID%TYPE) is
1259: select reg_request_id, status_code, ame_application_id,
1252: x_active_to out NOCOPY varchar2,
1253: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is
1254:
1255: l_application_id AME_CALLING_APPS.FND_APPLICATION_ID%TYPE;
1256: l_transaction_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
1257:
1258: cursor get_reg_req_info_from_userid (p_user_id in FND_USER.USER_ID%TYPE) is
1259: select reg_request_id, status_code, ame_application_id,
1260: ame_transaction_type_id, requested_username, justification