DBA Data[Home] [Help]

APPS.FA_INV_XFR_PUB dependencies on FA_CACHE_PKG

Line 11: g_release number := fa_cache_pkg.fazarel_release;

7: G_API_NAME CONSTANT varchar2(30) := 'Unplanned API';
8: G_API_VERSION CONSTANT number := 1.0;
9:
10: g_log_level_rec fa_api_types.log_level_rec_type;
11: g_release number := fa_cache_pkg.fazarel_release;
12:
13: --*********************** Private procedures ******************************--
14:
15: FUNCTION do_all_books

Line 164: if (NOT fa_cache_pkg.fazcbc(X_book => px_src_asset_hdr_rec.book_type_code, p_log_level_rec => g_log_level_rec)) then

160: -- do not allow transfer between books
161:
162: -- set up sob/mrc info
163: -- call the cache for the primary transaction book
164: if (NOT fa_cache_pkg.fazcbc(X_book => px_src_asset_hdr_rec.book_type_code, p_log_level_rec => g_log_level_rec)) then
165: raise inv_xfr_err;
166: end if;
167:
168: px_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

Line 168: px_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

164: if (NOT fa_cache_pkg.fazcbc(X_book => px_src_asset_hdr_rec.book_type_code, p_log_level_rec => g_log_level_rec)) then
165: raise inv_xfr_err;
166: end if;
167:
168: px_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
169: px_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
170:
171: -- reset the global here in case cache was not initialized at
172: -- time this package was instantiated

Line 169: px_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

165: raise inv_xfr_err;
166: end if;
167:
168: px_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
169: px_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
170:
171: -- reset the global here in case cache was not initialized at
172: -- time this package was instantiated
173: g_release := fa_cache_pkg.fazarel_release;

Line 173: g_release := fa_cache_pkg.fazarel_release;

169: px_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
170:
171: -- reset the global here in case cache was not initialized at
172: -- time this package was instantiated
173: g_release := fa_cache_pkg.fazarel_release;
174:
175: -- Account for transaction submitted from a responsibility
176: -- that is not tied to a SOB_ID by getting the value from
177: -- the book struct

Line 180: if not fa_cache_pkg.fazcsob

176: -- that is not tied to a SOB_ID by getting the value from
177: -- the book struct
178:
179: -- Get the book type code P,R or N
180: if not fa_cache_pkg.fazcsob
181: (X_set_of_books_id => px_src_asset_hdr_rec.set_of_books_id,
182: X_mrc_sob_type_code => l_mrc_sob_type_code, p_log_level_rec => g_log_level_rec) then
183: raise inv_xfr_err;
184: end if;

Line 692: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

688: l_delta_amount number;
689:
690: l_reporting_flag varchar2(1);
691: l_sob_index number;
692: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
693:
694: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
695: l_set_of_books_id number;
696:

Line 758: if not FA_CACHE_PKG.fazcrsob

754: end if;
755:
756:
757: -- call the sob cache to get the table of sob_ids
758: if not FA_CACHE_PKG.fazcrsob
759: (x_book_type_code => p_src_asset_hdr_rec.book_type_code,
760: x_sob_tbl => l_sob_tbl, p_log_level_rec => p_log_level_rec) then
761: raise inv_xfr_err;
762: end if;

Line 774: l_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

770: FOR l_sob_index in 0..l_sob_tbl.count LOOP
771:
772: if (l_sob_index = 0) then
773: l_reporting_flag := 'P';
774: l_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
775: else
776: l_reporting_flag := 'R';
777: l_set_of_books_id := l_sob_tbl(l_sob_index);
778: end if;

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

850:
851: l_adj.transaction_header_id := p_src_trans_rec.transaction_header_id;
852: l_adj.asset_id := p_src_asset_hdr_rec.asset_id;
853: l_adj.book_type_code := p_src_asset_hdr_rec.book_type_code;
854: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
855: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
856: l_adj.current_units := p_src_current_units;
857: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
858: l_adj.selection_thid := 0;

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

851: l_adj.transaction_header_id := p_src_trans_rec.transaction_header_id;
852: l_adj.asset_id := p_src_asset_hdr_rec.asset_id;
853: l_adj.book_type_code := p_src_asset_hdr_rec.book_type_code;
854: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
855: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
856: l_adj.current_units := p_src_current_units;
857: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
858: l_adj.selection_thid := 0;
859: l_adj.selection_retid := 0;

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

905:
906: l_adj.transaction_header_id := p_dest_trans_rec.transaction_header_id;
907: l_adj.asset_id := p_dest_asset_hdr_rec.asset_id;
908: l_adj.book_type_code := p_dest_asset_hdr_rec.book_type_code;
909: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
910: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
911: l_adj.current_units := p_dest_current_units;
912: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
913: l_adj.selection_thid := 0;

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

906: l_adj.transaction_header_id := p_dest_trans_rec.transaction_header_id;
907: l_adj.asset_id := p_dest_asset_hdr_rec.asset_id;
908: l_adj.book_type_code := p_dest_asset_hdr_rec.book_type_code;
909: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
910: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
911: l_adj.current_units := p_dest_current_units;
912: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
913: l_adj.selection_thid := 0;
914: l_adj.selection_retid := 0;

Line 1107: if not fa_cache_pkg.fazcbc(X_book => l_src_asset_hdr_rec.book_type_code,

1103: l_src_asset_hdr_rec.period_of_addition = 'N' and
1104: l_from_asset_type = l_to_asset_type)
1105: or g_release <> 11) then
1106:
1107: if not fa_cache_pkg.fazcbc(X_book => l_src_asset_hdr_rec.book_type_code,
1108: p_log_level_rec => p_log_level_rec) then
1109: raise inv_xfr_err;
1110: end if;
1111:

Line 1112: l_current_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

1108: p_log_level_rec => p_log_level_rec) then
1109: raise inv_xfr_err;
1110: end if;
1111:
1112: l_current_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1113:
1114: delete from fa_adjustments
1115: where asset_id in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
1116: and book_type_code = l_src_asset_hdr_rec.book_type_code

Line 1153: l_current_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

1149: AND ROWNUM < 2;
1150:
1151: if (l_interco_impact) then
1152:
1153: l_current_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1154:
1155: delete from fa_adjustments
1156: where asset_id in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
1157: and book_type_code = l_src_asset_hdr_rec.book_type_code