APPS.IGS_PS_CATLG_VERS_PKG dependencies on IGS_PS_CATLG_VERS_ALL

Line 4: old_references igs_ps_catlg_vers_all%RowType;

1: PACKAGE BODY igs_ps_catlg_vers_pkg AS
2: /* $Header: IGSPI1JB.pls 115.9 2002/11/29 02:07:13 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_catlg_vers_all%RowType;
5: new_references igs_ps_catlg_vers_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_catlg_vers_all%RowType;

1: PACKAGE BODY igs_ps_catlg_vers_pkg AS
2: /* $Header: IGSPI1JB.pls 115.9 2002/11/29 02:07:13 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_catlg_vers_all%RowType;
5: new_references igs_ps_catlg_vers_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_PS_CATLG_VERS_ALL

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

Line 185: FROM igs_ps_catlg_vers_all

181: ***************************************************************/
182:
183: CURSOR cur_rowid IS
184: SELECT rowid
185: FROM igs_ps_catlg_vers_all
186: WHERE catalog_version_id = x_catalog_version_id
187: FOR UPDATE NOWAIT;
188:
189: lv_rowid cur_rowid%RowType;

Line 222: FROM igs_ps_catlg_vers_all

218: ***************************************************************/
219:
220: CURSOR cur_rowid IS
221: SELECT rowid
222: FROM igs_ps_catlg_vers_all
223: WHERE catalog_schedule = x_catalog_schedule
224: AND catalog_version = x_catalog_version and ((l_rowid is null) or (rowid <> l_rowid))
225:
226: ;

Line 377: cursor C is select ROWID from IGS_PS_CATLG_VERS_ALL

373:
374: (reverse chronological order - newest change first)
375: ***************************************************************/
376:
377: cursor C is select ROWID from IGS_PS_CATLG_VERS_ALL
378: where CATALOG_VERSION_ID= X_CATALOG_VERSION_ID
379: ;
380: X_LAST_UPDATE_DATE DATE ;
381: X_LAST_UPDATED_BY NUMBER ;

Line 423: insert into IGS_PS_CATLG_VERS_ALL (

419: x_last_update_date=>X_LAST_UPDATE_DATE,
420: x_last_updated_by=>X_LAST_UPDATED_BY,
421: x_last_update_login=>X_LAST_UPDATE_LOGIN,
422: x_org_id=>igs_ge_gen_003.get_org_id);
423: insert into IGS_PS_CATLG_VERS_ALL (
424: CATALOG_VERSION_ID
425: ,CATALOG_VERSION
426: ,DESCRIPTION
427: ,CLOSED_IND

Line 483: from IGS_PS_CATLG_VERS_ALL

479: CATALOG_VERSION
480: , DESCRIPTION
481: , CLOSED_IND
482: , CATALOG_SCHEDULE
483: from IGS_PS_CATLG_VERS_ALL
484: where ROWID = X_ROWID
485: for update nowait;
486: tlinfo c1%rowtype;
487: begin

Line 566: update IGS_PS_CATLG_VERS_ALL set

562: x_created_by=>X_LAST_UPDATED_BY,
563: x_last_update_date=>X_LAST_UPDATE_DATE,
564: x_last_updated_by=>X_LAST_UPDATED_BY,
565: x_last_update_login=>X_LAST_UPDATE_LOGIN);
566: update IGS_PS_CATLG_VERS_ALL set
567: CATALOG_VERSION = NEW_REFERENCES.CATALOG_VERSION,
568: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
569: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
570: CATALOG_SCHEDULE = NEW_REFERENCES.CATALOG_SCHEDULE,

Line 605: cursor c1 is select ROWID from IGS_PS_CATLG_VERS_ALL

601:
602: (reverse chronological order - newest change first)
603: ***************************************************************/
604:
605: cursor c1 is select ROWID from IGS_PS_CATLG_VERS_ALL
606: where CATALOG_VERSION_ID= X_CATALOG_VERSION_ID
607: ;
608: begin
609: open c1;

Line 653: delete from IGS_PS_CATLG_VERS_ALL

649: Before_DML (
650: p_action => 'DELETE',
651: x_rowid => X_ROWID
652: );
653: delete from IGS_PS_CATLG_VERS_ALL
654: where ROWID = X_ROWID;
655: if (sql%notfound) then
656: raise no_data_found;
657: end if;