APPS.FA_MASS_REVAL_PKG dependencies on FA_PARALLEL_WORKERS

Line 186: FROM fa_parallel_workers pw,

182: rr.reval_attribute_category,
183: DECODE(rr.override_defaults_flag,
184: 'YES', rr.revalue_cip_assets_flag,
185: g_def_revalue_cip_assets_flag)
186: FROM fa_parallel_workers pw,
187: fa_mass_revaluation_rules rr,
188: fa_additions_b ad
189: WHERE pw.request_id = p_parent_request_id
190: AND pw.worker_number = p_request_number

Line 238: FROM fa_parallel_workers pw,

234: rr.reval_attribute_category,
235: DECODE(rr.override_defaults_flag,
236: 'YES', rr.revalue_cip_assets_flag,
237: g_def_revalue_cip_assets_flag)
238: FROM fa_parallel_workers pw,
239: fa_mass_revaluation_rules rr,
240: fa_additions_b ad
241: WHERE pw.request_id = p_parent_request_id
242: AND pw.worker_number = p_request_number

Line 543: update fa_parallel_workers fpw

539: end loop; -- main bulk fetch loop
540:
541: -- now flags the rows process status accordingly
542: forall i in 1..l_rowid.count
543: update fa_parallel_workers fpw
544: set process_status = l_process_status(i)
545: where rowid = l_rowid(i);
546:
547: if (g_log_level_rec.statement_level) then

Line 548: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workers for status', l_rowid.count,

544: set process_status = l_process_status(i)
545: where rowid = l_rowid(i);
546:
547: if (g_log_level_rec.statement_level) then
548: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workers for status', l_rowid.count,
549: p_log_level_rec => g_log_level_rec);
550: end if;
551:
552:

Line 900: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers - asset based', sql%rowcount,

896: -- NOTE: on first cursor, we do not want to insert category
897: -- as it's used to indicate asset/category later on
898:
899: if (g_log_level_rec.statement_level) then
900: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers - asset based', sql%rowcount,
901: p_log_level_rec => g_log_level_rec);
902: end if;
903:
904: -- asset based

Line 905: insert into fa_parallel_workers

901: p_log_level_rec => g_log_level_rec);
902: end if;
903:
904: -- asset based
905: insert into fa_parallel_workers
906: (request_id ,
907: asset_id ,
908: asset_number ,
909: asset_type ,

Line 958: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers2', sql%rowcount,

954: AND th_rev.mass_transaction_id = p_mass_reval_id);
955:
956:
957: if (g_log_level_rec.statement_level) then
958: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers2', sql%rowcount,
959: p_log_level_rec => g_log_level_rec);
960: end if;
961:
962:

Line 964: insert into fa_parallel_workers

960: end if;
961:
962:
963: -- category based
964: insert into fa_parallel_workers
965: (request_id ,
966: asset_id ,
967: asset_number ,
968: asset_type ,

Line 1017: FROM fa_parallel_workers pw

1013: AND th_rev.book_type_code = G_book_type_code
1014: AND th_rev.transaction_type_code = 'REVALUATION'
1015: AND th_rev.mass_transaction_id = p_mass_reval_id)
1016: AND NOT EXISTS (SELECT 1
1017: FROM fa_parallel_workers pw
1018: WHERE pw.request_id = p_parent_request_id
1019: AND pw.asset_id = ad.asset_id);
1020:
1021: