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_FIELDS_PKG dependencies on IGS_HE_ST_SPA

Line 64: (p_spa_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

60: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
61: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
62:
63: PROCEDURE get_fe_stdnt_mrker
64: (p_spa_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
65: p_fe_program_marker IN igs_he_st_prog.fe_program_marker%TYPE,
66: p_funding_src IN igs_he_ex_rn_dat_fd.value%TYPE,
67: p_fundability_cd IN igs_he_ex_rn_dat_fd.value%TYPE,
68: p_oss_fe_stdnt_mrker OUT NOCOPY VARCHAR2,

Line 106: p_spa_domicile IN igs_he_st_spa.domicile_cd%TYPE,

102: p_hesa_gender OUT NOCOPY VARCHAR2);
103:
104: PROCEDURE get_domicile
105: (p_ad_domicile IN igs_he_ad_dtl.domicile_cd%TYPE,
106: p_spa_domicile IN igs_he_st_spa.domicile_cd%TYPE,
107: p_hesa_domicile OUT NOCOPY VARCHAR2);
108:
109: -- smaddali 11-dec-03 Modified for bug#3235753 , added 1 new parameter
110: PROCEDURE get_nationality

Line 143: (p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

139: p_ucasnum IN igs_pe_alt_pers_id.api_person_id%TYPE,
140: p_year OUT NOCOPY VARCHAR2);
141:
142: PROCEDURE get_new_ent_to_he
143: (p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
144: p_susa_new_ent_to_he IN igs_he_en_susa.new_he_entrant_cd%TYPE,
145: p_yop IN VARCHAR2,
146: p_high_qual_on_ent IN igs_he_st_spa.highest_qual_on_entry%TYPE,
147: p_domicile IN igs_he_st_spa.domicile_cd%TYPE,

Line 146: p_high_qual_on_ent IN igs_he_st_spa.highest_qual_on_entry%TYPE,

142: PROCEDURE get_new_ent_to_he
143: (p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
144: p_susa_new_ent_to_he IN igs_he_en_susa.new_he_entrant_cd%TYPE,
145: p_yop IN VARCHAR2,
146: p_high_qual_on_ent IN igs_he_st_spa.highest_qual_on_entry%TYPE,
147: p_domicile IN igs_he_st_spa.domicile_cd%TYPE,
148: p_hesa_new_ent_to_he OUT NOCOPY VARCHAR2);
149:
150: PROCEDURE get_year_of_prog

Line 147: p_domicile IN igs_he_st_spa.domicile_cd%TYPE,

143: (p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
144: p_susa_new_ent_to_he IN igs_he_en_susa.new_he_entrant_cd%TYPE,
145: p_yop IN VARCHAR2,
146: p_high_qual_on_ent IN igs_he_st_spa.highest_qual_on_entry%TYPE,
147: p_domicile IN igs_he_st_spa.domicile_cd%TYPE,
148: p_hesa_new_ent_to_he OUT NOCOPY VARCHAR2);
149:
150: PROCEDURE get_year_of_prog
151: (p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,

Line 156: p_spa_special_student IN igs_he_st_spa.special_student%TYPE,

152: p_year_of_prog OUT NOCOPY VARCHAR2);
153:
154: PROCEDURE get_special_student
155: (p_ad_special_student IN igs_he_ad_dtl.special_student_cd%TYPE,
156: p_spa_special_student IN igs_he_st_spa.special_student%TYPE,
157: p_oss_special_student OUT NOCOPY VARCHAR2,
158: p_hesa_special_student OUT NOCOPY VARCHAR2);
159:
160: -- smaddali 29-oct-03 modified procedure get_year_of_student to add 1 new parameter for bug#3224246

Line 228: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,

224:
225: --smaddali 6-jun-2002 bug 2396174 added parameter p_course_cd
226: PROCEDURE get_completion_status
227: (p_person_id IN igs_pe_person.person_id%TYPE,
228: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,
229: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,
230: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
231: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,
232: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

Line 230: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

226: PROCEDURE get_completion_status
227: (p_person_id IN igs_pe_person.person_id%TYPE,
228: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,
229: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,
230: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
231: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,
232: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
233: p_hesa_comp_status OUT NOCOPY VARCHAR2);
234:

Line 237: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

233: p_hesa_comp_status OUT NOCOPY VARCHAR2);
234:
235: PROCEDURE get_good_stand_mrkr
236: (p_susa_good_st_mk IN igs_he_en_susa.good_stand_marker%TYPE,
237: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
238: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,
239: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
240: p_hesa_good_st_mk OUT NOCOPY VARCHAR2);
241:

Line 244: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

240: p_hesa_good_st_mk OUT NOCOPY VARCHAR2);
241:
242: PROCEDURE get_qual_obtained
243: (p_person_id IN igs_pe_person.person_id%TYPE,
244: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
245: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
246: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
247: p_oss_qual_obt1 OUT NOCOPY VARCHAR2,
248: p_oss_qual_obt2 OUT NOCOPY VARCHAR2,

Line 254: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,

250: p_hesa_qual_obt2 OUT NOCOPY VARCHAR2,
251: p_classification OUT NOCOPY VARCHAR2);
252:
253: PROCEDURE get_fe_qual_aim
254: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,
255: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
256: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
257: p_version_number IN igs_he_st_spa.version_number%TYPE,
258: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2);

