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_HE_EXTRACT2_PKG dependencies on IGS_HE_EXTRACT_DLHE_FIELDS_PKG

Line 8654: igs_he_extract_dlhe_fields_pkg.get_survey_method

8650:
8651: ELSIF p_field_number = 4
8652: THEN
8653: -- Method of data collection
8654: igs_he_extract_dlhe_fields_pkg.get_survey_method
8655: (p_dlhe_method => g_he_stdnt_dlhe.survey_method,
8656: p_hesa_method => p_value);
8657: l_hesa_method := p_value ;
8658:

Line 8662: igs_he_extract_dlhe_fields_pkg.get_empcir

8658:
8659: ELSIF p_field_number = 5
8660: THEN
8661: -- Employment circumstances
8662: igs_he_extract_dlhe_fields_pkg.get_empcir
8663: (p_hesa_method => l_hesa_method,
8664: p_dlhe_employment => g_he_stdnt_dlhe.Employment,
8665: p_hesa_empcir => p_value);
8666: l_hesa_empcir := p_value ;

Line 8671: igs_he_extract_dlhe_fields_pkg.get_mode_study

8667:
8668: ELSIF p_field_number = 6
8669: THEN
8670: -- Mode of Study
8671: igs_he_extract_dlhe_fields_pkg.get_mode_study
8672: (p_hesa_method => l_hesa_method,
8673: p_dlhe_further_study => g_he_stdnt_dlhe.Further_study,
8674: p_hesa_modstudy => p_value);
8675: l_hesa_modstudy := p_value ;

Line 8680: igs_he_extract_dlhe_fields_pkg.get_makedo

8676:
8677: ELSIF p_field_number = 7
8678: THEN
8679: -- Nature of employers business
8680: igs_he_extract_dlhe_fields_pkg.get_makedo
8681: (p_hesa_method => l_hesa_method,
8682: p_hesa_empcir => l_hesa_empcir,
8683: p_dlhe_Emp_business => g_he_stdnt_dlhe.Employer_business,
8684: p_hesa_makedo => p_value);

Line 8689: igs_he_extract_dlhe_fields_pkg.get_sic

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,
8693: p_hesa_sic => p_value);

Line 8699: igs_he_extract_dlhe_fields_pkg.get_emp_loc

8695:
8696: ELSIF p_field_number = 9
8697: THEN
8698: -- Location of employment
8699: igs_he_extract_dlhe_fields_pkg.get_emp_loc
8700: (p_hesa_method => l_hesa_method,
8701: p_hesa_empcir => l_hesa_empcir,
8702: p_dlhe_Emp_postcode => g_he_stdnt_dlhe.Employer_postcode,
8703: p_dlhe_emp_country => g_he_stdnt_dlhe.Employer_country,

Line 8709: igs_he_extract_dlhe_fields_pkg.get_job_title

8705:
8706: ELSIF p_field_number = 10
8707: THEN
8708: -- Job title
8709: igs_he_extract_dlhe_fields_pkg.get_job_title
8710: (p_hesa_method => l_hesa_method,
8711: p_hesa_empcir => l_hesa_empcir,
8712: p_dlhe_jobtitle => g_he_stdnt_dlhe.Job_title,
8713: p_hesa_jobtitle => p_value);

Line 8718: igs_he_extract_dlhe_fields_pkg.get_occ_class

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,
8722: p_hesa_soc => p_value);

Line 8727: igs_he_extract_dlhe_fields_pkg.get_emp_size

8723:
8724: ELSIF p_field_number = 12
8725: THEN
8726: -- Employer size
8727: igs_he_extract_dlhe_fields_pkg.get_emp_size
8728: (p_hesa_method => l_hesa_method,
8729: p_hesa_empcir => l_hesa_empcir,
8730: p_dlhe_emp_size => g_he_stdnt_dlhe.Employer_size,
8731: p_hesa_empsize => p_value);

Line 8736: igs_he_extract_dlhe_fields_pkg.get_emp_duration

8732:
8733: ELSIF p_field_number = 13
8734: THEN
8735: -- Duration of employment
8736: igs_he_extract_dlhe_fields_pkg.get_emp_duration
8737: (p_hesa_method => l_hesa_method,
8738: p_hesa_empcir => l_hesa_empcir,
8739: p_dlhe_emp_duration => g_he_stdnt_dlhe.Job_duration,
8740: p_hesa_duration => p_value);

Line 8745: igs_he_extract_dlhe_fields_pkg.get_salary

