APPS.IGS_FI_PRC_FEE_ASS dependencies on STANDARD

Line 883: -- Cursor to determine if a given Unit Section is Non-Standard

879: AND course_cd = cp_v_course_cd
880: AND uoo_id = cp_n_uoo_id
881: ORDER BY discontinued_dt;
882:
883: -- Cursor to determine if a given Unit Section is Non-Standard
884: CURSOR cur_non_std_usec(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
885: SELECT non_std_usec_ind
886: FROM igs_ps_unit_ofr_opt_all
887: WHERE uoo_id = cp_n_uoo_id;

Line 932: -- Determine if Unit Section is Non-Standard or not.

928: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
929: p_v_string => 'Teach Period level retention : Load not incurred for Usec, continue for'||
930: ' Uoo Id: '|| p_n_uoo_id);
931:
932: -- Determine if Unit Section is Non-Standard or not.
933: OPEN cur_non_std_usec(p_n_uoo_id);
934: FETCH cur_non_std_usec INTO l_v_non_std_usec;
935: CLOSE cur_non_std_usec;
936:

Line 938: -- If the Unit Section is Non-Standard, invoked function to determine Retention Amount

934: FETCH cur_non_std_usec INTO l_v_non_std_usec;
935: CLOSE cur_non_std_usec;
936:
937: IF (l_v_non_std_usec = 'Y') THEN
938: -- If the Unit Section is Non-Standard, invoked function to determine Retention Amount
939: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
940: p_v_string => 'Non Standard USEC - Invoking igs_fi_gen_008.get_ns_usec_retention');
941: l_n_retention_amount := igs_fi_gen_008.get_ns_usec_retention(p_n_uoo_id => p_n_uoo_id,
942: p_v_fee_type => p_fee_type,

Line 940: p_v_string => 'Non Standard USEC - Invoking igs_fi_gen_008.get_ns_usec_retention');

936:
937: IF (l_v_non_std_usec = 'Y') THEN
938: -- If the Unit Section is Non-Standard, invoked function to determine Retention Amount
939: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
940: p_v_string => 'Non Standard USEC - Invoking igs_fi_gen_008.get_ns_usec_retention');
941: l_n_retention_amount := igs_fi_gen_008.get_ns_usec_retention(p_n_uoo_id => p_n_uoo_id,
942: p_v_fee_type => p_fee_type,
943: p_d_effective_date => rec_usec_dtls.discontinued_dt,
944: p_n_diff_amount => p_n_diff_amount);

Line 970: -- If Unit Section is NOT Non-Standard, then invoke Teaching Period level retention

966: p_v_fee_trig_cat => p_v_fee_trig_cat ,
967: p_trace_on => p_trace_on);
968: END IF; -- End if for l_n_retention_amount > 0.0
969: ELSE
970: -- If Unit Section is NOT Non-Standard, then invoke Teaching Period level retention
971: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
972: p_v_string => 'Not NS - Apply Teaching Period Retention - Invoking igs_fi_gen_008.get_teach_retention');
973: l_n_retention_amount := igs_fi_gen_008.get_teach_retention(p_v_fee_cal_type => p_fee_cal_type,
974: p_n_fee_ci_sequence_number => p_fee_ci_sequence_number,