[Home] [Help]
PACKAGE: APPS.PA_GET_RESOURCE
Source
1 PACKAGE PA_GET_RESOURCE AUTHID CURRENT_USER AS
2 /* $Header: PAGTRESS.pls 120.1 2005/08/19 16:33:32 mwasowic noship $*/
3
4 G_include_inactive_res_flag VARCHAR2(1) := 'N';
5
6
7 Procedure Get_Resource_group (p_resource_list_id In Number,
8 p_resource_group In Varchar2,
9 p_resource_list_member_id Out NOCOPY Number, --File.Sql.39 bug 4440895
10 p_resource_id Out NOCOPY Number, --File.Sql.39 bug 4440895
11 p_track_as_labor_flag Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
12 p_err_code Out NOCOPY Number, --File.Sql.39 bug 4440895
13 p_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
14 p_err_stack In Out NOCOPY Varchar2); --File.Sql.39 bug 4440895
15
16 Procedure Get_Resource_list_member (p_resource_list_id In Number,
17 p_resource_name In Varchar2,
18 p_resource_type_Code In Varchar2,
19 p_group_resource_type_id In Number,
20 p_person_id In Number,
21 p_job_id In Number,
22 p_proj_organization_id In Number,
23 p_vendor_id In Number,
24 p_expenditure_type In Varchar2,
25 p_event_type In Varchar2,
26 p_expenditure_category In Varchar2,
27 p_revenue_category_code In Varchar2,
28 p_non_labor_resource In Varchar2,
29 p_system_linkage In Varchar2,
30 p_parent_member_id In Number,
31 p_project_role_id IN NUMBER DEFAULT NULL,
32 p_resource_id Out NOCOPY Number, --File.Sql.39 bug 4440895
33 p_resource_list_member_id Out NOCOPY Number, --File.Sql.39 bug 4440895
34 p_track_as_labor_flag Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
35 p_err_code Out NOCOPY Number, --File.Sql.39 bug 4440895
36 p_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
37 p_err_stack In Out NOCOPY Varchar2); --File.Sql.39 bug 4440895
38
39 Procedure Get_Resource (p_resource_name In Varchar2,
40 p_resource_type_Code In Varchar2,
41 p_person_id In Number,
42 p_job_id In Number,
43 p_proj_organization_id In Number,
44 p_vendor_id In Number,
45 p_expenditure_type In Varchar2,
46 p_event_type In Varchar2,
47 p_expenditure_category In Varchar2,
48 p_revenue_category_code In Varchar2,
49 p_non_labor_resource In Varchar2,
50 p_system_linkage In Varchar2,
51 p_project_role_id IN NUMBER DEFAULT NULL,
52 p_resource_id Out NOCOPY Number, --File.Sql.39 bug 4440895
53 p_err_code Out NOCOPY Number, --File.Sql.39 bug 4440895
54 p_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
55 p_err_stack In Out NOCOPY Varchar2); --File.Sql.39 bug 4440895
56
57 Procedure Get_Resource_Information (p_resource_type_Code In Varchar2,
58 p_resource_attr_value In Varchar2,
59 p_unit_of_measure Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
60 p_Rollup_quantity_flag Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
61 p_track_as_labor_flag Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
62 p_err_code Out NOCOPY Number, --File.Sql.39 bug 4440895
63 p_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
64 p_err_stack In Out NOCOPY Varchar2); --File.Sql.39 bug 4440895
65
66 Procedure Get_Uncateg_Resource_Info (p_resource_list_id Out NOCOPY Number, --File.Sql.39 bug 4440895
67 p_resource_list_member_id Out NOCOPY Number, --File.Sql.39 bug 4440895
68 p_resource_id Out NOCOPY Number, --File.Sql.39 bug 4440895
69 p_track_as_labor_flag Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
70 p_err_code Out NOCOPY Number, --File.Sql.39 bug 4440895
71 p_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
72 p_err_stack In Out NOCOPY Varchar2); --File.Sql.39 bug 4440895
73
74 Procedure Get_Unclassified_Member (p_resource_list_id In Number,
75 p_parent_member_id In Number,
76 p_unclassified_resource_id In Number,
77 p_resource_list_member_id Out NOCOPY Number, --File.Sql.39 bug 4440895
78 p_track_as_labor_flag Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
79 p_err_code Out NOCOPY Number, --File.Sql.39 bug 4440895
80 p_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
81 p_err_stack In Out NOCOPY Varchar2); --File.Sql.39 bug 4440895
82
83 Procedure Get_Unclassified_Resource (p_resource_id Out NOCOPY Number, --File.Sql.39 bug 4440895
84 p_resource_name Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
85 p_track_as_labor_flag Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
86 p_unit_of_measure Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
87 p_rollup_quantity_flag Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
88 p_err_code Out NOCOPY Number, --File.Sql.39 bug 4440895
89 p_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
90 p_err_stack In Out NOCOPY Varchar2); --File.Sql.39 bug 4440895
91
92 FUNCTION Include_Inactive_Resources RETURN VARCHAR2;
93 pragma RESTRICT_REFERENCES ( Include_Inactive_Resources, WNDS, WNPS);
94
95 FUNCTION Child_Resource_exists(p_resource_id in number,
96 p_task_id in number,
97 p_project_id in number)
98 RETURN VARCHAR2;
99 pragma RESTRICT_REFERENCES ( Child_Resource_exists, WNDS, WNPS);
100
101 PROCEDURE Set_Inactive_Resources_Flag (p_Set_Flag IN VARCHAR2);
102 PROCEDURE delete_resource_list_ok(l_resource_list_id IN NUMBER,
103 p_is_plan_res_list IN VARCHAR2 default 'N',
104 x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
105 x_err_stage IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
106 PROCEDURE delete_resource_list_member_ok(l_resource_list_id IN NUMBER,
107 l_resource_list_member_id IN NUMBER,
108 x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
109 x_err_stage IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
110 END PA_GET_RESOURCE;