8741:
8742: ELSIF p_field_number = 14
8743: THEN
8744: -- Salary
8745: igs_he_extract_dlhe_fields_pkg.get_salary
8746: (p_hesa_method => l_hesa_method,
8747: p_hesa_empcir => l_hesa_empcir,
8748: p_dlhe_Job_salary => g_he_stdnt_dlhe.Job_salary,
8749: p_hesa_salary => p_value);

Line 8756: igs_he_extract_dlhe_fields_pkg.get_qual_req

8752:
8753: ELSIF p_field_number = 15
8754: THEN
8755: -- Qualification required for job
8756: igs_he_extract_dlhe_fields_pkg.get_qual_req
8757: (p_hesa_method => l_hesa_method,
8758: p_hesa_empcir => l_hesa_empcir,
8759: p_dlhe_qual_req => g_he_stdnt_dlhe.Qualification_requirement,
8760: p_hesa_qualreq => p_value);

Line 8765: igs_he_extract_dlhe_fields_pkg.get_emp_imp

8761:
8762: ELSIF p_field_number = 16
8763: THEN
8764: -- Importance to employer
8765: igs_he_extract_dlhe_fields_pkg.get_emp_imp
8766: (p_hesa_method => l_hesa_method,
8767: p_hesa_empcir => l_hesa_empcir,
8768: p_dlhe_emp_imp => g_he_stdnt_dlhe.Qualification_importance,
8769: p_hesa_empimp => p_value);

Line 8787: igs_he_extract_dlhe_fields_pkg.get_career

8783: p_value := 'X' ;
8784: ELSIF p_field_number = 17
8785: THEN
8786: -- Career related code 1
8787: igs_he_extract_dlhe_fields_pkg.get_career
8788: (p_hesa_reason => g_he_stdnt_dlhe.Job_reason1 ,
8789: p_hesa_career => p_value);
8790: ELSIF p_field_number = 18
8791: THEN

Line 8793: igs_he_extract_dlhe_fields_pkg.get_career

8789: p_hesa_career => p_value);
8790: ELSIF p_field_number = 18
8791: THEN
8792: -- Career related code 2
8793: igs_he_extract_dlhe_fields_pkg.get_career
8794: (p_hesa_reason => g_he_stdnt_dlhe.Job_reason2 ,
8795: p_hesa_career => p_value);
8796: ELSIF p_field_number = 19
8797: THEN

Line 8799: igs_he_extract_dlhe_fields_pkg.get_career

8795: p_hesa_career => p_value);
8796: ELSIF p_field_number = 19
8797: THEN
8798: -- Career related code 3
8799: igs_he_extract_dlhe_fields_pkg.get_career
8800: (p_hesa_reason => g_he_stdnt_dlhe.Job_reason3,
8801: p_hesa_career => p_value);
8802: ELSIF p_field_number = 20
8803: THEN

Line 8805: igs_he_extract_dlhe_fields_pkg.get_career

8801: p_hesa_career => p_value);
8802: ELSIF p_field_number = 20
8803: THEN
8804: -- Career related code 4
8805: igs_he_extract_dlhe_fields_pkg.get_career
8806: (p_hesa_reason => g_he_stdnt_dlhe.Job_reason4 ,
8807: p_hesa_career => p_value);
8808:
8809: ELSIF p_field_number = 21

Line 8812: igs_he_extract_dlhe_fields_pkg.get_career

8808:
8809: ELSIF p_field_number = 21
8810: THEN
8811: -- Career related code 5
8812: igs_he_extract_dlhe_fields_pkg.get_career
8813: (p_hesa_reason => g_he_stdnt_dlhe.Job_reason5 ,
8814: p_hesa_career => p_value);
8815:
8816: ELSIF p_field_number = 22

Line 8819: igs_he_extract_dlhe_fields_pkg.get_career

8815:
8816: ELSIF p_field_number = 22
8817: THEN
8818: -- Career related code 6
8819: igs_he_extract_dlhe_fields_pkg.get_career
8820: (p_hesa_reason => g_he_stdnt_dlhe.Job_reason6 ,
8821: p_hesa_career => p_value);
8822:
8823: ELSIF p_field_number = 23

Line 8826: igs_he_extract_dlhe_fields_pkg.get_career

8822:
8823: ELSIF p_field_number = 23
8824: THEN
8825: -- Career related code 7
8826: igs_he_extract_dlhe_fields_pkg.get_career
8827: (p_hesa_reason => g_he_stdnt_dlhe.Job_reason7 ,
8828: p_hesa_career => p_value);
8829:
8830: ELSIF p_field_number = 24

