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_INST

Line 9: --Description to be added in IGS_CA_INST_ALL Table

5: Task : Duplicated Procedures and functions
6: PROCEDURE admp_val_apcood_da is removed and reference is changed *****/
7: /***********************************************************************
8: --Enh Bug :- 2138560,Change Request for Calendar Instance
9: --Description to be added in IGS_CA_INST_ALL Table
10:
11: Who When What
12: mesriniv 06-DEC-2001 A DESCRIPTION Column is ADDED in the
13: Insert Row Procedure

Line 14: of the package call IGS_CA_INST_PKG

10:
11: Who When What
12: mesriniv 06-DEC-2001 A DESCRIPTION Column is ADDED in the
13: Insert Row Procedure
14: of the package call IGS_CA_INST_PKG
15: ssawhney 28dec GSCC standards change name of
16: REL_SUP_CI_SEQ_NUM sequence to end in S1
17: npalanis 23-NOV-2002 Bug : 2563531
18: For calendars load , teaching and academic the alternate

Line 22: (igs_ca_inst_seq_num_s1) to make it unique

18: For calendars load , teaching and academic the alternate
19: code is made unique . In rollover the alternate code of the
20: previous calendar and the rolled over calendar was retained same
21: now the alternate code is appended with sequence number
22: (igs_ca_inst_seq_num_s1) to make it unique
23: asbala 9-Feb-2004 ENCR039: New column TERM_INSTRUCTION_TIME of table IGS_CA_INST will also be rolled
24: over when the calendar is rolled over.
25: nsidnaa 9/21/2004 New function added to rollover retention schedules for a teaching calendar.
26: skpandey 4-AUG-2005 BUG : 4356272

Line 23: asbala 9-Feb-2004 ENCR039: New column TERM_INSTRUCTION_TIME of table IGS_CA_INST will also be rolled

19: code is made unique . In rollover the alternate code of the
20: previous calendar and the rolled over calendar was retained same
21: now the alternate code is appended with sequence number
22: (igs_ca_inst_seq_num_s1) to make it unique
23: asbala 9-Feb-2004 ENCR039: New column TERM_INSTRUCTION_TIME of table IGS_CA_INST will also be rolled
24: over when the calendar is rolled over.
25: nsidnaa 9/21/2004 New function added to rollover retention schedules for a teaching calendar.
26: skpandey 4-AUG-2005 BUG : 4356272
27: Added parameteric values for SS_DISPLAYED, ADMIN_FLAG, PLANNING_FLAG, SCHEDULE_FLAG in IGS_CA_INST_PKG.INSERT_ROW procedure to

Line 27: Added parameteric values for SS_DISPLAYED, ADMIN_FLAG, PLANNING_FLAG, SCHEDULE_FLAG in IGS_CA_INST_PKG.INSERT_ROW procedure to

23: asbala 9-Feb-2004 ENCR039: New column TERM_INSTRUCTION_TIME of table IGS_CA_INST will also be rolled
24: over when the calendar is rolled over.
25: nsidnaa 9/21/2004 New function added to rollover retention schedules for a teaching calendar.
26: skpandey 4-AUG-2005 BUG : 4356272
27: Added parameteric values for SS_DISPLAYED, ADMIN_FLAG, PLANNING_FLAG, SCHEDULE_FLAG in IGS_CA_INST_PKG.INSERT_ROW procedure to
28: facilitate the adding of new checkboxes to the IGS_CA_INST_ALL table for enabling load calendars for self-service
29: **************************************************************************/
30:
31: l_message_name VARCHAR2(30);

Line 28: facilitate the adding of new checkboxes to the IGS_CA_INST_ALL table for enabling load calendars for self-service

24: over when the calendar is rolled over.
25: nsidnaa 9/21/2004 New function added to rollover retention schedules for a teaching calendar.
26: skpandey 4-AUG-2005 BUG : 4356272
27: Added parameteric values for SS_DISPLAYED, ADMIN_FLAG, PLANNING_FLAG, SCHEDULE_FLAG in IGS_CA_INST_PKG.INSERT_ROW procedure to
28: facilitate the adding of new checkboxes to the IGS_CA_INST_ALL table for enabling load calendars for self-service
29: **************************************************************************/
30:
31: l_message_name VARCHAR2(30);
32: l_app VARCHAR2(50);

Line 152: v_val_start_dt IGS_CA_INST.start_dt%TYPE;

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;
155: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
156: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

Line 153: v_val_end_dt IGS_CA_INST.end_dt%TYPE;

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

Line 154: v_dairn_start_dt IGS_CA_INST.start_dt%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;
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;

Line 155: v_dairn_end_dt IGS_CA_INST.end_dt%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;
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;

