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_GEN_001 dependencies on IGS_CA_INST

Line 60: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

56: RETURN VARCHAR2 AS
57: BEGIN
58: DECLARE
59: CURSOR c_ci (
60: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
61: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
62: SELECT ci.alternate_code
63: FROM IGS_CA_INST ci
64: WHERE ci.CAL_TYPE = cp_cal_type AND

Line 61: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

57: BEGIN
58: DECLARE
59: CURSOR c_ci (
60: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
61: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
62: SELECT ci.alternate_code
63: FROM IGS_CA_INST ci
64: WHERE ci.CAL_TYPE = cp_cal_type AND
65: ci.sequence_number = cp_sequence_number;

Line 63: FROM IGS_CA_INST ci

59: CURSOR c_ci (
60: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
61: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
62: SELECT ci.alternate_code
63: FROM IGS_CA_INST ci
64: WHERE ci.CAL_TYPE = cp_cal_type AND
65: ci.sequence_number = cp_sequence_number;
66: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
67: BEGIN

Line 66: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

62: SELECT ci.alternate_code
63: FROM IGS_CA_INST ci
64: WHERE ci.CAL_TYPE = cp_cal_type AND
65: ci.sequence_number = cp_sequence_number;
66: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
67: BEGIN
68: -- Load the start/end date from the source calendar instance.
69: OPEN c_ci(
70: p_cal_type,

Line 122: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;

118: --Module returns the start/end dates as output parameters for a nominated
119: --calendar instance. This routine is used in triggers which have surrogate
120: --start/end dates which should be populated automatically.
121: DECLARE
122: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;
123: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
124: CURSOR c_ci IS
125: SELECT ci.start_dt,
126: ci.end_dt

Line 123: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;

119: --calendar instance. This routine is used in triggers which have surrogate
120: --start/end dates which should be populated automatically.
121: DECLARE
122: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;
123: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
124: CURSOR c_ci IS
125: SELECT ci.start_dt,
126: ci.end_dt
127: FROM IGS_CA_INST ci

Line 127: FROM IGS_CA_INST ci

123: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
124: CURSOR c_ci IS
125: SELECT ci.start_dt,
126: ci.end_dt
127: FROM IGS_CA_INST ci
128: WHERE CAL_TYPE = p_cal_type AND
129: sequence_number = p_ci_sequence_number;
130: BEGIN
131: --Validate parameters

Line 168: v_start_dt IGS_CA_INST.start_dt%TYPE;

164: RETURN DATE AS
165: BEGIN -- calp_get_ci_start_dt
166: -- Return the calendar instance start date.
167: DECLARE
168: v_start_dt IGS_CA_INST.start_dt%TYPE;
169: CURSOR c_ci IS
170: SELECT ci.start_dt
171: FROM IGS_CA_INST ci
172: WHERE ci.CAL_TYPE = p_cal_type AND

Line 171: FROM IGS_CA_INST ci

167: DECLARE
168: v_start_dt IGS_CA_INST.start_dt%TYPE;
169: CURSOR c_ci IS
170: SELECT ci.start_dt
171: FROM IGS_CA_INST ci
172: WHERE ci.CAL_TYPE = p_cal_type AND
173: sequence_number = p_sequence_number;
174: BEGIN
175: OPEN c_ci;

Line 207: v_start_dt IGS_CA_INST.start_dt%TYPE;

203: cst_current CONSTANT VARCHAR2(8) := 'CURRENT';
204: cst_after CONSTANT VARCHAR2(8) := 'AFTER';
205: cst_null CONSTANT VARCHAR2(4) := 'NULL';
206: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
207: v_start_dt IGS_CA_INST.start_dt%TYPE;
208: v_end_dt IGS_CA_INST.end_dt%TYPE;
209: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
210: v_within BOOLEAN;
211: v_before BOOLEAN;

Line 208: v_end_dt IGS_CA_INST.end_dt%TYPE;

204: cst_after CONSTANT VARCHAR2(8) := 'AFTER';
205: cst_null CONSTANT VARCHAR2(4) := 'NULL';
206: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
207: v_start_dt IGS_CA_INST.start_dt%TYPE;
208: v_end_dt IGS_CA_INST.end_dt%TYPE;
209: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
210: v_within BOOLEAN;
211: v_before BOOLEAN;
212: v_after BOOLEAN;

Line 218: cp_source_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

214: SELECT sgcc.census_dt_alias
215: FROM IGS_GE_S_GEN_CAL_CON sgcc
216: WHERE sgcc.s_control_num = 1;
217: CURSOR c_ci (
218: cp_source_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
219: cp_source_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
220: SELECT ci.start_dt,
221: ci.end_dt
222: FROM IGS_CA_INST ci

Line 219: cp_source_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

215: FROM IGS_GE_S_GEN_CAL_CON sgcc
216: WHERE sgcc.s_control_num = 1;
217: CURSOR c_ci (
218: cp_source_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
219: cp_source_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
220: SELECT ci.start_dt,
221: ci.end_dt
222: FROM IGS_CA_INST ci
223: WHERE ci.CAL_TYPE = cp_source_cal_type AND

Line 222: FROM IGS_CA_INST ci

218: cp_source_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
219: cp_source_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
220: SELECT ci.start_dt,
221: ci.end_dt
222: FROM IGS_CA_INST ci
223: WHERE ci.CAL_TYPE = cp_source_cal_type AND
224: ci.sequence_number = cp_source_ci_sequence_number;
225: CURSOR c_daiv (
226: cp_related_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 226: cp_related_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

222: FROM IGS_CA_INST ci
223: WHERE ci.CAL_TYPE = cp_source_cal_type AND
224: ci.sequence_number = cp_source_ci_sequence_number;
225: CURSOR c_daiv (
226: cp_related_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
227: cp_related_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
228: cp_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE) IS
229: SELECT daiv.alias_val
230: FROM IGS_CA_DA_INST_V daiv

Line 227: cp_related_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

223: WHERE ci.CAL_TYPE = cp_source_cal_type AND
224: ci.sequence_number = cp_source_ci_sequence_number;
225: CURSOR c_daiv (
226: cp_related_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
227: cp_related_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
228: cp_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE) IS
229: SELECT daiv.alias_val
230: FROM IGS_CA_DA_INST_V daiv
231: WHERE daiv.CAL_TYPE = cp_related_cal_type AND

Line 316: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE DEFAULT NULL;

312: -- Return the superior calendar instance for a given calendar type and
313: -- subordinate calendar instance.
314: DECLARE
315: v_sup_ci_sequence_number
316: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE DEFAULT NULL;
317: CURSOR c_cir IS
318: SELECT sup_ci_sequence_number
319: FROM IGS_CA_INST_REL
320: WHERE sub_cal_type = p_sub_cal_type AND

Line 319: FROM IGS_CA_INST_REL

315: v_sup_ci_sequence_number
316: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE DEFAULT NULL;
317: CURSOR c_cir IS
318: SELECT sup_ci_sequence_number
319: FROM IGS_CA_INST_REL
320: WHERE sub_cal_type = p_sub_cal_type AND
321: sub_ci_sequence_number = p_sub_ci_sequence_number AND
322: sup_cal_type = p_sup_cal_type;
323: BEGIN

Line 352: v_cal_instance_rec IGS_CA_INST%ROWTYPE;

348: RETURN VARCHAR2 AS
349: cst_teaching_period CONSTANT VARCHAR2(15) := 'TEACHING';
350: cst_academic_period CONSTANT VARCHAR2(15) := 'ACADEMIC';
351: v_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;
352: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
353: v_other_detail VARCHAR2(255);
354: CURSOR c_cal_type IS
355: SELECT S_CAL_CAT
356: FROM IGS_CA_TYPE