DBA Data[Home] [Help]

APPS.FND_GRANTS_PKG dependencies on FND_APPLICATION

Line 822: from fnd_application

818: if((X_CTX_RESP_APP_SHORT_NAME is not NULL)
819: AND (X_CTX_RESP_APP_SHORT_NAME <> '*GLOBAL*'))then
820: begin
821: select application_id into resp_appl_id
822: from fnd_application
823: where application_short_name = X_CTX_RESP_APP_SHORT_NAME;
824: exception
825: when no_data_found then
826: resp_appl_id := -1;

Line 832: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_APPLICATION');

828: if (resp_appl_id = -1) then
829: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
830: FND_MESSAGE.SET_TOKEN('VALUE', X_CTX_RESP_APP_SHORT_NAME);
831: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_SHORT_NAME');
832: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_APPLICATION');
833: app_exception.raise_exception;
834: end if;
835: else
836: resp_appl_id := -1;