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_FTE_CALC_PKG dependencies on IGS_AS_SU_SETATMPT

Line 58: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE ,

54:
55: PROCEDURE coo_type (p_person_id IN igs_pe_person.person_id%TYPE ,
56: p_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE,
57: p_us_version_number IN igs_en_unit_set.version_number%TYPE,
58: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE ,
59: p_coo_id IN igs_ps_ofr_opt_all.coo_id%TYPE ,
60: p_coo_type OUT NOCOPY VARCHAR2 ,
61: p_hesa_mode OUT NOCOPY VARCHAR2 ,
62: p_message OUT NOCOPY VARCHAR2 ) AS

Line 199: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE ,

195: PROCEDURE fte_type_intensity ( p_person_id IN igs_pe_person.person_id%TYPE ,
196: p_coo_id IN igs_ps_ofr_opt_all.coo_id%TYPE ,
197: p_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE ,
198: p_us_version_number IN igs_en_unit_set.version_number%TYPE ,
199: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE ,
200: P_att_prc_st_fte IN VARCHAR2,
201: p_fte_calc_type OUT NOCOPY igs_he_poous_all.fte_calc_type%TYPE ,
202: p_fte_intensity OUT NOCOPY igs_he_poous_all.fte_intensity%TYPE ,
203: p_selection_dt_from IN VARCHAR2,

Line 244: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us

240: -- jtmathew modified this cursor for end_dt selection for HE357 changes
241: -- smaddali modified this cursor to modify where caluse for selection and completion_dt for bug 2448315
242: CURSOR c_year IS
243: SELECT susa.unit_set_cd , susa.us_version_number , susa.sequence_number
244: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us
245: WHERE susa.unit_set_cd = us.unit_set_cd
246: AND susa.person_id = p_person_id
247: AND susa.course_cd = l_course_cd
248: AND susa.selection_dt IS NOT NULL

Line 275: cp_sequence_number igs_as_su_setatmpt.sequence_number%TYPE

271: c_poous_rec c_poous%ROWTYPE ;
272:
273: -- get fte calculation type set up at student unit set attempt level
274: CURSOR c_susa (cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,
275: cp_sequence_number igs_as_su_setatmpt.sequence_number%TYPE
276: )IS
277: SELECT fte_calc_type , fte_intensity
278: FROM igs_he_en_susa
279: WHERE person_id = p_person_id AND

Line 748: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,

744: -- smaddali modified this cursor to pick up acad_perd field from igs_ps_us_prenr_cfg instead of
745: -- from igs_en_susa_year_v for bug 2452785
746: CURSOR c_crs_year(cp_person_id igs_pe_person.person_id%TYPE ,
747: cp_course_cd igs_ps_ver.course_cd%TYPE,
748: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
749: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
750: SELECT usv.unit_set_cd , usv.us_version_number , usv.sequence_number,
751: us.sequence_no acad_perd, usv.selection_dt, usv.rqrmnts_complete_dt completion_dt, usv.end_dt
752: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us

Line 749: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS

745: -- from igs_en_susa_year_v for bug 2452785
746: CURSOR c_crs_year(cp_person_id igs_pe_person.person_id%TYPE ,
747: cp_course_cd igs_ps_ver.course_cd%TYPE,
748: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
749: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
750: SELECT usv.unit_set_cd , usv.us_version_number , usv.sequence_number,
751: us.sequence_no acad_perd, usv.selection_dt, usv.rqrmnts_complete_dt completion_dt, usv.end_dt
752: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us
753: WHERE usv.unit_set_cd = us.unit_set_cd

Line 752: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us

748: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
749: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
750: SELECT usv.unit_set_cd , usv.us_version_number , usv.sequence_number,
751: us.sequence_no acad_perd, usv.selection_dt, usv.rqrmnts_complete_dt completion_dt, usv.end_dt
752: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us
753: WHERE usv.unit_set_cd = us.unit_set_cd
754: AND usv.person_id = cp_person_id
755: AND usv.course_cd = cp_course_cd
756: AND usv.selection_dt IS NOT NULL

Line 771: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,

767: -- jtmathew modified this cursor to use optional cp_selection_dt parameters for HE370 changes
768: -- jtmathew created this cursor for HE357 changes
769: CURSOR c_multi_yop(cp_person_id igs_pe_person.person_id%TYPE ,
770: cp_course_cd igs_ps_ver.course_cd%TYPE,
771: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
772: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
773: SELECT usv.person_id, usv.course_cd, count(*) multi_yop_count
774: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us
775: WHERE usv.unit_set_cd = us.unit_set_cd

Line 772: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS

768: -- jtmathew created this cursor for HE357 changes
769: CURSOR c_multi_yop(cp_person_id igs_pe_person.person_id%TYPE ,
770: cp_course_cd igs_ps_ver.course_cd%TYPE,
771: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
772: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
773: SELECT usv.person_id, usv.course_cd, count(*) multi_yop_count
774: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us
775: WHERE usv.unit_set_cd = us.unit_set_cd
776: AND usv.person_id = cp_person_id

Line 774: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us

770: cp_course_cd igs_ps_ver.course_cd%TYPE,
771: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
772: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
773: SELECT usv.person_id, usv.course_cd, count(*) multi_yop_count
774: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us
775: WHERE usv.unit_set_cd = us.unit_set_cd
776: AND usv.person_id = cp_person_id
777: AND usv.course_cd = cp_course_cd
778: AND usv.selection_dt IS NOT NULL

Line 795: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,

791: -- based on yop selection, completion and end dates for HE357 changes
792: -- smaddali modified the cursor to add DISTINCT ,to eliminate duplicate records for bug 2452785
793: CURSOR c_year_cal (cp_person_id igs_pe_person.person_id%TYPE,
794: cp_course_cd igs_ps_ver.course_cd%TYPE,
795: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
796: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
797: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
798: SELECT ci.cal_type, ci.sequence_number, ci.start_dt, ci.end_dt
799: FROM igs_ca_inst ci,

Line 796: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,

792: -- smaddali modified the cursor to add DISTINCT ,to eliminate duplicate records for bug 2452785
793: CURSOR c_year_cal (cp_person_id igs_pe_person.person_id%TYPE,
794: cp_course_cd igs_ps_ver.course_cd%TYPE,
795: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
796: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
797: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
798: SELECT ci.cal_type, ci.sequence_number, ci.start_dt, ci.end_dt
799: FROM igs_ca_inst ci,
800: igs_ca_type cat,

Line 797: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS

793: CURSOR c_year_cal (cp_person_id igs_pe_person.person_id%TYPE,
794: cp_course_cd igs_ps_ver.course_cd%TYPE,
795: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
796: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
797: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
798: SELECT ci.cal_type, ci.sequence_number, ci.start_dt, ci.end_dt
799: FROM igs_ca_inst ci,
800: igs_ca_type cat,
801: igs_ca_stat cs,

Line 803: igs_as_su_setatmpt susa

799: FROM igs_ca_inst ci,
800: igs_ca_type cat,
801: igs_ca_stat cs,
802: igs_en_stdnt_ps_att_all sca,
803: igs_as_su_setatmpt susa
804: WHERE sca.person_id = susa.person_id
805: AND sca.course_cd = susa.course_cd
806: AND sca.cal_type = ci.cal_type
807: AND ci.cal_type = cat.cal_type

Line 840: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,

836: -- jtmathew modified this cursor to allow for end_dts for HE357 changes
837: -- smaddali modified this cursors where clause of selection_dt and completion_dt for bug 2448315
838: CURSOR c_year (cp_person_id igs_pe_person.person_id%TYPE,
839: cp_course_cd igs_ps_ver.course_cd%TYPE,
840: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
841: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
842: SELECT susa.unit_set_cd , susa.us_version_number , susa.sequence_number
843: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us
844: WHERE susa.unit_set_cd = us.unit_set_cd

Line 841: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS

837: -- smaddali modified this cursors where clause of selection_dt and completion_dt for bug 2448315
838: CURSOR c_year (cp_person_id igs_pe_person.person_id%TYPE,
839: cp_course_cd igs_ps_ver.course_cd%TYPE,
840: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
841: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
842: SELECT susa.unit_set_cd , susa.us_version_number , susa.sequence_number
843: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us
844: WHERE susa.unit_set_cd = us.unit_set_cd
845: AND susa.person_id = cp_person_id

Line 843: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us

839: cp_course_cd igs_ps_ver.course_cd%TYPE,
840: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
841: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
842: SELECT susa.unit_set_cd , susa.us_version_number , susa.sequence_number
843: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us
844: WHERE susa.unit_set_cd = us.unit_set_cd
845: AND susa.person_id = cp_person_id
846: AND susa.course_cd = cp_course_cd
847: AND susa.selection_dt IS NOT NULL

Line 861: cp_sequence_number igs_as_su_setatmpt.sequence_number%TYPE ) IS

857: -- in which to save the calculated fte
858: CURSOR c_susa_upd (cp_person_id igs_pe_person.person_id%TYPE ,
859: cp_course_cd igs_ps_ver.course_cd%TYPE ,
860: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,
861: cp_sequence_number igs_as_su_setatmpt.sequence_number%TYPE ) IS
862: SELECT rowid , susa.*
863: FROM igs_he_en_susa susa
864: WHERE person_id = cp_person_id AND
865: course_cd = cp_course_cd AND

Line 1163: fnd_dsql.add_text(' FROM igs_as_su_setatmpt b ');

1159: IF l_selection_dt_from IS NOT NULL THEN
1160:
1161: fnd_dsql.add_text(' AND EXISTS (');
1162: fnd_dsql.add_text(' SELECT b.person_id, b.course_cd');
1163: fnd_dsql.add_text(' FROM igs_as_su_setatmpt b ');
1164: fnd_dsql.add_text(' WHERE b.person_id = spa.person_id ');
1165: fnd_dsql.add_text(' AND b.course_cd = spa.course_cd ');
1166: fnd_dsql.add_text(' AND b.selection_dt between ');
1167: fnd_dsql.add_bind(l_selection_dt_from);