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_ACT_ASSESSMENTS_PKG dependencies on IGS_LOOKUP_VALUES

Line 45: FUNCTION get_lookup_meaning (p_lookup_code igs_lookup_values.lookup_code%type) RETURN VARCHAR2 AS

41:
42:
43: /* Local function to get the lookup meaning */
44:
45: FUNCTION get_lookup_meaning (p_lookup_code igs_lookup_values.lookup_code%type) RETURN VARCHAR2 AS
46: l_lookup_meaning igs_lookup_values.meaning%type;
47:
48: CURSOR c_lookup_meaning (cp_lookup_code igs_lookup_values.lookup_code%type) IS
49: SELECT meaning from igs_lookup_values where lookup_code = cp_lookup_code and lookup_type = 'ACT_STATISTIC_CATEGORY';

Line 46: l_lookup_meaning igs_lookup_values.meaning%type;

42:
43: /* Local function to get the lookup meaning */
44:
45: FUNCTION get_lookup_meaning (p_lookup_code igs_lookup_values.lookup_code%type) RETURN VARCHAR2 AS
46: l_lookup_meaning igs_lookup_values.meaning%type;
47:
48: CURSOR c_lookup_meaning (cp_lookup_code igs_lookup_values.lookup_code%type) IS
49: SELECT meaning from igs_lookup_values where lookup_code = cp_lookup_code and lookup_type = 'ACT_STATISTIC_CATEGORY';
50: BEGIN

Line 48: CURSOR c_lookup_meaning (cp_lookup_code igs_lookup_values.lookup_code%type) IS

44:
45: FUNCTION get_lookup_meaning (p_lookup_code igs_lookup_values.lookup_code%type) RETURN VARCHAR2 AS
46: l_lookup_meaning igs_lookup_values.meaning%type;
47:
48: CURSOR c_lookup_meaning (cp_lookup_code igs_lookup_values.lookup_code%type) IS
49: SELECT meaning from igs_lookup_values where lookup_code = cp_lookup_code and lookup_type = 'ACT_STATISTIC_CATEGORY';
50: BEGIN
51: l_lookup_meaning:= NULL;
52: OPEN c_lookup_meaning(p_lookup_code);

Line 49: SELECT meaning from igs_lookup_values where lookup_code = cp_lookup_code and lookup_type = 'ACT_STATISTIC_CATEGORY';

45: FUNCTION get_lookup_meaning (p_lookup_code igs_lookup_values.lookup_code%type) RETURN VARCHAR2 AS
46: l_lookup_meaning igs_lookup_values.meaning%type;
47:
48: CURSOR c_lookup_meaning (cp_lookup_code igs_lookup_values.lookup_code%type) IS
49: SELECT meaning from igs_lookup_values where lookup_code = cp_lookup_code and lookup_type = 'ACT_STATISTIC_CATEGORY';
50: BEGIN
51: l_lookup_meaning:= NULL;
52: OPEN c_lookup_meaning(p_lookup_code);
53: FETCH c_lookup_meaning INTO l_lookup_meaning;

Line 213: IGS_LOOKUP_VALUES lkv

209: 'ACT-INSTITUTION','R','ACT-RESIDUAL','S','ACT-STATE','Z','ACT-ARRANGED','N','ACT-NATIONAL') ADMISSION_TEST_TYPE,
210: Decode(aas.STATISTIC_TYPE,'TEST','SCORE','TEST_SUB_SCORE','SUB SCORE') SEGMENT_TYPE,
211: lkv.meaning TEST_SEGMENT_NAME
212: FROM IGS_AD_ACT_STATISTICS aas ,
213: IGS_LOOKUP_VALUES lkv
214: WHERE aas.Reporting_Year like nvl(cp_Reporting_Year,'%')
215: AND aas.Test_Type like nvl(cp_Test_Type,'%')
216: AND aas.TEST_DATE_TXT like nvl(cp_Test_Date,'%')
217: AND aas.ACT_Identifier like nvl(cp_ACT_Id,'%')

Line 410: CURSOR c_statistic_category_desc (cp_Statistic_category igs_lookup_values.LOOKUP_CODE%type) IS

406: AND UPPER(trim(TEST_SEGMENT_NAME)) = UPPER(trim(cp_test_segment_name))
407: AND SEGMENT_TYPE = cp_segment_type;
408:
409: -- Cusror to select the Statistic Category Description from Lookups.
410: CURSOR c_statistic_category_desc (cp_Statistic_category igs_lookup_values.LOOKUP_CODE%type) IS
411: SELECT
412: Description
413: FROM IGS_LOOKUP_VALUES
414: WHERE lookup_TYPE = 'ACT_STATISTIC_CATEGORY'

Line 413: FROM IGS_LOOKUP_VALUES

409: -- Cusror to select the Statistic Category Description from Lookups.
410: CURSOR c_statistic_category_desc (cp_Statistic_category igs_lookup_values.LOOKUP_CODE%type) IS
411: SELECT
412: Description
413: FROM IGS_LOOKUP_VALUES
414: WHERE lookup_TYPE = 'ACT_STATISTIC_CATEGORY'
415: AND Lookup_code = cp_Statistic_category;
416:
417: -- Cusrsor to select the ACT Statistics Recrods for Test and Sub Test Statistic Types

Line 478: l_Statistic_Category_desc igs_lookup_values.MEANING%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 */
481:
482: -- The following code is added for disabling of OSS in R12.IGS.A - Bug 4955192