APPS.IGS_EN_SVS_AUTH_CAL_PKG dependencies on IGS_CA_INST

Line 106: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (

102: (old_references.ci_sequence_number = new_references.ci_sequence_number)) OR
103: ((new_references.cal_type is null) OR
104: (new_references.ci_sequence_number is null))) THEN
105: NULL;
106: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
107: new_references.cal_type,
108: new_references.ci_sequence_number
109: ) THEN
110: fnd_message.set_name ('FND','FORM_RECORD_DELETED');

Line 194: PROCEDURE get_fk_igs_ca_inst (

190:
191: END get_fk_igs_en_svs_auth;
192:
193:
194: PROCEDURE get_fk_igs_ca_inst (
195: x_cal_type IN VARCHAR2,
196: x_ci_sequence_number IN NUMBER
197: ) AS
198: CURSOR cur_rowid IS

Line 216: END get_fk_igs_ca_inst;

212: App_Exception.Raise_Exception;
213: RETURN;
214: END IF;
215: CLOSE cur_rowid;
216: END get_fk_igs_ca_inst;
217:
218: PROCEDURE beforedelete1(
219: x_sevis_auth_id IN NUMBER,
220: x_cal_type IN VARCHAR2,

Line 420: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

416: WHERE sevis_auth_id = x_sevis_auth_id;
417:
418:
419: CURSOR c_ovr_step (cp_person_id hz_parties.party_id%TYPE,
420: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
421: cp_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE)IS
422: SELECT STEP_OVERRIDE_TYPE, STEP_OVERRIDE_LIMIT
423: FROM IGS_EN_ELGB_OVR_STEP eos, IGS_EN_ELGB_OVR eo
424: WHERE eo.elgb_override_id = eos.elgb_override_id

Line 421: cp_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE)IS

417:
418:
419: CURSOR c_ovr_step (cp_person_id hz_parties.party_id%TYPE,
420: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
421: cp_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE)IS
422: SELECT STEP_OVERRIDE_TYPE, STEP_OVERRIDE_LIMIT
423: FROM IGS_EN_ELGB_OVR_STEP eos, IGS_EN_ELGB_OVR eo
424: WHERE eo.elgb_override_id = eos.elgb_override_id
425: AND eo.person_id = cp_person_id

Line 432: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

428: AND STEP_OVERRIDE_TYPE IN ('FMIN_CRDT','FATD_TYPE')
429: ORDER BY eos.CREATION_DATE ASC;
430:
431:
432: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
433: l_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
434: l_person_id hz_parties.party_id%TYPE;
435: l_elgb_override_id igs_en_elgb_ovr.elgb_override_id%TYPE;
436: l_step IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE;

Line 433: l_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

429: ORDER BY eos.CREATION_DATE ASC;
430:
431:
432: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
433: l_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
434: l_person_id hz_parties.party_id%TYPE;
435: l_elgb_override_id igs_en_elgb_ovr.elgb_override_id%TYPE;
436: l_step IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE;
437: l_limit IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_LIMIT%TYPE;