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_CA_INS_ROLL_CI dependencies on IGS_CA_DA_INST_V

Line 170: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,

166: v_ins_related_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
167: v_ins_related_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
168:
169: CURSOR c_new_dt_alias_instance(
170: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
171: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
172: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
173: SELECT *
174: FROM IGS_CA_DA_INST

Line 171: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,

167: v_ins_related_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
168:
169: CURSOR c_new_dt_alias_instance(
170: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
171: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
172: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
173: SELECT *
174: FROM IGS_CA_DA_INST
175: WHERE DT_ALIAS = cp_dt_alias AND

Line 172: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS

168:
169: CURSOR c_new_dt_alias_instance(
170: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
171: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
172: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
173: SELECT *
174: FROM IGS_CA_DA_INST
175: WHERE DT_ALIAS = cp_dt_alias AND
176: CAL_TYPE = cp_cal_type AND

Line 784: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,

780: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
781: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
782: v_sled_rec IGS_GE_S_LOG_ENTRY%ROWTYPE;
783: CURSOR c_new_dt_alias_instance(
784: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
785: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
786: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
787: SELECT *
788: FROM IGS_CA_DA_INST

Line 785: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,

781: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
782: v_sled_rec IGS_GE_S_LOG_ENTRY%ROWTYPE;
783: CURSOR c_new_dt_alias_instance(
784: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
785: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
786: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
787: SELECT *
788: FROM IGS_CA_DA_INST
789: WHERE DT_ALIAS = cp_dt_alias AND

Line 786: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS

782: v_sled_rec IGS_GE_S_LOG_ENTRY%ROWTYPE;
783: CURSOR c_new_dt_alias_instance(
784: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
785: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
786: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
787: SELECT *
788: FROM IGS_CA_DA_INST
789: WHERE DT_ALIAS = cp_dt_alias AND
790: CAL_TYPE = cp_cal_type AND

Line 1260: v_new_dai_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE;

1256: v_message_name varchar2(30);
1257: v_offset_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE;
1258: v_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE;
1259: v_related_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE;
1260: v_new_dai_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE;
1261: v_new_absolute_val IGS_CA_DA_INST_V.absolute_val%TYPE;
1262: v_new_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE;
1263: CURSOR c_dai_sequence_number IS
1264: SELECT IGS_CA_DA_INST_SEQ_NUM_S.nextval

Line 1261: v_new_absolute_val IGS_CA_DA_INST_V.absolute_val%TYPE;

1257: v_offset_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE;
1258: v_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE;
1259: v_related_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE;
1260: v_new_dai_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE;
1261: v_new_absolute_val IGS_CA_DA_INST_V.absolute_val%TYPE;
1262: v_new_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE;
1263: CURSOR c_dai_sequence_number IS
1264: SELECT IGS_CA_DA_INST_SEQ_NUM_S.nextval
1265: FROM DUAL;

Line 1262: v_new_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE;

1258: v_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE;
1259: v_related_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE;
1260: v_new_dai_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE;
1261: v_new_absolute_val IGS_CA_DA_INST_V.absolute_val%TYPE;
1262: v_new_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE;
1263: CURSOR c_dai_sequence_number IS
1264: SELECT IGS_CA_DA_INST_SEQ_NUM_S.nextval
1265: FROM DUAL;
1266: CURSOR c_dt_alias_instance(

Line 1267: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,

1263: CURSOR c_dai_sequence_number IS
1264: SELECT IGS_CA_DA_INST_SEQ_NUM_S.nextval
1265: FROM DUAL;
1266: CURSOR c_dt_alias_instance(
1267: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
1268: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
1269: SELECT *
1270: FROM IGS_CA_DA_INST
1271: WHERE CAL_TYPE = cp_cal_type AND

Line 1268: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS

1264: SELECT IGS_CA_DA_INST_SEQ_NUM_S.nextval
1265: FROM DUAL;
1266: CURSOR c_dt_alias_instance(
1267: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
1268: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
1269: SELECT *
1270: FROM IGS_CA_DA_INST
1271: WHERE CAL_TYPE = cp_cal_type AND
1272: ci_sequence_number = cp_ci_sequence_number;