Line 8833: igs_he_extract_dlhe_fields_pkg.get_career

8829:
8830: ELSIF p_field_number = 24
8831: THEN
8832: -- Career related code 8
8833: igs_he_extract_dlhe_fields_pkg.get_career
8834: (p_hesa_reason => g_he_stdnt_dlhe.Job_reason8 ,
8835: p_hesa_career => p_value);
8836: END IF; -- if default value condition is not satisfied
8837:

Line 8842: igs_he_extract_dlhe_fields_pkg.get_job_find

8838:
8839: ELSIF p_field_number = 25
8840: THEN
8841: -- How found job
8842: igs_he_extract_dlhe_fields_pkg.get_job_find
8843: (p_hesa_method => l_hesa_method,
8844: p_hesa_empcir => l_hesa_empcir,
8845: p_dlhe_job_source => g_he_stdnt_dlhe.Job_source,
8846: p_hesa_jobfnd => p_value);

Line 8851: igs_he_extract_dlhe_fields_pkg.get_prev_emp

8847:
8848: ELSIF p_field_number = 26
8849: THEN
8850: -- Previously employed
8851: igs_he_extract_dlhe_fields_pkg.get_prev_emp
8852: (p_hesa_method => l_hesa_method,
8853: p_hesa_empcir => l_hesa_empcir,
8854: p_dlhe_previous_job => g_he_stdnt_dlhe.Previous_job,
8855: p_hesa_prevemp => p_value);

Line 8861: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat

