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_OFST

Line 763: v_offset_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE;

759: token2_val VARCHAR2(255);
760: v_cntr NUMBER;
761: v_dai_found BOOLEAN;
762: v_ci_found BOOLEAN;
763: v_offset_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE;
764: v_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE;
765: v_derived_cal_status IGS_CA_STAT.s_cal_status%TYPE;
766: v_val_start_dt IGS_CA_INST.start_dt%TYPE;
767: v_val_end_dt IGS_CA_INST.end_dt%TYPE;

Line 764: v_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE;

760: v_cntr NUMBER;
761: v_dai_found BOOLEAN;
762: v_ci_found BOOLEAN;
763: v_offset_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE;
764: v_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE;
765: v_derived_cal_status IGS_CA_STAT.s_cal_status%TYPE;
766: v_val_start_dt IGS_CA_INST.start_dt%TYPE;
767: v_val_end_dt IGS_CA_INST.end_dt%TYPE;
768: v_dairn_start_dt IGS_CA_INST.start_dt%TYPE;

Line 1056: IGS_CA_DA_INST_OFST_PKG.INSERT_ROW(

1052: v_ins_offset_cal_type := p_cal_type;
1053: v_ins_offset_ci_seq_num := p_ci_sequence_number;
1054: END IF;
1055:
1056: IGS_CA_DA_INST_OFST_PKG.INSERT_ROW(
1057: X_ROWID => X_ROWID,
1058: X_DT_ALIAS => v_ins_dt_alias,
1059: X_dai_sequence_number => v_ins_dai_sequence_number,
1060: X_CAL_TYPE => v_ins_cal_type,

Line 1257: v_offset_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE;

1253: v_other_detail VARCHAR2(255);
1254: token1_val VARCHAR2(255);
1255: token2_val VARCHAR2(255);
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;

Line 1258: v_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE;

1254: token1_val VARCHAR2(255);
1255: token2_val VARCHAR2(255);
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;

Line 1274: cp_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE,

1270: FROM IGS_CA_DA_INST
1271: WHERE CAL_TYPE = cp_cal_type AND
1272: ci_sequence_number = cp_ci_sequence_number;
1273: CURSOR c_dt_alias_instance_offset(
1274: cp_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE,
1275: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
1276: cp_cal_type IGS_CA_DA_INST_OFST.CAL_TYPE%TYPE,
1277: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE) IS
1278: SELECT *

Line 1275: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,

1271: WHERE CAL_TYPE = cp_cal_type AND
1272: ci_sequence_number = cp_ci_sequence_number;
1273: CURSOR c_dt_alias_instance_offset(
1274: cp_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE,
1275: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
1276: cp_cal_type IGS_CA_DA_INST_OFST.CAL_TYPE%TYPE,
1277: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE) IS
1278: SELECT *
1279: FROM IGS_CA_DA_INST_OFST

Line 1276: cp_cal_type IGS_CA_DA_INST_OFST.CAL_TYPE%TYPE,

1272: ci_sequence_number = cp_ci_sequence_number;
1273: CURSOR c_dt_alias_instance_offset(
1274: cp_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE,
1275: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
1276: cp_cal_type IGS_CA_DA_INST_OFST.CAL_TYPE%TYPE,
1277: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE) IS
1278: SELECT *
1279: FROM IGS_CA_DA_INST_OFST
1280: WHERE DT_ALIAS = cp_dt_alias AND

Line 1277: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE) IS

1273: CURSOR c_dt_alias_instance_offset(
1274: cp_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE,
1275: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
1276: cp_cal_type IGS_CA_DA_INST_OFST.CAL_TYPE%TYPE,
1277: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE) IS
1278: SELECT *
1279: FROM IGS_CA_DA_INST_OFST
1280: WHERE DT_ALIAS = cp_dt_alias AND
1281: dai_sequence_number = cp_dai_sequence_number AND

Line 1279: FROM IGS_CA_DA_INST_OFST

1275: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
1276: cp_cal_type IGS_CA_DA_INST_OFST.CAL_TYPE%TYPE,
1277: cp_ci_sequence_number IGS_CA_DA_INST_OFST.ci_sequence_number%TYPE) IS
1278: SELECT *
1279: FROM IGS_CA_DA_INST_OFST
1280: WHERE DT_ALIAS = cp_dt_alias AND
1281: dai_sequence_number = cp_dai_sequence_number AND
1282: CAL_TYPE = cp_cal_type AND
1283: ci_sequence_number = cp_ci_sequence_number;

