Add the following code in Procedure Event for the Event Name WHEN-NEW-FORM-INSTANCE in Custom.pll. to make the responsibility of a user read-only. All you need to give/set the responsibility.
Also read : Oracle recommendation method to make read only responsibility
Also read : How to compile custom.pll in Oracle Apps R12
BEGIN
IF EVENT_NAME = 'WHEN-NEW-FORM-INSTANCE'
THEN
--Responsibility ID
IF FND_PROFILE.VALUE ('RESP_ID') = 12345
THEN
BEGIN
COPY ('Entering app_form.query_only_mode.', 'global.frd_debug');
--QUERY_ONLY="YES"
COPY ('YES', 'PARAMETER.QUERY_ONLY');
--Disabling the save and accept standard menus in form
APP_MENU2.SET_PROP ('FILE.SAVE', ENABLED, PROPERTY_OFF);
APP_MENU2.SET_PROP ('FILE.ACCEPT', ENABLED, PROPERTY_OFF);
-- Get the current form
FORM_NAME := NAME_IN ('system.current_form');
--Get the current block
BLOCK_NAME := GET_FORM_PROPERTY (FORM_NAME, FIRST_BLOCK);
--loop to get all datablocks in current form
WHILE (BLOCK_NAME IS NOT NULL)
LOOP
IF (GET_BLOCK_PROPERTY (BLOCK_NAME, BASE_TABLE) IS NOT NULL)
THEN
--Set insert, update and delete not allowed
SET_BLOCK_PROPERTY (BLOCK_NAME,
INSERT_ALLOWED,
PROPERTY_FALSE);
SET_BLOCK_PROPERTY (BLOCK_NAME,
UPDATE_ALLOWED,
PROPERTY_FALSE);
SET_BLOCK_PROPERTY (BLOCK_NAME,
DELETE_ALLOWED,
PROPERTY_FALSE);
END IF;
BLOCK_NAME := GET_BLOCK_PROPERTY (BLOCK_NAME, NEXTBLOCK);
END LOOP;
END QUERY_ONLY_MODE;
END IF;
END IF;
END;
Also read : Oracle recommendation method to make read only responsibility
Also read : How to compile custom.pll in Oracle Apps R12

5AE0308C
ReplyDeleteagoda güvenilir mi
agoda güvenilir mi
agoda güvenilir mi
5F7F64C5
ReplyDeleteForum
Forum
Forum
Forum
Forum
Forum
Forum
Forum
Forum
0099DB92
ReplyDeleteAmasya
Rize
Erzurum
Sivas
Urfa
Adıyaman
Yalova
Isparta
Muş