APPS.IGS_EN_ORUN_WLST_PRF_PKG dependencies on IGS_EN_ORUN_WLST_PRF

Line 1: PACKAGE BODY igs_en_orun_wlst_prf_pkg AS

1: PACKAGE BODY igs_en_orun_wlst_prf_pkg AS
2: /* $Header: IGSEI35B.pls 115.7 2002/11/28 23:40:14 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_en_orun_wlst_prf%RowType;
5: new_references igs_en_orun_wlst_prf%RowType;

Line 4: old_references igs_en_orun_wlst_prf%RowType;

1: PACKAGE BODY igs_en_orun_wlst_prf_pkg AS
2: /* $Header: IGSEI35B.pls 115.7 2002/11/28 23:40:14 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_en_orun_wlst_prf%RowType;
5: new_references igs_en_orun_wlst_prf%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_en_orun_wlst_prf%RowType;

1: PACKAGE BODY igs_en_orun_wlst_prf_pkg AS
2: /* $Header: IGSEI35B.pls 115.7 2002/11/28 23:40:14 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_en_orun_wlst_prf%RowType;
5: new_references igs_en_orun_wlst_prf%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_EN_ORUN_WLST_PRF

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

Line 140: FROM igs_en_orun_wlst_prf

136: ***************************************************************/
137:
138: CURSOR cur_rowid IS
139: SELECT rowid
140: FROM igs_en_orun_wlst_prf
141: WHERE org_unit_wlst_prf_id = x_org_unit_wlst_prf_id
142: FOR UPDATE NOWAIT;
143:
144: lv_rowid cur_rowid%RowType;

Line 176: FROM igs_en_orun_wlst_prf

172: ***************************************************************/
173:
174: CURSOR cur_rowid IS
175: SELECT rowid
176: FROM igs_en_orun_wlst_prf
177: WHERE org_unit_wlst_pri_id = x_org_unit_wlst_pri_id ;
178:
179: lv_rowid cur_rowid%RowType;
180:

Line 241: FROM igs_en_orun_wlst_prf

237: */
238:
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM igs_en_orun_wlst_prf
242: WHERE org_unit_wlst_pri_id = x_org_unit_wlst_pri_id
243: AND preference_code = x_preference_code
244: AND NVL(preference_version,'*') = NVL(x_preference_version,'*')
245: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 397: cursor C is select ROWID from IGS_EN_ORUN_WLST_PRF

393:
394: (reverse chronological order - newest change first)
395: ***************************************************************/
396:
397: cursor C is select ROWID from IGS_EN_ORUN_WLST_PRF
398: where ORG_UNIT_WLST_PRF_ID= X_ORG_UNIT_WLST_PRF_ID
399: ;
400: X_LAST_UPDATE_DATE DATE ;
401: X_LAST_UPDATED_BY NUMBER ;

Line 438: insert into IGS_EN_ORUN_WLST_PRF (

434: x_created_by=>X_LAST_UPDATED_BY,
435: x_last_update_date=>X_LAST_UPDATE_DATE,
436: x_last_updated_by=>X_LAST_UPDATED_BY,
437: x_last_update_login=>X_LAST_UPDATE_LOGIN);
438: insert into IGS_EN_ORUN_WLST_PRF (
439: ORG_UNIT_WLST_PRF_ID
440: ,ORG_UNIT_WLST_PRI_ID
441: ,PREFERENCE_ORDER
442: ,PREFERENCE_CODE

Line 495: from IGS_EN_ORUN_WLST_PRF

491: ORG_UNIT_WLST_PRI_ID
492: , PREFERENCE_ORDER
493: , PREFERENCE_CODE
494: , PREFERENCE_VERSION
495: from IGS_EN_ORUN_WLST_PRF
496: where ROWID = X_ROWID
497: for update nowait;
498: tlinfo c1%rowtype;
499: begin

Line 580: update IGS_EN_ORUN_WLST_PRF set

576: x_created_by=>X_LAST_UPDATED_BY,
577: x_last_update_date=>X_LAST_UPDATE_DATE,
578: x_last_updated_by=>X_LAST_UPDATED_BY,
579: x_last_update_login=>X_LAST_UPDATE_LOGIN);
580: update IGS_EN_ORUN_WLST_PRF set
581: ORG_UNIT_WLST_PRI_ID = NEW_REFERENCES.ORG_UNIT_WLST_PRI_ID,
582: PREFERENCE_ORDER = NEW_REFERENCES.PREFERENCE_ORDER,
583: PREFERENCE_CODE = NEW_REFERENCES.PREFERENCE_CODE,
584: PREFERENCE_VERSION = NEW_REFERENCES.PREFERENCE_VERSION,

Line 618: cursor c1 is select ROWID from IGS_EN_ORUN_WLST_PRF

614:
615: (reverse chronological order - newest change first)
616: ***************************************************************/
617:
618: cursor c1 is select ROWID from IGS_EN_ORUN_WLST_PRF
619: where ORG_UNIT_WLST_PRF_ID= X_ORG_UNIT_WLST_PRF_ID
620: ;
621: begin
622: open c1;

Line 665: delete from IGS_EN_ORUN_WLST_PRF

661: Before_DML (
662: p_action => 'DELETE',
663: x_rowid => X_ROWID
664: );
665: delete from IGS_EN_ORUN_WLST_PRF
666: where ROWID = X_ROWID;
667: if (sql%notfound) then
668: raise no_data_found;
669: end if;

Line 675: END igs_en_orun_wlst_prf_pkg;

671: p_action => 'DELETE',
672: x_rowid => X_ROWID
673: );
674: end DELETE_ROW;
675: END igs_en_orun_wlst_prf_pkg;