APPS.IGS_AS_VAH_CONF_PKG dependencies on IGS_AS_VAH_CONF

Line 1: PACKAGE BODY igs_as_vah_conf_pkg AS

1: PACKAGE BODY igs_as_vah_conf_pkg AS
2: /* $Header: IGSDI77B.pls 115.2 2003/12/08 10:07:19 ijeddy noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_vah_conf%ROWTYPE;

Line 5: old_references igs_as_vah_conf%ROWTYPE;

1: PACKAGE BODY igs_as_vah_conf_pkg AS
2: /* $Header: IGSDI77B.pls 115.2 2003/12/08 10:07:19 ijeddy noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_vah_conf%ROWTYPE;
6: new_references igs_as_vah_conf%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_vah_conf%ROWTYPE;

2: /* $Header: IGSDI77B.pls 115.2 2003/12/08 10:07:19 ijeddy noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_vah_conf%ROWTYPE;
6: new_references igs_as_vah_conf%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 53: FROM igs_as_vah_conf

49: */
50:
51: CURSOR cur_old_ref_values IS
52: SELECT *
53: FROM igs_as_vah_conf
54: WHERE rowid = x_rowid;
55:
56: BEGIN
57:

Line 177: FROM igs_as_vah_conf

173: || (reverse chronological order - newest change first)
174: */
175: CURSOR cur_rowid IS
176: SELECT ROWID
177: FROM igs_as_vah_conf
178: WHERE configuration_id = x_configuration_id
179: FOR UPDATE NOWAIT;
180:
181: lv_rowid cur_rowid%RowType;

Line 211: FROM igs_as_vah_conf

207: || (reverse chronological order - newest change first)
208: */
209: CURSOR cur_rowid IS
210: SELECT ROWID
211: FROM igs_as_vah_conf
212: WHERE ((course_type = x_course_type) OR (course_type IS NULL AND x_course_type IS NULL))
213: AND ((l_rowid IS NULL) OR (ROWID <> l_rowid));
214: lv_rowid cur_rowid%RowType;
215: BEGIN

Line 241: FROM igs_as_vah_conf

237: || (reverse chronological order - newest change first)
238: */
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM igs_as_vah_conf
242: WHERE ((course_type = x_course_type));
243:
244: lv_rowid cur_rowid%RowType;
245:

Line 439: fnd_message.set_token ('ROUTINE', 'IGS_AS_VAH_CONF_PKG.INSERT_ROW');

435: x_last_update_login := -1;
436: END IF;
437: ELSE
438: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
439: fnd_message.set_token ('ROUTINE', 'IGS_AS_VAH_CONF_PKG.INSERT_ROW');
440: igs_ge_msg_stack.add;
441: app_exception.raise_exception;
442: END IF;
443:

Line 480: INSERT INTO igs_as_vah_conf (

476: x_last_update_login => x_last_update_login ,
477: x_unt_lvl_marks_flag => x_unt_lvl_marks_flag
478: );
479:
480: INSERT INTO igs_as_vah_conf (
481: configuration_id,
482: course_type,
483: display_order_flag,
484: start_note_flag,

Line 511: igs_as_vah_conf_s.NEXTVAL,

507: last_updated_by,
508: last_update_login,
509: unt_lvl_marks_flag
510: ) VALUES (
511: igs_as_vah_conf_s.NEXTVAL,
512: new_references.course_type,
513: new_references.display_order_flag,
514: new_references.start_note_flag,
515: new_references.program_region_flag,

Line 608: FROM igs_as_vah_conf

604: prog_completion_flag,
605: degree_note_flag,
606: end_note_flag,
607: unt_lvl_marks_flag
608: FROM igs_as_vah_conf
609: WHERE rowid = x_rowid
610: FOR UPDATE NOWAIT;
611:
612: tlinfo c1%ROWTYPE;

Line 723: fnd_message.set_token ('ROUTINE', 'IGS_AS_VAH_CONF_PKG.UPDATE_ROW');

719: x_last_update_login := -1;
720: END IF;
721: ELSE
722: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
723: fnd_message.set_token ('ROUTINE', 'IGS_AS_VAH_CONF_PKG.UPDATE_ROW');
724: igs_ge_msg_stack.add;
725: app_exception.raise_exception;
726: END IF;
727:

Line 762: UPDATE igs_as_vah_conf

758: x_last_update_login => x_last_update_login,
759: x_unt_lvl_marks_flag => x_unt_lvl_marks_flag
760: );
761:
762: UPDATE igs_as_vah_conf
763: SET
764: course_type = new_references.course_type,
765: display_order_flag = new_references.display_order_flag,
766: start_note_flag = new_references.start_note_flag,

Line 840: FROM igs_as_vah_conf

836: || (reverse chronological order - newest change first)
837: */
838: CURSOR c1 IS
839: SELECT rowid
840: FROM igs_as_vah_conf
841: WHERE configuration_id = x_configuration_id;
842:
843: BEGIN
844:

Line 933: DELETE FROM igs_as_vah_conf

929: p_action => 'DELETE',
930: x_rowid => x_rowid
931: );
932:
933: DELETE FROM igs_as_vah_conf
934: WHERE rowid = x_rowid;
935:
936: IF (SQL%NOTFOUND) THEN
937: RAISE NO_DATA_FOUND;

Line 945: END igs_as_vah_conf_pkg;

941:
942: END delete_row;
943:
944:
945: END igs_as_vah_conf_pkg;