APPS.IGS_OR_UNIT_ACCTS_PKG dependencies on IGS_OR_UNIT_ACCTS_ALL

Line 5: old_references igs_or_unit_accts_all%ROWTYPE;

1: PACKAGE BODY igs_or_unit_accts_pkg AS
2: /* $Header: IGSOI32B.pls 115.4 2002/11/29 01:44:53 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_unit_accts_all%ROWTYPE;
6: new_references igs_or_unit_accts_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_or_unit_accts_all%ROWTYPE;

2: /* $Header: IGSOI32B.pls 115.4 2002/11/29 01:44:53 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_unit_accts_all%ROWTYPE;
6: new_references igs_or_unit_accts_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_OR_UNIT_ACCTS_ALL

31: */
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_OR_UNIT_ACCTS_ALL
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 92: FROM igs_or_unit_accts_all

88: || (reverse chronological order - newest change first)
89: */
90: CURSOR cur_rowid IS
91: SELECT rowid
92: FROM igs_or_unit_accts_all
93: WHERE org_account_id = x_org_account_id
94: FOR UPDATE NOWAIT;
95:
96: lv_rowid cur_rowid%RowType;

Line 202: FROM igs_or_unit_accts_all

198: || (reverse chronological order - newest change first)
199: */
200: CURSOR c IS
201: SELECT rowid
202: FROM igs_or_unit_accts_all
203: WHERE org_account_id = x_org_account_id;
204:
205: x_last_update_date DATE;
206: x_last_updated_by NUMBER;

Line 252: INSERT INTO igs_or_unit_accts_all (

248: x_last_updated_by => x_last_updated_by,
249: x_last_update_login => x_last_update_login
250: );
251:
252: INSERT INTO igs_or_unit_accts_all (
253: org_account_id,
254: org_unit_cd,
255: start_dt,
256: segment,

Line 316: FROM igs_or_unit_accts_all

312: start_dt,
313: segment,
314: segment_num,
315: segment_value
316: FROM igs_or_unit_accts_all
317: WHERE rowid = x_rowid
318: FOR UPDATE NOWAIT;
319:
320: tlinfo c1%ROWTYPE;

Line 414: UPDATE igs_or_unit_accts_all

410: x_last_updated_by => x_last_updated_by,
411: x_last_update_login => x_last_update_login
412: );
413:
414: UPDATE igs_or_unit_accts_all
415: SET
416: org_unit_cd = new_references.org_unit_cd,
417: start_dt = new_references.start_dt,
418: segment = new_references.segment,

Line 454: FROM igs_or_unit_accts_all

450: || (reverse chronological order - newest change first)
451: */
452: CURSOR c1 IS
453: SELECT rowid
454: FROM igs_or_unit_accts_all
455: WHERE org_account_id = x_org_account_id;
456:
457: BEGIN
458:

Line 511: DELETE FROM igs_or_unit_accts_all

507: p_action => 'DELETE',
508: x_rowid => x_rowid
509: );
510:
511: DELETE FROM igs_or_unit_accts_all
512: WHERE rowid = x_rowid;
513:
514: IF (SQL%NOTFOUND) THEN
515: RAISE NO_DATA_FOUND;