DBA Data[Home] [Help]

APPS.FTP_BR_ROM_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
IS

  g_api_name    constant varchar2(30)   := 'DeleteObjectDefinition';
Line: 21

	DELETE FROM FTP_RATE_OUTPUT_MAPPING_RULE
	WHERE object_definition_id = p_obj_def_id;
Line: 30

END DeleteObjectDefinition;
Line: 56

  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;