APPS.IGS_EN_UNIT_SET_MAP_PKG dependencies on IGS_EN_UNIT_SET_MAP

Line 1: PACKAGE BODY igs_en_unit_set_map_pkg AS

1: PACKAGE BODY igs_en_unit_set_map_pkg AS
2: /* $Header: IGSEI70B.pls 115.1 2003/06/06 11:42:19 myoganat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_unit_set_map%ROWTYPE;

Line 5: old_references igs_en_unit_set_map%ROWTYPE;

1: PACKAGE BODY igs_en_unit_set_map_pkg AS
2: /* $Header: IGSEI70B.pls 115.1 2003/06/06 11:42:19 myoganat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_unit_set_map%ROWTYPE;
6: new_references igs_en_unit_set_map%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_unit_set_map%ROWTYPE;

2: /* $Header: IGSEI70B.pls 115.1 2003/06/06 11:42:19 myoganat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_unit_set_map%ROWTYPE;
6: new_references igs_en_unit_set_map%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igs_en_unit_set_map

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

Line 134: FROM igs_en_unit_set_map

130: || (reverse chronological order - newest change first)
131: */
132: CURSOR cur_rowid IS
133: SELECT rowid
134: FROM igs_en_unit_set_map
135: WHERE mapping_set_cd = x_mapping_set_cd
136: AND sequence_no = x_sequence_no
137: AND stream_unit_set_cd = x_stream_unit_set_cd
138: AND us_version_number = x_us_version_number

Line 173: FROM igs_en_unit_set_map

169: || (reverse chronological order - newest change first)
170: */
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM igs_en_unit_set_map
174: WHERE ((stream_unit_set_cd = x_unit_set_cd) AND
175: (us_version_number = x_version_number));
176:
177: lv_rowid cur_rowid%RowType;

Line 210: FROM igs_en_unit_set_map

206: || (reverse chronological order - newest change first)
207: */
208: CURSOR cur_rowid IS
209: SELECT rowid
210: FROM igs_en_unit_set_map
211: WHERE ((mapping_set_cd = x_mapping_set_cd) AND
212: (sequence_no = x_sequence_no));
213:
214: lv_rowid cur_rowid%RowType;

Line 345: fnd_message.set_token ('ROUTINE', 'IGS_EN_UNIT_SET_MAP_PKG.INSERT_ROW');

341: x_last_update_login := -1;
342: END IF;
343: ELSE
344: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
345: fnd_message.set_token ('ROUTINE', 'IGS_EN_UNIT_SET_MAP_PKG.INSERT_ROW');
346: igs_ge_msg_stack.add;
347: app_exception.raise_exception;
348: END IF;
349:

Line 364: INSERT INTO igs_en_unit_set_map (

360: x_last_updated_by => x_last_updated_by,
361: x_last_update_login => x_last_update_login
362: );
363:
364: INSERT INTO igs_en_unit_set_map (
365: mapping_set_cd,
366: sequence_no,
367: stream_unit_set_cd,
368: us_version_number,

Line 408: FROM igs_en_unit_set_map

404: */
405: CURSOR c1 IS
406: SELECT
407: rowid
408: FROM igs_en_unit_set_map
409: WHERE rowid = x_rowid
410: FOR UPDATE NOWAIT;
411:
412: tlinfo c1%ROWTYPE;

Line 452: DELETE FROM igs_en_unit_set_map

448: p_action => 'DELETE',
449: x_rowid => x_rowid
450: );
451:
452: DELETE FROM igs_en_unit_set_map
453: WHERE rowid = x_rowid;
454:
455: IF (SQL%NOTFOUND) THEN
456: RAISE NO_DATA_FOUND;

Line 461: END igs_en_unit_set_map_pkg;

457: END IF;
458:
459: END delete_row;
460:
461: END igs_en_unit_set_map_pkg;