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_ORGUN_PRF_PKG dependencies on IGS_PS_RSV_ORGUN_PRF

Line 1: PACKAGE BODY igs_ps_rsv_orgun_prf_pkg AS

1: PACKAGE BODY igs_ps_rsv_orgun_prf_pkg AS
2: /* $Header: IGSPI1VB.pls 120.1 2005/08/18 07:16:04 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_orgun_prf%ROWTYPE;

Line 5: old_references igs_ps_rsv_orgun_prf%ROWTYPE;

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

Line 6: new_references igs_ps_rsv_orgun_prf%ROWTYPE;

2: /* $Header: IGSPI1VB.pls 120.1 2005/08/18 07:16:04 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_orgun_prf%ROWTYPE;
6: new_references igs_ps_rsv_orgun_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_ORGUN_PRF

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

Line 234: FROM igs_ps_rsv_orgun_prf

230: || (reverse chronological order - newest change first)
231: */
232: CURSOR cur_rowid IS
233: SELECT rowid
234: FROM igs_ps_rsv_orgun_prf
235: WHERE rsv_org_unit_prf_id = x_rsv_org_unit_prf_id
236: FOR UPDATE NOWAIT;
237:
238: lv_rowid cur_rowid%RowType;

Line 270: FROM igs_ps_rsv_orgun_prf

266: || (reverse chronological order - newest change first)
267: */
268: CURSOR cur_rowid IS
269: SELECT rowid
270: FROM igs_ps_rsv_orgun_prf
271: WHERE rsv_org_unit_pri_id = x_rsv_org_unit_pri_id
272: AND preference_code = x_preference_code
273: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
274:

Line 306: FROM igs_ps_rsv_orgun_prf

302: || (reverse chronological order - newest change first)
303: */
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM igs_ps_rsv_orgun_prf
307: WHERE ((rsv_org_unit_pri_id = x_rsv_org_unit_pri_id));
308:
309: lv_rowid cur_rowid%RowType;
310:

Line 340: FROM igs_ps_rsv_orgun_prf

336: || (reverse chronological order - newest change first)
337: */
338: CURSOR cur_rowid IS
339: SELECT rowid
340: FROM igs_ps_rsv_orgun_prf
341: WHERE ((preference_code = x_preference_code) AND (preference_version = x_preference_version) );
342:
343: lv_rowid cur_rowid%RowType;
344:

Line 374: FROM igs_ps_rsv_orgun_prf

370: || (reverse chronological order - newest change first)
371: */
372: CURSOR cur_rowid IS
373: SELECT rowid
374: FROM igs_ps_rsv_orgun_prf
375: WHERE ((preference_code = x_preference_code));
376:
377: lv_rowid cur_rowid%RowType;
378:

Line 409: FROM igs_ps_rsv_orgun_prf

405: || (reverse chronological order - newest change first)
406: */
407: CURSOR cur_rowid IS
408: SELECT rowid
409: FROM igs_ps_rsv_orgun_prf
410: WHERE ((preference_code = x_preference_code) AND (preference_version = x_preference_version));
411:
412: lv_rowid cur_rowid%RowType;
413:

Line 443: FROM igs_ps_rsv_orgun_prf

439: || (reverse chronological order - newest change first)
440: */
441: CURSOR cur_rowid IS
442: SELECT rowid
443: FROM igs_ps_rsv_orgun_prf
444: WHERE ((preference_code = x_preference_code));
445:
446: lv_rowid cur_rowid%RowType;
447:

Line 570: FROM igs_ps_rsv_orgun_prf

566: || (reverse chronological order - newest change first)
567: */
568: CURSOR c IS
569: SELECT rowid
570: FROM igs_ps_rsv_orgun_prf
571: WHERE rsv_org_unit_prf_id = x_rsv_org_unit_prf_id;
572:
573: x_last_update_date DATE;
574: x_last_updated_by NUMBER;

Line 598: SELECT igs_ps_rsv_orgun_prf_s.NEXTVAL

594: igs_ge_msg_stack.add;
595: app_exception.raise_exception;
596: END IF;
597:
598: SELECT igs_ps_rsv_orgun_prf_s.NEXTVAL
599: INTO x_rsv_org_unit_prf_id
600: FROM dual;
601:
602: before_dml(

Line 619: INSERT INTO igs_ps_rsv_orgun_prf (

615: x_last_updated_by => x_last_updated_by,
616: x_last_update_login => x_last_update_login
617: );
618:
619: INSERT INTO igs_ps_rsv_orgun_prf (
620: rsv_org_unit_prf_id,
621: rsv_org_unit_pri_id,
622: preference_order,
623: preference_code,

Line 685: FROM igs_ps_rsv_orgun_prf

681: preference_code,
682: preference_version,
683: percentage_reserved,
684: group_id
685: FROM igs_ps_rsv_orgun_prf
686: WHERE rowid = x_rowid
687: FOR UPDATE NOWAIT;
688:
689: tlinfo c1%ROWTYPE;

Line 786: UPDATE igs_ps_rsv_orgun_prf

782: x_last_updated_by => x_last_updated_by,
783: x_last_update_login => x_last_update_login
784: );
785:
786: UPDATE igs_ps_rsv_orgun_prf
787: SET
788: rsv_org_unit_pri_id = new_references.rsv_org_unit_pri_id,
789: preference_order = new_references.preference_order,
790: preference_code = new_references.preference_code,

Line 828: FROM igs_ps_rsv_orgun_prf

824: || (reverse chronological order - newest change first)
825: */
826: CURSOR c1 IS
827: SELECT rowid
828: FROM igs_ps_rsv_orgun_prf
829: WHERE rsv_org_unit_prf_id = x_rsv_org_unit_prf_id;
830:
831: BEGIN
832:

Line 887: DELETE FROM igs_ps_rsv_orgun_prf

883: p_action => 'DELETE',
884: x_rowid => x_rowid
885: );
886:
887: DELETE FROM igs_ps_rsv_orgun_prf
888: WHERE rowid = x_rowid;
889:
890: IF (SQL%NOTFOUND) THEN
891: RAISE NO_DATA_FOUND;

Line 897: END igs_ps_rsv_orgun_prf_pkg;

893:
894: END delete_row;
895:
896:
897: END igs_ps_rsv_orgun_prf_pkg;