[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION update_mass_additions (p_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl
, p_log_level_rec IN FA_API_TYPES.log_level_rec_type DEFAULT NULL)
RETURN BOOLEAN IS
TYPE mass_add_tbl IS TABLE OF fa_mass_additions%ROWTYPE
INDEX BY PLS_INTEGER;
l_calling_fn VARCHAR2 (40) := 'update_mass_additions';
l_mass_add_tbl (counter).LAST_UPDATE_DATE := p_mass_add_rec_tbl ( counter).LAST_UPDATE_DATE;
l_mass_add_tbl (counter).LAST_UPDATED_BY := p_mass_add_rec_tbl ( counter).LAST_UPDATED_BY;
l_mass_add_tbl (counter).INVOICE_UPDATED_BY := p_mass_add_rec_tbl ( counter).INVOICE_UPDATED_BY;
l_mass_add_tbl (counter).LAST_UPDATE_LOGIN := p_mass_add_rec_tbl ( counter).LAST_UPDATE_LOGIN;
UPDATE fa_mass_additions
SET ROW = l_mass_add_tbl (i)
WHERE mass_addition_id = l_mass_add_id_tbl (i);
l_mass_add_id_tbl.delete;
SELECT MASS_ADDITION_ID,
ASSET_NUMBER,
TAG_NUMBER,
DESCRIPTION,
ASSET_CATEGORY_ID,
MANUFACTURER_NAME,
SERIAL_NUMBER,
MODEL_NUMBER,
BOOK_TYPE_CODE,
DATE_PLACED_IN_SERVICE,
FIXED_ASSETS_COST,
PAYABLES_UNITS,
FIXED_ASSETS_UNITS,
PAYABLES_CODE_COMBINATION_ID,
EXPENSE_CODE_COMBINATION_ID,
LOCATION_ID,
ASSIGNED_TO,
FEEDER_SYSTEM_NAME,
CREATE_BATCH_DATE,
CREATE_BATCH_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
REVIEWER_COMMENTS,
INVOICE_NUMBER,
INVOICE_LINE_NUMBER, -- bug8984263
INVOICE_DISTRIBUTION_ID, -- bug8984263
VENDOR_NUMBER,
PO_VENDOR_ID,
PO_NUMBER,
POSTING_STATUS,
QUEUE_NAME,
INVOICE_DATE,
INVOICE_CREATED_BY,
INVOICE_UPDATED_BY,
PAYABLES_COST,
INVOICE_ID,
PAYABLES_BATCH_NAME,
DEPRECIATE_FLAG,
PARENT_MASS_ADDITION_ID,
PARENT_ASSET_ID,
SPLIT_MERGED_CODE,
AP_DISTRIBUTION_LINE_NUMBER,
POST_BATCH_ID,
ADD_TO_ASSET_ID,
AMORTIZE_FLAG,
NEW_MASTER_FLAG,
ASSET_KEY_CCID,
ASSET_TYPE,
DEPRN_RESERVE,
YTD_DEPRN,
BEGINNING_NBV,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
SALVAGE_VALUE,
ACCOUNTING_DATE,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE_CATEGORY_CODE,
FULLY_RSVD_REVALS_COUNTER,
MERGE_INVOICE_NUMBER,
MERGE_VENDOR_NUMBER,
PRODUCTION_CAPACITY,
REVAL_AMORTIZATION_BASIS,
REVAL_RESERVE,
UNIT_OF_MEASURE,
UNREVALUED_COST,
YTD_REVAL_DEPRN_EXPENSE,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
ATTRIBUTE21,
ATTRIBUTE22,
ATTRIBUTE23,
ATTRIBUTE24,
ATTRIBUTE25,
ATTRIBUTE26,
ATTRIBUTE27,
ATTRIBUTE28,
ATTRIBUTE29,
ATTRIBUTE30,
MERGED_CODE,
SPLIT_CODE,
MERGE_PARENT_MASS_ADDITIONS_ID,
SPLIT_PARENT_MASS_ADDITIONS_ID,
PROJECT_ASSET_LINE_ID,
PROJECT_ID,
TASK_ID,
SUM_UNITS,
DIST_NAME,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
GLOBAL_ATTRIBUTE_CATEGORY,
CONTEXT,
INVENTORIAL,
SHORT_FISCAL_YEAR_FLAG,
CONVERSION_DATE,
ORIGINAL_DEPRN_START_DATE,
GROUP_ASSET_ID,
CUA_PARENT_HIERARCHY_ID,
UNITS_TO_ADJUST,
BONUS_YTD_DEPRN,
BONUS_DEPRN_RESERVE,
AMORTIZE_NBV_FLAG,
AMORTIZATION_START_DATE,
TRANSACTION_TYPE_CODE,
TRANSACTION_DATE,
WARRANTY_ID,
LEASE_ID,
LESSOR_ID,
PROPERTY_TYPE_CODE,
PROPERTY_1245_1250_CODE,
IN_USE_FLAG,
OWNED_LEASED,
NEW_USED,
ASSET_ID,
MATERIAL_INDICATOR_FLAG,
CAST (MULTISET (SELECT MASSADD_DIST_ID dist_id,
MASS_ADDITION_ID mass_add_id,
UNITS,
DEPRN_EXPENSE_CCID,
LOCATION_ID,
EMPLOYEE_ID
FROM FA_MASSADD_DISTRIBUTIONS mass_dist
WHERE mass_dist.mass_addition_id =
mass_add.mass_addition_id) AS fa_mass_add_dist_tbl)
dists
FROM fa_mass_additions mass_add
WHERE posting_status IN ('NEW', 'ON HOLD')
AND book_type_code = l_book_type_code
AND NVL (merged_code, '1') NOT IN ('MC');
SELECT lookup_code
FROM fa_lookups
WHERE lookup_type = c_lookup_type
AND enabled_flag = 'Y'
AND NVL (end_date_active, SYSDATE) >= SYSDATE
AND ROWNUM = 1;
l_debug_str := 'Calling update_mass_additions';
IF NOT update_mass_additions (l_mass_add_rec_tbl,
p_log_level_rec => g_log_level_rec) THEN
l_debug_str := 'error in update_mass_additions';