Tag: PL/SQL

Again, a simple piece of code: This also runs Active User concurrent program: declare  v_request_id number := -1;begin  –fnd_global.apps_initialize(user_id, resp_id, appl_resp_id)  fnd_global.apps_initialize(0, 20420, 1); –So sysadmin using responsibility System Administrator in application System Administration  –v_request_id : fnd_request.submit_request(application short name,concurrent program short name,argument1 =>,  argument2 =>))  v_request_id := fnd_request.submit_request(application=>’FND’,program=>’FNDSCURS’);  commit;  if v_request_id > 0  then    dbms_output.put_line(‘Successfully…