APPS.IGS_PS_CATLG_NOTES_PKG dependencies on IGS_PS_CATLG_NOTES_ALL

Line 5: old_references igs_ps_catlg_notes_ALL%RowType;

1: PACKAGE BODY igs_ps_catlg_notes_pkg AS
2: /* $Header: IGSPI0QB.pls 115.11 2002/11/29 01:59:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_catlg_notes_ALL%RowType;
6: new_references igs_ps_catlg_notes_ALL%RowType;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_catlg_notes_ALL%RowType;

2: /* $Header: IGSPI0QB.pls 115.11 2002/11/29 01:59:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_catlg_notes_ALL%RowType;
6: new_references igs_ps_catlg_notes_ALL%RowType;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 46: FROM IGS_PS_CATLG_NOTES_ALL

42: *=======================================================================*/
43:
44: CURSOR cur_old_ref_values IS
45: SELECT *
46: FROM IGS_PS_CATLG_NOTES_ALL
47: WHERE rowid = x_rowid;
48:
49: BEGIN
50:

Line 114: FROM igs_ps_catlg_notes_all

110: *=======================================================================*/
111:
112: CURSOR c_date is
113: SELECT create_date,end_date
114: FROM igs_ps_catlg_notes_all
115: WHERE catalog_version_id = new_references.catalog_version_id and
116: note_type_id = new_references.note_type_id and
117: (
118: (l_rowid is not null AND

Line 275: FROM igs_ps_catlg_notes_ALL

271:
272:
273: CURSOR cur_rowid IS
274: SELECT rowid
275: FROM igs_ps_catlg_notes_ALL
276: WHERE catalog_note_id = x_catalog_note_id
277: FOR UPDATE NOWAIT;
278:
279: lv_rowid cur_rowid%RowType;

Line 321: FROM igs_ps_catlg_notes_ALL

317:
318:
319: CURSOR cur_rowid IS
320: SELECT rowid
321: FROM igs_ps_catlg_notes_ALL
322: WHERE catalog_version_id = x_catalog_version_id
323: AND note_type_id = x_note_type_id
324: AND sequence = x_sequence and ((l_rowid is null) or (rowid <> l_rowid))
325:

Line 365: FROM igs_ps_catlg_notes_ALL

361: *=======================================================================*/
362:
363: CURSOR cur_rowid IS
364: SELECT rowid
365: FROM igs_ps_catlg_notes_ALL
366: WHERE catalog_version_id = x_catalog_version_id ;
367:
368: lv_rowid cur_rowid%RowType;
369:

Line 409: FROM igs_ps_catlg_notes_ALL

405: *=======================================================================*/
406:
407: CURSOR cur_rowid IS
408: SELECT rowid
409: FROM igs_ps_catlg_notes_ALL
410: WHERE note_type_id = x_note_type_id ;
411:
412: lv_rowid cur_rowid%RowType;
413:

Line 596: cursor C is select ROWID from IGS_PS_CATLG_NOTES_ALL

592: |
593: |(reverse chronological order - newest change first)
594: *=======================================================================*/
595:
596: cursor C is select ROWID from IGS_PS_CATLG_NOTES_ALL
597: where CATALOG_NOTE_ID= X_CATALOG_NOTE_ID
598: ;
599: X_LAST_UPDATE_DATE DATE ;
600: X_LAST_UPDATED_BY NUMBER ;

Line 638: insert into IGS_PS_CATLG_NOTES_ALL (

634: x_last_update_date=>X_LAST_UPDATE_DATE,
635: x_last_updated_by=>X_LAST_UPDATED_BY,
636: x_last_update_login=>X_LAST_UPDATE_LOGIN,
637: x_org_id=>igs_ge_gen_003.get_org_id);
638: insert into IGS_PS_CATLG_NOTES_ALL (
639: CATALOG_NOTE_ID
640: ,CATALOG_VERSION_ID
641: ,NOTE_TYPE_ID
642: ,CREATE_DATE

Line 716: from IGS_PS_CATLG_NOTES_ALL

712: , END_DATE
713: , SEQUENCE
714: , NOTE_TEXT
715:
716: from IGS_PS_CATLG_NOTES_ALL
717: where ROWID = X_ROWID
718: for update nowait;
719: tlinfo c1%rowtype;
720: begin

Line 821: update IGS_PS_CATLG_NOTES_ALL set

817: x_last_update_date=>X_LAST_UPDATE_DATE,
818: x_last_updated_by=>X_LAST_UPDATED_BY,
819: x_last_update_login=>X_LAST_UPDATE_LOGIN
820: );
821: update IGS_PS_CATLG_NOTES_ALL set
822: CATALOG_VERSION_ID = NEW_REFERENCES.CATALOG_VERSION_ID,
823: NOTE_TYPE_ID = NEW_REFERENCES.NOTE_TYPE_ID,
824: CREATE_DATE = NEW_REFERENCES.CREATE_DATE,
825: END_DATE = NEW_REFERENCES.END_DATE,

Line 875: cursor c1 is select ROWID from IGS_PS_CATLG_NOTES_ALL

871: |
872: |(reverse chronological order - newest change first)
873: *=======================================================================*/
874:
875: cursor c1 is select ROWID from IGS_PS_CATLG_NOTES_ALL
876: where CATALOG_NOTE_ID= X_CATALOG_NOTE_ID
877: ;
878: begin
879: open c1;

Line 938: delete from IGS_PS_CATLG_NOTES_ALL

934: Before_DML (
935: p_action => 'DELETE',
936: x_rowid => X_ROWID
937: );
938: delete from IGS_PS_CATLG_NOTES_ALL
939: where ROWID = X_ROWID;
940: if (sql%notfound) then
941: raise no_data_found;
942: end if;