9: --
10: -- ----------------------------------------------------------------------------
11:
12: TYPE r_param IS RECORD (
13: param1_value hxc_time_entry_rules.attribute1%TYPE,
14: param1 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
15: param2_value hxc_time_entry_rules.attribute1%TYPE,
16: param2 fnd_descr_flex_column_usages.end_user_column_name%TYPE, param3_value hxc_time_entry_rules.attribute1%TYPE,
17: param3 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
11:
12: TYPE r_param IS RECORD (
13: param1_value hxc_time_entry_rules.attribute1%TYPE,
14: param1 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
15: param2_value hxc_time_entry_rules.attribute1%TYPE,
16: param2 fnd_descr_flex_column_usages.end_user_column_name%TYPE, param3_value hxc_time_entry_rules.attribute1%TYPE,
17: param3 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
18: param4_value hxc_time_entry_rules.attribute1%TYPE, param4 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
19: param5_value hxc_time_entry_rules.attribute1%TYPE,
12: TYPE r_param IS RECORD (
13: param1_value hxc_time_entry_rules.attribute1%TYPE,
14: param1 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
15: param2_value hxc_time_entry_rules.attribute1%TYPE,
16: param2 fnd_descr_flex_column_usages.end_user_column_name%TYPE, param3_value hxc_time_entry_rules.attribute1%TYPE,
17: param3 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
18: param4_value hxc_time_entry_rules.attribute1%TYPE, param4 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
19: param5_value hxc_time_entry_rules.attribute1%TYPE,
20: param5 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
14: param1 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
15: param2_value hxc_time_entry_rules.attribute1%TYPE,
16: param2 fnd_descr_flex_column_usages.end_user_column_name%TYPE, param3_value hxc_time_entry_rules.attribute1%TYPE,
17: param3 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
18: param4_value hxc_time_entry_rules.attribute1%TYPE, param4 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
19: param5_value hxc_time_entry_rules.attribute1%TYPE,
20: param5 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
21: param6_value hxc_time_entry_rules.attribute1%TYPE,
22: param6 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
15: param2_value hxc_time_entry_rules.attribute1%TYPE,
16: param2 fnd_descr_flex_column_usages.end_user_column_name%TYPE, param3_value hxc_time_entry_rules.attribute1%TYPE,
17: param3 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
18: param4_value hxc_time_entry_rules.attribute1%TYPE, param4 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
19: param5_value hxc_time_entry_rules.attribute1%TYPE,
20: param5 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
21: param6_value hxc_time_entry_rules.attribute1%TYPE,
22: param6 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
23: param7_value hxc_time_entry_rules.attribute1%TYPE,
17: param3 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
18: param4_value hxc_time_entry_rules.attribute1%TYPE, param4 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
19: param5_value hxc_time_entry_rules.attribute1%TYPE,
20: param5 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
21: param6_value hxc_time_entry_rules.attribute1%TYPE,
22: param6 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
23: param7_value hxc_time_entry_rules.attribute1%TYPE,
24: param7 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
25: param8_value hxc_time_entry_rules.attribute1%TYPE,
19: param5_value hxc_time_entry_rules.attribute1%TYPE,
20: param5 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
21: param6_value hxc_time_entry_rules.attribute1%TYPE,
22: param6 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
23: param7_value hxc_time_entry_rules.attribute1%TYPE,
24: param7 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
25: param8_value hxc_time_entry_rules.attribute1%TYPE,
26: param8 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
27: param9_value hxc_time_entry_rules.attribute1%TYPE,
21: param6_value hxc_time_entry_rules.attribute1%TYPE,
22: param6 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
23: param7_value hxc_time_entry_rules.attribute1%TYPE,
24: param7 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
25: param8_value hxc_time_entry_rules.attribute1%TYPE,
26: param8 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
27: param9_value hxc_time_entry_rules.attribute1%TYPE,
28: param9 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
29: param10_value hxc_time_entry_rules.attribute1%TYPE,
23: param7_value hxc_time_entry_rules.attribute1%TYPE,
24: param7 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
25: param8_value hxc_time_entry_rules.attribute1%TYPE,
26: param8 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
27: param9_value hxc_time_entry_rules.attribute1%TYPE,
28: param9 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
29: param10_value hxc_time_entry_rules.attribute1%TYPE,
30: param10 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
31: param11_value hxc_time_entry_rules.attribute1%TYPE,
25: param8_value hxc_time_entry_rules.attribute1%TYPE,
26: param8 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
27: param9_value hxc_time_entry_rules.attribute1%TYPE,
28: param9 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
29: param10_value hxc_time_entry_rules.attribute1%TYPE,
30: param10 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
31: param11_value hxc_time_entry_rules.attribute1%TYPE,
32: param11 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
33: param12_value hxc_time_entry_rules.attribute1%TYPE,
27: param9_value hxc_time_entry_rules.attribute1%TYPE,
28: param9 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
29: param10_value hxc_time_entry_rules.attribute1%TYPE,
30: param10 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
31: param11_value hxc_time_entry_rules.attribute1%TYPE,
32: param11 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
33: param12_value hxc_time_entry_rules.attribute1%TYPE,
34: param12 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
35: param13_value hxc_time_entry_rules.attribute1%TYPE,
29: param10_value hxc_time_entry_rules.attribute1%TYPE,
30: param10 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
31: param11_value hxc_time_entry_rules.attribute1%TYPE,
32: param11 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
33: param12_value hxc_time_entry_rules.attribute1%TYPE,
34: param12 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
35: param13_value hxc_time_entry_rules.attribute1%TYPE,
36: param13 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
37: param14_value hxc_time_entry_rules.attribute1%TYPE,
31: param11_value hxc_time_entry_rules.attribute1%TYPE,
32: param11 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
33: param12_value hxc_time_entry_rules.attribute1%TYPE,
34: param12 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
35: param13_value hxc_time_entry_rules.attribute1%TYPE,
36: param13 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
37: param14_value hxc_time_entry_rules.attribute1%TYPE,
38: param14 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
39: param15_value hxc_time_entry_rules.attribute1%TYPE,
33: param12_value hxc_time_entry_rules.attribute1%TYPE,
34: param12 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
35: param13_value hxc_time_entry_rules.attribute1%TYPE,
36: param13 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
37: param14_value hxc_time_entry_rules.attribute1%TYPE,
38: param14 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
39: param15_value hxc_time_entry_rules.attribute1%TYPE,
40: param15 fnd_descr_flex_column_usages.end_user_column_name%TYPE );
41: --
35: param13_value hxc_time_entry_rules.attribute1%TYPE,
36: param13 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
37: param14_value hxc_time_entry_rules.attribute1%TYPE,
38: param14 fnd_descr_flex_column_usages.end_user_column_name%TYPE,
39: param15_value hxc_time_entry_rules.attribute1%TYPE,
40: param15 fnd_descr_flex_column_usages.end_user_column_name%TYPE );
41: --
42: function formula(
43: p_formula_id in number
57: return ff_exec.outputs_t;
58:
59: PROCEDURE decode_formula_segments (
60: p_formula_name VARCHAR2
61: , p_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype
62: , p_param_rec IN OUT NOCOPY r_param
63: , p_period_value IN OUT NOCOPY NUMBER
64: , p_reference_value IN OUT NOCOPY NUMBER
65: , p_consider_zero_hours IN OUT NOCOPY VARCHAR2 );
69: , p_period_start_date DATE
70: , p_period_end_date DATE
71: , p_tc_period_start_date DATE
72: , p_tc_period_end_date DATE
73: , p_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype
74: , p_message_table IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE )
75: RETURN varchar2;
76:
77: FUNCTION get_formula_segment_value (
75: RETURN varchar2;
76:
77: FUNCTION get_formula_segment_value (
78: p_param_rec r_param
79: , p_param fnd_descr_flex_column_usages.end_user_column_name%TYPE ) RETURN hxc_time_entry_rules.attribute1%TYPE;
80:
81: end hxc_ff_dict;