APPS.IGS_EN_SPLACE_FACS_PKG dependencies on IGS_EN_SPLACE_FACS

Line 1: PACKAGE BODY igs_en_splace_facs_pkg AS

1: PACKAGE BODY igs_en_splace_facs_pkg AS
2: /* $Header: IGSEI75B.pls 120.0 2005/06/01 20:57:18 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_splace_facs%ROWTYPE;

Line 5: old_references igs_en_splace_facs%ROWTYPE;

1: PACKAGE BODY igs_en_splace_facs_pkg AS
2: /* $Header: IGSEI75B.pls 120.0 2005/06/01 20:57:18 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_splace_facs%ROWTYPE;
6: new_references igs_en_splace_facs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_splace_facs%ROWTYPE;

2: /* $Header: IGSEI75B.pls 120.0 2005/06/01 20:57:18 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_splace_facs%ROWTYPE;
6: new_references igs_en_splace_facs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 31: FROM igs_en_splace_facs

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

Line 85: FROM igs_en_splace_facs

81: || (reverse chronological order - newest change first)
82: */
83: CURSOR cur_rowid IS
84: SELECT rowid
85: FROM igs_en_splace_facs
86: WHERE splacement_id = x_splacement_id
87: AND faculty_id = x_faculty_id
88: FOR UPDATE NOWAIT;
89:

Line 206: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPLACE_FACS_PKG.INSERT_ROW');

202: x_last_update_login := -1;
203: END IF;
204: ELSE
205: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
206: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPLACE_FACS_PKG.INSERT_ROW');
207: igs_ge_msg_stack.add;
208: app_exception.raise_exception;
209: END IF;
210:

Line 223: INSERT INTO igs_en_splace_facs (

219: x_last_updated_by => x_last_updated_by,
220: x_last_update_login => x_last_update_login
221: );
222:
223: INSERT INTO igs_en_splace_facs (
224: splacement_id,
225: faculty_id,
226: creation_date,
227: created_by,

Line 261: FROM igs_en_splace_facs

257: */
258: CURSOR c1 IS
259: SELECT
260: rowid
261: FROM igs_en_splace_facs
262: WHERE rowid = x_rowid
263: FOR UPDATE NOWAIT;
264:
265: tlinfo c1%ROWTYPE;

Line 305: DELETE FROM igs_en_splace_facs

301: p_action => 'DELETE',
302: x_rowid => x_rowid
303: );
304:
305: DELETE FROM igs_en_splace_facs
306: WHERE rowid = x_rowid;
307:
308: IF (SQL%NOTFOUND) THEN
309: RAISE NO_DATA_FOUND;

Line 315: END igs_en_splace_facs_pkg;

311:
312: END delete_row;
313:
314:
315: END igs_en_splace_facs_pkg;