APPS.PSA_FA_MASS_ADDITIONS dependencies on FA_MASS_ADDITIONS

Line 1: PACKAGE BODY PSA_FA_MASS_ADDITIONS AS

1: PACKAGE BODY PSA_FA_MASS_ADDITIONS AS
2: /* $Header: PSAFAUCB.pls 120.4 2006/03/16 15:32:01 tpradhan noship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAFAUCB.PSA_FA_MASS_ADDITIONS.';

7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAFAUCB.PSA_FA_MASS_ADDITIONS.';
12: --===========================FND_LOG.END=======================================
13:
14: PROCEDURE update_asset_type
15: (err_buf OUT NOCOPY VARCHAR2,

Line 44: FROM fa_mass_additions fma, gl_code_combinations cc

40: p_where_clause := fa_rx_flex_pkg.flex_sql
41: (101, 'GL#', p_chart_of_accounts, 'CC', 'WHERE', 'ALL','BETWEEN', p_capital_acct_from, p_capital_acct_to);
42:
43: p_mass_add_query := 'SELECT mass_addition_id
44: FROM fa_mass_additions fma, gl_code_combinations cc
45: WHERE fma.payables_code_combination_id = cc.code_combination_id
46: AND fma.asset_type = '''||'EXPENSED'||''''||
47: ' AND fma.posting_status = '''||'NEW' ||''''||
48: ' AND book_type_code = :p_asset_book';

Line 67: UPDATE fa_mass_additions

63: LOOP
64: FETCH mass_add_cur INTO l_mass_addition_id;
65: EXIT WHEN mass_add_cur%NOTFOUND;
66:
67: UPDATE fa_mass_additions
68: SET asset_type = 'CAPITALIZED',
69: depreciate_flag = 'YES'
70: WHERE mass_addition_id = l_mass_addition_id;
71:

Line 102: UPDATE fa_mass_additions

98: LOOP
99: FETCH mass_add_cur INTO l_mass_addition_id;
100: EXIT WHEN mass_add_cur%NOTFOUND;
101:
102: UPDATE fa_mass_additions
103: SET asset_type = 'CIP'
104: WHERE mass_addition_id = l_mass_addition_id;
105:
106: PRINT_MASS_ADDITION_DETAILS (l_mass_addition_id);

Line 177: FROM fa_mass_additions

173: PROCEDURE print_mass_addition_details (p_mass_addition_id IN NUMBER) IS
174:
175: CURSOR c_invoice_details (c_mass_addition_id NUMBER) IS
176: SELECT mass_addition_id, invoice_number, payables_cost, description
177: FROM fa_mass_additions
178: WHERE mass_addition_id = c_mass_addition_id;
179:
180: l_mass_addition_details c_invoice_details%rowtype;
181: BEGIN

Line 197: END PSA_FA_MASS_ADDITIONS;

193:
194: END print_mass_addition_details;
195:
196:
197: END PSA_FA_MASS_ADDITIONS;