APPS.IGS_AS_UNITASS_ITEM_PKG dependencies on IGS_CA_INST

Line 223: cp_cal_type igs_ca_inst.cal_type%TYPE,

219: p_updating IN BOOLEAN DEFAULT FALSE,
220: p_deleting IN BOOLEAN DEFAULT FALSE
221: ) AS
222: CURSOR c_ci (
223: cp_cal_type igs_ca_inst.cal_type%TYPE,
224: cp_seq_number igs_ca_inst.sequence_number%TYPE
225: ) IS
226: SELECT start_dt,
227: end_dt

Line 224: cp_seq_number igs_ca_inst.sequence_number%TYPE

220: p_deleting IN BOOLEAN DEFAULT FALSE
221: ) AS
222: CURSOR c_ci (
223: cp_cal_type igs_ca_inst.cal_type%TYPE,
224: cp_seq_number igs_ca_inst.sequence_number%TYPE
225: ) IS
226: SELECT start_dt,
227: end_dt
228: FROM igs_ca_inst

Line 228: FROM igs_ca_inst

224: cp_seq_number igs_ca_inst.sequence_number%TYPE
225: ) IS
226: SELECT start_dt,
227: end_dt
228: FROM igs_ca_inst
229: WHERE cal_type = cp_cal_type
230: AND sequence_number = cp_seq_number;
231: BEGIN
232: IF p_inserting THEN

Line 375: IF NOT (igs_ca_inst_pkg.get_pk_for_validation (

371: )
372: ) THEN
373: NULL;
374: ELSE
375: IF NOT (igs_ca_inst_pkg.get_pk_for_validation (
376: new_references.exam_cal_type,
377: new_references.exam_ci_sequence_number
378: )
379: ) THEN

Line 648: PROCEDURE get_fk_igs_ca_inst (

644: END IF;
645: CLOSE cur_rowid;
646: END get_fk_igs_as_grd_schema;
647:
648: PROCEDURE get_fk_igs_ca_inst (
649: x_cal_type IN VARCHAR2,
650: x_sequence_number IN NUMBER
651: ) AS
652: CURSOR cur_rowid IS

Line 669: END get_fk_igs_ca_inst;

665: app_exception.raise_exception;
666: RETURN;
667: END IF;
668: CLOSE cur_rowid;
669: END get_fk_igs_ca_inst;
670: --
671: -- Obsoleted as part of Grade Book build
672: --
673: PROCEDURE get_fk_igs_ad_location (x_location_cd IN VARCHAR2) AS