APPS.IGS_CA_VAL_DAIOC dependencies on IGS_CA_DA_OFFCNT

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 80: FROM IGS_CA_DA_OFFCNT daoc

76: CURSOR c_daoc IS
77: SELECT daoc.s_dt_offset_constraint_type,
78: daoc.constraint_condition,
79: daoc.constraint_resolution
80: FROM IGS_CA_DA_OFFCNT daoc
81: WHERE daoc.dt_alias = p_dt_alias AND
82: daoc.offset_dt_alias = p_offset_dt_alias AND
83: daoc.s_dt_offset_constraint_type <> p_s_dt_offset_constraint_type;
84: CURSOR c_daioc IS

Line 100: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,

96: daioc.offset_ci_sequence_number = p_offset_ci_sequence_number AND
97: daioc.s_dt_offset_constraint_type <> p_s_dt_offset_constraint_type;
98: FUNCTION calpl_val_constraint (
99: p_s_dt_offset_constraint_type
100: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,
101: p_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
102: p_db_s_dt_offset_cstrnt_type
103: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,
104: p_db_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,

Line 101: p_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,

97: daioc.s_dt_offset_constraint_type <> p_s_dt_offset_constraint_type;
98: FUNCTION calpl_val_constraint (
99: p_s_dt_offset_constraint_type
100: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,
101: p_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
102: p_db_s_dt_offset_cstrnt_type
103: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,
104: p_db_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
105: p_db_constraint_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE)

Line 103: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,

99: p_s_dt_offset_constraint_type
100: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,
101: p_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
102: p_db_s_dt_offset_cstrnt_type
103: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,
104: p_db_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
105: p_db_constraint_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE)
106: RETURN VARCHAR2
107: AS

Line 104: p_db_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,

100: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,
101: p_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
102: p_db_s_dt_offset_cstrnt_type
103: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,
104: p_db_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
105: p_db_constraint_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE)
106: RETURN VARCHAR2
107: AS
108: BEGIN

Line 105: p_db_constraint_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE)

101: p_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
102: p_db_s_dt_offset_cstrnt_type
103: IGS_CA_DA_OFFCNT.s_dt_offset_constraint_type%TYPE,
104: p_db_constraint_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
105: p_db_constraint_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE)
106: RETURN VARCHAR2
107: AS
108: BEGIN
109: DECLARE

Line 283: -- function has been called from IGS_CA_DA_OFFCNT

279: -- 3. Use a loop to select each existing constraint record and determine if
280: -- the current s_dt_offset_constraint_type clashes with an existing
281: -- s_dt_offset_constraint_type for the same dt_alias/offset_dt_alias.
282: IF p_cal_type IS NULL THEN
283: -- function has been called from IGS_CA_DA_OFFCNT
284: FOR v_daoc_rec IN c_daoc LOOP
285: v_message_name := calpl_val_constraint(
286: p_s_dt_offset_constraint_type,
287: p_constraint_condition,