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_AD_GEN_003 dependencies on IGS_CA_GEN_001

Line 233: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val

229: adm_appl_final_dt_alias
230: FROM IGS_AD_CAL_CONF sacc
231: WHERE s_control_num = 1;
232: CURSOR c_daiv IS
233: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
234: FROM IGS_CA_DA_INST daiv,
235: IGS_AD_PERD_AD_CAT apac
236: WHERE daiv.dt_alias = p_dt_alias AND
237: apac.adm_cal_type = p_adm_cal_type AND

Line 251: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val

247: apcood.dt_alias = daiv.dt_alias AND
248: apcood.dai_sequence_number = daiv.sequence_number)
249: ORDER BY 1 desc;
250: CURSOR c_daiv2 IS
251: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
252: FROM IGS_CA_DA_INST daiv
253: WHERE daiv.cal_type = p_adm_cal_type AND
254: daiv.ci_sequence_number = p_adm_ci_sequence_number AND
255: daiv.dt_alias = p_dt_alias AND