APPS.IGS_FI_LB_REC_TYPES_PKG dependencies on IGS_FI_LB_REC_TYPES

Line 1: PACKAGE BODY igs_fi_lb_rec_types_pkg AS

1: PACKAGE BODY igs_fi_lb_rec_types_pkg AS
2: /* $Header: IGSSID4B.pls 115.1 2003/06/20 10:16:09 shtatiko noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lb_rec_types%ROWTYPE;

Line 5: old_references igs_fi_lb_rec_types%ROWTYPE;

1: PACKAGE BODY igs_fi_lb_rec_types_pkg AS
2: /* $Header: IGSSID4B.pls 115.1 2003/06/20 10:16:09 shtatiko noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lb_rec_types%ROWTYPE;
6: new_references igs_fi_lb_rec_types%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_lb_rec_types%ROWTYPE;

2: /* $Header: IGSSID4B.pls 115.1 2003/06/20 10:16:09 shtatiko noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lb_rec_types%ROWTYPE;
6: new_references igs_fi_lb_rec_types%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_fi_lb_rec_types

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

Line 141: FROM igs_fi_lb_rec_types

137: || (reverse chronological order - newest change first)
138: */
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM igs_fi_lb_rec_types
142: WHERE lockbox_name = x_lockbox_name
143: AND record_identifier_cd = x_record_identifier_cd
144: FOR UPDATE NOWAIT;
145:

Line 178: FROM igs_fi_lb_rec_types

174: || (reverse chronological order - newest change first)
175: */
176: CURSOR cur_rowid IS
177: SELECT rowid
178: FROM igs_fi_lb_rec_types
179: WHERE lockbox_name = x_lockbox_name
180: AND record_type_code = x_record_type_code
181: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
182:

Line 316: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_REC_TYPES_PKG.INSERT_ROW');

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

Line 334: INSERT INTO igs_fi_lb_rec_types (

330: x_last_updated_by => x_last_updated_by,
331: x_last_update_login => x_last_update_login
332: );
333:
334: INSERT INTO igs_fi_lb_rec_types (
335: lockbox_name,
336: record_identifier_cd,
337: record_type_code,
338: creation_date,

Line 375: FROM igs_fi_lb_rec_types

371: */
372: CURSOR c1 IS
373: SELECT
374: record_type_code
375: FROM igs_fi_lb_rec_types
376: WHERE rowid = x_rowid
377: FOR UPDATE NOWAIT;
378:
379: tlinfo c1%ROWTYPE;

Line 446: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_REC_TYPES_PKG.UPDATE_ROW');

442: x_last_update_login := -1;
443: END IF;
444: ELSE
445: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
446: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_REC_TYPES_PKG.UPDATE_ROW');
447: igs_ge_msg_stack.add;
448: app_exception.raise_exception;
449: END IF;
450:

Line 464: UPDATE igs_fi_lb_rec_types

460: x_last_updated_by => x_last_updated_by,
461: x_last_update_login => x_last_update_login
462: );
463:
464: UPDATE igs_fi_lb_rec_types
465: SET
466: record_type_code = new_references.record_type_code,
467: last_update_date = x_last_update_date,
468: last_updated_by = x_last_updated_by,

Line 497: FROM igs_fi_lb_rec_types

493: || (reverse chronological order - newest change first)
494: */
495: CURSOR c1 IS
496: SELECT rowid
497: FROM igs_fi_lb_rec_types
498: WHERE lockbox_name = x_lockbox_name
499: AND record_identifier_cd = x_record_identifier_cd;
500:
501: BEGIN

Line 549: DELETE FROM igs_fi_lb_rec_types

545: p_action => 'DELETE',
546: x_rowid => x_rowid
547: );
548:
549: DELETE FROM igs_fi_lb_rec_types
550: WHERE rowid = x_rowid;
551:
552: IF (SQL%NOTFOUND) THEN
553: RAISE NO_DATA_FOUND;

Line 559: END igs_fi_lb_rec_types_pkg;

555:
556: END delete_row;
557:
558:
559: END igs_fi_lb_rec_types_pkg;