APPS.IGS_EN_INST_WLST_OPT_PKG dependencies on IGS_EN_INST_WLST_OPT_ALL

Line 4: old_references IGS_EN_INST_WLST_OPT_ALL%RowType;

1: PACKAGE BODY igs_en_inst_wlst_opt_pkg AS
2: /* $Header: IGSEI16B.pls 115.10 2003/09/18 03:45:11 svanukur ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_INST_WLST_OPT_ALL%RowType;
5: new_references IGS_EN_INST_WLST_OPT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_EN_INST_WLST_OPT_ALL%RowType;

1: PACKAGE BODY igs_en_inst_wlst_opt_pkg AS
2: /* $Header: IGSEI16B.pls 115.10 2003/09/18 03:45:11 svanukur ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_INST_WLST_OPT_ALL%RowType;
5: new_references IGS_EN_INST_WLST_OPT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_EN_INST_WLST_OPT_ALL

31: ***************************************************************/
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_EN_INST_WLST_OPT_ALL
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 169: FROM IGS_EN_INST_WLST_OPT_ALL

165: ***************************************************************/
166:
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM IGS_EN_INST_WLST_OPT_ALL
170: WHERE inst_waitlist_id = x_inst_waitlist_id
171: FOR UPDATE NOWAIT;
172:
173: lv_rowid cur_rowid%RowType;

Line 206: FROM IGS_EN_INST_WLST_OPT_ALL

202: ***************************************************************/
203:
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM IGS_EN_INST_WLST_OPT_ALL
207: WHERE cal_type = x_cal_type
208: and ((l_rowid is null) or (rowid <> l_rowid))
209:
210: ;

Line 243: FROM IGS_EN_INST_WLST_OPT_ALL

239: ***************************************************************/
240:
241: CURSOR cur_rowid IS
242: SELECT rowid
243: FROM IGS_EN_INST_WLST_OPT_ALL
244: WHERE cal_type = x_cal_type ;
245:
246:
247: lv_rowid cur_rowid%RowType;

Line 443: cursor C is select ROWID from IGS_EN_INST_WLST_OPT_ALL

439:
440: (reverse chronological order - newest change first)
441: ***************************************************************/
442:
443: cursor C is select ROWID from IGS_EN_INST_WLST_OPT_ALL
444: where INST_WAITLIST_ID= X_INST_WAITLIST_ID
445: ;
446: X_LAST_UPDATE_DATE DATE ;
447: X_LAST_UPDATED_BY NUMBER ;

Line 482: insert into IGS_EN_INST_WLST_OPT_ALL (

478: x_created_by=>X_LAST_UPDATED_BY,
479: x_last_update_date=>X_LAST_UPDATE_DATE,
480: x_last_updated_by=>X_LAST_UPDATED_BY,
481: x_last_update_login=>X_LAST_UPDATE_LOGIN);
482: insert into IGS_EN_INST_WLST_OPT_ALL (
483: org_id
484: ,INST_WAITLIST_ID
485: ,CAL_TYPE
486: ,WAITLIST_ALWD

Line 539: from IGS_EN_INST_WLST_OPT_ALL

535: CAL_TYPE,
536:
537: WAITLIST_ALWD
538: , SMLNES_WAITLIST_ALWD
539: from IGS_EN_INST_WLST_OPT_ALL
540: where ROWID = X_ROWID
541: for update nowait;
542: tlinfo c1%rowtype;
543: begin

Line 620: update IGS_EN_INST_WLST_OPT_ALL set

616: x_created_by=>X_LAST_UPDATED_BY,
617: x_last_update_date=>X_LAST_UPDATE_DATE,
618: x_last_updated_by=>X_LAST_UPDATED_BY,
619: x_last_update_login=>X_LAST_UPDATE_LOGIN);
620: update IGS_EN_INST_WLST_OPT_ALL set
621: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
622: WAITLIST_ALWD = NEW_REFERENCES.WAITLIST_ALWD,
623: SMLNES_WAITLIST_ALWD = NEW_REFERENCES.SMLNES_WAITLIST_ALWD,
624: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 657: cursor c1 is select ROWID from IGS_EN_INST_WLST_OPT_ALL

653:
654: (reverse chronological order - newest change first)
655: ***************************************************************/
656:
657: cursor c1 is select ROWID from IGS_EN_INST_WLST_OPT_ALL
658: where INST_WAITLIST_ID= X_INST_WAITLIST_ID
659: ;
660: begin
661: open c1;

Line 703: delete from IGS_EN_INST_WLST_OPT_ALL

699: Before_DML (
700: p_action => 'DELETE',
701: x_rowid => X_ROWID
702: );
703: delete from IGS_EN_INST_WLST_OPT_ALL
704: where ROWID = X_ROWID;
705: if (sql%notfound) then
706: raise no_data_found;
707: end if;