DBA Data[Home] [Help]

APPS.OKL_OPEN_INT_PUB dependencies on OKC_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2: /* $Header: OKLPOINB.pls 115.6 2004/04/13 11:43:13 rnaik noship $ */
3:
4: PROCEDURE insert_open_int(
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_oinv_rec IN oinv_rec_type

Line 97: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

93: END insert_open_int;
94:
95: PROCEDURE insert_open_int(
96: p_api_version IN NUMBER
97: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
98: ,x_return_status OUT NOCOPY VARCHAR2
99: ,x_msg_count OUT NOCOPY NUMBER
100: ,x_msg_data OUT NOCOPY VARCHAR2
101: ,p_oinv_tbl IN oinv_tbl_type

Line 182: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

178: END insert_open_int;
179:
180: PROCEDURE lock_open_int(
181: p_api_version IN NUMBER
182: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
183: ,x_return_status OUT NOCOPY VARCHAR2
184: ,x_msg_count OUT NOCOPY NUMBER
185: ,x_msg_data OUT NOCOPY VARCHAR2
186: ,p_oinv_rec IN oinv_rec_type) AS

Line 223: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

219: END lock_open_int;
220:
221: PROCEDURE lock_open_int(
222: p_api_version IN NUMBER
223: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
224: ,x_return_status OUT NOCOPY VARCHAR2
225: ,x_msg_count OUT NOCOPY NUMBER
226: ,x_msg_data OUT NOCOPY VARCHAR2
227: ,p_oinv_tbl IN oinv_tbl_type) AS

Line 263: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

259: END lock_open_int;
260:
261: PROCEDURE update_open_int(
262: p_api_version IN NUMBER
263: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
264: ,x_return_status OUT NOCOPY VARCHAR2
265: ,x_msg_count OUT NOCOPY NUMBER
266: ,x_msg_data OUT NOCOPY VARCHAR2
267: ,p_oinv_rec IN oinv_rec_type

Line 352: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

348: END update_open_int;
349:
350: PROCEDURE update_open_int(
351: p_api_version IN NUMBER
352: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_msg_count OUT NOCOPY NUMBER
355: ,x_msg_data OUT NOCOPY VARCHAR2
356: ,p_oinv_tbl IN oinv_tbl_type

Line 440: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

436:
437: --Put custom code for cascade delete by developer
438: PROCEDURE delete_open_int(
439: p_api_version IN NUMBER
440: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
441: ,x_return_status OUT NOCOPY VARCHAR2
442: ,x_msg_count OUT NOCOPY NUMBER
443: ,x_msg_data OUT NOCOPY VARCHAR2
444: ,p_oinv_rec IN oinv_rec_type) AS

Line 447: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

443: ,x_msg_data OUT NOCOPY VARCHAR2
444: ,p_oinv_rec IN oinv_rec_type) AS
445:
446: i NUMBER :=0;
447: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
448: l_api_version NUMBER ;
449: l_init_msg_list VARCHAR2(1) ;
450: l_msg_data VARCHAR2(2000);
451: l_msg_count NUMBER ;

Line 523: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

519: END delete_open_int;
520:
521: PROCEDURE delete_open_int(
522: p_api_version IN NUMBER
523: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
524: ,x_return_status OUT NOCOPY VARCHAR2
525: ,x_msg_count OUT NOCOPY NUMBER
526: ,x_msg_data OUT NOCOPY VARCHAR2
527: ,p_oinv_tbl IN oinv_tbl_type) AS

Line 530: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

526: ,x_msg_data OUT NOCOPY VARCHAR2
527: ,p_oinv_tbl IN oinv_tbl_type) AS
528:
529: i NUMBER := 0;
530: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
531: l_api_version NUMBER := p_api_version ;
532: l_init_msg_list VARCHAR2(1) := p_init_msg_list ;
533: l_msg_data VARCHAR2(2000);
534: l_msg_count NUMBER ;

Line 554: l_return_status := OKC_API.G_RET_STS_SUCCESS;

550:
551:
552: BEGIN
553: --Initialize the return status
554: l_return_status := OKC_API.G_RET_STS_SUCCESS;
555:
556: IF (lp_oinv_tbl.COUNT > 0) THEN
557: i := p_oinv_tbl.FIRST;
558: LOOP

Line 618: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

614: END delete_open_int;
615:
616: PROCEDURE validate_open_int(
617: p_api_version IN NUMBER
618: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
619: ,x_return_status OUT NOCOPY VARCHAR2
620: ,x_msg_count OUT NOCOPY NUMBER
621: ,x_msg_data OUT NOCOPY VARCHAR2
622: ,p_oinv_rec IN oinv_rec_type) AS

Line 706: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

702: END validate_open_int;
703:
704: PROCEDURE validate_open_int(
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
707: x_return_status OUT NOCOPY VARCHAR2,
708: x_msg_count OUT NOCOPY NUMBER,
709: x_msg_data OUT NOCOPY VARCHAR2,
710: p_oinv_tbl IN oinv_tbl_type) AS