APPS.IGS_SC_PER_ATTR_VALS_PKG dependencies on IGS_SC_PER_ATTR_VALS

Line 1: PACKAGE BODY IGS_SC_PER_ATTR_VALS_PKG AS

1: PACKAGE BODY IGS_SC_PER_ATTR_VALS_PKG AS
2: /* $Header: IGSSC08B.pls 120.1 2005/09/08 14:33:27 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_sc_per_attr_vals%ROWTYPE;

Line 5: old_references igs_sc_per_attr_vals%ROWTYPE;

1: PACKAGE BODY IGS_SC_PER_ATTR_VALS_PKG AS
2: /* $Header: IGSSC08B.pls 120.1 2005/09/08 14:33:27 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_sc_per_attr_vals%ROWTYPE;
6: new_references igs_sc_per_attr_vals%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_sc_per_attr_vals%ROWTYPE;

2: /* $Header: IGSSC08B.pls 120.1 2005/09/08 14:33:27 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_sc_per_attr_vals%ROWTYPE;
6: new_references igs_sc_per_attr_vals%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_sc_per_attr_vals

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

Line 177: FROM IGS_SC_PER_ATTR_VALS

173:
174: ----------------------------------------------------------------------------------------------
175: CURSOR cur_rowid IS
176: SELECT rowid
177: FROM IGS_SC_PER_ATTR_VALS
178: WHERE person_id = x_person_id
179: AND user_attrib_id = x_user_attrib_id
180: AND user_attrib_value = x_user_attrib_value
181: FOR UPDATE NOWAIT;

Line 234: fnd_message.set_token ('ROUTINE', 'igs_sc_per_attr_vals_PKG.INSERT_ROW');

230: x_last_update_login := -1;
231: END IF;
232: ELSE
233: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
234: fnd_message.set_token ('ROUTINE', 'igs_sc_per_attr_vals_PKG.INSERT_ROW');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238:

Line 252: INSERT INTO igs_sc_per_attr_vals (

248: x_last_updated_by => x_last_updated_by,
249: x_last_update_login => x_last_update_login
250: );
251:
252: INSERT INTO igs_sc_per_attr_vals (
253: person_id,
254: user_attrib_id,
255: user_attrib_value,
256: creation_date,

Line 295: FROM igs_sc_per_attr_vals

291: SELECT
292: person_id,
293: user_attrib_id,
294: user_attrib_value
295: FROM igs_sc_per_attr_vals
296: WHERE rowid = x_rowid
297: FOR UPDATE NOWAIT;
298:
299: tlinfo c1%ROWTYPE;

Line 368: fnd_message.set_token ('ROUTINE', 'igs_sc_per_attr_vals_PKG.UPDATE_ROW');

364: x_last_update_login := -1;
365: END IF;
366: ELSE
367: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
368: fnd_message.set_token ('ROUTINE', 'igs_sc_per_attr_vals_PKG.UPDATE_ROW');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: END IF;
372:

Line 386: UPDATE igs_sc_per_attr_vals

382: x_last_updated_by => x_last_updated_by,
383: x_last_update_login => x_last_update_login
384: );
385:
386: UPDATE igs_sc_per_attr_vals
387: SET
388: person_id = new_references.person_id,
389: user_attrib_id = new_references.user_attrib_id,
390: user_attrib_value = new_references.user_attrib_value,

Line 421: FROM igs_sc_per_attr_vals

417: || (reverse chronological order - newest change first)
418: */
419: CURSOR c1 IS
420: SELECT rowid
421: FROM igs_sc_per_attr_vals
422: WHERE person_id =x_person_id AND
423: user_attrib_id = x_user_attrib_id AND
424: user_attrib_value = x_user_attrib_value;
425:

Line 474: DELETE FROM igs_sc_per_attr_vals

470: p_action => 'DELETE',
471: x_rowid => x_rowid
472: );
473:
474: DELETE FROM igs_sc_per_attr_vals
475: WHERE rowid = x_rowid;
476:
477: IF (SQL%NOTFOUND) THEN
478: RAISE NO_DATA_FOUND;

Line 484: END IGS_SC_PER_ATTR_VALS_PKG;

480:
481: END delete_row;
482:
483:
484: END IGS_SC_PER_ATTR_VALS_PKG;
485: