APPS.FTP_BR_ADJUSTMENT_PVT SQL Statements

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

Line: 11

PROCEDURE DeleteAdjustmentRuleRec(
  p_obj_def_id          in          number
);

Line: 15

PROCEDURE DeleteAddOnRateDtlRecs(
  p_obj_def_id          in          number
);

Line: 19

PROCEDURE  DeleteConditionRecs  (
  p_obj_def_id          in          number
);

Line: 47

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
IS

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

Line: 55

  DeleteAdjustmentRuleRec(
    p_obj_def_id    => p_obj_def_id
  );

Line: 59

  DeleteAddOnRateDtlRecs(
    p_obj_def_id    => p_obj_def_id
  );

Line: 63

 DeleteConditionRecs  (
  p_obj_def_id      => p_obj_def_id
 );

Line: 73

END DeleteObjectDefinition;

Line: 129

PROCEDURE DeleteAdjustmentRuleRec(
  p_obj_def_id in number
)
IS
BEGIN

  delete from FTP_ADJUSTMENT_RULE
  where object_definition_id = p_obj_def_id;

Line: 138

END DeleteAdjustmentRuleRec;

Line: 142

PROCEDURE DeleteAddOnRateDtlRecs(
  p_obj_def_id in number
)
IS
BEGIN

  delete from FTP_ADD_ON_RATE_DTL
  where object_definition_id = p_obj_def_id;

Line: 151

END DeleteAddOnRateDtlRecs;

Line: 154

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

END DeleteConditionRecs;

Line: 180

insert into FTP_ADJUSTMENT_RULE (
 object_definition_id,
 line_item_id,
 currency,
 cond_sequence,
 adjustment_type_code,
 calc_method_code,
 reference_term_code,
 lookup_method_code,
 assignment_date_code,
 interest_rate_code,
 break_funding_rate,
 minimum_charge,
 break_funding_amt,
 rate_spread,
 created_by,
 creation_date,
 last_updated_by,
 last_update_date,
 last_update_login,
 object_version_number
  )
  select
 p_target_obj_def_id,
 line_item_id,
 currency,
 cond_sequence,
 adjustment_type_code,
 calc_method_code,
 reference_term_code,
 lookup_method_code,
 assignment_date_code,
 interest_rate_code,
 break_funding_rate,
 minimum_charge,
 break_funding_amt,
 rate_spread,
 nvl(p_created_by,created_by),
 nvl(p_creation_date,creation_date),
 FND_GLOBAL.user_id,
 sysdate,
 FND_GLOBAL.login_id,
 object_version_number

  from FTP_ADJUSTMENT_RULE
  where object_definition_id = p_source_obj_def_id;

Line: 238

insert into FTP_ADD_ON_RATE_DTL (
	add_on_rate_dtl_id,
	object_definition_id,
	line_item_id,
	currency,
	cond_sequence,
	term,
	mult,
	rate,
	amount,
	formula,
	term_point,
	term_multiplier,
	coefficient,
	created_by,
	creation_date,
	last_updated_by,
	last_update_date,
	last_update_login,
	object_version_number
    ) select
	FUN_TRX_TYPES_B_S.nextval,
        p_target_obj_def_id,
	line_item_id,
	currency,
	cond_sequence,
	term,
	mult,
	rate,
	amount,
	formula,
	term_point,
	term_multiplier,
	coefficient,
	nvl(p_created_by,created_by),
	nvl(p_creation_date,creation_date),
	FND_GLOBAL.user_id,
	sysdate,
	FND_GLOBAL.login_id,
	object_version_number
   from FTP_ADD_ON_RATE_DTL
   where object_definition_id = p_source_obj_def_id;

Line: 294

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;