APPS.IGS_AD_DEPLVL_PRG_PKG dependencies on IGS_AD_DEPLVL_PRG

Line 1: PACKAGE BODY igs_ad_deplvl_prg_pkg AS

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

Line 5: old_references igs_ad_deplvl_prg%ROWTYPE;

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

Line 6: new_references igs_ad_deplvl_prg%ROWTYPE;

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

Line 33: FROM igs_ad_deplvl_prg

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

Line 131: FROM igs_ad_deplvl_prg

127: || (reverse chronological order - newest change first)
128: */
129: CURSOR cur_rowid IS
130: SELECT rowid
131: FROM igs_ad_deplvl_prg
132: WHERE admission_application_type = x_admission_application_type
133: AND program_code = x_program_code
134: AND version_number = x_version_number
135: AND closed_ind = NVL(x_closed_ind,closed_ind)

Line 169: FROM igs_ad_deplvl_prg

165: || (reverse chronological order - newest change first)
166: */
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM igs_ad_deplvl_prg
170: WHERE ((admission_application_type = x_admission_application_type));
171:
172: lv_rowid cur_rowid%RowType;
173:

Line 180: fnd_message.set_name ('IGS', 'IGS_AD_DEPLVL_PRG_FK1');

176: OPEN cur_rowid;
177: FETCH cur_rowid INTO lv_rowid;
178: IF (cur_rowid%FOUND) THEN
179: CLOSE cur_rowid;
180: fnd_message.set_name ('IGS', 'IGS_AD_DEPLVL_PRG_FK1');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: RETURN;
184: END IF;

Line 205: FROM igs_ad_deplvl_prg

201: || (reverse chronological order - newest change first)
202: */
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM igs_ad_deplvl_prg
206: WHERE ((program_code = x_course_cd) AND
207: (version_number = x_version_number));
208:
209: lv_rowid cur_rowid%RowType;

Line 356: INSERT INTO igs_ad_deplvl_prg (

352: x_last_updated_by => x_last_updated_by,
353: x_last_update_login => x_last_update_login
354: );
355:
356: INSERT INTO igs_ad_deplvl_prg (
357: admission_application_type,
358: program_code,
359: version_number,
360: closed_ind,

Line 400: FROM igs_ad_deplvl_prg

396: */
397: CURSOR c1 IS
398: SELECT
399: closed_ind
400: FROM igs_ad_deplvl_prg
401: WHERE rowid = x_rowid
402: FOR UPDATE NOWAIT;
403:
404: tlinfo c1%ROWTYPE;

Line 490: UPDATE igs_ad_deplvl_prg

486: x_last_updated_by => x_last_updated_by,
487: x_last_update_login => x_last_update_login
488: );
489:
490: UPDATE igs_ad_deplvl_prg
491: SET
492: closed_ind = new_references.closed_ind,
493: last_update_date = x_last_update_date,
494: last_updated_by = x_last_updated_by,

Line 524: FROM igs_ad_deplvl_prg

520: || (reverse chronological order - newest change first)
521: */
522: CURSOR c1 IS
523: SELECT rowid
524: FROM igs_ad_deplvl_prg
525: WHERE admission_application_type = x_admission_application_type
526: AND program_code = x_program_code
527: AND version_number = x_version_number;
528:

Line 579: DELETE FROM igs_ad_deplvl_prg

575: p_action => 'DELETE',
576: x_rowid => x_rowid
577: );
578:
579: DELETE FROM igs_ad_deplvl_prg
580: WHERE rowid = x_rowid;
581:
582: IF (SQL%NOTFOUND) THEN
583: RAISE NO_DATA_FOUND;

Line 589: END igs_ad_deplvl_prg_pkg;

585:
586: END delete_row;
587:
588:
589: END igs_ad_deplvl_prg_pkg;