Below query can be used to add (any)responsibility from backend database:BEGINFND_USER_PKG.ADDRESP ('XX_USERNAME', — Username'SYSADMIN', –application short name'SYSTEM_ADMINISTRATOR', — Responsibility Key'STANDARD', — Security Group Key'Sysadmin Responsibility added due to work', –Descriptionsysdate, –Start datenull –End date);COMMIT;DBMS_OUTPUT.put_line ('Responsibility Added Successfully');EXCEPTIONWHEN OTHERSTHENDBMS_OUTPUT.put_line (' Responsibility is not added due to '|| SQLCODE|| SUBSTR ...
API - pay_element_entry_api.create_element_entryset serveroutput on;DECLAREl_date date := '01-APR-2020'; /*Start date of element*/x NUMBER := 0;input_value_id2 number;input_value_id3 number;LV_ERROR_MSG VARCHAR2(240);LD_EFFECTIVE_START_DATE DATE;LD_EFFECTIVE_END_DATE DATE;LN_ELEMENT_ENTRY_ID NUMBER;LN_OBJECT_VERSION_NUMBER NUMBER;LB_CREATE_WARNING BOOLEAN;lb_delete_warning BOOLEAN;Cursor CREATE_ELEMENT_CUR Is ...
