The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_CFS_data(P_COA_ID IN NUMBER,
P_LEDGER_ID IN NUMBER,
P_LEGAL_ENTITY_ID IN NUMBER
) AS
BEGIN
INSERT INTO ja_cn_cfs_activities_all(CFS_ACTIVITY_ID,
LEGAL_ENTITY_ID,
LEDGER_ID,
ORG_ID,
TRX_ID,
TRX_NUMBER,
TRX_LINE_ID,
SOURCE,
TRANSACTION_TYPE,
DOCUMENT_SEQUENCE_NUMBER,
TRANSACTION_DATE,
GL_DATE,
PERIOD_NAME,
FUNC_CURR_CODE,
FUNC_AMOUNT,
ORIGINAL_CURR_CODE,
ORIGINAL_AMOUNT,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_DATE,
DESCRIPTION,
DETAILED_CFS_ITEM,
INTERCOMPANY_FLAG,
REFERENCE_NUMBER,
THIRD_PARTY_NAME,
THIRD_PARTY_NUMBER,
EVENT_CLASS_CODE,
SOURCE_APPLICATION_ID,
ANALYTICAL_CRITERION_CODE,
SOURCE_VALUE,
CASH_ITEM_DESC,
UPGRADE_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN)
SELECT ja_cn_cfs_activities_s.NEXTVAL,
LEGAL_ENTITY_ID,
LEDGER_ID,
ORG_ID,
TRX_ID,
TRX_NUMBER,
TRX_LINE_ID,
SOURCE,
TRANSACTION_TYPE,
DOCUMENT_SEQUENCE_NUMBER,
TRANSACTION_DATE,
GL_DATE,
PERIOD_NAME,
FUNC_CURR_CODE,
FUNC_AMOUNT,
ORIGINAL_CURR_CODE,
ORIGINAL_AMOUNT,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_DATE,
DESCRIPTION,
DETAILED_CFS_ITEM,
INTERCOMPANY_FLAG,
REFERENCE_NUMBER,
THIRD_PARTY_NAME,
THIRD_PARTY_NUMBER,
EVENT_CLASS_CODE,
SOURCE_APPLICATION_ID,
ANALYTICAL_CRITERION_CODE,
SOURCE_VALUE,
CASH_ITEM_DESC,
'I',
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
fnd_global.LOGIN_ID
FROM ja_cn_cfs_activities_interface
WHERE legal_entity_id = p_legal_entity_id
AND ledger_id = p_ledger_id
AND status = 'S';
SELECT ROWID,
period_name,
func_curr_code,
detailed_cfs_item,
trx_number,
transaction_date
FROM ja_cn_cfs_activities_interface
WHERE ledger_id = p_ledger_id
AND legal_entity_id = p_legal_entity_id;
DELETE FROM ja_cn_cfs_activities_interface
WHERE ledger_id = p_ledger_id
AND legal_entity_id = p_legal_entity_id
AND (status = 'E' OR status = 'S');
SELECT COUNT(*)
INTO l_number
FROM gl_ledgers
WHERE ledger_id = P_LEDGER_ID
AND currency_code = l_func_curr_code;
SELECT COUNT(*)
INTO l_number
FROM Gl_Periods gp, gl_ledgers gl
WHERE gl.ledger_id = p_ledger_id
AND gl.period_set_name = gp.period_set_name
AND gp.period_name = l_period_name;
SELECT COUNT(*)
INTO l_number
FROM Fnd_Flex_Values_Tl Ffvt,
fnd_flex_values Ffv,
ja_cn_cash_valuesets_all Cra
WHERE Cra.Chart_Of_Accounts_Id = P_COA_Id
AND Ffv.Flex_Value_Set_Id = Cra.Flex_Value_Set_Id
AND Ffv.Flex_Value_Id = Ffvt.Flex_Value_Id
AND Ffv.Flex_Value = l_detailed_cfs_item
AND ffvt.LANGUAGE = userenv('LANG');
UPDATE ja_cn_cfs_activities_interface
SET status = 'S'
WHERE ROWID = l_rowid;
UPDATE ja_cn_cfs_activities_interface
SET status = 'E'
WHERE ROWID = l_rowid;
insert_CFS_data(P_COA_ID,
P_LEDGER_ID,
P_legal_entity_ID);