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