1 PACKAGE Okl_Cash_Allctn_Rls_Pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPCATS.pls 115.6 2002/02/05 12:04:41 pkm ship $ */
3
4 SUBTYPE catv_rec_type IS Okl_Cat_Pvt.catv_rec_type;
5 SUBTYPE catv_tbl_type IS Okl_Cat_Pvt.catv_tbl_type;
6 ------------------------------------------------------------------------------
7 -- Global Variables
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CASH_ALLCTN_RLS_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13 ------------------------------------------------------------------------------
14 --Global Exception
15 ------------------------------------------------------------------------------
16 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
17 ------------------------------------------------------------------------------
18
19
20 PROCEDURE insert_cash_allctn_rls(
21 p_api_version IN NUMBER
22 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
23 ,x_return_status OUT NOCOPY VARCHAR2
24 ,x_msg_count OUT NOCOPY NUMBER
25 ,x_msg_data OUT NOCOPY VARCHAR2
26 ,p_catv_tbl IN catv_tbl_type
27 ,x_catv_tbl OUT NOCOPY catv_tbl_type);
28
29 PROCEDURE insert_cash_allctn_rls(
30 p_api_version IN NUMBER
31 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
32 ,x_return_status OUT NOCOPY VARCHAR2
33 ,x_msg_count OUT NOCOPY NUMBER
34 ,x_msg_data OUT NOCOPY VARCHAR2
35 ,p_catv_rec IN catv_rec_type
36 ,x_catv_rec OUT NOCOPY catv_rec_type);
37
38 PROCEDURE lock_cash_allctn_rls(
39 p_api_version IN NUMBER
40 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY NUMBER
43 ,x_msg_data OUT NOCOPY VARCHAR2
44 ,p_catv_tbl IN catv_tbl_type);
45
46 PROCEDURE lock_cash_allctn_rls(
47 p_api_version IN NUMBER
48 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 ,p_catv_rec IN catv_rec_type);
53
54 PROCEDURE update_cash_allctn_rls(
55 p_api_version IN NUMBER
56 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 ,p_catv_tbl IN catv_tbl_type
61 ,x_catv_tbl OUT NOCOPY catv_tbl_type);
62
63 PROCEDURE update_cash_allctn_rls(
64 p_api_version IN NUMBER
65 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
66 ,x_return_status OUT NOCOPY VARCHAR2
67 ,x_msg_count OUT NOCOPY NUMBER
68 ,x_msg_data OUT NOCOPY VARCHAR2
69 ,p_catv_rec IN catv_rec_type
70 ,x_catv_rec OUT NOCOPY catv_rec_type);
71
72 PROCEDURE delete_cash_allctn_rls(
73 p_api_version IN NUMBER
74 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 ,x_msg_data OUT NOCOPY VARCHAR2
78 ,p_catv_tbl IN catv_tbl_type);
79
80 PROCEDURE delete_cash_allctn_rls(
81 p_api_version IN NUMBER
82 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 ,p_catv_rec IN catv_rec_type);
87
88 PROCEDURE validate_cash_allctn_rls(
89 p_api_version IN NUMBER
90 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
91 ,x_return_status OUT NOCOPY VARCHAR2
92 ,x_msg_count OUT NOCOPY NUMBER
93 ,x_msg_data OUT NOCOPY VARCHAR2
94 ,p_catv_tbl IN catv_tbl_type);
95
96 PROCEDURE validate_cash_allctn_rls(
97 p_api_version IN NUMBER
98 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
99 ,x_return_status OUT NOCOPY VARCHAR2
100 ,x_msg_count OUT NOCOPY NUMBER
101 ,x_msg_data OUT NOCOPY VARCHAR2
102 ,p_catv_rec IN catv_rec_type);
103
104 END Okl_Cash_Allctn_Rls_Pub;