APPS.IGS_PS_RSV_USEC_PRI_PKG dependencies on IGS_PS_RSV_USEC_PRI

Line 1: PACKAGE BODY igs_ps_rsv_usec_pri_pkg AS

1: PACKAGE BODY igs_ps_rsv_usec_pri_pkg AS
2: /* $Header: IGSPI1WB.pls 115.5 2003/03/24 15:00:44 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_usec_pri%ROWTYPE;

Line 5: old_references igs_ps_rsv_usec_pri%ROWTYPE;

1: PACKAGE BODY igs_ps_rsv_usec_pri_pkg AS
2: /* $Header: IGSPI1WB.pls 115.5 2003/03/24 15:00:44 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_usec_pri%ROWTYPE;
6: new_references igs_ps_rsv_usec_pri%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_rsv_usec_pri%ROWTYPE;

2: /* $Header: IGSPI1WB.pls 115.5 2003/03/24 15:00:44 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_usec_pri%ROWTYPE;
6: new_references igs_ps_rsv_usec_pri%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_PS_RSV_USEC_PRI

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

Line 148: igs_ps_rsv_usec_prf_pkg.get_fk_igs_ps_rsv_usec_pri (

144: || (reverse chronological order - newest change first)
145: */
146: BEGIN
147:
148: igs_ps_rsv_usec_prf_pkg.get_fk_igs_ps_rsv_usec_pri (
149: old_references.rsv_usec_pri_id
150: );
151:
152: END check_child_existance;

Line 169: FROM igs_ps_rsv_usec_pri

165: || (reverse chronological order - newest change first)
166: */
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM igs_ps_rsv_usec_pri
170: WHERE rsv_usec_pri_id = x_rsv_usec_pri_id
171: FOR UPDATE NOWAIT;
172:
173: lv_rowid cur_rowid%RowType;

Line 205: FROM igs_ps_rsv_usec_pri

201: || (reverse chronological order - newest change first)
202: */
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM igs_ps_rsv_usec_pri
206: WHERE uoo_id = x_uoo_id
207: AND priority_value = x_priority_value
208: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
209:

Line 241: FROM igs_ps_rsv_usec_pri

237: || (reverse chronological order - newest change first)
238: */
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM igs_ps_rsv_usec_pri
242: WHERE ((uoo_id = x_uoo_id));
243:
244: lv_rowid cur_rowid%RowType;
245:

Line 361: FROM igs_ps_rsv_usec_pri

357: || (reverse chronological order - newest change first)
358: */
359: CURSOR c IS
360: SELECT rowid
361: FROM igs_ps_rsv_usec_pri
362: WHERE rsv_usec_pri_id = x_rsv_usec_pri_id;
363:
364: x_last_update_date DATE;
365: x_last_updated_by NUMBER;

Line 389: SELECT igs_ps_rsv_usec_pri_s.NEXTVAL

385: igs_ge_msg_stack.add;
386: app_exception.raise_exception;
387: END IF;
388:
389: SELECT igs_ps_rsv_usec_pri_s.NEXTVAL
390: INTO x_rsv_usec_pri_id
391: FROM dual;
392:
393: before_dml(

Line 407: INSERT INTO igs_ps_rsv_usec_pri (

403: x_last_updated_by => x_last_updated_by,
404: x_last_update_login => x_last_update_login
405: );
406:
407: INSERT INTO igs_ps_rsv_usec_pri (
408: rsv_usec_pri_id,
409: uoo_id,
410: priority_order,
411: priority_value,

Line 461: FROM igs_ps_rsv_usec_pri

457: SELECT
458: uoo_id,
459: priority_order,
460: priority_value
461: FROM igs_ps_rsv_usec_pri
462: WHERE rowid = x_rowid
463: FOR UPDATE NOWAIT;
464:
465: tlinfo c1%ROWTYPE;

Line 553: UPDATE igs_ps_rsv_usec_pri

549: x_last_updated_by => x_last_updated_by,
550: x_last_update_login => x_last_update_login
551: );
552:
553: UPDATE igs_ps_rsv_usec_pri
554: SET
555: uoo_id = new_references.uoo_id,
556: priority_order = new_references.priority_order,
557: priority_value = new_references.priority_value,

Line 589: FROM igs_ps_rsv_usec_pri

585: || (reverse chronological order - newest change first)
586: */
587: CURSOR c1 IS
588: SELECT rowid
589: FROM igs_ps_rsv_usec_pri
590: WHERE rsv_usec_pri_id = x_rsv_usec_pri_id;
591:
592: BEGIN
593:

Line 642: DELETE FROM igs_ps_rsv_usec_pri

638: p_action => 'DELETE',
639: x_rowid => x_rowid
640: );
641:
642: DELETE FROM igs_ps_rsv_usec_pri
643: WHERE rowid = x_rowid;
644:
645: IF (SQL%NOTFOUND) THEN
646: RAISE NO_DATA_FOUND;

Line 652: END igs_ps_rsv_usec_pri_pkg;

648:
649: END delete_row;
650:
651:
652: END igs_ps_rsv_usec_pri_pkg;