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.

[Home] [Help]

APPS.IGS_PS_OFR_PAT_NOTE_PKG dependencies on IGS_PS_OFR_PAT_NOTE

Line 1: package body IGS_PS_OFR_PAT_NOTE_PKG AS

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

Line 5: old_references IGS_PS_OFR_PAT_NOTE%RowType;

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

Line 6: new_references IGS_PS_OFR_PAT_NOTE%RowType;

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

Line 30: FROM IGS_PS_OFR_PAT_NOTE

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

Line 77: -- ON IGS_PS_OFR_PAT_NOTE

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

Line 85: v_course_cd IGS_PS_OFR_PAT_NOTE.course_cd%TYPE;

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

Line 86: v_version_number IGS_PS_OFR_PAT_NOTE.version_number%TYPE;

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

Line 290: FROM IGS_PS_OFR_PAT_NOTE

286: RETURN BOOLEAN AS
287:
288: CURSOR cur_rowid IS
289: SELECT rowid
290: FROM IGS_PS_OFR_PAT_NOTE
291: WHERE course_cd = x_course_cd
292: AND version_number = x_version_number
293: AND cal_type = x_cal_type
294: AND ci_sequence_number = x_ci_sequence_number

Line 323: FROM IGS_PS_OFR_PAT_NOTE

319: ) AS
320:
321: CURSOR cur_rowid IS
322: SELECT rowid
323: FROM IGS_PS_OFR_PAT_NOTE
324: WHERE crs_note_type = x_crs_note_type ;
325:
326: lv_rowid cur_rowid%RowType;
327:

Line 355: FROM IGS_PS_OFR_PAT_NOTE

351: ) AS
352:
353: CURSOR cur_rowid IS
354: SELECT rowid
355: FROM IGS_PS_OFR_PAT_NOTE
356: WHERE course_cd = x_course_cd
357: AND version_number = x_version_number
358: AND cal_type = x_cal_type
359: AND ci_sequence_number = x_ci_sequence_number

Line 387: FROM IGS_PS_OFR_PAT_NOTE

383: ) AS
384:
385: CURSOR cur_rowid IS
386: SELECT rowid
387: FROM IGS_PS_OFR_PAT_NOTE
388: WHERE cop_id = x_cop_id ;
389:
390: lv_rowid cur_rowid%RowType;
391:

Line 413: FROM IGS_PS_OFR_PAT_NOTE

409: ) AS
410:
411: CURSOR cur_rowid IS
412: SELECT rowid
413: FROM IGS_PS_OFR_PAT_NOTE
414: WHERE reference_number = x_reference_number ;
415:
416: lv_rowid cur_rowid%RowType;
417:

Line 546: cursor C is select ROWID from IGS_PS_OFR_PAT_NOTE

542: X_COP_ID in NUMBER,
543: X_CRS_NOTE_TYPE in VARCHAR2,
544: X_MODE in VARCHAR2 default 'R'
545: ) AS
546: cursor C is select ROWID from IGS_PS_OFR_PAT_NOTE
547: where COURSE_CD = X_COURSE_CD
548: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
549: and CAL_TYPE = X_CAL_TYPE
550: and VERSION_NUMBER = X_VERSION_NUMBER

Line 597: insert into IGS_PS_OFR_PAT_NOTE (

593: x_last_updated_by => X_LAST_UPDATED_BY ,
594: x_last_update_login => X_LAST_UPDATE_LOGIN
595: );
596:
597: insert into IGS_PS_OFR_PAT_NOTE (
598: COURSE_CD,
599: VERSION_NUMBER,
600: CAL_TYPE,
601: CI_SEQUENCE_NUMBER,

Line 660: from IGS_PS_OFR_PAT_NOTE

656: ) AS
657: cursor c1 is select
658: COP_ID,
659: CRS_NOTE_TYPE
660: from IGS_PS_OFR_PAT_NOTE
661: where ROWID = X_ROWID
662: for update nowait;
663: tlinfo c1%rowtype;
664:

Line 744: update IGS_PS_OFR_PAT_NOTE set

740: x_last_update_date => X_LAST_UPDATE_DATE ,
741: x_last_updated_by => X_LAST_UPDATED_BY ,
742: x_last_update_login => X_LAST_UPDATE_LOGIN
743: );
744: update IGS_PS_OFR_PAT_NOTE set
745: COP_ID = NEW_REFERENCES.COP_ID,
746: CRS_NOTE_TYPE = NEW_REFERENCES.CRS_NOTE_TYPE,
747: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
748: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 775: cursor c1 is select rowid from IGS_PS_OFR_PAT_NOTE

771: X_COP_ID in NUMBER,
772: X_CRS_NOTE_TYPE in VARCHAR2,
773: X_MODE in VARCHAR2 default 'R'
774: ) AS
775: cursor c1 is select rowid from IGS_PS_OFR_PAT_NOTE
776: where COURSE_CD = X_COURSE_CD
777: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
778: and CAL_TYPE = X_CAL_TYPE
779: and VERSION_NUMBER = X_VERSION_NUMBER

Line 829: delete from IGS_PS_OFR_PAT_NOTE

825: Before_DML (
826: p_action => 'DELETE',
827: x_rowid => X_ROWID
828: );
829: delete from IGS_PS_OFR_PAT_NOTE
830: where ROWID = X_ROWID;
831: if (sql%notfound) then
832: raise no_data_found;
833: end if;

Line 840: end IGS_PS_OFR_PAT_NOTE_PKG;

836: x_rowid => X_ROWID
837: );
838: end DELETE_ROW;
839:
840: end IGS_PS_OFR_PAT_NOTE_PKG;