APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_MASS_UPDATE_BATCH_DETAILS

Line 732: from fa_mass_update_batch_details

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

Line 817: from fa_mass_update_batch_details

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

Line 824: from fa_mass_update_batch_details

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

Line 877: update fa_mass_update_batch_details

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

Line 950: update fa_mass_update_batch_details

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

Line 969: update fa_mass_update_batch_details

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

Line 1009: FROM fa_mass_update_batch_details

1005: attribute_new_id,
1006: derived_from_entity_id,
1007: derived_from_entity,
1008: status_code
1009: FROM fa_mass_update_batch_details
1010: WHERE batch_id = p_batch_id
1011: and asset_id = p_asset_id
1012: and book_type_code = p_book
1013: AND apply_flag = 'Y'

Line 1205: update fa_mass_update_batch_details

1201: end if;
1202: end if;
1203:
1204: -- Now restore to Pending/Rejected
1205: update fa_mass_update_batch_details
1206: set status_code = l_get_lines_rec.status_code
1207: where batch_id = p_batch_id
1208: and asset_id = p_asset_id
1209: and book_type_code = p_book;