APPS.IGS_PE_RACE_PKG dependencies on IGS_PE_RACE

Line 1: PACKAGE BODY igs_pe_race_pkg AS

1: PACKAGE BODY igs_pe_race_pkg AS
2: /* $Header: IGSNIB0B.pls 120.1 2005/10/17 02:22:31 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_race%ROWTYPE;

Line 5: old_references igs_pe_race%ROWTYPE;

1: PACKAGE BODY igs_pe_race_pkg AS
2: /* $Header: IGSNIB0B.pls 120.1 2005/10/17 02:22:31 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_race%ROWTYPE;
6: new_references igs_pe_race%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_race%ROWTYPE;

2: /* $Header: IGSNIB0B.pls 120.1 2005/10/17 02:22:31 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_race%ROWTYPE;
6: new_references igs_pe_race%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 31: FROM igs_pe_race

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

Line 120: FROM igs_pe_race

116: || (reverse chronological order - newest change first)
117: */
118: CURSOR cur_rowid IS
119: SELECT rowid
120: FROM igs_pe_race
121: WHERE person_id = x_person_id
122: AND race_cd = x_race_cd
123: FOR UPDATE NOWAIT;
124:

Line 184: fnd_message.set_name('IGS','IGS_PE_RACE_DUP_EXISTS');

180: new_references.person_id,
181: new_references.race_cd
182: )
183: ) THEN
184: fnd_message.set_name('IGS','IGS_PE_RACE_DUP_EXISTS');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: END IF;
188:

Line 198: fnd_message.set_name('IGS','IGS_PE_RACE_DUP_EXISTS');

194: new_references.person_id,
195: new_references.race_cd
196: )
197: ) THEN
198: fnd_message.set_name('IGS','IGS_PE_RACE_DUP_EXISTS');
199: igs_ge_msg_stack.add;
200: app_exception.raise_exception;
201: END IF;
202: END IF;

Line 246: fnd_message.set_token ('ROUTINE', 'IGS_PE_RACE_PKG.INSERT_ROW');

242: x_last_update_login := -1;
243: END IF;
244: ELSE
245: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
246: fnd_message.set_token ('ROUTINE', 'IGS_PE_RACE_PKG.INSERT_ROW');
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: END IF;
250:

Line 266: INSERT INTO igs_pe_race (

262:
263: IF (x_mode = 'S') THEN
264: igs_sc_gen_001.set_ctx('R');
265: END IF;
266: INSERT INTO igs_pe_race (
267: person_id,
268: race_cd,
269: creation_date,
270: created_by,

Line 321: FROM igs_pe_race

317: */
318: CURSOR c1 IS
319: SELECT
320: rowid
321: FROM igs_pe_race
322: WHERE rowid = x_rowid
323: FOR UPDATE NOWAIT;
324:
325: tlinfo c1%ROWTYPE;

Line 369: DELETE FROM igs_pe_race

365:
366: IF (x_mode = 'S') THEN
367: igs_sc_gen_001.set_ctx('R');
368: END IF;
369: DELETE FROM igs_pe_race
370: WHERE rowid = x_rowid;
371:
372: IF (SQL%NOTFOUND) THEN
373: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 386: END igs_pe_race_pkg;

382:
383: END delete_row;
384:
385:
386: END igs_pe_race_pkg;