Oracle Apps Technical Stuff
Wednesday, June 19, 2013
How to Search all of the Profile Options for a Specific Value
›
SELECT p.profile_option_name SHORT_NAME , n.user_profile_option_name NAME , DECODE ( v.level_id ...
Script to Submit the Workflow Background Processor from Backend
›
DECLARE l_errbuf VARCHAR2 (1000); l_retcode VARCHA...
Monday, June 17, 2013
Script To Send an Email in HTML Format using Oracle PL/SQL
›
DECLARE p_from VARCHAR2 (2000) := 'xyz@xyz.com'; p_to ...
Friday, May 31, 2013
Script To Get the application usernames and passwords
›
-- Package Specification CREATE OR REPLACE PACKAGE get_user_password AS FUNCTION decrypt ( KEY IN ...
Friday, April 26, 2013
API To Add Responsibilty To User
›
/* Grant Particular Responsibility to a User */ SET serveroutput on DECLARE v_user_name VARCHAR...
‹
›
Home
View web version