APPS.IGS_FI_HIER_ACCT_TBL_PKG dependencies on IGS_FI_HIER_ACCT_TBL

Line 1: PACKAGE BODY igs_fi_hier_acct_tbl_pkg AS

1: PACKAGE BODY igs_fi_hier_acct_tbl_pkg AS
2: /* $Header: IGSSIA9B.pls 115.5 2002/11/29 04:03:08 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_hier_acct_tbl%ROWTYPE;

Line 5: old_references igs_fi_hier_acct_tbl%ROWTYPE;

1: PACKAGE BODY igs_fi_hier_acct_tbl_pkg AS
2: /* $Header: IGSSIA9B.pls 115.5 2002/11/29 04:03:08 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_hier_acct_tbl%ROWTYPE;
6: new_references igs_fi_hier_acct_tbl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_hier_acct_tbl%ROWTYPE;

2: /* $Header: IGSSIA9B.pls 115.5 2002/11/29 04:03:08 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_hier_acct_tbl%ROWTYPE;
6: new_references igs_fi_hier_acct_tbl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_FI_HIER_ACCT_TBL

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

Line 114: FROM igs_fi_hier_acct_tbl

110: || (reverse chronological order - newest change first)
111: */
112: CURSOR cur_rowid IS
113: SELECT rowid
114: FROM igs_fi_hier_acct_tbl
115: WHERE acct_tbl_id = x_acct_tbl_id
116: FOR UPDATE NOWAIT;
117:
118: lv_rowid cur_rowid%RowType;

Line 149: FROM igs_fi_hier_acct_tbl

145: || (reverse chronological order - newest change first)
146: */
147: CURSOR cur_rowid IS
148: SELECT rowid
149: FROM igs_fi_hier_acct_tbl
150: WHERE ((acct_hier_id = x_acct_hier_id));
151:
152: lv_rowid cur_rowid%RowType;
153:

Line 257: FROM igs_fi_hier_acct_tbl

253: || (reverse chronological order - newest change first)
254: */
255: CURSOR c IS
256: SELECT rowid
257: FROM igs_fi_hier_acct_tbl
258: WHERE acct_tbl_id = x_acct_tbl_id;
259:
260: x_last_update_date DATE;
261: x_last_updated_by NUMBER;

Line 285: SELECT igs_fi_hier_acct_tbl_s.NEXTVAL

281: igs_ge_msg_stack.add;
282: app_exception.raise_exception;
283: END IF;
284:
285: SELECT igs_fi_hier_acct_tbl_s.NEXTVAL
286: INTO x_acct_tbl_id
287: FROM dual;
288:
289: before_dml(

Line 303: INSERT INTO igs_fi_hier_acct_tbl (

299: x_last_updated_by => x_last_updated_by,
300: x_last_update_login => x_last_update_login
301: );
302:
303: INSERT INTO igs_fi_hier_acct_tbl (
304: acct_tbl_id,
305: acct_hier_id,
306: order_sequence,
307: entity_type_code,

Line 357: FROM igs_fi_hier_acct_tbl

353: SELECT
354: acct_hier_id,
355: order_sequence,
356: entity_type_code
357: FROM igs_fi_hier_acct_tbl
358: WHERE rowid = x_rowid
359: FOR UPDATE NOWAIT;
360:
361: tlinfo c1%ROWTYPE;

Line 449: UPDATE igs_fi_hier_acct_tbl

445: x_last_updated_by => x_last_updated_by,
446: x_last_update_login => x_last_update_login
447: );
448:
449: UPDATE igs_fi_hier_acct_tbl
450: SET
451: acct_hier_id = new_references.acct_hier_id,
452: order_sequence = new_references.order_sequence,
453: entity_type_code = new_references.entity_type_code,

Line 485: FROM igs_fi_hier_acct_tbl

481: || (reverse chronological order - newest change first)
482: */
483: CURSOR c1 IS
484: SELECT rowid
485: FROM igs_fi_hier_acct_tbl
486: WHERE acct_tbl_id = x_acct_tbl_id;
487:
488: BEGIN
489:

Line 538: DELETE FROM igs_fi_hier_acct_tbl

534: p_action => 'DELETE',
535: x_rowid => x_rowid
536: );
537:
538: DELETE FROM igs_fi_hier_acct_tbl
539: WHERE rowid = x_rowid;
540:
541: IF (SQL%NOTFOUND) THEN
542: RAISE NO_DATA_FOUND;

Line 548: END igs_fi_hier_acct_tbl_pkg;

544:
545: END delete_row;
546:
547:
548: END igs_fi_hier_acct_tbl_pkg;