APPS.IGS_DA_CNFG_STAT_PKG dependencies on IGS_DA_CNFG_STAT

Line 1: PACKAGE BODY igs_da_cnfg_stat_pkg AS

1: PACKAGE BODY igs_da_cnfg_stat_pkg AS
2: /* $Header: IGSKI47B.pls 115.0 2003/04/15 09:23:24 ddey noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_cnfg_stat%ROWTYPE;

Line 5: old_references igs_da_cnfg_stat%ROWTYPE;

1: PACKAGE BODY igs_da_cnfg_stat_pkg AS
2: /* $Header: IGSKI47B.pls 115.0 2003/04/15 09:23:24 ddey noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_cnfg_stat%ROWTYPE;
6: new_references igs_da_cnfg_stat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_da_cnfg_stat%ROWTYPE;

2: /* $Header: IGSKI47B.pls 115.0 2003/04/15 09:23:24 ddey noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_cnfg_stat%ROWTYPE;
6: new_references igs_da_cnfg_stat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_da_cnfg_stat

28: */
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM igs_da_cnfg_stat
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 124: FROM igs_da_cnfg_stat

120: || (reverse chronological order - newest change first)
121: */
122: CURSOR cur_rowid IS
123: SELECT rowid
124: FROM igs_da_cnfg_stat
125: WHERE request_type_id = x_request_type_id
126: AND stat_type = x_stat_type
127: FOR UPDATE NOWAIT;
128:

Line 160: FROM igs_da_cnfg_stat

156: || (reverse chronological order - newest change first)
157: */
158: CURSOR cur_rowid IS
159: SELECT rowid
160: FROM igs_da_cnfg_stat
161: WHERE ((request_type_id = x_request_type_id));
162:
163: lv_rowid cur_rowid%RowType;
164:

Line 171: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_STAT_FK');

167: OPEN cur_rowid;
168: FETCH cur_rowid INTO lv_rowid;
169: IF (cur_rowid%FOUND) THEN
170: CLOSE cur_rowid;
171: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_STAT_FK');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: RETURN;
175: END IF;

Line 195: FROM igs_da_cnfg_stat

191: || (reverse chronological order - newest change first)
192: */
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM igs_da_cnfg_stat
196: WHERE ((stat_type = x_stat_type));
197:
198: lv_rowid cur_rowid%RowType;
199:

Line 322: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_STAT_PKG.INSERT_ROW');

318: x_last_update_login := -1;
319: END IF;
320: ELSE
321: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
322: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_STAT_PKG.INSERT_ROW');
323: igs_ge_msg_stack.add;
324: app_exception.raise_exception;
325: END IF;
326:

Line 340: INSERT INTO igs_da_cnfg_stat (

336: x_last_updated_by => x_last_updated_by,
337: x_last_update_login => x_last_update_login
338: );
339:
340: INSERT INTO igs_da_cnfg_stat (
341: request_type_id,
342: stat_type,
343: timeframe,
344: creation_date,

Line 381: FROM igs_da_cnfg_stat

377: */
378: CURSOR c1 IS
379: SELECT
380: timeframe
381: FROM igs_da_cnfg_stat
382: WHERE rowid = x_rowid
383: FOR UPDATE NOWAIT;
384:
385: tlinfo c1%ROWTYPE;

Line 452: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_STAT_PKG.UPDATE_ROW');

448: x_last_update_login := -1;
449: END IF;
450: ELSE
451: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
452: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_STAT_PKG.UPDATE_ROW');
453: igs_ge_msg_stack.add;
454: app_exception.raise_exception;
455: END IF;
456:

Line 470: UPDATE igs_da_cnfg_stat

466: x_last_updated_by => x_last_updated_by,
467: x_last_update_login => x_last_update_login
468: );
469:
470: UPDATE igs_da_cnfg_stat
471: SET
472: timeframe = new_references.timeframe,
473: last_update_date = x_last_update_date,
474: last_updated_by = x_last_updated_by,

Line 503: FROM igs_da_cnfg_stat

499: || (reverse chronological order - newest change first)
500: */
501: CURSOR c1 IS
502: SELECT rowid
503: FROM igs_da_cnfg_stat
504: WHERE request_type_id = x_request_type_id
505: AND stat_type = x_stat_type;
506:
507: BEGIN

Line 555: DELETE FROM igs_da_cnfg_stat

551: p_action => 'DELETE',
552: x_rowid => x_rowid
553: );
554:
555: DELETE FROM igs_da_cnfg_stat
556: WHERE rowid = x_rowid;
557:
558: IF (SQL%NOTFOUND) THEN
559: RAISE NO_DATA_FOUND;

Line 565: END igs_da_cnfg_stat_pkg;

561:
562: END delete_row;
563:
564:
565: END igs_da_cnfg_stat_pkg;