DBA Data[Home] [Help]

APPS.IGS_TR_VAL_TRI dependencies on IGS_GE_DATE

Line 28: p_message_name := 'IGS_GE_DATE_IS_IN_WEEKEND';

24: v_day := RTRIM(TO_CHAR(p_date,'d'));
25: IF(p_weekend_ind = 'N' ) THEN
26: -- kdande --
27: IF(v_day = '7' OR v_day = '1') THEN
28: p_message_name := 'IGS_GE_DATE_IS_IN_WEEKEND';
29: RETURN FALSE;
30: END IF;
31: END IF;
32: RETURN TRUE;

Line 168: cst_min_dt CONSTANT DATE := igs_ge_date.igsdate ('1950/01/01');

164: BEGIN
165: DECLARE
166:
167: v_other_detail VARCHAR(255);
168: cst_min_dt CONSTANT DATE := igs_ge_date.igsdate ('1950/01/01');
169: cst_max_dt CONSTANT DATE := igs_ge_date.igsdate ('9999/01/01');
170: lv_param_values VARCHAR2(1080);
171:
172: BEGIN

Line 169: cst_max_dt CONSTANT DATE := igs_ge_date.igsdate ('9999/01/01');

165: DECLARE
166:
167: v_other_detail VARCHAR(255);
168: cst_min_dt CONSTANT DATE := igs_ge_date.igsdate ('1950/01/01');
169: cst_max_dt CONSTANT DATE := igs_ge_date.igsdate ('9999/01/01');
170: lv_param_values VARCHAR2(1080);
171:
172: BEGIN
173: