[Home] [Help]
PACKAGE: APPS.OKL_INSURANCE_POLICIES_PUB
Source
1 PACKAGE OKL_INSURANCE_POLICIES_PUB AS
2 /* $Header: OKLPIPXS.pls 120.4 2007/09/13 18:34:57 smereddy ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 SUBTYPE ipyv_rec_type IS Okl_Ipy_Pvt.ipyv_rec_type;
8
9 ------------------------------------------------------------------------------
10 -- Global Variables
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 ---------------------------------------------------------------------------
16 -- GLOBAL VARIABLES
17 ---------------------------------------------------------------------------
18 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INSURANCE_POLICIES_PUB';
19 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
20 ---------------------------------------------------------------------------
21 -- GLOBAL EXCEPTION
22 ---------------------------------------------------------------------------
23 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24 ---------------------------------------------------------------------------
25 -- Procedures and Functions
26 ---------------------------------------------------------------------------
27
28
29
30
31 PROCEDURE cancel_policy(
32 p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_ipyv_rec IN ipyv_rec_type,
38 x_ipyv_rec OUT NOCOPY ipyv_rec_type
39 );
40
41 PROCEDURE delete_policy(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_ipyv_rec IN ipyv_rec_type,
48 x_ipyv_rec OUT NOCOPY ipyv_rec_type
49 );
50
51
52 PROCEDURE insert_ap_request(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_tap_id IN NUMBER,
59 p_credit_amount IN NUMBER,
60 p_credit_sty_id IN NUMBER,
61 p_khr_id IN NUMBER ,
62 p_kle_id IN NUMBER,
63 p_invoice_date IN DATE,
64 p_trx_id IN NUMBER
65
66 );
67
68 PROCEDURE cancel_create_policies(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_khr_id IN NUMBER,
75 p_cancellation_date IN DATE,
76 p_crx_code IN VARCHAR2 DEFAULT NULL, -- Effective Dated Term Qte changes
77 p_transaction_id IN NUMBER
78 );
79
80
81 -- 3945995 Start
82 PROCEDURE cancel_create_policies(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_khr_id IN NUMBER,
89 p_cancellation_date IN DATE,
90 p_crx_code IN VARCHAR2 DEFAULT NULL, --Effective Dated Term Qte changes
91 p_transaction_id IN NUMBER,
92 x_ignore_flag OUT NOCOPY VARCHAR2
93 );
94 -- 3945995 End
95
96 --+++++++++++++ Effective Dated Term Qte changes -- start +++++++++
97 PROCEDURE check_claims(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT Okc_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 x_clm_exist OUT NOCOPY VARCHAR2,
104 p_khr_id IN NUMBER,
105 p_trx_date IN DATE
106 );
107 --+++++++++++++ Effective Dated Term Qte changes -- End +++++++++
108
109 PROCEDURE cancel_policies(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_contract_id IN NUMBER,
116 p_cancellation_date IN DATE,
117 p_crx_code IN VARCHAR2 DEFAULT NULL ); --++++++++ Effective Dated Term Qte changes +++++++++
118
119
120 PROCEDURE insert_ap_request(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_tap_id IN NUMBER,
127 p_credit_amount IN NUMBER,
128 p_credit_sty_id IN NUMBER,
129 p_khr_id IN NUMBER ,
130 p_kle_id IN NUMBER,
131 p_invoice_date IN DATE,
132 p_trx_id IN NUMBER,
133 p_vendor_site_id IN NUMBER DEFAULT Okc_Api.G_MISS_NUM,
134 x_request_id OUT NOCOPY NUMBER
135 );
136
137 END OKL_INSURANCE_POLICIES_PUB;