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

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 156: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%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;
155: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
156: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
157: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
158: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
159: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

Line 157: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;

153: v_val_end_dt IGS_CA_INST.end_dt%TYPE;
154: v_dairn_start_dt IGS_CA_INST.start_dt%TYPE;
155: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
156: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
157: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
158: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
159: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;

Line 158: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

154: v_dairn_start_dt IGS_CA_INST.start_dt%TYPE;
155: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
156: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
157: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
158: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
159: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

Line 159: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;

155: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
156: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
157: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
158: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
159: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;

Line 160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

156: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
157: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
158: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
159: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
164: v_ins_related_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

Line 161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;

157: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
158: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
159: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
164: v_ins_related_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
165: v_ins_related_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

Line 162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

158: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
159: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
164: v_ins_related_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
165: v_ins_related_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
166: v_ins_related_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

Line 163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;

159: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
164: v_ins_related_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
165: v_ins_related_dai_seq_num IGS_CA_DA_INST.sequence_number%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;

Line 164: v_ins_related_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

160: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
164: v_ins_related_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
165: v_ins_related_dai_seq_num IGS_CA_DA_INST.sequence_number%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:

Line 165: v_ins_related_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

161: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
164: v_ins_related_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
165: v_ins_related_dai_seq_num IGS_CA_DA_INST.sequence_number%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(

Line 166: v_ins_related_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

162: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
164: v_ins_related_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
165: v_ins_related_dai_seq_num IGS_CA_DA_INST.sequence_number%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,

Line 167: v_ins_related_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;

163: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
164: v_ins_related_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
165: v_ins_related_dai_seq_num IGS_CA_DA_INST.sequence_number%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,

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 174: FROM IGS_CA_DA_INST

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
177: ci_sequence_number = cp_ci_sequence_number;
178: CURSOR c_cal_instance(

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 600: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

596: DECLARE
597: X_ROWID VARCHAR2(25);
598:
599: v_other_detail VARCHAR2(255);
600: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
601: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
602: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
603: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
604: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

Line 601: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;

597: X_ROWID VARCHAR2(25);
598:
599: v_other_detail VARCHAR2(255);
600: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
601: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
602: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
603: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
604: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

Line 602: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

598:
599: v_other_detail VARCHAR2(255);
600: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
601: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
602: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
603: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
604: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

Line 603: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;

599: v_other_detail VARCHAR2(255);
600: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
601: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
602: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
603: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
604: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;

Line 604: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

600: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
601: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
602: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
603: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
604: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(

Line 605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

601: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
602: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
603: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
604: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,

Line 606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

602: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
603: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
604: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,

Line 607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;

603: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
604: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,

Line 609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,

605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,

Line 610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,

606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number

Line 611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,

607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,

Line 612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,

608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,

Line 613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,

609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number

Line 615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,

611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number
618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS
619: SELECT *

Line 616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,

612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number
618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS
619: SELECT *
620: FROM IGS_CA_DA_INST_OFCNT

Line 618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS

614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number
618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS
619: SELECT *
620: FROM IGS_CA_DA_INST_OFCNT
621: WHERE DT_ALIAS = cp_dt_alias AND
622: dai_sequence_number = cp_dai_sequence_number AND

Line 620: FROM IGS_CA_DA_INST_OFCNT

616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number
618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS
619: SELECT *
620: FROM IGS_CA_DA_INST_OFCNT
621: WHERE DT_ALIAS = cp_dt_alias AND
622: dai_sequence_number = cp_dai_sequence_number AND
623: CAL_TYPE = cp_cal_type AND
624: ci_sequence_number = cp_ci_sequence_number AND

Line 642: IGS_CA_DA_INST_OFCNT_PKG.INSERT_ROW(

638: p_offset_dai_sequence_number,
639: p_offset_cal_type,
640: p_offset_ci_sequence_number) LOOP
641:
642: IGS_CA_DA_INST_OFCNT_PKG.INSERT_ROW(
643: X_ROWID => X_ROWID,
644: X_DT_ALIAS => p_new_dt_alias,
645: X_dai_sequence_number => p_new_dai_sequence_number,
646: X_CAL_TYPE => p_new_cal_type,

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 770: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%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;
769: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
770: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
771: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
772: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
773: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

Line 771: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;

767: v_val_end_dt IGS_CA_INST.end_dt%TYPE;
768: v_dairn_start_dt IGS_CA_INST.start_dt%TYPE;
769: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
770: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
771: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
772: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
773: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;

Line 772: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

768: v_dairn_start_dt IGS_CA_INST.start_dt%TYPE;
769: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
770: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
771: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
772: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
773: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

Line 773: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;

769: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
770: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
771: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
772: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
773: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;

Line 774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

770: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
771: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
772: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
773: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

Line 775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;

771: v_new_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
772: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
773: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
779: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

Line 776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

772: v_new_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
773: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
779: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
780: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

Line 777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;

773: v_new_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
779: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%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;

Line 778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

774: v_ins_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
779: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%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;

Line 779: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

775: v_ins_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
779: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%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(

Line 780: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

776: v_ins_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
779: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%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,

Line 781: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;

777: v_ins_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
779: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%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,

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 788: FROM IGS_CA_DA_INST

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
791: ci_sequence_number = cp_ci_sequence_number;
792: CURSOR c_cal_instance(

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 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 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 1264: SELECT IGS_CA_DA_INST_SEQ_NUM_S.nextval

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(
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

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;

Line 1270: FROM IGS_CA_DA_INST

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;
1273: CURSOR c_dt_alias_instance_offset(
1274: cp_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%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;

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;

Line 1413: ELSE -- create IGS_CA_DA_INST

1409: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);
1410: END IF;
1411:
1412: -- END NEW CODE FROM JULIE
1413: ELSE -- create IGS_CA_DA_INST
1414: v_new_dai_dt_alias := c_dt_alias_instance_rec.DT_ALIAS;
1415: v_new_sequence_number := c_dt_alias_instance_rec.sequence_number;
1416: IF(c_dt_alias_instance_rec.absolute_val IS NULL) THEN
1417: v_new_absolute_val := NULL;

Line 1426: -- Get next available IGS_CA_DA instance sequence number

1422: ELSE
1423: v_new_absolute_val := c_dt_alias_instance_rec.absolute_val + p_diff_days;
1424: END IF;
1425: END IF;
1426: -- Get next available IGS_CA_DA instance sequence number
1427: /* Use old IGS_CA_DA sequence number for Student Finance functionality */
1428:
1429:
1430: IGS_CA_DA_INST_PKG.INSERT_ROW(

Line 1430: IGS_CA_DA_INST_PKG.INSERT_ROW(

1426: -- Get next available IGS_CA_DA instance sequence number
1427: /* Use old IGS_CA_DA sequence number for Student Finance functionality */
1428:
1429:
1430: IGS_CA_DA_INST_PKG.INSERT_ROW(
1431: X_ROWId => X_ROWID,
1432: X_DT_ALIAS => v_new_dai_dt_alias,
1433: X_sequence_number => v_new_sequence_number,
1434: X_CAL_TYPE => p_rollover_cal_type,