1 PACKAGE PA_Resources_Pkg AS
2 /* $Header: PARESOTS.pls 120.1 2005/08/19 16:50:56 mwasowic noship $ */
3 -- Standard Table Handler procedures for PA_RESOURCES table
4 PROCEDURE Insert_row (
5 X_Row_Id IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6 X_RESOURCE_ID IN NUMBER,
7 X_NAME IN VARCHAR2,
8 X_DESCRIPTION IN VARCHAR2,
9 X_RESOURCE_TYPE_ID IN NUMBER,
10 X_UNIT_OF_MEASURE IN VARCHAR2,
11 X_ROLLUP_QUANTITY_FLAG IN VARCHAR2,
12 X_START_DATE_ACTIVE IN DATE,
13 X_END_DATE_ACTIVE IN DATE,
14 X_TRACK_AS_LABOR_FLAG IN VARCHAR2,
15 X_LAST_UPDATE_DATE IN DATE,
16 X_LAST_UPDATED_BY IN NUMBER,
17 X_CREATION_DATE IN DATE,
18 X_CREATED_BY IN NUMBER,
19 X_LAST_UPDATE_LOGIN IN NUMBER,
20 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
21 X_ATTRIBUTE1 IN VARCHAR2);
22 Procedure Update_Row (
23 X_Row_Id IN VARCHAR2,
24 X_RESOURCE_ID IN NUMBER,
25 X_NAME IN VARCHAR2,
26 X_DESCRIPTION IN VARCHAR2,
27 X_RESOURCE_TYPE_ID IN NUMBER,
28 X_UNIT_OF_MEASURE IN VARCHAR2,
29 X_ROLLUP_QUANTITY_FLAG IN VARCHAR2,
30 X_START_DATE_ACTIVE IN DATE,
31 X_END_DATE_ACTIVE IN DATE,
32 X_TRACK_AS_LABOR_FLAG IN VARCHAR2,
33 X_LAST_UPDATE_DATE IN DATE,
34 X_LAST_UPDATED_BY IN NUMBER,
35 X_LAST_UPDATE_LOGIN IN NUMBER,
36 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
37 X_ATTRIBUTE1 IN VARCHAR2);
38 Procedure Lock_Row (
39 X_Row_Id IN VARCHAR2,
40 X_RESOURCE_ID IN NUMBER,
41 X_NAME IN VARCHAR2,
42 X_DESCRIPTION IN VARCHAR2,
43 X_RESOURCE_TYPE_ID IN NUMBER,
44 X_UNIT_OF_MEASURE IN VARCHAR2,
45 X_ROLLUP_QUANTITY_FLAG IN VARCHAR2,
46 X_START_DATE_ACTIVE IN DATE,
47 X_END_DATE_ACTIVE IN DATE,
48 X_TRACK_AS_LABOR_FLAG IN VARCHAR2,
49 X_LAST_UPDATE_DATE IN DATE,
50 X_LAST_UPDATED_BY IN NUMBER,
51 X_LAST_UPDATE_LOGIN IN NUMBER,
52 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
53 X_ATTRIBUTE1 IN VARCHAR2);
54 Procedure Delete_Row (X_Row_Id In Varchar2);
55
56 /* Added function get_resource_name for bug 1299456 */
57 Function Get_Resource_Name( P_Resource_Id IN NUMBER,
58 P_resource_type_id IN NUMBER) RETURN VARCHAR2;
59
60 pragma RESTRICT_REFERENCES (Get_Resource_Name, WNDS, WNPS);
61
62 Function Get_Resource_List_Member_Name(p_resource_list_member_Id IN pa_resource_list_members.resource_list_member_id%TYPE) RETURN VARCHAR2;
63 --pragma RESTRICT_REFERENCES (Get_Resource_List_Member_Name, WNDS, WNPS);
64
65 END PA_RESOURCES_Pkg;