APPS.GMO_PURGE dependencies on GMO_INSTR_ATTRIBUTES_T

Line 91: execute immediate 'truncate table GMO_INSTR_ATTRIBUTES_T';

87: execute immediate 'truncate table GMO_INSTR_EREC_INSTANCE_T';
88: execute immediate 'truncate table GMO_INSTR_INSTANCE_T';
89: execute immediate 'truncate table GMO_INSTR_SET_INSTANCE_T';
90: /* Truncate Attributes table in the end */
91: execute immediate 'truncate table GMO_INSTR_ATTRIBUTES_T';
92: RETURN;
93: END IF;
94:
95: /* Delete Definition temporary tables */

Line 107: delete GMO_INSTR_ATTRIBUTES_T where LAST_UPDATE_DATE <= P_END_DATE;

103: delete GMO_INSTR_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;
104: delete GMO_INSTR_SET_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;
105:
106: /* Truncate Attributes table in the end */
107: delete GMO_INSTR_ATTRIBUTES_T where LAST_UPDATE_DATE <= P_END_DATE;
108:
109: IF(P_COMMIT = GMO_CONSTANTS_GRP.YES) THEN
110: COMMIT;
111: END IF;