APPS.IGS_PS_USO_FACILITY_PKG dependencies on IGS_PS_USO_FACILITY

Line 1: PACKAGE BODY igs_ps_uso_facility_pkg AS

1: PACKAGE BODY igs_ps_uso_facility_pkg AS
2: /* $Header: IGSPI2OB.pls 120.1 2005/06/29 03:27:25 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_uso_facility%ROWTYPE;

Line 5: old_references igs_ps_uso_facility%ROWTYPE;

1: PACKAGE BODY igs_ps_uso_facility_pkg AS
2: /* $Header: IGSPI2OB.pls 120.1 2005/06/29 03:27:25 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_uso_facility%ROWTYPE;
6: new_references igs_ps_uso_facility%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_uso_facility%ROWTYPE;

2: /* $Header: IGSPI2OB.pls 120.1 2005/06/29 03:27:25 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_uso_facility%ROWTYPE;
6: new_references igs_ps_uso_facility%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_PS_USO_FACILITY

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

Line 148: FROM igs_ps_uso_facility

144: || (reverse chronological order - newest change first)
145: */
146: CURSOR cur_rowid IS
147: SELECT rowid
148: FROM igs_ps_uso_facility
149: WHERE uso_facility_id = x_uso_facility_id
150: FOR UPDATE NOWAIT;
151:
152: lv_rowid cur_rowid%RowType;

Line 184: FROM igs_ps_uso_facility

180: || (reverse chronological order - newest change first)
181: */
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM igs_ps_uso_facility
185: WHERE unit_section_occurrence_id = x_unit_section_occurrence_id
186: AND facility_code = x_facility_code
187: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
188:

Line 220: FROM igs_ps_uso_facility

216: || (reverse chronological order - newest change first)
217: */
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM igs_ps_uso_facility
221: WHERE ((unit_section_occurrence_id = x_unit_section_occurrence_id));
222:
223: lv_rowid cur_rowid%RowType;
224:

Line 255: FROM igs_ps_uso_facility

251: || (reverse chronological order - newest change first)
252: */
253: CURSOR cur_rowid IS
254: SELECT rowid
255: FROM igs_ps_uso_facility
256: WHERE ((facility_code = x_media_code));
257:
258: lv_rowid cur_rowid%RowType;
259:

Line 415: FROM igs_ps_uso_facility

411: || (reverse chronological order - newest change first)
412: */
413: CURSOR c IS
414: SELECT rowid
415: FROM igs_ps_uso_facility
416: WHERE uso_facility_id = x_uso_facility_id;
417:
418: x_last_update_date DATE;
419: x_last_updated_by NUMBER;

Line 443: SELECT igs_ps_uso_facility_s.NEXTVAL

439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442:
443: SELECT igs_ps_uso_facility_s.NEXTVAL
444: INTO x_uso_facility_id
445: FROM dual;
446:
447: before_dml(

Line 460: INSERT INTO igs_ps_uso_facility (

456: x_last_updated_by => x_last_updated_by,
457: x_last_update_login => x_last_update_login
458: );
459:
460: INSERT INTO igs_ps_uso_facility (
461: uso_facility_id,
462: unit_section_occurrence_id,
463: facility_code,
464: creation_date,

Line 514: FROM igs_ps_uso_facility

510: CURSOR c1 IS
511: SELECT
512: unit_section_occurrence_id,
513: facility_code
514: FROM igs_ps_uso_facility
515: WHERE rowid = x_rowid
516: FOR UPDATE NOWAIT;
517:
518: tlinfo c1%ROWTYPE;

Line 603: UPDATE igs_ps_uso_facility

599: x_last_updated_by => x_last_updated_by,
600: x_last_update_login => x_last_update_login
601: );
602:
603: UPDATE igs_ps_uso_facility
604: SET
605: unit_section_occurrence_id = new_references.unit_section_occurrence_id,
606: facility_code = new_references.facility_code,
607: last_update_date = x_last_update_date,

Line 641: FROM igs_ps_uso_facility

637: || (reverse chronological order - newest change first)
638: */
639: CURSOR c1 IS
640: SELECT rowid
641: FROM igs_ps_uso_facility
642: WHERE uso_facility_id = x_uso_facility_id;
643:
644: BEGIN
645:

Line 692: DELETE FROM igs_ps_uso_facility

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

Line 706: END igs_ps_uso_facility_pkg;

702:
703: END delete_row;
704:
705:
706: END igs_ps_uso_facility_pkg;