APPS.IGS_OR_LOC_REGION_PKG dependencies on IGS_OR_LOC_REGION

Line 1: PACKAGE BODY igs_or_loc_region_pkg AS

1: PACKAGE BODY igs_or_loc_region_pkg AS
2: /* $Header: IGSOI34B.pls 115.1 2003/10/30 13:30:15 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_loc_region%ROWTYPE;

Line 5: old_references igs_or_loc_region%ROWTYPE;

1: PACKAGE BODY igs_or_loc_region_pkg AS
2: /* $Header: IGSOI34B.pls 115.1 2003/10/30 13:30:15 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_loc_region%ROWTYPE;
6: new_references igs_or_loc_region%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_or_loc_region%ROWTYPE;

2: /* $Header: IGSOI34B.pls 115.1 2003/10/30 13:30:15 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_loc_region%ROWTYPE;
6: new_references igs_or_loc_region%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 31: FROM igs_or_loc_region

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

Line 149: FROM igs_or_loc_region

145: || (reverse chronological order - newest change first)
146: */
147: CURSOR cur_rowid IS
148: SELECT rowid
149: FROM igs_or_loc_region
150: WHERE location_cd = x_location_cd
151: AND region_cd = x_region_cd
152: FOR UPDATE NOWAIT;
153:

Line 185: FROM igs_or_loc_region

181: || (reverse chronological order - newest change first)
182: */
183: CURSOR cur_rowid IS
184: SELECT rowid
185: FROM igs_or_loc_region
186: WHERE ((location_cd = x_location_cd));
187:
188: lv_rowid cur_rowid%RowType;
189:

Line 317: fnd_message.set_token ('ROUTINE', 'IGS_OR_LOC_REGION_PKG.INSERT_ROW');

313: x_last_update_login := -1;
314: END IF;
315: ELSE
316: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
317: fnd_message.set_token ('ROUTINE', 'IGS_OR_LOC_REGION_PKG.INSERT_ROW');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: END IF;
321:

Line 334: INSERT INTO igs_or_loc_region (

330: x_last_updated_by => x_last_updated_by,
331: x_last_update_login => x_last_update_login
332: );
333:
334: INSERT INTO igs_or_loc_region (
335: location_cd,
336: region_cd,
337: creation_date,
338: created_by,

Line 372: FROM igs_or_loc_region

368: */
369: CURSOR c1 IS
370: SELECT
371: rowid
372: FROM igs_or_loc_region
373: WHERE rowid = x_rowid
374: FOR UPDATE NOWAIT;
375:
376: tlinfo c1%ROWTYPE;

Line 416: DELETE FROM igs_or_loc_region

412: p_action => 'DELETE',
413: x_rowid => x_rowid
414: );
415:
416: DELETE FROM igs_or_loc_region
417: WHERE rowid = x_rowid;
418:
419: IF (SQL%NOTFOUND) THEN
420: RAISE NO_DATA_FOUND;

Line 426: END igs_or_loc_region_pkg;

422:
423: END delete_row;
424:
425:
426: END igs_or_loc_region_pkg;