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_EXTRACT_DLHE_FIELDS_PKG dependencies on IGS_HE_STDNT_DLHE

Line 23: (p_dlhe_method IN igs_he_stdnt_dlhe.survey_method%TYPE,

19: END write_to_log;
20:
21:
22: PROCEDURE get_survey_method
23: (p_dlhe_method IN igs_he_stdnt_dlhe.survey_method%TYPE,
24: p_hesa_method OUT NOCOPY VARCHAR2)
25: IS
26: /***************************************************************
27: Created By : smaddali

Line 65: p_dlhe_employment IN igs_he_stdnt_dlhe.Employment%TYPE,

61:
62:
63: PROCEDURE get_empcir
64: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
65: p_dlhe_employment IN igs_he_stdnt_dlhe.Employment%TYPE,
66: p_hesa_empcir OUT NOCOPY VARCHAR2)
67: IS
68: /***************************************************************
69: Created By : smaddali

Line 111: p_dlhe_further_study IN igs_he_stdnt_dlhe.Further_study%TYPE,

107:
108:
109: PROCEDURE get_mode_study
110: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
111: p_dlhe_further_study IN igs_he_stdnt_dlhe.Further_study%TYPE,
112: p_hesa_modstudy OUT NOCOPY VARCHAR2)
113: IS
114: /***************************************************************
115: Created By : smaddali

Line 158: p_dlhe_Emp_business IN igs_he_stdnt_dlhe.Employer_business%TYPE,

154:
155: PROCEDURE get_makedo
156: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
157: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
158: p_dlhe_Emp_business IN igs_he_stdnt_dlhe.Employer_business%TYPE,
159: p_hesa_makedo OUT NOCOPY VARCHAR2)
160: IS
161: /***************************************************************
162: Created By : smaddali

Line 197: p_dlhe_Emp_class IN igs_he_stdnt_dlhe.Employer_classification%TYPE,

193:
194: PROCEDURE get_sic
195: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
196: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
197: p_dlhe_Emp_class IN igs_he_stdnt_dlhe.Employer_classification%TYPE,
198: p_hesa_sic OUT NOCOPY VARCHAR2)
199: IS
200: /***************************************************************
201: Created By : smaddali

Line 245: p_dlhe_Emp_postcode IN igs_he_stdnt_dlhe.Employer_postcode%TYPE,

241:
242: PROCEDURE get_emp_loc
243: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
244: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
245: p_dlhe_Emp_postcode IN igs_he_stdnt_dlhe.Employer_postcode%TYPE,
246: p_dlhe_emp_country IN igs_he_stdnt_dlhe.Employer_country%TYPE,
247: p_hesa_locemp OUT NOCOPY VARCHAR2)
248: IS
249: /***************************************************************

Line 246: p_dlhe_emp_country IN igs_he_stdnt_dlhe.Employer_country%TYPE,

242: PROCEDURE get_emp_loc
243: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
244: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
245: p_dlhe_Emp_postcode IN igs_he_stdnt_dlhe.Employer_postcode%TYPE,
246: p_dlhe_emp_country IN igs_he_stdnt_dlhe.Employer_country%TYPE,
247: p_hesa_locemp OUT NOCOPY VARCHAR2)
248: IS
249: /***************************************************************
250: Created By : smaddali

Line 289: p_dlhe_jobtitle IN igs_he_stdnt_dlhe.Job_title%TYPE,

285:
286: PROCEDURE get_job_title
287: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
288: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
289: p_dlhe_jobtitle IN igs_he_stdnt_dlhe.Job_title%TYPE,
290: p_hesa_jobtitle OUT NOCOPY VARCHAR2)
291: IS
292: /***************************************************************
293: Created By : smaddali

Line 328: p_dlhe_job_class IN igs_he_stdnt_dlhe.Job_classification%TYPE,

324:
325: PROCEDURE get_occ_class
326: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
327: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
328: p_dlhe_job_class IN igs_he_stdnt_dlhe.Job_classification%TYPE,
329: p_hesa_soc OUT NOCOPY VARCHAR2)
330: IS
331: /***************************************************************
332: Created By : smaddali

Line 377: p_dlhe_emp_size IN igs_he_stdnt_dlhe.Employer_size%TYPE,

373:
374: PROCEDURE get_emp_size
375: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
376: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
377: p_dlhe_emp_size IN igs_he_stdnt_dlhe.Employer_size%TYPE,
378: p_hesa_empsize OUT NOCOPY VARCHAR2)
379: IS
380: /***************************************************************
381: Created By : smaddali

Line 426: p_dlhe_emp_duration IN igs_he_stdnt_dlhe.Job_duration%TYPE,

422:
423: PROCEDURE get_emp_duration
424: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
425: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
426: p_dlhe_emp_duration IN igs_he_stdnt_dlhe.Job_duration%TYPE,
427: p_hesa_duration OUT NOCOPY VARCHAR2)
428: IS
429: /***************************************************************
430: Created By : smaddali

Line 475: p_dlhe_Job_salary IN igs_he_stdnt_dlhe.Job_salary%TYPE,

471:
472: PROCEDURE get_salary
473: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
474: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
475: p_dlhe_Job_salary IN igs_he_stdnt_dlhe.Job_salary%TYPE,
476: p_hesa_salary OUT NOCOPY VARCHAR2)
477: IS
478: /***************************************************************
479: Created By : smaddali

Line 514: p_dlhe_qual_req IN igs_he_stdnt_dlhe.Qualification_requirement%TYPE,

510:
511: PROCEDURE get_qual_req
512: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
513: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
514: p_dlhe_qual_req IN igs_he_stdnt_dlhe.Qualification_requirement%TYPE,
515: p_hesa_qualreq OUT NOCOPY VARCHAR2)
516: IS
517: /***************************************************************
518: Created By : smaddali

Line 563: p_dlhe_emp_imp IN igs_he_stdnt_dlhe.Qualification_importance%TYPE,

559:
560: PROCEDURE get_emp_imp
561: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
562: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
563: p_dlhe_emp_imp IN igs_he_stdnt_dlhe.Qualification_importance%TYPE,
564: p_hesa_empimp OUT NOCOPY VARCHAR2)
565: IS
566: /***************************************************************
567: Created By : smaddali

Line 610: (p_hesa_reason IN igs_he_stdnt_dlhe.Job_reason1%TYPE,

606: END get_emp_imp;
607:
608:
609: PROCEDURE get_career
610: (p_hesa_reason IN igs_he_stdnt_dlhe.Job_reason1%TYPE,
611: p_hesa_career OUT NOCOPY VARCHAR2)
612: IS
613: /***************************************************************
614: Created By : smaddali

Line 645: p_dlhe_job_source IN igs_he_stdnt_dlhe.Job_source%TYPE,

641:
642: PROCEDURE get_job_find
643: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
644: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
645: p_dlhe_job_source IN igs_he_stdnt_dlhe.Job_source%TYPE,
646: p_hesa_jobfnd OUT NOCOPY VARCHAR2)
647: IS
648: /***************************************************************
649: Created By : smaddali

Line 693: p_dlhe_previous_job IN igs_he_stdnt_dlhe.Previous_job%TYPE,

689:
690: PROCEDURE get_prev_emp
691: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
692: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
693: p_dlhe_previous_job IN igs_he_stdnt_dlhe.Previous_job%TYPE,
694: p_hesa_prevemp OUT NOCOPY VARCHAR2)
695: IS
696: /***************************************************************
697: Created By : smaddali

Line 742: p_dlhe_previous_jobtype IN igs_he_stdnt_dlhe.Previous_jobtype1%TYPE,

738: PROCEDURE get_prev_emp_cat
739: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
740: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
741: p_hesa_prevemp IN igs_he_ex_rn_dat_fd.value%TYPE,
742: p_dlhe_previous_jobtype IN igs_he_stdnt_dlhe.Previous_jobtype1%TYPE,
743: p_hesa_prevcat OUT NOCOPY VARCHAR2)
744: IS
745: /***************************************************************
746: Created By : smaddali

Line 781: p_dlhe_study_type IN igs_he_stdnt_dlhe.Further_study_type%TYPE,

777:
778: PROCEDURE get_nat_study
779: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
780: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
781: p_dlhe_study_type IN igs_he_stdnt_dlhe.Further_study_type%TYPE,
782: p_hesa_natstudy OUT NOCOPY VARCHAR2)
783: IS
784: /***************************************************************
785: Created By : smaddali

Line 830: p_dlhe_crse_train_subj IN igs_he_stdnt_dlhe.Course_training_subject%TYPE,

826: PROCEDURE get_train_subj
827: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
828: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
829: p_hesa_natstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
830: p_dlhe_crse_train_subj IN igs_he_stdnt_dlhe.Course_training_subject%TYPE,
831: p_dlhe_res_train_subj IN igs_he_stdnt_dlhe.Research_training_subject%TYPE,
832: p_hesa_profsoct OUT NOCOPY VARCHAR2)
833: IS
834: /***************************************************************

Line 831: p_dlhe_res_train_subj IN igs_he_stdnt_dlhe.Research_training_subject%TYPE,

827: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
828: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
829: p_hesa_natstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
830: p_dlhe_crse_train_subj IN igs_he_stdnt_dlhe.Course_training_subject%TYPE,
831: p_dlhe_res_train_subj IN igs_he_stdnt_dlhe.Research_training_subject%TYPE,
832: p_hesa_profsoct OUT NOCOPY VARCHAR2)
833: IS
834: /***************************************************************
835: Created By : smaddali

Line 889: p_dlhe_study_prov IN igs_he_stdnt_dlhe.Further_study_provider%TYPE,

885: PROCEDURE get_inst_prov
886: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
887: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
888: p_hesa_natstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
889: p_dlhe_study_prov IN igs_he_stdnt_dlhe.Further_study_provider%TYPE,
890: p_hesa_instprov OUT NOCOPY VARCHAR2)
891: IS
892: /***************************************************************
893: Created By : smaddali

Line 927: p_dlhe_study_qualaim IN igs_he_stdnt_dlhe.Further_study_qualaim%TYPE,

923:
924: PROCEDURE get_type_qual
925: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
926: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
927: p_dlhe_study_qualaim IN igs_he_stdnt_dlhe.Further_study_qualaim%TYPE,
928: p_hesa_typequal OUT NOCOPY VARCHAR2)
929: IS
930: /***************************************************************
931: Created By : smaddali

Line 975: p_dlhe_study_reason IN igs_he_stdnt_dlhe.Study_reason2%TYPE,

971:
972: PROCEDURE get_study_reason2
973: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
974: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
975: p_dlhe_study_reason IN igs_he_stdnt_dlhe.Study_reason2%TYPE,
976: p_hesa_secint OUT NOCOPY VARCHAR2)
977: IS
978: /***************************************************************
979: Created By : smaddali

Line 1014: p_dlhe_other_study_reason IN igs_he_stdnt_dlhe.Other_study_reason%TYPE,

1010:
1011: PROCEDURE get_study_reason8
1012: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1013: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
1014: p_dlhe_other_study_reason IN igs_he_stdnt_dlhe.Other_study_reason%TYPE,
1015: p_dlhe_no_study_reason IN igs_he_stdnt_dlhe.No_other_study_reason%TYPE,
1016: p_hesa_secint8 OUT NOCOPY VARCHAR2)
1017: IS
1018: /***************************************************************

Line 1015: p_dlhe_no_study_reason IN igs_he_stdnt_dlhe.No_other_study_reason%TYPE,

1011: PROCEDURE get_study_reason8
1012: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1013: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
1014: p_dlhe_other_study_reason IN igs_he_stdnt_dlhe.Other_study_reason%TYPE,
1015: p_dlhe_no_study_reason IN igs_he_stdnt_dlhe.No_other_study_reason%TYPE,
1016: p_hesa_secint8 OUT NOCOPY VARCHAR2)
1017: IS
1018: /***************************************************************
1019: Created By : smaddali

Line 1057: p_dlhe_funding_source IN igs_he_stdnt_dlhe.Funding_source%TYPE,

1053:
1054: PROCEDURE get_funding_source
1055: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1056: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
1057: p_dlhe_funding_source IN igs_he_stdnt_dlhe.Funding_source%TYPE,
1058: p_hesa_fundstudy OUT NOCOPY VARCHAR2)
1059: IS
1060: /***************************************************************
1061: Created By : smaddali

Line 1105: p_dlhe_qualified IN igs_he_stdnt_dlhe.Qualified_teacher%TYPE,

1101:
1102:
1103: PROCEDURE get_teaching_emp
1104: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1105: p_dlhe_qualified IN igs_he_stdnt_dlhe.Qualified_teacher%TYPE,
1106: p_dlhe_teaching IN igs_he_stdnt_dlhe.Teacher_teaching%TYPE ,
1107: p_dlhe_seeking IN igs_he_stdnt_dlhe.Teacher_seeking%TYPE ,
1108: p_hesa_tchemp OUT NOCOPY VARCHAR2)
1109: IS

Line 1106: p_dlhe_teaching IN igs_he_stdnt_dlhe.Teacher_teaching%TYPE ,

1102:
1103: PROCEDURE get_teaching_emp
1104: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1105: p_dlhe_qualified IN igs_he_stdnt_dlhe.Qualified_teacher%TYPE,
1106: p_dlhe_teaching IN igs_he_stdnt_dlhe.Teacher_teaching%TYPE ,
1107: p_dlhe_seeking IN igs_he_stdnt_dlhe.Teacher_seeking%TYPE ,
1108: p_hesa_tchemp OUT NOCOPY VARCHAR2)
1109: IS
1110: /***************************************************************

Line 1107: p_dlhe_seeking IN igs_he_stdnt_dlhe.Teacher_seeking%TYPE ,

1103: PROCEDURE get_teaching_emp
1104: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1105: p_dlhe_qualified IN igs_he_stdnt_dlhe.Qualified_teacher%TYPE,
1106: p_dlhe_teaching IN igs_he_stdnt_dlhe.Teacher_teaching%TYPE ,
1107: p_dlhe_seeking IN igs_he_stdnt_dlhe.Teacher_seeking%TYPE ,
1108: p_hesa_tchemp OUT NOCOPY VARCHAR2)
1109: IS
1110: /***************************************************************
1111: Created By : smaddali

Line 1153: p_dlhe_teach_sector IN igs_he_stdnt_dlhe.Teaching_sector%TYPE,

1149:
1150: PROCEDURE get_teaching_sector
1151: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1152: p_hesa_tchemp IN igs_he_ex_rn_dat_fd.value%TYPE,
1153: p_dlhe_teach_sector IN igs_he_stdnt_dlhe.Teaching_sector%TYPE,
1154: p_hesa_teachsct OUT NOCOPY VARCHAR2)
1155: IS
1156: /***************************************************************
1157: Created By : smaddali

Line 1200: p_dlhe_teach_level IN igs_he_stdnt_dlhe.Teaching_level%TYPE,

1196:
1197: PROCEDURE get_teaching_phase
1198: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1199: p_hesa_tchemp IN igs_he_ex_rn_dat_fd.value%TYPE,
1200: p_dlhe_teach_level IN igs_he_stdnt_dlhe.Teaching_level%TYPE,
1201: p_hesa_teachphs OUT NOCOPY VARCHAR2)
1202: IS
1203: /***************************************************************
1204: Created By : smaddali

Line 1247: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,

1243:
1244:
1245: PROCEDURE get_intent
1246: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1247: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,
1248: p_dlhe_reason_ptcrse IN igs_he_stdnt_dlhe.Reason_for_PTcourse%TYPE,
1249: p_hesa_intent OUT NOCOPY VARCHAR2)
1250: IS
1251: /***************************************************************

Line 1248: p_dlhe_reason_ptcrse IN igs_he_stdnt_dlhe.Reason_for_PTcourse%TYPE,

1244:
1245: PROCEDURE get_intent
1246: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1247: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,
1248: p_dlhe_reason_ptcrse IN igs_he_stdnt_dlhe.Reason_for_PTcourse%TYPE,
1249: p_hesa_intent OUT NOCOPY VARCHAR2)
1250: IS
1251: /***************************************************************
1252: Created By : smaddali

Line 1293: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,

1289:
1290:
1291: PROCEDURE get_job_while_study
1292: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1293: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,
1294: p_dlhe_job_while_study IN igs_he_stdnt_dlhe.Job_while_studying%TYPE,
1295: p_hesa_empcrse OUT NOCOPY VARCHAR2)
1296: IS
1297: /***************************************************************

Line 1294: p_dlhe_job_while_study IN igs_he_stdnt_dlhe.Job_while_studying%TYPE,

1290:
1291: PROCEDURE get_job_while_study
1292: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1293: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,
1294: p_dlhe_job_while_study IN igs_he_stdnt_dlhe.Job_while_studying%TYPE,
1295: p_hesa_empcrse OUT NOCOPY VARCHAR2)
1296: IS
1297: /***************************************************************
1298: Created By : smaddali

Line 1332: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,

1328:
1329: PROCEDURE get_emp_sponsorship
1330: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1331: p_hesa_empcrse IN igs_he_ex_rn_dat_fd.value%TYPE,
1332: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,
1333: p_dlhe_emp_support IN igs_he_stdnt_dlhe.Employer_support1%TYPE,
1334: p_hesa_empspns OUT NOCOPY VARCHAR2)
1335: IS
1336: /***************************************************************

Line 1333: p_dlhe_emp_support IN igs_he_stdnt_dlhe.Employer_support1%TYPE,

1329: PROCEDURE get_emp_sponsorship
1330: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
1331: p_hesa_empcrse IN igs_he_ex_rn_dat_fd.value%TYPE,
1332: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,
1333: p_dlhe_emp_support IN igs_he_stdnt_dlhe.Employer_support1%TYPE,
1334: p_hesa_empspns OUT NOCOPY VARCHAR2)
1335: IS
1336: /***************************************************************
1337: Created By : smaddali