DBA Data[Home] [Help]

APPS.OKL_CSH_ORDER_SEQ_PUB dependencies on OKC_API

Line 16: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

12: -- PROCEDURE insert_order_sequence
13: ---------------------------------------------------------------------------
14:
15: PROCEDURE insert_order_sequence (p_api_version IN NUMBER
16: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
17: ,x_return_status OUT NOCOPY VARCHAR2
18: ,x_msg_count OUT NOCOPY NUMBER
19: ,x_msg_data OUT NOCOPY VARCHAR2
20: ,p_okl_csh_order_rec IN okl_csh_order_rec_type

Line 24: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

20: ,p_okl_csh_order_rec IN okl_csh_order_rec_type
21: ,x_okl_csh_order_rec OUT NOCOPY okl_csh_order_rec_type) IS
22:
23: i NUMBER :=0;
24: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
25: l_api_version NUMBER ;
26: l_init_msg_list VARCHAR2(1) ;
27: l_msg_data VARCHAR2(2000);
28: l_msg_count NUMBER ;

Line 126: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

122: -- PROCEDURE insert_order_sequence(s)
123: ---------------------------------------------------------------------------
124:
125: PROCEDURE insert_order_sequence (p_api_version IN NUMBER
126: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
127: ,x_return_status OUT NOCOPY VARCHAR2
128: ,x_msg_count OUT NOCOPY NUMBER
129: ,x_msg_data OUT NOCOPY VARCHAR2
130: ,p_okl_csh_order_tbl IN okl_csh_order_tbl_type

Line 134: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

130: ,p_okl_csh_order_tbl IN okl_csh_order_tbl_type
131: ,x_okl_csh_order_tbl OUT NOCOPY okl_csh_order_tbl_type) IS
132:
133: i NUMBER :=0;
134: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
135: l_api_version NUMBER ;
136: l_init_msg_list VARCHAR2(1) ;
137: l_msg_data VARCHAR2(2000);
138: l_msg_count NUMBER ;

Line 162: l_return_status := Okc_Api.G_RET_STS_SUCCESS;

158:
159:
160: --Delete the Master
161: --Initialize the return status
162: l_return_status := Okc_Api.G_RET_STS_SUCCESS;
163:
164: IF (lp_okl_csh_order_tbl.COUNT > 0) THEN
165: i := p_okl_csh_order_tbl.FIRST;
166: LOOP

Line 248: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

244: -- PROCEDURE update_order_sequence
245: ---------------------------------------------------------------------------
246:
247: PROCEDURE update_order_sequence (p_api_version IN NUMBER
248: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
249: ,x_return_status OUT NOCOPY VARCHAR2
250: ,x_msg_count OUT NOCOPY NUMBER
251: ,x_msg_data OUT NOCOPY VARCHAR2
252: ,p_okl_csh_order_rec IN okl_csh_order_rec_type

Line 256: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

252: ,p_okl_csh_order_rec IN okl_csh_order_rec_type
253: ,x_okl_csh_order_rec OUT NOCOPY okl_csh_order_rec_type) IS
254:
255: i NUMBER :=0;
256: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
257: l_api_version NUMBER ;
258: l_init_msg_list VARCHAR2(1) ;
259: l_msg_data VARCHAR2(2000);
260: l_msg_count NUMBER ;

Line 357: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

353: -- PROCEDURE update_order_sequence(s)
354: ---------------------------------------------------------------------------
355:
356: PROCEDURE update_order_sequence (p_api_version IN NUMBER
357: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
358: ,x_return_status OUT NOCOPY VARCHAR2
359: ,x_msg_count OUT NOCOPY NUMBER
360: ,x_msg_data OUT NOCOPY VARCHAR2
361: ,p_okl_csh_order_tbl IN okl_csh_order_tbl_type

Line 370: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

366: j NUMBER :=0;
367: k NUMBER :=0;
368: l NUMBER :=0;
369:
370: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
371: l_api_version NUMBER;
372: l_init_msg_list VARCHAR2(1);
373: l_msg_data VARCHAR2(2000);
374: l_msg_count NUMBER;

Line 449: l_return_status := Okc_Api.G_RET_STS_SUCCESS;

445: lx_okl_csh_order_tbl := p_okl_csh_order_tbl;
446:
447: --Delete the Master
448: --Initialize the return status
449: l_return_status := Okc_Api.G_RET_STS_SUCCESS;
450:
451:
452: IF (lp_okl_csh_order_tbl.COUNT > 0) THEN
453: i := lp_okl_csh_order_tbl.FIRST;