APPS.IGS_AD_PERD_AD_CAT_PKG dependencies on IGS_CA_INST

Line 70: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

66: p_updating IN BOOLEAN DEFAULT FALSE,
67: p_deleting IN BOOLEAN DEFAULT FALSE
68: ) AS
69: v_message_name VARCHAR2(30);
70: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
71: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;
72: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
73: BEGIN
74: IF p_inserting THEN

Line 71: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;

67: p_deleting IN BOOLEAN DEFAULT FALSE
68: ) AS
69: v_message_name VARCHAR2(30);
70: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
71: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;
72: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
73: BEGIN
74: IF p_inserting THEN
75: -- Validate the admission calendar instance

Line 72: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;

68: ) AS
69: v_message_name VARCHAR2(30);
70: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
71: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;
72: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
73: BEGIN
74: IF p_inserting THEN
75: -- Validate the admission calendar instance
76: IF IGS_AD_VAL_APAC.admp_val_apac_ci(

Line 163: IF NOT IGS_CA_INST_PKG.Get_UK_For_Validation (

159: (new_references.ci_end_dt IS NULL))) THEN
160: NULL;
161:
162: ELSE
163: IF NOT IGS_CA_INST_PKG.Get_UK_For_Validation (
164: new_references.adm_cal_type,
165: new_references.adm_ci_sequence_number,
166: new_references.ci_start_dt,
167: new_references.ci_end_dt

Line 248: PROCEDURE GET_UFK_IGS_CA_INST (

244: Close cur_rowid;
245:
246: END GET_FK_IGS_AD_CAT;
247:
248: PROCEDURE GET_UFK_IGS_CA_INST (
249: x_cal_type IN VARCHAR2,
250: x_sequence_number IN NUMBER,
251: x_start_dt IN DATE,
252: x_end_dt IN DATE

Line 278: END GET_UFK_IGS_CA_INST;

274: Return;
275: END IF;
276: Close cur_rowid;
277:
278: END GET_UFK_IGS_CA_INST;
279:
280: PROCEDURE Before_DML (
281: p_action IN VARCHAR2,
282: x_rowid IN VARCHAR2 DEFAULT NULL,