1 PACKAGE okl_ins_policies_pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPIPYS.pls 120.5 2008/02/29 10:50:31 nikshah ship $ */
3 /*#
4 * Insurance Policy API allows users to perform actions on
5 * third party policies in Lease Management.
6 * @rep:scope public
7 * @rep:product OKL
8 * @rep:displayname Insurance Policy API
9 * @rep:category BUSINESS_ENTITY OKL_RISK_MANAGEMENT
10 * @rep:lifecycle active
11 * @rep:compatibility S
12 */
13
14
15 subtype ipyv_rec_type is okl_ipy_pvt.ipyv_rec_type;
16 subtype ipyv_tbl_type is okl_ipy_pvt.ipyv_tbl_type;
17 ------------------------------------------------------------------------------
18 -- Global Variables
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INS_POLICIES_PUB';
20 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
21 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
22 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
23 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
24 ------------------------------------------------------------------------------
25 --Global Exception
26 ------------------------------------------------------------------------------
27 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
28 ------------------------------------------------------------------------------
29 PROCEDURE insert_ins_policies(
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_ipyv_tbl IN ipyv_tbl_type
36 ,x_ipyv_tbl OUT NOCOPY ipyv_tbl_type);
37
38 /*#
39 * Create third party insurance policy.
40 * @param p_api_version API version
41 * @param p_init_msg_list Initialize message stack
42 * @param x_return_status Return status from the API
43 * @param x_msg_count Message count if error messages are encountered
44 * @param x_msg_data Error message data
45 * @param p_ipyv_rec Insurance policy record
46 * @param x_ipyv_rec Insurance policy record
47 * @rep:displayname Create Insurance Policy
48 * @rep:scope public
49 * @rep:lifecycle active
50 */
51 PROCEDURE insert_ins_policies(
52 p_api_version IN NUMBER
53 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 ,p_ipyv_rec IN ipyv_rec_type
58 ,x_ipyv_rec OUT NOCOPY ipyv_rec_type);
59 PROCEDURE lock_ins_policies(
60 p_api_version IN NUMBER
61 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_msg_count OUT NOCOPY NUMBER
64 ,x_msg_data OUT NOCOPY VARCHAR2
65 ,p_ipyv_tbl IN ipyv_tbl_type);
66 PROCEDURE lock_ins_policies(
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_ipyv_rec IN ipyv_rec_type);
73 PROCEDURE update_ins_policies(
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_ipyv_tbl IN ipyv_tbl_type
80 ,x_ipyv_tbl OUT NOCOPY ipyv_tbl_type);
81 PROCEDURE update_ins_policies(
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_ipyv_rec IN ipyv_rec_type
88 ,x_ipyv_rec OUT NOCOPY ipyv_rec_type);
89 PROCEDURE delete_ins_policies(
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_ipyv_tbl IN ipyv_tbl_type);
96 PROCEDURE delete_ins_policies(
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_ipyv_rec IN ipyv_rec_type);
103 PROCEDURE validate_ins_policies(
104 p_api_version IN NUMBER
105 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
106 ,x_return_status OUT NOCOPY VARCHAR2
107 ,x_msg_count OUT NOCOPY NUMBER
108 ,x_msg_data OUT NOCOPY VARCHAR2
109 ,p_ipyv_tbl IN ipyv_tbl_type);
110 PROCEDURE validate_ins_policies(
111 p_api_version IN NUMBER
112 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
113 ,x_return_status OUT NOCOPY VARCHAR2
114 ,x_msg_count OUT NOCOPY NUMBER
115 ,x_msg_data OUT NOCOPY VARCHAR2
116 ,p_ipyv_rec IN ipyv_rec_type);
117 END okl_ins_policies_pub;