APPS.IGF_GR_RFMS_ERROR_PKG dependencies on IGF_GR_RFMS_ERROR

Line 1: PACKAGE BODY igf_gr_rfms_error_pkg AS

1: PACKAGE BODY igf_gr_rfms_error_pkg AS
2: /* $Header: IGFGI07B.pls 115.5 2002/11/28 14:16:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_rfms_error%ROWTYPE;

Line 5: old_references igf_gr_rfms_error%ROWTYPE;

1: PACKAGE BODY igf_gr_rfms_error_pkg AS
2: /* $Header: IGFGI07B.pls 115.5 2002/11/28 14:16:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_rfms_error%ROWTYPE;
6: new_references igf_gr_rfms_error%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_rfms_error%ROWTYPE;

2: /* $Header: IGFGI07B.pls 115.5 2002/11/28 14:16:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_rfms_error%ROWTYPE;
6: new_references igf_gr_rfms_error%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM IGF_GR_RFMS_ERROR

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

Line 86: FROM igf_gr_rfms_error

82: || (reverse chronological order - newest change first)
83: */
84: CURSOR cur_rowid IS
85: SELECT rowid
86: FROM igf_gr_rfms_error
87: WHERE edit_code = x_edit_code
88: FOR UPDATE NOWAIT;
89:
90: lv_rowid cur_rowid%RowType;

Line 187: FROM igf_gr_rfms_error

183: || (reverse chronological order - newest change first)
184: */
185: CURSOR c IS
186: SELECT rowid
187: FROM igf_gr_rfms_error
188: WHERE edit_code = x_edit_code;
189:
190: x_last_update_date DATE;
191: x_last_updated_by NUMBER;

Line 244: INSERT INTO igf_gr_rfms_error (

240: x_last_updated_by => x_last_updated_by,
241: x_last_update_login => x_last_update_login
242: );
243:
244: INSERT INTO igf_gr_rfms_error (
245: edit_code,
246: type,
247: message,
248: creation_date,

Line 302: FROM igf_gr_rfms_error

298: CURSOR c1 IS
299: SELECT
300: type,
301: message
302: FROM igf_gr_rfms_error
303: WHERE rowid = x_rowid
304: FOR UPDATE NOWAIT;
305:
306: tlinfo c1%ROWTYPE;

Line 409: UPDATE igf_gr_rfms_error

405: x_program_update_date := SYSDATE;
406: END IF;
407: END IF;
408:
409: UPDATE igf_gr_rfms_error
410: SET
411: type = new_references.type,
412: message = new_references.message,
413: last_update_date = x_last_update_date,

Line 447: FROM igf_gr_rfms_error

443: || (reverse chronological order - newest change first)
444: */
445: CURSOR c1 IS
446: SELECT rowid
447: FROM igf_gr_rfms_error
448: WHERE edit_code = x_edit_code;
449:
450: BEGIN
451:

Line 498: DELETE FROM igf_gr_rfms_error

494: p_action => 'DELETE',
495: x_rowid => x_rowid
496: );
497:
498: DELETE FROM igf_gr_rfms_error
499: WHERE rowid = x_rowid;
500:
501: IF (SQL%NOTFOUND) THEN
502: RAISE NO_DATA_FOUND;

Line 508: END igf_gr_rfms_error_pkg;

504:
505: END delete_row;
506:
507:
508: END igf_gr_rfms_error_pkg;