1 PACKAGE PA_ALLOC_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PAXALUTS.pls 120.1 2005/08/10 13:45:05 dlanka noship $ */
3
4 ------------------------------------------------------------------------
8 FUNCTION is_resource_in_rules(p_resource_list_member_id IN NUMBER)
5 --- is_resource_in_alloc_rules
6 -----This function returns 'Y' if a resource list member is used in allocations
7 ------------------------------------------------------------------------
9 RETURN varchar2 ;
10 PRAGMA RESTRICT_REFERENCES(is_resource_in_rules, WNDS, WNPS) ;
11
12 ------------------------------------------------------------------------
13 --- is_resource_list_in_alloc_rules
14 ---- This function returns 'Y' if a resouce list is used in allocations
15 ------------------------------------------------------------------------
16 FUNCTION is_resource_list_in_rules(p_resource_list_id IN NUMBER)
17 RETURN varchar2 ;
18 PRAGMA RESTRICT_REFERENCES(is_resource_list_in_rules, WNDS, WNPS) ;
19
20 ------------------------------------------------------------------------
21 --- is_project_in_allocations
22 ---- This function returns 'Y' if a project is used in allocations
23 ------------------------------------------------------------------------
24 FUNCTION is_project_in_allocations(p_project_id IN NUMBER)
25 RETURN varchar2 ;
26 PRAGMA RESTRICT_REFERENCES(is_project_in_allocations, WNDS, WNPS) ;
27
28 ------------------------------------------------------------------------
29 --- is_task_in_allocations
30 ---- This function returns 'Y' if a task is used in allocations
31 ------------------------------------------------------------------------
32 FUNCTION is_task_in_allocations(p_task_id IN NUMBER)
33 RETURN varchar2 ;
34 PRAGMA RESTRICT_REFERENCES(is_task_in_allocations, WNDS, WNPS) ;
35
36 ------------------------------------------------------------------------
37 --- is_task_lowest_in_allocations
38 --- This function returns 'Y' if a task is used as target or offset, or if
39 ---- a task is a non top level task and used as source in allocations
40 ------------------------------------------------------------------------
41 FUNCTION is_task_lowest_in_allocations(p_task_id IN NUMBER) RETURN varchar2;
42 PRAGMA RESTRICT_REFERENCES(is_task_lowest_in_allocations, WNDS, WNPS) ;
43
44
45 ------------------------------------------------------------------------
46 --- Is_Budget_Type_In_allocations
47 ---- This function returns 'Y' if a budget_type is used in allocations
48 ------------------------------------------------------------------------
49 FUNCTION Is_Budget_Type_In_allocations(p_budget_type_code IN varchar2)
50 RETURN varchar2 ;
51 PRAGMA RESTRICT_REFERENCES(Is_Budget_Type_In_allocations, WNDS, WNPS) ;
52
53 /*------------------------------------------------------------------------
54 --- Is_Bem_In_allocations
55 ---- This function returns 'Y' if a budget entry method is used in allocations
56 ------------------------------------------------------------------------
57 FUNCTION Is_Bem_In_allocations(p_bem_code IN varchar2)
58 RETURN varchar2 ;
59 PRAGMA RESTRICT_REFERENCES(Is_Bem_In_allocations, WNDS, WNPS) ;*/
60
61
62 /*
63 API Name : Is_RBS_In_Rules
64 API Desc : Return 'Y' if RBS is used in Allocations.
65 API Created Date : 19-Mar-04
66 API Created By : Vthakkar
67 */
68
69 FUNCTION Is_RBS_In_Rules ( P_RBS_ID IN pa_rbs_headers_v.RBS_HEADER_ID%Type ) RETURN VARCHAR2;
70
71 /*
72 API Name : Is_RBS_In_Rules
73 API Desc : Return 'Y' if RBS Element is used in Allocations.
74 API Created Date : 19-Mar-04
75 API Created By : Vthakkar
76 */
77
78 FUNCTION Is_RBS_Element_In_Rules ( P_RBS_ELEMENT_ID IN pa_rbs_elements.RBS_ELEMENT_ID%type ) RETURN VARCHAR2;
79
80 /*
81 API Name : Resource_Name
82 API Desc : This function will be return the name of the resource id depending upon the Allocation Type and
83 If Resource ID is member of Resource List or RBS Structure.
84 API Created Date : 19-Mar-04
85 API Created By : Vthakkar
86 */
87
88 Function Resource_Name (
89 p_alloc_type IN Varchar2 ,
90 p_resource_id IN pa_rbs_elements.RBS_ELEMENT_ID%type ,
91 p_rule_id IN pa_alloc_rules.rule_id%type
92 ) Return Varchar2;
93
94 /*
95 API Name : ASSOCIATE_RBS_TO_ALLOC_RULE
96 API Desc : This procedure will be update the new element id to the allocation rules's source resource list member's id
97 and basis resource list member's id when new version of RBS is created
98 API Created Date : 02-Apr-04
99 API Created By : Vthakkar
100 */
101
102 Procedure ASSOCIATE_RBS_TO_ALLOC_RULE (
103 p_rbs_header_id IN NUMBER ,
104 p_rbs_version_id IN NUMBER ,
105 x_return_status OUT NOCOPY VARCHAR2 ,
106 x_error_code OUT NOCOPY VARCHAR2
107 );
108
109 /*
110 API Name : RESOURCE_LIST_NAME
111 API Desc : This function will return name of Resource List or Resource Breakdown Structure Header Name depending Upon
112 Rule contains Resource List or Resource Structure.
113 API Created Date : 06-Apr-04
114 API Created By : Vthakkar
115 */
116
117 Function RESOURCE_LIST_NAME (
118 p_resource_list_id In Number ,
119 p_resource_struct_type in Varchar2
120 ) Return Varchar2;
121
122 /*
123 API Name : GET_CONCATENATED_NAME
124 API Desc : This function will return name of Resource List Member attached with parent member name like e.g self.parent
125 API Created Date : 03-May-04
126 API Created By : Vthakkar
127 */
128 Function GET_CONCATENATED_NAME (p_resource_id in Number , p_struct_type in Varchar2 ) Return
129 Varchar2 ;
130
131 /*
135 API Created By : Vthakkar
132 API Name : Get_Rbs_Version_Name
133 API Desc : This function will return name of RBS Version Name provided rbs_version_id
134 API Created Date : 11-May-2004
136 */
137
138 Function Get_Rbs_Version_Name (p_rbs_ver_id in Number) Return Varchar2;
139
140 /*
141 API Name : Get_Resource_Name_TL
142 API Desc : This function will return name of RBS Name translated in the respective language
143 API Created Date : 13-May-2004
144 API Created By : Vthakkar
145 */
146
147 Function Get_Resource_Name_TL ( p_rbs_element_name_id in Number ) Return Varchar2;
148
149 END PA_ALLOC_UTILS ;