eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_PS_UNIT_FACILITY_PKG dependencies on IGS_PS_UNIT_FACILITY

Line 1: PACKAGE BODY igs_ps_unit_facility_pkg AS

1: PACKAGE BODY igs_ps_unit_facility_pkg AS
2: /* $Header: IGSPI0MB.pls 115.8 2003/03/21 07:59:22 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unit_facility%RowType;
5: new_references igs_ps_unit_facility%RowType;

Line 4: old_references igs_ps_unit_facility%RowType;

1: PACKAGE BODY igs_ps_unit_facility_pkg AS
2: /* $Header: IGSPI0MB.pls 115.8 2003/03/21 07:59:22 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unit_facility%RowType;
5: new_references igs_ps_unit_facility%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_unit_facility%RowType;

1: PACKAGE BODY igs_ps_unit_facility_pkg AS
2: /* $Header: IGSPI0MB.pls 115.8 2003/03/21 07:59:22 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unit_facility%RowType;
5: new_references igs_ps_unit_facility%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_PS_UNIT_FACILITY

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

Line 179: FROM igs_ps_unit_facility

175: ***************************************************************/
176:
177: CURSOR cur_rowid IS
178: SELECT rowid
179: FROM igs_ps_unit_facility
180: WHERE unit_media_id = x_unit_media_id
181: FOR UPDATE NOWAIT;
182:
183: lv_rowid cur_rowid%RowType;

Line 217: FROM igs_ps_unit_facility

213: ***************************************************************/
214:
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM igs_ps_unit_facility
218: WHERE media_code = x_media_code
219: AND unit_code = x_unit_code
220: AND unit_version_number = x_unit_version_number and ((l_rowid is null) or (rowid <> l_rowid))
221:

Line 254: FROM igs_ps_unit_facility

250: ***************************************************************/
251:
252: CURSOR cur_rowid IS
253: SELECT rowid
254: FROM igs_ps_unit_facility
255: WHERE media_code = x_media_code ;
256:
257: lv_rowid cur_rowid%RowType;
258:

Line 292: FROM igs_ps_unit_facility

288: ***************************************************************/
289:
290: CURSOR cur_rowid IS
291: SELECT rowid
292: FROM igs_ps_unit_facility
293: WHERE unit_code = x_unit_cd
294: AND unit_version_number = x_version_number ;
295:
296: lv_rowid cur_rowid%RowType;

Line 448: cursor C is select ROWID from IGS_PS_UNIT_FACILITY

444:
445: (reverse chronological order - newest change first)
446: ***************************************************************/
447:
448: cursor C is select ROWID from IGS_PS_UNIT_FACILITY
449: where UNIT_MEDIA_ID= X_UNIT_MEDIA_ID
450: ;
451: X_LAST_UPDATE_DATE DATE ;
452: X_LAST_UPDATED_BY NUMBER ;

Line 473: Select IGS_PS_UNIT_FACILITY_S.NEXTVAL into x_unit_media_id from dual;

469: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
470: IGS_GE_MSG_STACK.ADD;
471: app_exception.raise_exception;
472: end if;
473: Select IGS_PS_UNIT_FACILITY_S.NEXTVAL into x_unit_media_id from dual;
474: Before_DML(
475: p_action=>'INSERT',
476: x_rowid=>X_ROWID,
477: x_unit_media_id=>X_UNIT_MEDIA_ID,

Line 486: insert into IGS_PS_UNIT_FACILITY (

482: x_created_by=>X_LAST_UPDATED_BY,
483: x_last_update_date=>X_LAST_UPDATE_DATE,
484: x_last_updated_by=>X_LAST_UPDATED_BY,
485: x_last_update_login=>X_LAST_UPDATE_LOGIN);
486: insert into IGS_PS_UNIT_FACILITY (
487: UNIT_MEDIA_ID
488: ,UNIT_CODE
489: ,UNIT_VERSION_NUMBER
490: ,MEDIA_CODE

Line 539: from IGS_PS_UNIT_FACILITY

535: cursor c1 is select
536: UNIT_CODE
537: , UNIT_VERSION_NUMBER
538: , MEDIA_CODE
539: from IGS_PS_UNIT_FACILITY
540: where ROWID = X_ROWID
541: for update nowait;
542: tlinfo c1%rowtype;
543: begin

Line 619: update IGS_PS_UNIT_FACILITY set

615: x_created_by=>X_LAST_UPDATED_BY,
616: x_last_update_date=>X_LAST_UPDATE_DATE,
617: x_last_updated_by=>X_LAST_UPDATED_BY,
618: x_last_update_login=>X_LAST_UPDATE_LOGIN);
619: update IGS_PS_UNIT_FACILITY set
620: UNIT_CODE = NEW_REFERENCES.UNIT_CODE,
621: UNIT_VERSION_NUMBER = NEW_REFERENCES.UNIT_VERSION_NUMBER,
622: MEDIA_CODE = NEW_REFERENCES.MEDIA_CODE,
623: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 655: cursor c1 is select ROWID from IGS_PS_UNIT_FACILITY

651:
652: (reverse chronological order - newest change first)
653: ***************************************************************/
654:
655: cursor c1 is select ROWID from IGS_PS_UNIT_FACILITY
656: where UNIT_MEDIA_ID= X_UNIT_MEDIA_ID
657: ;
658: begin
659: open c1;

Line 700: delete from IGS_PS_UNIT_FACILITY

696: Before_DML (
697: p_action => 'DELETE',
698: x_rowid => X_ROWID
699: );
700: delete from IGS_PS_UNIT_FACILITY
701: where ROWID = X_ROWID;
702: if (sql%notfound) then
703: raise no_data_found;
704: end if;

Line 710: END igs_ps_unit_facility_pkg;

706: p_action => 'DELETE',
707: x_rowid => X_ROWID
708: );
709: end DELETE_ROW;
710: END igs_ps_unit_facility_pkg;