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_UOFR_WLST_PRF_PKG dependencies on IGS_PS_UOFR_WLST_PRF

Line 1: PACKAGE BODY igs_ps_uofr_wlst_prf_pkg AS

1: PACKAGE BODY igs_ps_uofr_wlst_prf_pkg AS
2: /* $Header: IGSPI97B.pls 120.1 2005/08/17 05:49:57 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_uofr_wlst_prf%RowType;
5: new_references igs_ps_uofr_wlst_prf%RowType;

Line 4: old_references igs_ps_uofr_wlst_prf%RowType;

1: PACKAGE BODY igs_ps_uofr_wlst_prf_pkg AS
2: /* $Header: IGSPI97B.pls 120.1 2005/08/17 05:49:57 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_uofr_wlst_prf%RowType;
5: new_references igs_ps_uofr_wlst_prf%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_uofr_wlst_prf%RowType;

1: PACKAGE BODY igs_ps_uofr_wlst_prf_pkg AS
2: /* $Header: IGSPI97B.pls 120.1 2005/08/17 05:49:57 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_uofr_wlst_prf%RowType;
5: new_references igs_ps_uofr_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_PS_UOFR_WLST_PRF

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

Line 167: FROM igs_ps_uofr_wlst_prf

163: ***************************************************************/
164:
165: CURSOR cur_rowid IS
166: SELECT rowid
167: FROM igs_ps_uofr_wlst_prf
168: WHERE unit_ofr_waitlist_pref_id = x_unit_ofr_wl_pref_id
169: FOR UPDATE NOWAIT;
170:
171: lv_rowid cur_rowid%RowType;

Line 205: FROM igs_ps_uofr_wlst_prf

201: ***************************************************************/
202:
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM igs_ps_uofr_wlst_prf
206: WHERE preference_code = x_preference_code
207: AND NVL(preference_version,-9) = NVL(x_preference_version,-9)
208: AND unit_ofr_waitlist_priority_id = x_unit_ofr_wl_priority_id and ((l_rowid is null) or (rowid <> l_rowid))
209:

Line 243: FROM igs_ps_uofr_wlst_prf

239: ***************************************************************/
240:
241: CURSOR cur_rowid IS
242: SELECT rowid
243: FROM igs_ps_uofr_wlst_prf
244: WHERE unit_ofr_waitlist_priority_id = x_unit_ofr_wl_priority_id ;
245:
246: lv_rowid cur_rowid%RowType;
247:

Line 397: cursor C is select ROWID from IGS_PS_UOFR_WLST_PRF

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

Line 422: SELECT IGS_PS_UOFR_WLST_PRF_S.NEXTVAL

418: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422: SELECT IGS_PS_UOFR_WLST_PRF_S.NEXTVAL
423: INTO X_UNIT_OFR_WL_PREF_ID
424: FROM dual;
425: Before_DML(
426: p_action=>'INSERT',

Line 438: insert into IGS_PS_UOFR_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_PS_UOFR_WLST_PRF (
439: UNIT_OFR_WAITLIST_PREF_ID
440: ,UNIT_OFR_WAITLIST_PRIORITY_ID
441: ,PREFERENCE_ORDER
442: ,PREFERENCE_CODE

Line 495: from IGS_PS_UOFR_WLST_PRF

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

Line 580: update IGS_PS_UOFR_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_PS_UOFR_WLST_PRF set
581: UNIT_OFR_WAITLIST_PRIORITY_ID = NEW_REFERENCES.UNIT_OFR_WAITLIST_PRIORITY_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_PS_UOFR_WLST_PRF

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

Line 665: delete from IGS_PS_UOFR_WLST_PRF

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

Line 675: END igs_ps_uofr_wlst_prf_pkg;

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