APPS.IGS_PS_USEC_LIM_WLST_PKG dependencies on IGS_PS_USEC_LIM_WLST

Line 1: PACKAGE BODY igs_ps_usec_lim_wlst_pkg AS

1: PACKAGE BODY igs_ps_usec_lim_wlst_pkg AS
2: /* $Header: IGSPI1LB.pls 120.2 2005/07/04 05:46:01 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_lim_wlst%RowType;
5: new_references igs_ps_usec_lim_wlst%RowType;

Line 4: old_references igs_ps_usec_lim_wlst%RowType;

1: PACKAGE BODY igs_ps_usec_lim_wlst_pkg AS
2: /* $Header: IGSPI1LB.pls 120.2 2005/07/04 05:46:01 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_lim_wlst%RowType;
5: new_references igs_ps_usec_lim_wlst%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_usec_lim_wlst%RowType;

1: PACKAGE BODY igs_ps_usec_lim_wlst_pkg AS
2: /* $Header: IGSPI1LB.pls 120.2 2005/07/04 05:46:01 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_lim_wlst%RowType;
5: new_references igs_ps_usec_lim_wlst%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 40: FROM IGS_PS_USEC_LIM_WLST

36: ***************************************************************/
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM IGS_PS_USEC_LIM_WLST
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 173: FROM igs_ps_usec_lim_wlst

169: ***************************************************************/
170:
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM igs_ps_usec_lim_wlst
174: WHERE unit_section_limit_waitlist_id = x_unit_section_limit_wlst_id
175: FOR UPDATE NOWAIT;
176:
177: lv_rowid cur_rowid%RowType;

Line 209: FROM igs_ps_usec_lim_wlst

205: ***************************************************************/
206:
207: CURSOR cur_rowid IS
208: SELECT rowid
209: FROM igs_ps_usec_lim_wlst
210: WHERE uoo_id = x_uoo_id and ((l_rowid is null) or (rowid <> l_rowid))
211:
212: ;
213: lv_rowid cur_rowid%RowType;

Line 244: FROM igs_ps_usec_lim_wlst

240: ***************************************************************/
241:
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM igs_ps_usec_lim_wlst
245: WHERE uoo_id = x_uoo_id ;
246:
247: lv_rowid cur_rowid%RowType;
248:

Line 496: cursor C is select ROWID from IGS_PS_USEC_LIM_WLST

492: (reverse chronological order - newest change first)
493: vvutukur 31-Oct-2002 Enh#2636716.Added new column max_auditors_allowed.
494: ***************************************************************/
495:
496: cursor C is select ROWID from IGS_PS_USEC_LIM_WLST
497: where UNIT_SECTION_LIMIT_WAITLIST_ID= x_unit_section_limit_wlst_id
498: ;
499: X_LAST_UPDATE_DATE DATE ;
500: X_LAST_UPDATED_BY NUMBER ;

Line 522: igs_ps_usec_lim_wlst_s.nextval

518: IGS_GE_MSG_STACK.ADD;
519: app_exception.raise_exception;
520: end if;
521: SELECT
522: igs_ps_usec_lim_wlst_s.nextval
523: INTO
524: x_unit_section_limit_wlst_id
525: FROM dual;
526: Before_DML(

Line 544: insert into IGS_PS_USEC_LIM_WLST (

540: x_created_by=>X_LAST_UPDATED_BY,
541: x_last_update_date=>X_LAST_UPDATE_DATE,
542: x_last_updated_by=>X_LAST_UPDATED_BY,
543: x_last_update_login=>X_LAST_UPDATE_LOGIN);
544: insert into IGS_PS_USEC_LIM_WLST (
545: UNIT_SECTION_LIMIT_WAITLIST_ID
546: ,UOO_ID
547: ,ENROLLMENT_EXPECTED
548: ,ENROLLMENT_MINIMUM

Line 621: FROM igs_ps_usec_lim_wlst

617: waitlist_allowed,
618: max_students_per_waitlist,
619: override_enrollment_max,
620: max_auditors_allowed
621: FROM igs_ps_usec_lim_wlst
622: WHERE rowid = x_rowid
623: FOR UPDATE NOWAIT;
624: tlinfo c1%ROWTYPE;
625: BEGIN

Line 732: update IGS_PS_USEC_LIM_WLST set

728: x_created_by =>X_LAST_UPDATED_BY,
729: x_last_update_date =>X_LAST_UPDATE_DATE,
730: x_last_updated_by =>X_LAST_UPDATED_BY,
731: x_last_update_login =>X_LAST_UPDATE_LOGIN);
732: update IGS_PS_USEC_LIM_WLST set
733: UOO_ID = NEW_REFERENCES.UOO_ID,
734: ENROLLMENT_EXPECTED = NEW_REFERENCES.ENROLLMENT_EXPECTED,
735: ENROLLMENT_MINIMUM = NEW_REFERENCES.ENROLLMENT_MINIMUM,
736: ENROLLMENT_MAXIMUM = NEW_REFERENCES.ENROLLMENT_MAXIMUM,

Line 783: FROM igs_ps_usec_lim_wlst

779: ***************************************************************/
780:
781: CURSOR c1 IS
782: SELECT rowid
783: FROM igs_ps_usec_lim_wlst
784: WHERE unit_section_limit_waitlist_id = x_unit_section_limit_wlst_id;
785:
786: BEGIN
787: OPEN c1;

Line 840: DELETE FROM igs_ps_usec_lim_wlst

836: Before_DML (
837: p_action => 'DELETE',
838: x_rowid => X_ROWID
839: );
840: DELETE FROM igs_ps_usec_lim_wlst
841: WHERE rowid = x_rowid;
842:
843: IF (sql%NOTFOUND) THEN
844: RAISE NO_DATA_FOUND;

Line 852: END igs_ps_usec_lim_wlst_pkg;

848: p_action => 'DELETE',
849: x_rowid => X_ROWID
850: );
851: END DELETE_ROW;
852: END igs_ps_usec_lim_wlst_pkg;