APPS.IGS_UC_REF_SUBJ_PKG dependencies on IGS_UC_REF_SUBJ

Line 1: PACKAGE BODY igs_uc_ref_subj_pkg AS

1: PACKAGE BODY igs_uc_ref_subj_pkg AS
2: /* $Header: IGSXI38B.pls 115.3 2003/02/28 07:51:01 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_subj%ROWTYPE;

Line 5: old_references igs_uc_ref_subj%ROWTYPE;

1: PACKAGE BODY igs_uc_ref_subj_pkg AS
2: /* $Header: IGSXI38B.pls 115.3 2003/02/28 07:51:01 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_subj%ROWTYPE;
6: new_references igs_uc_ref_subj%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_ref_subj%ROWTYPE;

2: /* $Header: IGSXI38B.pls 115.3 2003/02/28 07:51:01 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_subj%ROWTYPE;
6: new_references igs_uc_ref_subj%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_uc_ref_subj

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

Line 90: FROM igs_uc_ref_subj

86: || (reverse chronological order - newest change first)
87: */
88: CURSOR cur_rowid IS
89: SELECT rowid
90: FROM igs_uc_ref_subj
91: WHERE subj_code = x_subj_code ;
92:
93: lv_rowid cur_rowid%RowType;
94:

Line 196: FROM igs_uc_ref_subj

192: || (reverse chronological order - newest change first)
193: */
194: CURSOR c IS
195: SELECT rowid
196: FROM igs_uc_ref_subj
197: WHERE subj_code = x_subj_code;
198:
199: x_last_update_date DATE;
200: x_last_updated_by NUMBER;

Line 239: INSERT INTO igs_uc_ref_subj (

235: x_last_updated_by => x_last_updated_by,
236: x_last_update_login => x_last_update_login
237: );
238:
239: INSERT INTO igs_uc_ref_subj (
240: subj_code,
241: subj_text,
242: subj_abbrev,
243: ebl_subj,

Line 297: FROM igs_uc_ref_subj

293: subj_text,
294: subj_abbrev,
295: ebl_subj,
296: imported
297: FROM igs_uc_ref_subj
298: WHERE rowid = x_rowid
299: FOR UPDATE NOWAIT;
300:
301: tlinfo c1%ROWTYPE;

Line 392: UPDATE igs_uc_ref_subj

388: x_last_updated_by => x_last_updated_by,
389: x_last_update_login => x_last_update_login
390: );
391:
392: UPDATE igs_uc_ref_subj
393: SET
394: subj_text = new_references.subj_text,
395: subj_abbrev = new_references.subj_abbrev,
396: ebl_subj = new_references.ebl_subj,

Line 430: FROM igs_uc_ref_subj

426: || (reverse chronological order - newest change first)
427: */
428: CURSOR c1 IS
429: SELECT rowid
430: FROM igs_uc_ref_subj
431: WHERE subj_code = x_subj_code;
432:
433: BEGIN
434:

Line 485: DELETE FROM igs_uc_ref_subj

481: p_action => 'DELETE',
482: x_rowid => x_rowid
483: );
484:
485: DELETE FROM igs_uc_ref_subj
486: WHERE rowid = x_rowid;
487:
488: IF (SQL%NOTFOUND) THEN
489: RAISE NO_DATA_FOUND;

Line 495: END igs_uc_ref_subj_pkg;

491:
492: END delete_row;
493:
494:
495: END igs_uc_ref_subj_pkg;