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_ST_GEN_003 dependencies on IGS_GE_DATE

Line 544: v_submission_1_census_dt := IGS_GE_DATE.igsdate(TO_CHAR(p_SUBMISSION_YR)||'03/31');

540: IF (p_enrolled_dt IS NULL) THEN
541: RETURN 'N';
542: END IF;
543: -- define the submission census dates
544: v_submission_1_census_dt := IGS_GE_DATE.igsdate(TO_CHAR(p_SUBMISSION_YR)||'03/31');
545: v_submission_2_census_dt := IGS_GE_DATE.igsdate(TO_CHAR(p_SUBMISSION_YR)||'08/31');
546: -- get the Government Semester
547: IF (p_govt_semester IS NULL) THEN
548: v_govt_semester := IGS_ST_GEN_002.stap_get_govt_sem(

Line 545: v_submission_2_census_dt := IGS_GE_DATE.igsdate(TO_CHAR(p_SUBMISSION_YR)||'08/31');

541: RETURN 'N';
542: END IF;
543: -- define the submission census dates
544: v_submission_1_census_dt := IGS_GE_DATE.igsdate(TO_CHAR(p_SUBMISSION_YR)||'03/31');
545: v_submission_2_census_dt := IGS_GE_DATE.igsdate(TO_CHAR(p_SUBMISSION_YR)||'08/31');
546: -- get the Government Semester
547: IF (p_govt_semester IS NULL) THEN
548: v_govt_semester := IGS_ST_GEN_002.stap_get_govt_sem(
549: p_submission_yr,

Line 587: IGS_GE_DATE.igsdate('9999/01/01'));

583: END IF;
584: -- set the v_discontinued_dt to p_discontinued_dt
585: -- set the value to a late date if not set
586: v_discontinued_dt := NVL(p_discontinued_dt,
587: IGS_GE_DATE.igsdate('9999/01/01'));
588: -- determine if the unit should be reported in the
589: -- specified submission
590: -- Government semester 1
591: IF (v_govt_semester = 1) THEN

Line 935: ', creation_dt-' || IGS_GE_DATE.igschardt(p_creation_dt);

931: --Check if an entry has been written to the error log
932: IF p_logged_ind = FALSE THEN
933: v_other_detail := 'Check the system log:' ||
934: ' s_log_type-' || p_s_log_type ||
935: ', creation_dt-' || IGS_GE_DATE.igschardt(p_creation_dt);
936: -- set that an error has been logged
937: p_logged_ind := TRUE;
938: END IF;
939: --Create an entry in the system log entry

Line 984: ', creation_dt-' || IGS_GE_DATE.igschardt(p_creation_dt);

980: --Check if an entry has been written to the error log
981: IF p_logged_ind = FALSE THEN
982: v_other_detail := 'Check the system log:' ||
983: ' s_log_type-' || p_s_log_type ||
984: ', creation_dt-' || IGS_GE_DATE.igschardt(p_creation_dt);
985: -- set that an error has been logged
986: p_logged_ind := TRUE;
987: END IF;
988: --Create an entry in the system log entry

Line 1032: ', creation_dt-' || IGS_GE_DATE.igschardt(p_creation_dt);

1028: --Check if an entry has been written to the error log
1029: IF p_logged_ind = FALSE THEN
1030: v_other_detail := 'Check the system log:' ||
1031: ' s_log_type-' || p_s_log_type ||
1032: ', creation_dt-' || IGS_GE_DATE.igschardt(p_creation_dt);
1033: -- set that an error has been logged
1034: p_logged_ind := TRUE;
1035: END IF;
1036: --Create an entry in the system log entry