APPS.FTP_BR_TP_PROCESS_RULE_PVT SQL Statements

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

Line: 11

PROCEDURE DeleteTpProcessRuleRec(
  p_obj_def_id          in          number
);

Line: 14

PROCEDURE DeleteTpStochAssumpRecs(
  p_obj_def_id          in          number
);

Line: 17

PROCEDURE DeleteMigrationColumnRecs(
  p_obj_def_id          in          number
);

Line: 20

PROCEDURE DeleteProcessTableRecs(
  p_obj_def_id          in          number
);

Line: 61

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

Line: 68

  DeleteProcessTableRecs(
    p_obj_def_id     => p_obj_def_id
  );

Line: 71

  DeleteMigrationColumnRecs(
    p_obj_def_id     => p_obj_def_id
  );

Line: 74

  DeleteTpStochAssumpRecs(
    p_obj_def_id     => p_obj_def_id
  );

Line: 77

  DeleteTpProcessRuleRec(
    p_obj_def_id     => p_obj_def_id
  );

Line: 84

END DeleteObjectDefinition;

Line: 154

PROCEDURE DeleteTpProcessRuleRec(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN
  delete from ftp_tp_process_rule
  where object_definition_id = p_obj_def_id;

Line: 162

END DeleteTpProcessRuleRec;

Line: 175

PROCEDURE DeleteTpStochAssumpRecs(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN
  delete from ftp_tp_stoch_assump
  where object_definition_id = p_obj_def_id;

Line: 183

END DeleteTpStochAssumpRecs;

Line: 196

PROCEDURE DeleteMigrationColumnRecs(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN
  delete from ftp_tp_selctd_columns
  where object_definition_id = p_obj_def_id;

Line: 204

END DeleteMigrationColumnRecs;

Line: 217

PROCEDURE DeleteProcessTableRecs(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN
  delete from ftp_tp_process_tables
  where object_definition_id = p_obj_def_id;

Line: 225

END DeleteProcessTableRecs;

Line: 250

  insert into ftp_tp_process_rule (
        object_definition_id
        ,calc_mode_code
        ,transfer_price_object_id
        ,prepay_object_id
        ,filter_object_id
        ,dtl_cashflow_flg
        ,skip_nonzero_trans_rate_flg
        ,skip_nonzero_opt_cost_flg
        ,trans_rate_propagate_flg
        ,trans_rate_calc_flg
        ,trans_rate_migrate_flg
        ,option_cost_propagate_flg
        ,option_cost_calc_flg
        ,option_cost_migrate_flg
        ,write_forward_rate_flg
        ,accrual_code
        ,currency_flg
        ,creation_date
        ,created_by
        ,last_updated_by
        ,last_update_date
        ,last_update_login
        ,object_version_number
  ) select
         p_target_obj_def_id
        ,calc_mode_code
        ,transfer_price_object_id
        ,prepay_object_id
        ,filter_object_id
        ,dtl_cashflow_flg
        ,skip_nonzero_trans_rate_flg
        ,skip_nonzero_opt_cost_flg
        ,trans_rate_propagate_flg
        ,trans_rate_calc_flg
        ,trans_rate_migrate_flg
        ,option_cost_propagate_flg
        ,option_cost_calc_flg
        ,option_cost_migrate_flg
        ,write_forward_rate_flg
        ,accrual_code
        ,currency_flg
        ,nvl(p_creation_date,creation_date)
        ,nvl(p_created_by,created_by)
        ,FND_GLOBAL.user_id
        ,sysdate
        ,FND_GLOBAL.login_id
        ,object_version_number
  from ftp_tp_process_rule
  where object_definition_id = p_source_obj_def_id;

Line: 325

  insert into ftp_tp_stoch_assump (
        object_definition_id
        ,rate_index_object_id
        ,num_of_rate_path
        ,rand_seq_type_code
        ,ts_model_code
        ,smoothing_method_code
        ,write_1mn_rate_flg
        ,creation_date
        ,created_by
        ,last_updated_by
        ,last_update_date
        ,last_update_login
        ,object_version_number
        ,valuation_curve_code
  ) select
        p_target_obj_def_id
        ,rate_index_object_id
        ,num_of_rate_path
        ,rand_seq_type_code
        ,ts_model_code
        ,smoothing_method_code
        ,write_1mn_rate_flg
        ,nvl(p_creation_date,creation_date)
        ,nvl(p_created_by,created_by)
        ,FND_GLOBAL.user_id
        ,sysdate
        ,FND_GLOBAL.login_id
        ,object_version_number
        ,valuation_curve_code
  from ftp_tp_stoch_assump
  where object_definition_id = p_source_obj_def_id;

Line: 382

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

Line: 427

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