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_PS_GEN_001 dependencies on IGS_PS_UNIT_OFR_OPT

Line 2138: gv_new_usec_rec igs_ps_unit_ofr_opt%ROWTYPE;

2134: -- removed . The declarartion of cursors usec_rfmly and usec_pgrad removed and asscociated section
2135: -- of opening of cursor and calling the TBH of the above tables removed .The changes are as per DLD
2136: --skoppula 09-AUG-2001 Added code to rollover unit sectin account segment values.This comes as 27th cursor
2137: ---------------------------------------------------------------------------------------------------------------------
2138: gv_new_usec_rec igs_ps_unit_ofr_opt%ROWTYPE;
2139: gv_old_usec_rec igs_ps_unit_ofr_opt%ROWTYPE;
2140:
2141: -- get the old unit section values
2142: CURSOR gc_usec_old_rec IS

Line 2139: gv_old_usec_rec igs_ps_unit_ofr_opt%ROWTYPE;

2135: -- of opening of cursor and calling the TBH of the above tables removed .The changes are as per DLD
2136: --skoppula 09-AUG-2001 Added code to rollover unit sectin account segment values.This comes as 27th cursor
2137: ---------------------------------------------------------------------------------------------------------------------
2138: gv_new_usec_rec igs_ps_unit_ofr_opt%ROWTYPE;
2139: gv_old_usec_rec igs_ps_unit_ofr_opt%ROWTYPE;
2140:
2141: -- get the old unit section values
2142: CURSOR gc_usec_old_rec IS
2143: SELECT *

Line 2144: FROM igs_ps_unit_ofr_opt

2140:
2141: -- get the old unit section values
2142: CURSOR gc_usec_old_rec IS
2143: SELECT *
2144: FROM igs_ps_unit_ofr_opt
2145: WHERE uoo_id = p_old_uoo_id ;
2146:
2147: -- get the new unit section values
2148: CURSOR gc_usec_new_rec IS

Line 2150: FROM igs_ps_unit_ofr_opt

2146:
2147: -- get the new unit section values
2148: CURSOR gc_usec_new_rec IS
2149: SELECT *
2150: FROM igs_ps_unit_ofr_opt
2151: WHERE uoo_id = p_new_uoo_id ;
2152:
2153: --1
2154: CURSOR usec_occurs( p_uoo_id NUMBER ) IS

Line 2314: igs_ps_unit_ofr_opt_all b

2310:
2311: CURSOR c_rtn_us IS
2312: SELECT a.*
2313: FROM igs_ps_nsus_rtn a,
2314: igs_ps_unit_ofr_opt_all b
2315: WHERE a.uoo_id = p_old_uoo_id
2316: AND a.uoo_id = b.uoo_id
2317: AND b.non_std_usec_ind = 'Y'
2318: AND a.definition_code IN ('UNIT_SECTION','UNIT_SECTION_FEE_TYPE');

Line 2927: FROM igs_ps_unit_ofr_opt

