APPS.IGS_AD_DEPLVL_PRGTY_PKG dependencies on IGS_AD_DEPLVL_PRGTY

Line 1: PACKAGE BODY igs_ad_deplvl_prgty_pkg AS

1: PACKAGE BODY igs_ad_deplvl_prgty_pkg AS
2: /* $Header: IGSAIG7B.pls 115.5 2003/10/30 13:17:59 akadam noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_deplvl_prgty%ROWTYPE;

Line 5: old_references igs_ad_deplvl_prgty%ROWTYPE;

1: PACKAGE BODY igs_ad_deplvl_prgty_pkg AS
2: /* $Header: IGSAIG7B.pls 115.5 2003/10/30 13:17:59 akadam noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_deplvl_prgty%ROWTYPE;
6: new_references igs_ad_deplvl_prgty%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_deplvl_prgty%ROWTYPE;

2: /* $Header: IGSAIG7B.pls 115.5 2003/10/30 13:17:59 akadam noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_deplvl_prgty%ROWTYPE;
6: new_references igs_ad_deplvl_prgty%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_ad_deplvl_prgty

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

Line 125: FROM igs_ad_deplvl_prgty

121: || (reverse chronological order - newest change first)
122: */
123: CURSOR cur_rowid IS
124: SELECT rowid
125: FROM igs_ad_deplvl_prgty
126: WHERE admission_application_type = x_admission_application_type
127: AND program_type = x_program_type
128: AND closed_ind = NVL(x_closed_ind,closed_ind)
129: FOR UPDATE NOWAIT;

Line 162: FROM igs_ad_deplvl_prgty

158: || (reverse chronological order - newest change first)
159: */
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM igs_ad_deplvl_prgty
163: WHERE ((admission_application_type = x_admission_application_type));
164:
165: lv_rowid cur_rowid%RowType;
166:

Line 173: fnd_message.set_name ('IGS', 'IGS_AD_DEPLVL_PRGTY_FK1');

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

Line 306: INSERT INTO igs_ad_deplvl_prgty (

302: x_last_updated_by => x_last_updated_by,
303: x_last_update_login => x_last_update_login
304: );
305:
306: INSERT INTO igs_ad_deplvl_prgty (
307: admission_application_type,
308: program_type,
309: closed_ind,
310: creation_date,

Line 347: FROM igs_ad_deplvl_prgty

343: */
344: CURSOR c1 IS
345: SELECT
346: closed_ind
347: FROM igs_ad_deplvl_prgty
348: WHERE rowid = x_rowid
349: FOR UPDATE NOWAIT;
350:
351: tlinfo c1%ROWTYPE;

Line 435: UPDATE igs_ad_deplvl_prgty

431: x_last_updated_by => x_last_updated_by,
432: x_last_update_login => x_last_update_login
433: );
434:
435: UPDATE igs_ad_deplvl_prgty
436: SET
437: closed_ind = new_references.closed_ind,
438: last_update_date = x_last_update_date,
439: last_updated_by = x_last_updated_by,

Line 468: FROM igs_ad_deplvl_prgty

464: || (reverse chronological order - newest change first)
465: */
466: CURSOR c1 IS
467: SELECT rowid
468: FROM igs_ad_deplvl_prgty
469: WHERE admission_application_type = x_admission_application_type
470: AND program_type = x_program_type;
471:
472: BEGIN

Line 520: DELETE FROM igs_ad_deplvl_prgty

516: p_action => 'DELETE',
517: x_rowid => x_rowid
518: );
519:
520: DELETE FROM igs_ad_deplvl_prgty
521: WHERE rowid = x_rowid;
522:
523: IF (SQL%NOTFOUND) THEN
524: RAISE NO_DATA_FOUND;

Line 530: END igs_ad_deplvl_prgty_pkg;

526:
527: END delete_row;
528:
529:
530: END igs_ad_deplvl_prgty_pkg;