[Home] [Help]
PACKAGE: APPS.PA_FP_RESOURCE_ASSIGNMENTS_PKG
Source
1 PACKAGE pa_fp_resource_assignments_pkg AUTHID CURRENT_USER as
2 /* $Header: PAFPRATS.pls 120.1 2005/08/19 16:29:20 mwasowic noship $ */
3 -- Start of Comments
4 -- Package name : PA_FP_RESOURCE_ASSIGNMENTS_PKG
5 -- Purpose :
6 -- History :
7 -- 31-OCT-02 rravipat Modified the insert row and update row
8 -- apis to include newly added columns
9 -- for Bug:- 2634900
10 -- NOTE :
11 -- End of Comments
12
13 PROCEDURE Insert_Row
14 ( px_resource_assignment_id IN OUT NOCOPY pa_resource_assignments.resource_assignment_id%TYPE --File.Sql.39 bug 4440895
15 ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
16 := FND_API.G_MISS_NUM
17 ,p_project_id IN pa_resource_assignments.project_id%TYPE
18 := FND_API.G_MISS_NUM
19 ,p_task_id IN pa_resource_assignments.task_id%TYPE
20 := FND_API.G_MISS_NUM
21 ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
22 := FND_API.G_MISS_NUM
23 ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
24 := FND_API.G_MISS_CHAR
25 ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
26 := FND_API.G_MISS_CHAR
27 ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
28 := FND_API.G_MISS_NUM
29 ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
30 := FND_API.G_MISS_NUM
31 ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
32 := FND_API.G_MISS_NUM
33 ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
34 := FND_API.G_MISS_NUM
35 ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
36 := FND_API.G_MISS_CHAR
37 ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
38 := FND_API.G_MISS_NUM
39 ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
40 := FND_API.G_MISS_NUM
41 ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
42 := FND_API.G_MISS_NUM
43 ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
44 := FND_API.G_MISS_NUM
45 ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
46 := FND_API.G_MISS_NUM
47 ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
48 := FND_API.G_MISS_NUM
49 ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
50 := FND_API.G_MISS_NUM
51 ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
52 := FND_API.G_MISS_NUM
53 ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
54 := FND_API.G_MISS_NUM
55 ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
56 := FND_API.G_MISS_NUM
57 ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
58 := FND_API.G_MISS_NUM
59 ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
60 := FND_API.G_MISS_NUM
61 ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
62 := FND_API.G_MISS_NUM
63 ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
64 := FND_API.G_MISS_NUM
65 ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
66 := FND_API.G_MISS_NUM
67 ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
68 := FND_API.G_MISS_NUM
69 ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
70 := FND_API.G_MISS_NUM
71 ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
72 := FND_API.G_MISS_NUM
73 ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
74 := FND_API.G_MISS_NUM
75 ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
76 := FND_API.G_MISS_NUM
77 ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
78 := FND_API.G_MISS_CHAR
79 -- start of changes of Bug:- 2634900
80 ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
81 := FND_API.G_MISS_NUM
82 ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
83 := FND_API.G_MISS_NUM
84 ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
85 := FND_API.G_MISS_NUM
86 ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
87 := FND_API.G_MISS_NUM
88 -- end of changes of Bug :- 2634900
89 ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
90 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
91
92 PROCEDURE Update_Row
93 ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
94 := FND_API.G_MISS_NUM
95 ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
96 := FND_API.G_MISS_NUM
97 ,p_project_id IN pa_resource_assignments.project_id%TYPE
98 := FND_API.G_MISS_NUM
99 ,p_task_id IN pa_resource_assignments.task_id%TYPE
100 := FND_API.G_MISS_NUM
101 ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
102 := FND_API.G_MISS_NUM
103 ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
104 := FND_API.G_MISS_CHAR
105 ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
106 := FND_API.G_MISS_CHAR
107 ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
108 := FND_API.G_MISS_NUM
109 ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
110 := FND_API.G_MISS_NUM
111 ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
112 := FND_API.G_MISS_NUM
113 ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
114 := FND_API.G_MISS_NUM
115 ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
116 := FND_API.G_MISS_CHAR
117 ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
118 := FND_API.G_MISS_NUM
119 ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
120 := FND_API.G_MISS_NUM
121 ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
122 := FND_API.G_MISS_NUM
123 ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
124 := FND_API.G_MISS_NUM
125 ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
126 := FND_API.G_MISS_NUM
127 ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
128 := FND_API.G_MISS_NUM
129 ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
130 := FND_API.G_MISS_NUM
131 ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
132 := FND_API.G_MISS_NUM
133 ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
134 := FND_API.G_MISS_NUM
135 ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
136 := FND_API.G_MISS_NUM
137 ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
138 := FND_API.G_MISS_NUM
139 ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
140 := FND_API.G_MISS_NUM
141 ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
142 := FND_API.G_MISS_NUM
143 ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
144 := FND_API.G_MISS_NUM
145 ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
146 := FND_API.G_MISS_NUM
147 ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
148 := FND_API.G_MISS_NUM
149 ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
150 := FND_API.G_MISS_NUM
151 ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
152 := FND_API.G_MISS_NUM
153 ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
154 := FND_API.G_MISS_NUM
155 ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
156 := FND_API.G_MISS_NUM
157 ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
158 := FND_API.G_MISS_CHAR
159 -- start of changes of Bug:- 2634900
160 ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
161 := FND_API.G_MISS_NUM
162 ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
163 := FND_API.G_MISS_NUM
164 ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
165 := FND_API.G_MISS_NUM
166 ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
167 := FND_API.G_MISS_NUM
168 -- end of changes of Bug:- 2634900
169 ,p_row_id IN ROWID
170 := NULL
171 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
172
173 PROCEDURE Lock_Row
174 ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
175 := FND_API.G_MISS_NUM
176 ,p_row_id IN ROWID
177 := NULL
178 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
179
180 PROCEDURE Delete_Row
181 ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
182 := FND_API.G_MISS_NUM
183 ,p_row_id IN ROWID
184 := NULL
185 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
186
187 END pa_fp_resource_assignments_pkg;