APPS.IGS_AD_BUILDING_PKG dependencies on IGS_AD_BUILDING

Line 1: PACKAGE BODY igs_ad_building_pkg AS

1: PACKAGE BODY igs_ad_building_pkg AS
2: /* $Header: IGSAIB4B.pls 115.13 2003/10/30 13:17:28 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_building_all%RowType;
5: new_references igs_ad_building_all%RowType;

Line 4: old_references igs_ad_building_all%RowType;

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

Line 5: new_references igs_ad_building_all%RowType;

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

Line 36: FROM IGS_AD_BUILDING_ALL

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

Line 177: Igs_Ad_Room_Pkg.Get_FK_Igs_Ad_Building (

173: ***************************************************************/
174:
175: BEGIN
176:
177: Igs_Ad_Room_Pkg.Get_FK_Igs_Ad_Building (
178: old_references.building_id
179: );
180:
181: Igs_Ps_Unit_Location_Pkg.Get_FK_Igs_Ad_Building (

Line 181: Igs_Ps_Unit_Location_Pkg.Get_FK_Igs_Ad_Building (

177: Igs_Ad_Room_Pkg.Get_FK_Igs_Ad_Building (
178: old_references.building_id
179: );
180:
181: Igs_Ps_Unit_Location_Pkg.Get_FK_Igs_Ad_Building (
182: old_references.building_id
183: );
184:
185: Igs_Ps_Usec_Occurs_Pkg.Get_FK_Igs_Ad_Building (

Line 185: Igs_Ps_Usec_Occurs_Pkg.Get_FK_Igs_Ad_Building (

181: Igs_Ps_Unit_Location_Pkg.Get_FK_Igs_Ad_Building (
182: old_references.building_id
183: );
184:
185: Igs_Ps_Usec_Occurs_Pkg.Get_FK_Igs_Ad_Building (
186: old_references.building_id
187: );
188:
189: igs_ps_us_unsched_cl_Pkg.Get_FK_Igs_Ad_Building (

Line 189: igs_ps_us_unsched_cl_Pkg.Get_FK_Igs_Ad_Building (

185: Igs_Ps_Usec_Occurs_Pkg.Get_FK_Igs_Ad_Building (
186: old_references.building_id
187: );
188:
189: igs_ps_us_unsched_cl_Pkg.Get_FK_Igs_Ad_Building (
190: old_references.building_id
191: );
192:
193: igs_ps_usec_occurs_pkg.get_FK_Igs_Ad_Building (

Line 193: igs_ps_usec_occurs_pkg.get_FK_Igs_Ad_Building (

189: igs_ps_us_unsched_cl_Pkg.Get_FK_Igs_Ad_Building (
190: old_references.building_id
191: );
192:
193: igs_ps_usec_occurs_pkg.get_FK_Igs_Ad_Building (
194: old_references.building_id
195: );
196:
197: END Check_Child_Existance;

Line 217: FROM igs_ad_building_all

213: ***************************************************************/
214:
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM igs_ad_building_all
218: WHERE building_id = x_building_id AND
219: closed_ind = NVL(x_closed_ind,closed_ind)
220: FOR UPDATE NOWAIT;
221:

Line 256: FROM igs_ad_building_all

252: ***************************************************************/
253:
254: CURSOR cur_rowid IS
255: SELECT rowid
256: FROM igs_ad_building_all
257: WHERE building_cd = x_building_cd
258: AND location_cd = x_location_cd AND
259: ((l_rowid is null) or (rowid <> l_rowid)) AND
260: closed_ind = NVL(x_closed_ind,closed_ind);

Line 293: FROM igs_ad_building_all

289: ***************************************************************/
290:
291: CURSOR cur_rowid IS
292: SELECT rowid
293: FROM igs_ad_building_all
294: WHERE location_cd = x_location_cd ;
295:
296: lv_rowid cur_rowid%RowType;
297:

Line 452: cursor C is select ROWID from IGS_AD_BUILDING

448:
449: (reverse chronological order - newest change first)
450: ***************************************************************/
451:
452: cursor C is select ROWID from IGS_AD_BUILDING
453: where BUILDING_ID= X_BUILDING_ID;
454:
455: X_LAST_UPDATE_DATE DATE ;
456: X_LAST_UPDATED_BY NUMBER ;

Line 493: insert into IGS_AD_BUILDING (

489: x_created_by=>X_LAST_UPDATED_BY,
490: x_last_update_date=>X_LAST_UPDATE_DATE,
491: x_last_updated_by=>X_LAST_UPDATED_BY,
492: x_last_update_login=>X_LAST_UPDATE_LOGIN);
493: insert into IGS_AD_BUILDING (
494: BUILDING_ID
495: ,LOCATION_CD
496: ,BUILDING_CD
497: ,DESCRIPTION

Line 506: IGS_AD_BUILDING_S.NEXTVAL

502: ,LAST_UPDATED_BY
503: ,LAST_UPDATE_LOGIN
504: ,ORG_ID
505: ) values (
506: IGS_AD_BUILDING_S.NEXTVAL
507: ,NEW_REFERENCES.LOCATION_CD
508: ,NEW_REFERENCES.BUILDING_CD
509: ,NEW_REFERENCES.DESCRIPTION
510: ,NEW_REFERENCES.CLOSED_IND

Line 552: from IGS_AD_BUILDING

548: LOCATION_CD
549: , BUILDING_CD
550: , DESCRIPTION
551: , CLOSED_IND
552: from IGS_AD_BUILDING
553: where ROWID = X_ROWID
554: for update nowait;
555: tlinfo c1%rowtype;
556: begin

Line 635: update IGS_AD_BUILDING_ALL set

631: x_created_by=>X_LAST_UPDATED_BY,
632: x_last_update_date=>X_LAST_UPDATE_DATE,
633: x_last_updated_by=>X_LAST_UPDATED_BY,
634: x_last_update_login=>X_LAST_UPDATE_LOGIN);
635: update IGS_AD_BUILDING_ALL set
636: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
637: BUILDING_CD = NEW_REFERENCES.BUILDING_CD,
638: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
639: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 674: cursor c1 is select ROWID from IGS_AD_BUILDING_ALL

670:
671: (reverse chronological order - newest change first)
672: ***************************************************************/
673:
674: cursor c1 is select ROWID from IGS_AD_BUILDING_ALL
675: where BUILDING_ID= X_BUILDING_ID;
676:
677: begin
678: open c1;

Line 722: delete from IGS_AD_BUILDING_ALL

718: Before_DML (
719: p_action => 'DELETE',
720: x_rowid => X_ROWID
721: );
722: delete from IGS_AD_BUILDING_ALL
723: where ROWID = X_ROWID;
724: if (sql%notfound) then
725: raise no_data_found;
726: end if;

Line 732: END igs_ad_building_pkg;

728: p_action => 'DELETE',
729: x_rowid => X_ROWID
730: );
731: end DELETE_ROW;
732: END igs_ad_building_pkg;