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_OFR_OPT_NOTE_PKG dependencies on IGS_PS_OFR_OPT_NOTE

Line 1: package body IGS_PS_OFR_OPT_NOTE_PKG AS

1: package body IGS_PS_OFR_OPT_NOTE_PKG AS
2: /* $Header: IGSPI22B.pls 115.4 2002/11/29 02:12:21 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OFR_OPT_NOTE%RowType;

Line 5: old_references IGS_PS_OFR_OPT_NOTE%RowType;

1: package body IGS_PS_OFR_OPT_NOTE_PKG AS
2: /* $Header: IGSPI22B.pls 115.4 2002/11/29 02:12:21 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OFR_OPT_NOTE%RowType;
6: new_references IGS_PS_OFR_OPT_NOTE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_OFR_OPT_NOTE%RowType;

2: /* $Header: IGSPI22B.pls 115.4 2002/11/29 02:12:21 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OFR_OPT_NOTE%RowType;
6: new_references IGS_PS_OFR_OPT_NOTE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_PS_OFR_OPT_NOTE

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_PS_OFR_OPT_NOTE
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 75: -- ON IGS_PS_OFR_OPT_NOTE

71:
72: -- Trigger description :-
73: -- "OSS_TST".trg_coon_br_iud
74: -- BEFORE INSERT OR DELETE OR UPDATE
75: -- ON IGS_PS_OFR_OPT_NOTE
76: -- FOR EACH ROW
77:
78: PROCEDURE BeforeRowInsertUpdateDelete1(
79: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 83: v_course_cd IGS_PS_OFR_OPT_NOTE.course_cd%TYPE;

79: p_inserting IN BOOLEAN DEFAULT FALSE,
80: p_updating IN BOOLEAN DEFAULT FALSE,
81: p_deleting IN BOOLEAN DEFAULT FALSE
82: ) AS
83: v_course_cd IGS_PS_OFR_OPT_NOTE.course_cd%TYPE;
84: v_version_number IGS_PS_OFR_OPT_NOTE.version_number%TYPE;
85: v_message_name VARCHAR2(30);
86: BEGIN
87:

Line 84: v_version_number IGS_PS_OFR_OPT_NOTE.version_number%TYPE;

80: p_updating IN BOOLEAN DEFAULT FALSE,
81: p_deleting IN BOOLEAN DEFAULT FALSE
82: ) AS
83: v_course_cd IGS_PS_OFR_OPT_NOTE.course_cd%TYPE;
84: v_version_number IGS_PS_OFR_OPT_NOTE.version_number%TYPE;
85: v_message_name VARCHAR2(30);
86: BEGIN
87:
88: -- Set IGS_PS_OFR_OPT key.

Line 284: FROM IGS_PS_OFR_OPT_NOTE

280: RETURN BOOLEAN AS
281:
282: CURSOR cur_rowid IS
283: SELECT rowid
284: FROM IGS_PS_OFR_OPT_NOTE
285: WHERE course_cd = x_course_cd
286: AND version_number = x_version_number
287: AND cal_type = x_cal_type
288: AND location_cd = x_location_cd

Line 316: FROM IGS_PS_OFR_OPT_NOTE

312: ) AS
313:
314: CURSOR cur_rowid IS
315: SELECT rowid
316: FROM IGS_PS_OFR_OPT_NOTE
317: WHERE crs_note_type = x_crs_note_type ;
318:
319: lv_rowid cur_rowid%RowType;
320:

Line 347: FROM IGS_PS_OFR_OPT_NOTE

343: ) AS
344:
345: CURSOR cur_rowid IS
346: SELECT rowid
347: FROM IGS_PS_OFR_OPT_NOTE
348: WHERE course_cd = x_course_cd
349: AND version_number = x_version_number
350: AND cal_type = x_cal_type
351: AND location_cd = x_location_cd

Line 378: FROM IGS_PS_OFR_OPT_NOTE

374: ) AS
375:
376: CURSOR cur_rowid IS
377: SELECT rowid
378: FROM IGS_PS_OFR_OPT_NOTE
379: WHERE coo_id = x_coo_id ;
380:
381: lv_rowid cur_rowid%RowType;
382:

Line 404: FROM IGS_PS_OFR_OPT_NOTE

400: ) AS
401:
402: CURSOR cur_rowid IS
403: SELECT rowid
404: FROM IGS_PS_OFR_OPT_NOTE
405: WHERE reference_number = x_reference_number ;
406:
407: lv_rowid cur_rowid%RowType;
408:

Line 531: cursor C is select ROWID from IGS_PS_OFR_OPT_NOTE

527: X_COO_ID in NUMBER,
528: X_CRS_NOTE_TYPE in VARCHAR2,
529: X_MODE in VARCHAR2 default 'R'
530: ) AS
531: cursor C is select ROWID from IGS_PS_OFR_OPT_NOTE
532: where COURSE_CD = X_COURSE_CD
533: and VERSION_NUMBER = X_VERSION_NUMBER
534: and CAL_TYPE = X_CAL_TYPE
535: and ATTENDANCE_MODE = X_ATTENDANCE_MODE

Line 580: insert into IGS_PS_OFR_OPT_NOTE (

576: x_last_updated_by => X_LAST_UPDATED_BY ,
577: x_last_update_login => X_LAST_UPDATE_LOGIN
578: );
579:
580: insert into IGS_PS_OFR_OPT_NOTE (
581: COURSE_CD,
582: VERSION_NUMBER,
583: CAL_TYPE,
584: LOCATION_CD,

Line 640: from IGS_PS_OFR_OPT_NOTE

636: ) AS
637: cursor c1 is select
638: COO_ID,
639: CRS_NOTE_TYPE
640: from IGS_PS_OFR_OPT_NOTE
641: where ROWID = X_ROWID
642: for update nowait;
643: tlinfo c1%rowtype;
644:

Line 723: update IGS_PS_OFR_OPT_NOTE set

719: x_last_updated_by => X_LAST_UPDATED_BY ,
720: x_last_update_login => X_LAST_UPDATE_LOGIN
721: );
722:
723: update IGS_PS_OFR_OPT_NOTE set
724: COO_ID = NEW_REFERENCES.COO_ID,
725: CRS_NOTE_TYPE = NEW_REFERENCES.CRS_NOTE_TYPE,
726: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
727: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 753: cursor c1 is select rowid from IGS_PS_OFR_OPT_NOTE

749: X_COO_ID in NUMBER,
750: X_CRS_NOTE_TYPE in VARCHAR2,
751: X_MODE in VARCHAR2 default 'R'
752: ) AS
753: cursor c1 is select rowid from IGS_PS_OFR_OPT_NOTE
754: where COURSE_CD = X_COURSE_CD
755: and VERSION_NUMBER = X_VERSION_NUMBER
756: and CAL_TYPE = X_CAL_TYPE
757: and ATTENDANCE_MODE = X_ATTENDANCE_MODE

Line 804: delete from IGS_PS_OFR_OPT_NOTE

800: Before_DML (
801: p_action => 'DELETE',
802: x_rowid => X_ROWID
803: );
804: delete from IGS_PS_OFR_OPT_NOTE
805: where ROWID = X_ROWID;
806: if (sql%notfound) then
807: raise no_data_found;
808: end if;

Line 815: end IGS_PS_OFR_OPT_NOTE_PKG;

811: x_rowid => X_ROWID
812: );
813: end DELETE_ROW;
814:
815: end IGS_PS_OFR_OPT_NOTE_PKG;