APPS.IGS_UC_PURGE_INT_DATA SQL Statements

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

Line: 12

		  This process is created to delete all records from the Interface tables
		  which have been successfully processed and populated into the main UCAS
		  tables or have been obsoleted by a change in data coming from UCAS.

    Know limitations, enhancements or remarks
    Change History
    Who             When            What
    (reverse chronological order - newest change first)
    anwest          18-JAN-2006     Bug# 4950285 R12 Disable OSS Mandate
    dsridhar        14-JUL-2003     Changed package name to CAPS, changed concatenation
    ***************************************************************/

    TYPE InterfaceTableNames IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line: 102

	   --Delete statement to delete obsolete and processed data
           IF p_del_obsolete_data = 'Y' OR p_del_proc_data = 'Y' THEN

	          l_statement := 'DECLARE
				  BEGIN
		                     DELETE FROM ' || InterfaceTables(j) || l_where || ' ; ' || '