APPS.IGS_EN_VAL_SCHO dependencies on IGS_GE_DATE

Line 1947: IF TO_NUMBER(substr(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4)) -

1943: cst_no_arrival, -- '01'
1944: cst_arrival_prior_1903, -- '02'
1945: cst_arrival_no_info, -- 'A8'
1946: cst_no_info_aust) THEN -- 'A9'
1947: IF TO_NUMBER(substr(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4)) -
1948: TO_NUMBER(p_yr_arrival) < 3 THEN
1949: p_message_name := 'IGS_EN_STUD_GOVT_VAL3';
1950: p_return_type := cst_warn;
1951: RETURN FALSE;

Line 3149: lv_collection_yr := TO_NUMBER(substr(IGS_GE_DATE.IGSCHAR(p_collection_yr),1,4));

3145: SELECT 'x'
3146: FROM IGS_PE_COUNTRY_CD cnc
3147: WHERE cnc.country_cd = lp_term_location_country;
3148: BEGIN
3149: lv_collection_yr := TO_NUMBER(substr(IGS_GE_DATE.IGSCHAR(p_collection_yr),1,4));
3150: IF lp_govt_citizenship_cd = cst_citizen_nz THEN
3151: IF lp_commencement_dt IS NOT NULL THEN
3152: -- perform validations that are dependent on the course commencement date
3153: IF lp_commencement_dt >= IGS_GE_DATE.IGSDATE('1996/01/01') THEN

Line 3153: IF lp_commencement_dt >= IGS_GE_DATE.IGSDATE('1996/01/01') THEN

3149: lv_collection_yr := TO_NUMBER(substr(IGS_GE_DATE.IGSCHAR(p_collection_yr),1,4));
3150: IF lp_govt_citizenship_cd = cst_citizen_nz THEN
3151: IF lp_commencement_dt IS NOT NULL THEN
3152: -- perform validations that are dependent on the course commencement date
3153: IF lp_commencement_dt >= IGS_GE_DATE.IGSDATE('1996/01/01') THEN
3154: -- DEET validation 1676
3155: -- HECS payment option must not be deferred or upfront with discount
3156: IF lp_govt_hecs_payment_option IN (
3157: cst_hecs_deferred,

Line 3201: IGS_GE_DATE.IGSDATE(lv_collection_yr_less1_str) THEN

3197: END IF;
3198: END IF;
3199: IF p_collection_yr IS NOT NULL AND
3200: lp_commencement_dt <
3201: IGS_GE_DATE.IGSDATE(lv_collection_yr_less1_str) THEN
3202: -- Perform validations that are dependent on the year of arrival
3203: IF lp_yr_arrival IS NOT NULL AND
3204: lp_yr_arrival NOT IN (
3205: cst_off_shore,