1 PACKAGE okl_ins_claims_pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPCLMS.pls 115.4 2002/08/23 18:25:52 rgalipo noship $ */
3
4
5
6
7 subtype CLMv_rec_type is okl_CLM_pvt.CLMv_rec_type;
8 subtype CLMv_tbl_type is okl_CLM_pvt.CLMv_tbl_type;
9 ------------------------------------------------------------------------------
10 -- Global Variables
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INS_CLAIMS_PUB';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16 ------------------------------------------------------------------------------
17 --Global Exception
18 ------------------------------------------------------------------------------
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ------------------------------------------------------------------------------
21
22
23 PROCEDURE insert_INS_CLAIMS(
24 p_api_version IN NUMBER
25 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
26 ,x_return_status OUT NOCOPY VARCHAR2
27 ,x_msg_count OUT NOCOPY NUMBER
28 ,x_msg_data OUT NOCOPY VARCHAR2
29 ,p_CLMv_tbl IN CLMv_tbl_type
30 ,x_CLMv_tbl OUT NOCOPY CLMv_tbl_type);
31
32 PROCEDURE insert_INS_CLAIMS(
33 p_api_version IN NUMBER
34 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 ,p_CLMv_rec IN CLMv_rec_type
39 ,x_CLMv_rec OUT NOCOPY CLMv_rec_type);
40
41 PROCEDURE lock_INS_CLAIMS(
42 p_api_version IN NUMBER
43 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
44 ,x_return_status OUT NOCOPY VARCHAR2
45 ,x_msg_count OUT NOCOPY NUMBER
46 ,x_msg_data OUT NOCOPY VARCHAR2
47 ,p_CLMv_tbl IN CLMv_tbl_type);
48
49 PROCEDURE lock_INS_CLAIMS(
50 p_api_version IN NUMBER
51 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
52 ,x_return_status OUT NOCOPY VARCHAR2
53 ,x_msg_count OUT NOCOPY NUMBER
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 ,p_CLMv_rec IN CLMv_rec_type);
56
57 PROCEDURE update_INS_CLAIMS(
58 p_api_version IN NUMBER
59 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 ,p_CLMv_tbl IN CLMv_tbl_type
64 ,x_CLMv_tbl OUT NOCOPY CLMv_tbl_type);
65
66 PROCEDURE update_INS_CLAIMS(
67 p_api_version IN NUMBER
68 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 ,p_CLMv_rec IN CLMv_rec_type
73 ,x_CLMv_rec OUT NOCOPY CLMv_rec_type);
74
75 PROCEDURE delete_INS_CLAIMS(
76 p_api_version IN NUMBER
77 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 ,p_CLMv_tbl IN CLMv_tbl_type);
82
83 PROCEDURE delete_INS_CLAIMS(
84 p_api_version IN NUMBER
85 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
86 ,x_return_status OUT NOCOPY VARCHAR2
87 ,x_msg_count OUT NOCOPY NUMBER
88 ,x_msg_data OUT NOCOPY VARCHAR2
89 ,p_CLMv_rec IN CLMv_rec_type);
90
91 PROCEDURE validate_INS_CLAIMS(
92 p_api_version IN NUMBER
93 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 ,p_CLMv_tbl IN CLMv_tbl_type);
98
99 PROCEDURE validate_INS_CLAIMS(
100 p_api_version IN NUMBER
101 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
102 ,x_return_status OUT NOCOPY VARCHAR2
103 ,x_msg_count OUT NOCOPY NUMBER
104 ,x_msg_data OUT NOCOPY VARCHAR2
105 ,p_CLMv_rec IN CLMv_rec_type);
106
107 END okl_ins_claims_pub;