APPS.IGS_OR_ORG_NOTE_TYPE_PKG dependencies on IGS_OR_ORG_NOTE_TYPE

Line 1: PACKAGE BODY igs_or_org_note_type_pkg AS

1: PACKAGE BODY igs_or_org_note_type_pkg AS
2: /* $Header: IGSOI17B.pls 120.0 2005/06/01 12:57:41 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_note_type%RowType;
5: new_references igs_or_org_note_type%RowType;

Line 4: old_references igs_or_org_note_type%RowType;

1: PACKAGE BODY igs_or_org_note_type_pkg AS
2: /* $Header: IGSOI17B.pls 120.0 2005/06/01 12:57:41 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_note_type%RowType;
5: new_references igs_or_org_note_type%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_or_org_note_type%RowType;

1: PACKAGE BODY igs_or_org_note_type_pkg AS
2: /* $Header: IGSOI17B.pls 120.0 2005/06/01 12:57:41 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_note_type%RowType;
5: new_references igs_or_org_note_type%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_OR_ORG_NOTE_TYPE

31: ***************************************************************/
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_OR_ORG_NOTE_TYPE
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 151: Igs_Or_Org_Notes_Pkg.Get_FK_Igs_Or_Org_Note_Type (

147: ***************************************************************/
148:
149: BEGIN
150:
151: Igs_Or_Org_Notes_Pkg.Get_FK_Igs_Or_Org_Note_Type (
152: old_references.org_notes_type
153: );
154:
155: END Check_Child_Existance;

Line 174: FROM igs_or_org_note_type

170: ***************************************************************/
171:
172: CURSOR cur_rowid IS
173: SELECT rowid
174: FROM igs_or_org_note_type
175: WHERE org_notes_type = x_org_notes_type
176: FOR UPDATE NOWAIT;
177:
178: lv_rowid cur_rowid%RowType;

Line 322: cursor C is select ROWID from IGS_OR_ORG_NOTE_TYPE

318:
319: (reverse chronological order - newest change first)
320: ***************************************************************/
321:
322: cursor C is select ROWID from IGS_OR_ORG_NOTE_TYPE
323: where ORG_NOTES_TYPE= X_ORG_NOTES_TYPE
324: ;
325: X_LAST_UPDATE_DATE DATE ;
326: X_LAST_UPDATED_BY NUMBER ;

Line 360: insert into IGS_OR_ORG_NOTE_TYPE (

356: x_created_by=>X_LAST_UPDATED_BY,
357: x_last_update_date=>X_LAST_UPDATE_DATE,
358: x_last_updated_by=>X_LAST_UPDATED_BY,
359: x_last_update_login=>X_LAST_UPDATE_LOGIN);
360: insert into IGS_OR_ORG_NOTE_TYPE (
361: ORG_NOTES_TYPE
362: ,NOTE_TYPE_DESCRIPTION
363: ,INST_FLAG
364: ,UNIT_FLAG

Line 417: from IGS_OR_ORG_NOTE_TYPE

413: NOTE_TYPE_DESCRIPTION
414: , INST_FLAG
415: , UNIT_FLAG
416: , LOCATION_FLAG
417: from IGS_OR_ORG_NOTE_TYPE
418: where ROWID = X_ROWID
419: for update nowait;
420: tlinfo c1%rowtype;
421: begin

Line 508: update IGS_OR_ORG_NOTE_TYPE set

504: x_created_by=>X_LAST_UPDATED_BY,
505: x_last_update_date=>X_LAST_UPDATE_DATE,
506: x_last_updated_by=>X_LAST_UPDATED_BY,
507: x_last_update_login=>X_LAST_UPDATE_LOGIN);
508: update IGS_OR_ORG_NOTE_TYPE set
509: NOTE_TYPE_DESCRIPTION = NEW_REFERENCES.NOTE_TYPE_DESCRIPTION,
510: INST_FLAG = NEW_REFERENCES.INST_FLAG,
511: UNIT_FLAG = NEW_REFERENCES.UNIT_FLAG,
512: LOCATION_FLAG = NEW_REFERENCES.LOCATION_FLAG,

Line 546: cursor c1 is select ROWID from IGS_OR_ORG_NOTE_TYPE

542:
543: (reverse chronological order - newest change first)
544: ***************************************************************/
545:
546: cursor c1 is select ROWID from IGS_OR_ORG_NOTE_TYPE
547: where ORG_NOTES_TYPE= X_ORG_NOTES_TYPE
548: ;
549: begin
550: open c1;

Line 593: delete from IGS_OR_ORG_NOTE_TYPE

589: Before_DML (
590: p_action => 'DELETE',
591: x_rowid => X_ROWID
592: );
593: delete from IGS_OR_ORG_NOTE_TYPE
594: where ROWID = X_ROWID;
595: if (sql%notfound) then
596: raise no_data_found;
597: end if;

Line 603: END igs_or_org_note_type_pkg;

599: p_action => 'DELETE',
600: x_rowid => X_ROWID
601: );
602: end DELETE_ROW;
603: END igs_or_org_note_type_pkg;