Line 1285: cp_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE,

1281: dai_sequence_number = cp_dai_sequence_number AND
1282: CAL_TYPE = cp_cal_type AND
1283: ci_sequence_number = cp_ci_sequence_number;
1284: CURSOR c_dt_alias_inst_offset_offset(
1285: cp_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE,
1286: cp_dai_seq_num IGS_CA_DA_INST_OFST.offset_dai_sequence_number%TYPE,
1287: cp_cal_type IGS_CA_DA_INST_OFST.offset_cal_type%TYPE,
1288: cp_ci_seq IGS_CA_DA_INST_OFST.offset_ci_sequence_number%TYPE) IS
1289: SELECT *

Line 1286: cp_dai_seq_num IGS_CA_DA_INST_OFST.offset_dai_sequence_number%TYPE,

1282: CAL_TYPE = cp_cal_type AND
1283: ci_sequence_number = cp_ci_sequence_number;
1284: CURSOR c_dt_alias_inst_offset_offset(
1285: cp_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE,
1286: cp_dai_seq_num IGS_CA_DA_INST_OFST.offset_dai_sequence_number%TYPE,
1287: cp_cal_type IGS_CA_DA_INST_OFST.offset_cal_type%TYPE,
1288: cp_ci_seq IGS_CA_DA_INST_OFST.offset_ci_sequence_number%TYPE) IS
1289: SELECT *
1290: FROM IGS_CA_DA_INST_OFST

Line 1287: cp_cal_type IGS_CA_DA_INST_OFST.offset_cal_type%TYPE,

1283: ci_sequence_number = cp_ci_sequence_number;
1284: CURSOR c_dt_alias_inst_offset_offset(
1285: cp_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE,
1286: cp_dai_seq_num IGS_CA_DA_INST_OFST.offset_dai_sequence_number%TYPE,
1287: cp_cal_type IGS_CA_DA_INST_OFST.offset_cal_type%TYPE,
1288: cp_ci_seq IGS_CA_DA_INST_OFST.offset_ci_sequence_number%TYPE) IS
1289: SELECT *
1290: FROM IGS_CA_DA_INST_OFST
1291: WHERE offset_dt_alias = cp_dt_alias AND

Line 1288: cp_ci_seq IGS_CA_DA_INST_OFST.offset_ci_sequence_number%TYPE) IS

1284: CURSOR c_dt_alias_inst_offset_offset(
1285: cp_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE,
1286: cp_dai_seq_num IGS_CA_DA_INST_OFST.offset_dai_sequence_number%TYPE,
1287: cp_cal_type IGS_CA_DA_INST_OFST.offset_cal_type%TYPE,
1288: cp_ci_seq IGS_CA_DA_INST_OFST.offset_ci_sequence_number%TYPE) IS
1289: SELECT *
1290: FROM IGS_CA_DA_INST_OFST
1291: WHERE offset_dt_alias = cp_dt_alias AND
1292: offset_dai_sequence_number = cp_dai_seq_num AND

Line 1290: FROM IGS_CA_DA_INST_OFST

1286: cp_dai_seq_num IGS_CA_DA_INST_OFST.offset_dai_sequence_number%TYPE,
1287: cp_cal_type IGS_CA_DA_INST_OFST.offset_cal_type%TYPE,
1288: cp_ci_seq IGS_CA_DA_INST_OFST.offset_ci_sequence_number%TYPE) IS
1289: SELECT *
1290: FROM IGS_CA_DA_INST_OFST
1291: WHERE offset_dt_alias = cp_dt_alias AND
1292: offset_dai_sequence_number = cp_dai_seq_num AND
1293: offset_cal_type = cp_cal_type AND
1294: offset_ci_sequence_number = cp_ci_seq;