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.

APPS.IGS_EN_ORUN_WLST_PRI_PKG dependencies on IGS_EN_ORUN_WLST_PRI

Line 1: PACKAGE BODY igs_en_orun_wlst_pri_pkg AS

1: PACKAGE BODY igs_en_orun_wlst_pri_pkg AS
2: /* $Header: IGSEI34B.pls 115.7 2003/05/30 10:45:03 ptandon ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_en_orun_wlst_pri%RowType;
5: new_references igs_en_orun_wlst_pri%RowType;

Line 4: old_references igs_en_orun_wlst_pri%RowType;

1: PACKAGE BODY igs_en_orun_wlst_pri_pkg AS
2: /* $Header: IGSEI34B.pls 115.7 2003/05/30 10:45:03 ptandon ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_en_orun_wlst_pri%RowType;
5: new_references igs_en_orun_wlst_pri%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_en_orun_wlst_pri%RowType;

1: PACKAGE BODY igs_en_orun_wlst_pri_pkg AS
2: /* $Header: IGSEI34B.pls 115.7 2003/05/30 10:45:03 ptandon ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_en_orun_wlst_pri%RowType;
5: new_references igs_en_orun_wlst_pri%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_EN_ORUN_WLST_PRI

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

Line 172: FROM igs_en_orun_wlst_pri

168: ***************************************************************/
169:
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM igs_en_orun_wlst_pri
173: WHERE org_unit_wlst_pri_id = x_org_unit_wlst_pri_id
174: FOR UPDATE NOWAIT;
175:
176: lv_rowid cur_rowid%RowType;

Line 208: FROM igs_en_orun_wlst_pri

204: ***************************************************************/
205:
206: CURSOR cur_rowid IS
207: SELECT rowid
208: FROM igs_en_orun_wlst_pri
209: WHERE org_unit_wlst_id = x_org_unit_wlst_id ;
210:
211: lv_rowid cur_rowid%RowType;
212:

Line 233: FROM IGS_EN_ORUN_WLST_PRI

229: x_priority_value IN VARCHAR2
230: ) AS
231: CURSOR cur_rowid IS
232: SELECT ROWID
233: FROM IGS_EN_ORUN_WLST_PRI
234: WHERE priority_value = x_priority_value ;
235: lv_rowid cur_rowid%ROWTYPE;
236: BEGIN
237: OPEN cur_rowid;

Line 377: cursor C is select ROWID from IGS_EN_ORUN_WLST_PRI

373:
374: (reverse chronological order - newest change first)
375: ***************************************************************/
376:
377: cursor C is select ROWID from IGS_EN_ORUN_WLST_PRI
378: where ORG_UNIT_WLST_PRI_ID= X_ORG_UNIT_WLST_PRI_ID
379: ;
380: X_LAST_UPDATE_DATE DATE ;
381: X_LAST_UPDATED_BY NUMBER ;

Line 417: insert into IGS_EN_ORUN_WLST_PRI (

413: x_created_by=>X_LAST_UPDATED_BY,
414: x_last_update_date=>X_LAST_UPDATE_DATE,
415: x_last_updated_by=>X_LAST_UPDATED_BY,
416: x_last_update_login=>X_LAST_UPDATE_LOGIN);
417: insert into IGS_EN_ORUN_WLST_PRI (
418: ORG_UNIT_WLST_PRI_ID
419: ,ORG_UNIT_WLST_ID
420: ,PRIORITY_NUMBER
421: ,PRIORITY_VALUE

Line 470: from IGS_EN_ORUN_WLST_PRI

466: cursor c1 is select
467: ORG_UNIT_WLST_ID
468: , PRIORITY_NUMBER
469: , PRIORITY_VALUE
470: from IGS_EN_ORUN_WLST_PRI
471: where ROWID = X_ROWID
472: for update nowait;
473: tlinfo c1%rowtype;
474: begin

Line 550: update IGS_EN_ORUN_WLST_PRI set

546: x_created_by=>X_LAST_UPDATED_BY,
547: x_last_update_date=>X_LAST_UPDATE_DATE,
548: x_last_updated_by=>X_LAST_UPDATED_BY,
549: x_last_update_login=>X_LAST_UPDATE_LOGIN);
550: update IGS_EN_ORUN_WLST_PRI set
551: ORG_UNIT_WLST_ID = NEW_REFERENCES.ORG_UNIT_WLST_ID,
552: PRIORITY_NUMBER = NEW_REFERENCES.PRIORITY_NUMBER,
553: PRIORITY_VALUE = NEW_REFERENCES.PRIORITY_VALUE,
554: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 586: cursor c1 is select ROWID from IGS_EN_ORUN_WLST_PRI

582:
583: (reverse chronological order - newest change first)
584: ***************************************************************/
585:
586: cursor c1 is select ROWID from IGS_EN_ORUN_WLST_PRI
587: where ORG_UNIT_WLST_PRI_ID= X_ORG_UNIT_WLST_PRI_ID
588: ;
589: begin
590: open c1;

Line 631: delete from IGS_EN_ORUN_WLST_PRI

627: Before_DML (
628: p_action => 'DELETE',
629: x_rowid => X_ROWID
630: );
631: delete from IGS_EN_ORUN_WLST_PRI
632: where ROWID = X_ROWID;
633: if (sql%notfound) then
634: raise no_data_found;
635: end if;

Line 641: END igs_en_orun_wlst_pri_pkg;

637: p_action => 'DELETE',
638: x_rowid => X_ROWID
639: );
640: end DELETE_ROW;
641: END igs_en_orun_wlst_pri_pkg;