APPS.IGS_AD_GEN_007 dependencies on IGS_GE_NUMBER

Line 29: v_dd_mm_yyyy := IGS_GE_NUMBER.TO_NUM(p_birth_dt);

25: -- Set the default message number
26: p_message_name := null;
27: -- Check the parameter birthday in correct format.
28: BEGIN
29: v_dd_mm_yyyy := IGS_GE_NUMBER.TO_NUM(p_birth_dt);
30: IF v_dd_mm_yyyy <= 0 THEN
31: p_message_name := 'IGS_AD_BIRTHDT_INCORRECT_DATA';
32: RETURN 0;
33: END IF;

Line 34: v_dd_mm_yyyy := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_birth_dt,1,2));

30: IF v_dd_mm_yyyy <= 0 THEN
31: p_message_name := 'IGS_AD_BIRTHDT_INCORRECT_DATA';
32: RETURN 0;
33: END IF;
34: v_dd_mm_yyyy := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_birth_dt,1,2));
35: IF (v_dd_mm_yyyy > 31) THEN
36: p_message_name := 'IGS_AD_BIRTHDT_INCORRECT_DATA';
37: RETURN 0;
38: END IF;

Line 39: v_dd_mm_yyyy := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_birth_dt,3,2));

35: IF (v_dd_mm_yyyy > 31) THEN
36: p_message_name := 'IGS_AD_BIRTHDT_INCORRECT_DATA';
37: RETURN 0;
38: END IF;
39: v_dd_mm_yyyy := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_birth_dt,3,2));
40: IF (v_dd_mm_yyyy > 12) THEN
41: p_message_name := 'IGS_AD_BIRTHDT_INCORRECT_DATA';
42: RETURN 0;
43: END IF;

Line 44: v_dd_mm_yyyy := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_birth_dt,5,4));

40: IF (v_dd_mm_yyyy > 12) THEN
41: p_message_name := 'IGS_AD_BIRTHDT_INCORRECT_DATA';
42: RETURN 0;
43: END IF;
44: v_dd_mm_yyyy := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_birth_dt,5,4));
45: IF (v_dd_mm_yyyy <= 1900) THEN
46: p_message_name := 'IGS_AD_BIRTHDT_INCORRECT_DATA';
47: RETURN 0;
48: END IF;