APPS.IGS_EN_VAL_AUS dependencies on IGS_EN_DL_OFFSET_CONS

Line 318: -- Validate that IGS_EN_DL_OFFSET_CONS records

314: p_message_name OUT NOCOPY VARCHAR2 )
315: RETURN BOOLEAN AS
316: gv_other_detail VARCHAR2(255);
317: BEGIN -- calp_val_sdoct_clash
318: -- Validate that IGS_EN_DL_OFFSET_CONS records
319: -- do not result in constraints that cannot be resolved. (eg. MUST BE MONDAY,
320: -- MUST BE WEDNESDAY).
321: -- Note that the primary keys prevent cases such as MUST BE MONDAY, MUST NOT
322: -- BE MONDAY from occurring.

Line 333: FROM IGS_EN_DL_OFFSET_CONS doscv

329: cp_c_deadline_type in varchar2)IS
330: SELECT doscv.offset_cons_type_cd,
331: doscv.constraint_condition,
332: doscv.constraint_resolution
333: FROM IGS_EN_DL_OFFSET_CONS doscv
334: WHERE doscv.offset_cons_type_cd <> cp_c_offset_cons_type_cd AND
335: doscv.non_std_usec_dls_id = cp_n_non_std_usec_dls_id AND
336: doscv.deadline_type = cp_c_deadline_type;
337:

Line 340: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,

336: doscv.deadline_type = cp_c_deadline_type;
337:
338: FUNCTION calpl_val_constraint (
339: p_offset_cons_type_cd
340: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,
341: p_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
342: p_db_offset_cons_type_cd
343: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,
344: p_db_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,

Line 341: p_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,

337:
338: FUNCTION calpl_val_constraint (
339: p_offset_cons_type_cd
340: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,
341: p_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
342: p_db_offset_cons_type_cd
343: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,
344: p_db_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
345: p_db_constraint_resolution IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE)

Line 343: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,

339: p_offset_cons_type_cd
340: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,
341: p_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
342: p_db_offset_cons_type_cd
343: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,
344: p_db_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
345: p_db_constraint_resolution IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE)
346: RETURN VARCHAR2
347: AS

Line 344: p_db_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,

340: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,
341: p_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
342: p_db_offset_cons_type_cd
343: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,
344: p_db_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
345: p_db_constraint_resolution IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE)
346: RETURN VARCHAR2
347: AS
348: BEGIN

Line 345: p_db_constraint_resolution IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE)

341: p_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
342: p_db_offset_cons_type_cd
343: IGS_EN_DL_OFFSET_CONS.offset_cons_type_cd%TYPE,
344: p_db_constraint_condition IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
345: p_db_constraint_resolution IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE)
346: RETURN VARCHAR2
347: AS
348: BEGIN
349: DECLARE