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

Line 13: lp_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,

9: || Who When What
10: || (reverse chronological order - newest change first)
11: */
12: FUNCTION get_dt_alias_val (lp_dt_alias IN igs_ca_da_inst.dt_alias%TYPE,
13: lp_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
14: lp_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
15: RETURN DATE IS
16: /*
17: || Created By : nmankodi

Line 14: lp_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)

10: || (reverse chronological order - newest change first)
11: */
12: FUNCTION get_dt_alias_val (lp_dt_alias IN igs_ca_da_inst.dt_alias%TYPE,
13: lp_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
14: lp_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
15: RETURN DATE IS
16: /*
17: || Created By : nmankodi
18: || Created On : 04-FEB-2002

Line 47: lp_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,

43: END get_dt_alias_val; -- get_dt_alias_val
44:
45: FUNCTION check_grading_cohort (lp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
46: lp_grading_period_cd IN igs_as_grd_schema.grading_schema_cd%TYPE,
47: lp_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
48: lp_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
49: RETURN BOOLEAN IS
50: /*
51: || Created By : nmankodi

Line 48: lp_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)

44:
45: FUNCTION check_grading_cohort (lp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
46: lp_grading_period_cd IN igs_as_grd_schema.grading_schema_cd%TYPE,
47: lp_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
48: lp_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
49: RETURN BOOLEAN IS
50: /*
51: || Created By : nmankodi
52: || Created On : 04-FEB-2002

Line 147: lp_teach_description IN igs_ca_inst_all.description%TYPE,

143:
144: PROCEDURE raise_business_event (
145: lp_internal_name IN VARCHAR2,
146: lp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
147: lp_teach_description IN igs_ca_inst_all.description%TYPE,
148: lp_load_description IN igs_ca_inst_all.description%TYPE,
149: lp_grading_period_start_dt IN DATE,
150: lp_grading_period_end_dt IN DATE,
151: lp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

Line 148: lp_load_description IN igs_ca_inst_all.description%TYPE,

144: PROCEDURE raise_business_event (
145: lp_internal_name IN VARCHAR2,
146: lp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
147: lp_teach_description IN igs_ca_inst_all.description%TYPE,
148: lp_load_description IN igs_ca_inst_all.description%TYPE,
149: lp_grading_period_start_dt IN DATE,
150: lp_grading_period_end_dt IN DATE,
151: lp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
152: lp_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,

Line 275: l_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

271: || Who When What
272: || swaghmar 16-Jan-2006 Bug# 4951054 - Check for disabling UI's
273: || (reverse chronological order - newest change first)
274: */
275: l_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
276: l_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
277:
278: CURSOR c_ttl
279: IS

Line 276: l_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

272: || swaghmar 16-Jan-2006 Bug# 4951054 - Check for disabling UI's
273: || (reverse chronological order - newest change first)
274: */
275: l_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
276: l_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
277:
278: CURSOR c_ttl
279: IS
280: SELECT ttl.teach_cal_type,

Line 285: igs_ca_inst ci,

281: ttl.teach_ci_sequence_number,
282: ttl.teach_description,
283: ttl.load_description
284: FROM igs_ca_teach_to_load_v ttl,
285: igs_ca_inst ci,
286: igs_ca_stat cs
287: WHERE ttl.load_cal_type = l_ld_cal_type
288: AND ttl.load_ci_sequence_number = l_ld_sequence_number
289: AND ttl.teach_cal_type = ci.cal_type

Line 295: CURSOR c_uoo (cp_teach_cal_type igs_ca_inst_all.cal_type%TYPE,cp_teach_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)

291: AND ci.cal_status = cs.cal_status
292: AND cs.s_cal_status = 'ACTIVE';
293:
294:
295: CURSOR c_uoo (cp_teach_cal_type igs_ca_inst_all.cal_type%TYPE,cp_teach_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
296: IS
297: SELECT uoo.uoo_id,
298: uoo.unit_cd,
299: uoo.unit_class,