[Home] [Help]
PACKAGE: APPS.PA_CLIENT_EXTN_DFFTRANS
Source
1 PACKAGE PA_CLIENT_EXTN_DFFTRANS AS
2 --$Header: PAPDFFCS.pls 120.4 2006/07/25 19:40:17 skannoji noship $
3 /*#
4 * This extension is used to map segments of descriptive flexfield that are transferred from Payables to
5 * Oracle Projects or from Oracle Projects to Payables.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Descriptive Flexfield Mapping Client Extension
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_PAYABLE_INV_COST
13 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14 */
15 TYPE attribute_a IS TABLE of pa_expenditure_items_all.attribute1%TYPE
16 INDEX BY BINARY_INTEGER;
17
18
19 /*----------------------------------------------------------------------------*/
20 -- Start of Comments
21 -- API Name : DFF_map_segments_f
22 -- Type : Public
23 -- Pre-Reqs : None
24 -- Type : Function
25 -- Function : Given the attribute number, returns the attribute value
26 -- Parameters :
27 -- IN
28 -- p_attribute_number NUMBER
29 -- p_calling_module VARCHAR2
30 -- p_trx_ref_1 NUMBER
31 -- p_trx_ref_2 NUMBER
32 -- p_trx_type VARCHAR2
33 -- p_system_linkage_function VARCHAR2
34 -- p_submodule VARCHAR2
35 -- p_expenditure_type VARCHAR2
36 -- p_set_of_books_id NUMBER
37 -- p_org_id NUMBER
38 -- p_attribute_category VARCHAR2
39 -- p_attribute_1 VARCHAR2
40 -- p_attribute_2 VARCHAR2
41 -- p_attribute_3 VARCHAR2
42 -- p_attribute_4 VARCHAR2
43 -- p_attribute_5 VARCHAR2
44 -- p_attribute_6 VARCHAR2
45 -- p_attribute_7 VARCHAR2
46 -- p_attribute_8 VARCHAR2
47 -- p_attribute_9 VARCHAR2
48 -- p_attribute_10 VARCHAR2
49
50 /*----------------------------------------------------------------------------*/
51
52
53
54 /*#
55 * This API provides the mapping logic for the descriptive flex fields.The default logic maps segment n in the originating application
56 * to segment n in the receiving application. You can change this function to map the segments according to your business rules
57 * @return Returns the mapping of Descriptive FlexField segments.
58 * @param p_attribute_number The identifier of the attribute to be mapped.
59 * @rep:paraminfo {@rep:required}
60 * @param p_calling_module The module that calls the extension.
61 * @rep:paraminfo {@rep:required}
62 * @param p_trx_ref_1 Reference information passed to the extension.
63 * @rep:paraminfo {@rep:required}
64 * @param p_trx_ref_2 Reference information passed to the extension.
65 * @rep:paraminfo {@rep:required}
66 * @param p_trx_type Type of transaction .
67 * @rep:paraminfo {@rep:required}
68 * @param p_system_linkage_function The expenditure type class function.
69 * @rep:paraminfo {@rep:required}
70 * @param p_submodule Name of the calling submodule.
71 * @rep:paraminfo {@rep:required}
72 * @param p_expenditure_type The expenditure type.
73 * @rep:paraminfo {@rep:required}
74 * @param p_set_of_books_id The identifier of the set of books.
75 * @rep:paraminfo {@rep:required}
76 * @param p_org_id The identifier of the organization.
77 * @rep:paraminfo {@rep:required}
78 * @param p_attribute_category The attribute category for the descriptive flexfield.
79 * @rep:paraminfo {@rep:required}
80 * @param p_attribute_1 The descriptive flexfield segment.
81 * @rep:paraminfo {@rep:required}
82 * @param p_attribute_2 The descriptive flexfield segment.
83 * @rep:paraminfo {@rep:required}
84 * @param p_attribute_3 The descriptive flexfield segment.
85 * @rep:paraminfo {@rep:required}
86 * @param p_attribute_4 The descriptive flexfield segment.
87 * @rep:paraminfo {@rep:required}
88 * @param p_attribute_5 The descriptive flexfield segment.
89 * @rep:paraminfo {@rep:required}
90 * @param p_attribute_6 The descriptive flexfield segment.
91 * @rep:paraminfo {@rep:required}
92 * @param p_attribute_7 The descriptive flexfield segment.
93 * @rep:paraminfo {@rep:required}
94 * @param p_attribute_8 The descriptive flexfield segment.
95 * @rep:paraminfo {@rep:required}
96 * @param p_attribute_9 The descriptive flexfield segment.
97 * @rep:paraminfo {@rep:required}
98 * @param p_attribute_10 The descriptive flexfield segment.
99 * @rep:paraminfo {@rep:required}
100 * @rep:scope public
101 * @rep:lifecycle active
102 * @rep:displayname Descriptive Flexfields Mapping Logic
103 * @rep:compatibility S
104 */
105
106 FUNCTION DFF_map_segments_f(
107 p_attribute_number IN NUMBER,
108 p_calling_module IN VARCHAR2,
109 p_trx_ref_1 IN NUMBER,
110 p_trx_ref_2 IN NUMBER,
111 p_trx_type IN VARCHAR2,
112 p_system_linkage_function IN VARCHAR2,
113 p_submodule IN VARCHAR2,
114 p_expenditure_type IN VARCHAR2,
115 p_set_of_books_id IN NUMBER,
116 p_org_id IN NUMBER,
117 p_attribute_category IN VARCHAR2,
118 p_attribute_1 IN VARCHAR2,
119 p_attribute_2 IN VARCHAR2,
120 p_attribute_3 IN VARCHAR2,
121 p_attribute_4 IN VARCHAR2,
122 p_attribute_5 IN VARCHAR2,
123 p_attribute_6 IN VARCHAR2,
124 p_attribute_7 IN VARCHAR2,
125 p_attribute_8 IN VARCHAR2,
126 p_attribute_9 IN VARCHAR2,
127 p_attribute_10 IN VARCHAR2)
128 RETURN pa_expenditure_items_all.attribute1%TYPE;
129 pragma RESTRICT_REFERENCES ( DFF_map_segments_f, WNDS, WNPS);
130
131 /*----------------------------------------------------------------------------*/
132 -- Start of Comments
133 -- API Name : DFF_map_segments_PA_and_AP
134 -- Type : Public
135 -- Pre-Reqs : None
136 -- Type : Procedure
137 -- Function : Provide the DFF segments mapping logic
138 -- Parameters :
139 -- IN
140 -- p_attribute_number NUMBER
141 -- p_calling_module VARCHAR2
142 -- p_trx_ref_1 NUMBER
143 -- p_trx_ref_2 NUMBER
144 -- p_trx_type VARCHAR2
145 -- p_system_linkage_function VARCHAR2
146 -- p_submodule VARCHAR2
147 -- p_expenditure_type VARCHAR2
148 -- p_set_of_books_id NUMBER
149 -- p_org_id NUMBER
150 -- IN/OUT
151 -- p_attribute_category VARCHAR2
152 -- p_attribute_1 VARCHAR2
153 -- p_attribute_2 VARCHAR2
154 -- p_attribute_3 VARCHAR2
155 -- p_attribute_4 VARCHAR2
156 -- p_attribute_5 VARCHAR2
157 -- p_attribute_6 VARCHAR2
158 -- p_attribute_7 VARCHAR2
159 -- p_attribute_8 VARCHAR2
160 -- p_attribute_9 VARCHAR2
161 -- p_attribute_10 VARCHAR2
162 -- OUT
163 -- x_status_code VARCHAR2
164
165 /*----------------------------------------------------------------------------*/
166
167
168 /*#
169 * This API provides the procedure calls the function dff_map_segments_f, and stores the mapped segments in the
170 * parameters p_attribute_1 through p_attribute_10.
171 * @param p_calling_module The module that calls theextension.
172 * @rep:paraminfo {@rep:required}
173 * @param p_trx_ref_1 Reference information passed to the extension.
174 * @rep:paraminfo {@rep:required}
175 * @param p_trx_ref_2 Reference information passed to the extension.
176 * @rep:paraminfo {@rep:required}
177 * @param p_trx_type Type of transaction .
178 * @rep:paraminfo {@rep:required}
179 * @param p_system_linkage_function The expenditure type class function.
180 * @rep:paraminfo {@rep:required}
181 * @param p_submodule Name of the calling submodule.
182 * @rep:paraminfo {@rep:required}
183 * @param p_expenditure_type The expenditure type.
184 * @rep:paraminfo {@rep:required}
185 * @param p_set_of_books_id The identifier of the set of books.
186 * @rep:paraminfo {@rep:required}
187 * @param p_org_id The identifier of the organization.
188 * @rep:paraminfo {@rep:required}
189 * @param p_attribute_category The attribute category for the descriptive flexfield.
190 * @rep:paraminfo {@rep:required}
191 * @param p_attribute_1 The descriptive flexfield segment.
192 * @rep:paraminfo {@rep:required}
193 * @param p_attribute_2 The descriptive flexfield segment.
194 * @rep:paraminfo {@rep:required}
195 * @param p_attribute_3 The descriptive flexfield segment.
196 * @rep:paraminfo {@rep:required}
197 * @param p_attribute_4 The descriptive flexfield segment.
198 * @rep:paraminfo {@rep:required}
199 * @param p_attribute_5 The descriptive flexfield segment.
200 * @rep:paraminfo {@rep:required}
201 * @param p_attribute_6 The descriptive flexfield segment.
202 * @rep:paraminfo {@rep:required}
203 * @param p_attribute_7 The descriptive flexfield segment.
204 * @rep:paraminfo {@rep:required}
205 * @param p_attribute_8 The descriptive flexfield segment.
206 * @rep:paraminfo {@rep:required}
207 * @param p_attribute_9 The descriptive flexfield segment.
208 * @rep:paraminfo {@rep:required}
209 * @param p_attribute_10 The descriptive flexfield segment.
210 * @rep:paraminfo {@rep:required}
211 * @param x_status_code Status of the procedure.
212 * @rep:paraminfo {@rep:required}
213 * @rep:scope public
214 * @rep:lifecycle active
215 * @rep:displayname Descriptive Flexfields Mapping Segments
216 * @rep:compatibility S
217 */
218
219 PROCEDURE DFF_map_segments_PA_and_AP (
220 p_calling_module IN VARCHAR2,
221 p_trx_ref_1 IN NUMBER,
222 p_trx_ref_2 IN NUMBER,
223 p_trx_type IN VARCHAR2,
224 p_system_linkage_function IN VARCHAR2,
225 p_submodule IN VARCHAR2,
226 p_expenditure_type IN VARCHAR2,
227 p_set_of_books_id IN NUMBER,
228 p_org_id IN NUMBER,
229 p_attribute_category IN OUT NOCOPY VARCHAR2,
230 p_attribute_1 IN OUT NOCOPY VARCHAR2,
231 p_attribute_2 IN OUT NOCOPY VARCHAR2,
232 p_attribute_3 IN OUT NOCOPY VARCHAR2,
233 p_attribute_4 IN OUT NOCOPY VARCHAR2,
234 p_attribute_5 IN OUT NOCOPY VARCHAR2,
235 p_attribute_6 IN OUT NOCOPY VARCHAR2,
236 p_attribute_7 IN OUT NOCOPY VARCHAR2,
237 p_attribute_8 IN OUT NOCOPY VARCHAR2,
238 p_attribute_9 IN OUT NOCOPY VARCHAR2,
239 p_attribute_10 IN OUT NOCOPY VARCHAR2,
240 x_status_code OUT NOCOPY VARCHAR2);
241
242 END PA_CLIENT_EXTN_DFFTRANS;
243