APPS.IGS_EN_STD_WARNINGS_PKG dependencies on IGS_EN_STD_WARNINGS

Line 1: PACKAGE BODY IGS_EN_STD_WARNINGS_PKG AS

1: PACKAGE BODY IGS_EN_STD_WARNINGS_PKG AS
2: /* $Header: IGSEI58B.pls 120.0 2005/09/13 10:01:24 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_std_warnings%ROWTYPE;

Line 5: old_references igs_en_std_warnings%ROWTYPE;

1: PACKAGE BODY IGS_EN_STD_WARNINGS_PKG AS
2: /* $Header: IGSEI58B.pls 120.0 2005/09/13 10:01:24 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_std_warnings%ROWTYPE;
6: new_references igs_en_std_warnings%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_std_warnings%ROWTYPE;

2: /* $Header: IGSEI58B.pls 120.0 2005/09/13 10:01:24 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_std_warnings%ROWTYPE;
6: new_references igs_en_std_warnings%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 44: FROM igs_en_std_warnings

40: */
41:
42: CURSOR cur_old_ref_values IS
43: SELECT *
44: FROM igs_en_std_warnings
45: WHERE rowid = x_rowid;
46:
47: BEGIN
48:

Line 110: FROM igs_en_std_warnings

106: || (reverse chronological order - newest change first)
107: */
108: CURSOR cur_rowid IS
109: SELECT rowid
110: FROM igs_en_std_warnings
111: WHERE warning_id = x_warning_id
112: FOR UPDATE NOWAIT;
113:
114: lv_rowid cur_rowid%RowType;

Line 267: fnd_message.set_token ('ROUTINE', 'igs_en_std_warnings_PKG.INSERT_ROW');

263: x_last_update_login := -1;
264: END IF;
265: ELSE
266: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
267: fnd_message.set_token ('ROUTINE', 'igs_en_std_warnings_PKG.INSERT_ROW');
268: igs_ge_msg_stack.add;
269: app_exception.raise_exception;
270: END IF;
271:

Line 299: INSERT INTO igs_en_std_warnings (

295: x_last_updated_by => x_last_updated_by,
296: x_last_update_login => x_last_update_login
297: );
298:
299: INSERT INTO igs_en_std_warnings (
300: warning_id,
301: person_id,
302: course_cd,
303: uoo_id,

Line 321: igs_en_std_warnings_s.NEXTVAL,

317: last_update_date,
318: last_updated_by,
319: last_update_login
320: ) VALUES (
321: igs_en_std_warnings_s.NEXTVAL,
322: new_references.person_id,
323: new_references.course_cd,
324: new_references.uoo_id,
325: new_references.term_cal_type,

Line 389: FROM igs_en_std_warnings

385: destination,
386: p_parameters,
387: step_type,
388: session_id
389: FROM igs_en_std_warnings
390: WHERE rowid = x_rowid
391: FOR UPDATE NOWAIT;
392:
393: tlinfo c1%ROWTYPE;

Line 485: fnd_message.set_token ('ROUTINE', 'igs_en_std_warnings_PKG.UPDATE_ROW');

481: x_last_update_login := -1;
482: END IF;
483: ELSE
484: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
485: fnd_message.set_token ('ROUTINE', 'igs_en_std_warnings_PKG.UPDATE_ROW');
486: igs_ge_msg_stack.add;
487: app_exception.raise_exception;
488: END IF;
489:

Line 515: UPDATE igs_en_std_warnings

511: x_last_updated_by => x_last_updated_by,
512: x_last_update_login => x_last_update_login
513: );
514:
515: UPDATE igs_en_std_warnings
516: SET
517: person_id = new_references.person_id,
518: course_cd = new_references.course_cd,
519: uoo_id = new_references.uoo_id,

Line 573: FROM igs_en_std_warnings

569: || (reverse chronological order - newest change first)
570: */
571: CURSOR c1 IS
572: SELECT rowid
573: FROM igs_en_std_warnings
574: WHERE warning_id = x_warning_id;
575:
576: BEGIN
577:

Line 648: DELETE FROM igs_en_std_warnings

644: p_action => 'DELETE',
645: x_rowid => x_rowid
646: );
647:
648: DELETE FROM igs_en_std_warnings
649: WHERE rowid = x_rowid;
650:
651: IF (SQL%NOTFOUND) THEN
652: RAISE NO_DATA_FOUND;

Line 658: END igs_en_std_warnings_pkg;

654:
655: END delete_row;
656:
657:
658: END igs_en_std_warnings_pkg;