[Home] [Help]
PACKAGE: APPS.IGW_BUDGET_DETAILS_PVT
Source
1 PACKAGE IGW_BUDGET_DETAILS_PVT as
2 --$Header: igwvbdts.pls 120.3 2005/10/30 05:50:37 appldev ship $
3 G_package_name VARCHAR2(30) := 'IGW_BUDGET_DETAILS_PVT';
4 -----------------------------------------------------------------------------------------
5 function get_personnel_attached_flag(p_expenditure_type IN VARCHAR2
6 ,p_expenditure_category_flag IN VARCHAR2) return varchar2;
7
8 -----------------------------------------------------------------------------------------
9 function get_budget_justification(p_line_item_id NUMBER) RETURN VARCHAR2;
10 ------------------------------------------------------------------------------------------
11 procedure create_budget_line
12 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
13 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
14 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
15 ,p_proposal_id NUMBER
16 ,p_version_id NUMBER
17 ,p_budget_period_id NUMBER
18 ,p_line_item_id NUMBER := NULL
19 ,p_expenditure_type VARCHAR2
20 ,p_expenditure_category_flag VARCHAR2
21 ,p_budget_category_code VARCHAR2
22 ,p_budget_category VARCHAR2
23 ,p_line_item_description VARCHAR2
24 ,p_based_on_line_item NUMBER := NULL
25 ,p_line_item_cost NUMBER := 0
26 ,p_cost_sharing_amount NUMBER := 0
27 ,p_underrecovery_amount NUMBER := 0
28 ,p_apply_inflation_flag VARCHAR2
29 ,p_budget_justification LONG
30 ,p_location_code VARCHAR2
31 ,p_location VARCHAR2
32 ,p_project_id NUMBER :=NULL
33 ,p_project_number VARCHAR2
34 ,p_task_id NUMBER :=NULL
35 ,p_task_number VARCHAR2
36 ,p_award_id NUMBER :=NULL
37 ,p_award_number VARCHAR2
38 ,x_line_item_id OUT NOCOPY NUMBER
39 ,x_rowid OUT NOCOPY ROWID
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2);
43
44
45 ----------------------------------------------------------------------
46 procedure update_budget_line
47 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
48 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
49 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
50 ,p_proposal_id NUMBER := NULL
51 ,p_version_id NUMBER := NULL
52 ,p_budget_period_id NUMBER := NULL
53 ,p_line_item_id NUMBER
54 ,p_expenditure_type VARCHAR2
55 ,p_expenditure_category_flag VARCHAR2
56 ,p_budget_category_code VARCHAR2
57 ,p_budget_category VARCHAR2
58 ,p_line_item_description VARCHAR2
59 ,p_based_on_line_item NUMBER := NULL
60 ,p_line_item_cost NUMBER
61 ,p_cost_sharing_amount NUMBER
62 ,p_underrecovery_amount NUMBER := 0
63 ,p_apply_inflation_flag VARCHAR2
64 ,p_budget_justification LONG
65 ,p_location_code VARCHAR2
66 ,p_location VARCHAR2
67 ,p_project_id NUMBER
68 ,p_project_number VARCHAR2
69 ,p_task_id NUMBER
70 ,p_task_number VARCHAR2
71 ,p_award_id NUMBER
72 ,p_award_number VARCHAR2
73 ,p_record_version_number IN NUMBER
74 ,p_rowid IN ROWID
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 ,x_msg_data OUT NOCOPY VARCHAR2);
78
79 -----------------------------------------------------------------------
80
81 procedure delete_budget_line
82 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
83 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
84 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
85 ,p_proposal_id IN NUMBER := NULL
86 ,p_version_id IN NUMBER := NULL
87 ,p_budget_period_id NUMBER := NULL
88 ,p_line_item_id NUMBER
89 ,p_record_version_number IN NUMBER
90 ,p_rowid IN ROWID
91 ,x_return_status OUT NOCOPY VARCHAR2
92 ,x_msg_count OUT NOCOPY NUMBER
93 ,x_msg_data OUT NOCOPY VARCHAR2);
94
95
96 END;