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_STAT

Line 100: cp_close_ind igs_or_inst_stat.closed_ind%TYPE) is select 'X' from

96:
97: c_institution_type_rec c_institution_type%rowtype;
98:
99: cursor c_institution_stat(cp_institution_stat igs_or_inst_int.institution_status%TYPE,
100: cp_close_ind igs_or_inst_stat.closed_ind%TYPE) is select 'X' from
101: igs_or_inst_stat where
102: institution_status = cp_institution_stat
103: and closed_ind = cp_close_ind;
104:

Line 101: igs_or_inst_stat where

97: c_institution_type_rec c_institution_type%rowtype;
98:
99: cursor c_institution_stat(cp_institution_stat igs_or_inst_int.institution_status%TYPE,
100: cp_close_ind igs_or_inst_stat.closed_ind%TYPE) is select 'X' from
101: igs_or_inst_stat where
102: institution_status = cp_institution_stat
103: and closed_ind = cp_close_ind;
104:
105: c_institution_stat_rec c_institution_stat%rowtype;

Line 262: -- IGS_OR_INST_STAT_INT,IGS_OR_CWLK_INT,IGS_OR_CWLK_DTL_INT,IGS_OR_INST_BTCH_INT';

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

Line 272: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_STAT_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);
275: END IF;
276:

Line 2135: IGS_OR_INST_STAT_INT STAT

2131:
2132: CURSOR log_inst_stat_rcount_cur(cp_batch_id IGS_OR_INST_INT.BATCH_ID%TYPE) IS
2133: SELECT COUNT(1) CNT,STAT.STATUS STAT
2134: FROM IGS_OR_INST_INT INST,
2135: IGS_OR_INST_STAT_INT STAT
2136: WHERE INST.BATCH_ID = cp_batch_id AND
2137: INST.INTERFACE_ID = STAT.INTERFACE_ID
2138: GROUP BY STAT.STATUS;
2139:

Line 2149: IGS_OR_INST_STAT_INT STAT,

2145:
2146: CURSOR log_inst_sdtl_rcount_cur(cp_batch_id IGS_OR_INST_INT.BATCH_ID%TYPE) IS
2147: SELECT COUNT(1) CNT,SDTL.STATUS STAT
2148: FROM IGS_OR_INST_INT INST,
2149: IGS_OR_INST_STAT_INT STAT,
2150: IGS_OR_INST_SDTL_INT SDTL
2151: WHERE INST.BATCH_ID = cp_batch_id AND
2152: INST.INTERFACE_ID = STAT.INTERFACE_ID AND
2153: STAT.INTERFACE_INST_STAT_ID = SDTL.INTERFACE_INST_STAT_ID

Line 2387: DELETE FROM IGS_OR_INST_STAT_INT STAT

2383: -- Table deletion logic for 2 level Childs -- Statistics and Statistics Details
2384:
2385: DELETE FROM IGS_OR_INST_SDTL_INT WHERE STATUS = '1';
2386:
2387: DELETE FROM IGS_OR_INST_STAT_INT STAT
2388: WHERE STATUS = '1' AND
2389: NOT EXISTS (SELECT 1
2390: FROM IGS_OR_INST_SDTL_INT SDTL
2391: WHERE STAT.INTERFACE_INST_STAT_ID = SDTL.INTERFACE_INST_STAT_ID AND

Line 2398: FROM IGS_OR_INST_STAT_INT STAT

2394: UPDATE IGS_OR_INST_INT INST
2395: SET STATUS = '4',ERROR_CODE = 'E056'
2396: WHERE STATUS = '1' AND
2397: EXISTS (SELECT 1
2398: FROM IGS_OR_INST_STAT_INT STAT
2399: WHERE STAT.INTERFACE_ID = INST.INTERFACE_ID);
2400:
2401: -- Table deletion logic for 2 level Childs -- Address and Address Usage
2402: