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_GRD_DATA_LOAD dependencies on IGS_GE_NUMBER

Line 92: p_acad_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_acad_perd, 112, 6)));

88: retcode := 0;
89:
90: -- extract academic calendar
91: p_acad_cal_type := RTRIM(SUBSTR(p_acad_perd, 101, 10));
92: p_acad_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_acad_perd, 112, 6)));
93:
94: -- extract admission calendar
95: p_adm_cal_type := RTRIM(SUBSTR(p_adm_perd, 101, 10));
96: p_adm_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_adm_perd, 112, 6)));

Line 96: p_adm_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_adm_perd, 112, 6)));

92: p_acad_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_acad_perd, 112, 6)));
93:
94: -- extract admission calendar
95: p_adm_cal_type := RTRIM(SUBSTR(p_adm_perd, 101, 10));
96: p_adm_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_adm_perd, 112, 6)));
97:
98:
99: IF (IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
100: p_acad_cal_type,

Line 719: result_yr := IGS_GE_NUMBER.TO_NUM(vtac_s_result_year);

715: -- Only insert aus scn edu if the result year is known
716:
717: IF vtac_s_result_year IS NOT NULL THEN
718:
719: result_yr := IGS_GE_NUMBER.TO_NUM(vtac_s_result_year);
720: vtac_s_ter := RTRIM(SUBSTR(G_vtac_output_buffer,497,5));
721: score := IGS_GE_NUMBER.TO_NUM(vtac_s_ter);
722:
723: IF score = 0 THEN

Line 721: score := IGS_GE_NUMBER.TO_NUM(vtac_s_ter);

717: IF vtac_s_result_year IS NOT NULL THEN
718:
719: result_yr := IGS_GE_NUMBER.TO_NUM(vtac_s_result_year);
720: vtac_s_ter := RTRIM(SUBSTR(G_vtac_output_buffer,497,5));
721: score := IGS_GE_NUMBER.TO_NUM(vtac_s_ter);
722:
723: IF score = 0 THEN
724: vtac_s_est_ter := RTRIM(SUBSTR(G_vtac_output_buffer,502,5));
725: score := IGS_GE_NUMBER.TO_NUM(vtac_s_est_ter);

Line 725: score := IGS_GE_NUMBER.TO_NUM(vtac_s_est_ter);

721: score := IGS_GE_NUMBER.TO_NUM(vtac_s_ter);
722:
723: IF score = 0 THEN
724: vtac_s_est_ter := RTRIM(SUBSTR(G_vtac_output_buffer,502,5));
725: score := IGS_GE_NUMBER.TO_NUM(vtac_s_est_ter);
726: END IF;
727:
728: IF score = 0 THEN
729: vtac_s_factor_ter := RTRIM(SUBSTR(G_vtac_output_buffer,507,5));

Line 730: score := IGS_GE_NUMBER.TO_NUM(vtac_s_factor_ter);

726: END IF;
727:
728: IF score = 0 THEN
729: vtac_s_factor_ter := RTRIM(SUBSTR(G_vtac_output_buffer,507,5));
730: score := IGS_GE_NUMBER.TO_NUM(vtac_s_factor_ter);
731: END IF;
732:
733: score := score/100;
734:

Line 757: study_cnt := IGS_GE_NUMBER.TO_NUM(vtac_study_count);

753:
754: --Load the secondary education subjects if any exist.
755:
756: vtac_study_count := RTRIM(SUBSTR(G_vtac_output_buffer,1048,2));
757: study_cnt := IGS_GE_NUMBER.TO_NUM(vtac_study_count);
758:
759: IF study_cnt > 0 THEN
760:
761: --Transfer the secondary education subjects data form the VTAC file to the

Line 781: sub_result_yr := IGS_GE_NUMBER.TO_NUM(vtac_result_year);

777: -- Do not process this record, go to end of the while loop
778: GOTO sec_edu_loop;
779: END IF;
780:
781: sub_result_yr := IGS_GE_NUMBER.TO_NUM(vtac_result_year);
782:
783: -- Work out NOCOPY mark from possible mark fields
784:
785: vtac_gl_score := RTRIM(SUBSTR(sec_edu_str(k),8,2));

Line 827: ||IGS_GE_NUMBER.TO_CANN(sub_result_yr) ;

823: ||' '||vtac_state_name||' '||vtac_subject_code);
824: END IF;
825: ELSE
826: G_message_str := FND_MESSAGE.GET_STRING('IGS','IGS_GE_DUPLICATE_VALUE')||'-'
827: ||IGS_GE_NUMBER.TO_CANN(sub_result_yr) ;
828: FND_FILE.PUT_LINE( FND_FILE.LOG,RTRIM(G_message_str) ||'-'||G_current_person_id
829: ||'-'||vtac_state_name||'-'||vtac_subject_code);
830:
831: END IF; -- End of if c_dup_chk%NOTFOUND

Line 933: start_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_started);

929:
930: vtac_post_sec_started := RTRIM(SUBSTR(po_sec_str(k),1,4));
931: vtac_post_sec_completed := RTRIM(SUBSTR(po_sec_str(k),5,4));
932:
933: start_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_started);
934: end_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_completed);
935:
936: IF start_yr > 50 THEN
937: start_yr := start_yr + 1900;

Line 934: end_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_completed);

930: vtac_post_sec_started := RTRIM(SUBSTR(po_sec_str(k),1,4));
931: vtac_post_sec_completed := RTRIM(SUBSTR(po_sec_str(k),5,4));
932:
933: start_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_started);
934: end_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_completed);
935:
936: IF start_yr > 50 THEN
937: start_yr := start_yr + 1900;
938: ELSE

Line 951: gpa := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_gpa)/100;

947:
948: -- Get the GPA in a format we can use. It needs 2 decimal places
949:
950: vtac_post_sec_gpa := RTRIM(SUBSTR(po_sec_str(k),38,3));
951: gpa := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_gpa)/100;
952:
953: vtac_post_sec_student_id := RTRIM(SUBSTR(po_sec_str(k),27,10));
954: vtac_post_sec_inst_code := RTRIM(SUBSTR(po_sec_str(k),11,4));
955: vtac_post_sec_inst_name := RTRIM(SUBSTR(po_sec_str(k),15,12));

Line 1030: start_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_syear_ov);

1026:
1027: vtac_post_sec_syear_ov := RTRIM(SUBSTR(po_sec_ov_str(k),1,4));
1028: vtac_post_sec_cyear_ov := RTRIM(SUBSTR(po_sec_ov_str(k),5,4));
1029:
1030: start_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_syear_ov);
1031: end_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_cyear_ov);
1032:
1033: IF start_yr > 50 THEN
1034: start_yr := start_yr + 1900;

Line 1031: end_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_cyear_ov);

1027: vtac_post_sec_syear_ov := RTRIM(SUBSTR(po_sec_ov_str(k),1,4));
1028: vtac_post_sec_cyear_ov := RTRIM(SUBSTR(po_sec_ov_str(k),5,4));
1029:
1030: start_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_syear_ov);
1031: end_yr := IGS_GE_NUMBER.TO_NUM(vtac_post_sec_cyear_ov);
1032:
1033: IF start_yr > 50 THEN
1034: start_yr := start_yr + 1900;
1035: ELSE