[Home] [Help]
PACKAGE: APPS.OZF_OBJFUNDSUM_PVT
Source
1 PACKAGE OZF_OBJFUNDSUM_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvfsus.pls 120.3.12010000.2 2009/06/19 08:41:36 kdass ship $ */
3
4 --
5 -- Start of comments.
6 --
7 -- NAME
8 -- Ozf_objfundsum_Pvt 12.0
9 --
10 -- PURPOSE
11 -- This package is a private package used for captures object's planned/committed/utilized/earned/paid amount at object-budget level
12 --
13 -- Procedures:
14 -- Create_ObjFundSum
15 -- Update_ObjFundSum
16 -- Validate_ObjFundSum
17 -- Complete_ObjFundSum_Rec
18 -- Init_ObjFundSum_Rec
19 -- NOTES
20 --
21 --
22 -- HISTORY
23 -- 06/30/2005 YZHAO creation
24 -- 06/12/2009 kdass bug 8532055 - ADD EXCHANGE RATE DATE PARAM TO OZF_FUND_UTILIZED_PUB.CREATE_FUND_ADJUSTMENT API
25 --
26 TYPE objfundsum_rec_type
27 IS RECORD (
28 objfundsum_id NUMBER,
29 last_update_date DATE,
30 last_updated_by NUMBER,
31 creation_date DATE,
32 created_by NUMBER,
33 last_update_login NUMBER,
34 object_version_number NUMBER,
35 fund_id NUMBER,
36 fund_currency VARCHAR2(30),
37 object_type VARCHAR2(30),
38 object_id NUMBER,
39 object_currency VARCHAR2(30),
40 reference_object_type VARCHAR2(30),
41 reference_object_id NUMBER,
42 source_from_parent VARCHAR2(1),
43 planned_amt NUMBER,
44 committed_amt NUMBER,
45 recal_committed_amt NUMBER,
46 utilized_amt NUMBER,
47 earned_amt NUMBER,
48 paid_amt NUMBER,
49 plan_curr_planned_amt NUMBER,
50 plan_curr_committed_amt NUMBER,
51 plan_curr_recal_committed_amt NUMBER,
52 plan_curr_utilized_amt NUMBER,
53 plan_curr_earned_amt NUMBER,
54 plan_curr_paid_amt NUMBER,
55 univ_curr_planned_amt NUMBER,
56 univ_curr_committed_amt NUMBER,
57 univ_curr_recal_committed_amt NUMBER,
58 univ_curr_utilized_amt NUMBER,
59 univ_curr_earned_amt NUMBER,
60 univ_curr_paid_amt NUMBER,
61 attribute_category VARCHAR2(30),
62 attribute1 VARCHAR2(150),
63 attribute2 VARCHAR2(150),
64 attribute3 VARCHAR2(150),
65 attribute4 VARCHAR2(150),
66 attribute5 VARCHAR2(150),
67 attribute6 VARCHAR2(150),
68 attribute7 VARCHAR2(150),
69 attribute8 VARCHAR2(150),
70 attribute9 VARCHAR2(150),
71 attribute10 VARCHAR2(150),
72 attribute11 VARCHAR2(150),
73 attribute12 VARCHAR2(150),
74 attribute13 VARCHAR2(150),
75 attribute14 VARCHAR2(150),
76 attribute15 VARCHAR2(150)
77 );
78
79
80 -- NAME
81 -- create_objfundsum
82 --
83 -- PURPOSE
84 -- This Procedure creates a record in object fund summary table.
85 --
86 -- NOTES
87 --
88 --
89 PROCEDURE Create_objfundsum (
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
92 p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
93 p_objfundsum_rec IN objfundsum_rec_type,
94 p_conv_date IN DATE DEFAULT NULL, --bug 8532055
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 x_objfundsum_id OUT NOCOPY NUMBER
99 );
100
101
102
103 -- NAME
104 -- update_objfundsum
105 --
106 -- PURPOSE
107 -- This Procedure updates record in object fund summary table.
108 -- it overwrites record if the filed(e.g. earned_amount) is passed in
109 --
110 -- NOTES
111 --
112 --
113 PROCEDURE Update_objfundsum (
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
116 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
117 p_objfundsum_rec IN objfundsum_rec_type,
118 p_conv_date IN DATE DEFAULT NULL, --bug 8532055
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2
122 );
123
124
125 -- NAME
126 -- process_objfundsum
127 --
128 -- PURPOSE
129 -- This Procedure creates a record in object fund summary table if it's not there.
130 -- update a record in object fund summary table if it's already there
131 -- for update, it does cumulative update. E.g. existing record has earned_amount=$100
132 -- if p_objfundsum_rec.earned_amount=$50, after this call earned_amount=$150
133 --
134 -- NOTES
135 --
136 --
137 PROCEDURE process_objfundsum (
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
140 p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
141 p_objfundsum_rec IN objfundsum_rec_type,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 x_objfundsum_id OUT NOCOPY NUMBER
146 );
147
148
149 -- NAME
150 -- validate_objfundsum
151 --
152 -- PURPOSE
153 -- This Procedure validates record in object fund summary table.
154 --
155 -- NOTES
156 --
157 --
158 PROCEDURE Validate_objfundsum (
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
161 p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
162 p_objfundsum_rec IN objfundsum_rec_type,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2
166 );
167
168
169
170 -- NAME
171 -- complete_objfundsum_rec
172 --
173 -- PURPOSE
174 -- This Procedure completes record in object fund summary table.
175 --
176 -- NOTES
177 --
178 --
179 PROCEDURE Complete_objfundsum_Rec(
180 p_objfundsum_rec IN objfundsum_rec_type,
181 x_complete_rec IN OUT NOCOPY objfundsum_rec_type
182 );
183
184
185 END ozf_objfundsum_pvt;