1 PACKAGE okl_trx_csh_batch_pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPBTCS.pls 120.2 2005/10/30 03:29:14 appldev noship $ */
3
4 subtype btcv_rec_type is okl_btc_pvt.btcv_rec_type;
5 subtype btcv_tbl_type is okl_btc_pvt.btcv_tbl_type;
6 subtype okl_btch_dtls_tbl_type is okl_btch_cash_applic.okl_btch_dtls_tbl_type;
7 ------------------------------------------------------------------------------
8 -- Global Variables
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRX_CSH_BATCH_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14 ------------------------------------------------------------------------------
15 --Global Exception
16 ------------------------------------------------------------------------------
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18 ------------------------------------------------------------------------------
19
20
21 PROCEDURE insert_trx_csh_batch(
22 p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,p_btcv_tbl IN btcv_tbl_type
28 ,x_btcv_tbl OUT NOCOPY btcv_tbl_type);
29
30 PROCEDURE insert_trx_csh_batch(
31 p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,p_btcv_rec IN btcv_rec_type
37 ,x_btcv_rec OUT NOCOPY btcv_rec_type);
38
39 PROCEDURE lock_trx_csh_batch(
40 p_api_version IN NUMBER
41 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 ,p_btcv_tbl IN btcv_tbl_type);
46
47 PROCEDURE lock_trx_csh_batch(
48 p_api_version IN NUMBER
49 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
50 ,x_return_status OUT NOCOPY VARCHAR2
51 ,x_msg_count OUT NOCOPY NUMBER
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 ,p_btcv_rec IN btcv_rec_type);
54
55 PROCEDURE update_trx_csh_batch(
56 p_api_version IN NUMBER
57 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_btcv_tbl IN btcv_tbl_type
62 ,x_btcv_tbl OUT NOCOPY btcv_tbl_type);
63
64 PROCEDURE update_trx_csh_batch(
65 p_api_version IN NUMBER
66 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 ,p_btcv_rec IN btcv_rec_type
71 ,x_btcv_rec OUT NOCOPY btcv_rec_type);
72
73 PROCEDURE delete_trx_csh_batch(
74 p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
76 ,x_return_status OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 ,p_btcv_tbl IN btcv_tbl_type);
80
81 PROCEDURE delete_trx_csh_batch(
82 p_api_version IN NUMBER
83 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 ,x_msg_data OUT NOCOPY VARCHAR2
87 ,p_btcv_rec IN btcv_rec_type);
88
89 PROCEDURE validate_trx_csh_batch(
90 p_api_version IN NUMBER
91 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
92 ,x_return_status OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER
94 ,x_msg_data OUT NOCOPY VARCHAR2
95 ,p_btcv_tbl IN btcv_tbl_type);
96
97 PROCEDURE validate_trx_csh_batch(
98 p_api_version IN NUMBER
99 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY NUMBER
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 ,p_btcv_rec IN btcv_rec_type);
104
105 PROCEDURE handle_batch_receipt(
106 p_api_version IN NUMBER
107 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
108 ,x_return_status OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY NUMBER
110 ,x_msg_data OUT NOCOPY VARCHAR2
111 ,p_btcv_rec IN btcv_rec_type
112 ,x_btcv_rec OUT NOCOPY btcv_rec_type
113 ,p_btch_lines_tbl IN okl_btch_dtls_tbl_type
114 ,x_btch_lines_tbl OUT NOCOPY okl_btch_dtls_tbl_type);
115
116 END okl_trx_csh_batch_pub;