APPS.IGS_CA_VAL_DAIOC dependencies on IGS_CA_DA_INST_OFCNT

Line 67: -- Validate that IGS_CA_DA_OFFCNT or IGS_CA_DA_INST_OFCNT records

63: p_message_name OUT NOCOPY VARCHAR2 )
64: RETURN BOOLEAN AS
65: gv_other_detail VARCHAR2(255);
66: BEGIN -- calp_val_sdoct_clash
67: -- Validate that IGS_CA_DA_OFFCNT or IGS_CA_DA_INST_OFCNT records
68: -- do not result in constraints that cannot be resolved. (eg. MUST BE MONDAY,
69: -- MUST BE WEDNESDAY).
70: -- Note that the primary keys prevent cases such as MUST BE MONDAY, MUST NOT
71: -- BE MONDAY from occurring.

Line 88: FROM IGS_CA_DA_INST_OFCNT daioc

84: CURSOR c_daioc IS
85: SELECT daioc.s_dt_offset_constraint_type,
86: daioc.constraint_condition,
87: daioc.constraint_resolution
88: FROM IGS_CA_DA_INST_OFCNT daioc
89: WHERE daioc.dt_alias = p_dt_alias AND
90: daioc.dai_sequence_number = p_dai_sequence_number AND
91: daioc.cal_type = p_cal_type AND
92: daioc.ci_sequence_number = p_ci_sequence_number AND

Line 304: -- function has been called from IGS_CA_DA_INST_OFCNT

300: NULL;
301: END IF;
302: END LOOP;
303: ELSE
304: -- function has been called from IGS_CA_DA_INST_OFCNT
305: FOR v_daioc_rec IN c_daioc LOOP
306: v_message_name := calpl_val_constraint(
307: p_s_dt_offset_constraint_type,
308: p_constraint_condition,

Line 352: IGS_CA_DA_INST_OFCNT daioc

348: v_daioc_exists VARCHAR2(1);
349: CURSOR c_daioc IS
350: SELECT 'X'
351: FROM IGS_CA_DA_INST_OFST daio,
352: IGS_CA_DA_INST_OFCNT daioc
353: WHERE daio.dt_alias = p_dt_alias AND
354: daio.dai_sequence_number = p_dai_sequence_number AND
355: daio.cal_type = p_cal_type AND
356: daio.ci_sequence_number = p_ci_sequence_number AND