APPS.IGS_EN_VAL_AUS dependencies on IGS_EN_DISC_DL_CONS

Line 61: -- Validate that IGS_EN_DISC_DL_CONS records

57: p_message_name OUT NOCOPY VARCHAR2 )
58: RETURN BOOLEAN AS
59: gv_other_detail VARCHAR2(255);
60: BEGIN -- calp_val_sdoct_clash
61: -- Validate that IGS_EN_DISC_DL_CONS records
62: -- do not result in constraints that cannot be resolved. (eg. MUST BE MONDAY,
63: -- MUST BE WEDNESDAY).
64: -- Note that the primary keys prevent cases such as MUST BE MONDAY, MUST NOT
65: -- BE MONDAY from occurring.

Line 74: FROM IGS_EN_DISC_DL_CONS ddcv

70: CURSOR c_ddcv IS
71: SELECT ddcv.offset_cons_type_cd,
72: ddcv.constraint_condition,
73: ddcv.constraint_resolution
74: FROM IGS_EN_DISC_DL_CONS ddcv
75: WHERE ddcv.offset_cons_type_cd <>p_offset_cons_type_cd AND
76:
77: ddcv.non_std_disc_dl_stp_id = p_non_std_disc_dl_stp_id;
78:

Line 81: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,

77: ddcv.non_std_disc_dl_stp_id = p_non_std_disc_dl_stp_id;
78:
79: FUNCTION calpl_val_constraint (
80: p_offset_cons_type_cd
81: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,
82: p_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,
83: p_db_offset_cons_type_cd
84: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,
85: p_db_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,

Line 82: p_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,

78:
79: FUNCTION calpl_val_constraint (
80: p_offset_cons_type_cd
81: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,
82: p_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,
83: p_db_offset_cons_type_cd
84: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,
85: p_db_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,
86: p_db_constraint_resolution IGS_EN_DISC_DL_CONS.constraint_resolution%TYPE)

Line 84: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,

80: p_offset_cons_type_cd
81: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,
82: p_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,
83: p_db_offset_cons_type_cd
84: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,
85: p_db_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,
86: p_db_constraint_resolution IGS_EN_DISC_DL_CONS.constraint_resolution%TYPE)
87: RETURN VARCHAR2
88: AS

Line 85: p_db_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,

81: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,
82: p_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,
83: p_db_offset_cons_type_cd
84: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,
85: p_db_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,
86: p_db_constraint_resolution IGS_EN_DISC_DL_CONS.constraint_resolution%TYPE)
87: RETURN VARCHAR2
88: AS
89: BEGIN

Line 86: p_db_constraint_resolution IGS_EN_DISC_DL_CONS.constraint_resolution%TYPE)

82: p_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,
83: p_db_offset_cons_type_cd
84: IGS_EN_DISC_DL_CONS.offset_cons_type_cd%TYPE,
85: p_db_constraint_condition IGS_EN_DISC_DL_CONS.constraint_condition%TYPE,
86: p_db_constraint_resolution IGS_EN_DISC_DL_CONS.constraint_resolution%TYPE)
87: RETURN VARCHAR2
88: AS
89: BEGIN
90: DECLARE