APPS.IGI_IAC_PROJECTIONS_PKG dependencies on IGI_IAC_PROJECTIONS

Line 1: PACKAGE BODY igi_iac_projections_pkg AS

1: PACKAGE BODY igi_iac_projections_pkg AS
2: /* $Header: igiiapjb.pls 120.4.12000000.1 2007/08/01 16:15:56 npandya ship $ */
3:
4: --===========================FND_LOG.START=====================================
5:

Line 12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiapjb.igi_iac_projections_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.igiiapjb.igi_iac_projections_pkg.';
13:
14: --===========================FND_LOG.END=======================================
15:
16: l_rowid VARCHAR2(25);

Line 17: old_references igi_iac_projections%ROWTYPE;

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

Line 18: new_references igi_iac_projections%ROWTYPE;

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

Line 47: FROM igi_iac_projections

43: */
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM igi_iac_projections
48: WHERE rowid = x_rowid;
49: l_path varchar2(150) := g_path||'set_column_values';
50: BEGIN
51:

Line 102: igi_iac_proj_details_pkg.get_fk_igi_iac_projections (

98: || (reverse chronological order - newest change first)
99: */
100: BEGIN
101:
102: igi_iac_proj_details_pkg.get_fk_igi_iac_projections (
103: old_references.projection_id
104: );
105:
106: END check_child_existance;

Line 123: FROM igi_iac_projections

119: || (reverse chronological order - newest change first)
120: */
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM igi_iac_projections
124: WHERE projection_id = x_projection_id
125: FOR UPDATE NOWAIT;
126:
127: lv_rowid cur_rowid%RowType;

Line 239: FROM igi_iac_projections

235: || (reverse chronological order - newest change first)
236: */
237: CURSOR c IS
238: SELECT rowid
239: FROM igi_iac_projections
240: WHERE projection_id = x_projection_id;
241:
242: x_last_update_date DATE;
243: x_last_updated_by NUMBER;

Line 267: SELECT igi_iac_projections_s.NEXTVAL

263: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);
264: app_exception.raise_exception;
265: END IF;
266:
267: SELECT igi_iac_projections_s.NEXTVAL
268: INTO x_projection_id
269: FROM dual;
270:
271: before_dml(

Line 287: INSERT INTO igi_iac_projections (

283: x_last_updated_by => x_last_updated_by,
284: x_last_update_login => x_last_update_login
285: );
286:
287: INSERT INTO igi_iac_projections (
288: projection_id,
289: book_type_code,
290: start_period_counter,
291: end_period,

Line 349: FROM igi_iac_projections

345: start_period_counter,
346: end_period,
347: category_id,
348: revaluation_period
349: FROM igi_iac_projections
350: WHERE rowid = x_rowid
351: FOR UPDATE NOWAIT;
352:
353: tlinfo c1%ROWTYPE;

Line 447: UPDATE igi_iac_projections

443: x_last_updated_by => x_last_updated_by,
444: x_last_update_login => x_last_update_login
445: );
446:
447: UPDATE igi_iac_projections
448: SET
449: book_type_code = new_references.book_type_code,
450: start_period_counter = new_references.start_period_counter,
451: end_period = new_references.end_period,

Line 487: FROM igi_iac_projections

483: || (reverse chronological order - newest change first)
484: */
485: CURSOR c1 IS
486: SELECT rowid
487: FROM igi_iac_projections
488: WHERE projection_id = x_projection_id;
489:
490: BEGIN
491:

Line 544: DELETE FROM igi_iac_projections

540: p_action => 'DELETE',
541: x_rowid => x_rowid
542: );
543:
544: DELETE FROM igi_iac_projections
545: WHERE rowid = x_rowid;
546:
547: IF (SQL%NOTFOUND) THEN
548: RAISE NO_DATA_FOUND;

Line 554: END igi_iac_projections_pkg;

550:
551: END delete_row;
552:
553:
554: END igi_iac_projections_pkg;