APPS.IGS_EN_CONFIG_ENR_CP_PKG dependencies on IGS_EN_CONFIG_ENR_CP

Line 1: PACKAGE BODY igs_en_config_enr_cp_pkg AS

1: PACKAGE BODY igs_en_config_enr_cp_pkg AS
2: /* $Header: IGSEI65B.pls 115.2 2002/11/28 23:48:26 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_config_enr_cp%ROWTYPE;

Line 5: old_references igs_en_config_enr_cp%ROWTYPE;

1: PACKAGE BODY igs_en_config_enr_cp_pkg AS
2: /* $Header: IGSEI65B.pls 115.2 2002/11/28 23:48:26 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_config_enr_cp%ROWTYPE;
6: new_references igs_en_config_enr_cp%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_config_enr_cp%ROWTYPE;

2: /* $Header: IGSEI65B.pls 115.2 2002/11/28 23:48:26 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_config_enr_cp%ROWTYPE;
6: new_references igs_en_config_enr_cp%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_en_config_enr_cp

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

Line 132: FROM igs_en_config_enr_cp

128: || (reverse chronological order - newest change first)
129: */
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM igs_en_config_enr_cp
133: WHERE course_cd = x_course_cd
134: AND version_number = x_version_number
135: AND cal_type = x_cal_type
136: FOR UPDATE NOWAIT;

Line 170: FROM igs_en_config_enr_cp

166: || (reverse chronological order - newest change first)
167: */
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM igs_en_config_enr_cp
171: WHERE ((course_cd = x_course_cd) AND
172: (version_number = x_version_number));
173:
174: lv_rowid cur_rowid%RowType;

Line 206: FROM igs_en_config_enr_cp

202: || (reverse chronological order - newest change first)
203: */
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM igs_en_config_enr_cp
207: WHERE ((cal_type = x_cal_type));
208:
209: lv_rowid cur_rowid%RowType;
210:

Line 360: INSERT INTO igs_en_config_enr_cp (

356: x_last_updated_by => x_last_updated_by,
357: x_last_update_login => x_last_update_login
358: );
359:
360: INSERT INTO igs_en_config_enr_cp (
361: course_cd,
362: version_number,
363: cal_type,
364: min_cp_per_term,

Line 408: FROM igs_en_config_enr_cp

404: CURSOR c1 IS
405: SELECT
406: min_cp_per_term,
407: max_cp_per_term
408: FROM igs_en_config_enr_cp
409: WHERE rowid = x_rowid
410: FOR UPDATE NOWAIT;
411:
412: tlinfo c1%ROWTYPE;

Line 501: UPDATE igs_en_config_enr_cp

497: x_last_updated_by => x_last_updated_by,
498: x_last_update_login => x_last_update_login
499: );
500:
501: UPDATE igs_en_config_enr_cp
502: SET
503: min_cp_per_term = new_references.min_cp_per_term,
504: max_cp_per_term = new_references.max_cp_per_term,
505: last_update_date = x_last_update_date,

Line 537: FROM igs_en_config_enr_cp

533: || (reverse chronological order - newest change first)
534: */
535: CURSOR c1 IS
536: SELECT rowid
537: FROM igs_en_config_enr_cp
538: WHERE course_cd = x_course_cd
539: AND version_number = x_version_number
540: AND cal_type = x_cal_type;
541:

Line 594: DELETE FROM igs_en_config_enr_cp

590: p_action => 'DELETE',
591: x_rowid => x_rowid
592: );
593:
594: DELETE FROM igs_en_config_enr_cp
595: WHERE rowid = x_rowid;
596:
597: IF (SQL%NOTFOUND) THEN
598: RAISE NO_DATA_FOUND;

Line 604: END igs_en_config_enr_cp_pkg;

600:
601: END delete_row;
602:
603:
604: END igs_en_config_enr_cp_pkg;