The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE DeleteObjectDefinition(
p_obj_def_id in number
)
IS
g_api_name constant varchar2(30) := 'DeleteObjectDefinition';
DELETE FROM FTP_RATE_OUTPUT_MAPPING_RULE
WHERE object_definition_id = p_obj_def_id;
END DeleteObjectDefinition;
INSERT INTO FTP_RATE_OUTPUT_MAPPING_RULE (
OBJECT_DEFINITION_ID,
FTP_ACCOUNT_TABLE_NAME,
TRANSFER_RATE_COL_NAME,
MATCHED_SPREAD_COL_NAME,
REMAINING_TERM_COL_NAME,
HIST_OAS_COL_NAME,
HIST_STAT_SPREAD_COL_NAME,
CUR_OAS_COL_NAME,
CUR_STAT_SPREAD_COL_NAME,
ADJUSTMENT_SPRD_COL_NAME,
ADJUSTMENT_AMOUNT_COL_NAME,
SELECT_ALL_TABS_FLG,
CREATION_DATE,
CREATED_BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
SELECT
p_target_obj_def_id,
FTP_ACCOUNT_TABLE_NAME,
TRANSFER_RATE_COL_NAME,
MATCHED_SPREAD_COL_NAME,
REMAINING_TERM_COL_NAME,
HIST_OAS_COL_NAME,
HIST_STAT_SPREAD_COL_NAME,
CUR_OAS_COL_NAME,
CUR_STAT_SPREAD_COL_NAME,
ADJUSTMENT_SPRD_COL_NAME,
ADJUSTMENT_AMOUNT_COL_NAME,
SELECT_ALL_TABS_FLG,
NVL(p_creation_date,CREATION_DATE),
NVL(p_created_by,CREATED_BY),
FND_GLOBAL.user_id,
SYSDATE,
FND_GLOBAL.login_id
FROM FTP_RATE_OUTPUT_MAPPING_RULE
WHERE OBJECT_DEFINITION_ID = p_source_obj_def_id;