APPS.IGS_CA_INST_PKG dependencies on IGS_CA_TYPE

Line 115: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT

111: -- CURSOR added to check uniqueness for alternate code for calendar categories
112: -- load , academic and teaching
113: CURSOR alt_code_unique IS
114: SELECT count(*)
115: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT
116: WHERE CAT.CAL_TYPE = CI.CAL_TYPE
117: AND CAT.S_CAL_CAT IN ('LOAD','TEACHING','ACADEMIC')
118: AND NEW_REFERENCES.ALTERNATE_CODE = CI.ALTERNATE_CODE
119: AND ((l_rowid IS NULL) OR (CI.ROW_ID <> l_rowid)) ;

Line 324: ELSIF NOT IGS_CA_TYPE_PKG.Get_PK_For_Validation (

320:
321: IF (((old_references.cal_type = new_references.cal_type)) OR
322: ((new_references.cal_type IS NULL))) THEN
323: NULL;
324: ELSIF NOT IGS_CA_TYPE_PKG.Get_PK_For_Validation (
325: new_references.cal_type
326: ) THEN
327: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
328: IGS_GE_MSG_STACK.ADD;

Line 849: PROCEDURE GET_FK_IGS_CA_TYPE (

845: END IF;
846:
847: END Get_UK2_For_Validation;
848:
849: PROCEDURE GET_FK_IGS_CA_TYPE (
850: x_cal_type IN VARCHAR2
851: ) AS
852:
853: CURSOR cur_rowid IS

Line 873: END GET_FK_IGS_CA_TYPE;

869: RETURN;
870: END IF;
871: CLOSE cur_rowid;
872:
873: END GET_FK_IGS_CA_TYPE;
874:
875: PROCEDURE GET_FK_IGS_CA_STAT (
876: x_cal_status IN VARCHAR2
877: ) AS

Line 1598: FROM igs_ca_type

1594: l_new_status igs_ca_stat.s_cal_status%TYPE;
1595:
1596: CURSOR c_cal_type (p_cal_type IN VARCHAR2) IS
1597: SELECT s_cal_cat
1598: FROM igs_ca_type
1599: WHERE cal_type = p_cal_type
1600: AND closed_ind = 'N';
1601:
1602: l_cal_type igs_ca_type.s_cal_cat%TYPE;

Line 1602: l_cal_type igs_ca_type.s_cal_cat%TYPE;

1598: FROM igs_ca_type
1599: WHERE cal_type = p_cal_type
1600: AND closed_ind = 'N';
1601:
1602: l_cal_type igs_ca_type.s_cal_cat%TYPE;
1603:
1604: BEGIN
1605: OPEN c_old_status(old_references.cal_status);
1606: FETCH c_old_status INTO l_old_status;