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.

[Home] [Help]

APPS.IGS_CA_INS_ROLL_CI dependencies on IGS_CA_DA_INST_PAIR

Line 149: v_related_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE;

145: token2_val VARCHAR2(255);
146: v_cntr NUMBER;
147: v_dai_found BOOLEAN;
148: v_ci_found BOOLEAN;
149: v_related_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE;
150: v_dt_alias IGS_CA_DA_INST_PAIR.DT_ALIAS%TYPE;
151: v_derived_cal_status IGS_CA_STAT.s_cal_status%TYPE;
152: v_val_start_dt IGS_CA_INST.start_dt%TYPE;
153: v_val_end_dt IGS_CA_INST.end_dt%TYPE;

Line 150: v_dt_alias IGS_CA_DA_INST_PAIR.DT_ALIAS%TYPE;

146: v_cntr NUMBER;
147: v_dai_found BOOLEAN;
148: v_ci_found BOOLEAN;
149: v_related_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE;
150: v_dt_alias IGS_CA_DA_INST_PAIR.DT_ALIAS%TYPE;
151: v_derived_cal_status IGS_CA_STAT.s_cal_status%TYPE;
152: v_val_start_dt IGS_CA_INST.start_dt%TYPE;
153: v_val_end_dt IGS_CA_INST.end_dt%TYPE;
154: v_dairn_start_dt IGS_CA_INST.start_dt%TYPE;

Line 449: IGS_CA_DA_INST_PAIR_PKG.INSERT_ROW(

445: v_ins_related_cal_type := p_cal_type;
446: v_ins_related_ci_seq_num := p_ci_sequence_number;
447: END IF;
448:
449: IGS_CA_DA_INST_PAIR_PKG.INSERT_ROW(
450: X_ROWID => X_ROWID,
451: X_DT_ALIAS=> v_ins_dt_alias,
452: X_dai_sequence_number => v_ins_dai_sequence_number,
453: X_CAL_TYPE =>v_ins_cal_type,

Line 1259: v_related_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE;

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;
1263: CURSOR c_dai_sequence_number IS

Line 1296: cp_dt_alias IGS_CA_DA_INST_PAIR.DT_ALIAS%TYPE,

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;
1295: CURSOR c_dt_alias_instance_pair(
1296: cp_dt_alias IGS_CA_DA_INST_PAIR.DT_ALIAS%TYPE,
1297: cp_dai_sequence_number IGS_CA_DA_INST_PAIR.dai_sequence_number%TYPE,
1298: cp_cal_type IGS_CA_DA_INST_PAIR.CAL_TYPE%TYPE,
1299: cp_ci_sequence_number IGS_CA_DA_INST_PAIR.ci_sequence_number%TYPE) IS
1300: SELECT *

Line 1297: cp_dai_sequence_number IGS_CA_DA_INST_PAIR.dai_sequence_number%TYPE,

1293: offset_cal_type = cp_cal_type AND
1294: offset_ci_sequence_number = cp_ci_seq;
1295: CURSOR c_dt_alias_instance_pair(
1296: cp_dt_alias IGS_CA_DA_INST_PAIR.DT_ALIAS%TYPE,
1297: cp_dai_sequence_number IGS_CA_DA_INST_PAIR.dai_sequence_number%TYPE,
1298: cp_cal_type IGS_CA_DA_INST_PAIR.CAL_TYPE%TYPE,
1299: cp_ci_sequence_number IGS_CA_DA_INST_PAIR.ci_sequence_number%TYPE) IS
1300: SELECT *
1301: FROM IGS_CA_DA_INST_PAIR

Line 1298: cp_cal_type IGS_CA_DA_INST_PAIR.CAL_TYPE%TYPE,

1294: offset_ci_sequence_number = cp_ci_seq;
1295: CURSOR c_dt_alias_instance_pair(
1296: cp_dt_alias IGS_CA_DA_INST_PAIR.DT_ALIAS%TYPE,
1297: cp_dai_sequence_number IGS_CA_DA_INST_PAIR.dai_sequence_number%TYPE,
1298: cp_cal_type IGS_CA_DA_INST_PAIR.CAL_TYPE%TYPE,
1299: cp_ci_sequence_number IGS_CA_DA_INST_PAIR.ci_sequence_number%TYPE) IS
1300: SELECT *
1301: FROM IGS_CA_DA_INST_PAIR
1302: WHERE DT_ALIAS = cp_dt_alias AND

Line 1299: cp_ci_sequence_number IGS_CA_DA_INST_PAIR.ci_sequence_number%TYPE) IS

1295: CURSOR c_dt_alias_instance_pair(
1296: cp_dt_alias IGS_CA_DA_INST_PAIR.DT_ALIAS%TYPE,
1297: cp_dai_sequence_number IGS_CA_DA_INST_PAIR.dai_sequence_number%TYPE,
1298: cp_cal_type IGS_CA_DA_INST_PAIR.CAL_TYPE%TYPE,
1299: cp_ci_sequence_number IGS_CA_DA_INST_PAIR.ci_sequence_number%TYPE) IS
1300: SELECT *
1301: FROM IGS_CA_DA_INST_PAIR
1302: WHERE DT_ALIAS = cp_dt_alias AND
1303: dai_sequence_number = cp_dai_sequence_number AND

Line 1301: FROM IGS_CA_DA_INST_PAIR

1297: cp_dai_sequence_number IGS_CA_DA_INST_PAIR.dai_sequence_number%TYPE,
1298: cp_cal_type IGS_CA_DA_INST_PAIR.CAL_TYPE%TYPE,
1299: cp_ci_sequence_number IGS_CA_DA_INST_PAIR.ci_sequence_number%TYPE) IS
1300: SELECT *
1301: FROM IGS_CA_DA_INST_PAIR
1302: WHERE DT_ALIAS = cp_dt_alias AND
1303: dai_sequence_number = cp_dai_sequence_number AND
1304: CAL_TYPE = cp_cal_type AND
1305: ci_sequence_number = cp_ci_sequence_number;

