[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT lookup_code
FROM fa_lookups
WHERE lookup_type = c_lookup_type
AND NVL (END_DATE_ACTIVE, SYSDATE) >= SYSDATE
AND enabled_flag = 'Y';
SELECT ad.asset_id,
ad.asset_category_id,
ad.parent_asset_id,
ad.asset_key_ccid
FROM fa_additions ad,
fa_categories cat,
fa_categories cat1,
FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
fnd_flex_value_sets val_set,
fa_asset_keywords ak
WHERE ad.ASSET_CATEGORY_ID = cat.CATEGORY_ID
AND cat.SEGMENT2 = l_cat_value
AND cat1.category_id = l_category_id
AND cat1.segment1 = cat.segment1
AND val_norm.flex_value_set_id = val_set.flex_value_set_id
AND val_set.flex_value_set_name = l_value_set_name
AND l_here_key_seg_val BETWEEN val_norm.child_flex_value_low
AND val_norm.child_flex_value_high
AND ad.asset_key_ccid = ak.code_combination_id
AND ak.segment1 = val_norm.parent_flex_value
AND NVL (ak.segment2, '-1') =
NVL (l_group_akey_segment2, '-1')
AND NVL (ak.segment3, '-1') =
NVL (l_group_akey_segment3, '-1')
AND NVL (ak.segment4, '-1') =
NVL (l_group_akey_segment4, '-1')
AND NVL (ak.segment5, '-1') =
NVL (l_group_akey_segment5, '-1')
AND NVL (ak.segment6, '-1') =
NVL (l_group_akey_segment6, '-1')
AND NVL (ak.segment7, '-1') =
NVL (l_group_akey_segment7, '-1')
AND NVL (ak.segment8, '-1') =
NVL (l_group_akey_segment8, '-1')
AND NVL (ak.segment9, '-1') =
NVL (l_group_akey_segment9, '-1')
AND NVL (ak.segment10, '-1') =
NVL (l_group_akey_segment10, '-1')
AND EXISTS
(SELECT 'x'
FROM fa_category_books cb
WHERE cb.category_id = cat.category_id
AND cb.book_type_code = l_book)
AND EXISTS
(SELECT 'x'
FROM fa_category_books cb1
WHERE cb1.category_id = cat1.category_id
AND cb1.book_type_code = l_book);
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,
INVOICE_DISTRIBUTION_ID,
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
INTO l_mass_add_rec.MASS_ADDITION_ID,
l_mass_add_rec.ASSET_NUMBER,
l_mass_add_rec.TAG_NUMBER,
l_mass_add_rec.DESCRIPTION,
l_mass_add_rec.ASSET_CATEGORY_ID,
l_mass_add_rec.MANUFACTURER_NAME,
l_mass_add_rec.SERIAL_NUMBER,
l_mass_add_rec.MODEL_NUMBER,
l_mass_add_rec.BOOK_TYPE_CODE,
l_mass_add_rec.DATE_PLACED_IN_SERVICE,
l_mass_add_rec.FIXED_ASSETS_COST,
l_mass_add_rec.PAYABLES_UNITS,
l_mass_add_rec.FIXED_ASSETS_UNITS,
l_mass_add_rec.PAYABLES_CODE_COMBINATION_ID,
l_mass_add_rec.EXPENSE_CODE_COMBINATION_ID,
l_mass_add_rec.LOCATION_ID,
l_mass_add_rec.ASSIGNED_TO,
l_mass_add_rec.FEEDER_SYSTEM_NAME,
l_mass_add_rec.CREATE_BATCH_DATE,
l_mass_add_rec.CREATE_BATCH_ID,
l_mass_add_rec.LAST_UPDATE_DATE,
l_mass_add_rec.LAST_UPDATED_BY,
l_mass_add_rec.REVIEWER_COMMENTS,
l_mass_add_rec.INVOICE_NUMBER,
l_mass_add_rec.INVOICE_LINE_NUMBER,
l_mass_add_rec.INVOICE_DISTRIBUTION_ID,
l_mass_add_rec.VENDOR_NUMBER,
l_mass_add_rec.PO_VENDOR_ID,
l_mass_add_rec.PO_NUMBER,
l_mass_add_rec.POSTING_STATUS,
l_mass_add_rec.QUEUE_NAME,
l_mass_add_rec.INVOICE_DATE,
l_mass_add_rec.INVOICE_CREATED_BY,
l_mass_add_rec.INVOICE_UPDATED_BY,
l_mass_add_rec.PAYABLES_COST,
l_mass_add_rec.INVOICE_ID,
l_mass_add_rec.PAYABLES_BATCH_NAME,
l_mass_add_rec.DEPRECIATE_FLAG,
l_mass_add_rec.PARENT_MASS_ADDITION_ID,
l_mass_add_rec.PARENT_ASSET_ID,
l_mass_add_rec.SPLIT_MERGED_CODE,
l_mass_add_rec.AP_DISTRIBUTION_LINE_NUMBER,
l_mass_add_rec.POST_BATCH_ID,
l_mass_add_rec.ADD_TO_ASSET_ID,
l_mass_add_rec.AMORTIZE_FLAG,
l_mass_add_rec.NEW_MASTER_FLAG,
l_mass_add_rec.ASSET_KEY_CCID,
l_mass_add_rec.ASSET_TYPE,
l_mass_add_rec.DEPRN_RESERVE,
l_mass_add_rec.YTD_DEPRN,
l_mass_add_rec.BEGINNING_NBV,
l_mass_add_rec.CREATED_BY,
l_mass_add_rec.CREATION_DATE,
l_mass_add_rec.LAST_UPDATE_LOGIN,
l_mass_add_rec.SALVAGE_VALUE,
l_mass_add_rec.ACCOUNTING_DATE,
l_mass_add_rec.ATTRIBUTE1,
l_mass_add_rec.ATTRIBUTE2,
l_mass_add_rec.ATTRIBUTE3,
l_mass_add_rec.ATTRIBUTE4,
l_mass_add_rec.ATTRIBUTE5,
l_mass_add_rec.ATTRIBUTE6,
l_mass_add_rec.ATTRIBUTE7,
l_mass_add_rec.ATTRIBUTE8,
l_mass_add_rec.ATTRIBUTE9,
l_mass_add_rec.ATTRIBUTE10,
l_mass_add_rec.ATTRIBUTE11,
l_mass_add_rec.ATTRIBUTE12,
l_mass_add_rec.ATTRIBUTE13,
l_mass_add_rec.ATTRIBUTE14,
l_mass_add_rec.ATTRIBUTE15,
l_mass_add_rec.ATTRIBUTE_CATEGORY_CODE,
l_mass_add_rec.FULLY_RSVD_REVALS_COUNTER,
l_mass_add_rec.MERGE_INVOICE_NUMBER,
l_mass_add_rec.MERGE_VENDOR_NUMBER,
l_mass_add_rec.PRODUCTION_CAPACITY,
l_mass_add_rec.REVAL_AMORTIZATION_BASIS,
l_mass_add_rec.REVAL_RESERVE,
l_mass_add_rec.UNIT_OF_MEASURE,
l_mass_add_rec.UNREVALUED_COST,
l_mass_add_rec.YTD_REVAL_DEPRN_EXPENSE,
l_mass_add_rec.ATTRIBUTE16,
l_mass_add_rec.ATTRIBUTE17,
l_mass_add_rec.ATTRIBUTE18,
l_mass_add_rec.ATTRIBUTE19,
l_mass_add_rec.ATTRIBUTE20,
l_mass_add_rec.ATTRIBUTE21,
l_mass_add_rec.ATTRIBUTE22,
l_mass_add_rec.ATTRIBUTE23,
l_mass_add_rec.ATTRIBUTE24,
l_mass_add_rec.ATTRIBUTE25,
l_mass_add_rec.ATTRIBUTE26,
l_mass_add_rec.ATTRIBUTE27,
l_mass_add_rec.ATTRIBUTE28,
l_mass_add_rec.ATTRIBUTE29,
l_mass_add_rec.ATTRIBUTE30,
l_mass_add_rec.MERGED_CODE,
l_mass_add_rec.SPLIT_CODE,
l_mass_add_rec.MERGE_PARENT_MASS_ADD_ID,
l_mass_add_rec.SPLIT_PARENT_MASS_ADD_ID,
l_mass_add_rec.PROJECT_ASSET_LINE_ID,
l_mass_add_rec.PROJECT_ID,
l_mass_add_rec.TASK_ID,
l_mass_add_rec.SUM_UNITS,
l_mass_add_rec.DIST_NAME,
l_mass_add_rec.GLOBAL_ATTRIBUTE1,
l_mass_add_rec.GLOBAL_ATTRIBUTE2,
l_mass_add_rec.GLOBAL_ATTRIBUTE3,
l_mass_add_rec.GLOBAL_ATTRIBUTE4,
l_mass_add_rec.GLOBAL_ATTRIBUTE5,
l_mass_add_rec.GLOBAL_ATTRIBUTE6,
l_mass_add_rec.GLOBAL_ATTRIBUTE7,
l_mass_add_rec.GLOBAL_ATTRIBUTE8,
l_mass_add_rec.GLOBAL_ATTRIBUTE9,
l_mass_add_rec.GLOBAL_ATTRIBUTE10,
l_mass_add_rec.GLOBAL_ATTRIBUTE11,
l_mass_add_rec.GLOBAL_ATTRIBUTE12,
l_mass_add_rec.GLOBAL_ATTRIBUTE13,
l_mass_add_rec.GLOBAL_ATTRIBUTE14,
l_mass_add_rec.GLOBAL_ATTRIBUTE15,
l_mass_add_rec.GLOBAL_ATTRIBUTE16,
l_mass_add_rec.GLOBAL_ATTRIBUTE17,
l_mass_add_rec.GLOBAL_ATTRIBUTE18,
l_mass_add_rec.GLOBAL_ATTRIBUTE19,
l_mass_add_rec.GLOBAL_ATTRIBUTE20,
l_mass_add_rec.GLOBAL_ATTRIBUTE_CATEGORY,
l_mass_add_rec.CONTEXT,
l_mass_add_rec.INVENTORIAL,
l_mass_add_rec.SHORT_FISCAL_YEAR_FLAG,
l_mass_add_rec.CONVERSION_DATE,
l_mass_add_rec.ORIGINAL_DEPRN_START_DATE,
l_mass_add_rec.GROUP_ASSET_ID,
l_mass_add_rec.CUA_PARENT_HIERARCHY_ID,
l_mass_add_rec.UNITS_TO_ADJUST,
l_mass_add_rec.BONUS_YTD_DEPRN,
l_mass_add_rec.BONUS_DEPRN_RESERVE,
l_mass_add_rec.AMORTIZE_NBV_FLAG,
l_mass_add_rec.AMORTIZATION_START_DATE,
l_mass_add_rec.TRANSACTION_TYPE_CODE,
l_mass_add_rec.TRANSACTION_DATE,
l_mass_add_rec.WARRANTY_ID,
l_mass_add_rec.LEASE_ID,
l_mass_add_rec.LESSOR_ID,
l_mass_add_rec.PROPERTY_TYPE_CODE,
l_mass_add_rec.PROPERTY_1245_1250_CODE,
l_mass_add_rec.IN_USE_FLAG,
l_mass_add_rec.OWNED_LEASED,
l_mass_add_rec.NEW_USED,
l_mass_add_rec.ASSET_ID,
l_mass_add_rec.MATERIAL_INDICATOR_FLAG,
l_mass_add_rec.distributions_table
FROM fa_mass_additions mass_add
WHERE mass_addition_id = px_group_asset_rec.mass_addition_id;
SELECT segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10
INTO l_akey_segment (1),
l_akey_segment (2),
l_akey_segment (3),
l_akey_segment (4),
l_akey_segment (5),
l_akey_segment (6),
l_akey_segment (7),
l_akey_segment (8),
l_akey_segment (9),
l_akey_segment (10)
FROM fa_asset_keywords
WHERE code_combination_id = l_akey_ccid;
SELECT DISTINCT val_norm.parent_flex_value
INTO l_group_akey_segment1
FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
fnd_flex_value_sets val_set
WHERE val_norm.flex_value_set_id = val_set.flex_value_set_id
AND val_set.flex_value_set_name = l_value_set_name
AND l_here_key_seg_val BETWEEN val_norm.child_flex_value_low
AND val_norm.child_flex_value_high;
SELECT segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10
INTO l_group_akey_segment2,
l_group_akey_segment3,
l_group_akey_segment4,
l_group_akey_segment5,
l_group_akey_segment6,
l_group_akey_segment7,
l_group_akey_segment8,
l_group_akey_segment9,
l_group_akey_segment10
FROM fa_asset_keywords
WHERE code_combination_id = l_child_akey_ccid;
SELECT segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7
INTO l_cat_segment (1),
l_cat_segment (2),
l_cat_segment (3),
l_cat_segment (4),
l_cat_segment (5),
l_cat_segment (6),
l_cat_segment (7)
FROM fa_categories
WHERE category_id = l_mass_add_rec.asset_category_id;
SELECT code_combination_id
INTO l_akey_ccid
FROM fa_asset_keywords
WHERE NVL (segment1, '-1') = NVL (l_group_akey_segment1, '-1')
AND NVL (segment2, '-1') = 'PARENT'
AND NVL (segment3, '-1') =
NVL (l_group_akey_segment3, '-1')
AND NVL (segment4, '-1') =
NVL (l_group_akey_segment4, '-1')
AND NVL (segment5, '-1') =
NVL (l_group_akey_segment5, '-1')
AND NVL (segment6, '-1') =
NVL (l_group_akey_segment6, '-1')
AND NVL (segment7, '-1') =
NVL (l_group_akey_segment7, '-1')
AND NVL (segment8, '-1') =
NVL (l_group_akey_segment8, '-1')
AND NVL (segment9, '-1') =
NVL (l_group_akey_segment9, '-1')
AND NVL (segment10, '-1') =
NVL (l_group_akey_segment10, '-1');
SELECT FA_Asset_keywords_S.NEXTVAL
INTO akey_ccid_seq
FROM DUAL;
INSERT INTO fa_asset_keywords (CODE_COMBINATION_ID,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
SEGMENT6,
SEGMENT7,
SEGMENT8,
SEGMENT9,
SEGMENT10,
SUMMARY_FLAG,
ENABLED_FLAG,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN)
VALUES (akey_ccid_seq,
l_group_akey_segment1,
'PARENT',
l_group_akey_segment3,
l_group_akey_segment4,
l_group_akey_segment5,
l_group_akey_segment6,
l_group_akey_segment7,
l_group_akey_segment8,
l_group_akey_segment9,
l_group_akey_segment10,
'Y',
'Y',
NULL,
NULL,
SYSDATE,
FND_GLOBAL.USER_ID,
-1);
SELECT segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10
INTO l_group_akey_segment2,
l_group_akey_segment3,
l_group_akey_segment4,
l_group_akey_segment5,
l_group_akey_segment6,
l_group_akey_segment7,
l_group_akey_segment8,
l_group_akey_segment9,
l_group_akey_segment10
FROM fa_asset_keywords
WHERE code_combination_id = l_child_akey_ccid;
SELECT DISTINCT ak.code_combination_id
INTO l_akey_ccid
FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
fnd_flex_value_sets val_set,
fa_asset_keywords ak
WHERE val_norm.flex_value_set_id =
val_set.flex_value_set_id
AND val_set.flex_value_set_name = l_value_set_name
AND l_here_key_seg_val BETWEEN val_norm.child_flex_value_low
AND val_norm.child_flex_value_high
AND ak.segment1 = val_norm.parent_flex_value
AND NVL (ak.segment2, '-1') = 'PARENT'
AND NVL (ak.segment3, '-1') =
NVL (l_group_akey_segment3, '-1')
AND NVL (ak.segment4, '-1') =
NVL (l_group_akey_segment4, '-1')
AND NVL (ak.segment5, '-1') =
NVL (l_group_akey_segment5, '-1')
AND NVL (ak.segment6, '-1') =
NVL (l_group_akey_segment6, '-1')
AND NVL (ak.segment7, '-1') =
NVL (l_group_akey_segment7, '-1')
AND NVL (ak.segment8, '-1') =
NVL (l_group_akey_segment8, '-1')
AND NVL (ak.segment9, '-1') =
NVL (l_group_akey_segment9, '-1')
AND NVL (ak.segment10, '-1') =
NVL (l_group_akey_segment10, '-1');
SELECT DISTINCT val_norm.parent_flex_value
INTO l_group_akey_segment1
FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
fnd_flex_value_sets val_set
WHERE val_norm.flex_value_set_id =
val_set.flex_value_set_id
AND val_set.flex_value_set_name =
l_value_set_name
AND l_here_key_seg_val BETWEEN val_norm.child_flex_value_low
AND val_norm.child_flex_value_high;
SELECT DISTINCT code_combination_id
INTO l_akey_ccid
FROM fa_asset_keywords
WHERE NVL (segment1, '-1') =
NVL (l_group_akey_segment1, '-1')
AND NVL (segment2, '-1') = 'PARENT'
AND NVL (segment3, '-1') =
NVL (l_group_akey_segment3, '-1')
AND NVL (segment4, '-1') =
NVL (l_group_akey_segment4, '-1')
AND NVL (segment5, '-1') =
NVL (l_group_akey_segment5, '-1')
AND NVL (segment6, '-1') =
NVL (l_group_akey_segment6, '-1')
AND NVL (segment7, '-1') =
NVL (l_group_akey_segment7, '-1')
AND NVL (segment8, '-1') =
NVL (l_group_akey_segment8, '-1')
AND NVL (segment9, '-1') =
NVL (l_group_akey_segment9, '-1')
AND NVL (segment10, '-1') =
NVL (l_group_akey_segment10, '-1');
SELECT FA_Asset_keywords_S.NEXTVAL
INTO akey_ccid_seq
FROM DUAL;
INSERT
INTO fa_asset_keywords (CODE_COMBINATION_ID,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
SEGMENT6,
SEGMENT7,
SEGMENT8,
SEGMENT9,
SEGMENT10,
SUMMARY_FLAG,
ENABLED_FLAG,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN)
VALUES (akey_ccid_seq,
l_group_akey_segment1,
'PARENT',
l_group_akey_segment3,
l_group_akey_segment4,
l_group_akey_segment5,
l_group_akey_segment6,
l_group_akey_segment7,
l_group_akey_segment8,
l_group_akey_segment9,
l_group_akey_segment10,
'Y',
'Y',
NULL,
NULL,
SYSDATE,
FND_GLOBAL.USER_ID,
-1);
SELECT DISTINCT category_id
INTO l_cat_id
FROM fa_categories
WHERE DECODE (l_cat_segment (1), NULL, '-1', segment1) =
DECODE (l_cat_segment (1),
NULL, '-1',
l_cat_segment (1))
AND DECODE (l_cat_segment (2), NULL, '-1', segment2) =
DECODE (l_cat_segment (2),
NULL, '-1',
l_cat_segment (2))
AND DECODE (l_cat_segment (3), NULL, '-1', segment3) =
DECODE (l_cat_segment (3),
NULL, '-1',
l_cat_segment (3))
AND DECODE (l_cat_segment (4), NULL, '-1', segment4) =
DECODE (l_cat_segment (4),
NULL, '-1',
l_cat_segment (4))
AND DECODE (l_cat_segment (5), NULL, '-1', segment5) =
DECODE (l_cat_segment (5),
NULL, '-1',
l_cat_segment (5))
AND DECODE (l_cat_segment (6), NULL, '-1', segment6) =
DECODE (l_cat_segment (6),
NULL, '-1',
l_cat_segment (6))
AND DECODE (l_cat_segment (7), NULL, '-1', segment7) =
DECODE (l_cat_segment (7),
NULL, '-1',
l_cat_segment (7));
SELECT l_temp + 1
INTO l_temp
FROM fa_books
WHERE book_type_code = l_mass_add_rec.book_type_code
AND transaction_header_id_out IS NULL
AND asset_id = rec.asset_id;
UPDATE fa_mass_additions
SET posting_status = 'ON-HOLD', Queue_name = 'ON-HOLD'
WHERE mass_addition_id = l_mass_add_rec.mass_addition_id;
SELECT DISTINCT cat.category_id
INTO l_group_category_id
FROM fa_categories cat, fa_categories cat1
WHERE cat.SEGMENT2 = l_cat_grp_seg_val
AND cat1.category_id = l_category_id
AND cat1.segment1 = cat.segment1
AND EXISTS
(SELECT 'x'
FROM fa_category_books cb
WHERE cb.category_id = cat.category_id
AND cb.book_type_code =
l_mass_add_rec.book_type_code)
AND EXISTS
(SELECT 'x'
FROM fa_category_books cb1
WHERE cb1.category_id = cat1.category_id
AND cb1.book_type_code =
l_mass_add_rec.book_type_code);
l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
UPDATE fa_mass_additions
SET posting_status = 'POST',
Queue_name = 'POST',
group_asset_id = l_mass_add_rec.group_asset_id
WHERE mass_addition_id = l_mass_add_rec.mass_addition_id;
l_debug_str := 'Update the mass addition line with parent asset id';
UPDATE fa_mass_additions
SET posting_status = 'POST',
Queue_name = 'POST',
group_asset_id = l_parent_asset_id
WHERE mass_addition_id = l_mass_add_rec.mass_addition_id;
SELECT DISTINCT asset_key_ccid, asset_type, asset_category_id
INTO l_akey_ccid, l_asset_type, l_category_id
FROM fa_Additions
WHERE asset_id = px_group_asset_rec.asset_id;
SELECT l_temp + 1
INTO l_temp
FROM fa_books
WHERE book_type_code = px_group_asset_rec.book_type_code
AND transaction_header_id_out IS NULL
AND asset_id = px_group_asset_rec.asset_id;
SELECT CALENDAR_PERIOD_OPEN_DATE
INTO l_CALENDAR_PERIOD_OPEN_DATE
FROM fa_deprn_periods
WHERE period_close_date IS NULL
AND book_type_code = px_group_asset_rec.book_type_code;
SELECT DISTINCT cat.category_id
INTO l_group_category_id
FROM fa_categories cat, fa_categories cat1
WHERE cat.SEGMENT2 = l_cat_grp_seg_val
AND cat1.category_id = l_category_id
AND cat1.segment1 = cat.segment1
AND EXISTS
(SELECT 'x'
FROM fa_category_books cb
WHERE cb.category_id = cat.category_id
AND cb.book_type_code =
l_mass_add_rec.book_type_code)
AND EXISTS
(SELECT 'x'
FROM fa_category_books cb1
WHERE cb1.category_id = cat1.category_id
AND cb1.book_type_code =
l_mass_add_rec.book_type_code);
l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
SELECT location_id, code_combination_id
INTO l_asset_dist_rec.location_ccid,
l_asset_dist_rec.expense_ccid
FROM fa_distribution_history
WHERE asset_id = px_group_asset_rec.asset_id
AND book_type_code = px_group_asset_rec.book_type_code
AND date_ineffective IS NULL;