1: PACKAGE BODY ICX_POR_MAP_CATEGORIES AS
2: /* $Header: ICXECMCB.pls 115.0 2002/11/20 19:35:43 sbgeorge noship $*/
3:
4: gNewCatIdTab dbms_sql.number_table;
5: gNewCatNameTab dbms_sql.varchar2_table;
6: gNewCatLangTab dbms_sql.varchar2_table;
7:
8: PROCEDURE clear_tables IS
1: PACKAGE BODY ICX_POR_MAP_CATEGORIES AS
2: /* $Header: ICXECMCB.pls 115.0 2002/11/20 19:35:43 sbgeorge noship $*/
3:
4: gNewCatIdTab dbms_sql.number_table;
5: gNewCatNameTab dbms_sql.varchar2_table;
6: gNewCatLangTab dbms_sql.varchar2_table;
7:
8: PROCEDURE clear_tables IS
9: BEGIN
2: /* $Header: ICXECMCB.pls 115.0 2002/11/20 19:35:43 sbgeorge noship $*/
3:
4: gNewCatIdTab dbms_sql.number_table;
5: gNewCatNameTab dbms_sql.varchar2_table;
6: gNewCatLangTab dbms_sql.varchar2_table;
7:
8: PROCEDURE clear_tables IS
9: BEGIN
10: gNewCatIdTab.DELETE;