APPS.FTP_BR_RATE_INDEX_PVT SQL Statements

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

Line: 11

PROCEDURE DeleteRateIndexRuleRec(
  p_obj_def_id          in          number
);

Line: 14

PROCEDURE DeleteRIValuationCurveRecs(
  p_obj_def_id          in          number
);

Line: 43

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
--------------------------------------------------------------------------------
IS
  g_api_name    constant varchar2(30)   := 'DeleteObjectDefinition';

Line: 50

  DeleteRIValuationCurveRecs(
    p_obj_def_id     => p_obj_def_id
  );

Line: 53

  DeleteRateIndexRuleRec(
    p_obj_def_id     => p_obj_def_id
  );

Line: 60

END DeleteObjectDefinition;

Line: 118

PROCEDURE DeleteRateIndexRuleRec(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN
  delete from ftp_rate_index_rule
  where object_definition_id = p_obj_def_id;

Line: 126

END DeleteRateIndexRuleRec;

Line: 139

PROCEDURE DeleteRIValuationCurveRecs(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN
  delete from ftp_ri_valuation_curve
  where object_definition_id = p_obj_def_id;

Line: 147

END DeleteRIValuationCurveRecs;

Line: 172

  insert into ftp_rate_index_rule (
    object_definition_id
    ,currency
    ,interest_rate_code
    ,yield_cv_term
    ,yield_cv_term_mult
    ,element_number
    ,coefficient
    ,exponent
    ,val_yc_term
    ,val_yc_term_mult
    ,creation_date
    ,created_by
    ,last_updated_by
    ,last_update_date
    ,last_update_login
  ) select
    p_target_obj_def_id
     ,currency
     ,interest_rate_code
     ,yield_cv_term
     ,yield_cv_term_mult
     ,element_number
     ,coefficient
     ,exponent
     ,val_yc_term
     ,val_yc_term_mult
     ,nvl(p_creation_date,creation_date)
     ,nvl(p_created_by,created_by)
     ,FND_GLOBAL.user_id
     ,sysdate
     ,FND_GLOBAL.login_id
  from ftp_rate_index_rule
  where object_definition_id = p_source_obj_def_id;

Line: 231

  insert into ftp_ri_valuation_curve (
    object_definition_id
    ,currency
    ,interest_rate_code
    ,creation_date
    ,created_by
    ,last_updated_by
    ,last_update_date
    ,last_update_login
  ) select
    p_target_obj_def_id
    ,currency
    ,interest_rate_code
    ,nvl(p_creation_date,creation_date)
    ,nvl(p_created_by,created_by)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
  from ftp_ri_valuation_curve
  where object_definition_id = p_source_obj_def_id;