[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_formula(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_validation_level NUMBER
, p_generate_packages VARCHAR2
, p_calc_formula_id NUMBER
, p_name VARCHAR2
, p_description VARCHAR2
, p_formula_type VARCHAR2
, p_formula_status VARCHAR2
, p_trx_group_code VARCHAR2
, p_number_dim NUMBER
, p_cumulative_flag VARCHAR2
, p_itd_flag VARCHAR2
, p_split_flag VARCHAR2
, p_threshold_all_tier_flag VARCHAR2
, p_modeling_flag VARCHAR2
, p_perf_measure_id NUMBER
, p_output_exp_id NUMBER
, p_f_output_exp_id NUMBER
, p20_a0 JTF_NUMBER_TABLE
, p20_a1 JTF_NUMBER_TABLE
, p20_a2 JTF_NUMBER_TABLE
, p20_a3 JTF_NUMBER_TABLE
, p20_a4 JTF_VARCHAR2_TABLE_100
, p20_a5 JTF_VARCHAR2_TABLE_100
, p20_a6 JTF_VARCHAR2_TABLE_100
, p20_a7 JTF_VARCHAR2_TABLE_100
, p20_a8 JTF_NUMBER_TABLE
, p20_a9 JTF_VARCHAR2_TABLE_100
, p20_a10 JTF_VARCHAR2_TABLE_100
, p21_a0 JTF_NUMBER_TABLE
, p21_a1 JTF_NUMBER_TABLE
, p21_a2 JTF_DATE_TABLE
, p21_a3 JTF_DATE_TABLE
, p21_a4 JTF_VARCHAR2_TABLE_100
, p21_a5 JTF_VARCHAR2_TABLE_100
, p21_a6 JTF_NUMBER_TABLE
, p_org_id NUMBER
, p_object_version_number in out nocopy NUMBER
, x_formula_status out nocopy VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_input_tbl cn_calc_formulas_pvt.input_tbl_type;
cn_calc_formulas_pvt.update_formula(p_api_version,
p_init_msg_list,
p_commit,
p_validation_level,
p_generate_packages,
p_calc_formula_id,
p_name,
p_description,
p_formula_type,
p_formula_status,
p_trx_group_code,
p_number_dim,
p_cumulative_flag,
p_itd_flag,
p_split_flag,
p_threshold_all_tier_flag,
p_modeling_flag,
p_perf_measure_id,
p_output_exp_id,
p_f_output_exp_id,
ddp_input_tbl,
ddp_rt_assign_tbl,
p_org_id,
p_object_version_number,
x_formula_status,
x_return_status,
x_msg_count,
x_msg_data);