APPS.IGS_OR_INST_STAT_DTL_PKG dependencies on IGS_OR_INST_STAT_DTL

Line 1: PACKAGE BODY igs_or_inst_stat_dtl_pkg AS

1: PACKAGE BODY igs_or_inst_stat_dtl_pkg AS
2: /* $Header: IGSOI30B.pls 115.5 2003/06/24 09:25:52 pkpatel ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_inst_stat_dtl%ROWTYPE;

Line 5: old_references igs_or_inst_stat_dtl%ROWTYPE;

1: PACKAGE BODY igs_or_inst_stat_dtl_pkg AS
2: /* $Header: IGSOI30B.pls 115.5 2003/06/24 09:25:52 pkpatel ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_inst_stat_dtl%ROWTYPE;
6: new_references igs_or_inst_stat_dtl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_or_inst_stat_dtl%ROWTYPE;

2: /* $Header: IGSOI30B.pls 115.5 2003/06/24 09:25:52 pkpatel ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_inst_stat_dtl%ROWTYPE;
6: new_references igs_or_inst_stat_dtl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_OR_INST_STAT_DTL

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

Line 139: FROM igs_or_inst_stat_dtl

135: || (reverse chronological order - newest change first)
136: */
137: CURSOR cur_rowid IS
138: SELECT rowid
139: FROM igs_or_inst_stat_dtl
140: WHERE inst_stat_dtl_id = x_inst_stat_dtl_id
141: FOR UPDATE NOWAIT;
142:
143: lv_rowid cur_rowid%RowType;

Line 175: FROM igs_or_inst_stat_dtl

171: || (reverse chronological order - newest change first)
172: */
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM igs_or_inst_stat_dtl
176: WHERE inst_stat_id = x_inst_stat_id
177: AND year = x_year
178: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
179:

Line 211: FROM igs_or_inst_stat_dtl

207: || (reverse chronological order - newest change first)
208: */
209: CURSOR cur_rowid IS
210: SELECT rowid
211: FROM igs_or_inst_stat_dtl
212: WHERE ((inst_stat_id = x_inst_stat_id));
213:
214: lv_rowid cur_rowid%RowType;
215:

Line 328: FROM igs_or_inst_stat_dtl

324: || (reverse chronological order - newest change first)
325: */
326: CURSOR c IS
327: SELECT rowid
328: FROM igs_or_inst_stat_dtl
329: WHERE inst_stat_dtl_id = x_inst_stat_dtl_id;
330:
331: x_last_update_date DATE;
332: x_last_updated_by NUMBER;

Line 372: SELECT igs_or_inst_stat_dtl_s.NEXTVAL

368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END IF;
371:
372: SELECT igs_or_inst_stat_dtl_s.NEXTVAL
373: INTO x_inst_stat_dtl_id
374: FROM dual;
375:
376: before_dml(

Line 390: INSERT INTO igs_or_inst_stat_dtl (

386: x_last_updated_by => x_last_updated_by,
387: x_last_update_login => x_last_update_login
388: );
389:
390: INSERT INTO igs_or_inst_stat_dtl (
391: inst_stat_dtl_id,
392: inst_stat_id,
393: year,
394: value,

Line 452: FROM igs_or_inst_stat_dtl

448: SELECT
449: inst_stat_id,
450: year,
451: value
452: FROM igs_or_inst_stat_dtl
453: WHERE rowid = x_rowid
454: FOR UPDATE NOWAIT;
455:
456: tlinfo c1%ROWTYPE;

Line 562: UPDATE igs_or_inst_stat_dtl

558: x_program_update_date := SYSDATE;
559: END IF;
560: END IF;
561:
562: UPDATE igs_or_inst_stat_dtl
563: SET
564: inst_stat_id = new_references.inst_stat_id,
565: year = new_references.year,
566: value = new_references.value,

Line 602: FROM igs_or_inst_stat_dtl

598: || (reverse chronological order - newest change first)
599: */
600: CURSOR c1 IS
601: SELECT rowid
602: FROM igs_or_inst_stat_dtl
603: WHERE inst_stat_dtl_id = x_inst_stat_dtl_id;
604:
605: BEGIN
606:

Line 655: DELETE FROM igs_or_inst_stat_dtl

651: p_action => 'DELETE',
652: x_rowid => x_rowid
653: );
654:
655: DELETE FROM igs_or_inst_stat_dtl
656: WHERE rowid = x_rowid;
657:
658: IF (SQL%NOTFOUND) THEN
659: RAISE NO_DATA_FOUND;

Line 665: END igs_or_inst_stat_dtl_pkg;

661:
662: END delete_row;
663:
664:
665: END igs_or_inst_stat_dtl_pkg;