APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_MASS_UPDATE_BATCH_DETAILS

Line 729: from fa_mass_update_batch_details

725:
726: Begin
727: select 'Y'
728: into l_dummy
729: from fa_mass_update_batch_details
730: where batch_id = l_batch_rec.batch_id
731: and status_code in ('P','R')
732: and rownum = 1;
733: Exception

Line 814: from fa_mass_update_batch_details

810: -- -----------------------
811:
812: CURSOR l_get_books is
813: SELECT distinct book_type_code
814: from fa_mass_update_batch_details
815: WHERE batch_id = p_Batch_ID
816: and status_code in ('P','R')
817: and apply_flag = 'Y';
818:

Line 821: from fa_mass_update_batch_details

817: and apply_flag = 'Y';
818:
819: CURSOR l_get_assets_csr is
820: SELECT distinct asset_id
821: from fa_mass_update_batch_details
822: WHERE batch_id = p_Batch_ID
823: and book_type_code = l_book
824: and status_code in ('P','R')
825: and apply_flag = 'Y';

Line 874: update fa_mass_update_batch_details

870: l_err_code := '0';
871:
872: /* moved this update here for bugfix 1389275 */
873: -- Changes the status of the Asset detail records to In Process
874: update fa_mass_update_batch_details
875: set status_code = 'IP'
876: where batch_id = p_batch_id
877: and asset_id = l_asset_id
878: and book_type_code = l_book;

Line 946: update fa_mass_update_batch_details

942: FOR l_asset_rec IN l_get_assets_csr LOOP
943: l_asset_id := l_asset_rec.asset_id;
944:
945: if l_error_tab.exists(l_asset_id) then
946: update fa_mass_update_batch_details
947: set rejection_reason = l_error_tab(l_asset_id).rejection_reason,
948: concurrent_request_id = px_trans_rec.mass_reference_id,
949: status_code = 'R',
950: last_updated_by = px_trans_rec.who_info.last_updated_by,

Line 965: update fa_mass_update_batch_details

961: END LOOP;
962: END LOOP;
963:
964: else -- No Asset record failed. Therefore update the status to Accepted for all records
965: update fa_mass_update_batch_details
966: set rejection_reason = null,
967: concurrent_request_id = px_trans_rec.mass_reference_id,
968: status_code = 'A',
969: last_updated_by = px_trans_rec.who_info.last_updated_by,

Line 1005: FROM fa_mass_update_batch_details

1001: attribute_new_id,
1002: derived_from_entity_id,
1003: derived_from_entity,
1004: status_code
1005: FROM fa_mass_update_batch_details
1006: WHERE batch_id = p_batch_id
1007: and asset_id = p_asset_id
1008: and book_type_code = p_book
1009: AND apply_flag = 'Y'

Line 1200: update fa_mass_update_batch_details

1196: end if;
1197: end if;
1198:
1199: -- Now restore to Pending/Rejected
1200: update fa_mass_update_batch_details
1201: set status_code = l_get_lines_rec.status_code
1202: where batch_id = p_batch_id
1203: and asset_id = p_asset_id
1204: and book_type_code = p_book;