DBA Data[Home] [Help]

APPS.FA_MASSADD_PKG dependencies on FA_CACHE_PKG

Line 646: if NOT fa_cache_pkg.fazcbc(X_book => p_book_type_code) then

642: x_success_count := 0;
643: x_failure_count := 0;
644:
645: -- call the book_controls cache
646: if NOT fa_cache_pkg.fazcbc(X_book => p_book_type_code) then
647: raise error_found;
648: end if;
649:
650: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);

Line 650: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);

646: if NOT fa_cache_pkg.fazcbc(X_book => p_book_type_code) then
647: raise error_found;
648: end if;
649:
650: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
651:
652: -- values that remain constant for all lines
653: l_asset_hdr_rec.book_type_code := p_book_type_code;
654: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

Line 654: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

650: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
651:
652: -- values that remain constant for all lines
653: l_asset_hdr_rec.book_type_code := p_book_type_code;
654: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
655: l_inv_trans_rec.transaction_type := 'MASS ADDITION';
656: l_trans_rec.calling_interface := 'FAMAPT';
657: l_dist_trans_rec.calling_interface := 'FAMAPT';
658: l_trans_rec.mass_reference_id := p_parent_request_id;

Line 1073: if (nvl(fa_cache_pkg.fazcbc_record.mc_source_flag, 'N') = 'Y') then

1069: -- place the main invoice in the array
1070: l_inv_tbl(l_inv_indicator) := l_inv_rec;
1071:
1072: -- load the rates for the main/parent invoice
1073: if (nvl(fa_cache_pkg.fazcbc_record.mc_source_flag, 'N') = 'Y') then
1074: open c_mass_rates (p_massadd_id => l_mass_addition_id_tbl(i));
1075: fetch c_mass_rates bulk collect
1076: into l_set_of_books_id_tbl,
1077: l_exchange_rate_tbl,

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

1182: -- append to the existing row(s) in the table of invoices (always + 1)
1183: l_inv_tbl(l_inv_indicator + 1) := l_inv_rec;
1184:
1185: -- process mrc rates for the children
1186: if (fa_cache_pkg.fazcbc_record.mc_source_flag = 'Y') then
1187: open c_mass_rates(p_massadd_id => l_inv_rec.asset_invoice_id);
1188: fetch c_mass_rates bulk collect
1189: into l_set_of_books_id_tbl ,
1190: l_exchange_rate_tbl,

Line 2352: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code) then

2348:
2349: x_return_status := 0;
2350:
2351: -- get corp book information
2352: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code) then
2353: raise massadd_err;
2354: end if;
2355:
2356: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);

Line 2356: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);

2352: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code) then
2353: raise massadd_err;
2354: end if;
2355:
2356: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
2357:
2358: -- get corp period info
2359: if not FA_UTIL_PVT.get_period_rec
2360: (p_book => p_book_type_code,

Line 2361: p_period_counter => fa_cache_pkg.fazcbc_record.last_period_counter + 1,

2357:
2358: -- get corp period info
2359: if not FA_UTIL_PVT.get_period_rec
2360: (p_book => p_book_type_code,
2361: p_period_counter => fa_cache_pkg.fazcbc_record.last_period_counter + 1,
2362: x_period_rec => l_period_rec
2363: ) then
2364: raise massadd_err;
2365: end if;

Line 2370: p_period_counter => fa_cache_pkg.fazcbc_record.last_period_counter + 1,

2366:
2367: -- get corp period info
2368: if not FA_UTIL_PVT.get_period_rec
2369: (p_book => p_book_type_code,
2370: p_period_counter => fa_cache_pkg.fazcbc_record.last_period_counter + 1,
2371: x_period_rec => l_period_rec
2372: ) then
2373: raise massadd_err;
2374: end if;

Line 2475: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then

2471:
2472: if (p_mode = 'NORMAL') then
2473:
2474: -- update group asset information if we're not copying from corp
2475: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then
2476:
2477: update fa_mass_additions mad
2478: set group_asset_id =
2479: (select cbd.group_asset_id

Line 2514: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then

2510:
2511: else
2512:
2513: -- update group asset information if we're not copying from corp
2514: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then
2515:
2516: update fa_mass_additions mad
2517: set group_asset_id =
2518: (select cbd.group_asset_id