APPS.IGS_EN_ATTRIB_VALUES_PKG dependencies on IGS_EN_ATTRIB_VALUES

Line 1: PACKAGE BODY igs_en_attrib_values_pkg AS

1: PACKAGE BODY igs_en_attrib_values_pkg AS
2: /* $Header: IGSEI64B.pls 115.1 2002/11/28 23:48:09 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ATTRIB_VALUES%ROWTYPE;

Line 5: old_references IGS_EN_ATTRIB_VALUES%ROWTYPE;

1: PACKAGE BODY igs_en_attrib_values_pkg AS
2: /* $Header: IGSEI64B.pls 115.1 2002/11/28 23:48:09 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ATTRIB_VALUES%ROWTYPE;
6: new_references IGS_EN_ATTRIB_VALUES%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_EN_ATTRIB_VALUES%ROWTYPE;

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

Line 34: FROM IGS_EN_ATTRIB_VALUES

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

Line 119: FROM IGS_EN_ATTRIB_VALUES

115: || (reverse chronological order - newest change first)
116: */
117: CURSOR cur_rowid IS
118: SELECT rowid
119: FROM IGS_EN_ATTRIB_VALUES
120: WHERE obj_type_id = x_obj_type_id
121: AND obj_id = x_obj_id
122: AND attrib_id = x_attrib_id
123: AND version = x_version

Line 239: FROM IGS_EN_ATTRIB_VALUES

235: || (reverse chronological order - newest change first)
236: */
237: CURSOR c IS
238: SELECT rowid
239: FROM IGS_EN_ATTRIB_VALUES
240: WHERE obj_type_id = x_obj_type_id
241: AND obj_id = x_obj_id
242: AND attrib_id = x_attrib_id
243: AND version = x_version;

Line 285: INSERT INTO IGS_EN_ATTRIB_VALUES (

281: x_last_updated_by => x_last_updated_by,
282: x_last_update_login => x_last_update_login
283: );
284:
285: INSERT INTO IGS_EN_ATTRIB_VALUES (
286: obj_type_id,
287: obj_id,
288: attrib_id,
289: version,

Line 340: FROM IGS_EN_ATTRIB_VALUES

336: */
337: CURSOR c1 IS
338: SELECT
339: value
340: FROM IGS_EN_ATTRIB_VALUES
341: WHERE rowid = x_rowid
342: FOR UPDATE NOWAIT;
343:
344: tlinfo c1%ROWTYPE;

Line 432: UPDATE IGS_EN_ATTRIB_VALUES

428: x_last_updated_by => x_last_updated_by,
429: x_last_update_login => x_last_update_login
430: );
431:
432: UPDATE IGS_EN_ATTRIB_VALUES
433: SET
434: value = new_references.value,
435: last_update_date = x_last_update_date,
436: last_updated_by = x_last_updated_by,

Line 467: FROM IGS_EN_ATTRIB_VALUES

463: || (reverse chronological order - newest change first)
464: */
465: CURSOR c1 IS
466: SELECT rowid
467: FROM IGS_EN_ATTRIB_VALUES
468: WHERE obj_type_id = x_obj_type_id
469: AND obj_id = x_obj_id
470: AND attrib_id = x_attrib_id
471: AND version = x_version;

Line 525: DELETE FROM IGS_EN_ATTRIB_VALUES

521: p_action => 'DELETE',
522: x_rowid => x_rowid
523: );
524:
525: DELETE FROM IGS_EN_ATTRIB_VALUES
526: WHERE rowid = x_rowid;
527:
528: IF (SQL%NOTFOUND) THEN
529: RAISE NO_DATA_FOUND;

Line 535: END IGS_EN_ATTRIB_VALUES_pkg;

531:
532: END delete_row;
533:
534:
535: END IGS_EN_ATTRIB_VALUES_pkg;