DBA Data[Home] [Help]

APPS.FND_GRANTS_PKG dependencies on FND_RESPONSIBILITY

Line 843: from fnd_responsibility

839: if((X_CTX_RESP_KEY is not NULL)
840: AND (X_CTX_RESP_KEY <> '*GLOBAL*'))then
841: begin
842: select responsibility_id into resp_id
843: from fnd_responsibility
844: where responsibility_key = X_CTX_RESP_KEY
845: and application_id = resp_appl_id;
846: exception
847: when no_data_found then

Line 854: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_RESPONSIBILITY');

850: if (resp_id = -1) then
851: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
852: FND_MESSAGE.SET_TOKEN('VALUE', X_CTX_RESP_KEY);
853: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESPONSIBILITY_KEY');
854: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_RESPONSIBILITY');
855: app_exception.raise_exception;
856: end if;
857: else
858: resp_id := -1;