DBA Data[Home] [Help]

APPS.UMX_REG_REQUESTS_PVT dependencies on AME_CALLING_APPS

Line 1107: l_application_id AME_CALLING_APPS.FND_APPLICATION_ID%TYPE;

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,

Line 1108: l_transaction_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;

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