APPS.IGS_HE_CODE_MAP_VAL_PKG dependencies on IGS_HE_CODE_MAP_VAL

Line 1: PACKAGE BODY igs_he_code_map_val_pkg AS

1: PACKAGE BODY igs_he_code_map_val_pkg AS
2: /* $Header: IGSWI03B.pls 115.7 2003/01/07 06:21:34 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_code_map_val%ROWTYPE;

Line 5: old_references igs_he_code_map_val%ROWTYPE;

1: PACKAGE BODY igs_he_code_map_val_pkg AS
2: /* $Header: IGSWI03B.pls 115.7 2003/01/07 06:21:34 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_code_map_val%ROWTYPE;
6: new_references igs_he_code_map_val%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_code_map_val%ROWTYPE;

2: /* $Header: IGSWI03B.pls 115.7 2003/01/07 06:21:34 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_code_map_val%ROWTYPE;
6: new_references igs_he_code_map_val%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 42: FROM IGS_HE_CODE_MAP_VAL

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

Line 132: FROM igs_he_code_map_val

128: || (reverse chronological order - newest change first)
129: */
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM igs_he_code_map_val
133: WHERE sequence = x_sequence
134: FOR UPDATE NOWAIT;
135:
136: lv_rowid cur_rowid%RowType;

Line 167: FROM igs_he_code_map_val

163: || (reverse chronological order - newest change first)
164: */
165: CURSOR cur_rowid IS
166: SELECT rowid
167: FROM igs_he_code_map_val
168: WHERE ((association_code = x_association_code));
169:
170: lv_rowid cur_rowid%RowType;
171:

Line 211: FROM igs_he_code_map_val

207: || smaddali modified cursor cur_rowid to add check for rowid as it was missing
208: */
209: CURSOR cur_rowid IS
210: SELECT rowid
211: FROM igs_he_code_map_val
212: WHERE association_code = x_association_code
213: AND map1 = x_map1
214: AND map2 = x_map2
215: AND ((map3 = x_map3) OR (map3 IS NULL AND x_map3 IS NULL))

Line 387: FROM igs_he_code_map_val

383: || (reverse chronological order - newest change first)
384: */
385: CURSOR c IS
386: SELECT rowid
387: FROM igs_he_code_map_val
388: WHERE sequence = x_sequence;
389:
390: x_last_update_date DATE;
391: x_last_updated_by NUMBER;

Line 415: SELECT igs_he_code_map_val_s.NEXTVAL

411: igs_ge_msg_stack.add;
412: app_exception.raise_exception;
413: END IF;
414:
415: SELECT igs_he_code_map_val_s.NEXTVAL
416: INTO x_sequence
417: FROM dual;
418:
419: before_dml(

Line 442: INSERT INTO igs_he_code_map_val (

438: x_last_updated_by => x_last_updated_by,
439: x_last_update_login => x_last_update_login
440: );
441:
442: INSERT INTO igs_he_code_map_val (
443: association_code,
444: sequence,
445: map_description,
446: map1,

Line 532: FROM igs_he_code_map_val

528: map7,
529: map8,
530: map9,
531: map10
532: FROM igs_he_code_map_val
533: WHERE rowid = x_rowid
534: FOR UPDATE NOWAIT;
535:
536: tlinfo c1%ROWTYPE;

Line 651: UPDATE igs_he_code_map_val

647: x_last_updated_by => x_last_updated_by,
648: x_last_update_login => x_last_update_login
649: );
650:
651: UPDATE igs_he_code_map_val
652: SET
653: association_code = new_references.association_code,
654: map_description = new_references.map_description,
655: map1 = new_references.map1,

Line 705: FROM igs_he_code_map_val

701: || (reverse chronological order - newest change first)
702: */
703: CURSOR c1 IS
704: SELECT rowid
705: FROM igs_he_code_map_val
706: WHERE sequence = x_sequence;
707:
708:
709: BEGIN

Line 789: DELETE FROM igs_he_code_map_val

785: p_action => 'DELETE',
786: x_rowid => x_rowid
787: );
788:
789: DELETE FROM igs_he_code_map_val
790: WHERE rowid = x_rowid;
791:
792: IF (SQL%NOTFOUND) THEN
793: RAISE NO_DATA_FOUND;

Line 799: END igs_he_code_map_val_pkg;

795:
796: END delete_row;
797:
798:
799: END igs_he_code_map_val_pkg;