APPS.ASF_OSI_DENORM_REF dependencies on AS_OSI_LEADS_DENORM

Line 108: v_Stmt := 'TRUNCATE TABLE OSM.AS_OSI_LEADS_DENORM reuse storage';

104: -- LOCK TABLE as_sales_credits_denorm in EXCLUSIVE mode;
105: RETCODE := '0';
106:
107: v_CursorID := DBMS_SQL.OPEN_CURSOR;
108: v_Stmt := 'TRUNCATE TABLE OSM.AS_OSI_LEADS_DENORM reuse storage';
109: dbms_sql.parse(v_CursorID,v_Stmt ,dbms_sql.native);
110: v_Dummy := DBMS_SQL.EXECUTE(v_CursorID);
111: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
112:

Line 138: INSERT INTO AS_OSI_LEADS_DENORM

134: tOvmTab(vOvmCount).ovm_value := null;
135: end if;
136: BEGIN
137: for i in 1..vOvmCount loop
138: INSERT INTO AS_OSI_LEADS_DENORM
139: (last_update_date,
140: last_updated_by,
141: creation_date,
142: created_by,