[Home] [Help]
29: -- := FND_API.G_MISS_CHAR,
30: payment_amount cn_quotas.payment_amount%TYPE := fnd_api.g_miss_num,
31: calc_formula_id cn_quotas.calc_formula_id%TYPE := NULL,
32: quota_rule_id cn_quota_rules.quota_rule_id%TYPE := NULL,
33: calc_formula_name cn_calc_formulas.NAME%TYPE := NULL,
34: incentive_type_code cn_quotas.incentive_type_code%TYPE := fnd_api.g_miss_char,
35: credit_type cn_credit_types.NAME%TYPE := fnd_api.g_miss_char,
36: credit_type_id cn_credit_types.credit_type_id%TYPE := NULL,
37: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := fnd_api.g_miss_char,
39: -- quota_unspecified cn_quotas.quota_unspecified%TYPE
40: -- := NULL,
41: package_name cn_quotas.package_name%TYPE := NULL,
42: split_flag cn_quotas.split_flag%TYPE := fnd_api.g_miss_char,
43: itd_flag cn_calc_formulas.itd_flag%TYPE := fnd_api.g_miss_char,
44: cumulative_flag cn_quotas.cumulative_flag%TYPE := NULL,
45: rate_table_id cn_rate_schedules.rate_schedule_id%TYPE := NULL,
46: rate_table_name cn_rate_schedules.NAME%TYPE := fnd_api.g_miss_char,
47: disc_rate_table_id cn_rate_schedules.rate_schedule_id%TYPE := NULL,
268: --| ---------------------------------------------------------------------+
269: FUNCTION get_calc_formula_name (
270: p_calc_formula_id NUMBER
271: )
272: RETURN cn_calc_formulas.NAME%TYPE;
273:
274: PRAGMA RESTRICT_REFERENCES (get_calc_formula_name, WNDS, WNPS);
275:
276: --| -----------------------------------------------------------------------+
280: FUNCTION get_calc_formula_id (
281: p_calc_formula_name VARCHAR2,
282: p_org_id NUMBER
283: )
284: RETURN cn_calc_formulas.calc_formula_id%TYPE;
285:
286: PRAGMA RESTRICT_REFERENCES (get_calc_formula_id, WNDS, WNPS);
287:
288: --| -----------------------------------------------------------------------+