eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DOM_SECURITY_PUB dependencies on DOM_FOLDER_FILE_MEMBERSHIPS

Line 485: -- Insert to DOM_FOLDER_FILE_MEMBERSHIPS

481: );
482: IF(l_rows = 0) THEN
483: */
484:
485: -- Insert to DOM_FOLDER_FILE_MEMBERSHIPS
486: -- Required while revoking roles.
487: INSERT INTO DOM_FOLDER_FILE_MEMBERSHIPS
488: (
489: REPOSITORY_ID,

Line 487: INSERT INTO DOM_FOLDER_FILE_MEMBERSHIPS

483: */
484:
485: -- Insert to DOM_FOLDER_FILE_MEMBERSHIPS
486: -- Required while revoking roles.
487: INSERT INTO DOM_FOLDER_FILE_MEMBERSHIPS
488: (
489: REPOSITORY_ID,
490: REPOSITORY_ITEM_ID,
491: REPOSITORY_ITEM_TYPE,

Line 821: DELETE FROM DOM_FOLDER_FILE_MEMBERSHIPS

817:
818: END IF;
819:
820: -- Delete from
821: DELETE FROM DOM_FOLDER_FILE_MEMBERSHIPS
822: WHERE REPOSITORY_ID = l_node_id
823: AND REPOSITORY_ITEM_ID = l_media_id
824: AND REPOSITORY_ITEM_TYPE = l_file_type
825: AND ENTITY_NAME = l_entity_name

Line 994: FROM DOM_FOLDER_FILE_MEMBERSHIPS

990: l_party_type := 'USER';
991: END IF;
992:
993: SELECT count(*) INTO l_count
994: FROM DOM_FOLDER_FILE_MEMBERSHIPS
995: WHERE REPOSITORY_ITEM_ID = p_file_id
996: AND REPOSITORY_ID = p_repos_id
997: AND PARTY_ID = p_party_id
998: AND PARTY_TYPE = l_party_type