8857:
8858: ELSIF p_field_number = 27
8859: THEN
8860: -- Category of previous employment 1
8861: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat
8862: (p_hesa_method => l_hesa_method,
8863: p_hesa_empcir => l_hesa_empcir,
8864: p_hesa_prevemp => l_hesa_prevemp,
8865: p_dlhe_previous_jobtype => g_he_stdnt_dlhe.Previous_jobtype1,

Line 8871: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat

8867:
8868: ELSIF p_field_number = 28
8869: THEN
8870: -- Category of previous employment 2
8871: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat
8872: (p_hesa_method => l_hesa_method,
8873: p_hesa_empcir => l_hesa_empcir,
8874: p_hesa_prevemp => l_hesa_prevemp,
8875: p_dlhe_previous_jobtype => g_he_stdnt_dlhe.Previous_jobtype2,

Line 8881: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat

8877:
8878: ELSIF p_field_number = 29
8879: THEN
8880: -- Category of previous employment 3
8881: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat
8882: (p_hesa_method => l_hesa_method,
8883: p_hesa_empcir => l_hesa_empcir,
8884: p_hesa_prevemp => l_hesa_prevemp,
8885: p_dlhe_previous_jobtype => g_he_stdnt_dlhe.Previous_jobtype3,

Line 8891: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat

8887:
8888: ELSIF p_field_number = 30
8889: THEN
8890: -- Category of previous employment 4
8891: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat
8892: (p_hesa_method => l_hesa_method,
8893: p_hesa_empcir => l_hesa_empcir,
8894: p_hesa_prevemp => l_hesa_prevemp,
8895: p_dlhe_previous_jobtype => g_he_stdnt_dlhe.Previous_jobtype4,

Line 8901: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat

8897:
8898: ELSIF p_field_number = 31
8899: THEN
8900: -- Category of previous employment 5
8901: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat
8902: (p_hesa_method => l_hesa_method,
8903: p_hesa_empcir => l_hesa_empcir,
8904: p_hesa_prevemp => l_hesa_prevemp,
8905: p_dlhe_previous_jobtype => g_he_stdnt_dlhe.Previous_jobtype5,

Line 8911: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat

8907:
8908: ELSIF p_field_number = 32
8909: THEN
8910: -- Category of previous employment 6
8911: igs_he_extract_dlhe_fields_pkg.get_prev_emp_cat
8912: (p_hesa_method => l_hesa_method,
8913: p_hesa_empcir => l_hesa_empcir,
8914: p_hesa_prevemp => l_hesa_prevemp,
8915: p_dlhe_previous_jobtype => g_he_stdnt_dlhe.Previous_jobtype6,

Line 8921: igs_he_extract_dlhe_fields_pkg.get_nat_study

8917:
8918: ELSIF p_field_number = 33
8919: THEN
8920: -- Nature of study/training
8921: igs_he_extract_dlhe_fields_pkg.get_nat_study
8922: (p_hesa_method => l_hesa_method,
8923: p_hesa_modstudy => l_hesa_modstudy,
8924: p_dlhe_study_type => g_he_stdnt_dlhe.Further_study_type,
8925: p_hesa_natstudy => p_value);

Line 8931: igs_he_extract_dlhe_fields_pkg.get_train_subj

8927:
8928: ELSIF p_field_number = 34
8929: THEN
8930: -- Professional subject of training
8931: igs_he_extract_dlhe_fields_pkg.get_train_subj
8932: (p_hesa_method => l_hesa_method,
8933: p_hesa_modstudy => l_hesa_modstudy,
8934: p_hesa_natstudy => l_hesa_natstudy,
8935: p_dlhe_crse_train_subj => g_he_stdnt_dlhe.Course_training_subject,

Line 8942: igs_he_extract_dlhe_fields_pkg.get_inst_prov

8938:
8939: ELSIF p_field_number = 35
8940: THEN
8941: -- Institution providing study
8942: igs_he_extract_dlhe_fields_pkg.get_inst_prov
8943: (p_hesa_method => l_hesa_method,
8944: p_hesa_modstudy => l_hesa_modstudy,
8945: p_hesa_natstudy => l_hesa_natstudy,
8946: p_dlhe_study_prov => g_he_stdnt_dlhe.Further_study_provider,

Line 8953: igs_he_extract_dlhe_fields_pkg.get_type_qual

8949: ELSIF p_field_number = 36
8950: THEN
8951: -- Type of qualification
8952: -- smaddali removed parameter p_hesa_natstudy from the call for build HECR011 ,bug#3051597
8953: igs_he_extract_dlhe_fields_pkg.get_type_qual
8954: (p_hesa_method => l_hesa_method,
8955: p_hesa_modstudy => l_hesa_modstudy,
8956: p_dlhe_study_qualaim => g_he_stdnt_dlhe.Further_study_qualaim,
8957: p_hesa_typequal => p_value);

Line 8964: igs_he_extract_dlhe_fields_pkg.get_study_reason2

8960: THEN
8961: -- smaddali removed calculation of field 45 EMPPAID for build HECR011 ,bug#3051597
8962: -- smaddali removed parameter p_hesa_natstudy,p_hesa_emppaid from the call for build HECR011 ,bug#3051597
8963: -- Reason for taking another course 2
8964: igs_he_extract_dlhe_fields_pkg.get_study_reason2
8965: (p_hesa_method => l_hesa_method,
8966: p_hesa_modstudy => l_hesa_modstudy,
8967: p_dlhe_study_reason => g_he_stdnt_dlhe.Study_reason1,
8968: p_hesa_secint => p_value);

Line 8975: igs_he_extract_dlhe_fields_pkg.get_study_reason2

8971: THEN
8972: -- smaddali removed calculation of field 45 EMPPAID for build HECR011 ,bug#3051597
8973: -- smaddali removed parameter p_hesa_natstudy,p_hesa_emppaid from the call for build HECR011 ,bug#3051597
8974: -- Reason for taking another course 2
8975: igs_he_extract_dlhe_fields_pkg.get_study_reason2
8976: (p_hesa_method => l_hesa_method,
8977: p_hesa_modstudy => l_hesa_modstudy,
8978: p_dlhe_study_reason => g_he_stdnt_dlhe.Study_reason2,
8979: p_hesa_secint => p_value);

Line 8986: igs_he_extract_dlhe_fields_pkg.get_study_reason2

8982: THEN
8983: -- smaddali removed calculation of field 45 EMPPAID for build HECR011 ,bug#3051597
8984: -- smaddali removed parameter p_hesa_natstudy,p_hesa_emppaid from the call for build HECR011 ,bug#3051597
8985: -- Reason for taking another course 3
8986: igs_he_extract_dlhe_fields_pkg.get_study_reason2
8987: (p_hesa_method => l_hesa_method,
8988: p_hesa_modstudy => l_hesa_modstudy,
8989: p_dlhe_study_reason => g_he_stdnt_dlhe.Study_reason3,
8990: p_hesa_secint => p_value);

Line 8997: igs_he_extract_dlhe_fields_pkg.get_study_reason2

8993: THEN
8994: -- smaddali removed calculation of field 45 EMPPAID for build HECR011 ,bug#3051597
8995: -- smaddali removed parameter p_hesa_natstudy,p_hesa_emppaid from the call for build HECR011 ,bug#3051597
8996: -- Reason for taking another course 4
8997: igs_he_extract_dlhe_fields_pkg.get_study_reason2
8998: (p_hesa_method => l_hesa_method,
8999: p_hesa_modstudy => l_hesa_modstudy,
9000: p_dlhe_study_reason => g_he_stdnt_dlhe.Study_reason4,
9001: p_hesa_secint => p_value);

Line 9008: igs_he_extract_dlhe_fields_pkg.get_study_reason2

9004: THEN
9005: -- smaddali removed calculation of field 45 EMPPAID for build HECR011 ,bug#3051597
9006: -- smaddali removed parameter p_hesa_natstudy,p_hesa_emppaid from the call for build HECR011 ,bug#3051597
9007: -- Reason for taking another course 5
9008: igs_he_extract_dlhe_fields_pkg.get_study_reason2
9009: (p_hesa_method => l_hesa_method,
9010: p_hesa_modstudy => l_hesa_modstudy,
9011: p_dlhe_study_reason => g_he_stdnt_dlhe.Study_reason5,
9012: p_hesa_secint => p_value);

Line 9019: igs_he_extract_dlhe_fields_pkg.get_study_reason2

9015: THEN
9016: -- smaddali removed calculation of field 45 EMPPAID for build HECR011 ,bug#3051597
9017: -- smaddali removed parameter p_hesa_natstudy,p_hesa_emppaid from the call for build HECR011 ,bug#3051597
9018: -- Reason for taking another course 6
9019: igs_he_extract_dlhe_fields_pkg.get_study_reason2
9020: (p_hesa_method => l_hesa_method,
9021: p_hesa_modstudy => l_hesa_modstudy,
9022: p_dlhe_study_reason => g_he_stdnt_dlhe.Study_reason6,
9023: p_hesa_secint => p_value);

Line 9030: igs_he_extract_dlhe_fields_pkg.get_study_reason2

9026: THEN
9027: -- smaddali removed calculation of field 45 EMPPAID for build HECR011 ,bug#3051597
9028: -- smaddali removed parameter p_hesa_natstudy,p_hesa_emppaid from the call for build HECR011 ,bug#3051597
9029: -- Reason for taking another course 7
9030: igs_he_extract_dlhe_fields_pkg.get_study_reason2
9031: (p_hesa_method => l_hesa_method,
9032: p_hesa_modstudy => l_hesa_modstudy,
9033: p_dlhe_study_reason => g_he_stdnt_dlhe.Study_reason7,
9034: p_hesa_secint => p_value);

Line 9041: igs_he_extract_dlhe_fields_pkg.get_study_reason8

9037: THEN
9038: -- smaddali removed calculation of field 45 EMPPAID for build HECR011 ,bug#3051597
9039: -- smaddali removed parameter p_hesa_natstudy,p_hesa_emppaid from the call for build HECR011 ,bug#3051597
9040: -- Reason for taking another course 8
9041: igs_he_extract_dlhe_fields_pkg.get_study_reason8
9042: (p_hesa_method => l_hesa_method,
9043: p_hesa_modstudy => l_hesa_modstudy,
9044: p_dlhe_other_study_reason => g_he_stdnt_dlhe.Other_study_reason,
9045: p_dlhe_no_study_reason => g_he_stdnt_dlhe.No_other_study_reason,

Line 9058: igs_he_extract_dlhe_fields_pkg.get_funding_source

9054: ELSIF p_field_number = 46
9055: THEN
9056: -- smaddali removed parameter p_hesa_natstudy,p_hesa_emppaid from the call for build HECR011 ,bug#3051597
9057: -- How funding further study
9058: igs_he_extract_dlhe_fields_pkg.get_funding_source
9059: (p_hesa_method => l_hesa_method,
9060: p_hesa_modstudy => l_hesa_modstudy,
9061: p_dlhe_funding_source => g_he_stdnt_dlhe.Funding_source,
9062: p_hesa_fundstudy => p_value);

Line 9067: igs_he_extract_dlhe_fields_pkg.get_teaching_emp

9063:
9064: ELSIF p_field_number = 47
9065: THEN
9066: -- Teaching employment marker
9067: igs_he_extract_dlhe_fields_pkg.get_teaching_emp
9068: (p_hesa_method => l_hesa_method,
9069: p_dlhe_qualified => g_he_stdnt_dlhe.Qualified_teacher,
9070: p_dlhe_teaching => g_he_stdnt_dlhe.Teacher_teaching ,
9071: p_dlhe_seeking => g_he_stdnt_dlhe.Teacher_seeking ,

Line 9078: igs_he_extract_dlhe_fields_pkg.get_teaching_sector

9074:
9075: ELSIF p_field_number = 48
9076: THEN
9077: -- Teaching sector
9078: igs_he_extract_dlhe_fields_pkg.get_teaching_sector
9079: (p_hesa_method => l_hesa_method,
9080: p_hesa_tchemp => l_hesa_tchemp,
9081: p_dlhe_teach_sector => g_he_stdnt_dlhe.Teaching_sector,
9082: p_hesa_teachsct => p_value);

Line 9087: igs_he_extract_dlhe_fields_pkg.get_teaching_phase

9083:
9084: ELSIF p_field_number = 49
9085: THEN
9086: -- Teaching phase
9087: igs_he_extract_dlhe_fields_pkg.get_teaching_phase
9088: (p_hesa_method => l_hesa_method,
9089: p_hesa_tchemp => l_hesa_tchemp,
9090: p_dlhe_teach_level => g_he_stdnt_dlhe.Teaching_level,
9091: p_hesa_teachphs => p_value);

Line 9096: igs_he_extract_dlhe_fields_pkg.get_intent

9092:
9093: ELSIF p_field_number = 50
9094: THEN
9095: -- Reason for taking original course
9096: igs_he_extract_dlhe_fields_pkg.get_intent
9097: (p_hesa_method => l_hesa_method,
9098: p_dlhe_pt_study => g_he_stdnt_dlhe.PT_Study,
9099: p_dlhe_reason_ptcrse => g_he_stdnt_dlhe.Reason_for_PTcourse,
9100: p_hesa_intent => p_value);

Line 9105: igs_he_extract_dlhe_fields_pkg.get_job_while_study

9101:
9102: ELSIF p_field_number = 51
9103: THEN
9104: -- Employed during course
9105: igs_he_extract_dlhe_fields_pkg.get_job_while_study
9106: (p_hesa_method => l_hesa_method,
9107: p_dlhe_pt_study => g_he_stdnt_dlhe.PT_Study,
9108: p_dlhe_job_while_study => g_he_stdnt_dlhe.Job_while_studying,
9109: p_hesa_empcrse => p_value);

Line 9115: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship

9111:
9112: ELSIF p_field_number = 52
9113: THEN
9114: -- Employer sponsorship 1
9115: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship
9116: (p_hesa_method => l_hesa_method,
9117: p_hesa_empcrse => l_hesa_empcrse,
9118: p_dlhe_pt_study => g_he_stdnt_dlhe.PT_Study,
9119: p_dlhe_emp_support => g_he_stdnt_dlhe.Employer_support1,

Line 9125: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship

9121:
9122: ELSIF p_field_number = 53
9123: THEN
9124: -- Employer sponsorship 2
9125: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship
9126: (p_hesa_method => l_hesa_method,
9127: p_hesa_empcrse => l_hesa_empcrse,
9128: p_dlhe_pt_study => g_he_stdnt_dlhe.PT_Study,
9129: p_dlhe_emp_support => g_he_stdnt_dlhe.Employer_support2,

Line 9135: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship

9131:
9132: ELSIF p_field_number = 54
9133: THEN
9134: -- Employer sponsorship 3
9135: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship
9136: (p_hesa_method => l_hesa_method,
9137: p_hesa_empcrse => l_hesa_empcrse,
9138: p_dlhe_pt_study => g_he_stdnt_dlhe.PT_Study,
9139: p_dlhe_emp_support => g_he_stdnt_dlhe.Employer_support3,

Line 9145: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship

9141:
9142: ELSIF p_field_number = 55
9143: THEN
9144: -- Employer sponsorship 4
9145: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship
9146: (p_hesa_method => l_hesa_method,
9147: p_hesa_empcrse => l_hesa_empcrse,
9148: p_dlhe_pt_study => g_he_stdnt_dlhe.PT_Study,
9149: p_dlhe_emp_support => g_he_stdnt_dlhe.Employer_support4,

Line 9155: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship

9151:
9152: ELSIF p_field_number = 56
9153: THEN
9154: -- Employer sponsorship 5
9155: igs_he_extract_dlhe_fields_pkg.get_emp_sponsorship
9156: (p_hesa_method => l_hesa_method,
9157: p_hesa_empcrse => l_hesa_empcrse,
9158: p_dlhe_pt_study => g_he_stdnt_dlhe.PT_Study,
9159: p_dlhe_emp_support => g_he_stdnt_dlhe.Employer_support5,