APPS.FTP_BR_PREPAYMENT_PVT SQL Statements

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

Line: 10

PROCEDURE DeletePrepaymentAssumptionRecs(
  p_obj_def_id          in          number
);

Line: 14

PROCEDURE DeleteRateDefinitionRecs(
  p_obj_def_id          in          number
);

Line: 18

PROCEDURE DeleteConditionRecs(
  p_obj_def_id          in          number
);

Line: 51

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
IS

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

Line: 59

  DeletePrepaymentAssumptionRecs(
    p_obj_def_id    => p_obj_def_id
  );

Line: 63

  DeleteRateDefinitionRecs(
    p_obj_def_id    => p_obj_def_id
  );

Line: 67

 DeleteConditionRecs(
    p_obj_def_id     => p_obj_def_id
  );

Line: 77

END DeleteObjectDefinition;

Line: 153

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

  delete from ftp_prepayment_rule
  where object_definition_id = p_obj_def_id;

Line: 163

END DeletePrepaymentAssumptionRecs;

Line: 178

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

  delete from ftp_pp_orgdate_assump
  where object_definition_id = p_obj_def_id;

Line: 188

END DeleteRateDefinitionRecs;

Line: 204

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

  delete from ftp_tp_pp_conditions
  where object_definition_id = p_obj_def_id;

Line: 214

END DeleteConditionRecs;

Line: 243

  insert into ftp_prepayment_rule (
    object_definition_id
    ,line_item_id
    ,currency
    ,cond_sequence
    ,calc_method_code
    ,portfolio_flg
    ,quote_code
    ,rate_term_code
    ,interest_rate_code
    ,seasonality_flg
    ,rate_spread
    ,jan_coeff
    ,feb_coeff
    ,mar_coeff
    ,apr_coeff
    ,may_coeff
    ,jun_coeff
    ,jul_coeff
    ,aug_coeff
    ,sep_coeff
    ,oct_coeff
    ,nov_coeff
    ,dec_coeff
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,ppr_assumption_id
  ) select
    p_target_obj_def_id
    ,line_item_id
    ,currency
    ,cond_sequence
    ,calc_method_code
    ,portfolio_flg
    ,quote_code
    ,rate_term_code
    ,interest_rate_code
    ,seasonality_flg
    ,rate_spread
    ,jan_coeff
    ,feb_coeff
    ,mar_coeff
    ,apr_coeff
    ,may_coeff
    ,jun_coeff
    ,jul_coeff
    ,aug_coeff
    ,sep_coeff
    ,oct_coeff
    ,nov_coeff
    ,dec_coeff
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
    ,FTP.FTP_PPR_ASSUMPTION_ID_SEQ.NEXTVAL
  from ftp_prepayment_rule
  where object_definition_id = p_source_obj_def_id;

Line: 341

   SELECT PPR_ASSUMPTION_ID, OBJECT_DEFINITION_ID,
   LINE_ITEM_ID,CURRENCY, COND_SEQUENCE
   FROM FTP_PREPAYMENT_RULE
   WHERE OBJECT_DEFINITION_ID = p_target_obj_def_id;

Line: 353

   insert into ftp_pp_orgdate_assump (
    object_definition_id
    ,line_item_id
    ,currency
    ,cond_sequence
    ,origination_date
    ,const_prepay_rate
    ,prepay_tbl_object_id
    ,burnout_factor
    ,arc_coeff_1
    ,arc_coeff_2
    ,arc_coeff_3
    ,arc_coeff_4
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,ppr_assumption_id
   ) select
    p_target_obj_def_id
    ,line_item_id
    ,currency
    ,cond_sequence
    ,origination_date
    ,const_prepay_rate
    ,prepay_tbl_object_id
    ,burnout_factor
    ,arc_coeff_1
    ,arc_coeff_2
    ,arc_coeff_3
    ,arc_coeff_4
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
    ,v_ppr_id
   from ftp_pp_orgdate_assump
   where object_definition_id = p_source_obj_def_id
   and line_item_id = v_ln_id
   and currency = v_currency
   and cond_sequence = v_seq;

Line: 427

  insert into ftp_tp_pp_conditions (
    object_definition_id
    ,line_item_id
    ,currency
    ,cond_sequence
    ,cond_order
    ,level_num
    ,table_name
    ,column_name
    ,column_data_type
    ,compare_type
    ,comparator
    ,logical
    ,r_from
    ,r_to
    ,left_paren
    ,right_paren
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
  ) select
    p_target_obj_def_id
    ,line_item_id
    ,currency
    ,cond_sequence
    ,cond_order
    ,level_num
    ,table_name
    ,column_name
    ,column_data_type
    ,compare_type
    ,comparator
    ,logical
    ,r_from
    ,r_to
    ,left_paren
    ,right_paren
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
  from ftp_tp_pp_conditions
  where object_definition_id = p_source_obj_def_id;