APPS.IGS_UC_COM_EBL_SUBJ_PKG dependencies on IGS_UC_COM_EBL_SUBJ

Line 1: PACKAGE BODY igs_uc_com_ebl_subj_pkg AS

1: PACKAGE BODY igs_uc_com_ebl_subj_pkg AS
2: /* $Header: IGSXI08B.pls 115.8 2003/06/11 10:30:19 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_com_ebl_subj%ROWTYPE;

Line 5: old_references igs_uc_com_ebl_subj%ROWTYPE;

1: PACKAGE BODY igs_uc_com_ebl_subj_pkg AS
2: /* $Header: IGSXI08B.pls 115.8 2003/06/11 10:30:19 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_com_ebl_subj%ROWTYPE;
6: new_references igs_uc_com_ebl_subj%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_com_ebl_subj%ROWTYPE;

2: /* $Header: IGSXI08B.pls 115.8 2003/06/11 10:30:19 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_com_ebl_subj%ROWTYPE;
6: new_references igs_uc_com_ebl_subj%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 39: FROM IGS_UC_COM_EBL_SUBJ

35: */
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM IGS_UC_COM_EBL_SUBJ
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 129: igs_uc_app_results_pkg.get_fk_igs_uc_com_ebl_subj (

125: || (reverse chronological order - newest change first)
126: */
127: BEGIN
128:
129: igs_uc_app_results_pkg.get_fk_igs_uc_com_ebl_subj (
130: old_references.subject_id
131: );
132:
133: END check_child_existance;

Line 150: FROM igs_uc_com_ebl_subj

146: || (reverse chronological order - newest change first)
147: */
148: CURSOR cur_rowid IS
149: SELECT rowid
150: FROM igs_uc_com_ebl_subj
151: WHERE subject_id = x_subject_id ;
152:
153: lv_rowid cur_rowid%RowType;
154:

Line 186: FROM igs_uc_com_ebl_subj

182: || (reverse chronological order - newest change first)
183: */
184: CURSOR cur_rowid IS
185: SELECT rowid
186: FROM igs_uc_com_ebl_subj
187: WHERE ((awarding_body = x_awarding_body) AND
188: (sitting = x_sitting) AND
189: (year = x_year));
190:

Line 318: FROM igs_uc_com_ebl_subj

314: || (reverse chronological order - newest change first)
315: */
316: CURSOR c IS
317: SELECT rowid
318: FROM igs_uc_com_ebl_subj
319: WHERE subject_id = x_subject_id;
320:
321: x_last_update_date DATE;
322: x_last_updated_by NUMBER;

Line 365: INSERT INTO igs_uc_com_ebl_subj (

361: x_last_updated_by => x_last_updated_by,
362: x_last_update_login => x_last_update_login
363: );
364:
365: INSERT INTO igs_uc_com_ebl_subj (
366: subject_id,
367: year,
368: sitting,
369: awarding_body,

Line 440: FROM igs_uc_com_ebl_subj

436: exam_level,
437: title,
438: subject_code,
439: imported
440: FROM igs_uc_com_ebl_subj
441: WHERE rowid = x_rowid
442: FOR UPDATE NOWAIT;
443:
444: tlinfo c1%ROWTYPE;

Line 548: UPDATE igs_uc_com_ebl_subj

544: x_last_updated_by => x_last_updated_by,
545: x_last_update_login => x_last_update_login
546: );
547:
548: UPDATE igs_uc_com_ebl_subj
549: SET
550: year = new_references.year,
551: sitting = new_references.sitting,
552: awarding_body = new_references.awarding_body,

Line 595: FROM igs_uc_com_ebl_subj

591: || (reverse chronological order - newest change first)
592: */
593: CURSOR c1 IS
594: SELECT rowid
595: FROM igs_uc_com_ebl_subj
596: WHERE subject_id = x_subject_id;
597:
598: BEGIN
599:

Line 658: DELETE FROM igs_uc_com_ebl_subj

654: p_action => 'DELETE',
655: x_rowid => x_rowid
656: );
657:
658: DELETE FROM igs_uc_com_ebl_subj
659: WHERE rowid = x_rowid;
660:
661: IF (SQL%NOTFOUND) THEN
662: RAISE NO_DATA_FOUND;

Line 668: END igs_uc_com_ebl_subj_pkg;

664:
665: END delete_row;
666:
667:
668: END igs_uc_com_ebl_subj_pkg;