APPS.IGS_OR_ORG_NOTES_PKG dependencies on IGS_OR_ORG_NOTES

Line 1: PACKAGE BODY igs_or_org_notes_pkg AS

1: PACKAGE BODY igs_or_org_notes_pkg AS
2: /* $Header: IGSOI18B.pls 115.8 2003/10/30 13:29:55 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_notes%RowType;
5: new_references igs_or_org_notes%RowType;

Line 4: old_references igs_or_org_notes%RowType;

1: PACKAGE BODY igs_or_org_notes_pkg AS
2: /* $Header: IGSOI18B.pls 115.8 2003/10/30 13:29:55 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_notes%RowType;
5: new_references igs_or_org_notes%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_or_org_notes%RowType;

1: PACKAGE BODY igs_or_org_notes_pkg AS
2: /* $Header: IGSOI18B.pls 115.8 2003/10/30 13:29:55 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_notes%RowType;
5: new_references igs_or_org_notes%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM IGS_OR_ORG_NOTES

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

Line 178: FROM igs_or_org_notes

174: ***************************************************************/
175:
176: CURSOR cur_rowid IS
177: SELECT rowid
178: FROM igs_or_org_notes
179: WHERE org_structure_type = x_org_structure_type
180: AND org_note_sequence = x_org_note_sequence
181: AND org_note_type = x_org_note_type
182: AND org_structure_id = x_org_structure_id

Line 217: FROM igs_or_org_notes

213: ***************************************************************/
214:
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM igs_or_org_notes
218: WHERE org_note_type = x_org_notes_type ;
219:
220: lv_rowid cur_rowid%RowType;
221:

Line 242: FROM IGS_OR_ORG_NOTES

238: x_institution_cd IN VARCHAR2
239: ) AS
240: CURSOR cur_rowid IS
241: SELECT ROWID
242: FROM IGS_OR_ORG_NOTES
243: WHERE (
244: (org_structure_id = x_institution_cd) AND (org_structure_type = 'INSTITUTE')
245: );
246: lv_rowid cur_rowid%ROWTYPE;

Line 265: FROM IGS_OR_ORG_NOTES

261: x_location_cd IN VARCHAR2
262: ) AS
263: CURSOR cur_rowid IS
264: SELECT ROWID
265: FROM IGS_OR_ORG_NOTES
266: WHERE (
267: (org_structure_id = x_location_cd) AND (org_structure_type = 'LOCATION')
268: );
269: lv_rowid cur_rowid%ROWTYPE;

Line 288: FROM IGS_OR_ORG_NOTES

284: x_org_unit_cd IN VARCHAR2
285: ) AS
286: CURSOR cur_rowid IS
287: SELECT ROWID
288: FROM IGS_OR_ORG_NOTES
289: WHERE (
290: (org_structure_id = x_org_unit_cd) AND (org_structure_type = 'ORG_UNIT')
291: );
292: lv_rowid cur_rowid%ROWTYPE;

Line 450: cursor C is select ROWID from IGS_OR_ORG_NOTES

446:
447: (reverse chronological order - newest change first)
448: ***************************************************************/
449:
450: cursor C is select ROWID from IGS_OR_ORG_NOTES
451: where ORG_STRUCTURE_TYPE= X_ORG_STRUCTURE_TYPE
452: and ORG_NOTE_SEQUENCE = X_ORG_NOTE_SEQUENCE
453: and ORG_NOTE_TYPE = X_ORG_NOTE_TYPE
454: and ORG_STRUCTURE_ID = X_ORG_STRUCTURE_ID

Line 500: insert into IGS_OR_ORG_NOTES (

496: x_created_by=>X_LAST_UPDATED_BY,
497: x_last_update_date=>X_LAST_UPDATE_DATE,
498: x_last_updated_by=>X_LAST_UPDATED_BY,
499: x_last_update_login=>X_LAST_UPDATE_LOGIN);
500: insert into IGS_OR_ORG_NOTES (
501: ORG_STRUCTURE_ID
502: ,ORG_STRUCTURE_TYPE
503: ,ORG_NOTE_SEQUENCE
504: ,ORG_NOTE_TYPE

Line 562: from IGS_OR_ORG_NOTES

558: cursor c1 is select
559: START_DATE
560: , END_DATE
561: , NOTE_TEXT
562: from IGS_OR_ORG_NOTES
563: where ROWID = X_ROWID
564: for update nowait;
565: tlinfo c1%rowtype;
566: begin

Line 652: update IGS_OR_ORG_NOTES set

648: x_created_by=>X_LAST_UPDATED_BY,
649: x_last_update_date=>X_LAST_UPDATE_DATE,
650: x_last_updated_by=>X_LAST_UPDATED_BY,
651: x_last_update_login=>X_LAST_UPDATE_LOGIN);
652: update IGS_OR_ORG_NOTES set
653: START_DATE = NEW_REFERENCES.START_DATE,
654: END_DATE = NEW_REFERENCES.END_DATE,
655: NOTE_TEXT = NEW_REFERENCES.NOTE_TEXT,
656: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 691: cursor c1 is select ROWID from IGS_OR_ORG_NOTES

687:
688: (reverse chronological order - newest change first)
689: ***************************************************************/
690:
691: cursor c1 is select ROWID from IGS_OR_ORG_NOTES
692: where ORG_STRUCTURE_TYPE= X_ORG_STRUCTURE_TYPE
693: and ORG_NOTE_SEQUENCE = X_ORG_NOTE_SEQUENCE
694: and ORG_NOTE_TYPE = X_ORG_NOTE_TYPE
695: and ORG_STRUCTURE_ID = X_ORG_STRUCTURE_ID

Line 746: delete from IGS_OR_ORG_NOTES

742: Before_DML (
743: p_action => 'DELETE',
744: x_rowid => X_ROWID
745: );
746: delete from IGS_OR_ORG_NOTES
747: where ROWID = X_ROWID;
748: if (sql%notfound) then
749: raise no_data_found;
750: end if;

Line 756: END igs_or_org_notes_pkg;

752: p_action => 'DELETE',
753: x_rowid => X_ROWID
754: );
755: end DELETE_ROW;
756: END igs_or_org_notes_pkg;