Line 179: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

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(
179: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
180: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
181: SELECT *
182: FROM IGS_CA_INST
183: WHERE CAL_TYPE = cp_cal_type AND

Line 180: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

176: CAL_TYPE = cp_cal_type AND
177: ci_sequence_number = cp_ci_sequence_number;
178: CURSOR c_cal_instance(
179: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
180: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
181: SELECT *
182: FROM IGS_CA_INST
183: WHERE CAL_TYPE = cp_cal_type AND
184: sequence_number = cp_sequence_number;

Line 182: FROM IGS_CA_INST

178: CURSOR c_cal_instance(
179: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
180: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
181: SELECT *
182: FROM IGS_CA_INST
183: WHERE CAL_TYPE = cp_cal_type AND
184: sequence_number = cp_sequence_number;
185: CURSOR c_derived_cal_instance(
186: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 186: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

182: FROM IGS_CA_INST
183: WHERE CAL_TYPE = cp_cal_type AND
184: sequence_number = cp_sequence_number;
185: CURSOR c_derived_cal_instance(
186: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
187: cp_start_dt IGS_CA_INST.start_dt%TYPE,
188: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
189: SELECT *
190: FROM IGS_CA_INST

Line 187: cp_start_dt IGS_CA_INST.start_dt%TYPE,

183: WHERE CAL_TYPE = cp_cal_type AND
184: sequence_number = cp_sequence_number;
185: CURSOR c_derived_cal_instance(
186: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
187: cp_start_dt IGS_CA_INST.start_dt%TYPE,
188: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
189: SELECT *
190: FROM IGS_CA_INST
191: WHERE CAL_TYPE = cp_cal_type AND

Line 188: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS

184: sequence_number = cp_sequence_number;
185: CURSOR c_derived_cal_instance(
186: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
187: cp_start_dt IGS_CA_INST.start_dt%TYPE,
188: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
189: SELECT *
190: FROM IGS_CA_INST
191: WHERE CAL_TYPE = cp_cal_type AND
192: start_dt = cp_start_dt AND

Line 190: FROM IGS_CA_INST

186: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
187: cp_start_dt IGS_CA_INST.start_dt%TYPE,
188: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
189: SELECT *
190: FROM IGS_CA_INST
191: WHERE CAL_TYPE = cp_cal_type AND
192: start_dt = cp_start_dt AND
193: end_dt = cp_end_dt;
194: CURSOR c_derived_cal_status(

Line 766: v_val_start_dt IGS_CA_INST.start_dt%TYPE;

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;
769: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;
770: v_new_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;

Line 767: v_val_end_dt IGS_CA_INST.end_dt%TYPE;

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

Line 768: v_dairn_start_dt IGS_CA_INST.start_dt%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;
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;

Line 769: v_dairn_end_dt IGS_CA_INST.end_dt%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;
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;

Line 793: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

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(
793: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
794: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
795: SELECT *
796: FROM IGS_CA_INST
797: WHERE CAL_TYPE = cp_cal_type AND

Line 794: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

790: CAL_TYPE = cp_cal_type AND
791: ci_sequence_number = cp_ci_sequence_number;
792: CURSOR c_cal_instance(
793: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
794: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
795: SELECT *
796: FROM IGS_CA_INST
797: WHERE CAL_TYPE = cp_cal_type AND
798: sequence_number = cp_sequence_number;

Line 796: FROM IGS_CA_INST

792: CURSOR c_cal_instance(
793: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
794: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
795: SELECT *
796: FROM IGS_CA_INST
797: WHERE CAL_TYPE = cp_cal_type AND
798: sequence_number = cp_sequence_number;
799: CURSOR c_derived_cal_instance(
800: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 800: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

796: FROM IGS_CA_INST
797: WHERE CAL_TYPE = cp_cal_type AND
798: sequence_number = cp_sequence_number;
799: CURSOR c_derived_cal_instance(
800: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
801: cp_start_dt IGS_CA_INST.start_dt%TYPE,
802: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
803: SELECT *
804: FROM IGS_CA_INST

Line 801: cp_start_dt IGS_CA_INST.start_dt%TYPE,

797: WHERE CAL_TYPE = cp_cal_type AND
798: sequence_number = cp_sequence_number;
799: CURSOR c_derived_cal_instance(
800: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
801: cp_start_dt IGS_CA_INST.start_dt%TYPE,
802: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
803: SELECT *
804: FROM IGS_CA_INST
805: WHERE CAL_TYPE = cp_cal_type AND

Line 802: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS

798: sequence_number = cp_sequence_number;
799: CURSOR c_derived_cal_instance(
800: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
801: cp_start_dt IGS_CA_INST.start_dt%TYPE,
802: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
803: SELECT *
804: FROM IGS_CA_INST
805: WHERE CAL_TYPE = cp_cal_type AND
806: start_dt = cp_start_dt AND

Line 804: FROM IGS_CA_INST

800: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
801: cp_start_dt IGS_CA_INST.start_dt%TYPE,
802: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
803: SELECT *
804: FROM IGS_CA_INST
805: WHERE CAL_TYPE = cp_cal_type AND
806: start_dt = cp_start_dt AND
807: end_dt = cp_end_dt;
808: CURSOR c_derived_cal_status(

Line 1620: v_derived_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

1616:
1617: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
1618: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
1619: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
1620: v_derived_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1621: v_derived_start_dt IGS_CA_INST.start_dt%TYPE;
1622: v_derived_end_dt IGS_CA_INST.end_dt%TYPE;
1623: v_sup_load_res_percentage
1624: IGS_CA_INST_REL.load_research_percentage%TYPE;

Line 1621: v_derived_start_dt IGS_CA_INST.start_dt%TYPE;

1617: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
1618: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
1619: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
1620: v_derived_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1621: v_derived_start_dt IGS_CA_INST.start_dt%TYPE;
1622: v_derived_end_dt IGS_CA_INST.end_dt%TYPE;
1623: v_sup_load_res_percentage
1624: IGS_CA_INST_REL.load_research_percentage%TYPE;
1625: v_other_detail VARCHAR2(255);

Line 1622: v_derived_end_dt IGS_CA_INST.end_dt%TYPE;

1618: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
1619: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
1620: v_derived_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1621: v_derived_start_dt IGS_CA_INST.start_dt%TYPE;
1622: v_derived_end_dt IGS_CA_INST.end_dt%TYPE;
1623: v_sup_load_res_percentage
1624: IGS_CA_INST_REL.load_research_percentage%TYPE;
1625: v_other_detail VARCHAR2(255);
1626: token1_val VARCHAR2(255);

Line 1624: IGS_CA_INST_REL.load_research_percentage%TYPE;

1620: v_derived_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1621: v_derived_start_dt IGS_CA_INST.start_dt%TYPE;
1622: v_derived_end_dt IGS_CA_INST.end_dt%TYPE;
1623: v_sup_load_res_percentage
1624: IGS_CA_INST_REL.load_research_percentage%TYPE;
1625: v_other_detail VARCHAR2(255);
1626: token1_val VARCHAR2(255);
1627: token2_val VARCHAR2(255);
1628: v_dummy VARCHAR2(1);

Line 1635: FROM IGS_CA_INST_REL cir

1631: CURSOR c_cal_inst_rltsp_sup IS
1632: SELECT cir.sup_cal_type,
1633: cir.sup_ci_sequence_number,
1634: cir.load_research_percentage
1635: FROM IGS_CA_INST_REL cir
1636: WHERE cir.sub_cal_type = p_cal_type AND
1637: cir.sub_ci_sequence_number = p_sequence_number;
1638: CURSOR c_cal_instance(
1639: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 1639: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1635: FROM IGS_CA_INST_REL cir
1636: WHERE cir.sub_cal_type = p_cal_type AND
1637: cir.sub_ci_sequence_number = p_sequence_number;
1638: CURSOR c_cal_instance(
1639: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1640: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1641: SELECT ci.start_dt,
1642: ci.end_dt,
1643: ci.CAL_TYPE

Line 1640: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1636: WHERE cir.sub_cal_type = p_cal_type AND
1637: cir.sub_ci_sequence_number = p_sequence_number;
1638: CURSOR c_cal_instance(
1639: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1640: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1641: SELECT ci.start_dt,
1642: ci.end_dt,
1643: ci.CAL_TYPE
1644: FROM IGS_CA_INST ci

Line 1644: FROM IGS_CA_INST ci

1640: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1641: SELECT ci.start_dt,
1642: ci.end_dt,
1643: ci.CAL_TYPE
1644: FROM IGS_CA_INST ci
1645: WHERE ci.CAL_TYPE = cp_cal_type AND
1646: ci.sequence_number = cp_sequence_number;
1647: v_cal_inst_rec c_cal_instance%ROWTYPE;
1648: CURSOR c_derived_cal_instance(

Line 1649: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1645: WHERE ci.CAL_TYPE = cp_cal_type AND
1646: ci.sequence_number = cp_sequence_number;
1647: v_cal_inst_rec c_cal_instance%ROWTYPE;
1648: CURSOR c_derived_cal_instance(
1649: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1650: cp_start_dt IGS_CA_INST.start_dt%TYPE,
1651: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
1652: SELECT ci.CAL_TYPE,
1653: ci.sequence_number,

Line 1650: cp_start_dt IGS_CA_INST.start_dt%TYPE,

1646: ci.sequence_number = cp_sequence_number;
1647: v_cal_inst_rec c_cal_instance%ROWTYPE;
1648: CURSOR c_derived_cal_instance(
1649: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1650: cp_start_dt IGS_CA_INST.start_dt%TYPE,
1651: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
1652: SELECT ci.CAL_TYPE,
1653: ci.sequence_number,
1654: cs.s_cal_status

Line 1651: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS

1647: v_cal_inst_rec c_cal_instance%ROWTYPE;
1648: CURSOR c_derived_cal_instance(
1649: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1650: cp_start_dt IGS_CA_INST.start_dt%TYPE,
1651: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
1652: SELECT ci.CAL_TYPE,
1653: ci.sequence_number,
1654: cs.s_cal_status
1655: FROM IGS_CA_INST ci,

Line 1655: FROM IGS_CA_INST ci,

1651: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
1652: SELECT ci.CAL_TYPE,
1653: ci.sequence_number,
1654: cs.s_cal_status
1655: FROM IGS_CA_INST ci,
1656: IGS_CA_STAT cs
1657: WHERE ci.CAL_TYPE = cp_cal_type AND
1658: ci.start_dt = cp_start_dt AND
1659: ci.end_dt = cp_end_dt AND

Line 1663: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

1659: ci.end_dt = cp_end_dt AND
1660: ci.CAL_STATUS = cs.CAL_STATUS;
1661: v_derived_cal_instance_rec c_derived_cal_instance%ROWTYPE;
1662: CURSOR c_cir(
1663: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1664: cp_sub_ci_sequence_number
1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,
1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number

Line 1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,

1661: v_derived_cal_instance_rec c_derived_cal_instance%ROWTYPE;
1662: CURSOR c_cir(
1663: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1664: cp_sub_ci_sequence_number
1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,
1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number
1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
1669: SELECT 'x'

Line 1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

1662: CURSOR c_cir(
1663: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1664: cp_sub_ci_sequence_number
1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,
1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number
1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
1669: SELECT 'x'
1670: FROM IGS_CA_INST_REL cir

Line 1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS

1664: cp_sub_ci_sequence_number
1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,
1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number
1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
1669: SELECT 'x'
1670: FROM IGS_CA_INST_REL cir
1671: WHERE cir.sub_cal_type = cp_sub_cal_type AND
1672: cir.sub_ci_sequence_number = cp_sub_ci_sequence_number AND

Line 1670: FROM IGS_CA_INST_REL cir

1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number
1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
1669: SELECT 'x'
1670: FROM IGS_CA_INST_REL cir
1671: WHERE cir.sub_cal_type = cp_sub_cal_type AND
1672: cir.sub_ci_sequence_number = cp_sub_ci_sequence_number AND
1673: cir.sup_cal_type = cp_sup_cal_type AND
1674: cir.sup_ci_sequence_number = cp_sup_ci_sequence_number;

Line 1820: IGS_CA_INST_REL_PKG.INSERT_ROW(

1816: FETCH c_cir INTO v_dummy;
1817: IF c_cir%NOTFOUND THEN
1818: CLOSE c_cir;
1819:
1820: IGS_CA_INST_REL_PKG.INSERT_ROW(
1821: X_ROWID => X_ROWID,
1822: X_sub_cal_type => p_sub_cal_type,
1823: X_sub_ci_sequence_number => p_sub_ci_sequence_number,
1824: X_sup_cal_type => v_derived_cal_instance_rec.CAL_TYPE,

Line 1920: -- Validate IGS_CA_INST_REL

1916: CLOSE c_cal_instance;
1917: RAISE NO_DATA_FOUND;
1918: END IF;
1919: CLOSE c_cal_instance;
1920: -- Validate IGS_CA_INST_REL
1921: IF NOT IGS_CA_VAL_CIR.calp_val_cir_ci (
1922: p_sub_cal_type,
1923: p_sub_ci_sequence_number,
1924: p_sup_cal_type,

Line 1957: IGS_CA_INST_REL_PKG.INSERT_ROW(

1953: v_other_detail);
1954: ELSE
1955: -- Insert calendar instance relationship
1956:
1957: IGS_CA_INST_REL_PKG.INSERT_ROW(
1958: X_ROWID => X_ROWID,
1959: X_sub_cal_type => p_sub_cal_type,
1960: X_sub_ci_sequence_number => p_sub_ci_sequence_number,
1961: X_sup_cal_type => p_sup_cal_type,

Line 2057: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

2053: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
2054: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
2055: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
2056: FUNCTION calpl_val_rolled_ci(
2057: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2058: p_sequence_number IGS_CA_INST.sequence_number%TYPE,
2059: p_start_dt OUT NOCOPY IGS_CA_INST.start_dt%TYPE,
2060: p_end_dt OUT NOCOPY IGS_CA_INST.end_dt%TYPE,
2061: p_message_name OUT NOCOPY varchar2)

Line 2058: p_sequence_number IGS_CA_INST.sequence_number%TYPE,

2054: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
2055: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
2056: FUNCTION calpl_val_rolled_ci(
2057: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2058: p_sequence_number IGS_CA_INST.sequence_number%TYPE,
2059: p_start_dt OUT NOCOPY IGS_CA_INST.start_dt%TYPE,
2060: p_end_dt OUT NOCOPY IGS_CA_INST.end_dt%TYPE,
2061: p_message_name OUT NOCOPY varchar2)
2062: RETURN BOOLEAN AS

Line 2059: p_start_dt OUT NOCOPY IGS_CA_INST.start_dt%TYPE,

2055: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
2056: FUNCTION calpl_val_rolled_ci(
2057: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2058: p_sequence_number IGS_CA_INST.sequence_number%TYPE,
2059: p_start_dt OUT NOCOPY IGS_CA_INST.start_dt%TYPE,
2060: p_end_dt OUT NOCOPY IGS_CA_INST.end_dt%TYPE,
2061: p_message_name OUT NOCOPY varchar2)
2062: RETURN BOOLEAN AS
2063: BEGIN

Line 2060: p_end_dt OUT NOCOPY IGS_CA_INST.end_dt%TYPE,

2056: FUNCTION calpl_val_rolled_ci(
2057: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2058: p_sequence_number IGS_CA_INST.sequence_number%TYPE,
2059: p_start_dt OUT NOCOPY IGS_CA_INST.start_dt%TYPE,
2060: p_end_dt OUT NOCOPY IGS_CA_INST.end_dt%TYPE,
2061: p_message_name OUT NOCOPY varchar2)
2062: RETURN BOOLEAN AS
2063: BEGIN
2064: -- Validate calendar instance exists and is not inactive.

Line 2067: v_cal_instance_rec IGS_CA_INST%ROWTYPE;

2063: BEGIN
2064: -- Validate calendar instance exists and is not inactive.
2065: DECLARE
2066: v_other_detail VARCHAR2(255);
2067: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
2068: CURSOR c_cal_instance IS
2069: SELECT *
2070: FROM IGS_CA_INST
2071: WHERE CAL_TYPE = p_cal_type AND

Line 2070: FROM IGS_CA_INST

2066: v_other_detail VARCHAR2(255);
2067: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
2068: CURSOR c_cal_instance IS
2069: SELECT *
2070: FROM IGS_CA_INST
2071: WHERE CAL_TYPE = p_cal_type AND
2072: sequence_number = p_sequence_number;
2073: CURSOR c_cal_status(
2074: cp_cal_status IGS_CA_INST.CAL_STATUS%TYPE) IS

Line 2074: cp_cal_status IGS_CA_INST.CAL_STATUS%TYPE) IS

2070: FROM IGS_CA_INST
2071: WHERE CAL_TYPE = p_cal_type AND
2072: sequence_number = p_sequence_number;
2073: CURSOR c_cal_status(
2074: cp_cal_status IGS_CA_INST.CAL_STATUS%TYPE) IS
2075: SELECT *
2076: FROM IGS_CA_STAT
2077: WHERE CAL_STATUS = cp_cal_status;
2078: BEGIN

Line 2089: -- Invalid parameters IGS_CA_INST status cannot be

2085: LOOP
2086: FETCH c_cal_instance INTO v_cal_instance_rec;
2087: IF(c_cal_instance%NOTFOUND) THEN
2088: CLOSE c_cal_instance;
2089: -- Invalid parameters IGS_CA_INST status cannot be
2090: -- determined
2091: p_message_name :='IGS_OR_LOC_TYPE_CLOSED';
2092: RETURN FALSE;
2093: END IF;

Line 2105: -- Inactive IGS_CA_INST cannot be rolled

2101: END IF;
2102: FOR v_cal_status_rec IN c_cal_status(
2103: v_cal_instance_rec.CAL_STATUS) LOOP
2104: IF(v_cal_status_rec.s_cal_status = cst_inactive) THEN
2105: -- Inactive IGS_CA_INST cannot be rolled
2106: p_message_name :='IGS_OR_ADDR_TYPE_CLOSE';
2107: RETURN FALSE;
2108: END IF;
2109: END LOOP;

Line 2121: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,

2117: App_Exception.Raise_Exception;
2118: END;
2119: END calpl_val_rolled_ci;
2120: FUNCTION calpl_ins_rollvr_ci(
2121: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
2122: p_sequence_number IGS_CA_INST.sequence_number%TYPE ,
2123: p_diff_days NUMBER ,
2124: p_diff_months NUMBER,
2125: p_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,

Line 2122: p_sequence_number IGS_CA_INST.sequence_number%TYPE ,

2118: END;
2119: END calpl_val_rolled_ci;
2120: FUNCTION calpl_ins_rollvr_ci(
2121: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
2122: p_sequence_number IGS_CA_INST.sequence_number%TYPE ,
2123: p_diff_days NUMBER ,
2124: p_diff_months NUMBER,
2125: p_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
2126: p_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE ,

Line 2125: p_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,

2121: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
2122: p_sequence_number IGS_CA_INST.sequence_number%TYPE ,
2123: p_diff_days NUMBER ,
2124: p_diff_months NUMBER,
2125: p_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
2126: p_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE ,
2127: p_new_sequence_number OUT NOCOPY IGS_CA_INST.sequence_number%TYPE,
2128: p_ci_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE,
2129: p_message_name OUT NOCOPY varchar2 )

Line 2126: p_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE ,

2122: p_sequence_number IGS_CA_INST.sequence_number%TYPE ,
2123: p_diff_days NUMBER ,
2124: p_diff_months NUMBER,
2125: p_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
2126: p_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE ,
2127: p_new_sequence_number OUT NOCOPY IGS_CA_INST.sequence_number%TYPE,
2128: p_ci_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE,
2129: p_message_name OUT NOCOPY varchar2 )
2130: RETURN BOOLEAN AS

Line 2127: p_new_sequence_number OUT NOCOPY IGS_CA_INST.sequence_number%TYPE,

2123: p_diff_days NUMBER ,
2124: p_diff_months NUMBER,
2125: p_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
2126: p_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE ,
2127: p_new_sequence_number OUT NOCOPY IGS_CA_INST.sequence_number%TYPE,
2128: p_ci_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE,
2129: p_message_name OUT NOCOPY varchar2 )
2130: RETURN BOOLEAN AS
2131: BEGIN

Line 2128: p_ci_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE,

2124: p_diff_months NUMBER,
2125: p_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
2126: p_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE ,
2127: p_new_sequence_number OUT NOCOPY IGS_CA_INST.sequence_number%TYPE,
2128: p_ci_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE,
2129: p_message_name OUT NOCOPY varchar2 )
2130: RETURN BOOLEAN AS
2131: BEGIN
2132: DECLARE

Line 2137: v_old_start_dt IGS_CA_INST.start_dt%TYPE;

2133: X_ROWID VARCHAR2(25);
2134: v_other_detail VARCHAR2(255);
2135: token1_val VARCHAR2(255);
2136: token2_val VARCHAR2(255);
2137: v_old_start_dt IGS_CA_INST.start_dt%TYPE;
2138: v_old_end_dt IGS_CA_INST.end_dt%TYPE;
2139: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2140: v_new_start_dt IGS_CA_INST.start_dt%TYPE;
2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;

Line 2138: v_old_end_dt IGS_CA_INST.end_dt%TYPE;

2134: v_other_detail VARCHAR2(255);
2135: token1_val VARCHAR2(255);
2136: token2_val VARCHAR2(255);
2137: v_old_start_dt IGS_CA_INST.start_dt%TYPE;
2138: v_old_end_dt IGS_CA_INST.end_dt%TYPE;
2139: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2140: v_new_start_dt IGS_CA_INST.start_dt%TYPE;
2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;
2142: v_new_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

Line 2139: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;

2135: token1_val VARCHAR2(255);
2136: token2_val VARCHAR2(255);
2137: v_old_start_dt IGS_CA_INST.start_dt%TYPE;
2138: v_old_end_dt IGS_CA_INST.end_dt%TYPE;
2139: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2140: v_new_start_dt IGS_CA_INST.start_dt%TYPE;
2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;
2142: v_new_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2143: v_new_alternate_code IGS_CA_INST.alternate_code%TYPE;

Line 2140: v_new_start_dt IGS_CA_INST.start_dt%TYPE;

2136: token2_val VARCHAR2(255);
2137: v_old_start_dt IGS_CA_INST.start_dt%TYPE;
2138: v_old_end_dt IGS_CA_INST.end_dt%TYPE;
2139: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2140: v_new_start_dt IGS_CA_INST.start_dt%TYPE;
2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;
2142: v_new_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2143: v_new_alternate_code IGS_CA_INST.alternate_code%TYPE;
2144: l_n_org_id IGS_CA_INST.ORG_ID%TYPE := igs_ge_gen_003.get_org_id;

Line 2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;

2137: v_old_start_dt IGS_CA_INST.start_dt%TYPE;
2138: v_old_end_dt IGS_CA_INST.end_dt%TYPE;
2139: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2140: v_new_start_dt IGS_CA_INST.start_dt%TYPE;
2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;
2142: v_new_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2143: v_new_alternate_code IGS_CA_INST.alternate_code%TYPE;
2144: l_n_org_id IGS_CA_INST.ORG_ID%TYPE := igs_ge_gen_003.get_org_id;
2145: v_new_cal_status IGS_CA_STAT.CAL_STATUS%TYPE;

Line 2142: v_new_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

2138: v_old_end_dt IGS_CA_INST.end_dt%TYPE;
2139: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2140: v_new_start_dt IGS_CA_INST.start_dt%TYPE;
2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;
2142: v_new_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2143: v_new_alternate_code IGS_CA_INST.alternate_code%TYPE;
2144: l_n_org_id IGS_CA_INST.ORG_ID%TYPE := igs_ge_gen_003.get_org_id;
2145: v_new_cal_status IGS_CA_STAT.CAL_STATUS%TYPE;
2146: v_message_name VARCHAR2(30);

Line 2143: v_new_alternate_code IGS_CA_INST.alternate_code%TYPE;

2139: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2140: v_new_start_dt IGS_CA_INST.start_dt%TYPE;
2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;
2142: v_new_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2143: v_new_alternate_code IGS_CA_INST.alternate_code%TYPE;
2144: l_n_org_id IGS_CA_INST.ORG_ID%TYPE := igs_ge_gen_003.get_org_id;
2145: v_new_cal_status IGS_CA_STAT.CAL_STATUS%TYPE;
2146: v_message_name VARCHAR2(30);
2147: v_cal_instance_rec IGS_CA_INST%ROWTYPE;

Line 2144: l_n_org_id IGS_CA_INST.ORG_ID%TYPE := igs_ge_gen_003.get_org_id;

2140: v_new_start_dt IGS_CA_INST.start_dt%TYPE;
2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;
2142: v_new_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2143: v_new_alternate_code IGS_CA_INST.alternate_code%TYPE;
2144: l_n_org_id IGS_CA_INST.ORG_ID%TYPE := igs_ge_gen_003.get_org_id;
2145: v_new_cal_status IGS_CA_STAT.CAL_STATUS%TYPE;
2146: v_message_name VARCHAR2(30);
2147: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
2148: v_new_cal_instance_rec IGS_CA_INST%ROWTYPE;

Line 2147: v_cal_instance_rec IGS_CA_INST%ROWTYPE;

2143: v_new_alternate_code IGS_CA_INST.alternate_code%TYPE;
2144: l_n_org_id IGS_CA_INST.ORG_ID%TYPE := igs_ge_gen_003.get_org_id;
2145: v_new_cal_status IGS_CA_STAT.CAL_STATUS%TYPE;
2146: v_message_name VARCHAR2(30);
2147: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
2148: v_new_cal_instance_rec IGS_CA_INST%ROWTYPE;
2149: v_cal_type_rec IGS_CA_TYPE%ROWTYPE;
2150: v_unique_sequence IGS_CA_INST.sequence_number%TYPE; -- added for bug 2563531
2151: v_cal_instance_exists BOOLEAN;

Line 2148: v_new_cal_instance_rec IGS_CA_INST%ROWTYPE;

2144: l_n_org_id IGS_CA_INST.ORG_ID%TYPE := igs_ge_gen_003.get_org_id;
2145: v_new_cal_status IGS_CA_STAT.CAL_STATUS%TYPE;
2146: v_message_name VARCHAR2(30);
2147: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
2148: v_new_cal_instance_rec IGS_CA_INST%ROWTYPE;
2149: v_cal_type_rec IGS_CA_TYPE%ROWTYPE;
2150: v_unique_sequence IGS_CA_INST.sequence_number%TYPE; -- added for bug 2563531
2151: v_cal_instance_exists BOOLEAN;
2152: v_new_term_instruction_time IGS_CA_INST.term_instruction_time%TYPE;

Line 2150: v_unique_sequence IGS_CA_INST.sequence_number%TYPE; -- added for bug 2563531

2146: v_message_name VARCHAR2(30);
2147: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
2148: v_new_cal_instance_rec IGS_CA_INST%ROWTYPE;
2149: v_cal_type_rec IGS_CA_TYPE%ROWTYPE;
2150: v_unique_sequence IGS_CA_INST.sequence_number%TYPE; -- added for bug 2563531
2151: v_cal_instance_exists BOOLEAN;
2152: v_new_term_instruction_time IGS_CA_INST.term_instruction_time%TYPE;
2153:
2154: CURSOR c_cal_instance IS

Line 2152: v_new_term_instruction_time IGS_CA_INST.term_instruction_time%TYPE;

2148: v_new_cal_instance_rec IGS_CA_INST%ROWTYPE;
2149: v_cal_type_rec IGS_CA_TYPE%ROWTYPE;
2150: v_unique_sequence IGS_CA_INST.sequence_number%TYPE; -- added for bug 2563531
2151: v_cal_instance_exists BOOLEAN;
2152: v_new_term_instruction_time IGS_CA_INST.term_instruction_time%TYPE;
2153:
2154: CURSOR c_cal_instance IS
2155: SELECT *
2156: FROM IGS_CA_INST

Line 2156: FROM IGS_CA_INST

2152: v_new_term_instruction_time IGS_CA_INST.term_instruction_time%TYPE;
2153:
2154: CURSOR c_cal_instance IS
2155: SELECT *
2156: FROM IGS_CA_INST
2157: WHERE CAL_TYPE = p_cal_type AND
2158: sequence_number = p_sequence_number;
2159: CURSOR c_new_cal_instance(
2160: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 2160: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

2156: FROM IGS_CA_INST
2157: WHERE CAL_TYPE = p_cal_type AND
2158: sequence_number = p_sequence_number;
2159: CURSOR c_new_cal_instance(
2160: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2161: cp_start_dt IGS_CA_INST.start_dt%TYPE,
2162: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
2163: SELECT *
2164: FROM IGS_CA_INST

Line 2161: cp_start_dt IGS_CA_INST.start_dt%TYPE,

2157: WHERE CAL_TYPE = p_cal_type AND
2158: sequence_number = p_sequence_number;
2159: CURSOR c_new_cal_instance(
2160: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2161: cp_start_dt IGS_CA_INST.start_dt%TYPE,
2162: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
2163: SELECT *
2164: FROM IGS_CA_INST
2165: WHERE CAL_TYPE = cp_cal_type AND

Line 2162: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS

2158: sequence_number = p_sequence_number;
2159: CURSOR c_new_cal_instance(
2160: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2161: cp_start_dt IGS_CA_INST.start_dt%TYPE,
2162: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
2163: SELECT *
2164: FROM IGS_CA_INST
2165: WHERE CAL_TYPE = cp_cal_type AND
2166: start_dt = cp_start_dt AND

Line 2164: FROM IGS_CA_INST

2160: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2161: cp_start_dt IGS_CA_INST.start_dt%TYPE,
2162: cp_end_dt IGS_CA_INST.end_dt%TYPE) IS
2163: SELECT *
2164: FROM IGS_CA_INST
2165: WHERE CAL_TYPE = cp_cal_type AND
2166: start_dt = cp_start_dt AND
2167: end_dt = cp_end_dt;
2168: CURSOR c_cal_status(

Line 2169: cp_cal_status IGS_CA_INST.CAL_STATUS%TYPE) IS

2165: WHERE CAL_TYPE = cp_cal_type AND
2166: start_dt = cp_start_dt AND
2167: end_dt = cp_end_dt;
2168: CURSOR c_cal_status(
2169: cp_cal_status IGS_CA_INST.CAL_STATUS%TYPE) IS
2170: SELECT *
2171: FROM IGS_CA_STAT
2172: WHERE s_cal_status = cp_cal_status;
2173: CURSOR c_cal_type(

Line 2174: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS

2170: SELECT *
2171: FROM IGS_CA_STAT
2172: WHERE s_cal_status = cp_cal_status;
2173: CURSOR c_cal_type(
2174: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS
2175: SELECT *
2176: FROM IGS_CA_TYPE
2177: WHERE CAL_TYPE = cp_cal_type;
2178: CURSOR c_ci_sequence_number IS

Line 2179: SELECT IGS_CA_INST_SEQ_NUM_S.nextval

2175: SELECT *
2176: FROM IGS_CA_TYPE
2177: WHERE CAL_TYPE = cp_cal_type;
2178: CURSOR c_ci_sequence_number IS
2179: SELECT IGS_CA_INST_SEQ_NUM_S.nextval
2180: FROM DUAL;
2181:
2182: -- Sequence to get unique value for alternate codes bug - 2563531
2183: CURSOR alt_uniq_seq IS

Line 2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;

2180: FROM DUAL;
2181:
2182: -- Sequence to get unique value for alternate codes bug - 2563531
2183: CURSOR alt_uniq_seq IS
2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;
2185: -- cursor to check whether the alternate code for academic calendar instance is already present.
2186: CURSOR alt_code_unique(p_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
2187: SELECT count(*)
2188: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT

Line 2186: CURSOR alt_code_unique(p_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE) IS

2182: -- Sequence to get unique value for alternate codes bug - 2563531
2183: CURSOR alt_uniq_seq IS
2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;
2185: -- cursor to check whether the alternate code for academic calendar instance is already present.
2186: CURSOR alt_code_unique(p_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
2187: SELECT count(*)
2188: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT
2189: WHERE CAT.CAL_TYPE = CI.CAL_TYPE
2190: AND CAT.S_CAL_CAT IN ('ACADEMIC' ,'LOAD','TEACHING')

Line 2188: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT

2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;
2185: -- cursor to check whether the alternate code for academic calendar instance is already present.
2186: CURSOR alt_code_unique(p_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
2187: SELECT count(*)
2188: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT
2189: WHERE CAT.CAL_TYPE = CI.CAL_TYPE
2190: AND CAT.S_CAL_CAT IN ('ACADEMIC' ,'LOAD','TEACHING')
2191: AND CI.ALTERNATE_CODE = p_alternate_code;
2192: l_count NUMBER(3);

Line 2421: --Description to be added in IGS_CA_INST_ALL Table

2417: -- Insert new calendar instance
2418: v_new_term_instruction_time := v_cal_instance_rec.term_instruction_time;
2419: --A DESCRIPTION Column is ADDED in the Insert Row Procedure
2420: --Enh Bug :- 2138560,Change Request for Calendar Instance
2421: --Description to be added in IGS_CA_INST_ALL Table
2422: IGS_CA_INST_PKG.INSERT_ROW(
2423: X_ROWID => X_ROWID,
2424: X_CAL_TYPE => v_new_cal_type,
2425: X_sequence_number => v_new_sequence_number,

Line 2422: IGS_CA_INST_PKG.INSERT_ROW(

2418: v_new_term_instruction_time := v_cal_instance_rec.term_instruction_time;
2419: --A DESCRIPTION Column is ADDED in the Insert Row Procedure
2420: --Enh Bug :- 2138560,Change Request for Calendar Instance
2421: --Description to be added in IGS_CA_INST_ALL Table
2422: IGS_CA_INST_PKG.INSERT_ROW(
2423: X_ROWID => X_ROWID,
2424: X_CAL_TYPE => v_new_cal_type,
2425: X_sequence_number => v_new_sequence_number,
2426: X_start_dt => v_new_start_dt,

Line 2518: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;

2514: DECLARE
2515: v_other_detail VARCHAR2(255);
2516: token1_val VARCHAR2(255);
2517: token2_val VARCHAR2(255);
2518: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2519: v_message_name VARCHAR2(30);
2520: v_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2521: v_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE;
2522: v_cir5_rec IGS_CA_INST_REL%ROWTYPE;

Line 2520: v_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

2516: token1_val VARCHAR2(255);
2517: token2_val VARCHAR2(255);
2518: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2519: v_message_name VARCHAR2(30);
2520: v_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2521: v_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE;
2522: v_cir5_rec IGS_CA_INST_REL%ROWTYPE;
2523: v_ci_rollover_sequence_number
2524: IGS_CA_INST.sequence_number%TYPE;

Line 2521: v_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE;

2517: token2_val VARCHAR2(255);
2518: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2519: v_message_name VARCHAR2(30);
2520: v_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2521: v_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE;
2522: v_cir5_rec IGS_CA_INST_REL%ROWTYPE;
2523: v_ci_rollover_sequence_number
2524: IGS_CA_INST.sequence_number%TYPE;
2525: TYPE t1_rollover_ci_rec IS RECORD(

Line 2522: v_cir5_rec IGS_CA_INST_REL%ROWTYPE;

2518: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2519: v_message_name VARCHAR2(30);
2520: v_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2521: v_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE;
2522: v_cir5_rec IGS_CA_INST_REL%ROWTYPE;
2523: v_ci_rollover_sequence_number
2524: IGS_CA_INST.sequence_number%TYPE;
2525: TYPE t1_rollover_ci_rec IS RECORD(
2526: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,

Line 2524: IGS_CA_INST.sequence_number%TYPE;

2520: v_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2521: v_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE;
2522: v_cir5_rec IGS_CA_INST_REL%ROWTYPE;
2523: v_ci_rollover_sequence_number
2524: IGS_CA_INST.sequence_number%TYPE;
2525: TYPE t1_rollover_ci_rec IS RECORD(
2526: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,
2527: sequence_number IGS_CA_INST.sequence_number%TYPE,
2528: rollover_sequence_number IGS_CA_INST.sequence_number%TYPE);

Line 2526: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,

2522: v_cir5_rec IGS_CA_INST_REL%ROWTYPE;
2523: v_ci_rollover_sequence_number
2524: IGS_CA_INST.sequence_number%TYPE;
2525: TYPE t1_rollover_ci_rec IS RECORD(
2526: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,
2527: sequence_number IGS_CA_INST.sequence_number%TYPE,
2528: rollover_sequence_number IGS_CA_INST.sequence_number%TYPE);
2529: TYPE t1_rollover_ci_table IS TABLE OF t1_rollover_ci_rec
2530: INDEX BY BINARY_INTEGER;

Line 2527: sequence_number IGS_CA_INST.sequence_number%TYPE,

2523: v_ci_rollover_sequence_number
2524: IGS_CA_INST.sequence_number%TYPE;
2525: TYPE t1_rollover_ci_rec IS RECORD(
2526: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,
2527: sequence_number IGS_CA_INST.sequence_number%TYPE,
2528: rollover_sequence_number IGS_CA_INST.sequence_number%TYPE);
2529: TYPE t1_rollover_ci_table IS TABLE OF t1_rollover_ci_rec
2530: INDEX BY BINARY_INTEGER;
2531: t1_rollover_ci t1_rollover_ci_table;

Line 2528: rollover_sequence_number IGS_CA_INST.sequence_number%TYPE);

2524: IGS_CA_INST.sequence_number%TYPE;
2525: TYPE t1_rollover_ci_rec IS RECORD(
2526: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,
2527: sequence_number IGS_CA_INST.sequence_number%TYPE,
2528: rollover_sequence_number IGS_CA_INST.sequence_number%TYPE);
2529: TYPE t1_rollover_ci_table IS TABLE OF t1_rollover_ci_rec
2530: INDEX BY BINARY_INTEGER;
2531: t1_rollover_ci t1_rollover_ci_table;
2532: t1_rollover_ci_index BINARY_INTEGER;

Line 2536: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,

2532: t1_rollover_ci_index BINARY_INTEGER;
2533: v_index BINARY_INTEGER;
2534: v2_index BINARY_INTEGER;
2535: TYPE t2_rollover_ci_rec IS RECORD(
2536: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,
2537: sequence_number IGS_CA_INST.sequence_number%TYPE,
2538: rollover_sequence_number IGS_CA_INST.sequence_number%TYPE);
2539: TYPE t2_rollover_ci_table IS TABLE OF t2_rollover_ci_rec
2540: INDEX BY BINARY_INTEGER;

Line 2537: sequence_number IGS_CA_INST.sequence_number%TYPE,

2533: v_index BINARY_INTEGER;
2534: v2_index BINARY_INTEGER;
2535: TYPE t2_rollover_ci_rec IS RECORD(
2536: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,
2537: sequence_number IGS_CA_INST.sequence_number%TYPE,
2538: rollover_sequence_number IGS_CA_INST.sequence_number%TYPE);
2539: TYPE t2_rollover_ci_table IS TABLE OF t2_rollover_ci_rec
2540: INDEX BY BINARY_INTEGER;
2541: t2_rollover_ci t2_rollover_ci_table;

Line 2538: rollover_sequence_number IGS_CA_INST.sequence_number%TYPE);

2534: v2_index BINARY_INTEGER;
2535: TYPE t2_rollover_ci_rec IS RECORD(
2536: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,
2537: sequence_number IGS_CA_INST.sequence_number%TYPE,
2538: rollover_sequence_number IGS_CA_INST.sequence_number%TYPE);
2539: TYPE t2_rollover_ci_table IS TABLE OF t2_rollover_ci_rec
2540: INDEX BY BINARY_INTEGER;
2541: t2_rollover_ci t2_rollover_ci_table;
2542: t2_rollover_ci_index BINARY_INTEGER;

Line 2544: SELECT IGS_CA_INST_REL_SUP_CI_SNO_S1.NEXTVAL

2540: INDEX BY BINARY_INTEGER;
2541: t2_rollover_ci t2_rollover_ci_table;
2542: t2_rollover_ci_index BINARY_INTEGER;
2543: CURSOR c_ci_rollover_sequence_number IS
2544: SELECT IGS_CA_INST_REL_SUP_CI_SNO_S1.NEXTVAL
2545: FROM dual;
2546: CURSOR c_cir1 IS
2547: SELECT *
2548: FROM IGS_CA_INST_REL

Line 2548: FROM IGS_CA_INST_REL

2544: SELECT IGS_CA_INST_REL_SUP_CI_SNO_S1.NEXTVAL
2545: FROM dual;
2546: CURSOR c_cir1 IS
2547: SELECT *
2548: FROM IGS_CA_INST_REL
2549: WHERE sup_cal_type = p_cal_type AND
2550: sup_ci_sequence_number = p_sequence_number;
2551: CURSOR c_cir2 IS
2552: SELECT *

Line 2553: FROM IGS_CA_INST_REL cir1

2549: WHERE sup_cal_type = p_cal_type AND
2550: sup_ci_sequence_number = p_sequence_number;
2551: CURSOR c_cir2 IS
2552: SELECT *
2553: FROM IGS_CA_INST_REL cir1
2554: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2555: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2556: FROM IGS_CA_INST_REL cir2
2557: WHERE cir2.sup_cal_type = p_cal_type AND

Line 2556: FROM IGS_CA_INST_REL cir2

2552: SELECT *
2553: FROM IGS_CA_INST_REL cir1
2554: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2555: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2556: FROM IGS_CA_INST_REL cir2
2557: WHERE cir2.sup_cal_type = p_cal_type AND
2558: cir2.sup_ci_sequence_number = p_sequence_number);
2559: CURSOR c_cir3 IS
2560: SELECT *

Line 2561: FROM IGS_CA_INST_REL cir1

2557: WHERE cir2.sup_cal_type = p_cal_type AND
2558: cir2.sup_ci_sequence_number = p_sequence_number);
2559: CURSOR c_cir3 IS
2560: SELECT *
2561: FROM IGS_CA_INST_REL cir1
2562: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2563: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2564: FROM IGS_CA_INST_REL cir2
2565: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN

Line 2564: FROM IGS_CA_INST_REL cir2

2560: SELECT *
2561: FROM IGS_CA_INST_REL cir1
2562: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2563: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2564: FROM IGS_CA_INST_REL cir2
2565: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2566: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2567: FROM IGS_CA_INST_REL cir3
2568: WHERE cir3.sup_cal_type = p_cal_type AND

Line 2567: FROM IGS_CA_INST_REL cir3

2563: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2564: FROM IGS_CA_INST_REL cir2
2565: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2566: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2567: FROM IGS_CA_INST_REL cir3
2568: WHERE cir3.sup_cal_type = p_cal_type AND
2569: cir3.sup_ci_sequence_number = p_sequence_number));
2570: CURSOR c_cir4 IS
2571: SELECT *

Line 2572: FROM IGS_CA_INST_REL cir1

2568: WHERE cir3.sup_cal_type = p_cal_type AND
2569: cir3.sup_ci_sequence_number = p_sequence_number));
2570: CURSOR c_cir4 IS
2571: SELECT *
2572: FROM IGS_CA_INST_REL cir1
2573: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2574: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2575: FROM IGS_CA_INST_REL cir2
2576: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN

Line 2575: FROM IGS_CA_INST_REL cir2

2571: SELECT *
2572: FROM IGS_CA_INST_REL cir1
2573: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2574: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2575: FROM IGS_CA_INST_REL cir2
2576: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2577: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2578: FROM IGS_CA_INST_REL cir3
2579: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN

Line 2578: FROM IGS_CA_INST_REL cir3

2574: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2575: FROM IGS_CA_INST_REL cir2
2576: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2577: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2578: FROM IGS_CA_INST_REL cir3
2579: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN
2580: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2581: FROM IGS_CA_INST_REL cir4
2582: WHERE cir4.sup_cal_type = p_cal_type AND

Line 2581: FROM IGS_CA_INST_REL cir4

2577: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2578: FROM IGS_CA_INST_REL cir3
2579: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN
2580: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2581: FROM IGS_CA_INST_REL cir4
2582: WHERE cir4.sup_cal_type = p_cal_type AND
2583: cir4.sup_ci_sequence_number = p_sequence_number)));
2584: CURSOR c_cir5 IS
2585: SELECT *

Line 2586: FROM IGS_CA_INST_REL cir1

2582: WHERE cir4.sup_cal_type = p_cal_type AND
2583: cir4.sup_ci_sequence_number = p_sequence_number)));
2584: CURSOR c_cir5 IS
2585: SELECT *
2586: FROM IGS_CA_INST_REL cir1
2587: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2588: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2589: FROM IGS_CA_INST_REL cir2
2590: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN

Line 2589: FROM IGS_CA_INST_REL cir2

2585: SELECT *
2586: FROM IGS_CA_INST_REL cir1
2587: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2588: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2589: FROM IGS_CA_INST_REL cir2
2590: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2591: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2592: FROM IGS_CA_INST_REL cir3
2593: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN

Line 2592: FROM IGS_CA_INST_REL cir3

2588: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2589: FROM IGS_CA_INST_REL cir2
2590: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2591: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2592: FROM IGS_CA_INST_REL cir3
2593: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN
2594: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2595: FROM IGS_CA_INST_REL cir4
2596: WHERE (cir4.sup_cal_type,cir4.sup_ci_sequence_number) IN

Line 2595: FROM IGS_CA_INST_REL cir4

2591: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2592: FROM IGS_CA_INST_REL cir3
2593: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN
2594: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2595: FROM IGS_CA_INST_REL cir4
2596: WHERE (cir4.sup_cal_type,cir4.sup_ci_sequence_number) IN
2597: (SELECT DISTINCT cir5.sub_cal_type,cir5.sub_ci_sequence_number
2598: FROM IGS_CA_INST_REL cir5
2599: WHERE cir5.sup_cal_type = p_cal_type AND

Line 2598: FROM IGS_CA_INST_REL cir5

2594: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2595: FROM IGS_CA_INST_REL cir4
2596: WHERE (cir4.sup_cal_type,cir4.sup_ci_sequence_number) IN
2597: (SELECT DISTINCT cir5.sub_cal_type,cir5.sub_ci_sequence_number
2598: FROM IGS_CA_INST_REL cir5
2599: WHERE cir5.sup_cal_type = p_cal_type AND
2600: cir5.sup_ci_sequence_number = p_sequence_number))));
2601: BEGIN
2602: -- Insert rollover calendar instance, its calendar instance relationships