APPS.IGS_GE_JOB_TEXT_PKG dependencies on IGS_GE_JOB_TEXT_ALL

Line 5: old_references IGS_GE_JOB_TEXT_ALL%RowType;

1: package body IGS_GE_JOB_TEXT_PKG as
2: /* $Header: IGSMI15B.pls 115.6 2002/11/29 01:12:55 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GE_JOB_TEXT_ALL%RowType;
6: new_references IGS_GE_JOB_TEXT_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_GE_JOB_TEXT_ALL%RowType;

2: /* $Header: IGSMI15B.pls 115.6 2002/11/29 01:12:55 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GE_JOB_TEXT_ALL%RowType;
6: new_references IGS_GE_JOB_TEXT_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_GE_JOB_TEXT_ALL

21: ) as
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_GE_JOB_TEXT_ALL
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 98: FROM IGS_GE_JOB_TEXT_ALL

94: ) RETURN BOOLEAN as
95:
96: CURSOR cur_rowid IS
97: SELECT rowid
98: FROM IGS_GE_JOB_TEXT_ALL
99: WHERE sequence_number = x_sequence_number
100: FOR UPDATE NOWAIT;
101:
102: lv_rowid cur_rowid%RowType;

Line 211: cursor C is select ROWID from IGS_GE_JOB_TEXT_ALL

207: X_TEXT in VARCHAR2,
208: X_MODE in VARCHAR2 default 'R',
209: X_ORG_ID in NUMBER
210: ) as
211: cursor C is select ROWID from IGS_GE_JOB_TEXT_ALL
212: where SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
213: X_LAST_UPDATE_DATE DATE;
214: X_LAST_UPDATED_BY NUMBER;
215: X_LAST_UPDATE_LOGIN NUMBER;

Line 250: insert into IGS_GE_JOB_TEXT_ALL (

246: x_last_updated_by => X_LAST_UPDATED_BY,
247: x_last_update_login => X_LAST_UPDATE_LOGIN,
248: x_org_id => igs_ge_gen_003.get_org_id
249: );
250: insert into IGS_GE_JOB_TEXT_ALL (
251: SEQUENCE_NUMBER,
252: JOB_EXECUTION_NAME,
253: DESCRIPTION,
254: TEXT,

Line 300: from IGS_GE_JOB_TEXT_ALL

296: cursor c1 is select
297: JOB_EXECUTION_NAME,
298: DESCRIPTION,
299: TEXT
300: from IGS_GE_JOB_TEXT_ALL
301: where ROWID = X_ROWID
302: for update nowait;
303: tlinfo c1%rowtype;
304:

Line 374: update IGS_GE_JOB_TEXT_ALL set

370: x_last_update_date => X_LAST_UPDATE_DATE,
371: x_last_updated_by => X_LAST_UPDATED_BY,
372: x_last_update_login => X_LAST_UPDATE_LOGIN
373: );
374: update IGS_GE_JOB_TEXT_ALL set
375: JOB_EXECUTION_NAME = NEW_REFERENCES.JOB_EXECUTION_NAME,
376: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
377: TEXT = NEW_REFERENCES.TEXT,
378: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 402: cursor c1 is select rowid from IGS_GE_JOB_TEXT_ALL

398: X_TEXT in VARCHAR2,
399: X_MODE in VARCHAR2 default 'R',
400: X_ORG_ID in NUMBER
401: ) as
402: cursor c1 is select rowid from IGS_GE_JOB_TEXT_ALL
403: where SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
404:
405: begin
406: open c1;

Line 440: delete from IGS_GE_JOB_TEXT_ALL

436: p_action => 'DELETE',
437: x_rowid => X_ROWID
438: );
439:
440: delete from IGS_GE_JOB_TEXT_ALL
441: where ROWID = X_ROWID;
442: if (sql%notfound) then
443: raise no_data_found;
444: end if;