APPS.IGS_PS_RSV_UOP_PRI_PKG dependencies on IGS_PS_RSV_UOP_PRI

Line 1: PACKAGE BODY igs_ps_rsv_uop_pri_pkg AS

1: PACKAGE BODY igs_ps_rsv_uop_pri_pkg AS
2: /* $Header: IGSPI1SB.pls 115.5 2003/11/07 11:45:37 smvk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_uop_pri%ROWTYPE;

Line 5: old_references igs_ps_rsv_uop_pri%ROWTYPE;

1: PACKAGE BODY igs_ps_rsv_uop_pri_pkg AS
2: /* $Header: IGSPI1SB.pls 115.5 2003/11/07 11:45:37 smvk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_uop_pri%ROWTYPE;
6: new_references igs_ps_rsv_uop_pri%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_rsv_uop_pri%ROWTYPE;

2: /* $Header: IGSPI1SB.pls 115.5 2003/11/07 11:45:37 smvk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rsv_uop_pri%ROWTYPE;
6: new_references igs_ps_rsv_uop_pri%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_PRI

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

Line 168: FROM igs_ps_rsv_uop_pri

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

Line 207: FROM igs_ps_rsv_uop_pri

203: || (reverse chronological order - newest change first)
204: */
205: CURSOR cur_rowid IS
206: SELECT rowid
207: FROM igs_ps_rsv_uop_pri
208: WHERE unit_cd = x_unit_cd
209: AND version_number = x_version_number
210: AND calender_type = x_calender_type
211: AND ci_sequence_number = x_ci_sequence_number

Line 249: FROM igs_ps_rsv_uop_pri

245: || (reverse chronological order - newest change first)
246: */
247: CURSOR cur_rowid IS
248: SELECT rowid
249: FROM igs_ps_rsv_uop_pri
250: WHERE ((calender_type = x_cal_type) AND
251: (ci_sequence_number = x_ci_sequence_number) AND
252: (unit_cd = x_unit_cd) AND
253: (version_number = x_version_number));

Line 376: FROM igs_ps_rsv_uop_pri

372: || (reverse chronological order - newest change first)
373: */
374: CURSOR c IS
375: SELECT rowid
376: FROM igs_ps_rsv_uop_pri
377: WHERE rsv_uop_pri_id = x_rsv_uop_pri_id;
378:
379: x_last_update_date DATE;
380: x_last_updated_by NUMBER;

Line 404: SELECT igs_ps_rsv_uop_pri_s.NEXTVAL

400: igs_ge_msg_stack.add;
401: app_exception.raise_exception;
402: END IF;
403:
404: SELECT igs_ps_rsv_uop_pri_s.NEXTVAL
405: INTO x_rsv_uop_pri_id
406: FROM dual;
407:
408: before_dml(

Line 425: INSERT INTO igs_ps_rsv_uop_pri (

421: x_last_updated_by => x_last_updated_by,
422: x_last_update_login => x_last_update_login
423: );
424:
425: INSERT INTO igs_ps_rsv_uop_pri (
426: rsv_uop_pri_id,
427: unit_cd,
428: version_number,
429: calender_type,

Line 491: FROM igs_ps_rsv_uop_pri

487: calender_type,
488: ci_sequence_number,
489: priority_order,
490: priority_value
491: FROM igs_ps_rsv_uop_pri
492: WHERE rowid = x_rowid
493: FOR UPDATE NOWAIT;
494:
495: tlinfo c1%ROWTYPE;

Line 592: UPDATE igs_ps_rsv_uop_pri

588: x_last_updated_by => x_last_updated_by,
589: x_last_update_login => x_last_update_login
590: );
591:
592: UPDATE igs_ps_rsv_uop_pri
593: SET
594: unit_cd = new_references.unit_cd,
595: version_number = new_references.version_number,
596: calender_type = new_references.calender_type,

Line 634: FROM igs_ps_rsv_uop_pri

630: || (reverse chronological order - newest change first)
631: */
632: CURSOR c1 IS
633: SELECT rowid
634: FROM igs_ps_rsv_uop_pri
635: WHERE rsv_uop_pri_id = x_rsv_uop_pri_id;
636:
637: BEGIN
638:

Line 693: DELETE FROM igs_ps_rsv_uop_pri

689: p_action => 'DELETE',
690: x_rowid => x_rowid
691: );
692:
693: DELETE FROM igs_ps_rsv_uop_pri
694: WHERE rowid = x_rowid;
695:
696: IF (SQL%NOTFOUND) THEN
697: RAISE NO_DATA_FOUND;

Line 703: END igs_ps_rsv_uop_pri_pkg;

699:
700: END delete_row;
701:
702:
703: END igs_ps_rsv_uop_pri_pkg;