APPS.IGS_EN_REP_PROCESS_PKG dependencies on IGS_EN_REP_PROCESS

Line 1: PACKAGE BODY igs_en_rep_process_pkg AS

1: PACKAGE BODY igs_en_rep_process_pkg AS
2: /* $Header: IGSEI60B.pls 115.5 2002/11/28 23:47:01 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_rep_process%ROWTYPE;

Line 5: old_references igs_en_rep_process%ROWTYPE;

1: PACKAGE BODY igs_en_rep_process_pkg AS
2: /* $Header: IGSEI60B.pls 115.5 2002/11/28 23:47:01 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_rep_process%ROWTYPE;
6: new_references igs_en_rep_process%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_rep_process%ROWTYPE;

2: /* $Header: IGSEI60B.pls 115.5 2002/11/28 23:47:01 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_rep_process%ROWTYPE;
6: new_references igs_en_rep_process%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM IGS_EN_REP_PROCESS

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_EN_REP_PROCESS
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 158: FROM igs_en_rep_process

154: || (reverse chronological order - newest change first)
155: */
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM igs_en_rep_process
159: WHERE repeat_process_id = x_repeat_process_id
160: FOR UPDATE NOWAIT;
161:
162: lv_rowid cur_rowid%RowType;

Line 195: FROM igs_en_rep_process

191: || missing in the where clause of the cursor.
192: */
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM igs_en_rep_process
196: WHERE ((org_unit_id = x_org_unit_id) -- The extreme left parenthesis was missing earlier, Added by Nishikant, Bug#2383216
197: OR ( org_unit_id IS NULL AND x_org_unit_id IS NULL)) -- The extreme right parenthesis was missing earlier, Added by Nishikant, Bug#2383216
198: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
199: -- also check if the null record (i.e record with organization unit cd as null) exists.

Line 322: FROM igs_en_rep_process

318: || (reverse chronological order - newest change first)
319: */
320: CURSOR c IS
321: SELECT rowid
322: FROM igs_en_rep_process
323: WHERE repeat_process_id = x_repeat_process_id;
324:
325: x_last_update_date DATE;
326: x_last_updated_by NUMBER;

Line 350: SELECT igs_en_rep_process_s.NEXTVAL

346: igs_ge_msg_stack.add;
347: app_exception.raise_exception;
348: END IF;
349:
350: SELECT igs_en_rep_process_s.NEXTVAL
351: INTO x_repeat_process_id
352: FROM dual;
353:
354: before_dml(

Line 372: INSERT INTO igs_en_rep_process (

368: x_last_updated_by => x_last_updated_by,
369: x_last_update_login => x_last_update_login
370: );
371:
372: INSERT INTO igs_en_rep_process (
373: repeat_process_id,
374: org_unit_id,
375: include_adv_standing_units,
376: max_repeats_for_credit,

Line 442: FROM igs_en_rep_process

438: max_repeats_for_funding,
439: use_most_recent_unit_attempt,
440: use_best_grade_attempt,
441: external_formula
442: FROM igs_en_rep_process
443: WHERE rowid = x_rowid
444: FOR UPDATE NOWAIT;
445:
446: tlinfo c1%ROWTYPE;

Line 546: UPDATE igs_en_rep_process

542: x_last_updated_by => x_last_updated_by,
543: x_last_update_login => x_last_update_login
544: );
545:
546: UPDATE igs_en_rep_process
547: SET
548: org_unit_id = new_references.org_unit_id,
549: include_adv_standing_units = new_references.include_adv_standing_units,
550: max_repeats_for_credit = new_references.max_repeats_for_credit,

Line 590: FROM igs_en_rep_process

586: || (reverse chronological order - newest change first)
587: */
588: CURSOR c1 IS
589: SELECT rowid
590: FROM igs_en_rep_process
591: WHERE repeat_process_id = x_repeat_process_id;
592:
593: BEGIN
594:

Line 651: DELETE FROM igs_en_rep_process

647: p_action => 'DELETE',
648: x_rowid => x_rowid
649: );
650:
651: DELETE FROM igs_en_rep_process
652: WHERE rowid = x_rowid;
653:
654: IF (SQL%NOTFOUND) THEN
655: RAISE NO_DATA_FOUND;

Line 661: END igs_en_rep_process_pkg;

657:
658: END delete_row;
659:
660:
661: END igs_en_rep_process_pkg;