[Home] [Help]
PACKAGE: APPS.PA_FP_FIN_PLAN_ADJ_LINES_PKG
Source
1 PACKAGE pa_fp_fin_plan_adj_lines_pkg AUTHID CURRENT_USER AS
2 /* $Header: PAFPALTS.pls 120.1 2005/08/19 16:24:02 mwasowic noship $ */
3 -- Start of Comments
4 -- Package name : PA_FP_FIN_PLAN_ADJ_LINES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row
11 (px_fin_plan_adj_line_id IN OUT NOCOPY pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE --File.Sql.39 bug 4440895
12 ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
13 := FND_API.G_MISS_NUM
14 ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
15 := FND_API.G_MISS_NUM
16 ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE
17 := FND_API.G_MISS_NUM
18 ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE
19 := FND_API.G_MISS_NUM
20 ,p_resource_assignment_id IN
21 pa_fin_plan_adj_lines.resource_assignment_id%TYPE
22 := FND_API.G_MISS_NUM
23 ,p_period_name IN
24 pa_fin_plan_adj_lines.period_name%TYPE
25 := FND_API.G_MISS_CHAR
26 ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
27 := FND_API.G_MISS_DATE
28 ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE
29 := FND_API.G_MISS_DATE
30 ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE
31 := FND_API.G_MISS_NUM
32 ,p_burdened_cost_adjustment IN
33 pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE
34 := FND_API.G_MISS_NUM
35 ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE
36 := FND_API.G_MISS_NUM
37 ,p_utilization_adjustment IN
38 pa_fin_plan_adj_lines.utilization_adjustment%TYPE
39 := FND_API.G_MISS_NUM
40 ,p_head_count_adjustment IN pa_fin_plan_adj_lines.head_count_adjustment%TYPE
41 := FND_API.G_MISS_NUM
42 ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
43 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
44
45 PROCEDURE Update_Row
46 ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE
47 := FND_API.G_MISS_NUM
48 ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
49 := FND_API.G_MISS_NUM
50 ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
51 := FND_API.G_MISS_NUM
52 ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE
53 := FND_API.G_MISS_NUM
54 ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE
55 := FND_API.G_MISS_NUM
56 ,p_resource_assignment_id IN
57 pa_fin_plan_adj_lines.resource_assignment_id%TYPE
58 := FND_API.G_MISS_NUM
59 ,p_period_name IN
60 pa_fin_plan_adj_lines.period_name%TYPE
61 := FND_API.G_MISS_CHAR
62 ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
63 := FND_API.G_MISS_DATE
64 ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE
65 := FND_API.G_MISS_DATE
66 ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE
67 := FND_API.G_MISS_NUM
68 ,p_burdened_cost_adjustment IN
69 pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE
70 := FND_API.G_MISS_NUM
71 ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE
72 := FND_API.G_MISS_NUM
73 ,p_utilization_adjustment IN
74 pa_fin_plan_adj_lines.utilization_adjustment%TYPE
75 := FND_API.G_MISS_NUM
76 ,p_head_count_adjustment IN pa_fin_plan_adj_lines.head_count_adjustment%TYPE
77 := FND_API.G_MISS_NUM
78 ,p_row_id IN ROWID
79 := NULL
80 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
81
82 PROCEDURE Lock_Row
83 ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE
84 := FND_API.G_MISS_NUM
85 ,p_row_id IN ROWID
86 := NULL
87 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
88
89 PROCEDURE Delete_Row
90 ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE
91 ,p_row_id IN ROWID
92 := NULL
93 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
94 END pa_fp_fin_plan_adj_lines_pkg;