APPS.FTP_BR_PREPAY_TABLE_PVT SQL Statements

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

Line: 10

PROCEDURE DeletePrepayTableRuleRecs(
  p_obj_def_id          in          number
);

Line: 14

PROCEDURE DeleteTblDimensionValueRecs(
  p_obj_def_id          in          number
);

Line: 18

PROCEDURE DeleteTblHypercubeRecs(
  p_obj_def_id          in          number
);

Line: 52

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
IS

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

Line: 60

  DeletePrepayTableRuleRecs(
    p_obj_def_id    => p_obj_def_id
  );

Line: 64

  DeleteTblDimensionValueRecs(
    p_obj_def_id    => p_obj_def_id
  );

Line: 68

  DeleteTblHypercubeRecs(
    p_obj_def_id    => p_obj_def_id
  );

Line: 77

END DeleteObjectDefinition;

Line: 150

PROCEDURE DeletePrepayTableRuleRecs(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN

  delete from ftp_prepay_table_rule
  where object_definition_id = p_obj_def_id;

Line: 160

END DeletePrepayTableRuleRecs;

Line: 175

PROCEDURE DeleteTblDimensionValueRecs(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN

  delete from ftp_pp_tbl_dim_value
  where pptb_object_definition_id = p_obj_def_id;

Line: 185

END DeleteTblDimensionValueRecs;

Line: 200

PROCEDURE DeleteTblHypercubeRecs(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN

  delete from ftp_pp_tbl_hypercube
  where object_definition_id = p_obj_def_id;

Line: 210

END DeleteTblHypercubeRecs;

Line: 239

  insert into ftp_prepay_table_rule (
    object_definition_id
    ,pp_dim_type_code
    ,dim_display_seq
    ,num_nodes
    ,interpolation_flg
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,pptb_dimension_id
  ) select
    p_target_obj_def_id
    ,pp_dim_type_code
    ,dim_display_seq
    ,num_nodes
    ,interpolation_flg
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
    ,FTP.FTP_PPTB_DIM_ID_SEQ.NEXTVAL
  from ftp_prepay_table_rule
  where object_definition_id = p_source_obj_def_id;

Line: 294

  insert into ftp_pp_tbl_dim_value (
    pptb_object_definition_id
    ,pptb_dim_type_code
    ,type_display_seq
    ,type_value
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,pptb_dimension_value_id
  ) select
    p_target_obj_def_id
    ,pptb_dim_type_code
    ,type_display_seq
    ,type_value
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
    ,FTP.FTP_PPTB_DIM_VALUE_ID_SEQ.NEXTVAL
  from ftp_pp_tbl_dim_value
  where pptb_object_definition_id = p_source_obj_def_id;

Line: 349

  insert into ftp_pp_tbl_hypercube (
    object_definition_id
    ,original_term
    ,reprice_freq
    ,remain_term
    ,expired_term
    ,term_to_repr
    ,coupon_rate
    ,market_rate
    ,rate_difference
    ,rate_ratio
    ,prepayment_rate
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,pptb_hypercube_id
  ) select
    p_target_obj_def_id
    ,original_term
    ,reprice_freq
    ,remain_term
    ,expired_term
    ,term_to_repr
    ,coupon_rate
    ,market_rate
    ,rate_difference
    ,rate_ratio
    ,prepayment_rate
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
    ,FTP.FTP_PPTB_HYPERCUBE_ID_SEQ.NEXTVAL
  from ftp_pp_tbl_hypercube
  where object_definition_id = p_source_obj_def_id;