APPS.IGS_EN_ELGB_OVR_PKG dependencies on IGS_EN_ELGB_OVR

Line 1: PACKAGE BODY igs_en_elgb_ovr_pkg AS

1: PACKAGE BODY igs_en_elgb_ovr_pkg AS
2: /* $Header: IGSEI51B.pls 120.1 2006/05/02 01:40:45 amuthu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_elgb_ovr_all%ROWTYPE;

Line 5: old_references igs_en_elgb_ovr_all%ROWTYPE;

1: PACKAGE BODY igs_en_elgb_ovr_pkg AS
2: /* $Header: IGSEI51B.pls 120.1 2006/05/02 01:40:45 amuthu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_elgb_ovr_all%ROWTYPE;
6: new_references igs_en_elgb_ovr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_elgb_ovr_all%ROWTYPE;

2: /* $Header: IGSEI51B.pls 120.1 2006/05/02 01:40:45 amuthu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_elgb_ovr_all%ROWTYPE;
6: new_references igs_en_elgb_ovr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM IGS_EN_ELGB_OVR_ALL

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

Line 148: igs_pe_hold_rel_ovr_pkg.get_fk_igs_en_elgb_ovr (

144: || (reverse chronological order - newest change first)
145: */
146: BEGIN
147:
148: igs_pe_hold_rel_ovr_pkg.get_fk_igs_en_elgb_ovr (
149: old_references.elgb_override_id
150: );
151:
152: igs_en_elgb_ovr_step_pkg.get_fk_igs_en_elgb_ovr (

Line 152: igs_en_elgb_ovr_step_pkg.get_fk_igs_en_elgb_ovr (

148: igs_pe_hold_rel_ovr_pkg.get_fk_igs_en_elgb_ovr (
149: old_references.elgb_override_id
150: );
151:
152: igs_en_elgb_ovr_step_pkg.get_fk_igs_en_elgb_ovr (
153: old_references.elgb_override_id
154: );
155: END check_child_existance;
156:

Line 172: FROM igs_en_elgb_ovr_all

168: || (reverse chronological order - newest change first)
169: */
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM igs_en_elgb_ovr_all
173: WHERE elgb_override_id = x_elgb_override_id
174: FOR UPDATE NOWAIT;
175:
176: lv_rowid cur_rowid%RowType;

Line 210: FROM igs_en_elgb_ovr

206: || (reverse chronological order - newest change first)
207: */
208: CURSOR cur_rowid IS
209: SELECT rowid
210: FROM igs_en_elgb_ovr
211: WHERE person_id = x_person_id
212: AND cal_type = x_cal_type
213: AND ci_sequence_number = x_ci_sequence_number
214: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 248: FROM igs_en_elgb_ovr_all

244: || (reverse chronological order - newest change first)
245: */
246: CURSOR cur_rowid IS
247: SELECT rowid
248: FROM igs_en_elgb_ovr_all
249: WHERE ((cal_type = x_cal_type) AND
250: (ci_sequence_number = x_sequence_number));
251:
252: lv_rowid cur_rowid%RowType;

Line 283: FROM igs_en_elgb_ovr_all

279: || (reverse chronological order - newest change first)
280: */
281: CURSOR cur_rowid IS
282: SELECT rowid
283: FROM igs_en_elgb_ovr_all
284: WHERE ((person_id = x_person_id));
285:
286: lv_rowid cur_rowid%RowType;
287:

Line 401: FROM igs_en_elgb_ovr_all

397: || (reverse chronological order - newest change first)
398: */
399: CURSOR c IS
400: SELECT rowid
401: FROM igs_en_elgb_ovr_all
402: WHERE elgb_override_id = x_elgb_override_id;
403:
404: x_last_update_date DATE;
405: x_last_updated_by NUMBER;

Line 445: SELECT igs_en_elgb_ovr_s.NEXTVAL

441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;
444:
445: SELECT igs_en_elgb_ovr_s.NEXTVAL
446: INTO x_elgb_override_id
447: FROM dual;
448:
449: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 465: INSERT INTO igs_en_elgb_ovr_all (

461: x_last_updated_by => x_last_updated_by,
462: x_last_update_login => x_last_update_login
463: );
464:
465: INSERT INTO igs_en_elgb_ovr_all (
466: elgb_override_id,
467: person_id,
468: cal_type,
469: ci_sequence_number,

Line 529: FROM igs_en_elgb_ovr_all

525: SELECT
526: person_id,
527: cal_type,
528: ci_sequence_number
529: FROM igs_en_elgb_ovr_all
530: WHERE rowid = x_rowid
531: FOR UPDATE NOWAIT;
532:
533: tlinfo c1%ROWTYPE;

Line 639: UPDATE igs_en_elgb_ovr_all

635: x_program_update_date := SYSDATE;
636: END IF;
637: END IF;
638:
639: UPDATE igs_en_elgb_ovr_all
640: SET
641: person_id = new_references.person_id,
642: cal_type = new_references.cal_type,
643: ci_sequence_number = new_references.ci_sequence_number,

Line 679: FROM igs_en_elgb_ovr_all

675: || (reverse chronological order - newest change first)
676: */
677: CURSOR c1 IS
678: SELECT rowid
679: FROM igs_en_elgb_ovr_all
680: WHERE elgb_override_id = x_elgb_override_id;
681:
682: BEGIN
683:

Line 732: DELETE FROM igs_en_elgb_ovr_all

728: p_action => 'DELETE',
729: x_rowid => x_rowid
730: );
731:
732: DELETE FROM igs_en_elgb_ovr_all
733: WHERE rowid = x_rowid;
734:
735: IF (SQL%NOTFOUND) THEN
736: RAISE NO_DATA_FOUND;

Line 742: END igs_en_elgb_ovr_pkg;

738:
739: END delete_row;
740:
741:
742: END igs_en_elgb_ovr_pkg;