[Home] [Help]
PACKAGE BODY: APPS.IGW_BUDGET_DETAILS_PVT
Source
1 PACKAGE BODY IGW_BUDGET_DETAILS_PVT AS
2 --$Header: igwvbdtb.pls 120.4 2006/02/22 23:21:56 dsadhukh ship $
3 PROCEDURE VALIDATE_EXPENDITURE_TYPE
4 (p_expenditure_type_category IN VARCHAR2
5 ,x_expenditure_type_category OUT NOCOPY VARCHAR2
6 ,x_expenditure_category_flag OUT NOCOPY VARCHAR2
7 ,x_budget_category_code OUT NOCOPY VARCHAR2
8 ,x_return_status OUT NOCOPY VARCHAR2
9 ,x_error_msg_code OUT NOCOPY VARCHAR2) is
10
11
12 BEGIN
13 null;
14 END; --VALIDATE_EXPENDITURE_TYPE
15
16 --------------------------------------------------------------------------------------------
17 Procedure validate_expenditure_level(
18 p_proposal_id VARCHAR2
19 ,p_version_id VARCHAR2
20 ,p_budget_period_id VARCHAR2
21 ,p_expenditure_type VARCHAR2
22 ,p_expenditure_category_flag VARCHAR2
23 ,p_line_item_id NUMBER
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_error_msg_code OUT NOCOPY VARCHAR2) is
26
27 Begin
28 null;
29 End validate_expenditure_level;
30
31 --------------------------------------------------------------------------------------------
32 function get_personnel_attached_flag(p_expenditure_type IN VARCHAR2
33 ,p_expenditure_category_flag IN VARCHAR2) RETURN VARCHAR2 IS
34 begin
35 RETURN null;
36 end;
37 -----------------------------------------------------------------------------------------
38 function get_budget_justification(p_line_item_id NUMBER) RETURN VARCHAR2 is
39 begin
40 RETURN null;
41 end;
42 -----------------------------------------------------------------------------------------
43 procedure create_budget_line
44 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
45 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
46 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
47 ,p_proposal_id NUMBER
48 ,p_version_id NUMBER
49 ,p_budget_period_id NUMBER
50 ,p_line_item_id NUMBER := NULL
51 ,p_expenditure_type VARCHAR2
52 ,p_expenditure_category_flag VARCHAR2
53 ,p_budget_category_code VARCHAR2
54 ,p_budget_category VARCHAR2
55 ,p_line_item_description VARCHAR2
56 ,p_based_on_line_item NUMBER := NULL
57 ,p_line_item_cost NUMBER := 0
58 ,p_cost_sharing_amount NUMBER := 0
59 ,p_underrecovery_amount NUMBER := 0
60 ,p_apply_inflation_flag VARCHAR2
61 ,p_budget_justification LONG
62 ,p_location_code VARCHAR2
63 ,p_location VARCHAR2
64 ,p_project_id NUMBER :=NULL
65 ,p_project_number VARCHAR2
66 ,p_task_id NUMBER :=NULL
67 ,p_task_number VARCHAR2
68 ,p_award_id NUMBER :=NULL
69 ,p_award_number VARCHAR2
70 ,x_line_item_id OUT NOCOPY NUMBER
71 ,x_rowid OUT NOCOPY ROWID
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_msg_count OUT NOCOPY NUMBER
74 ,x_msg_data OUT NOCOPY VARCHAR2) IS
75
76
77
78 BEGIN
79 NULL;
80 END; --CREATE BUDGET LINE
81
82
83 ------------------------------------------------------------------------------------------
84 procedure update_budget_line
85 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
86 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
87 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
88 ,p_proposal_id NUMBER := NULL
89 ,p_version_id NUMBER := NULL
90 ,p_budget_period_id NUMBER := NULL
91 ,p_line_item_id NUMBER
92 ,p_expenditure_type VARCHAR2
93 ,p_expenditure_category_flag VARCHAR2
94 ,p_budget_category_code VARCHAR2
95 ,p_budget_category VARCHAR2
96 ,p_line_item_description VARCHAR2
97 ,p_based_on_line_item NUMBER := NULL
98 ,p_line_item_cost NUMBER
99 ,p_cost_sharing_amount NUMBER
100 ,p_underrecovery_amount NUMBER := 0
101 ,p_apply_inflation_flag VARCHAR2
102 ,p_budget_justification LONG
103 ,p_location_code VARCHAR2
104 ,p_location VARCHAR2
105 ,p_project_id NUMBER
106 ,p_project_number VARCHAR2
107 ,p_task_id NUMBER
108 ,p_task_number VARCHAR2
109 ,p_award_id NUMBER
110 ,p_award_number VARCHAR2
111 ,p_record_version_number IN NUMBER
112 ,p_rowid IN ROWID
113 ,x_return_status OUT NOCOPY VARCHAR2
114 ,x_msg_count OUT NOCOPY NUMBER
115 ,x_msg_data OUT NOCOPY VARCHAR2) IS
116
117 BEGIN
118 NULL;
119
120 END; --UPDATE BUDGET LINE
121
122 -------------------------------------------------------------------------------------------
123
124 procedure delete_budget_line
125 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
126 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
127 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
128 ,p_proposal_id IN NUMBER := NULL
129 ,p_version_id IN NUMBER := NULL
130 ,p_budget_period_id NUMBER := NULL
131 ,p_line_item_id NUMBER
132 ,p_record_version_number IN NUMBER
133 ,p_rowid IN ROWID
134 ,x_return_status OUT NOCOPY VARCHAR2
135 ,x_msg_count OUT NOCOPY NUMBER
136 ,x_msg_data OUT NOCOPY VARCHAR2) is
137
138
139 BEGIN
140 NULL;
141 END; --DELETE BUDGET LINE
142
143
144 END;