APPS.IGS_FI_LOCKBOXES_PKG dependencies on IGS_FI_LOCKBOXES

Line 1: PACKAGE BODY igs_fi_lockboxes_pkg AS

1: PACKAGE BODY igs_fi_lockboxes_pkg AS
2: /* $Header: IGSSID1B.pls 120.1 2006/02/01 19:55:48 svuppala noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lockboxes%ROWTYPE;

Line 5: old_references igs_fi_lockboxes%ROWTYPE;

1: PACKAGE BODY igs_fi_lockboxes_pkg AS
2: /* $Header: IGSSID1B.pls 120.1 2006/02/01 19:55:48 svuppala noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lockboxes%ROWTYPE;
6: new_references igs_fi_lockboxes%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_lockboxes%ROWTYPE;

2: /* $Header: IGSSID1B.pls 120.1 2006/02/01 19:55:48 svuppala noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lockboxes%ROWTYPE;
6: new_references igs_fi_lockboxes%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 56: FROM igs_fi_lockboxes

52: */
53:
54: CURSOR cur_old_ref_values IS
55: SELECT *
56: FROM igs_fi_lockboxes
57: WHERE rowid = x_rowid;
58:
59: BEGIN
60:

Line 188: -- on igs_fi_lockboxes table.

184: || Who When What
185: || (reverse chronological order - newest change first)
186: */
187: -- Enh# 2831582, FOR UPDATE NOWAIT clause is removed to avoid locking issues as deletion is not allowed
188: -- on igs_fi_lockboxes table.
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM igs_fi_lockboxes
192: WHERE lockbox_name = x_lockbox_name;

Line 191: FROM igs_fi_lockboxes

187: -- Enh# 2831582, FOR UPDATE NOWAIT clause is removed to avoid locking issues as deletion is not allowed
188: -- on igs_fi_lockboxes table.
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM igs_fi_lockboxes
192: WHERE lockbox_name = x_lockbox_name;
193:
194: lv_rowid cur_rowid%RowType;
195:

Line 388: fnd_message.set_token ('ROUTINE', 'IGS_FI_LOCKBOXES_PKG.INSERT_ROW');

384: x_last_update_login := -1;
385: END IF;
386: ELSE
387: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
388: fnd_message.set_token ('ROUTINE', 'IGS_FI_LOCKBOXES_PKG.INSERT_ROW');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392:

Line 430: INSERT INTO igs_fi_lockboxes (

426: x_last_updated_by => x_last_updated_by,
427: x_last_update_login => x_last_update_login
428: );
429:
430: INSERT INTO igs_fi_lockboxes (
431: lockbox_name,
432: lockbox_desc,
433: closed_flag,
434: gl_date_source_code,

Line 568: FROM igs_fi_lockboxes

564: attribute17,
565: attribute18,
566: attribute19,
567: attribute20
568: FROM igs_fi_lockboxes
569: WHERE rowid = x_rowid
570: FOR UPDATE NOWAIT;
571:
572: tlinfo c1%ROWTYPE;

Line 687: fnd_message.set_token ('ROUTINE', 'IGS_FI_LOCKBOXES_PKG.UPDATE_ROW');

683: x_last_update_login := -1;
684: END IF;
685: ELSE
686: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
687: fnd_message.set_token ('ROUTINE', 'IGS_FI_LOCKBOXES_PKG.UPDATE_ROW');
688: igs_ge_msg_stack.add;
689: app_exception.raise_exception;
690: END IF;
691:

Line 729: UPDATE igs_fi_lockboxes

725: x_last_updated_by => x_last_updated_by,
726: x_last_update_login => x_last_update_login
727: );
728:
729: UPDATE igs_fi_lockboxes
730: SET
731: lockbox_desc = new_references.lockbox_desc,
732: closed_flag = new_references.closed_flag,
733: gl_date_source_code = new_references.gl_date_source_code,

Line 811: FROM igs_fi_lockboxes

807: || (reverse chronological order - newest change first)
808: */
809: CURSOR c1 IS
810: SELECT rowid
811: FROM igs_fi_lockboxes
812: WHERE lockbox_name = x_lockbox_name;
813:
814: BEGIN
815:

Line 891: END igs_fi_lockboxes_pkg;

887: END add_row;
888:
889: -- Removed delete_row as Deletion is not allowed on this table.
890:
891: END igs_fi_lockboxes_pkg;