APPS.AZ_DELETE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

PROCEDURE delete_all(p_request_id IN NUMBER,
          	 p_table_name IN VARCHAR2) IS


v_source_list         TYP_NEST_TAB_VARCHAR;

Line: 18

	--gather stats on the table from which the records are to be deleted
	FND_STATS.GATHER_TABLE_STATS('AZ',p_table_name);

Line: 20

        execute immediate 'select distinct(source) from '||p_table_name||
                          ' where request_id='||p_request_id
                          BULK COLLECT INTO v_source_list;

Line: 27

                        delete_source(p_request_id,v_source_list(i),p_table_name);

Line: 32

                            'DELETE_ALL: Error while deleting records for a given source:'||v_source_list(i));

Line: 45

END delete_all;

Line: 49

PROCEDURE delete_source(p_request_id IN NUMBER,p_source IN VARCHAR2,p_table_name IN VARCHAR2)
IS
v_id_list             TYP_NEST_TAB_NUMBER;

Line: 56

    open cur_id for 'select id from '||p_table_name||
                    ' where request_id=:1 and source=:2'
                    USING p_request_id,p_source;

Line: 63

    execute immediate 'delete from '||p_table_name||' where
                        request_id=:1 and source=:2 and
                        id=:3' using p_request_id,p_source,v_id_list(i);

Line: 75

END delete_source;