Line 255: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

251: p_classification OUT NOCOPY VARCHAR2);
252:
253: PROCEDURE get_fe_qual_aim
254: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,
255: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
256: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
257: p_version_number IN igs_he_st_spa.version_number%TYPE,
258: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2);
259:

Line 256: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

252:
253: PROCEDURE get_fe_qual_aim
254: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,
255: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
256: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
257: p_version_number IN igs_he_st_spa.version_number%TYPE,
258: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2);
259:
260: PROCEDURE get_qual_aim_sbj

Line 257: p_version_number IN igs_he_st_spa.version_number%TYPE,

253: PROCEDURE get_fe_qual_aim
254: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,
255: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
256: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
257: p_version_number IN igs_he_st_spa.version_number%TYPE,
258: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2);
259:
260: PROCEDURE get_qual_aim_sbj
261: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,

Line 261: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,

257: p_version_number IN igs_he_st_spa.version_number%TYPE,
258: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2);
259:
260: PROCEDURE get_qual_aim_sbj
261: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
262: p_version_number IN igs_he_st_spa.version_number%TYPE,
263: p_subject1 OUT NOCOPY VARCHAR2,
264: p_subject2 OUT NOCOPY VARCHAR2,
265: p_subject3 OUT NOCOPY VARCHAR2,

Line 262: p_version_number IN igs_he_st_spa.version_number%TYPE,

258: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2);
259:
260: PROCEDURE get_qual_aim_sbj
261: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
262: p_version_number IN igs_he_st_spa.version_number%TYPE,
263: p_subject1 OUT NOCOPY VARCHAR2,
264: p_subject2 OUT NOCOPY VARCHAR2,
265: p_subject3 OUT NOCOPY VARCHAR2,
266: p_prop_ind OUT NOCOPY VARCHAR2);

Line 271: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

267:
268: -- smaddali added 2 new parameters for bug#3360646
269: PROCEDURE get_gen_qual_aim
270: (p_person_id IN igs_pe_person.person_id%TYPE,
271: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
272: p_version_number IN igs_he_st_spa.version_number%TYPE,
273: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
274: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,
275: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

Line 272: p_version_number IN igs_he_st_spa.version_number%TYPE,

268: -- smaddali added 2 new parameters for bug#3360646
269: PROCEDURE get_gen_qual_aim
270: (p_person_id IN igs_pe_person.person_id%TYPE,
271: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
272: p_version_number IN igs_he_st_spa.version_number%TYPE,
273: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
274: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,
275: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
276: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL,

Line 273: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,

269: PROCEDURE get_gen_qual_aim
270: (p_person_id IN igs_pe_person.person_id%TYPE,
271: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
272: p_version_number IN igs_he_st_spa.version_number%TYPE,
273: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
274: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,
275: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
276: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL,
277: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE DEFAULT NULL);

Line 280: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,

276: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL,
277: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE DEFAULT NULL);
278:
279: PROCEDURE get_awd_body_12
280: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
281: p_version_number IN igs_he_st_spa.version_number%TYPE,
282: p_awd1 IN VARCHAR2,
283: p_awd2 IN VARCHAR2,
284: p_awd_body1 OUT NOCOPY VARCHAR2,

Line 281: p_version_number IN igs_he_st_spa.version_number%TYPE,

277: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE DEFAULT NULL);
278:
279: PROCEDURE get_awd_body_12
280: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
281: p_version_number IN igs_he_st_spa.version_number%TYPE,
282: p_awd1 IN VARCHAR2,
283: p_awd2 IN VARCHAR2,
284: p_awd_body1 OUT NOCOPY VARCHAR2,
285: p_awd_body2 OUT NOCOPY VARCHAR2);

Line 296: p_spa_ttcid IN igs_he_st_spa.teacher_train_prog_id%TYPE,

292: p_units OUT NOCOPY VARCHAR2);
293:
294: PROCEDURE get_teach_train_crs_id
295: (p_prg_ttcid IN igs_he_st_prog.teacher_train_prog_id%TYPE,
296: p_spa_ttcid IN igs_he_st_spa.teacher_train_prog_id%TYPE,
297: p_hesa_ttcid OUT NOCOPY VARCHAR2);
298:
299: PROCEDURE get_itt_phsc
300: (p_prg_itt_phsc IN igs_he_st_prog.itt_phase%TYPE,

Line 301: p_spa_itt_phsc IN igs_he_st_spa.itt_phase%TYPE,

297: p_hesa_ttcid OUT NOCOPY VARCHAR2);
298:
299: PROCEDURE get_itt_phsc
300: (p_prg_itt_phsc IN igs_he_st_prog.itt_phase%TYPE,
301: p_spa_itt_phsc IN igs_he_st_spa.itt_phase%TYPE,
302: p_hesa_itt_phsc OUT NOCOPY VARCHAR2);
303:
304: PROCEDURE get_itt_mrker
305: (p_prg_itt_mrker IN igs_he_st_prog.bilingual_itt_marker%TYPE,

Line 306: p_spa_itt_mrker IN igs_he_st_spa.bilingual_itt_marker%TYPE,

302: p_hesa_itt_phsc OUT NOCOPY VARCHAR2);
303:
304: PROCEDURE get_itt_mrker
305: (p_prg_itt_mrker IN igs_he_st_prog.bilingual_itt_marker%TYPE,
306: p_spa_itt_mrker IN igs_he_st_spa.bilingual_itt_marker%TYPE,
307: p_hesa_itt_mrker OUT NOCOPY VARCHAR2);
308:
309: PROCEDURE get_teach_qual_sect
310: (p_oss_teach_qual_sect IN igs_he_st_prog.teaching_qual_sought_sector%TYPE,

Line 321: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

317: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
318: PROCEDURE get_fee_elig
319: (p_person_id IN igs_pe_person.person_id%TYPE,
320: p_susa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,
321: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
322: p_study_mode IN VARCHAR2,
323: p_special_student IN VARCHAR2,
324: p_hesa_fee_elig OUT NOCOPY VARCHAR2,
325: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

Line 338: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

334:
335: -- smaddali 13-oct-03 modified procedure to add 2 new parameters for bug# 3179544
336: PROCEDURE get_amt_tuition_fees
337: (p_person_id IN igs_pe_person.person_id%TYPE,
338: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
339: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
340: p_fe_prg_mrker IN igs_he_st_prog.fe_program_marker%TYPE,
341: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
342: p_oss_amt OUT NOCOPY NUMBER,

Line 341: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

337: (p_person_id IN igs_pe_person.person_id%TYPE,
338: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
339: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
340: p_fe_prg_mrker IN igs_he_st_prog.fe_program_marker%TYPE,
341: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
342: p_oss_amt OUT NOCOPY NUMBER,
343: p_hesa_amt OUT NOCOPY VARCHAR2,
344: p_enrl_start_dt IN DATE DEFAULT NULL,
345: p_enrl_end_dt IN DATE DEFAULT NULL);

Line 363: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

359: p_hesa_religion OUT NOCOPY VARCHAR2);
360:
361: PROCEDURE get_sldd_disc_prv
362: (p_oss_sldd_disc_prv IN igs_he_en_susa.sldd_discrete_prov%TYPE,
363: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
364: p_hesa_sldd_disc_prv OUT NOCOPY VARCHAR2);
365:
366:
367:

Line 370: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

366:
367:
368: PROCEDURE get_non_payment_rsn
369: (p_oss_non_payment_rsn IN igs_he_en_susa.non_payment_reason%TYPE,
370: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
371: p_hesa_non_payment_rsn OUT NOCOPY VARCHAR2);
372:
373:
374:

Line 377: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

373:
374:
375: PROCEDURE get_oth_teach_inst
376: (p_person_id IN igs_pe_person.person_id%TYPE,
377: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
378: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
379: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
380: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
381: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,

Line 393: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

389:
390: -- smaddali added new parameters p_enrl_start_dt , p_enrl_end_dt for bug 2437081
391: PROCEDURE get_prop_not_taught
392: (p_person_id IN igs_pe_person.person_id%TYPE,
393: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
394: p_enrl_start_dt IN DATE,
395: p_enrl_end_dt IN DATE,
396: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
397: p_susa_prop IN igs_he_en_susa.pro_not_taught%TYPE,

Line 414: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

410:
411: -- jbaber added crd_pt3-4, lvl_crd_pt3-4 for HEFD350
412: PROCEDURE get_credit_obtained
413: (p_person_id IN igs_pe_person.person_id%TYPE,
414: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
415: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
416: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,

Line 460: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

456:
457: -- jbaber 25-Nov-2004 Included p_version_number for bug # 4037237
458: PROCEDURE get_studies_susp
459: (p_person_id IN igs_pe_person.person_id%TYPE,
460: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
461: p_version_number IN igs_he_st_spa.version_number%TYPE,
462: p_enrl_start_dt IN DATE,
463: p_enrl_end_dt IN DATE,
464: p_susp_act_std OUT NOCOPY VARCHAR2);

Line 461: p_version_number IN igs_he_st_spa.version_number%TYPE,

457: -- jbaber 25-Nov-2004 Included p_version_number for bug # 4037237
458: PROCEDURE get_studies_susp
459: (p_person_id IN igs_pe_person.person_id%TYPE,
460: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
461: p_version_number IN igs_he_st_spa.version_number%TYPE,
462: p_enrl_start_dt IN DATE,
463: p_enrl_end_dt IN DATE,
464: p_susp_act_std OUT NOCOPY VARCHAR2);
465:

Line 493: (p_oss_destination IN igs_he_st_spa.destination%TYPE,

489: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
490: p_hesa_comp_pyr_study OUT NOCOPY VARCHAR2);
491:
492: PROCEDURE get_destination
493: (p_oss_destination IN igs_he_st_spa.destination%TYPE,
494: p_hesa_destination OUT NOCOPY VARCHAR2);
495:
496: PROCEDURE get_itt_outcome
497: (p_oss_itt_outcome IN igs_he_st_spa.itt_prog_outcome%TYPE,

Line 497: (p_oss_itt_outcome IN igs_he_st_spa.itt_prog_outcome%TYPE,

493: (p_oss_destination IN igs_he_st_spa.destination%TYPE,
494: p_hesa_destination OUT NOCOPY VARCHAR2);
495:
496: PROCEDURE get_itt_outcome
497: (p_oss_itt_outcome IN igs_he_st_spa.itt_prog_outcome%TYPE,
498: p_teach_train_prg IN igs_he_st_spa.teacher_train_prog_id%TYPE,
499: p_hesa_itt_outcome OUT NOCOPY VARCHAR2);
500:
501: PROCEDURE get_ufi_place

Line 498: p_teach_train_prg IN igs_he_st_spa.teacher_train_prog_id%TYPE,

494: p_hesa_destination OUT NOCOPY VARCHAR2);
495:
496: PROCEDURE get_itt_outcome
497: (p_oss_itt_outcome IN igs_he_st_spa.itt_prog_outcome%TYPE,
498: p_teach_train_prg IN igs_he_st_spa.teacher_train_prog_id%TYPE,
499: p_hesa_itt_outcome OUT NOCOPY VARCHAR2);
500:
501: PROCEDURE get_ufi_place
502: (p_oss_ufi_place IN igs_he_st_spa.ufi_place%TYPE,

Line 502: (p_oss_ufi_place IN igs_he_st_spa.ufi_place%TYPE,

498: p_teach_train_prg IN igs_he_st_spa.teacher_train_prog_id%TYPE,
499: p_hesa_itt_outcome OUT NOCOPY VARCHAR2);
500:
501: PROCEDURE get_ufi_place
502: (p_oss_ufi_place IN igs_he_st_spa.ufi_place%TYPE,
503: p_hesa_ufi_place OUT NOCOPY VARCHAR2);
504:
505: PROCEDURE get_franchising_activity
506: (p_susa_franch_activity IN igs_he_en_susa.franchising_activity%TYPE,

Line 512: (p_spa_social_class_ind IN igs_he_st_spa.social_class_ind%TYPE,

508: p_prog_franch_activity IN igs_he_st_prog.franchising_activity%TYPE,
509: p_hesa_franch_activity OUT NOCOPY VARCHAR2);
510:
511: PROCEDURE get_social_class_ind
512: (p_spa_social_class_ind IN igs_he_st_spa.social_class_ind%TYPE,
513: p_adm_social_class_ind IN igs_he_ad_dtl.social_class_cd%TYPE,
514: p_hesa_social_class_ind OUT NOCOPY VARCHAR2);
515:
516: PROCEDURE get_occupation_code

Line 517: (p_spa_occupation_code IN igs_he_st_spa.occupation_code%TYPE,

513: p_adm_social_class_ind IN igs_he_ad_dtl.social_class_cd%TYPE,
514: p_hesa_social_class_ind OUT NOCOPY VARCHAR2);
515:
516: PROCEDURE get_occupation_code
517: (p_spa_occupation_code IN igs_he_st_spa.occupation_code%TYPE,
518: p_hesa_occupation_code OUT NOCOPY VARCHAR2);
519:
520: PROCEDURE get_inst_last_attended
521: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 528: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,

524: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
525: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
526:
527: PROCEDURE get_regulatory_body
528: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
529: p_version_number IN igs_he_st_spa.version_number%TYPE,
530: p_hesa_regulatory_body OUT NOCOPY VARCHAR2);
531:
532: PROCEDURE get_nhs_fund_src

Line 529: p_version_number IN igs_he_st_spa.version_number%TYPE,

525: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
526:
527: PROCEDURE get_regulatory_body
528: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
529: p_version_number IN igs_he_st_spa.version_number%TYPE,
530: p_hesa_regulatory_body OUT NOCOPY VARCHAR2);
531:
532: PROCEDURE get_nhs_fund_src
533: (p_spa_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,

Line 533: (p_spa_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,

529: p_version_number IN igs_he_st_spa.version_number%TYPE,
530: p_hesa_regulatory_body OUT NOCOPY VARCHAR2);
531:
532: PROCEDURE get_nhs_fund_src
533: (p_spa_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,
534: p_prg_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,
535: p_hesa_nhs_fund_src OUT NOCOPY VARCHAR2);
536:
537: PROCEDURE get_nhs_employer

Line 534: p_prg_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,

530: p_hesa_regulatory_body OUT NOCOPY VARCHAR2);
531:
532: PROCEDURE get_nhs_fund_src
533: (p_spa_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,
534: p_prg_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,
535: p_hesa_nhs_fund_src OUT NOCOPY VARCHAR2);
536:
537: PROCEDURE get_nhs_employer
538: (p_spa_nhs_employer IN igs_he_st_spa.nhs_employer%TYPE,

Line 538: (p_spa_nhs_employer IN igs_he_st_spa.nhs_employer%TYPE,

534: p_prg_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,
535: p_hesa_nhs_fund_src OUT NOCOPY VARCHAR2);
536:
537: PROCEDURE get_nhs_employer
538: (p_spa_nhs_employer IN igs_he_st_spa.nhs_employer%TYPE,
539: p_hesa_nhs_employer OUT NOCOPY VARCHAR2);
540:
541: PROCEDURE get_qual_dets
542: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 543: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

539: p_hesa_nhs_employer OUT NOCOPY VARCHAR2);
540:
541: PROCEDURE get_qual_dets
542: (p_person_id IN igs_pe_person.person_id%TYPE,
543: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
544: p_hesa_qual IN VARCHAR2,
545: p_no_of_qual OUT NOCOPY NUMBER,
546: p_tariff_score OUT NOCOPY NUMBER);
547:

Line 553: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,

549: PROCEDURE get_module_dets
550: (p_person_id IN igs_pe_person.person_id%TYPE,
551: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
552: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
553: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,
554: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
555: p_enrl_start_dt IN DATE,
556: p_enrl_end_dt IN DATE,
557: p_offset_days IN NUMBER,

Line 564: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

560:
561: -- jbaber 25-Nov-2004 Included p_version_number for bug # 4037237
562: PROCEDURE get_mode_of_study
563: (p_person_id IN igs_pe_person.person_id%TYPE,
564: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
565: p_version_number IN igs_he_st_spa.version_number%TYPE,
566: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
567: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
568: p_susa_study_mode IN igs_he_en_susa.study_mode%TYPE,

Line 565: p_version_number IN igs_he_st_spa.version_number%TYPE,

561: -- jbaber 25-Nov-2004 Included p_version_number for bug # 4037237
562: PROCEDURE get_mode_of_study
563: (p_person_id IN igs_pe_person.person_id%TYPE,
564: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
565: p_version_number IN igs_he_st_spa.version_number%TYPE,
566: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
567: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
568: p_susa_study_mode IN igs_he_en_susa.study_mode%TYPE,
569: p_poous_study_mode IN igs_he_poous.attendance_mode%TYPE,

Line 575: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

571: p_mode_of_study OUT NOCOPY VARCHAR2);
572:
573: FUNCTION isDormant
574: (p_person_id IN igs_pe_person.person_id%TYPE,
575: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
576: p_version_number IN igs_he_st_spa.version_number%TYPE,
577: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
578: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
579: RETURN BOOLEAN;

Line 576: p_version_number IN igs_he_st_spa.version_number%TYPE,

572:
573: FUNCTION isDormant
574: (p_person_id IN igs_pe_person.person_id%TYPE,
575: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
576: p_version_number IN igs_he_st_spa.version_number%TYPE,
577: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
578: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
579: RETURN BOOLEAN;
580:

Line 590: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

586:
587: PROCEDURE limit_no_of_qual
588: (p_field_number IN NUMBER,
589: p_person_number IN igs_pe_person.person_number%TYPE,
590: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
591: p_hesa_qual IN VARCHAR2,
592: p_no_of_qual IN OUT NOCOPY NUMBER);
593:
594: PROCEDURE limit_tariff_score

Line 597: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

593:
594: PROCEDURE limit_tariff_score
595: (p_field_number IN NUMBER,
596: p_person_number IN igs_pe_person.person_number%TYPE,
597: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
598: p_hesa_qual IN VARCHAR2,
599: p_tariff_score IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE);
600:
601: PROCEDURE get_mod_prop_fte

Line 622: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE DEFAULT NULL,

618: p_pgce_class OUT NOCOPY VARCHAR2);
619:
620:
621: PROCEDURE get_commencement_dt
622: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE DEFAULT NULL,
623: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE DEFAULT NULL,
624: p_person_id IN igs_pe_person.person_id%TYPE ,
625: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
626: p_version_number IN igs_he_st_spa_all.version_number%TYPE,

Line 625: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,

621: PROCEDURE get_commencement_dt
622: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE DEFAULT NULL,
623: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE DEFAULT NULL,
624: p_person_id IN igs_pe_person.person_id%TYPE ,
625: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
626: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
627: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,
628: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE );
629:

Line 626: p_version_number IN igs_he_st_spa_all.version_number%TYPE,

622: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE DEFAULT NULL,
623: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE DEFAULT NULL,
624: p_person_id IN igs_pe_person.person_id%TYPE ,
625: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
626: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
627: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,
628: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE );
629:
630:

Line 627: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,

623: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE DEFAULT NULL,
624: p_person_id IN igs_pe_person.person_id%TYPE ,
625: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
626: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
627: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,
628: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE );
629:
630:
631: PROCEDURE get_qual_aim_sbj1

Line 632: ( p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,

628: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE );
629:
630:
631: PROCEDURE get_qual_aim_sbj1
632: ( p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,
633: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,
634: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,
635: p_oss_qualaim_sbj IN igs_he_code_values.value%TYPE,
636: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE);

Line 633: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,

629:
630:
631: PROCEDURE get_qual_aim_sbj1
632: ( p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,
633: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,
634: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,
635: p_oss_qualaim_sbj IN igs_he_code_values.value%TYPE,
636: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE);
637:

Line 634: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,

630:
631: PROCEDURE get_qual_aim_sbj1
632: ( p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,
633: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,
634: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,
635: p_oss_qualaim_sbj IN igs_he_code_values.value%TYPE,
636: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE);
637:
638:

Line 658: (p_oss_dependants IN igs_he_st_spa.dependants_cd%TYPE,

654: (p_oss_marital_status IN igs_pe_stat_v.marital_status%TYPE,
655: p_hesa_marital_status OUT NOCOPY VARCHAR2);
656:
657: PROCEDURE get_dependants
658: (p_oss_dependants IN igs_he_st_spa.dependants_cd%TYPE,
659: p_hesa_dependants OUT NOCOPY VARCHAR2);
660:
661: PROCEDURE get_enh_fund_elig
662: (p_susa_enh_fund_elig IN igs_he_en_susa.enh_fund_elig_cd%TYPE ,

Line 663: p_spa_enh_fund_elig IN igs_he_st_spa.enh_fund_elig_cd%TYPE,

659: p_hesa_dependants OUT NOCOPY VARCHAR2);
660:
661: PROCEDURE get_enh_fund_elig
662: (p_susa_enh_fund_elig IN igs_he_en_susa.enh_fund_elig_cd%TYPE ,
663: p_spa_enh_fund_elig IN igs_he_st_spa.enh_fund_elig_cd%TYPE,
664: p_hesa_enh_fund_elig OUT NOCOPY VARCHAR2);
665:
666: PROCEDURE get_learn_dif
667: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 673: (p_spa_gov_initiatives_cd IN igs_he_st_spa.gov_initiatives_cd%TYPE,

669: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
670: p_hesa_disability_type OUT NOCOPY VARCHAR2);
671:
672: PROCEDURE get_gov_init
673: (p_spa_gov_initiatives_cd IN igs_he_st_spa.gov_initiatives_cd%TYPE,
674: p_prog_gov_initiatives_cd IN igs_he_st_prog.gov_initiatives_cd%TYPE,
675: p_hesa_gov_initiatives_cd OUT NOCOPY VARCHAR2);
676:
677: PROCEDURE get_units_completed

Line 681: p_spa_units_completed IN igs_he_st_spa.units_completed%TYPE,

677: PROCEDURE get_units_completed
678: (p_person_id IN igs_pe_person.person_id%TYPE,
679: p_course_cd IN igs_ps_ver.course_cd%TYPE,
680: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
681: p_spa_units_completed IN igs_he_st_spa.units_completed%TYPE,
682: p_hesa_units_completed OUT NOCOPY VARCHAR2);
683:
684: PROCEDURE get_disadv_uplift_elig
685: (p_spa_disadv_uplift_elig_cd IN igs_he_st_spa.disadv_uplift_elig_cd%TYPE,

Line 685: (p_spa_disadv_uplift_elig_cd IN igs_he_st_spa.disadv_uplift_elig_cd%TYPE,

681: p_spa_units_completed IN igs_he_st_spa.units_completed%TYPE,
682: p_hesa_units_completed OUT NOCOPY VARCHAR2);
683:
684: PROCEDURE get_disadv_uplift_elig
685: (p_spa_disadv_uplift_elig_cd IN igs_he_st_spa.disadv_uplift_elig_cd%TYPE,
686: p_prog_disadv_uplift_elig_cd IN igs_he_st_prog.disadv_uplift_elig_cd%TYPE,
687: p_hesa_disadv_uplift_elig_cd OUT NOCOPY VARCHAR2);
688:
689: PROCEDURE get_franch_out_arr

Line 690: (p_spa_franch_out_arr_cd IN igs_he_st_spa.franch_out_arr_cd%TYPE,

686: p_prog_disadv_uplift_elig_cd IN igs_he_st_prog.disadv_uplift_elig_cd%TYPE,
687: p_hesa_disadv_uplift_elig_cd OUT NOCOPY VARCHAR2);
688:
689: PROCEDURE get_franch_out_arr
690: (p_spa_franch_out_arr_cd IN igs_he_st_spa.franch_out_arr_cd%TYPE,
691: p_prog_franch_out_arr_cd IN igs_he_st_prog.franch_out_arr_cd%TYPE,
692: p_hesa_franch_out_arr_cd OUT NOCOPY VARCHAR2);
693:
694: PROCEDURE get_employer_role

Line 695: (p_spa_employer_role_cd IN igs_he_st_spa.employer_role_cd%TYPE,

691: p_prog_franch_out_arr_cd IN igs_he_st_prog.franch_out_arr_cd%TYPE,
692: p_hesa_franch_out_arr_cd OUT NOCOPY VARCHAR2);
693:
694: PROCEDURE get_employer_role
695: (p_spa_employer_role_cd IN igs_he_st_spa.employer_role_cd%TYPE,
696: p_hesa_employer_role_cd OUT NOCOPY VARCHAR2);
697:
698: PROCEDURE get_franchise_partner
699: (p_spa_franch_partner_cd IN igs_he_st_spa.franch_partner_cd%TYPE,

Line 699: (p_spa_franch_partner_cd IN igs_he_st_spa.franch_partner_cd%TYPE,

695: (p_spa_employer_role_cd IN igs_he_st_spa.employer_role_cd%TYPE,
696: p_hesa_employer_role_cd OUT NOCOPY VARCHAR2);
697:
698: PROCEDURE get_franchise_partner
699: (p_spa_franch_partner_cd IN igs_he_st_spa.franch_partner_cd%TYPE,
700: p_hesa_franch_partner_cd OUT NOCOPY VARCHAR2);
701:
702: PROCEDURE get_welsh_speaker_ind
703: (p_person_id IN igs_pe_person.person_id%TYPE,