APPS.IGS_PR_S_SCRATCH_PAD_PKG dependencies on IGS_PR_S_SCRATCH_PAD_ALL

Line 4: old_references igs_pr_s_scratch_pad_all%RowType;

1: PACKAGE BODY igs_pr_s_scratch_pad_pkg AS
2: /* $Header: IGSQI27B.pls 115.9 2002/11/29 03:21:08 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pr_s_scratch_pad_all%RowType;
5: new_references igs_pr_s_scratch_pad_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pr_s_scratch_pad_all%RowType;

1: PACKAGE BODY igs_pr_s_scratch_pad_pkg AS
2: /* $Header: IGSQI27B.pls 115.9 2002/11/29 03:21:08 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pr_s_scratch_pad_all%RowType;
5: new_references igs_pr_s_scratch_pad_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_PR_S_SCRATCH_PAD_ALL

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

Line 120: FROM igs_pr_s_scratch_pad_all

116: ***************************************************************/
117:
118: CURSOR cur_rowid IS
119: SELECT rowid
120: FROM igs_pr_s_scratch_pad_all
121: WHERE sequence_number = x_sequence_number
122: FOR UPDATE NOWAIT;
123:
124: lv_rowid cur_rowid%RowType;

Line 270: cursor C is select ROWID from IGS_PR_S_SCRATCH_PAD_ALL

266:
267: (reverse chronological order - newest change first)
268: ***************************************************************/
269:
270: cursor C is select ROWID from IGS_PR_S_SCRATCH_PAD_ALL
271: where SEQUENCE_NUMBER= X_SEQUENCE_NUMBER
272: ;
273: X_LAST_UPDATE_DATE DATE ;
274: X_LAST_UPDATED_BY NUMBER ;

Line 309: insert into IGS_PR_S_SCRATCH_PAD_ALL (

305: x_last_update_date=>X_LAST_UPDATE_DATE,
306: x_last_updated_by=>X_LAST_UPDATED_BY,
307: x_last_update_login=>X_LAST_UPDATE_LOGIN,
308: x_org_id=>igs_ge_gen_003.get_org_id);
309: insert into IGS_PR_S_SCRATCH_PAD_ALL (
310: SEQUENCE_NUMBER
311: ,CREATION_DT
312: ,KEY
313: ,MESSAGE_NAME

Line 369: from IGS_PR_S_SCRATCH_PAD_ALL

365: CREATION_DT
366: , KEY
367: , MESSAGE_NAME
368: , TEXT
369: from IGS_PR_S_SCRATCH_PAD_ALL
370: where ROWID = X_ROWID
371: for update nowait;
372: tlinfo c1%rowtype;
373: begin

Line 457: update IGS_PR_S_SCRATCH_PAD_ALL set

453: x_last_update_date=>X_LAST_UPDATE_DATE,
454: x_last_updated_by=>X_LAST_UPDATED_BY,
455: x_last_update_login=>X_LAST_UPDATE_LOGIN
456: );
457: update IGS_PR_S_SCRATCH_PAD_ALL set
458: CREATION_DT = NEW_REFERENCES.CREATION_DT,
459: KEY = NEW_REFERENCES.KEY,
460: MESSAGE_NAME = NEW_REFERENCES.MESSAGE_NAME,
461: TEXT = NEW_REFERENCES.TEXT,

Line 496: cursor c1 is select ROWID from IGS_PR_S_SCRATCH_PAD_ALL

492:
493: (reverse chronological order - newest change first)
494: ***************************************************************/
495:
496: cursor c1 is select ROWID from IGS_PR_S_SCRATCH_PAD_ALL
497: where SEQUENCE_NUMBER= X_SEQUENCE_NUMBER
498: ;
499: begin
500: open c1;

Line 544: delete from IGS_PR_S_SCRATCH_PAD_ALL

540: Before_DML (
541: p_action => 'DELETE',
542: x_rowid => X_ROWID
543: );
544: delete from IGS_PR_S_SCRATCH_PAD_ALL
545: where ROWID = X_ROWID;
546: if (sql%notfound) then
547: raise no_data_found;
548: end if;