APPS.IGS_AD_PECRS_OFOP_DT_PKG dependencies on IGS_CA_INST

Line 86: v_cal_type IGS_CA_INST.cal_type%TYPE;

82: p_updating IN BOOLEAN ,
83: p_deleting IN BOOLEAN
84: ) AS
85: v_message_name VARCHAR2(30);
86: v_cal_type IGS_CA_INST.cal_type%TYPE;
87: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
88: v_start_dt IGS_CA_INST.start_dt%TYPE;
89: v_end_dt IGS_CA_INST.end_dt%TYPE;
90: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

Line 87: v_sequence_number IGS_CA_INST.sequence_number%TYPE;

83: p_deleting IN BOOLEAN
84: ) AS
85: v_message_name VARCHAR2(30);
86: v_cal_type IGS_CA_INST.cal_type%TYPE;
87: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
88: v_start_dt IGS_CA_INST.start_dt%TYPE;
89: v_end_dt IGS_CA_INST.end_dt%TYPE;
90: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
91: BEGIN

Line 88: v_start_dt IGS_CA_INST.start_dt%TYPE;

84: ) AS
85: v_message_name VARCHAR2(30);
86: v_cal_type IGS_CA_INST.cal_type%TYPE;
87: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
88: v_start_dt IGS_CA_INST.start_dt%TYPE;
89: v_end_dt IGS_CA_INST.end_dt%TYPE;
90: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
91: BEGIN
92: -- Validate that the admission period is not inactive

Line 89: v_end_dt IGS_CA_INST.end_dt%TYPE;

85: v_message_name VARCHAR2(30);
86: v_cal_type IGS_CA_INST.cal_type%TYPE;
87: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
88: v_start_dt IGS_CA_INST.start_dt%TYPE;
89: v_end_dt IGS_CA_INST.end_dt%TYPE;
90: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
91: BEGIN
92: -- Validate that the admission period is not inactive
93: IF p_inserting OR p_updating THEN

Line 90: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

86: v_cal_type IGS_CA_INST.cal_type%TYPE;
87: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
88: v_start_dt IGS_CA_INST.start_dt%TYPE;
89: v_end_dt IGS_CA_INST.end_dt%TYPE;
90: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
91: BEGIN
92: -- Validate that the admission period is not inactive
93: IF p_inserting OR p_updating THEN
94: v_cal_type := new_references.adm_cal_type;