PACKAGE: APPS.WIP_PREFERENCES_PKG

Source

1 PACKAGE WIP_PREFERENCES_PKG AS
2 /* $Header: wipprefs.pls 120.0 2005/06/24 16:41 jezheng noship $ */
3 
4 --
5 -- This function returns attribute_code from wip_preference_values
6 -- for single value preferences based on resp_key, org_id, dept_id.
7 -- For multiple value preferences, it returns "ENTERED" or "INHERIT" based on setup.
8 --
9 function get_preference_value_code
10 (p_preference_id number,
11  p_resp_key varchar2 default null,
12  p_org_id number default null,
13  p_dept_id number default null) return varchar2;
14 
15 --
16 -- This function returns attribute_value based on attribute_code.
17 --
18 function get_preference_value
19 (p_preference_id number,
20  p_resp_key varchar2 default null,
21  p_org_id number default null,
22  p_dept_id number default null) return varchar2;
23 
24 --
25 -- Return the number of preference setups at specified level
26 --
27 function get_row_count
28 (p_pref_id number,
29 p_level_code number,
30 p_resp_key varchar2,
31 p_org_id number,
32 p_dept_id number)  return number;
33 
34 --
35 -- The function calculates the result preference value
36 --
37 function get_result_value_code
38 (p_preference_id number,
39  p_resp_key varchar2 default null,
40  p_org_id number default null,
41  p_dept_id number default null) return varchar2;
42 
43 --
44 -- The function calculates the result preference value
45 --
46 function get_result_value
47 (p_preference_id number,
48  p_resp_key varchar2 default null,
49  p_org_id number default null,
50  p_dept_id number default null) return varchar2;
51 
52 --
53 -- The function returns the inherit flag for a preference at specified level
54 --
55 function get_inherit_flag_value
56 (p_level_id number,
57  p_level_code number) return number;
58 
59 --
60 -- The function calculates the preference level_id based on given resp_key,
61 -- org_id and dept_id
62 --
63 function get_preference_level_id
64 (p_preference_id number,
65  p_resp_key varchar2,
66  p_organization_id number,
67  p_department_id number) return number;
68 
69 function get_level (p_level_code number) return varchar2;
70 function get_responsibility (p_resp_key varchar2) return varchar2;
71 function get_organization (p_org_id number) return varchar2;
72 function get_department (p_dept_id number) return varchar2;
73 
74 END WIP_PREFERENCES_PKG;