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_EX_RN_DAT_FD

Line 64: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

60: END get_survey_method;
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: /***************************************************************

Line 110: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

106: END get_empcir;
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: /***************************************************************

Line 156: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

152: END get_mode_study;
153:
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

Line 157: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

153:
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: /***************************************************************

Line 195: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

191: END get_makedo;
192:
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

Line 196: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

192:
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: /***************************************************************

Line 243: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

239: END get_sic;
240:
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)

Line 244: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

240:
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

Line 287: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

283:
284:
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

Line 288: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

284:
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: /***************************************************************

Line 326: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

322: END get_job_title;
323:
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

Line 327: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

323:
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: /***************************************************************

Line 375: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

371:
372:
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

Line 376: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

372:
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: /***************************************************************

Line 424: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

420: END get_emp_size;
421:
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

Line 425: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

421:
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: /***************************************************************

Line 473: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

469: END get_emp_duration;
470:
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

Line 474: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

470:
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: /***************************************************************

Line 512: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

508:
509:
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

Line 513: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

509:
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: /***************************************************************

Line 561: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

557: END get_qual_req;
558:
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

Line 562: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

558:
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: /***************************************************************

Line 643: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

639: END get_career;
640:
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

Line 644: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

640:
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: /***************************************************************

Line 691: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

687: END get_job_find;
688:
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

Line 692: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

688:
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: /***************************************************************

Line 739: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

735: END get_prev_emp;
736:
737:
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)

Line 740: p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,

736:
737:
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

Line 741: p_hesa_prevemp IN igs_he_ex_rn_dat_fd.value%TYPE,

737:
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: /***************************************************************

Line 779: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

775: END get_prev_emp_cat;
776:
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

Line 780: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,

776:
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: /***************************************************************

Line 827: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

823: END get_nat_study;
824:
825:
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,

Line 828: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,

824:
825:
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)

Line 829: p_hesa_natstudy IN igs_he_ex_rn_dat_fd.value%TYPE,

825:
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

Line 886: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

882: END get_train_subj;
883:
884:
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)

Line 887: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,

883:
884:
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

Line 888: p_hesa_natstudy IN igs_he_ex_rn_dat_fd.value%TYPE,

884:
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: /***************************************************************

Line 925: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

921: END get_inst_prov;
922:
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

Line 926: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,

922:
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: /***************************************************************

Line 973: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

969: END get_type_qual;
970:
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

Line 974: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,

970:
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: /***************************************************************

Line 1012: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

1008: END get_study_reason2;
1009:
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)

Line 1013: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,

1009:
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

Line 1055: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

1051: END get_study_reason8;
1052:
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

Line 1056: p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,

1052:
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: /***************************************************************

Line 1104: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

1100: END get_funding_source;
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)

Line 1151: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

1147:
1148:
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

Line 1152: p_hesa_tchemp IN igs_he_ex_rn_dat_fd.value%TYPE,

1148:
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: /***************************************************************

Line 1198: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

1194: END get_teaching_sector;
1195:
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

Line 1199: p_hesa_tchemp IN igs_he_ex_rn_dat_fd.value%TYPE,

1195:
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: /***************************************************************

Line 1246: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

1242: END get_teaching_phase;
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

Line 1292: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

1288: END get_intent;
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

Line 1330: (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,

1326: END get_job_while_study;
1327:
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)

Line 1331: p_hesa_empcrse IN igs_he_ex_rn_dat_fd.value%TYPE,

1327:
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