APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_CONTACTROLES_SG

Line 307: FROM HZ_IMP_CONTACTROLES_SG

303: AND batch_mode_flag = p_batch_mode_flag
304: AND rownum = 1)
305: OR EXISTS (
306: SELECT 'Y'
307: FROM HZ_IMP_CONTACTROLES_SG
308: WHERE batch_id = p_batch_id
309: AND batch_mode_flag = p_batch_mode_flag
310: AND rownum = 1)
311: OR EXISTS (

Line 373: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTROLES_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';
373: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTROLES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
374: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSUSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
375:
376: ELSE
377: DELETE HZ_IMP_PARTIES_SG

Line 404: DELETE HZ_IMP_CONTACTROLES_SG

400: AND batch_mode_flag = P_BATCH_MODE_FLAG;
401: DELETE HZ_IMP_CONTACTS_SG
402: WHERE batch_id = P_BATCH_ID
403: AND batch_mode_flag = P_BATCH_MODE_FLAG;
404: DELETE HZ_IMP_CONTACTROLES_SG
405: WHERE batch_id = P_BATCH_ID
406: AND batch_mode_flag = P_BATCH_MODE_FLAG;
407: DELETE HZ_IMP_ADDRESSUSES_SG
408: WHERE batch_id = P_BATCH_ID