APPS.IGS_EN_SPL_PERM_H_PKG dependencies on IGS_EN_SPL_PERM_H

Line 1: PACKAGE BODY igs_en_spl_perm_h_pkg AS

1: PACKAGE BODY igs_en_spl_perm_h_pkg AS
2: /* $Header: IGSEI54B.pls 115.4 2002/11/28 23:45:56 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_spl_perm_h%ROWTYPE;

Line 5: old_references igs_en_spl_perm_h%ROWTYPE;

1: PACKAGE BODY igs_en_spl_perm_h_pkg AS
2: /* $Header: IGSEI54B.pls 115.4 2002/11/28 23:45:56 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_spl_perm_h%ROWTYPE;
6: new_references igs_en_spl_perm_h%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_spl_perm_h%ROWTYPE;

2: /* $Header: IGSEI54B.pls 115.4 2002/11/28 23:45:56 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_spl_perm_h%ROWTYPE;
6: new_references igs_en_spl_perm_h%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 42: FROM IGS_EN_SPL_PERM_H

38: */
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM IGS_EN_SPL_PERM_H
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 146: FROM igs_en_spl_perm_h

142: || (reverse chronological order - newest change first)
143: */
144: CURSOR cur_rowid IS
145: SELECT rowid
146: FROM igs_en_spl_perm_h
147: WHERE spl_perm_request_h_id = x_spl_perm_request_h_id
148: FOR UPDATE NOWAIT;
149:
150: lv_rowid cur_rowid%RowType;

Line 181: FROM igs_en_spl_perm_h

177: || (reverse chronological order - newest change first)
178: */
179: CURSOR cur_rowid IS
180: SELECT rowid
181: FROM igs_en_spl_perm_h
182: WHERE ((spl_perm_request_id = x_spl_perm_request_id));
183:
184: lv_rowid cur_rowid%RowType;
185:

Line 316: FROM igs_en_spl_perm_h

312: || (reverse chronological order - newest change first)
313: */
314: CURSOR c IS
315: SELECT rowid
316: FROM igs_en_spl_perm_h
317: WHERE spl_perm_request_h_id = x_spl_perm_request_h_id;
318:
319: x_last_update_date DATE;
320: x_last_updated_by NUMBER;

Line 344: SELECT igs_en_spl_perm_h_s.NEXTVAL

340: igs_ge_msg_stack.add;
341: app_exception.raise_exception;
342: END IF;
343:
344: SELECT igs_en_spl_perm_h_s.NEXTVAL
345: INTO x_spl_perm_request_h_id
346: FROM dual;
347:
348: before_dml(

Line 371: INSERT INTO igs_en_spl_perm_h (

367: x_last_updated_by => x_last_updated_by,
368: x_last_update_login => x_last_update_login
369: );
370:
371: INSERT INTO igs_en_spl_perm_h (
372: spl_perm_request_h_id,
373: spl_perm_request_id,
374: date_submission,
375: audit_the_course,

Line 461: FROM igs_en_spl_perm_h

457: transaction_type,
458: hist_start_dt,
459: hist_end_dt,
460: hist_who
461: FROM igs_en_spl_perm_h
462: WHERE rowid = x_rowid
463: FOR UPDATE NOWAIT;
464:
465: tlinfo c1%ROWTYPE;

Line 580: UPDATE igs_en_spl_perm_h

576: x_last_updated_by => x_last_updated_by,
577: x_last_update_login => x_last_update_login
578: );
579:
580: UPDATE igs_en_spl_perm_h
581: SET
582: spl_perm_request_id = new_references.spl_perm_request_id,
583: date_submission = new_references.date_submission,
584: audit_the_course = new_references.audit_the_course,

Line 634: FROM igs_en_spl_perm_h

630: || (reverse chronological order - newest change first)
631: */
632: CURSOR c1 IS
633: SELECT rowid
634: FROM igs_en_spl_perm_h
635: WHERE spl_perm_request_h_id = x_spl_perm_request_h_id;
636:
637: BEGIN
638:

Line 705: DELETE FROM igs_en_spl_perm_h

701: p_action => 'DELETE',
702: x_rowid => x_rowid
703: );
704:
705: DELETE FROM igs_en_spl_perm_h
706: WHERE rowid = x_rowid;
707:
708: IF (SQL%NOTFOUND) THEN
709: RAISE NO_DATA_FOUND;

Line 715: END igs_en_spl_perm_h_pkg;

711:
712: END delete_row;
713:
714:
715: END igs_en_spl_perm_h_pkg;