APPS.FA_MASS_REVAL_PKG dependencies on FA_PARALLEL_WORKERS

Line 199: FROM fa_parallel_workers pw,

195: rr.reval_attribute_category,
196: DECODE(rr.override_defaults_flag,
197: 'YES', rr.revalue_cip_assets_flag,
198: g_def_revalue_cip_assets_flag)
199: FROM fa_parallel_workers pw,
200: fa_mass_revaluation_rules rr,
201: fa_additions_b ad
202: WHERE pw.request_id = p_parent_request_id
203: AND pw.worker_number = p_request_number

Line 256: FROM fa_parallel_workers pw,

252: rr.reval_attribute_category,
253: DECODE(rr.override_defaults_flag,
254: 'YES', rr.revalue_cip_assets_flag,
255: g_def_revalue_cip_assets_flag)
256: FROM fa_parallel_workers pw,
257: fa_mass_revaluation_rules rr,
258: fa_additions_b ad
259: WHERE pw.request_id = p_parent_request_id
260: AND pw.worker_number = p_request_number

Line 606: fa_debug_pkg.add(l_calling_fn, 'updating fa_parallel_workers for status', '', p_log_level_rec => g_log_level_rec);

602:
603: end loop; -- main bulk fetch loop
604:
605: if (g_log_level_rec.statement_level) then
606: fa_debug_pkg.add(l_calling_fn, 'updating fa_parallel_workers for status', '', p_log_level_rec => g_log_level_rec);
607: end if;
608:
609: -- now flags the rows process status accordingly
610: forall i in 1..l_rowid.count

Line 611: update fa_parallel_workers fpw

607: end if;
608:
609: -- now flags the rows process status accordingly
610: forall i in 1..l_rowid.count
611: update fa_parallel_workers fpw
612: set process_status = l_process_status(i)
613: where rowid = l_rowid(i);
614:
615: if (g_log_level_rec.statement_level) then

Line 616: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workers for status', l_rowid.count, p_log_level_rec => g_log_level_rec);

612: set process_status = l_process_status(i)
613: where rowid = l_rowid(i);
614:
615: if (g_log_level_rec.statement_level) then
616: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workers for status', l_rowid.count, p_log_level_rec => g_log_level_rec);
617: end if;
618:
619: x_return_status := 0;
620:

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

973: -- NOTE: on first cursor, we do not want to insert category
974: -- as it's used to indicate asset/category later on
975:
976: if (g_log_level_rec.statement_level) then
977: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers - asset based', sql%rowcount);
978: end if;
979:
980: -- R12 conditional handling
981: if (G_release = 11) then

Line 988: insert into fa_parallel_workers

984: l_min_period_counter := G_period_rec.period_counter;
985: end if;
986:
987: -- asset based
988: insert into fa_parallel_workers
989: (request_id ,
990: asset_id ,
991: asset_number ,
992: asset_type ,

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

1041: AND th_rev.transaction_type_code = 'REVALUATION'
1042: AND th_rev.mass_transaction_id = p_mass_reval_id);
1043:
1044: if (g_log_level_rec.statement_level) then
1045: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers2', sql%rowcount);
1046: end if;
1047:
1048:
1049: -- category based

Line 1050: insert into fa_parallel_workers

1046: end if;
1047:
1048:
1049: -- category based
1050: insert into fa_parallel_workers
1051: (request_id ,
1052: asset_id ,
1053: asset_number ,
1054: asset_type ,

Line 1108: FROM fa_parallel_workers pw

1104: AND th_rev.book_type_code = G_book_type_code
1105: AND th_rev.transaction_type_code = 'REVALUATION'
1106: AND th_rev.mass_transaction_id = p_mass_reval_id)
1107: AND NOT EXISTS (SELECT 1
1108: FROM fa_parallel_workers pw
1109: WHERE pw.request_id = p_parent_request_id
1110: AND pw.asset_id = ad.asset_id);
1111:
1112: FND_CONCURRENT.AF_COMMIT;