eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_GEN_004 dependencies on IGS_GE_DATE

Line 248: RETURN IGS_GE_DATE.IGSCHAR(v_out_date); -- IGS_GE_DATE.IGSCHAR(v_out_date, 'DD/MM/YYYY');

244: v_aa_acaiv_rec.location_cd,
245: v_aa_acaiv_rec.attendance_mode,
246: v_aa_acaiv_rec.attendance_type);
247: IF v_out_date IS NOT NULL THEN
248: RETURN IGS_GE_DATE.IGSCHAR(v_out_date); -- IGS_GE_DATE.IGSCHAR(v_out_date, 'DD/MM/YYYY');
249: ELSE
250: RETURN NULL;
251: END IF;
252: EXCEPTION

Line 673: NVL(alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) >= v_context_completion_dt AND

669: SELECT dai.alias_val
670: FROM IGS_CA_DA_INST_V dai
671: WHERE dt_alias = v_comp_perd_dt_alias AND
672: cal_type = v_cal_type AND
673: NVL(alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) >= v_context_completion_dt AND
674: SUBSTR(IGS_GE_DATE.IGSCHAR(alias_val),1,4) >= p_expected_completion_yr
675: ORDER BY alias_val; -- Order is changed to Ascending. Bug :2647482
676:
677: CURSOR c_dai2 (

Line 674: SUBSTR(IGS_GE_DATE.IGSCHAR(alias_val),1,4) >= p_expected_completion_yr

670: FROM IGS_CA_DA_INST_V dai
671: WHERE dt_alias = v_comp_perd_dt_alias AND
672: cal_type = v_cal_type AND
673: NVL(alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) >= v_context_completion_dt AND
674: SUBSTR(IGS_GE_DATE.IGSCHAR(alias_val),1,4) >= p_expected_completion_yr
675: ORDER BY alias_val; -- Order is changed to Ascending. Bug :2647482
676:
677: CURSOR c_dai2 (
678: cp_adm_e_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE,

Line 690: NVL(alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) >= v_context_completion_dt --Replaced '<' with '>'. Bug: 2647482

686: NVL(cp_adm_m_perd_dt_alias, 'NONE'),
687: NVL(cp_adm_s_perd_dt_alias, 'NONE')
688: ) AND
689: cal_type = v_cal_type AND
690: NVL(alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) >= v_context_completion_dt --Replaced '<' with '>'. Bug: 2647482
691: ORDER BY alias_val; -- Order is changed to Ascending. Bug :2647482
692:
693: --Cursor to get the Program Length and Program Length Measurement for the Program Offering Option record. Bug:2647482
694: CURSOR c_get_prg_mesr_dtls(

Line 718: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

714: BEGIN
715:
716: --Check if there is adequate information to identify the Program Offering Option record. Enh Bug: 2647482
717: IF p_attendance_type IS NULL OR p_attendance_mode IS NULL OR p_location_cd IS NULL THEN
718: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
719: RETURN;
720: END IF;
721: --Check for adequate information to continue processing
722: IF (p_start_dt IS NULL AND

Line 725: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

721: --Check for adequate information to continue processing
722: IF (p_start_dt IS NULL AND
723: p_expected_completion_yr IS NULL AND
724: p_expected_completion_perd IS NULL) THEN
725: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
726: RETURN;
727: END IF;
728:
729: --Check that course start date is given, calculations cannot be

Line 732: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

728:
729: --Check that course start date is given, calculations cannot be
730: --determined without it
731: IF (p_start_dt IS NULL) THEN
732: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
733: RETURN;
734: ELSE
735: -- Determine course start date year
736: v_start_dt_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(p_start_dt),1,4);

Line 736: v_start_dt_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(p_start_dt),1,4);

732: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
733: RETURN;
734: ELSE
735: -- Determine course start date year
736: v_start_dt_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(p_start_dt),1,4);
737: END IF;
738:
739:
740: --Get academic calendar type if not specified or validate calendar type

Line 745: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

741: -- specified
742: OPEN c_co;
743: FETCH c_co INTO v_cal_type;
744: IF (c_co%NOTFOUND) THEN
745: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
746: CLOSE c_co;
747: RETURN;
748: END IF;
749: CLOSE c_co;

Line 769: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

765: v_rec_cnt := v_rec_cnt + 1;
766: END LOOP;
767:
768: IF ( v_cal_type IS NULL) THEN
769: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
770: RETURN;
771: END IF;
772:
773: --Check for existence of completion period date alias

Line 780: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

776: FETCH c_sacco INTO v_adm_e_perd_dt_alias,
777: v_adm_m_perd_dt_alias,
778: v_adm_s_perd_dt_alias;
779: IF (c_sacco%NOTFOUND) THEN
780: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
781: CLOSE c_sacco;
782: RETURN;
783: END IF;
784: CLOSE c_sacco;

