APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USEC_SP_FEES

Line 2111: --sarakshi 04-Nov-2003 Enh#3116171,added field billing_credit_points in igs_ps_usec_cps insert_row.Also coded logic for rolling over igs_ps_usec_sp_fees data.

2107: --sommukhe 01-SEP-2005 Bug# 4538540 , Added cursor cur_ass_item .
2108: --sarakshi 14-Sep-2004 Enh#3888835, added cursor c_rtn_us,c_rtn_us_dtl and c_fee_type_cal_exists and it's related logic (of retention rollover).
2109: --sarakshi 12-Jul-2004 Bug#3729462, Added the column DELETE_FLAG in the where clause of the cursor cur_waitlist_chk .
2110: --sarakshi 02-Jun-2004 Bug#3658126,modified cursor usec_unitass and its usage, also added cursor cur_unitassgrp_new and its usage
2111: --sarakshi 04-Nov-2003 Enh#3116171,added field billing_credit_points in igs_ps_usec_cps insert_row.Also coded logic for rolling over igs_ps_usec_sp_fees data.
2112: --sarakshi 21-oct-2003 Enh# 3052452, removed the validation related to max_auditors_allowed
2113: --schodava 17-Sep-2003 Bug # 2520994 PSP Inheritance Build
2114: -- Modified cursor wlst_pri and cursor cur_wlst_pri_new, to obsolete column UNIT_SECTION_LIMIT_WAITLIST_ID
2115: -- and use column UOO_ID instead.

Line 2308: FROM igs_ps_usec_sp_fees

2304:
2305: --23
2306: CURSOR c_usec_spl_fees (cp_uoo_id NUMBER) IS
2307: SELECT *
2308: FROM igs_ps_usec_sp_fees
2309: WHERE uoo_id = cp_uoo_id;
2310:
2311: CURSOR c_rtn_us IS
2312: SELECT a.*

Line 3969: CURSOR cur_usec_spl_fees_new(cp_n_uoo_id igs_ps_usec_sp_fees.uoo_id%TYPE,

3965: -- Rollover of unit section special fees records
3966: IF teachCalendar_tbl.EXISTS(1) THEN
3967: FOR usec_spl_fees_rec IN c_usec_spl_fees (p_old_uoo_id ) LOOP
3968: DECLARE
3969: CURSOR cur_usec_spl_fees_new(cp_n_uoo_id igs_ps_usec_sp_fees.uoo_id%TYPE,
3970: cp_c_fee_type igs_ps_usec_sp_fees.fee_type%TYPE) IS
3971: SELECT 'x'
3972: FROM igs_ps_usec_sp_fees
3973: WHERE uoo_id = cp_n_uoo_id

Line 3970: cp_c_fee_type igs_ps_usec_sp_fees.fee_type%TYPE) IS

3966: IF teachCalendar_tbl.EXISTS(1) THEN
3967: FOR usec_spl_fees_rec IN c_usec_spl_fees (p_old_uoo_id ) LOOP
3968: DECLARE
3969: CURSOR cur_usec_spl_fees_new(cp_n_uoo_id igs_ps_usec_sp_fees.uoo_id%TYPE,
3970: cp_c_fee_type igs_ps_usec_sp_fees.fee_type%TYPE) IS
3971: SELECT 'x'
3972: FROM igs_ps_usec_sp_fees
3973: WHERE uoo_id = cp_n_uoo_id
3974: AND fee_type = cp_c_fee_type

Line 3972: FROM igs_ps_usec_sp_fees

3968: DECLARE
3969: CURSOR cur_usec_spl_fees_new(cp_n_uoo_id igs_ps_usec_sp_fees.uoo_id%TYPE,
3970: cp_c_fee_type igs_ps_usec_sp_fees.fee_type%TYPE) IS
3971: SELECT 'x'
3972: FROM igs_ps_usec_sp_fees
3973: WHERE uoo_id = cp_n_uoo_id
3974: AND fee_type = cp_c_fee_type
3975: AND ROWNUM = 1;
3976: l_cur_usec_spl_fees_new cur_usec_spl_fees_new%ROWTYPE;

Line 4021: igs_ps_usec_sp_fees_pkg.insert_row (

4017:
4018: END LOOP;
4019:
4020: IF l_c_proceed THEN
4021: igs_ps_usec_sp_fees_pkg.insert_row (
4022: x_rowid => lv_rowid,
4023: x_usec_sp_fees_id => l_usec_sp_fees_id,
4024: x_uoo_id => p_new_uoo_id,
4025: x_fee_type => usec_spl_fees_rec.fee_type,