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.

[Home] [Help]

APPS.IGF_AP_GEN_001 dependencies on IGS_PS_VER

Line 21: CURSOR c_comm_date(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,

17: || procedure that gets the key program based on the
18: || award year. this key program will be used in calculating
19: || the course commencement date
20: */
21: CURSOR c_comm_date(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,
22: cp_version_number igs_ps_ver_all.version_number%TYPE)IS
23: SELECT commencement_dt
24: FROM igs_en_stdnt_ps_att_all
25: WHERE course_cd = cp_course_cd

Line 22: cp_version_number igs_ps_ver_all.version_number%TYPE)IS

18: || award year. this key program will be used in calculating
19: || the course commencement date
20: */
21: CURSOR c_comm_date(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,
22: cp_version_number igs_ps_ver_all.version_number%TYPE)IS
23: SELECT commencement_dt
24: FROM igs_en_stdnt_ps_att_all
25: WHERE course_cd = cp_course_cd
26: AND version_number = cp_version_number

Line 30: x_course_cd igs_ps_ver_all.course_cd%TYPE;

26: AND version_number = cp_version_number
27: AND person_id = cp_person_id;
28: l_comm_date c_comm_date%ROWTYPE;
29: l_person_id hz_parties.party_id%TYPE;
30: x_course_cd igs_ps_ver_all.course_cd%TYPE;
31: x_version_number igs_ps_ver_all.version_number%TYPE;
32: BEGIN
33: -- call igf_gr_gen.get_person_id to get the Person ID for the Base ID
34: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);

Line 31: x_version_number igs_ps_ver_all.version_number%TYPE;

27: AND person_id = cp_person_id;
28: l_comm_date c_comm_date%ROWTYPE;
29: l_person_id hz_parties.party_id%TYPE;
30: x_course_cd igs_ps_ver_all.course_cd%TYPE;
31: x_version_number igs_ps_ver_all.version_number%TYPE;
32: BEGIN
33: -- call igf_gr_gen.get_person_id to get the Person ID for the Base ID
34: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
35: -- get the key program from the get_key_program api

Line 61: CURSOR key_program_dtl_cur(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,

57: || Who When What
58: || (reverse chronological order - newest change first)
59: */
60: -- Get the details of the Key Program
61: CURSOR key_program_dtl_cur(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,
62: cp_version_number igs_ps_ver_all.version_number%TYPE) IS
63: SELECT course_cd, version_number, cal_type, location_cd, attendance_mode, attendance_type
64: FROM igs_en_stdnt_ps_att_all
65: WHERE course_cd = cp_course_cd

Line 62: cp_version_number igs_ps_ver_all.version_number%TYPE) IS

58: || (reverse chronological order - newest change first)
59: */
60: -- Get the details of the Key Program
61: CURSOR key_program_dtl_cur(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,
62: cp_version_number igs_ps_ver_all.version_number%TYPE) IS
63: SELECT course_cd, version_number, cal_type, location_cd, attendance_mode, attendance_type
64: FROM igs_en_stdnt_ps_att_all
65: WHERE course_cd = cp_course_cd
66: AND version_number = cp_version_number

Line 95: x_course_cd igs_ps_ver_all.course_cd%TYPE;

91: l_person_id VARCHAR2(20);
92: lv_course_start_dt DATE;
93: l_completion_dt DATE;
94: cp_term_enr_dtl_rec igs_en_spa_terms%ROWTYPE;
95: x_course_cd igs_ps_ver_all.course_cd%TYPE;
96: x_version_number igs_ps_ver_all.version_number%TYPE;
97:
98: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE,
99: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

Line 96: x_version_number igs_ps_ver_all.version_number%TYPE;

92: lv_course_start_dt DATE;
93: l_completion_dt DATE;
94: cp_term_enr_dtl_rec igs_en_spa_terms%ROWTYPE;
95: x_course_cd igs_ps_ver_all.course_cd%TYPE;
96: x_version_number igs_ps_ver_all.version_number%TYPE;
97:
98: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE,
99: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
100: cp_version_number igs_en_stdnt_ps_att.version_number%TYPE

Line 186: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;

182: || (reverse chronological order - newest change first)
183: */
184: l_person_id hz_parties.party_id%TYPE;
185: lv_class_standing igs_pr_class_std.class_standing%TYPE;
186: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;
187: x_version_number igs_ps_ver_all.version_number%TYPE;
188: BEGIN
189: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
190: -- get the key program from the get_key_program api

Line 187: x_version_number igs_ps_ver_all.version_number%TYPE;

183: */
184: l_person_id hz_parties.party_id%TYPE;
185: lv_class_standing igs_pr_class_std.class_standing%TYPE;
186: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;
187: x_version_number igs_ps_ver_all.version_number%TYPE;
188: BEGIN
189: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
190: -- get the key program from the get_key_program api
191: get_key_program(cp_base_id, x_key_program_course_cd, x_version_number);

Line 220: FROM igs_ps_ver

216: -- Get the Program Type
217: CURSOR Program_Type_Cur(cp_course_cd VARCHAR2,
218: cp_version_number NUMBER)IS
219: SELECT course_type enrl_program_type
220: FROM igs_ps_ver
221: WHERE course_cd = cp_course_cd
222: AND version_number = cp_version_number;
223: l_Program_Type Program_Type_Cur%ROWTYPE;
224: l_person_id hz_parties.party_id%TYPE;

Line 225: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;

221: WHERE course_cd = cp_course_cd
222: AND version_number = cp_version_number;
223: l_Program_Type Program_Type_Cur%ROWTYPE;
224: l_person_id hz_parties.party_id%TYPE;
225: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;
226: x_version_number igs_ps_ver_all.version_number%TYPE;
227: BEGIN
228: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
229: -- get the key program from the get_key_program api

Line 226: x_version_number igs_ps_ver_all.version_number%TYPE;

222: AND version_number = cp_version_number;
223: l_Program_Type Program_Type_Cur%ROWTYPE;
224: l_person_id hz_parties.party_id%TYPE;
225: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;
226: x_version_number igs_ps_ver_all.version_number%TYPE;
227: BEGIN
228: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
229: -- get the key program from the get_key_program api
230: get_key_program(cp_base_id, x_key_program_course_cd, x_version_number);

Line 498: p_program_cd OUT NOCOPY igs_ps_ver_all.course_cd%TYPE,

494: PROCEDURE get_context_data_for_term(
495: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
496: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
497: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
498: p_program_cd OUT NOCOPY igs_ps_ver_all.course_cd%TYPE,
499: p_version_num OUT NOCOPY igs_ps_ver_all.version_number%TYPE,
500: p_program_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
501: p_org_unit OUT NOCOPY igs_ps_ver_all.responsible_org_unit_cd%TYPE
502: ) IS

Line 499: p_version_num OUT NOCOPY igs_ps_ver_all.version_number%TYPE,

495: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
496: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
497: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
498: p_program_cd OUT NOCOPY igs_ps_ver_all.course_cd%TYPE,
499: p_version_num OUT NOCOPY igs_ps_ver_all.version_number%TYPE,
500: p_program_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
501: p_org_unit OUT NOCOPY igs_ps_ver_all.responsible_org_unit_cd%TYPE
502: ) IS
503: ------------------------------------------------------------------

Line 500: p_program_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,

496: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
497: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
498: p_program_cd OUT NOCOPY igs_ps_ver_all.course_cd%TYPE,
499: p_version_num OUT NOCOPY igs_ps_ver_all.version_number%TYPE,
500: p_program_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
501: p_org_unit OUT NOCOPY igs_ps_ver_all.responsible_org_unit_cd%TYPE
502: ) IS
503: ------------------------------------------------------------------
504: --Created by : ssanyal

Line 501: p_org_unit OUT NOCOPY igs_ps_ver_all.responsible_org_unit_cd%TYPE

497: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
498: p_program_cd OUT NOCOPY igs_ps_ver_all.course_cd%TYPE,
499: p_version_num OUT NOCOPY igs_ps_ver_all.version_number%TYPE,
500: p_program_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
501: p_org_unit OUT NOCOPY igs_ps_ver_all.responsible_org_unit_cd%TYPE
502: ) IS
503: ------------------------------------------------------------------
504: --Created by : ssanyal
505: --Date created: 29-Oct-2004

Line 539: cp_program_cd igs_ps_ver_all.course_cd%TYPE,

535: AND key_program_flag = 'Y';
536: l_spa_terms c_spa_terms%ROWTYPE;
537:
538: CURSOR c_prog_dtls(
539: cp_program_cd igs_ps_ver_all.course_cd%TYPE,
540: cp_version_num igs_ps_ver_all.version_number%TYPE
541: )IS
542: SELECT *
543: FROM igs_ps_ver_all

Line 540: cp_version_num igs_ps_ver_all.version_number%TYPE

536: l_spa_terms c_spa_terms%ROWTYPE;
537:
538: CURSOR c_prog_dtls(
539: cp_program_cd igs_ps_ver_all.course_cd%TYPE,
540: cp_version_num igs_ps_ver_all.version_number%TYPE
541: )IS
542: SELECT *
543: FROM igs_ps_ver_all
544: WHERE course_cd = cp_program_cd

Line 543: FROM igs_ps_ver_all

539: cp_program_cd igs_ps_ver_all.course_cd%TYPE,
540: cp_version_num igs_ps_ver_all.version_number%TYPE
541: )IS
542: SELECT *
543: FROM igs_ps_ver_all
544: WHERE course_cd = cp_program_cd
545: AND version_number = NVL(cp_version_num,version_number);
546: l_prog_dtls c_prog_dtls%ROWTYPE;
547:

Line 652: lc_program_cd igs_ps_ver_all.course_cd%TYPE;

648: --Who When What
649: --veramach 01-Nov-2004 Fixed issues with parameter order
650: --veramach 19-Nov-2004 Fixed issues with passing program version
651: -------------------------------------------------------------------
652: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
653: lc_version_num igs_ps_ver_all.version_number%TYPE;
654: lc_program_type igs_ps_ver_all.course_type%TYPE;
655: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
656:

Line 653: lc_version_num igs_ps_ver_all.version_number%TYPE;

649: --veramach 01-Nov-2004 Fixed issues with parameter order
650: --veramach 19-Nov-2004 Fixed issues with passing program version
651: -------------------------------------------------------------------
652: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
653: lc_version_num igs_ps_ver_all.version_number%TYPE;
654: lc_program_type igs_ps_ver_all.course_type%TYPE;
655: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
656:
657: BEGIN

Line 654: lc_program_type igs_ps_ver_all.course_type%TYPE;

650: --veramach 19-Nov-2004 Fixed issues with passing program version
651: -------------------------------------------------------------------
652: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
653: lc_version_num igs_ps_ver_all.version_number%TYPE;
654: lc_program_type igs_ps_ver_all.course_type%TYPE;
655: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
656:
657: BEGIN
658: get_context_data_for_term(

Line 655: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;

651: -------------------------------------------------------------------
652: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
653: lc_version_num igs_ps_ver_all.version_number%TYPE;
654: lc_program_type igs_ps_ver_all.course_type%TYPE;
655: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
656:
657: BEGIN
658: get_context_data_for_term(
659: p_base_id,

Line 740: lc_program_cd igs_ps_ver_all.course_cd%TYPE;

736: AND dainst.ci_sequence_number = cp_ci_sequence_number;
737: lc_dt_inst cur_get_dt%ROWTYPE;
738:
739: lc_derived_val DATE;
740: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
741: lc_version_num igs_ps_ver_all.version_number%TYPE;
742: lc_program_type igs_ps_ver_all.course_type%TYPE;
743: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
744:

Line 741: lc_version_num igs_ps_ver_all.version_number%TYPE;

737: lc_dt_inst cur_get_dt%ROWTYPE;
738:
739: lc_derived_val DATE;
740: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
741: lc_version_num igs_ps_ver_all.version_number%TYPE;
742: lc_program_type igs_ps_ver_all.course_type%TYPE;
743: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
744:
745: BEGIN

Line 742: lc_program_type igs_ps_ver_all.course_type%TYPE;

738:
739: lc_derived_val DATE;
740: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
741: lc_version_num igs_ps_ver_all.version_number%TYPE;
742: lc_program_type igs_ps_ver_all.course_type%TYPE;
743: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
744:
745: BEGIN
746: get_context_data_for_term(

Line 743: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;

739: lc_derived_val DATE;
740: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
741: lc_version_num igs_ps_ver_all.version_number%TYPE;
742: lc_program_type igs_ps_ver_all.course_type%TYPE;
743: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
744:
745: BEGIN
746: get_context_data_for_term(
747: p_base_id,