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_NTS_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 270: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_NTS_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);
272: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_STAT_INT',cascade => TRUE);
273: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_CWLK_INT',cascade => TRUE);
274: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_CWLK_DTL_INT',cascade => TRUE);

Line 2121: IGS_OR_INST_NTS_INT NT

2117:
2118: CURSOR log_inst_note_rcount_cur(cp_batch_id IGS_OR_INST_INT.BATCH_ID%TYPE) IS
2119: SELECT COUNT(1) CNT,NT.STATUS STAT
2120: FROM IGS_OR_INST_INT INST,
2121: IGS_OR_INST_NTS_INT NT
2122: WHERE INST.BATCH_ID = cp_batch_id AND
2123: INST.INTERFACE_ID = NT.INTERFACE_ID
2124: GROUP BY NT.STATUS;
2125:

Line 2421: DELETE FROM IGS_OR_INST_NTS_INT WHERE STATUS = '1';

2417: WHERE ADR.INTERFACE_ID = INST.INTERFACE_ID);
2418:
2419: -- Table deletion logic for one level child
2420:
2421: DELETE FROM IGS_OR_INST_NTS_INT WHERE STATUS = '1';
2422:
2423: UPDATE IGS_OR_INST_INT INST
2424: SET STATUS = '4',ERROR_CODE='E058'
2425: WHERE STATUS = '1' AND

Line 2427: FROM IGS_OR_INST_NTS_INT NTS

2423: UPDATE IGS_OR_INST_INT INST
2424: SET STATUS = '4',ERROR_CODE='E058'
2425: WHERE STATUS = '1' AND
2426: EXISTS (SELECT 1
2427: FROM IGS_OR_INST_NTS_INT NTS
2428: WHERE NTS.INTERFACE_ID = INST.INTERFACE_ID);
2429:
2430: FOR l_inst_rec IN log_inst_rcount_cur(p_batch_id) LOOP
2431: IF l_inst_rec.STAT = '1' THEN