APPS.IGS_PS_MEDIA_EQUIP_PKG dependencies on IGS_PS_MEDIA_EQUIP

Line 1: PACKAGE BODY igs_ps_media_equip_pkg AS

1: PACKAGE BODY igs_ps_media_equip_pkg AS
2: /* $Header: IGSPI0DB.pls 115.9 2002/11/29 01:55:46 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_media_equip_all%RowType;
5: new_references igs_ps_media_equip_all%RowType;

Line 4: old_references igs_ps_media_equip_all%RowType;

1: PACKAGE BODY igs_ps_media_equip_pkg AS
2: /* $Header: IGSPI0DB.pls 115.9 2002/11/29 01:55:46 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_media_equip_all%RowType;
5: new_references igs_ps_media_equip_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_media_equip_all%RowType;

1: PACKAGE BODY igs_ps_media_equip_pkg AS
2: /* $Header: IGSPI0DB.pls 115.9 2002/11/29 01:55:46 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_media_equip_all%RowType;
5: new_references igs_ps_media_equip_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_PS_MEDIA_EQUIP_ALL

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

Line 123: Igs_Ps_Unit_Facility_Pkg.Get_FK_Igs_Ps_Media_Equip (

119: ***************************************************************/
120:
121: BEGIN
122:
123: Igs_Ps_Unit_Facility_Pkg.Get_FK_Igs_Ps_Media_Equip (
124: old_references.media_code
125: );
126:
127: igs_ps_uso_facility_pkg.Get_FK_Igs_Ps_Media_Equip (

Line 127: igs_ps_uso_facility_pkg.Get_FK_Igs_Ps_Media_Equip (

123: Igs_Ps_Unit_Facility_Pkg.Get_FK_Igs_Ps_Media_Equip (
124: old_references.media_code
125: );
126:
127: igs_ps_uso_facility_pkg.Get_FK_Igs_Ps_Media_Equip (
128: old_references.media_code
129: );
130:
131: END Check_Child_Existance;

Line 150: FROM igs_ps_media_equip_all

146: ***************************************************************/
147:
148: CURSOR cur_rowid IS
149: SELECT rowid
150: FROM igs_ps_media_equip_all
151: WHERE media_code = x_media_code
152: FOR UPDATE NOWAIT;
153:
154: lv_rowid cur_rowid%RowType;

Line 295: cursor C is select ROWID from IGS_PS_MEDIA_EQUIP_ALL

291:
292: (reverse chronological order - newest change first)
293: ***************************************************************/
294:
295: cursor C is select ROWID from IGS_PS_MEDIA_EQUIP_ALL
296: where MEDIA_CODE= X_MEDIA_CODE
297: ;
298: X_LAST_UPDATE_DATE DATE ;
299: X_LAST_UPDATED_BY NUMBER ;

Line 332: insert into IGS_PS_MEDIA_EQUIP (

328: x_last_update_date=>X_LAST_UPDATE_DATE,
329: x_last_updated_by=>X_LAST_UPDATED_BY,
330: x_last_update_login=>X_LAST_UPDATE_LOGIN,
331: x_org_id => igs_ge_gen_003.get_org_id);
332: insert into IGS_PS_MEDIA_EQUIP (
333: MEDIA_CODE
334: ,MEDIA_DESCRIPTION
335: ,CLOSED_IND
336: ,CREATION_DATE

Line 383: from IGS_PS_MEDIA_EQUIP_ALL

379:
380: cursor c1 is select
381: MEDIA_DESCRIPTION
382: , CLOSED_IND
383: from IGS_PS_MEDIA_EQUIP_ALL
384: where ROWID = X_ROWID
385: for update nowait;
386: tlinfo c1%rowtype;
387: begin

Line 460: update IGS_PS_MEDIA_EQUIP_ALL set

456: x_created_by=>X_LAST_UPDATED_BY,
457: x_last_update_date=>X_LAST_UPDATE_DATE,
458: x_last_updated_by=>X_LAST_UPDATED_BY,
459: x_last_update_login=>X_LAST_UPDATE_LOGIN);
460: update IGS_PS_MEDIA_EQUIP_ALL set
461: MEDIA_DESCRIPTION = NEW_REFERENCES.MEDIA_DESCRIPTION,
462: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
463: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
464: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 495: cursor c1 is select ROWID from IGS_PS_MEDIA_EQUIP_ALL

491:
492: (reverse chronological order - newest change first)
493: ***************************************************************/
494:
495: cursor c1 is select ROWID from IGS_PS_MEDIA_EQUIP_ALL
496: where MEDIA_CODE= X_MEDIA_CODE
497: ;
498: begin
499: open c1;

Line 539: delete from IGS_PS_MEDIA_EQUIP

535: Before_DML (
536: p_action => 'DELETE',
537: x_rowid => X_ROWID
538: );
539: delete from IGS_PS_MEDIA_EQUIP
540: where ROWID = X_ROWID;
541: if (sql%notfound) then
542: raise no_data_found;
543: end if;

Line 549: END igs_ps_media_equip_pkg;

545: p_action => 'DELETE',
546: x_rowid => X_ROWID
547: );
548: end DELETE_ROW;
549: END igs_ps_media_equip_pkg;