DBA Data[Home] [Help]

PACKAGE: APPS.AZ_DELETE

Source


1 PACKAGE "AZ_DELETE" AS
2 /* $Header: azdeletes.pls 120.3.12000000.1 2007/02/20 13:13:11 lmathur noship $ */
3     TYPE TYP_NEST_TAB_VARCHAR IS TABLE OF VARCHAR2(4000);
4     TYPE TYP_NEST_TAB_NUMBER IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 --procedure to delete data from az_reporter_data and az_diff_results table
6 --This procedure assumes that the column 'source' is present in both the tables
7 PROCEDURE delete_all(p_request_id IN NUMBER, p_table_name IN VARCHAR2);
8 PROCEDURE delete_source(p_request_id IN NUMBER,p_source IN VARCHAR2,p_table_name IN VARCHAR2);
9 END;