APPS.IGI_IAC_REVAL_ASSET_RULES_PKG dependencies on IGI_IAC_REVAL_ASSET_RULES

Line 1: PACKAGE BODY igi_iac_reval_asset_rules_pkg AS

1: PACKAGE BODY igi_iac_reval_asset_rules_pkg AS
2: -- $Header: igiiarrb.pls 120.5.12000000.1 2007/08/01 16:17:51 npandya ship $
3:
4: --===========================FND_LOG.START=====================================
5:

Line 12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiarrb.igi_iac_reval_asset_rules_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.igiiarrb.igi_iac_reval_asset_rules_pkg.';
13:
14: --===========================FND_LOG.END=======================================
15:
16: PROCEDURE insert_row (

Line 34: FROM igi_iac_reval_asset_rules

30: ) AS
31:
32: CURSOR c IS
33: SELECT rowid
34: FROM igi_iac_reval_asset_rules
35: WHERE revaluation_id = X_revaluation_id
36: AND asset_id = X_asset_id
37: AND book_type_code = X_book_type_code
38: AND category_id = X_category_id;

Line 72: INSERT INTO igi_iac_reval_asset_rules

68: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);
69: app_exception.raise_exception;
70: END IF;
71:
72: INSERT INTO igi_iac_reval_asset_rules
73: (revaluation_id,
74: book_type_code,
75: category_id,
76: asset_id,

Line 124: DELETE FROM igi_iac_reval_asset_rules

120: x_revaluation_id IN NUMBER
121: ) AS
122: BEGIN
123:
124: DELETE FROM igi_iac_reval_asset_rules
125: WHERE asset_id = x_asset_id
126: AND book_type_code = x_book_type_code
127: AND revaluation_id = x_revaluation_id;
128:

Line 135: END igi_iac_reval_asset_rules_pkg;

131: END IF;
132:
133: END delete_row;
134:
135: END igi_iac_reval_asset_rules_pkg;