66: ,x_agcv_tbl OUT NOCOPY agcv_tbl_type) IS
67:
68:
69:
70: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
71: l_api_name CONSTANT VARCHAR2(30) := 'create_acc_ccid';
72: i NUMBER;
73:
74: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
70: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
71: l_api_name CONSTANT VARCHAR2(30) := 'create_acc_ccid';
72: i NUMBER;
73:
74: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
75: l_agcv_tbl agcv_tbl_type := p_agcv_tbl;
76:
77:
78: BEGIN
92: ,p_agcv_rec => l_agcv_tbl(i)
93: ,x_agcv_rec => x_agcv_tbl(i));
94:
95: -- store the highest degree of error
96: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
97: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
98: l_overall_status := l_return_status;
99: END IF;
100: END IF;
93: ,x_agcv_rec => x_agcv_tbl(i));
94:
95: -- store the highest degree of error
96: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
97: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
98: l_overall_status := l_return_status;
99: END IF;
100: END IF;
101:
176: ,x_msg_data OUT NOCOPY VARCHAR2
177: ,p_agcv_tbl IN agcv_tbl_type
178: ,x_agcv_tbl OUT NOCOPY agcv_tbl_type) IS
179:
180: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
181: l_api_name CONSTANT VARCHAR2(30) := 'update_acc_ccid';
182: i NUMBER;
183:
184: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
180: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
181: l_api_name CONSTANT VARCHAR2(30) := 'update_acc_ccid';
182: i NUMBER;
183:
184: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
185: l_agcv_tbl agcv_tbl_type := p_agcv_tbl;
186:
187: BEGIN
188:
200: ,p_agcv_rec => l_agcv_tbl(i)
201: ,x_agcv_rec => x_agcv_tbl(i));
202:
203: -- store the highest degree of error
204: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
205: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
206: l_overall_status := l_return_status;
207: END IF;
208: END IF;
201: ,x_agcv_rec => x_agcv_tbl(i));
202:
203: -- store the highest degree of error
204: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
205: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
206: l_overall_status := l_return_status;
207: END IF;
208: END IF;
209:
253: ,x_msg_data OUT NOCOPY VARCHAR2
254: ,p_agcv_tbl IN agcv_tbl_type) IS
255:
256: i NUMBER :=0;
257: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
258: l_api_name CONSTANT VARCHAR2(30) := 'delete_acc_ccid';
259: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
260: l_agcv_tbl agcv_tbl_type := p_agcv_tbl;
261:
255:
256: i NUMBER :=0;
257: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
258: l_api_name CONSTANT VARCHAR2(30) := 'delete_acc_ccid';
259: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
260: l_agcv_tbl agcv_tbl_type := p_agcv_tbl;
261:
262: BEGIN
263:
274: ,x_msg_data => x_msg_data
275: ,p_agcv_rec => l_agcv_tbl(i));
276:
277: -- store the highest degree of error
278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
280: l_overall_status := l_return_status;
281: END IF;
282: END IF;
275: ,p_agcv_rec => l_agcv_tbl(i));
276:
277: -- store the highest degree of error
278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
280: l_overall_status := l_return_status;
281: END IF;
282: END IF;
283:
329: ,p_agbv_tbl IN agbv_tbl_type
330: ,x_agbv_tbl OUT NOCOPY agbv_tbl_type) IS
331:
332:
333: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
334: l_api_name CONSTANT VARCHAR2(30) := 'create_acc_bal';
335: i NUMBER;
336: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
337: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
332:
333: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
334: l_api_name CONSTANT VARCHAR2(30) := 'create_acc_bal';
335: i NUMBER;
336: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
337: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
338:
339: BEGIN
340:
353: ,p_agbv_rec => l_agbv_tbl(i)
354: ,x_agbv_rec => x_agbv_tbl(i));
355:
356: -- store the highest degree of error
357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
358: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
359: l_overall_status := l_return_status;
360: END IF;
361: END IF;
354: ,x_agbv_rec => x_agbv_tbl(i));
355:
356: -- store the highest degree of error
357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
358: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
359: l_overall_status := l_return_status;
360: END IF;
361: END IF;
362:
405: ,x_msg_data OUT NOCOPY VARCHAR2
406: ,p_agbv_tbl IN agbv_tbl_type
407: ,x_agbv_tbl OUT NOCOPY agbv_tbl_type) IS
408:
409: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
410: l_api_name CONSTANT VARCHAR2(30) := 'update_acc_bal';
411: i NUMBER;
412: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
413: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
408:
409: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
410: l_api_name CONSTANT VARCHAR2(30) := 'update_acc_bal';
411: i NUMBER;
412: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
413: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
414:
415: BEGIN
416:
428: ,p_agbv_rec => l_agbv_tbl(i)
429: ,x_agbv_rec => x_agbv_tbl(i));
430:
431: -- store the highest degree of error
432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
434: l_overall_status := l_return_status;
435: END IF;
436: END IF;
429: ,x_agbv_rec => x_agbv_tbl(i));
430:
431: -- store the highest degree of error
432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
434: l_overall_status := l_return_status;
435: END IF;
436: END IF;
437:
484:
485:
486:
487: i NUMBER :=0;
488: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
489: l_api_name CONSTANT VARCHAR2(30) := 'delete_acc_bal';
490: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
491: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
492:
486:
487: i NUMBER :=0;
488: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
489: l_api_name CONSTANT VARCHAR2(30) := 'delete_acc_bal';
490: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
491: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
492:
493: BEGIN
494:
505: ,x_msg_data => x_msg_data
506: ,p_agbv_rec => l_agbv_tbl(i));
507:
508: -- store the highest degree of error
509: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
510: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
511: l_overall_status := l_return_status;
512: END IF;
513: END IF;
506: ,p_agbv_rec => l_agbv_tbl(i));
507:
508: -- store the highest degree of error
509: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
510: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
511: l_overall_status := l_return_status;
512: END IF;
513: END IF;
514: