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_PROG_TRANSFER_PKG dependencies on IGS_HE_EN_SUSA

Line 47: v_hesa_en_susa_id igs_he_en_susa.hesa_en_susa_id%TYPE;

43: v_new_prg_funding_source igs_fi_fnd_src_rstn.funding_source%TYPE;
44: v_new_prg_fundability_cd igs_he_poous_all.fundability_cd%TYPE;
45:
46: -- Variables to hold final values for first record
47: v_hesa_en_susa_id igs_he_en_susa.hesa_en_susa_id%TYPE;
48: v_term_time_accom igs_he_en_susa.term_time_accom%TYPE;
49: v_study_mode igs_he_en_susa.study_mode%TYPE;
50: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;

Line 48: v_term_time_accom igs_he_en_susa.term_time_accom%TYPE;

44: v_new_prg_fundability_cd igs_he_poous_all.fundability_cd%TYPE;
45:
46: -- Variables to hold final values for first record
47: v_hesa_en_susa_id igs_he_en_susa.hesa_en_susa_id%TYPE;
48: v_term_time_accom igs_he_en_susa.term_time_accom%TYPE;
49: v_study_mode igs_he_en_susa.study_mode%TYPE;
50: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;
52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;

Line 49: v_study_mode igs_he_en_susa.study_mode%TYPE;

45:
46: -- Variables to hold final values for first record
47: v_hesa_en_susa_id igs_he_en_susa.hesa_en_susa_id%TYPE;
48: v_term_time_accom igs_he_en_susa.term_time_accom%TYPE;
49: v_study_mode igs_he_en_susa.study_mode%TYPE;
50: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;
52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;
53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;

Line 51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;

47: v_hesa_en_susa_id igs_he_en_susa.hesa_en_susa_id%TYPE;
48: v_term_time_accom igs_he_en_susa.term_time_accom%TYPE;
49: v_study_mode igs_he_en_susa.study_mode%TYPE;
50: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;
52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;
53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;
54: v_fee_band igs_he_en_susa.fee_band%TYPE;
55: v_completion_status igs_he_en_susa.completion_status%TYPE;

Line 52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;

48: v_term_time_accom igs_he_en_susa.term_time_accom%TYPE;
49: v_study_mode igs_he_en_susa.study_mode%TYPE;
50: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;
52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;
53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;
54: v_fee_band igs_he_en_susa.fee_band%TYPE;
55: v_completion_status igs_he_en_susa.completion_status%TYPE;
56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;

Line 53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;

49: v_study_mode igs_he_en_susa.study_mode%TYPE;
50: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;
52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;
53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;
54: v_fee_band igs_he_en_susa.fee_band%TYPE;
55: v_completion_status igs_he_en_susa.completion_status%TYPE;
56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;
57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;

Line 54: v_fee_band igs_he_en_susa.fee_band%TYPE;

50: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;
52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;
53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;
54: v_fee_band igs_he_en_susa.fee_band%TYPE;
55: v_completion_status igs_he_en_susa.completion_status%TYPE;
56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;
57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;
58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;

Line 55: v_completion_status igs_he_en_susa.completion_status%TYPE;

51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;
52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;
53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;
54: v_fee_band igs_he_en_susa.fee_band%TYPE;
55: v_completion_status igs_he_en_susa.completion_status%TYPE;
56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;
57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;
58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;
59: v_mark igs_he_en_susa.mark%TYPE;

Line 56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;

52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;
53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;
54: v_fee_band igs_he_en_susa.fee_band%TYPE;
55: v_completion_status igs_he_en_susa.completion_status%TYPE;
56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;
57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;
58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;
59: v_mark igs_he_en_susa.mark%TYPE;
60: v_type_of_year igs_he_en_susa.TYPE_OF_YEAR%TYPE;

Line 57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;

53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;
54: v_fee_band igs_he_en_susa.fee_band%TYPE;
55: v_completion_status igs_he_en_susa.completion_status%TYPE;
56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;
57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;
58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;
59: v_mark igs_he_en_susa.mark%TYPE;
60: v_type_of_year igs_he_en_susa.TYPE_OF_YEAR%TYPE;
61: v_fte_intensity igs_he_en_susa.fte_intensity%TYPE;

Line 58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;

54: v_fee_band igs_he_en_susa.fee_band%TYPE;
55: v_completion_status igs_he_en_susa.completion_status%TYPE;
56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;
57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;
58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;
59: v_mark igs_he_en_susa.mark%TYPE;
60: v_type_of_year igs_he_en_susa.TYPE_OF_YEAR%TYPE;
61: v_fte_intensity igs_he_en_susa.fte_intensity%TYPE;
62: v_fte_calc_type igs_he_en_susa.fte_calc_type%TYPE;

Line 59: v_mark igs_he_en_susa.mark%TYPE;

55: v_completion_status igs_he_en_susa.completion_status%TYPE;
56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;
57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;
58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;
59: v_mark igs_he_en_susa.mark%TYPE;
60: v_type_of_year igs_he_en_susa.TYPE_OF_YEAR%TYPE;
61: v_fte_intensity igs_he_en_susa.fte_intensity%TYPE;
62: v_fte_calc_type igs_he_en_susa.fte_calc_type%TYPE;
63: v_term_time_map1 igs_he_code_map_val.map1%TYPE;

Line 60: v_type_of_year igs_he_en_susa.TYPE_OF_YEAR%TYPE;

56: v_good_stand_marker igs_he_en_susa.good_stand_marker%TYPE;
57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;
58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;
59: v_mark igs_he_en_susa.mark%TYPE;
60: v_type_of_year igs_he_en_susa.TYPE_OF_YEAR%TYPE;
61: v_fte_intensity igs_he_en_susa.fte_intensity%TYPE;
62: v_fte_calc_type igs_he_en_susa.fte_calc_type%TYPE;
63: v_term_time_map1 igs_he_code_map_val.map1%TYPE;
64: v_rowid VARCHAR2(25);

Line 61: v_fte_intensity igs_he_en_susa.fte_intensity%TYPE;

57: v_complete_pyr_study_cd igs_he_en_susa.complete_pyr_study_cd%TYPE;
58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;
59: v_mark igs_he_en_susa.mark%TYPE;
60: v_type_of_year igs_he_en_susa.TYPE_OF_YEAR%TYPE;
61: v_fte_intensity igs_he_en_susa.fte_intensity%TYPE;
62: v_fte_calc_type igs_he_en_susa.fte_calc_type%TYPE;
63: v_term_time_map1 igs_he_code_map_val.map1%TYPE;
64: v_rowid VARCHAR2(25);
65: v_new_he_entrant_cd igs_he_en_susa.new_he_entrant_cd%TYPE;

Line 62: v_fte_calc_type igs_he_en_susa.fte_calc_type%TYPE;

58: v_grad_sch_grade igs_he_en_susa.grad_sch_grade%TYPE;
59: v_mark igs_he_en_susa.mark%TYPE;
60: v_type_of_year igs_he_en_susa.TYPE_OF_YEAR%TYPE;
61: v_fte_intensity igs_he_en_susa.fte_intensity%TYPE;
62: v_fte_calc_type igs_he_en_susa.fte_calc_type%TYPE;
63: v_term_time_map1 igs_he_code_map_val.map1%TYPE;
64: v_rowid VARCHAR2(25);
65: v_new_he_entrant_cd igs_he_en_susa.new_he_entrant_cd%TYPE;
66:

Line 65: v_new_he_entrant_cd igs_he_en_susa.new_he_entrant_cd%TYPE;

61: v_fte_intensity igs_he_en_susa.fte_intensity%TYPE;
62: v_fte_calc_type igs_he_en_susa.fte_calc_type%TYPE;
63: v_term_time_map1 igs_he_code_map_val.map1%TYPE;
64: v_rowid VARCHAR2(25);
65: v_new_he_entrant_cd igs_he_en_susa.new_he_entrant_cd%TYPE;
66:
67: --Variables to hold old record unique key values
68: v_u_old_version_number igs_en_stdnt_ps_att.version_number%TYPE;
69: v_u_old_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;

Line 144: FROM igs_he_en_susa

140: additional_sup_cost,
141: enh_fund_elig_cd,
142: disadv_uplift_factor,
143: year_stu
144: FROM igs_he_en_susa
145: WHERE person_id = p_person_id AND
146: course_cd = p_old_course_cd AND
147: unit_set_cd = p_old_unit_set_cd AND
148: us_version_number = p_old_us_version_number AND

Line 235: from igs_he_en_susa

231: SELECT map1
232: FROM igs_he_code_map_val
233: WHERE association_code = 'OSS_HESA_TTA_ASSOC' AND
234: map2 = (select term_time_accom
235: from igs_he_en_susa
236: where person_id = p_person_id AND
237: course_cd = p_old_course_cd AND
238: unit_set_cd = p_old_unit_set_cd AND
239: us_version_number = p_old_us_version_number);

Line 271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,

267: c_prg_grp_rec c_prg_grp%ROWTYPE ;
268: l_cont_progs BOOLEAN;
269:
270: -- Fetch the Cost Centers of the Old Program Attempt
271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,
272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*

Line 272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,

268: l_cont_progs BOOLEAN;
269:
270: -- Fetch the Cost Centers of the Old Program Attempt
271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,
272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*
276: FROM igs_he_en_susa_cc susa

Line 273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,

269:
270: -- Fetch the Cost Centers of the Old Program Attempt
271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,
272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*
276: FROM igs_he_en_susa_cc susa
277: WHERE susa.person_id = cp_person_id

Line 274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS

270: -- Fetch the Cost Centers of the Old Program Attempt
271: CURSOR old_susa_cc_dtls_cur( cp_person_id igs_he_en_susa_cc.person_id%TYPE,
272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*
276: FROM igs_he_en_susa_cc susa
277: WHERE susa.person_id = cp_person_id
278: AND susa.course_cd = cp_course_cd

Line 276: FROM igs_he_en_susa_cc susa

272: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
273: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
274: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE) IS
275: SELECT susa.*
276: FROM igs_he_en_susa_cc susa
277: WHERE susa.person_id = cp_person_id
278: AND susa.course_cd = cp_course_cd
279: AND susa.unit_set_cd = cp_unit_set_cd
280: AND susa.sequence_number = cp_sequence_number;

Line 283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,

279: AND susa.unit_set_cd = cp_unit_set_cd
280: AND susa.sequence_number = cp_sequence_number;
281:
282: -- Check whether the Cost Center record already exist in the new program attempt
283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,

Line 284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,

280: AND susa.sequence_number = cp_sequence_number;
281:
282: -- Check whether the Cost Center record already exist in the new program attempt
283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS

Line 285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,

281:
282: -- Check whether the Cost Center record already exist in the new program attempt
283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'

Line 286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,

282: -- Check whether the Cost Center record already exist in the new program attempt
283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'
290: FROM igs_he_en_susa_cc susa

Line 287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,

283: CURSOR new_susa_cc_dtls_cur(cp_person_id igs_he_en_susa_cc.person_id%TYPE,
284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'
290: FROM igs_he_en_susa_cc susa
291: WHERE susa.person_id = cp_person_id

Line 288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS

284: cp_course_cd igs_he_en_susa_cc.course_cd%TYPE,
285: cp_unit_set_cd igs_he_en_susa_cc.unit_set_cd%TYPE,
286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'
290: FROM igs_he_en_susa_cc susa
291: WHERE susa.person_id = cp_person_id
292: AND susa.course_cd = cp_course_cd

Line 290: FROM igs_he_en_susa_cc susa

286: cp_sequence_number igs_he_en_susa_cc.sequence_number%TYPE,
287: cp_cost_centre igs_he_en_susa_cc.cost_centre%TYPE,
288: cp_subject igs_he_en_susa_cc.subject%TYPE) IS
289: SELECT 'X'
290: FROM igs_he_en_susa_cc susa
291: WHERE susa.person_id = cp_person_id
292: AND susa.course_cd = cp_course_cd
293: AND susa.unit_set_cd = cp_unit_set_cd
294: AND susa.sequence_number = cp_sequence_number

Line 299: l_he_susa_cc_id igs_he_en_susa_cc.he_susa_cc_id%TYPE := NULL ;

295: AND susa.cost_centre = cp_cost_centre
296: AND susa.subject = cp_subject;
297:
298: l_rowid VARCHAR2(25) := NULL;
299: l_he_susa_cc_id igs_he_en_susa_cc.he_susa_cc_id%TYPE := NULL ;
300: l_dummy VARCHAR2(1);
301:
302: BEGIN
303:

Line 367: igs_he_en_susa_pkg.insert_row(

363: IF c_old_susa%NOTFOUND THEN
364: -- smaddali added this code instead of raising error ,for bug#2371477
365: close c_old_susa;
366: -- create the new susa hesa details record
367: igs_he_en_susa_pkg.insert_row(
368: x_rowid => v_rowid,
369: x_hesa_en_susa_id => v_hesa_en_susa_id,
370: x_person_id => p_person_id,
371: x_course_cd => p_new_course_cd,

Line 582: igs_he_en_susa_pkg.insert_row(

578: END IF;
579:
580:
581: -- INSERT Values into Record.
582: igs_he_en_susa_pkg.insert_row(
583: x_rowid => v_rowid,
584: x_hesa_en_susa_id => v_hesa_en_susa_id,
585: x_person_id => p_person_id,
586: x_course_cd => p_new_course_cd,

Line 642: -- Loop through all the records in igs_he_en_susa_cc table for the old unit set attempt

638: END IF; -- if old susa hesa details record is not found
639:
640: -- CREATE THE STUDENT SET ATTEMPT COST CENTRE RECORD
641:
642: -- Loop through all the records in igs_he_en_susa_cc table for the old unit set attempt
643: -- and insert if the record does not exist for new Unit Set Attempt
644: FOR old_susa_cc_dtls_rec IN old_susa_cc_dtls_cur( p_person_id, p_old_course_cd,
645: p_old_unit_set_cd, v_u_old_sequence_number ) LOOP
646:

Line 653: igs_he_en_susa_cc_pkg.insert_row (

649: FETCH new_susa_cc_dtls_cur INTO l_dummy;
650: IF new_susa_cc_dtls_cur%NOTFOUND THEN
651:
652: -- create the new student unit set attempt cost centre record
653: igs_he_en_susa_cc_pkg.insert_row (
654: x_rowid => l_rowid,
655: x_he_susa_cc_id => l_he_susa_cc_id,
656: x_person_id => p_person_id,
657: x_course_cd => p_new_course_cd,