APPS.IGS_HE_EXTRACT2_PKG dependencies on STANDARD

Line 3836: -- Number of Scottish Standard Grade Credit Levels

3832: THEN
3833:
3834: g_default_pro := 'N';
3835:
3836: -- Number of Scottish Standard Grade Credit Levels
3837: igs_he_extract_fields_pkg.get_qual_dets
3838: (p_person_id => p_person_id,
3839: p_course_cd => p_course_cd,
3840: p_hesa_qual => 'SCOTST',

Line 3871: -- Scottish Standard Grade level Tariff Score

3867: THEN
3868:
3869: g_default_pro := 'N';
3870:
3871: -- Scottish Standard Grade level Tariff Score
3872: IF g_field_defn.hesa_value.EXISTS(193) AND g_field_defn.hesa_value(193) IS NOT NULL
3873: THEN
3874: p_value := g_field_defn.hesa_value(193);
3875:

Line 7511: -- Number of Scottish Standard Grade Credit Levels

7507: THEN
7508:
7509: g_default_pro := 'N';
7510:
7511: -- Number of Scottish Standard Grade Credit Levels
7512: igs_he_extract_fields_pkg.get_qual_dets
7513: (p_person_id => p_person_id,
7514: p_course_cd => p_course_cd,
7515: p_hesa_qual => 'SCOTST',

Line 7547: -- Scottish Standard Grade level Tariff Score

7543: THEN
7544:
7545: g_default_pro := 'N';
7546:
7547: -- Scottish Standard Grade level Tariff Score
7548: IF g_field_defn.hesa_value.EXISTS(178) AND g_field_defn.hesa_value(178) IS NOT NULL
7549: THEN
7550: p_value := g_field_defn.hesa_value(178);
7551:

Line 8688: -- Standard Industrial Classification

8684: p_hesa_makedo => p_value);
8685:
8686: ELSIF p_field_number = 8
8687: THEN
8688: -- Standard Industrial Classification
8689: igs_he_extract_dlhe_fields_pkg.get_sic
8690: (p_hesa_method => l_hesa_method,
8691: p_hesa_empcir => l_hesa_empcir,
8692: p_dlhe_Emp_class => g_he_stdnt_dlhe.Employer_classification,

Line 8717: -- Standard Occupational Classification

8713: p_hesa_jobtitle => p_value);
8714:
8715: ELSIF p_field_number = 11
8716: THEN
8717: -- Standard Occupational Classification
8718: igs_he_extract_dlhe_fields_pkg.get_occ_class
8719: (p_hesa_method => l_hesa_method,
8720: p_hesa_empcir => l_hesa_empcir,
8721: p_dlhe_job_class => g_he_stdnt_dlhe.Job_classification,

Line 10861: -- The direct Delete Statement is used against the standards because of performance improvement only.

10857: App_Exception.Raise_Exception;
10858: END;
10859:
10860: -- Delete the records from igs_he_ext_run_interim of the current Run ID, p_extract_run_id
10861: -- The direct Delete Statement is used against the standards because of performance improvement only.
10862: -- Same issue was fixed in IGSHE9AB.pls for bug,3179585
10863: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;
10864:
10865: END IF;