DBA Data[Home] [Help]

APPS.FA_INVOICE_PVT dependencies on FA_CACHE_PKG

Line 4: g_release number := fa_cache_pkg.fazarel_release;

1: PACKAGE BODY FA_INVOICE_PVT as
2: /* $Header: FAVINVB.pls 120.28.12020000.3 2013/03/14 13:36:39 dvjoshi ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: -- used for tracking the total payables cost cleared for all invoices
7: TYPE payables_cost_rec_type IS RECORD
8: (set_of_books_id number,

Line 91: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

87:
88: l_count number;
89:
90: -- mrc checks
91: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
92: l_reporting_flag varchar2(1);
93: l_mrc_rate_found_count number := 0;
94: l_mrc_rate_index number := 0;
95: l_mrc_fin_book_rec number := 0;

Line 139: p_gl_chart_id => fa_cache_pkg.fazcbc_record.accounting_flex_structure,

135: if (px_inv_tbl(i).Payables_Code_Combination_Id is not NULL) then
136: if not FA_ASSET_VAL_PVT.validate_ccid
137: (p_book_type_code => px_asset_hdr_rec.book_type_code,
138: p_ccid => px_inv_tbl(i).Payables_Code_Combination_Id,
139: p_gl_chart_id => fa_cache_pkg.fazcbc_record.accounting_flex_structure,
140: p_ledger_id => fa_cache_pkg.fazcbc_record.set_of_books_id,
141: p_validation_date => NULL,
142: p_calling_fn => l_calling_fn,
143: p_log_level_rec => p_log_level_rec

Line 140: p_ledger_id => fa_cache_pkg.fazcbc_record.set_of_books_id,

136: if not FA_ASSET_VAL_PVT.validate_ccid
137: (p_book_type_code => px_asset_hdr_rec.book_type_code,
138: p_ccid => px_inv_tbl(i).Payables_Code_Combination_Id,
139: p_gl_chart_id => fa_cache_pkg.fazcbc_record.accounting_flex_structure,
140: p_ledger_id => fa_cache_pkg.fazcbc_record.set_of_books_id,
141: p_validation_date => NULL,
142: p_calling_fn => l_calling_fn,
143: p_log_level_rec => p_log_level_rec
144: ) then

Line 153: if (fa_cache_pkg.fazcbc_record.mc_source_flag = 'Y') then

149:
150: -- store the current profile value and then use the definitive value
151: -- for the book in question and check whether this is a reporting book.
152:
153: if (fa_cache_pkg.fazcbc_record.mc_source_flag = 'Y') then
154:
155: -- call the sob cache to get the table of sob_ids
156: if not FA_CACHE_PKG.fazcrsob
157: (x_book_type_code => px_asset_hdr_rec.book_type_code,

Line 156: if not FA_CACHE_PKG.fazcrsob

152:
153: if (fa_cache_pkg.fazcbc_record.mc_source_flag = 'Y') then
154:
155: -- call the sob cache to get the table of sob_ids
156: if not FA_CACHE_PKG.fazcrsob
157: (x_book_type_code => px_asset_hdr_rec.book_type_code,
158: x_sob_tbl => l_sob_tbl, p_log_level_rec => p_log_level_rec) then
159: raise error_found;
160: end if;

Line 783: if (fa_cache_pkg.fazcbc_record.mc_source_flag = 'Y') then

779: l_inv_rec_fa_cost_primary := l_inv_rec.fixed_assets_cost;
780:
781: -- call process_invoice for reporting books by looping through each reporting book
782:
783: if (fa_cache_pkg.fazcbc_record.mc_source_flag = 'Y') then
784:
785: if (px_inv_tbl(l_row_count + 1).inv_rate_tbl.count > 0 and
786: px_inv_tbl(l_row_count + 1).inv_rate_tbl.count <> l_sob_tbl.count) then
787: fa_srvr_msg.add_message(

Line 804: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code,

800:
801: -- BUG# 2632955
802: -- call the cache to set the sob_id used for rounding and other lower
803: -- level code for each book.
804: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code,
805: X_set_of_books_id => l_sob_tbl(l_sob_index),
806: p_log_level_rec => p_log_level_rec) then
807: raise error_found;
808: end if;

Line 1227: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code,

1223:
1224: end loop; -- end mrc sob loop
1225:
1226: -- call the cache to reset the sob_id for the primary book
1227: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code,
1228: X_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
1229: p_log_level_rec => p_log_level_rec) then
1230: raise error_found;
1231: end if;

Line 1265: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code,

1261: end if;
1262:
1263: -- BUG# 2632955
1264: -- call the cache to reset the sob_id for the primary book
1265: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code,
1266: X_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
1267: p_log_level_rec => p_log_level_rec) then
1268: raise error_found;
1269: end if;

Line 1687: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

1683:
1684: i number;
1685: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
1686: sob_processed_tbl num_tbl;
1687: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1688: l_sob_index number;
1689:
1690: l_calling_fn varchar2(35) := 'fa_inv_pvt.post_clearing';
1691:

Line 1699: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

1695:
1696: l_adj.transaction_header_id := p_trans_rec.transaction_header_id;
1697: l_adj.asset_id := p_asset_hdr_rec.asset_id;
1698: l_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1699: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1700: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1701: l_adj.current_units := p_asset_desc_rec.current_units ;
1702: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1703: l_adj.selection_thid := 0;

Line 1700: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

1696: l_adj.transaction_header_id := p_trans_rec.transaction_header_id;
1697: l_adj.asset_id := p_asset_hdr_rec.asset_id;
1698: l_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1699: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1700: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1701: l_adj.current_units := p_asset_desc_rec.current_units ;
1702: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1703: l_adj.selection_thid := 0;
1704: l_adj.selection_retid := 0;

Line 1772: if not FA_CACHE_PKG.fazcrsob

1768: l_adj.transaction_header_id := p_trans_rec.transaction_header_id;
1769:
1770:
1771: -- call the sob cache to get the table of sob_ids
1772: if not FA_CACHE_PKG.fazcrsob
1773: (x_book_type_code => p_asset_hdr_rec.book_type_code,
1774: x_sob_tbl => l_sob_tbl, p_log_level_rec => p_log_level_rec) then
1775: raise error_found;
1776: end if;