Application Developer Guide

Welcome to Oracle Applications Training

Agenda • Application Developer Guide / Application Object Library (AOL) • Question and Answers.

Application Developer Guide

Application Objects / Components •

Flexfields

•

Profile Options

•

Concurrent Programs (PL/SQL , Forms, Reports)

•

Request Group

•

Database (Table, View, Sequence ..)

•

Forms

•

Functions

•

Menus

•

Messages

•

Lookups

Application Developer Guide

Application Objects / Components

Profiles  Define Profile Options  System Profile Options  Personal / User Profile Options

Access Visible Updateable

Hierarchy Type Access Level Hierarchy

Security

Server

Organization

Site







Application



Resposibility



Server



Organization User

 





Application Developer Guide Application Objects / Components

Concurrent Programs Concurrent Executable Concurrent Program Request Set

Application Developer Guide Application Objects / Components

Request Group

Application Developer Guide Application Objects / Components

Database  Table  Sequence  View

Application Developer Guide Application Objects / Components

Lookup Codes

Application Developer Guide Database

Table

Application Developer Guide Database

Sequence

Application Developer Guide Database

View

Application Developer Guide Concurrent Programs

Request Set

Application Developer Guide Concurrent Programs

Concurrent Programs

Enter Domain or Global. If you choose Domain, the The Database Resourceis Manager is used to incompatibility resolved in at aOracle8i domain-specific Setchoose or Program Only tothis specify whether allocate andEnter manage resources among users and level. If you Global, thendatabase concurrent You can choose ALL_ROWS, yourwill concurrent program is incompatible with applications. program be considered globally incompatible FIRST_ROWS, Rules, or Choose. You this program and all its child requests (Set) or Resource consumer groups and resource plans provide a with your concurrent program, regardless of which would specify an optimizer mode only for with this program (Program Only). methoddomain for only specifying how to partition processing it is running in. a custom program may not perform resources amongthat different users. A resource consumer well with the default cost-based optimizer group defines a set of users who have similar resource (CBO) needs tuning usageand requirements

Application Developer Guide Profiles

Define Profiles

Application Developer Guide Profiles

System Profile Values

Application Developer Guide Profiles

Personal Profile Values

Application Developer Guide Concurrent Program

Concurrent Executable Host The execution file is a host script. Oracle Reports The execution file is an Oracle Reports file. PL/SQL Stored Procedure The execution file is a PL/SQL stored procedure / package. SQL*Loader The execution file is a SQL script. SQL*Plus The execution file is a SQL*Plus script. Spawned The execution file is a C or Pro*C program. Immediate The execution file is a program written to run as a subroutine of the concurrent manager. We recommend against defining new immediate concurrent programs, and suggest you use either a PL/SQL Stored Procedure or a Spawned C Program instead Request Set Stage Function PL/SQL Stored Function that can be uesd to calculate the completion statuses of request set stages. Java Stored Procedure The execution file is a Java stored procedure. Java Concurrent Program The execution file is a program written in Java. Multi Language Function The execution file is a function (MLS function) that supports running concurrent programs in multiple languages.

Application Developer Guide Concurrent Executable

Host The execution file is a host script. Example of a Shell Script APPSPWD=`echo $* | sed 's/\"//g' | awk 'BEGIN {RS=" "} /FCP_LOGIN/ {print $0}' | awk 'BEGIN {RS="="} NR==2 {printf"%s",$0}'` PROCESS_FLAG=`echo $* | sed 's/\"//g' | awk 'BEGIN {RS=" "} /PROCESS/ {print $0}' | awk 'BEGIN {RS="="} NR==2 {printf"%s",$0}'` export APPSPWD PROCESS_FLAG # code for process 1 if [ $PROCESS_FLAG -eq 1 ] then sqlplus -SILENT $APPSPWD << ENDSQL1 set serveroutput on UPDATE SUNINV_SME_C_ITEM SME SET SEGMENT1 = UPPER(SEGMENT1) WHERE MSI.SEGMENT1 =UPPER(SME.SEGMENT1) AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MP.ORGANIZATION_CODE = '001'); commit; exit 0 ENDSQL1

Application Developer Guide Concurrent Executable

PL/SQL Stored Procedure The execution file is a PL/SQL stored procedure / package. Example of a PL/SQL Stored Procedure CREATE OR REPLACE PROCEDURE xxwin_sample_code (p_errbuf_o OUT VARCHAR2, p_retcode_o OUT NUMBER ) IS BEGIN p_errbuf_o := NULL; p_retcode_o := 0; FND_FILE.PUT_LINE(FND_FILE.LOG, ' ***********************'); FND_FILE.PUT_LINE(FND_FILE.LOG, ' *** Sample Program ***'); FND_FILE.PUT_LINE(FND_FILE.LOG, ' *** Writing to Log ***'); FND_FILE.PUT_LINE(FND_FILE.LOG, ' ***********************'); EXCEPTION WHEN OTHERS THEN p_errbuf_o := SQLERRM;; p_retcode_o := 2; END xxwin_sample_code; /

Application Developer Guide Concurrent Executable

SQL*Loader The execution file is a SQL script. Example of a SQL* Loader Script LOAD DATA APPEND INTO TABLE SUNINV_SME_C_ITEM FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( SEGMENT1 , START_DATE_ACTIVE DATE 'MM/DD/RR' , TEMPLATE_NAME , MATERIAL_COST , MATERIAL_OH_RATE , ITEM_DESCRIPTION, ITEM_STATUS_CODE , REVISION , EFFECTIVITY_DATE DATE 'MM/DD/RR' , PROCESS_FLAG "10" , LAST_UPDATE_DATE SYSDATE , CREATION_DATE SYSDATE , CREATED_BY "-1" , LAST_UPDATED_BY "-1" , LAST_UPDATE_LOGIN "-1“ )