We can also register the Table using Application DBA Data Definitions (AD-DD) Package from the Back End. You can also use the AD_DD API to delete the registrations of tables and columns from Oracle Application Object Library tables. To alter a registration you should first delete the registration and then reregister the table or column. You should delete the column registration first, then the table registration.
procedure register_table(p_appl_short_name in varchar2,
p_tab_name in varchar2, p_tab_type in varchar2,
p_next_extent in number default 512, p_pct_free in number default 10,
p_pct_used in number default 70);
Procedure register_column (p_appl_short_name in varchar2,
p_tab_name in varchar2, p_col_name in varchar2,
p_col_seq in number, p_col_type in varchar2,
p_col_width in number, p_nullable in varchar2,
p_translate in varchar2, p_precision in number default null,
p_scale in number default null);
procedure delete_table (p_appl_short_name in varchar2, p_tab_name in varchar2);
procedure delete_column (p_appl_short_name in varchar2,
p_tab_name in varchar2, p_col_name in varchar2);
SQL> ed
Wrote file afiedt.buf
1 BEGIN
2 AD_DD.REGISTER_TABLE(‘PPR’ , ‘PLAN_PARTS’ , ‘T’);
3* END;
SQL> /
PL/SQL Procedure Succesfully Completed.
SQL> ed
Note : Table can be registered from Front End by Application Developer
or Back End by Database Administrator.
