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_PS_RSV_UOP_PRF_PKG dependencies on IGS_PS_RSV_UOP_PRF

Line 1: PACKAGE BODY igs_ps_rsv_uop_prf_pkg AS

1: PACKAGE BODY igs_ps_rsv_uop_prf_pkg AS
2: /* $Header: IGSPI1TB.pls 120.1 2005/08/18 07:13:28 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_uop_prf%ROWTYPE;

Line 5: old_references igs_ps_rsv_uop_prf%ROWTYPE;

1: PACKAGE BODY igs_ps_rsv_uop_prf_pkg AS
2: /* $Header: IGSPI1TB.pls 120.1 2005/08/18 07:13:28 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_uop_prf%ROWTYPE;
6: new_references igs_ps_rsv_uop_prf%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_rsv_uop_prf%ROWTYPE;

2: /* $Header: IGSPI1TB.pls 120.1 2005/08/18 07:13:28 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_uop_prf%ROWTYPE;
6: new_references igs_ps_rsv_uop_prf%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_PS_RSV_UOP_PRF

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

Line 219: FROM igs_ps_rsv_uop_prf

215: || (reverse chronological order - newest change first)
216: */
217: CURSOR cur_rowid IS
218: SELECT rowid
219: FROM igs_ps_rsv_uop_prf
220: WHERE rsv_uop_prf_id = x_rsv_uop_prf_id
221: FOR UPDATE NOWAIT;
222:
223: lv_rowid cur_rowid%RowType;

Line 255: FROM igs_ps_rsv_uop_prf

251: || (reverse chronological order - newest change first)
252: */
253: CURSOR cur_rowid IS
254: SELECT rowid
255: FROM igs_ps_rsv_uop_prf
256: WHERE rsv_uop_pri_id = x_rsv_uop_pri_id
257: AND preference_code = x_preference_code
258: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
259:

Line 291: FROM igs_ps_rsv_uop_prf

287: || (reverse chronological order - newest change first)
288: */
289: CURSOR cur_rowid IS
290: SELECT rowid
291: FROM igs_ps_rsv_uop_prf
292: WHERE ((rsv_uop_pri_id = x_rsv_uop_pri_id));
293:
294: lv_rowid cur_rowid%RowType;
295:

Line 326: FROM igs_ps_rsv_uop_prf

322: || (reverse chronological order - newest change first)
323: */
324: CURSOR cur_rowid IS
325: SELECT rowid
326: FROM igs_ps_rsv_uop_prf
327: WHERE ((preference_code = x_preference_code) AND (preference_version = x_preference_version) );
328:
329: lv_rowid cur_rowid%RowType;
330:

Line 360: FROM igs_ps_rsv_uop_prf

356: || (reverse chronological order - newest change first)
357: */
358: CURSOR cur_rowid IS
359: SELECT rowid
360: FROM igs_ps_rsv_uop_prf
361: WHERE ((preference_code = x_preference_code));
362:
363: lv_rowid cur_rowid%RowType;
364:

Line 395: FROM igs_ps_rsv_uop_prf

391: || (reverse chronological order - newest change first)
392: */
393: CURSOR cur_rowid IS
394: SELECT rowid
395: FROM igs_ps_rsv_uop_prf
396: WHERE ((preference_code = x_preference_code) AND (preference_version = x_preference_version));
397:
398: lv_rowid cur_rowid%RowType;
399:

Line 429: FROM igs_ps_rsv_uop_prf

425: || (reverse chronological order - newest change first)
426: */
427: CURSOR cur_rowid IS
428: SELECT rowid
429: FROM igs_ps_rsv_uop_prf
430: WHERE ((preference_code = x_preference_code));
431:
432: lv_rowid cur_rowid%RowType;
433:

Line 566: FROM igs_ps_rsv_uop_prf

562: || (reverse chronological order - newest change first)
563: */
564: CURSOR c IS
565: SELECT rowid
566: FROM igs_ps_rsv_uop_prf
567: WHERE rsv_uop_prf_id = x_rsv_uop_prf_id;
568:
569: x_last_update_date DATE;
570: x_last_updated_by NUMBER;

Line 594: SELECT igs_ps_rsv_uop_prf_s.NEXTVAL

590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:
594: SELECT igs_ps_rsv_uop_prf_s.NEXTVAL
595: INTO x_rsv_uop_prf_id
596: FROM dual;
597:
598: before_dml(

Line 615: INSERT INTO igs_ps_rsv_uop_prf (

611: x_last_updated_by => x_last_updated_by,
612: x_last_update_login => x_last_update_login
613: );
614:
615: INSERT INTO igs_ps_rsv_uop_prf (
616: rsv_uop_prf_id,
617: rsv_uop_pri_id,
618: preference_order,
619: preference_code,

Line 681: FROM igs_ps_rsv_uop_prf

677: preference_code,
678: preference_version,
679: percentage_reserved,
680: group_id
681: FROM igs_ps_rsv_uop_prf
682: WHERE rowid = x_rowid
683: FOR UPDATE NOWAIT;
684:
685: tlinfo c1%ROWTYPE;

Line 782: UPDATE igs_ps_rsv_uop_prf

778: x_last_updated_by => x_last_updated_by,
779: x_last_update_login => x_last_update_login
780: );
781:
782: UPDATE igs_ps_rsv_uop_prf
783: SET
784: rsv_uop_pri_id = new_references.rsv_uop_pri_id,
785: preference_order = new_references.preference_order,
786: preference_code = new_references.preference_code,

Line 824: FROM igs_ps_rsv_uop_prf

820: || (reverse chronological order - newest change first)
821: */
822: CURSOR c1 IS
823: SELECT rowid
824: FROM igs_ps_rsv_uop_prf
825: WHERE rsv_uop_prf_id = x_rsv_uop_prf_id;
826:
827: BEGIN
828:

Line 883: DELETE FROM igs_ps_rsv_uop_prf

879: p_action => 'DELETE',
880: x_rowid => x_rowid
881: );
882:
883: DELETE FROM igs_ps_rsv_uop_prf
884: WHERE rowid = x_rowid;
885:
886: IF (SQL%NOTFOUND) THEN
887: RAISE NO_DATA_FOUND;

Line 893: END igs_ps_rsv_uop_prf_pkg;

889:
890: END delete_row;
891:
892:
893: END igs_ps_rsv_uop_prf_pkg;