APPS.IGS_PS_MEDIA_EQUIP_PKG dependencies on IGS_PS_MEDIA_EQUIP_ALL

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 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 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;