[Home] [Help]
PACKAGE: APPS.HXC_FF_DICT
Source
1 Package hxc_ff_dict AUTHID CURRENT_USER as
2 /* $Header: hxcffpkg.pkh 120.1 2005/07/27 13:43:55 gpaytonm noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' hxc_ff_dict'; -- Global package name
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,
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,
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,
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 --
42 function formula(
43 p_formula_id in number
44 , p_resource_id in number
45 , p_submission_date in date
46 , p_ss_timecard_hours in number default null
47 , p_period_start_date in date default null
48 , p_period_end_date in date default null
49 , p_db_pre_period_start in date default null
50 , p_db_pre_period_end in date default null
51 , p_db_post_period_start in date default null
52 , p_db_post_period_end in date default null
53 , p_db_ref_period_start in date default null
54 , p_db_ref_period_end in date default null
55 , p_duration_in_days in number default null
56 , p_param_rec in r_param )
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 );
66
67 FUNCTION execute_approval_formula (
68 p_resource_id NUMBER
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 (
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;