DBA Data[Home] [Help]

APPS.UMX_REG_REQUESTS_PVT dependencies on AME_CALLING_APPS

Line 1255: l_application_id AME_CALLING_APPS.FND_APPLICATION_ID%TYPE;

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,

Line 1256: l_transaction_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;

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