APPS.IGS_AD_ROOM_PKG dependencies on IGS_AD_ROOM_ALL

Line 4: old_references igs_ad_room_all%RowType;

1: PACKAGE BODY igs_ad_room_pkg AS
2: /* $Header: IGSAIB5B.pls 115.15 2003/10/30 13:17:31 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_room_all%RowType;
5: new_references igs_ad_room_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_room_all%RowType;

1: PACKAGE BODY igs_ad_room_pkg AS
2: /* $Header: IGSAIB5B.pls 115.15 2003/10/30 13:17:31 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_room_all%RowType;
5: new_references igs_ad_room_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGS_AD_ROOM_ALL

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

Line 228: FROM igs_ad_room_all

224: ***************************************************************/
225:
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_ad_room_all
229: WHERE room_id = x_room_id AND
230: closed_ind = NVL(x_closed_ind,closed_ind)
231: FOR UPDATE NOWAIT;
232:

Line 267: FROM igs_ad_room_all

263: ***************************************************************/
264:
265: CURSOR cur_rowid IS
266: SELECT rowid
267: FROM igs_ad_room_all
268: WHERE building_id = x_building_id AND
269: room_cd = x_room_cd AND
270: ((l_rowid is null) or (rowid <> l_rowid)) AND
271: closed_ind = NVL(x_closed_ind,closed_ind)

Line 305: FROM igs_ad_room_all

301: ***************************************************************/
302:
303: CURSOR cur_rowid IS
304: SELECT rowid
305: FROM igs_ad_room_all
306: WHERE building_id = x_building_id ;
307:
308: lv_rowid cur_rowid%RowType;
309:

Line 473: cursor C is select ROWID from IGS_AD_ROOM_ALL

469:
470: (reverse chronological order - newest change first)
471: ***************************************************************/
472:
473: cursor C is select ROWID from IGS_AD_ROOM_ALL
474: where ROOM_ID= X_ROOM_ID
475: ;
476: X_LAST_UPDATE_DATE DATE ;
477: X_LAST_UPDATED_BY NUMBER ;

Line 516: insert into IGS_AD_ROOM_ALL (

512: x_created_by=>X_LAST_UPDATED_BY,
513: x_last_update_date=>X_LAST_UPDATE_DATE,
514: x_last_updated_by=>X_LAST_UPDATED_BY,
515: x_last_update_login=>X_LAST_UPDATE_LOGIN);
516: insert into IGS_AD_ROOM_ALL (
517: ORG_ID,
518: ROOM_ID
519: ,BUILDING_ID
520: ,ROOM_CD

Line 584: from IGS_AD_ROOM_ALL

580: , DESCRIPTION
581: , PRIMARY_USE_CD
582: , CAPACITY
583: , CLOSED_IND
584: from IGS_AD_ROOM_ALL
585: where ROWID = X_ROWID
586: for update nowait;
587: tlinfo c1%rowtype;
588: begin

Line 674: update IGS_AD_ROOM_ALL set

670: x_created_by=>X_LAST_UPDATED_BY,
671: x_last_update_date=>X_LAST_UPDATE_DATE,
672: x_last_updated_by=>X_LAST_UPDATED_BY,
673: x_last_update_login=>X_LAST_UPDATE_LOGIN);
674: update IGS_AD_ROOM_ALL set
675: BUILDING_ID = NEW_REFERENCES.BUILDING_ID,
676: ROOM_CD = NEW_REFERENCES.ROOM_CD,
677: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
678: PRIMARY_USE_CD = NEW_REFERENCES.PRIMARY_USE_CD,

Line 717: cursor c1 is select ROWID from IGS_AD_ROOM_ALL

713:
714: (reverse chronological order - newest change first)
715: ***************************************************************/
716:
717: cursor c1 is select ROWID from IGS_AD_ROOM_ALL
718: where ROOM_ID= X_ROOM_ID
719: ;
720: begin
721: open c1;

Line 770: delete from IGS_AD_ROOM_ALL

766: Before_DML (
767: p_action => 'DELETE',
768: x_rowid => X_ROWID
769: );
770: delete from IGS_AD_ROOM_ALL
771: where ROWID = X_ROWID;
772: if (sql%notfound) then
773: raise no_data_found;
774: end if;