APPS.IGS_AD_NOTE_TYPES_PKG dependencies on IGS_AD_NOTE_TYPES

Line 1: PACKAGE BODY igs_ad_note_types_pkg AS

1: PACKAGE BODY igs_ad_note_types_pkg AS
2: /* $Header: IGSAI76B.pls 120.1 2005/09/22 05:41:47 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_note_types%RowType;
5: new_references igs_ad_note_types%RowType;

Line 4: old_references igs_ad_note_types%RowType;

1: PACKAGE BODY igs_ad_note_types_pkg AS
2: /* $Header: IGSAI76B.pls 120.1 2005/09/22 05:41:47 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_note_types%RowType;
5: new_references igs_ad_note_types%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_note_types%RowType;

1: PACKAGE BODY igs_ad_note_types_pkg AS
2: /* $Header: IGSAI76B.pls 120.1 2005/09/22 05:41:47 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_note_types%RowType;
5: new_references igs_ad_note_types%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_AD_NOTE_TYPES

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

Line 170: Igs_Ad_Appl_Notes_Pkg.Get_FK_Igs_Ad_Note_Types (

166: Who When What
167: (reverse chronological order - newest change first)
168: ***************************************************************/
169: BEGIN
170: Igs_Ad_Appl_Notes_Pkg.Get_FK_Igs_Ad_Note_Types (
171: old_references.notes_type_id
172: );
173: END Check_Child_Existance;
174:

Line 190: FROM igs_ad_note_types

186: (reverse chronological order - newest change first)
187: ***************************************************************/
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM igs_ad_note_types
191: WHERE notes_type_id = x_notes_type_id AND
192: closed_ind = NVL(x_closed_ind,closed_ind)
193: FOR UPDATE NOWAIT;
194:

Line 225: FROM igs_ad_note_types

221: (reverse chronological order - newest change first)
222: ***************************************************************/
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM igs_ad_note_types
226: WHERE notes_category = x_notes_category AND
227: note_type = x_note_type AND
228: ((l_rowid is null) or (rowid <> l_rowid)) AND
229: closed_ind = NVL(x_closed_ind,closed_ind);

Line 260: FROM igs_ad_note_types

256: (reverse chronological order - newest change first)
257: ***************************************************************/
258: CURSOR cur_rowid IS
259: SELECT rowid
260: FROM igs_ad_note_types
261: WHERE notes_category = NVL(x_notes_category,notes_category ) AND
262: notes_type_id = x_notes_type_id AND
263: ((l_rowid is null) or (rowid <> l_rowid)) AND
264: closed_ind = NVL(x_closed_ind,closed_ind) ;

Line 375: select ROWID from IGS_AD_NOTE_TYPES

371:
372: (reverse chronological order - newest change first)
373: ***************************************************************/
374: cursor C is
375: select ROWID from IGS_AD_NOTE_TYPES
376: where NOTES_TYPE_ID= X_NOTES_TYPE_ID;
377: X_LAST_UPDATE_DATE DATE ;
378: X_LAST_UPDATED_BY NUMBER ;
379: X_LAST_UPDATE_LOGIN NUMBER ;

Line 417: insert into IGS_AD_NOTE_TYPES (

413: x_last_update_date=>X_LAST_UPDATE_DATE,
414: x_last_updated_by=>X_LAST_UPDATED_BY,
415: x_last_update_login=>X_LAST_UPDATE_LOGIN
416: );
417: insert into IGS_AD_NOTE_TYPES (
418: NOTES_TYPE_ID
419: ,NOTES_CATEGORY
420: ,NOTE_TYPE
421: ,DESCRIPTION

Line 429: IGS_AD_NOTE_TYPES_S.NEXTVAL

425: ,LAST_UPDATE_DATE
426: ,LAST_UPDATED_BY
427: ,LAST_UPDATE_LOGIN
428: ) values (
429: IGS_AD_NOTE_TYPES_S.NEXTVAL
430: ,NEW_REFERENCES.NOTES_CATEGORY
431: ,NEW_REFERENCES.NOTE_TYPE
432: ,NEW_REFERENCES.DESCRIPTION
433: ,NEW_REFERENCES.CLOSED_IND

Line 471: from IGS_AD_NOTE_TYPES

467: select NOTES_CATEGORY,
468: NOTE_TYPE,
469: DESCRIPTION,
470: CLOSED_IND
471: from IGS_AD_NOTE_TYPES
472: where ROWID = X_ROWID
473: for update nowait;
474: tlinfo c1%rowtype;
475: begin

Line 557: update IGS_AD_NOTE_TYPES

553: x_last_update_date=>X_LAST_UPDATE_DATE,
554: x_last_updated_by=>X_LAST_UPDATED_BY,
555: x_last_update_login=>X_LAST_UPDATE_LOGIN
556: );
557: update IGS_AD_NOTE_TYPES
558: set NOTES_CATEGORY = NEW_REFERENCES.NOTES_CATEGORY,
559: NOTE_TYPE = NEW_REFERENCES.NOTE_TYPE,
560: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
561: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 592: from IGS_AD_NOTE_TYPES

588: (reverse chronological order - newest change first)
589: ***************************************************************/
590: cursor c1 is
591: select ROWID
592: from IGS_AD_NOTE_TYPES
593: where NOTES_TYPE_ID= X_NOTES_TYPE_ID;
594: l_mode VARCHAR2(1);
595: begin
596: l_mode := NVL(x_mode, 'R');

Line 642: delete from IGS_AD_NOTE_TYPES

638: Before_DML (
639: p_action => 'DELETE',
640: x_rowid => X_ROWID
641: );
642: delete from IGS_AD_NOTE_TYPES
643: where ROWID = X_ROWID;
644: if (sql%notfound) then
645: raise no_data_found;
646: end if;

Line 649: END igs_ad_note_types_pkg;

645: raise no_data_found;
646: end if;
647: end DELETE_ROW;
648:
649: END igs_ad_note_types_pkg;