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_USEC_CPS

Line 13: -- in the call to igs_ps_usec_cps_pkg.insert_row

9: --vvutukur 04-Aug-2003 Enh#3045069.PSP Enh Build. Modified crsp_ins_unit_section,change_unit_section_status.
10: --jdeekoll 28-July-2003 Bug#3060697 Modified the local procedure crsp_ins_cal_rec
11: --jbegum 23-July-2003 Bug#3060693 Modified the local procedure crsp_ins_ca_rec
12: --jbegum 27-jun-2003 Bug#2930935 Added the columns ACHIEVABLE_CREDIT_POINTS,ENROLLED_CREDIT_POINTS
13: -- in the call to igs_ps_usec_cps_pkg.insert_row
14: --jbegum 16-Jun-2003 Bug#2983445 .Obsoleted the column award_title from igs_ps_award table.
15: --smvk 09-Jun-2003 Bug # 2858436. Modified the procedure crsp_ins_crs_ver.
16: --shtatiko 03-JUN-2003 Enh# 2831572, Modified crsp_ins_unit_section and crsp_ins_crs_ver
17: --Nalin Kumar 26-May-2003 Modified the call to the igs_ps_unitass_item_pkg.insert row;

Line 42: -- from igs_ps_usec_cps_pkg.insert_row call

38: --smadathi 02-May-2002 Bug 2261649. The procedure crsp_ins_unit_section modified.
39: --jbegum 19 April 02 As part of bug fix of bug #2322290 and bug#2250784
40: -- Removed the following 4 columns
41: -- BILLING_CREDIT_POINTS,BILLING_HRS,FIN_AID_CP,FIN_AID_HRS
42: -- from igs_ps_usec_cps_pkg.insert_row call
43: --prraj 14-Feb-2002 Parameter ACHIEVABLE_CREDIT_POINTS removed from call to
44: -- tbh IGS_PS_USEC_CPS_PKG Bug# 2224366
45: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_ps_val_cop.genp_val_staff_prsn
46: -- is changed to igs_ad_val_acai.genp_val_staff_prsn

Line 44: -- tbh IGS_PS_USEC_CPS_PKG Bug# 2224366

40: -- Removed the following 4 columns
41: -- BILLING_CREDIT_POINTS,BILLING_HRS,FIN_AID_CP,FIN_AID_HRS
42: -- from igs_ps_usec_cps_pkg.insert_row call
43: --prraj 14-Feb-2002 Parameter ACHIEVABLE_CREDIT_POINTS removed from call to
44: -- tbh IGS_PS_USEC_CPS_PKG Bug# 2224366
45: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_ps_val_cop.genp_val_staff_prsn
46: -- is changed to igs_ad_val_acai.genp_val_staff_prsn
47: --bayadav 19-Nov-2001 Bug no:2115430.Added column acad_perd_unit_set column in insert_orw call to IGS_PAT_OF_STUDY table
48: -- Nalin Kumar 20-Nov-2001 Added 'DEFAULT_IND' parameter to call igs_ps_award_pkg.insert_row.

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 2194: FROM igs_ps_usec_cps

2190:
2191: --7
2192: CURSOR usec_cps( p_uoo_id NUMBER) IS
2193: SELECT *
2194: FROM igs_ps_usec_cps
2195: WHERE uoo_id = p_uoo_id;
2196:
2197: --8
2198: CURSOR usec_x_grp (cp_grp_name VARCHAR2, cp_cal_type VARCHAR2, cp_seq_no NUMBER) IS

Line 3089: CURSOR cur_usec_cps_new (cp_uoo_id igs_ps_usec_cps.uoo_id%TYPE) IS

3085:
3086: -- Rollover of unit section credit points records
3087: FOR usec_cps_rec IN usec_cps(p_old_uoo_Id ) LOOP
3088: DECLARE
3089: CURSOR cur_usec_cps_new (cp_uoo_id igs_ps_usec_cps.uoo_id%TYPE) IS
3090: SELECT 'X'
3091: FROM igs_ps_usec_cps
3092: WHERE uoo_id = cp_uoo_id
3093: AND ROWNUM = 1;

Line 3091: FROM igs_ps_usec_cps

3087: FOR usec_cps_rec IN usec_cps(p_old_uoo_Id ) LOOP
3088: DECLARE
3089: CURSOR cur_usec_cps_new (cp_uoo_id igs_ps_usec_cps.uoo_id%TYPE) IS
3090: SELECT 'X'
3091: FROM igs_ps_usec_cps
3092: WHERE uoo_id = cp_uoo_id
3093: AND ROWNUM = 1;
3094: l_cur_usec_cps_new cur_usec_cps_new%ROWTYPE;
3095:

Line 3103: igs_ps_usec_cps_pkg.insert_row(

3099:
3100: OPEN cur_usec_cps_new(p_new_uoo_id);
3101: FETCH cur_usec_cps_new INTO l_cur_usec_cps_new;
3102: IF cur_usec_cps_new%NOTFOUND THEN
3103: igs_ps_usec_cps_pkg.insert_row(
3104: x_rowid => lv_rowid,
3105: x_unit_sec_credit_points_id => l_usec_cps_id,
3106: x_uoo_id => p_new_uoo_id,
3107: x_minimum_credit_points => usec_cps_rec.minimum_credit_points ,