Line 1307: cp_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE,

1303: dai_sequence_number = cp_dai_sequence_number AND
1304: CAL_TYPE = cp_cal_type AND
1305: ci_sequence_number = cp_ci_sequence_number;
1306: CURSOR c_dt_alias_inst_pair_pair(
1307: cp_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE,
1308: cp_dai_seq_num IGS_CA_DA_INST_PAIR.related_dai_sequence_number%TYPE,
1309: cp_cal_type IGS_CA_DA_INST_PAIR.related_cal_type%TYPE,
1310: cp_ci_seq IGS_CA_DA_INST_PAIR.related_ci_sequence_number%TYPE) IS
1311: SELECT *

Line 1308: cp_dai_seq_num IGS_CA_DA_INST_PAIR.related_dai_sequence_number%TYPE,

1304: CAL_TYPE = cp_cal_type AND
1305: ci_sequence_number = cp_ci_sequence_number;
1306: CURSOR c_dt_alias_inst_pair_pair(
1307: cp_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE,
1308: cp_dai_seq_num IGS_CA_DA_INST_PAIR.related_dai_sequence_number%TYPE,
1309: cp_cal_type IGS_CA_DA_INST_PAIR.related_cal_type%TYPE,
1310: cp_ci_seq IGS_CA_DA_INST_PAIR.related_ci_sequence_number%TYPE) IS
1311: SELECT *
1312: FROM IGS_CA_DA_INST_PAIR

Line 1309: cp_cal_type IGS_CA_DA_INST_PAIR.related_cal_type%TYPE,

1305: ci_sequence_number = cp_ci_sequence_number;
1306: CURSOR c_dt_alias_inst_pair_pair(
1307: cp_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE,
1308: cp_dai_seq_num IGS_CA_DA_INST_PAIR.related_dai_sequence_number%TYPE,
1309: cp_cal_type IGS_CA_DA_INST_PAIR.related_cal_type%TYPE,
1310: cp_ci_seq IGS_CA_DA_INST_PAIR.related_ci_sequence_number%TYPE) IS
1311: SELECT *
1312: FROM IGS_CA_DA_INST_PAIR
1313: WHERE related_dt_alias = cp_dt_alias AND

Line 1310: cp_ci_seq IGS_CA_DA_INST_PAIR.related_ci_sequence_number%TYPE) IS

1306: CURSOR c_dt_alias_inst_pair_pair(
1307: cp_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE,
1308: cp_dai_seq_num IGS_CA_DA_INST_PAIR.related_dai_sequence_number%TYPE,
1309: cp_cal_type IGS_CA_DA_INST_PAIR.related_cal_type%TYPE,
1310: cp_ci_seq IGS_CA_DA_INST_PAIR.related_ci_sequence_number%TYPE) IS
1311: SELECT *
1312: FROM IGS_CA_DA_INST_PAIR
1313: WHERE related_dt_alias = cp_dt_alias AND
1314: related_dai_sequence_number = cp_dai_seq_num AND

Line 1312: FROM IGS_CA_DA_INST_PAIR

1308: cp_dai_seq_num IGS_CA_DA_INST_PAIR.related_dai_sequence_number%TYPE,
1309: cp_cal_type IGS_CA_DA_INST_PAIR.related_cal_type%TYPE,
1310: cp_ci_seq IGS_CA_DA_INST_PAIR.related_ci_sequence_number%TYPE) IS
1311: SELECT *
1312: FROM IGS_CA_DA_INST_PAIR
1313: WHERE related_dt_alias = cp_dt_alias AND
1314: related_dai_sequence_number = cp_dai_seq_num AND
1315: related_cal_type = cp_cal_type AND
1316: related_ci_sequence_number = cp_ci_seq;