APPS.FTP_BR_TRANSFER_PRICE_PVT SQL Statements

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

Line: 13

PROCEDURE DeleteTransferPriceRuleRec(
  p_obj_def_id          in          number
);

Line: 17

PROCEDURE DeleteUnpricedAccountRecs(
  p_obj_def_id          in          number
);

Line: 21

PROCEDURE DeleteRedemptionCurveRecs(
  p_obj_def_id          in          number
);

Line: 25

PROCEDURE DeleteConditionRecs(
  p_obj_def_id          in          number
);

Line: 72

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
--------------------------------------------------------------------------------
IS

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

Line: 82

  DeleteUnpricedAccountRecs(
    p_obj_def_id     => p_obj_def_id
  );

Line: 86

  DeleteRedemptionCurveRecs(
    p_obj_def_id     => p_obj_def_id
  );

Line: 90

  DeleteConditionRecs(
    p_obj_def_id     => p_obj_def_id
  );

Line: 94

  DeleteTransferPriceRuleRec(
    p_obj_def_id     => p_obj_def_id
  );

Line: 104

END DeleteObjectDefinition;

Line: 189

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

  delete from ftp_transfer_price_rule
  where object_definition_id = p_obj_def_id;

Line: 199

END DeleteTransferPriceRuleRec;

Line: 214

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

  delete from ftp_tp_unpriced_acct_dtl
  where object_definition_id = p_obj_def_id;

Line: 224

END DeleteUnpricedAccountRecs;

Line: 239

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

  delete from ftp_tp_redempt_curve_dtl
  where object_definition_id = p_obj_def_id;

Line: 249

END DeleteRedemptionCurveRecs;

Line: 265

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: 275

END DeleteConditionRecs;

Line: 303

  insert into ftp_transfer_price_rule (
    object_definition_id
    ,line_item_id
    ,currency
    ,cond_sequence
    ,data_source_code
    ,tp_calc_method_code
    ,gross_rate_flg
    ,interest_rate_code
    ,yield_curve_term
    ,yield_curve_mult
    ,historical_term
    ,historical_mult
    ,assignment_date_code
    ,option_cost_method_code
    ,target_bal_code
    ,rate_spread
    ,lag_term
    ,lag_mult
    ,across_org_unit_flg
    ,mid_period_reprice_flg
    ,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
    ,data_source_code
    ,tp_calc_method_code
    ,gross_rate_flg
    ,interest_rate_code
    ,yield_curve_term
    ,yield_curve_mult
    ,historical_term
    ,historical_mult
    ,assignment_date_code
    ,option_cost_method_code
    ,target_bal_code
    ,rate_spread
    ,lag_term
    ,lag_mult
    ,across_org_unit_flg
    ,mid_period_reprice_flg
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
  from ftp_transfer_price_rule
  where object_definition_id = p_source_obj_def_id;

Line: 386

  insert into ftp_tp_unpriced_acct_dtl (
    object_definition_id
    ,line_item_id
    ,currency
    ,cond_sequence
    ,source_line_item_id
    ,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
    ,source_line_item_id
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
  from ftp_tp_unpriced_acct_dtl
  where object_definition_id = p_source_obj_def_id;

Line: 441

  insert into ftp_tp_redempt_curve_dtl (
    object_definition_id
    ,line_item_id
    ,currency
    ,cond_sequence
    ,interest_rate_code
    ,interest_rate_term
    ,interest_rate_term_mult
    ,percentage
    ,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
    ,interest_rate_code
    ,interest_rate_term
    ,interest_rate_term_mult
    ,percentage
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
  from ftp_tp_redempt_curve_dtl
  where object_definition_id = p_source_obj_def_id;

Line: 500

  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;