APPS.IGS_EN_OR_UNIT_WLST_PKG dependencies on IGS_EN_OR_UNIT_WLST_ALL

Line 4: old_references igs_en_or_unit_wlst_all%RowType;

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

Line 5: new_references igs_en_or_unit_wlst_all%RowType;

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

Line 39: FROM IGS_EN_OR_UNIT_WLST_ALL

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

Line 233: FROM igs_en_or_unit_wlst_all

229: ***************************************************************/
230:
231: CURSOR cur_rowid IS
232: SELECT rowid
233: FROM igs_en_or_unit_wlst_all
234: WHERE org_unit_wlst_id = x_org_unit_wlst_id
235: FOR UPDATE NOWAIT;
236:
237: lv_rowid cur_rowid%RowType;

Line 271: FROM igs_en_or_unit_wlst_all

267: ***************************************************************/
268:
269: CURSOR cur_rowid IS
270: SELECT rowid
271: FROM igs_en_or_unit_wlst_all
272: WHERE cal_type = x_cal_type
273: AND org_unit_cd = x_org_unit_cd
274: AND start_dt = x_start_dt and ((l_rowid is null) or (rowid <> l_rowid))
275:

Line 309: FROM igs_en_or_unit_wlst_all

305: ***************************************************************/
306:
307: CURSOR cur_rowid IS
308: SELECT rowid
309: FROM igs_en_or_unit_wlst_all
310: WHERE org_unit_cd = x_org_unit_cd
311: AND start_dt = x_start_dt ;
312:
313: lv_rowid cur_rowid%RowType;

Line 351: FROM igs_en_or_unit_wlst_all

347: ***************************************************************/
348:
349: /* CURSOR cur_rowid IS
350: SELECT rowid
351: FROM igs_en_or_unit_wlst_all
352: WHERE cal_type = x_cal_type
353: AND sequence_number = x_sequence_number ;
354:
355: lv_rowid cur_rowid%RowType;

Line 392: FROM igs_en_or_unit_wlst_all

388: ***************************************************************/
389:
390: CURSOR cur_rowid IS
391: SELECT rowid
392: FROM igs_en_or_unit_wlst_all
393: WHERE cal_type = x_cal_type ;
394:
395:
396: lv_rowid cur_rowid%RowType;

Line 559: cursor C is select ROWID from IGS_EN_OR_UNIT_WLST_ALL

555:
556: (reverse chronological order - newest change first)
557: ***************************************************************/
558:
559: cursor C is select ROWID from IGS_EN_OR_UNIT_WLST_ALL
560: where ORG_UNIT_WLST_ID= X_ORG_UNIT_WLST_ID
561: ;
562: X_LAST_UPDATE_DATE DATE ;
563: X_LAST_UPDATED_BY NUMBER ;

Line 604: insert into IGS_EN_OR_UNIT_WLST_ALL (

600: x_last_updated_by=>X_LAST_UPDATED_BY,
601: x_last_update_login=>X_LAST_UPDATE_LOGIN,
602: x_org_id => igs_ge_gen_003.get_org_id,
603: x_closed_flag => X_CLOSED_FLAG);
604: insert into IGS_EN_OR_UNIT_WLST_ALL (
605: ORG_UNIT_WLST_ID
606: ,ORG_UNIT_CD
607: ,START_DT
608: ,CAL_TYPE

Line 675: from IGS_EN_OR_UNIT_WLST_ALL

671: , MAX_STUD_PER_WLST
672: , SMTANUS_WLST_UNIT_ENR_ALWD
673: , ASSES_CHRG_FOR_WLST_STUD
674: , CLOSED_FLAG
675: from IGS_EN_OR_UNIT_WLST_ALL
676: where ROWID = X_ROWID
677: for update nowait;
678: tlinfo c1%rowtype;
679: begin

Line 769: update IGS_EN_OR_UNIT_WLST_ALL set

765: x_last_update_date=>X_LAST_UPDATE_DATE,
766: x_last_updated_by=>X_LAST_UPDATED_BY,
767: x_last_update_login=>X_LAST_UPDATE_LOGIN,
768: x_closed_flag => X_CLOSED_FLAG);
769: update IGS_EN_OR_UNIT_WLST_ALL set
770: ORG_UNIT_CD = NEW_REFERENCES.ORG_UNIT_CD,
771: START_DT = NEW_REFERENCES.START_DT,
772: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
773: MAX_STUD_PER_WLST = NEW_REFERENCES.MAX_STUD_PER_WLST,

Line 814: cursor c1 is select ROWID from IGS_EN_OR_UNIT_WLST_ALL

810:
811: (reverse chronological order - newest change first)
812: ***************************************************************/
813:
814: cursor c1 is select ROWID from IGS_EN_OR_UNIT_WLST_ALL
815: where ORG_UNIT_WLST_ID= X_ORG_UNIT_WLST_ID
816: ;
817: begin
818: open c1;

Line 868: delete from IGS_EN_OR_UNIT_WLST_ALL

864: Before_DML (
865: p_action => 'DELETE',
866: x_rowid => X_ROWID
867: );
868: delete from IGS_EN_OR_UNIT_WLST_ALL
869: where ROWID = X_ROWID;
870: if (sql%notfound) then
871: raise no_data_found;
872: end if;