Line 802: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

798: );
799:
800: FETCH c_get_prg_mesr_dtls INTO c_get_prg_mesr_dtls_rec;
801: IF c_get_prg_mesr_dtls%NOTFOUND THEN
802: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
803: CLOSE c_get_prg_mesr_dtls;
804: RETURN;
805: END IF;
806: CLOSE c_get_prg_mesr_dtls;

Line 827: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

823: v_completion_days := c_get_prg_mesr_dtls_rec.program_length/1440;
824: END IF;
825:
826: IF v_completion_days IS NULL THEN
827: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
828: RETURN;
829: END IF;
830:
831: --Add the Program Length (in Days) to the Program Start Date to get the Completion Date. Bug: 2647482

Line 851: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

847: v_comp_perd_dt_alias := v_adm_s_perd_dt_alias;
848: END IF;
849:
850: IF (v_comp_perd_dt_alias IS NULL) THEN
851: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
852: RETURN;
853: END IF;
854:
855: -- get completion date, which is the closest date greater than the context completion date and year part is greater than

Line 860: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

856: -- the Expected Completion Year. Bug : 2715535
857: OPEN c_dai;
858: FETCH c_dai INTO v_dai;
859: IF (c_dai%NOTFOUND) THEN
860: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
861: CLOSE c_dai;
862: RETURN;
863: END IF;
864: CLOSE c_dai;

Line 873: v_completion_dt_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(v_completion_dt),1,4); --IGSCHAR returns date in 'YYYY/MM/DD' format

869: RETURN;
870: END IF;
871:
872: -- Move completion date into context of course start date
873: v_completion_dt_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(v_completion_dt),1,4); --IGSCHAR returns date in 'YYYY/MM/DD' format
874:
875: --Determine expected completion details
876: OPEN c_dai2 ( v_adm_e_perd_dt_alias,
877: v_adm_m_perd_dt_alias,

Line 883: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);

879: FETCH c_dai2 INTO v_dai2_alias_val,
880: v_dai2_dt_alias;
881:
882: IF (c_dai2%NOTFOUND) THEN
883: p_completion_dt := IGS_GE_DATE.IGSDATE(NULL);
884: CLOSE c_dai2;
885: RETURN;
886: END IF;
887: CLOSE c_dai2;

Line 890: v_dai2_alias_val_dd_mon := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),5,10); --IGSCHAR returns date in 'YYYY/MM/DD' format

886: END IF;
887: CLOSE c_dai2;
888:
889: -- Only process the first record found because it's the nearest date greater than the Context Completion Date;
890: v_dai2_alias_val_dd_mon := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),5,10); --IGSCHAR returns date in 'YYYY/MM/DD' format
891:
892: v_dai2_alias_val_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),1,4); --IGSCHAR returns date in 'YYYY/MM/DD' format
893:
894: p_expected_completion_yr := IGS_GE_NUMBER.TO_NUM(v_dai2_alias_val_yyyy);

Line 892: v_dai2_alias_val_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),1,4); --IGSCHAR returns date in 'YYYY/MM/DD' format

888:
889: -- Only process the first record found because it's the nearest date greater than the Context Completion Date;
890: v_dai2_alias_val_dd_mon := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),5,10); --IGSCHAR returns date in 'YYYY/MM/DD' format
891:
892: v_dai2_alias_val_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),1,4); --IGSCHAR returns date in 'YYYY/MM/DD' format
893:
894: p_expected_completion_yr := IGS_GE_NUMBER.TO_NUM(v_dai2_alias_val_yyyy);
895:
896: p_completion_dt := IGS_GE_DATE.IGSDATE(IGS_GE_NUMBER.TO_CANN(p_expected_completion_yr)||v_dai2_alias_val_dd_mon);

Line 896: p_completion_dt := IGS_GE_DATE.IGSDATE(IGS_GE_NUMBER.TO_CANN(p_expected_completion_yr)||v_dai2_alias_val_dd_mon);

892: v_dai2_alias_val_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),1,4); --IGSCHAR returns date in 'YYYY/MM/DD' format
893:
894: p_expected_completion_yr := IGS_GE_NUMBER.TO_NUM(v_dai2_alias_val_yyyy);
895:
896: p_completion_dt := IGS_GE_DATE.IGSDATE(IGS_GE_NUMBER.TO_CANN(p_expected_completion_yr)||v_dai2_alias_val_dd_mon);
897:
898: --Return the Completion Period associated with the calculated Completion date alias instance.
899: IF (v_dai2_dt_alias = NVL(v_adm_e_perd_dt_alias, 'NONE')) THEN
900: p_expected_completion_perd := 'E';