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_PS_USEC_CPS

Line 492: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;

488: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
489: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
490: --dummy variable to pick up audit, billing, enrolled credit points
491: --due to signature change by EN308 Billing credit hours
492: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
493: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
494: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
495:
496: CURSOR c_uooid IS

Line 493: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;

489: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
490: --dummy variable to pick up audit, billing, enrolled credit points
491: --due to signature change by EN308 Billing credit hours
492: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
493: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
494: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
495:
496: CURSOR c_uooid IS
497: SELECT sua.uoo_id,

Line 1067: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;

1063: v_calendar_load NUMBER;
1064: v_return_eftsu NUMBER;
1065: --dummy variable to pick up audit, billing, enrolled credit points
1066: --due to signature change by EN308 Billing credit hours
1067: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1068: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1069: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1070: CURSOR c_cal_type_instance( cp_cal_type IGS_CA_INST.cal_type%TYPE,
1071: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS

Line 1068: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;

1064: v_return_eftsu NUMBER;
1065: --dummy variable to pick up audit, billing, enrolled credit points
1066: --due to signature change by EN308 Billing credit hours
1067: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1068: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1069: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1070: CURSOR c_cal_type_instance( cp_cal_type IGS_CA_INST.cal_type%TYPE,
1071: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1072: SELECT CI.cal_type,

Line 1207: v_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;

1203: BEGIN
1204: DECLARE
1205: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1206: v_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1207: v_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1208: v_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
1209: v_second_percentage IGS_ST_DFT_LOAD_APPO.second_percentage%TYPE;
1210: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
1211: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

Line 1220: v_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;

1216: v_first_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1217: v_first_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1218: v_dummy_alt_cd IGS_CA_INST.alternate_code%TYPE;
1219: v_message_name VARCHAR2(30);
1220: v_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1221:
1222: CURSOR c_dflt_load_apportion(
1223: cp_acad_cal_type IGS_ST_DFT_LOAD_APPO.cal_type%TYPE,
1224: cp_acad_ci_sequence_number IGS_ST_DFT_LOAD_APPO.ci_sequence_number%TYPE,

Line 2209: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;

2205: sua.ci_sequence_number = cp_teach_seq_num;
2206:
2207: lv_sua_cp NUMBER(10) := 0;
2208: lv_return_eftsu NUMBER(10);
2209: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
2210: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
2211: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
2212: BEGIN
2213: lv_sua_cp := 0;

Line 2210: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;

2206:
2207: lv_sua_cp NUMBER(10) := 0;
2208: lv_return_eftsu NUMBER(10);
2209: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
2210: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
2211: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
2212: BEGIN
2213: lv_sua_cp := 0;
2214: FOR l_get_teach_cal_dtls IN c_get_teach_cal_dtls(p_load_cal_type,p_load_sequence_number,p_tp_sd_cut_off_date) LOOP