2923:
2924: --following two cursors are added by sarakshi,bug#2332807
2925: CURSOR cur_get_parameters IS
2926: SELECT unit_cd,version_number,cal_type,ci_sequence_number
2927: FROM igs_ps_unit_ofr_opt
2928: WHERE uoo_id=p_new_uoo_id;
2929: l_cur_get_parameters cur_get_parameters%ROWTYPE;
2930:
2931: CURSOR cur_waitlist_chk(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

Line 2931: CURSOR cur_waitlist_chk(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

2927: FROM igs_ps_unit_ofr_opt
2928: WHERE uoo_id=p_new_uoo_id;
2929: l_cur_get_parameters cur_get_parameters%ROWTYPE;
2930:
2931: CURSOR cur_waitlist_chk(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2932: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2933: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
2934: cp_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE) IS
2935: SELECT waitlist_allowed

Line 2932: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

2928: WHERE uoo_id=p_new_uoo_id;
2929: l_cur_get_parameters cur_get_parameters%ROWTYPE;
2930:
2931: CURSOR cur_waitlist_chk(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2932: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2933: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
2934: cp_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE) IS
2935: SELECT waitlist_allowed
2936: FROM igs_ps_unit_ofr_pat

Line 2933: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,

2929: l_cur_get_parameters cur_get_parameters%ROWTYPE;
2930:
2931: CURSOR cur_waitlist_chk(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2932: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2933: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
2934: cp_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE) IS
2935: SELECT waitlist_allowed
2936: FROM igs_ps_unit_ofr_pat
2937: WHERE unit_cd=cp_unit_cd

Line 2934: cp_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE) IS

2930:
2931: CURSOR cur_waitlist_chk(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2932: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2933: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
2934: cp_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE) IS
2935: SELECT waitlist_allowed
2936: FROM igs_ps_unit_ofr_pat
2937: WHERE unit_cd=cp_unit_cd
2938: AND version_number=cp_version_number

Line 4222: || call of igs_ps_unit_ofr_opt_pkg.update_row .

4218: || (reverse chronological order - newest change first)
4219: || sarakshi 21-oct-2003 Enh#3052452,used function igs_ps_gen_003.enrollment_for_uoo_check for checking the
4220: || existance of record in igs_en_su_attempt rather than explicitly coding a cursor locally.
4221: || sarakshi 18-sep-2003 Enh#3052452, added new parameters relation_type,sup_uoo_id,default_enroll_flag to the
4222: || call of igs_ps_unit_ofr_opt_pkg.update_row .
4223: || vvutukur 04-Aug-2003 Enh#3045069.PSP Enh Build.Modified the calls to igs_ps_unit_ofr_opt_pkg.update_row to add
4224: || new parameter not_multiple_section_flag.
4225: */
4226:

Line 4223: || vvutukur 04-Aug-2003 Enh#3045069.PSP Enh Build.Modified the calls to igs_ps_unit_ofr_opt_pkg.update_row to add

4219: || sarakshi 21-oct-2003 Enh#3052452,used function igs_ps_gen_003.enrollment_for_uoo_check for checking the
4220: || existance of record in igs_en_su_attempt rather than explicitly coding a cursor locally.
4221: || sarakshi 18-sep-2003 Enh#3052452, added new parameters relation_type,sup_uoo_id,default_enroll_flag to the
4222: || call of igs_ps_unit_ofr_opt_pkg.update_row .
4223: || vvutukur 04-Aug-2003 Enh#3045069.PSP Enh Build.Modified the calls to igs_ps_unit_ofr_opt_pkg.update_row to add
4224: || new parameter not_multiple_section_flag.
4225: */
4226:
4227: CURSOR c_uoo_id IS

Line 4229: FROM igs_ps_unit_ofr_opt_all usec

4225: */
4226:
4227: CURSOR c_uoo_id IS
4228: SELECT usec.* ,usec.rowid
4229: FROM igs_ps_unit_ofr_opt_all usec
4230: WHERE cal_type=p_c_cal_type
4231: AND ci_sequence_number=p_n_ci_sequence_number;
4232:
4233: l_b_found BOOLEAN := FALSE;

Line 4266: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_uoo_id.rowid,

4262: p_c_message_name:='IGS_PS_STATUS_NOT_UPD_ALLOWED';
4263: RETURN;
4264: ELSE
4265: FOR l_uoo_id IN c_uoo_id LOOP
4266: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_uoo_id.rowid,
4267: x_unit_cd =>l_uoo_id.unit_cd,
4268: x_version_number =>l_uoo_id.version_number,
4269: x_cal_type =>l_uoo_id.cal_type,
4270: x_ci_sequence_number =>l_uoo_id.ci_sequence_number,

Line 4323: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_uoo_id.rowid,

4319: --to OPEN for all the unit section under the calendar instance
4320:
4321: ELSIF p_c_new_cal_status = 'ACTIVE' AND p_c_old_cal_status ='INACTIVE' THEN
4322: FOR l_uoo_id IN c_uoo_id LOOP
4323: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_uoo_id.rowid,
4324: x_unit_cd =>l_uoo_id.unit_cd,
4325: x_version_number =>l_uoo_id.version_number,
4326: x_cal_type =>l_uoo_id.cal_type,
4327: x_ci_sequence_number =>l_uoo_id.ci_sequence_number,

Line 4455: FROM igs_ps_usec_tch_resp utr,igs_ps_unit_ofr_opt_all opt

4451: )IS
4452: SELECT NVL(utr.INSTRUCTIONAL_LOAD_LAB,0) +
4453: NVL(utr.INSTRUCTIONAL_LOAD_LECTURE,0) +
4454: NVL(utr.INSTRUCTIONAL_LOAD,0) teach_wl
4455: FROM igs_ps_usec_tch_resp utr,igs_ps_unit_ofr_opt_all opt
4456: WHERE utr.instructor_id = cp_n_person_id AND
4457: utr.uoo_id = opt.uoo_id AND
4458: opt.cal_type = cp_c_cal_type AND
4459: utr.confirmed_flag = 'Y' AND