TABLE REGISTRATION

PROCEDURE REGISTER_TABLE
(APPLICATION_SHORTNAME IN VARCHAR2
,TABLE_NAME IN VARCHAR2
,TABLE_TYPE IN VARCHAR2
,NEXE_EXTENT IN NUMBER DEFAULT 512
,PCT_FREE IN NUMBER DEFAULT 10
,PCT_USED IN NUMBER DEFAULT 70);

PROCEDURE REGISTER_COLUMN
(
APPLICATION_SHORT_NAME IN VARCHAR2
,COL_NAME IN VARCHAR2
,COL_SEQ IN NUMBER
,COL_TYPE IN VARCHAR2
,COL_WIDTH IN NUMBER
,NULLABLE IN VARCHAR2
,TRANSLATABLE IN VARCHAR2
,PRECISION IN NUMBER DEFAULT NULL
,SCALE IN NUMBER DEFAULT NULL)


TABLE REGISTRATION IN HR MODULE

create table XXEMPLOYEEDTLS
(
EMPID NUMBER
,E_NAME VARCHAR2(100)
,E_LASTNAME VARCHAR2(100)
,E_FIRST_NAME VARCHAR2(100)
,E_JOIN_DATE DATE
,E_POSITION VARCHAR2(100)
,E_PROJECT VARCHAR2(100)
,E_HRA NUMBER
,E_TAX NUMBER
,E_PF NUMBER
,E_TOTALSALARY NUMBER
,E_PACKAGE NUMBER
,LAST_UPDATED_BY NUMBER
,LAST_UPDATE_LOGIN NUMBER
,CREATION_DATE DATE
,CREATED_BY NUMBER
,LAST_UPDATE_DATE DATE
,ATTRIBUTE1 VARCHAR2(100)
,ATTRIBUTE2 VARCHAR2(100)
,ATTRIBUTE3 VARCHAR2(100)
,ATTRIBUTE_CATEGORY VARCHAR2(100)
)

);

grant all on xxemployeedtls to apps


CREATE public synonym apps.XXEMPLOYEEDTLS FOR HR.XXEMPLOYEEDTLS;


EXEC AD_DD.REGISTER_TABLE('PER','XXEMPLOYEEDTLS','T',8,60,40);

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','EMPID',1,'NUMBER',20,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_NAME',2,'VARCHAR2',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_LASTNAME',3,'VARCHAR2',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_FIRST_NAME',4,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_JOIN_DATE',5,'DATE',38,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_POSITION',6,'VARCHAR2',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_PROJECT',7,'VARCHAR2',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_HRA',8,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_TAX',9,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_PF',10,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_TOTALSALARY',11,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_PACKAGE',12,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','LAST_UPDATED_BY',13,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','LAST_UPDATE_LOGIN',14,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','CREATION_DATE',15,'DATE',38,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','CREATED_BY',16,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','LAST_UPDATE_DATE',17,'DATE',38,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','ATTRIBUTE1',18,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','ATTRIBUTE2',19,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','ATTRIBUTE3',20,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','ATTRIBUTE_CATEGORY',21,'VARCHAR2',100,'Y','N');

check table registration
NAVIGATION
application developer>>database>>table

query mode
enter your table name.

Basic Differences of OAF and D2K Forms

--->It connects to single session of Oracle and sticks to the single Oracle Database session.
--->when a button is pressessed in Form need to add the code for it and in oa pages
you will add a controller java code to handle events like Form Submit button clicks.
--->In handling the values for Form we use Block.Fieldname where as in oa pages
use getparamenter

HOW TO SET WHO COLUMNS TO FORM and HOW TO SET CALENDAR TO ITEM

how to set who columns?
in form level or item level
open pre-insert ,pre-update,pre-delete triggers
use the following code
fnd_standard.set_who;

(WHO Columns are
last_updated_by number
,last_update_login number
,creation_date date
,created_by number
,last_update_date date)

how to set the calendar to an item?

go to property pallete of an item
lov as enable list lamp
and validate from list as NO
create a trigger key-list-val at item level
use d following code
calendar.show;

FORM REGISTRATION

FORM REGISTRATION

first attach form to your form menu
and user form name to function
and function to menu
and attach menu to responsibility


open the oracla applications

-->go to application developer responsibility

-->navigation for registiring form

application>>form
form -- your custom from name
application -- your application name (i.e responsibility name to which responsibility you want to save)
user from name -- your user form name for reference in front end(give any name)
save it

-->navigation to register funcion

application >>from
description tab
funcion -- your function name
user function name -- your user function name to refer in front end

form tab
funcion --automatically populates the function name
form -- user form name
save it

find out the menu for your application

-->navigation to register menu
application>>menu

open your particualar menu
seq -- give the seq no which is not given
prompt -- how do u want display your form in front end(optional)
submenu -- if you want to attach any other menu you can attach here(optional)
function -- give your user function name.
save it

go to your particual responsibility and open the form .

CUSTOM FORM DEVELOPMENT

custom form development

take the template.fmb
-->Delete detailblock and blockname blocks in data block
-->Delete blockname in windows and as well in canvas
-->create datablock(xxdatablock) with your custom table to the custom form
-->create new canvas(xxcan) and new window(xxwin) for datablock(xxdatablock)
-->go to form property pallete and define first navigation data block as your new datablock(ie xxdatablock)
-->go to window property pallete define primary canvas as your canvas name (xxcan)
-->go to canvas property pallete define window as your new window (xxwin)
-->go to form level triggers and open "pre form trigger" define your window name
app_window.set_window_position('xxwin', 'FIRST_WINDOW');
i.e your defining your first window as xxwin
-->go to program units and open package body

if (wnd = 'xxwin') then
app_window.close_first_window;
give the window name
i.e to identify the first window and to close the form and define master detail relation ship of the form.

then compile the form and generate the fmx

generation of fmx

• f60gen module=$AU_TOP/forms/US/custom_form.fmb module_type=form user=apps output_file=$custom_TOP/forms/US/custom_FORM.fmx compile_all=special batch=no

then register in apps