[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select bc.fiscal_year_name,
bc.current_fiscal_year,
bc.book_class,
dp.calendar_period_close_date
from fa_book_controls bc,
fa_deprn_periods dp
where bc.book_type_code = l_book
and bc.last_period_counter = dp.period_counter
and dp.book_type_code = bc.book_type_code
and bc.book_class <> 'BUDGET'
and nvl(bc.date_ineffective, sysdate + 1) > sysdate;
Select 'Validated'
From fa_category_books cb
Where book_type_code = l_book
And category_id = l_category_id;
Select 'Validated'
From fa_lookups
Where lookup_type = 'RETIREMENT'
And lookup_code = l_retirement_type_code;
Select 'Validated'
FROM fa_deprn_periods fadp
WHERE fadp.book_type_code = l_book
AND fadp.period_close_date IS NULL
AND l_retirement_date
<= fadp.calendar_period_close_date;
SELECT 'Validated'
FROM fa_fiscal_year
WHERE fiscal_year = l_fiscal_year
AND fiscal_year_name = l_fiscal_year_name
AND l_retirement_date
BETWEEN start_date AND end_date;
SELECT 'Validated'
FROM FA_LOOKUPS
WHERE LOOKUP_TYPE = 'MASS_TRX_STATUS'
AND LOOKUP_CODE = l_status
AND LOOKUP_CODE in ('NEW','PENDING','ON_HOLD'
);
SELECT 'Validated'
FROM FA_LOCATIONS
WHERE location_id = l_location_id
AND sysdate between nvl(start_date_active,sysdate -1)
and nvl(end_date_active, sysdate +1)
AND enabled_flag = 'Y';
SELECT 'Validated'
FROM FA_EMPLOYEES
WHERE employee_id = l_employee_id;
SELECT 'Validated'
FROM FA_ASSET_KEYWORDS
WHERE code_combination_id = l_asset_key_id;
Select 'Validated'
From fa_books bk,
fa_additions ad
Where ad.asset_number = l_from_asset_no
And ad.asset_id = bk.asset_id
And bk.book_type_code = l_book
And bk.date_ineffective is null;
Select 'Validated'
From fa_books bk,
fa_additions ad
Where ad.asset_number = l_to_asset_no
And ad.asset_id = bk.asset_id
And bk.book_type_code = l_book
And bk.date_ineffective is null;
Insert into fa_mass_retirements (
MASS_RETIREMENT_ID,
BOOK_TYPE_CODE,
RETIRE_SUBCOMPONENTS_FLAG,
STATUS,
RETIRE_REQUEST_ID,
REINSTATE_REQUEST_ID,
RETIREMENT_DATE,
PROCEEDS_OF_SALE,
COST_OF_REMOVAL,
DESCRIPTION,
RETIREMENT_TYPE_CODE,
ASSET_TYPE,
LOCATION_ID,
EMPLOYEE_ID,
CATEGORY_ID,
ASSET_KEY_ID,
FROM_ASSET_NUMBER,
TO_ASSET_NUMBER,
FROM_DATE_PLACED_IN_SERVICE,
TO_DATE_PLACED_IN_SERVICE,
FROM_COST,
MODEL_NUMBER,
TAG_NUMBER,
MANUFACTURER_NAME,
SERIAL_NUMBER,
CREATE_REQUEST_ID,
UNITS_TO_RETIRE,
INCLUDE_FULLY_RSVD_FLAG,
TO_COST,
GROUP_ASSET_ID,
FROM_THRESHOLD_AMOUNT,
TO_THRESHOLD_AMOUNT,
PROJECT_ID,
TASK_ID,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE_CATEGORY_CODE,
SEGMENT1_LOW,
SEGMENT2_LOW,
SEGMENT3_LOW,
SEGMENT4_LOW,
SEGMENT5_LOW,
SEGMENT6_LOW,
SEGMENT7_LOW,
SEGMENT8_LOW,
SEGMENT9_LOW,
SEGMENT10_LOW,
SEGMENT11_LOW,
SEGMENT12_LOW,
SEGMENT13_LOW,
SEGMENT14_LOW,
SEGMENT15_LOW,
SEGMENT16_LOW,
SEGMENT17_LOW,
SEGMENT18_LOW,
SEGMENT19_LOW,
SEGMENT20_LOW,
SEGMENT21_LOW,
SEGMENT22_LOW,
SEGMENT23_LOW,
SEGMENT24_LOW,
SEGMENT25_LOW,
SEGMENT26_LOW,
SEGMENT27_LOW,
SEGMENT28_LOW,
SEGMENT29_LOW,
SEGMENT30_LOW,
SEGMENT1_HIGH,
SEGMENT2_HIGH,
SEGMENT3_HIGH,
SEGMENT4_HIGH,
SEGMENT5_HIGH,
SEGMENT6_HIGH,
SEGMENT7_HIGH,
SEGMENT8_HIGH,
SEGMENT9_HIGH,
SEGMENT10_HIGH,
SEGMENT11_HIGH,
SEGMENT12_HIGH,
SEGMENT13_HIGH,
SEGMENT14_HIGH,
SEGMENT15_HIGH,
SEGMENT16_HIGH,
SEGMENT17_HIGH,
SEGMENT18_HIGH,
SEGMENT19_HIGH,
SEGMENT20_HIGH,
SEGMENT21_HIGH,
SEGMENT22_HIGH,
SEGMENT23_HIGH,
SEGMENT24_HIGH,
SEGMENT25_HIGH,
SEGMENT26_HIGH,
SEGMENT27_HIGH,
SEGMENT28_HIGH,
SEGMENT29_HIGH,
SEGMENT30_HIGH,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN)
VALUES
(
FA_MASS_TRANSACTIONS_S.NEXTVAL,
L_MASS_RET_REC(mr_count).BOOK_TYPE_CODE,
L_MASS_RET_REC(mr_count).RETIRE_SUBCOMPONENTS_FLAG,
L_MASS_RET_REC(mr_count).STATUS,
L_MASS_RET_REC(mr_count).RETIRE_REQUEST_ID,
L_MASS_RET_REC(mr_count).REINSTATE_REQUEST_ID,
L_MASS_RET_REC(mr_count).RETIREMENT_DATE,
L_MASS_RET_REC(mr_count).PROCEEDS_OF_SALE,
L_MASS_RET_REC(mr_count).COST_OF_REMOVAL,
L_MASS_RET_REC(mr_count).DESCRIPTION,
L_MASS_RET_REC(mr_count).RETIREMENT_TYPE_CODE,
L_MASS_RET_REC(mr_count).ASSET_TYPE,
L_MASS_RET_REC(mr_count).LOCATION_ID,
L_MASS_RET_REC(mr_count).EMPLOYEE_ID,
L_MASS_RET_REC(mr_count).CATEGORY_ID,
L_MASS_RET_REC(mr_count).ASSET_KEY_ID,
L_MASS_RET_REC(mr_count).FROM_ASSET_NUMBER,
L_MASS_RET_REC(mr_count).TO_ASSET_NUMBER,
L_MASS_RET_REC(mr_count).FROM_DATE_PLACED_IN_SERVICE,
L_MASS_RET_REC(mr_count).TO_DATE_PLACED_IN_SERVICE,
L_MASS_RET_REC(mr_count).FROM_COST,
L_MASS_RET_REC(mr_count).MODEL_NUMBER,
L_MASS_RET_REC(mr_count).TAG_NUMBER,
L_MASS_RET_REC(mr_count).MANUFACTURER_NAME,
L_MASS_RET_REC(mr_count).SERIAL_NUMBER,
L_MASS_RET_REC(mr_count).CREATE_REQUEST_ID,
L_MASS_RET_REC(mr_count).UNITS_TO_RETIRE,
L_MASS_RET_REC(mr_count).INCLUDE_FULLY_RSVD_FLAG,
L_MASS_RET_REC(mr_count).TO_COST,
L_MASS_RET_REC(mr_count).GROUP_ASSET_ID,
L_MASS_RET_REC(mr_count).FROM_THRESHOLD_AMOUNT,
L_MASS_RET_REC(mr_count).TO_THRESHOLD_AMOUNT,
L_MASS_RET_REC(mr_count).PROJECT_ID,
L_MASS_RET_REC(mr_count).TASK_ID,
L_MASS_RET_REC(mr_count).ATTRIBUTE1,
L_MASS_RET_REC(mr_count).ATTRIBUTE2,
L_MASS_RET_REC(mr_count).ATTRIBUTE3,
L_MASS_RET_REC(mr_count).ATTRIBUTE4,
L_MASS_RET_REC(mr_count).ATTRIBUTE5,
L_MASS_RET_REC(mr_count).ATTRIBUTE6,
L_MASS_RET_REC(mr_count).ATTRIBUTE7,
L_MASS_RET_REC(mr_count).ATTRIBUTE8,
L_MASS_RET_REC(mr_count).ATTRIBUTE9,
L_MASS_RET_REC(mr_count).ATTRIBUTE10,
L_MASS_RET_REC(mr_count).ATTRIBUTE11,
L_MASS_RET_REC(mr_count).ATTRIBUTE12,
L_MASS_RET_REC(mr_count).ATTRIBUTE13,
L_MASS_RET_REC(mr_count).ATTRIBUTE14,
L_MASS_RET_REC(mr_count).ATTRIBUTE15,
L_MASS_RET_REC(mr_count).ATTRIBUTE_CATEGORY_CODE,
L_MASS_RET_REC(mr_count).SEGMENT1_LOW,
L_MASS_RET_REC(mr_count).SEGMENT2_LOW,
L_MASS_RET_REC(mr_count).SEGMENT3_LOW,
L_MASS_RET_REC(mr_count).SEGMENT4_LOW,
L_MASS_RET_REC(mr_count).SEGMENT5_LOW,
L_MASS_RET_REC(mr_count).SEGMENT6_LOW,
L_MASS_RET_REC(mr_count).SEGMENT7_LOW,
L_MASS_RET_REC(mr_count).SEGMENT8_LOW,
L_MASS_RET_REC(mr_count).SEGMENT9_LOW,
L_MASS_RET_REC(mr_count).SEGMENT10_LOW,
L_MASS_RET_REC(mr_count).SEGMENT11_LOW,
L_MASS_RET_REC(mr_count).SEGMENT12_LOW,
L_MASS_RET_REC(mr_count).SEGMENT13_LOW,
L_MASS_RET_REC(mr_count).SEGMENT14_LOW,
L_MASS_RET_REC(mr_count).SEGMENT15_LOW,
L_MASS_RET_REC(mr_count).SEGMENT16_LOW,
L_MASS_RET_REC(mr_count).SEGMENT17_LOW,
L_MASS_RET_REC(mr_count).SEGMENT18_LOW,
L_MASS_RET_REC(mr_count).SEGMENT19_LOW,
L_MASS_RET_REC(mr_count).SEGMENT20_LOW,
L_MASS_RET_REC(mr_count).SEGMENT21_LOW,
L_MASS_RET_REC(mr_count).SEGMENT22_LOW,
L_MASS_RET_REC(mr_count).SEGMENT23_LOW,
L_MASS_RET_REC(mr_count).SEGMENT24_LOW,
L_MASS_RET_REC(mr_count).SEGMENT25_LOW,
L_MASS_RET_REC(mr_count).SEGMENT26_LOW,
L_MASS_RET_REC(mr_count).SEGMENT27_LOW,
L_MASS_RET_REC(mr_count).SEGMENT28_LOW,
L_MASS_RET_REC(mr_count).SEGMENT29_LOW,
L_MASS_RET_REC(mr_count).SEGMENT30_LOW,
L_MASS_RET_REC(mr_count).SEGMENT1_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT2_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT3_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT4_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT5_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT6_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT7_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT8_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT9_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT10_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT11_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT12_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT13_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT14_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT15_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT16_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT17_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT18_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT19_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT20_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT21_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT22_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT23_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT24_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT25_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT26_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT27_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT28_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT29_HIGH,
L_MASS_RET_REC(mr_count).SEGMENT30_HIGH,
L_MASS_RET_REC(mr_count).LAST_UPDATE_DATE,
L_MASS_RET_REC(mr_count).LAST_UPDATED_BY,
L_MASS_RET_REC(mr_count).CREATION_DATE,
L_MASS_RET_REC(mr_count).CREATED_BY,
L_MASS_RET_REC(mr_count).LAST_UPDATE_LOGIN
);