APPS.IGI_IAC_PROJ_DETAILS_PKG dependencies on IGI_IAC_PROJ_DETAILS

Line 1: PACKAGE BODY igi_iac_proj_details_pkg AS

1: PACKAGE BODY igi_iac_proj_details_pkg AS
2: /* $Header: igiiapdb.pls 120.5.12000000.1 2007/08/01 16:15:47 npandya ship $ */
3:
4: --===========================FND_LOG.START=====================================
5:

Line 12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiapdb.igi_iac_proj_details_pkg.';

8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiapdb.igi_iac_proj_details_pkg.';
13:
14: --===========================FND_LOG.END=======================================
15:
16: l_rowid VARCHAR2(25);

Line 17: old_references igi_iac_proj_details%ROWTYPE;

13:
14: --===========================FND_LOG.END=======================================
15:
16: l_rowid VARCHAR2(25);
17: old_references igi_iac_proj_details%ROWTYPE;
18: new_references igi_iac_proj_details%ROWTYPE;
19:
20: PROCEDURE set_column_values (
21: p_action IN VARCHAR2,

Line 18: new_references igi_iac_proj_details%ROWTYPE;

14: --===========================FND_LOG.END=======================================
15:
16: l_rowid VARCHAR2(25);
17: old_references igi_iac_proj_details%ROWTYPE;
18: new_references igi_iac_proj_details%ROWTYPE;
19:
20: PROCEDURE set_column_values (
21: p_action IN VARCHAR2,
22: x_rowid IN VARCHAR2 ,

Line 54: FROM igi_iac_proj_details

50: */
51:
52: CURSOR cur_old_ref_values IS
53: SELECT *
54: FROM igi_iac_proj_details
55: WHERE rowid = x_rowid;
56: l_path varchar2(150) := g_path||'set_column_values';
57: BEGIN
58:

Line 147: FROM igi_iac_proj_details

143: || (reverse chronological order - newest change first)
144: */
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM igi_iac_proj_details
148: WHERE projection_id = x_projection_id
149: AND asset_id = x_asset_id
150: AND period_counter = x_period_counter
151: FOR UPDATE NOWAIT;

Line 184: FROM igi_iac_proj_details

180: || (reverse chronological order - newest change first)
181: */
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM igi_iac_proj_details
185: WHERE ((projection_id = x_projection_id));
186:
187: lv_rowid cur_rowid%RowType;
188: l_path varchar2(150) := g_path||'get_fk_igi_iac_projections';

Line 324: FROM igi_iac_proj_details

320: || (reverse chronological order - newest change first)
321: */
322: CURSOR c IS
323: SELECT rowid
324: FROM igi_iac_proj_details
325: WHERE projection_id = x_projection_id
326: AND asset_id = x_asset_id
327: AND period_counter = x_period_counter;
328:

Line 377: INSERT INTO igi_iac_proj_details (

373: x_last_updated_by => x_last_updated_by,
374: x_last_update_login => x_last_update_login
375: );
376:
377: INSERT INTO igi_iac_proj_details (
378: projection_id,
379: period_counter,
380: fiscal_year,
381: company,

Line 465: FROM igi_iac_proj_details

461: deprn_ytd,
462: deprn_reserve,
463: asset_exception,
464: revaluation_flag
465: FROM igi_iac_proj_details
466: WHERE rowid = x_rowid
467: FOR UPDATE NOWAIT;
468:
469: tlinfo c1%ROWTYPE;

Line 582: UPDATE igi_iac_proj_details

578: x_last_updated_by => x_last_updated_by,
579: x_last_update_login => x_last_update_login
580: );
581:
582: UPDATE igi_iac_proj_details
583: SET
584: fiscal_year = new_references.fiscal_year,
585: company = new_references.company,
586: cost_center = new_references.cost_center,

Line 634: FROM igi_iac_proj_details

630: || (reverse chronological order - newest change first)
631: */
632: CURSOR c1 IS
633: SELECT rowid
634: FROM igi_iac_proj_details
635: WHERE projection_id = x_projection_id
636: AND asset_id = x_asset_id
637: AND period_counter = x_period_counter;
638: BEGIN

Line 706: DELETE FROM igi_iac_proj_details

702: p_action => 'DELETE',
703: x_rowid => x_rowid
704: );
705:
706: DELETE FROM igi_iac_proj_details
707: WHERE rowid = x_rowid;
708:
709: IF (SQL%NOTFOUND) THEN
710: RAISE NO_DATA_FOUND;

Line 716: END igi_iac_proj_details_pkg;

712:
713: END delete_row;
714:
715:
716: END igi_iac_proj_details_pkg;