DBA Data[Home] [Help]

APPS.FND_GRANTS_PKG dependencies on FND_SECURITY_GROUPS

Line 801: from fnd_security_groups

797: if((X_CTX_SECURITY_GROUP_KEY is not NULL)
798: AND (X_CTX_SECURITY_GROUP_KEY <> '*GLOBAL*'))then
799: begin
800: select security_group_id into secgrp_id
801: from fnd_security_groups
802: where security_group_key = X_CTX_SECURITY_GROUP_KEY;
803: exception
804: when no_data_found then
805: secgrp_id := -1;

Line 811: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_SECURITY_GROUPS');

807: if (secgrp_id = -1) then
808: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
809: FND_MESSAGE.SET_TOKEN('VALUE', X_CTX_SECURITY_GROUP_KEY);
810: FND_MESSAGE.SET_TOKEN('COLUMN', 'SECURITY_GROUP_KEY');
811: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_SECURITY_GROUPS');
812: app_exception.raise_exception;
813: end if;
814: else
815: secgrp_id := -1;