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.

[Home] [Help]

APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_TEST_SEGS_INT

Line 471: l_test_segment_id igs_ad_test_segs_int.test_segment_id%type;

467: l_Interface_Id_exist igs_ad_interface_all.Interface_Id%type;
468: l_High_School_Code igs_Ad_Act_Assessments.High_School_Code%type;
469: l_High_School_Graduation igs_Ad_Act_Assessments.High_School_Graduation%type;
470:
471: l_test_segment_id igs_ad_test_segs_int.test_segment_id%type;
472: l_test_score igs_ad_test_segs_int.test_score%type;
473: l_national_percentile igs_ad_act_statistics.national_norm%type;
474: l_state_percentile igs_ad_act_statistics.local_norm%type;
475: l_score_band_upper igs_ad_test_segs_int.score_band_upper%type;

Line 472: l_test_score igs_ad_test_segs_int.test_score%type;

468: l_High_School_Code igs_Ad_Act_Assessments.High_School_Code%type;
469: l_High_School_Graduation igs_Ad_Act_Assessments.High_School_Graduation%type;
470:
471: l_test_segment_id igs_ad_test_segs_int.test_segment_id%type;
472: l_test_score igs_ad_test_segs_int.test_score%type;
473: l_national_percentile igs_ad_act_statistics.national_norm%type;
474: l_state_percentile igs_ad_act_statistics.local_norm%type;
475: l_score_band_upper igs_ad_test_segs_int.score_band_upper%type;
476: l_score_band_lower igs_ad_test_segs_int.score_band_lower%type;

Line 475: l_score_band_upper igs_ad_test_segs_int.score_band_upper%type;

471: l_test_segment_id igs_ad_test_segs_int.test_segment_id%type;
472: l_test_score igs_ad_test_segs_int.test_score%type;
473: l_national_percentile igs_ad_act_statistics.national_norm%type;
474: l_state_percentile igs_ad_act_statistics.local_norm%type;
475: l_score_band_upper igs_ad_test_segs_int.score_band_upper%type;
476: l_score_band_lower igs_ad_test_segs_int.score_band_lower%type;
477: l_grade VARCHAR2(10);
478: l_Statistic_Category_desc igs_lookup_values.MEANING%type;
479:

Line 476: l_score_band_lower igs_ad_test_segs_int.score_band_lower%type;

472: l_test_score igs_ad_test_segs_int.test_score%type;
473: l_national_percentile igs_ad_act_statistics.national_norm%type;
474: l_state_percentile igs_ad_act_statistics.local_norm%type;
475: l_score_band_upper igs_ad_test_segs_int.score_band_upper%type;
476: l_score_band_lower igs_ad_test_segs_int.score_band_lower%type;
477: l_grade VARCHAR2(10);
478: l_Statistic_Category_desc igs_lookup_values.MEANING%type;
479:
480: BEGIN /* Main */

Line 546: ------> IGS_AD_TEST_SEGS_INT

542: ------> IGS_AD_ADDRUSAGE_INT_ALL -- akadam Bug# 4352471
543: --> IGS_AD_CONTACTS_INT_ALL
544: --> IGS_AD_API_INT_ALL
545: --> IGS_AD_TEST_INT
546: ------> IGS_AD_TEST_SEGS_INT
547: --> IGS_AD_ACADHIS_INT_ALL
548: ------> IGS_AD_TXCPT_INT_ALL
549: ------------> IGS_AD_TRMDT_INT
550: ------------------> IGS_AD_TUNDT_INT

Line 883: -- Enter Test Details into IGS_AD_TEST_SEGS_INT from ACT Statistics

879: FND_GLOBAL.LOGIN_ID,
880: 'Y'
881: ) returning INTERFACE_TEST_ID,ADMISSION_TEST_TYPE into l_interface_test_id,l_admission_test_type;
882:
883: -- Enter Test Details into IGS_AD_TEST_SEGS_INT from ACT Statistics
884: -- For Inserting multiple records of Test Details for a Person for each Test Type
885:
886: FOR Act_Statistic_Rec IN c_Act_Statistic_Test (Act_Assessment_rec.reporting_year,
887: Act_Assessment_rec.test_type,

Line 1031: INTO IGS_AD_TEST_SEGS_INT

1027: END LOOP;
1028: END IF;
1029:
1030: INSERT
1031: INTO IGS_AD_TEST_SEGS_INT
1032: (
1033: INTERFACE_TESTSEGS_ID ,
1034: INTERFACE_TEST_ID ,
1035: ADMISSION_TEST_TYPE ,

Line 1051: IGS_AD_TEST_SEGS_INT_S.NEXTVAL,

1047: LAST_UPDATE_LOGIN
1048: )
1049: VALUES
1050: (
1051: IGS_AD_TEST_SEGS_INT_S.NEXTVAL,
1052: l_interface_test_id,
1053: l_admission_test_type,
1054: l_test_segment_id,
1055: l_test_score,