eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_OR_INST_IMP_001 dependencies on IGS_OR_INST_CON_INT

Line 261: -- 'IGS_OR_ADRUSGE_INT,IGS_OR_ADR_INT,IGS_OR_INST_CON_INT,IGS_OR_INST_CPHN_INT,IGS_OR_INST_INT,IGS_OR_INST_NTS_INT,IGS_OR_INST_SDTL_INT,

257: l_return := fnd_installation.get_app_info('IGS', l_status, l_industry, l_schema);
258:
259: IF l_schema IS NOT NULL THEN
260: -- gather statistics as the new INTERFACE batch program standard.
261: -- 'IGS_OR_ADRUSGE_INT,IGS_OR_ADR_INT,IGS_OR_INST_CON_INT,IGS_OR_INST_CPHN_INT,IGS_OR_INST_INT,IGS_OR_INST_NTS_INT,IGS_OR_INST_SDTL_INT,
262: -- IGS_OR_INST_STAT_INT,IGS_OR_CWLK_INT,IGS_OR_CWLK_DTL_INT,IGS_OR_INST_BTCH_INT';
263: -- IGS.L change, added gather statistics for table IGS_OR_ADR_INT
264:
265: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_ADR_INT',cascade => TRUE);

Line 267: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_CON_INT',cascade => TRUE);

263: -- IGS.L change, added gather statistics for table IGS_OR_ADR_INT
264:
265: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_ADR_INT',cascade => TRUE);
266: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_ADRUSGE_INT',cascade => TRUE);
267: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_CON_INT',cascade => TRUE);
268: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_CPHN_INT',cascade => TRUE);
269: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_INT',cascade => TRUE);
270: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_NTS_INT',cascade => TRUE);
271: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_SDTL_INT',cascade => TRUE);

Line 2165: IGS_OR_INST_CON_INT CON

2161:
2162: CURSOR log_inst_con_rcount_cur(cp_batch_id IGS_OR_INST_INT.BATCH_ID%TYPE) IS
2163: SELECT COUNT(1) CNT,CON.STATUS STAT
2164: FROM IGS_OR_INST_INT INST,
2165: IGS_OR_INST_CON_INT CON
2166: WHERE INST.BATCH_ID = cp_batch_id AND
2167: INST.INTERFACE_ID = CON.INTERFACE_ID
2168: GROUP BY CON.STATUS;
2169:

Line 2179: IGS_OR_INST_CON_INT CON,

2175:
2176: CURSOR log_inst_cphn_rcount_cur(cp_batch_id IGS_OR_INST_INT.BATCH_ID%TYPE) IS
2177: SELECT COUNT(1) CNT,CPHN.STATUS STAT
2178: FROM IGS_OR_INST_INT INST,
2179: IGS_OR_INST_CON_INT CON,
2180: IGS_OR_INST_CPHN_INT CPHN
2181: WHERE INST.BATCH_ID = cp_batch_id AND
2182: INST.INTERFACE_ID = CON.INTERFACE_ID AND
2183: CON.INTERFACE_CONTACTS_ID = CPHN.INTERFACE_CONT_ID

Line 2369: DELETE FROM IGS_OR_INST_CON_INT CON

2365:
2366: -- Table deletion logic for 2 level Childs -- Contact and Contact Phone
2367: DELETE FROM IGS_OR_INST_CPHN_INT WHERE STATUS = '1';
2368:
2369: DELETE FROM IGS_OR_INST_CON_INT CON
2370: WHERE STATUS = '1' AND
2371: NOT EXISTS (SELECT 1
2372: FROM IGS_OR_INST_CPHN_INT CPHN
2373: WHERE CON.INTERFACE_CONTACTS_ID = CPHN.INTERFACE_CONT_ID AND

Line 2380: FROM IGS_OR_INST_CON_INT CON

2376: UPDATE IGS_OR_INST_INT INST
2377: SET STATUS = '4',ERROR_CODE = 'E055'
2378: WHERE STATUS = '1' AND
2379: EXISTS (SELECT 1
2380: FROM IGS_OR_INST_CON_INT CON
2381: WHERE CON.INTERFACE_ID = INST.INTERFACE_ID);
2382:
2383: -- Table deletion logic for 2 level Childs -- Statistics and Statistics Details
2384: