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_EN_PRC_LOAD dependencies on IGS_EN_ATD_TYPE_LOAD

Line 1350: v_attendance_type IGS_EN_ATD_TYPE_LOAD.attendance_type%TYPE;

1346: BEGIN
1347: DECLARE
1348: v_record_found BOOLEAN;
1349: v_record_count NUMBER;
1350: v_attendance_type IGS_EN_ATD_TYPE_LOAD.attendance_type%TYPE;
1351: CURSOR c_attendance_type(
1352: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
1353: cp_load_figure IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE) IS
1354: SELECT ATL.attendance_type

Line 1353: cp_load_figure IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE) IS

1349: v_record_count NUMBER;
1350: v_attendance_type IGS_EN_ATD_TYPE_LOAD.attendance_type%TYPE;
1351: CURSOR c_attendance_type(
1352: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
1353: cp_load_figure IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE) IS
1354: SELECT ATL.attendance_type
1355: FROM IGS_EN_ATD_TYPE_LOAD ATL
1356: WHERE ATL.cal_type = p_load_cal_type AND
1357: ATL.lower_enr_load_range <= p_load_figure AND

Line 1355: FROM IGS_EN_ATD_TYPE_LOAD ATL

1351: CURSOR c_attendance_type(
1352: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
1353: cp_load_figure IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE) IS
1354: SELECT ATL.attendance_type
1355: FROM IGS_EN_ATD_TYPE_LOAD ATL
1356: WHERE ATL.cal_type = p_load_cal_type AND
1357: ATL.lower_enr_load_range <= p_load_figure AND
1358: ATL.upper_enr_load_range >= p_load_figure;
1359: BEGIN

Line 1361: -- This is done by searching for an IGS_EN_ATD_TYPE_LOAD record which specifies

1357: ATL.lower_enr_load_range <= p_load_figure AND
1358: ATL.upper_enr_load_range >= p_load_figure;
1359: BEGIN
1360: -- Get the attendance type for a nominated CP load in a nominated load calendar
1361: -- This is done by searching for an IGS_EN_ATD_TYPE_LOAD record which specifies
1362: -- the load ranges for the different attendance types within the load calendar
1363: -- types. If no record is found then NULL is returned, as it is not possible to
1364: -- derive the figure.
1365: IF p_load_figure = 0 THEN

Line 1756: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,

1752:
1753: PROCEDURE enrp_get_inst_latt(p_person_id IN hz_parties.party_id%TYPE,
1754: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1755: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1756: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1757: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1758: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
1759: )
1760: AS

Line 1800: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;

1796: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1797: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1798: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1799: l_version_number igs_en_su_attempt.version_number%TYPE;
1800: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1801:
1802:
1803: --## CURSOR to get the Person number for the person id for message tokens
1804:

Line 1936: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,

1932:
1933: PROCEDURE enrp_get_inst_latt_fte(p_person_id IN hz_parties.party_id%TYPE,
1934: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1935: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1936: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1937: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1938: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
1939: )
1940: AS

Line 1971: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;

1967: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1968: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1969: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1970: l_version_number igs_en_su_attempt.version_number%TYPE;
1971: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1972:
1973: CURSOR c_active_cd(l_career VARCHAR2) IS
1974: SELECT course_cd,
1975: igs_en_spa_terms_api.get_spat_program_version(p_person_id, course_cd,

Line 2547: l_attendance igs_en_atd_type_load.attendance_type%TYPE;

2543: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2544: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2545: ) RETURN VARCHAR2 AS
2546:
2547: l_attendance igs_en_atd_type_load.attendance_type%TYPE;
2548: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;
2549: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;
2550:
2551: BEGIN

Line 2577: l_attendance igs_en_atd_type_load.attendance_type%TYPE;

2573: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2574: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2575: ) RETURN VARCHAR2 AS
2576:
2577: l_attendance igs_en_atd_type_load.attendance_type%TYPE;
2578: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;
2579: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;
2580:
2581: BEGIN