26: -- 09/14/00 Anitha B Created --
27: ----------------------------------------------------------------------------
28: PROCEDURE processInterface (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
33:
34: x_return_status OUT NOCOPY VARCHAR2,
27: ----------------------------------------------------------------------------
28: PROCEDURE processInterface (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
33:
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
28: PROCEDURE processInterface (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
33:
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
67: ----------------------------------------------------------------------------
68:
69: PROCEDURE getNonMatchingSubElements (
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74:
75: x_return_status OUT NOCOPY VARCHAR2,
68:
69: PROCEDURE getNonMatchingSubElements (
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74:
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
69: PROCEDURE getNonMatchingSubElements (
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74:
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
107: ----------------------------------------------------------------------------
108:
109: PROCEDURE createSubElements (
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115:
108:
109: PROCEDURE createSubElements (
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115:
116: p_subelement_tbl IN nonmatching_tbl_type,
109: PROCEDURE createSubElements (
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115:
116: p_subelement_tbl IN nonmatching_tbl_type,
117: p_department_tbl IN nonmatching_tbl_type,
143: ----------------------------------------------------------------------------
144:
145: PROCEDURE getDeptAccounts (
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER
150: := FND_API.G_VALID_LEVEL_FULL,
151: p_department_id IN NUMBER,
144:
145: PROCEDURE getDeptAccounts (
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER
150: := FND_API.G_VALID_LEVEL_FULL,
151: p_department_id IN NUMBER,
152: p_from_organization_id IN NUMBER,
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER
150: := FND_API.G_VALID_LEVEL_FULL,
151: p_department_id IN NUMBER,
152: p_from_organization_id IN NUMBER,
153: p_to_organization_id IN NUMBER,
154: x_scrap_account OUT NOCOPY NUMBER,
176: ----------------------------------------------------------------------------
177:
178: PROCEDURE getOSPItem (
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181: p_commit IN VARCHAR2 := FND_API.G_FALSE,
182: p_validation_level IN NUMBER
183: := FND_API.G_VALID_LEVEL_FULL,
184: p_resource_id IN NUMBER,
177:
178: PROCEDURE getOSPItem (
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181: p_commit IN VARCHAR2 := FND_API.G_FALSE,
182: p_validation_level IN NUMBER
183: := FND_API.G_VALID_LEVEL_FULL,
184: p_resource_id IN NUMBER,
185: p_from_organization_id IN NUMBER,
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181: p_commit IN VARCHAR2 := FND_API.G_FALSE,
182: p_validation_level IN NUMBER
183: := FND_API.G_VALID_LEVEL_FULL,
184: p_resource_id IN NUMBER,
185: p_from_organization_id IN NUMBER,
186: p_to_organization_id IN NUMBER,
187:
207: ----------------------------------------------------------------------------
208:
209: PROCEDURE getDefaultActivity (
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER
214: := FND_API.G_VALID_LEVEL_FULL,
215:
208:
209: PROCEDURE getDefaultActivity (
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER
214: := FND_API.G_VALID_LEVEL_FULL,
215:
216: p_resource_id IN NUMBER,
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER
214: := FND_API.G_VALID_LEVEL_FULL,
215:
216: p_resource_id IN NUMBER,
217: p_from_organization_id IN NUMBER,
218: p_to_organization_id IN NUMBER,
238: ----------------------------------------------------------------------------
239:
240: PROCEDURE getExpenditureType (
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER
245: := FND_API.G_VALID_LEVEL_FULL,
246:
239:
240: PROCEDURE getExpenditureType (
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER
245: := FND_API.G_VALID_LEVEL_FULL,
246:
247: p_resource_id IN NUMBER,
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER
245: := FND_API.G_VALID_LEVEL_FULL,
246:
247: p_resource_id IN NUMBER,
248: p_from_organization_id IN NUMBER,
249: p_to_organization_id IN NUMBER,
269: ----------------------------------------------------------------------------
270:
271: PROCEDURE getSubelementAcct (
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: p_validation_level IN NUMBER
276: := FND_API.G_VALID_LEVEL_FULL,
277:
270:
271: PROCEDURE getSubelementAcct (
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: p_validation_level IN NUMBER
276: := FND_API.G_VALID_LEVEL_FULL,
277:
278: p_resource_id IN NUMBER,
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: p_validation_level IN NUMBER
276: := FND_API.G_VALID_LEVEL_FULL,
277:
278: p_resource_id IN NUMBER,
279: p_from_organization_id IN NUMBER,
280: p_to_organization_id IN NUMBER,
302: ----------------------------------------------------------------------------
303:
304: PROCEDURE summarizeSubElements (
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309:
310: x_return_status OUT NOCOPY VARCHAR2,
303:
304: PROCEDURE summarizeSubElements (
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309:
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY NUMBER,
304: PROCEDURE summarizeSubElements (
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309:
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY NUMBER,
312: x_msg_data OUT NOCOPY VARCHAR2,