APPS.IGS_OR_UNIT_ACCT_CD_PKG dependencies on IGS_OR_UNIT_ACCT_CD_ALL

Line 5: old_references igs_or_unit_acct_cd_all%ROWTYPE;

1: PACKAGE BODY igs_or_unit_acct_cd_pkg AS
2: /* $Header: IGSOI31B.pls 115.6 2003/02/17 05:43:40 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_unit_acct_cd_all%ROWTYPE;
6: new_references igs_or_unit_acct_cd_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_or_unit_acct_cd_all%ROWTYPE;

2: /* $Header: IGSOI31B.pls 115.6 2003/02/17 05:43:40 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_unit_acct_cd_all%ROWTYPE;
6: new_references igs_or_unit_acct_cd_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_OR_UNIT_ACCT_CD_ALL

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

Line 105: FROM igs_or_unit_acct_cd_all

101: || (reverse chronological order - newest change first)
102: */
103: CURSOR cur_rowid IS
104: SELECT rowid
105: FROM igs_or_unit_acct_cd_all
106: WHERE org_account_cd_id = x_org_account_cd_id
107: FOR UPDATE NOWAIT;
108:
109: lv_rowid cur_rowid%RowType;

Line 209: FROM igs_or_unit_acct_cd_all

205: || (reverse chronological order - newest change first)
206: */
207: CURSOR c IS
208: SELECT rowid
209: FROM igs_or_unit_acct_cd_all
210: WHERE org_account_cd_id = x_org_account_cd_id;
211:
212: x_last_update_date DATE;
213: x_last_updated_by NUMBER;

Line 257: INSERT INTO igs_or_unit_acct_cd_all (

253: x_last_updated_by => x_last_updated_by,
254: x_last_update_login => x_last_update_login
255: );
256:
257: INSERT INTO igs_or_unit_acct_cd_all (
258: org_account_cd_id,
259: org_unit_cd,
260: start_dt,
261: rev_account_cd,

Line 313: FROM igs_or_unit_acct_cd_all

309: SELECT
310: org_unit_cd,
311: start_dt,
312: rev_account_cd
313: FROM igs_or_unit_acct_cd_all
314: WHERE rowid = x_rowid
315: FOR UPDATE NOWAIT;
316:
317: tlinfo c1%ROWTYPE;

Line 405: UPDATE igs_or_unit_acct_cd_all

401: x_last_updated_by => x_last_updated_by,
402: x_last_update_login => x_last_update_login
403: );
404:
405: UPDATE igs_or_unit_acct_cd_all
406: SET
407: org_unit_cd = new_references.org_unit_cd,
408: start_dt = new_references.start_dt,
409: rev_account_cd = new_references.rev_account_cd,

Line 441: FROM igs_or_unit_acct_cd_all

437: || (reverse chronological order - newest change first)
438: */
439: CURSOR c1 IS
440: SELECT rowid
441: FROM igs_or_unit_acct_cd_all
442: WHERE org_account_cd_id = x_org_account_cd_id;
443:
444: BEGIN
445:

Line 494: DELETE FROM igs_or_unit_acct_cd_all

490: p_action => 'DELETE',
491: x_rowid => x_rowid
492: );
493:
494: DELETE FROM igs_or_unit_acct_cd_all
495: WHERE rowid = x_rowid;
496:
497: IF (SQL%NOTFOUND) THEN
498: RAISE NO_DATA_FOUND;