2: /* $Header: IEXPIEAB.pls 120.2 2005/11/17 20:38:49 jsanju ship $ */
3:
4: PROCEDURE insert_ext_agncy(
5: p_api_version IN NUMBER
6: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
7: ,x_return_status OUT NOCOPY VARCHAR2
8: ,x_msg_count OUT NOCOPY NUMBER
9: ,x_msg_data OUT NOCOPY VARCHAR2
10: ,p_ieav_rec IN ieav_rec_type
165: END insert_ext_agncy;
166:
167: PROCEDURE insert_ext_agncy(
168: p_api_version IN NUMBER
169: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
170: ,x_return_status OUT NOCOPY VARCHAR2
171: ,x_msg_count OUT NOCOPY NUMBER
172: ,x_msg_data OUT NOCOPY VARCHAR2
173: ,p_ieav_tbl IN ieav_tbl_type
324: END insert_ext_agncy;
325:
326: PROCEDURE lock_ext_agncy(
327: p_api_version IN NUMBER
328: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
329: ,x_return_status OUT NOCOPY VARCHAR2
330: ,x_msg_count OUT NOCOPY NUMBER
331: ,x_msg_data OUT NOCOPY VARCHAR2
332: ,p_ieav_rec IN ieav_rec_type) AS
366: END lock_ext_agncy;
367:
368: PROCEDURE lock_ext_agncy(
369: p_api_version IN NUMBER
370: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
371: ,x_return_status OUT NOCOPY VARCHAR2
372: ,x_msg_count OUT NOCOPY NUMBER
373: ,x_msg_data OUT NOCOPY VARCHAR2
374: ,p_ieav_tbl IN ieav_tbl_type) AS
408: END lock_ext_agncy;
409:
410: PROCEDURE update_ext_agncy(
411: p_api_version IN NUMBER
412: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
413: ,x_return_status OUT NOCOPY VARCHAR2
414: ,x_msg_count OUT NOCOPY NUMBER
415: ,x_msg_data OUT NOCOPY VARCHAR2
416: ,p_ieav_rec IN ieav_rec_type
569: END update_ext_agncy;
570:
571: PROCEDURE update_ext_agncy(
572: p_api_version IN NUMBER
573: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
574: ,x_return_status OUT NOCOPY VARCHAR2
575: ,x_msg_count OUT NOCOPY NUMBER
576: ,x_msg_data OUT NOCOPY VARCHAR2
577: ,p_ieav_tbl IN ieav_tbl_type
729:
730: --Put custom code for cascade delete by developer
731: PROCEDURE delete_ext_agncy(
732: p_api_version IN NUMBER
733: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
734: ,x_return_status OUT NOCOPY VARCHAR2
735: ,x_msg_count OUT NOCOPY NUMBER
736: ,x_msg_data OUT NOCOPY VARCHAR2
737: ,p_ieav_rec IN ieav_rec_type) AS
736: ,x_msg_data OUT NOCOPY VARCHAR2
737: ,p_ieav_rec IN ieav_rec_type) AS
738:
739: i NUMBER :=0;
740: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
741: l_api_version NUMBER ;
742: l_init_msg_list VARCHAR2(1) ;
743: l_msg_data VARCHAR2(2000);
744: l_msg_count NUMBER ;
884: END delete_ext_agncy;
885:
886: PROCEDURE delete_ext_agncy(
887: p_api_version IN NUMBER
888: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
889: ,x_return_status OUT NOCOPY VARCHAR2
890: ,x_msg_count OUT NOCOPY NUMBER
891: ,x_msg_data OUT NOCOPY VARCHAR2
892: ,p_ieav_tbl IN ieav_tbl_type) AS
891: ,x_msg_data OUT NOCOPY VARCHAR2
892: ,p_ieav_tbl IN ieav_tbl_type) AS
893:
894: i NUMBER := 0;
895: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
896: l_api_version NUMBER := p_api_version ;
897: l_init_msg_list VARCHAR2(1) := p_init_msg_list ;
898: l_msg_data VARCHAR2(2000);
899: l_msg_count NUMBER ;
960: */
961:
962: BEGIN
963: --Initialize the return status
964: l_return_status := OKC_API.G_RET_STS_SUCCESS;
965:
966: IF (lp_ieav_tbl.COUNT > 0) THEN
967: i := p_ieav_tbl.FIRST;
968: LOOP
1055: END delete_ext_agncy;
1056:
1057: PROCEDURE validate_ext_agncy(
1058: p_api_version IN NUMBER
1059: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1060: ,x_return_status OUT NOCOPY VARCHAR2
1061: ,x_msg_count OUT NOCOPY NUMBER
1062: ,x_msg_data OUT NOCOPY VARCHAR2
1063: ,p_ieav_rec IN ieav_rec_type) AS
1219: END validate_ext_agncy;
1220:
1221: PROCEDURE validate_ext_agncy(
1222: p_api_version IN NUMBER,
1223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1224: x_return_status OUT NOCOPY VARCHAR2,
1225: x_msg_count OUT NOCOPY NUMBER,
1226: x_msg_data OUT NOCOPY VARCHAR2,
1227: p_ieav_tbl IN ieav_tbl_type) AS