APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_CLASSIFICS_SG

Line 295: FROM HZ_IMP_CLASSIFICS_SG

291: AND batch_mode_flag = p_batch_mode_flag
292: AND rownum = 1)
293: OR EXISTS (
294: SELECT 'Y'
295: FROM HZ_IMP_CLASSIFICS_SG
296: WHERE batch_id = p_batch_id
297: AND batch_mode_flag = p_batch_mode_flag
298: AND rownum = 1)
299: OR EXISTS (

Line 368: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CLASSIFICS_SG TRUNCATE PARTITION batchpar DROP STORAGE';

364: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_PARTIES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
365: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
366: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTPTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
367: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CREDITRTNGS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
368: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CLASSIFICS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
369: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINREPORTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
370: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINNUMBERS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
371: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_RELSHIPS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
372: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';

Line 389: DELETE HZ_IMP_CLASSIFICS_SG

385: AND batch_mode_flag = P_BATCH_MODE_FLAG;
386: DELETE HZ_IMP_CREDITRTNGS_SG
387: WHERE batch_id = P_BATCH_ID
388: AND batch_mode_flag = P_BATCH_MODE_FLAG;
389: DELETE HZ_IMP_CLASSIFICS_SG
390: WHERE batch_id = P_BATCH_ID
391: AND batch_mode_flag = P_BATCH_MODE_FLAG;
392: DELETE HZ_IMP_FINREPORTS_SG
393: WHERE batch_id = P_BATCH_ID