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_ADRUSGE_INT

Line 24: -- 3. Gather statistics done for IGS_OR_ADRUSGE_INT table

20: -- 1. Logging mechanism introduced, FND_FILE.PUT_LINE replaced with methods in FND_LOG package
21: -- log writer procedure modified for this purpose and package level variables declared, intialised
22: -- to control logging.
23: -- 2. Cursors that utilise variables in SELECT statements are replaced with cursor parameters
24: -- 3. Gather statistics done for IGS_OR_ADRUSGE_INT table
25: -- 4. New procedure validate_inst_code written to validate new and exst institution codes with
26: -- crosswalk institution code
27: -- 5. New procedure delete_log_int_rec written to take statistics, log and delete completed
28: -- records in the interface tables. The IGS_OR_INST_INT table will also be updated be updated with

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 266: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_ADRUSGE_INT',cascade => TRUE);

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);
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);

Line 2210: IGS_OR_ADRUSGE_INT ADRU

2206: CURSOR log_inst_adru_rcount_cur(cp_batch_id IGS_OR_INST_INT.BATCH_ID%TYPE) IS
2207: SELECT COUNT(1) CNT,ADRU.STATUS STAT
2208: FROM IGS_OR_INST_INT INST,
2209: IGS_OR_ADR_INT ADR,
2210: IGS_OR_ADRUSGE_INT ADRU
2211: WHERE INST.BATCH_ID = cp_batch_id AND
2212: INST.INTERFACE_ID = ADR.INTERFACE_ID AND
2213: ADR.INTERFACE_ADDR_ID = ADRU.INTERFACE_ADDR_ID
2214: GROUP BY ADRU.STATUS;

Line 2403: DELETE FROM IGS_OR_ADRUSGE_INT WHERE STATUS = '1';

2399: WHERE STAT.INTERFACE_ID = INST.INTERFACE_ID);
2400:
2401: -- Table deletion logic for 2 level Childs -- Address and Address Usage
2402:
2403: DELETE FROM IGS_OR_ADRUSGE_INT WHERE STATUS = '1';
2404:
2405: DELETE FROM IGS_OR_ADR_INT ADR
2406: WHERE STATUS = '1' AND
2407: NOT EXISTS (SELECT 1

Line 2408: FROM IGS_OR_ADRUSGE_INT ADU

2404:
2405: DELETE FROM IGS_OR_ADR_INT ADR
2406: WHERE STATUS = '1' AND
2407: NOT EXISTS (SELECT 1
2408: FROM IGS_OR_ADRUSGE_INT ADU
2409: WHERE ADR.INTERFACE_ADDR_ID = ADU.INTERFACE_ADDR_ID AND
2410: ADU.STATUS = '3');
2411:
2412: UPDATE IGS_OR_INST_INT INST