[Home] [Help]
PACKAGE: APPS.OKL_AUTO_INSURANCE_PVT
Source
1 PACKAGE OKL_AUTO_INSURANCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRICXS.pls 115.4 2002/12/18 12:47:53 kjinger noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 TYPE id_rec_type IS RECORD (
8 CONTRACT_NUMBER VARCHAR2(120) := OKC_API.G_MISS_NUM,
9 START_DATE DATE := OKC_API.G_MISS_DATE
10 );
11
12
13
14 TYPE policy_tbl_type IS TABLE OF id_rec_type INDEX BY BINARY_INTEGER;
15 SUBTYPE ipyv_rec_type IS Okl_ins_quote_Pub.ipyv_rec_type;
16
17 SUBTYPE inav_rec_type IS Okl_Ina_Pvt.inav_rec_type;
18 /*
19 TYPE iasset_rec_type IS RECORD (
20 KLE_ID NUMBER := OKC_API.G_MISS_NUM,
21 premium NUMBER := OKC_API.G_MISS_NUM
22 );
23 TYPE iasset_tbl_type IS TABLE OF iasset_rec_type INDEX BY BINARY_INTEGER;
24 */
25 ---------------------------------------------------------------------------
26 -- GLOBAL MESSAGE CONSTANTS
27 ---------------------------------------------------------------------------
28 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
29 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
30 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
31 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
32 G_COL_VALUE_TOKEN CONSTANT VARCHAR2(200) := 'COL_VALUE';
33 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
34 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
35 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
36 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
37 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_PARENT_RECORD';
38 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
39 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
40 G_INVALID_QUOTE CONSTANT VARCHAR2(200) := 'OKL_QUOTE_INVALID';
41 G_INVALID_QUOTE_TYPE CONSTANT VARCHAR2(200) := 'OKL_QUOTE_TYPE_INVALID';
42 G_EXPIRED_QUOTE CONSTANT VARCHAR2(200) := 'OKL_QUOTE_EXPIRED';
43 G_NO_STREAM_REC_FOUND CONSTANT VARCHAR2(200) := 'OKL_NO_STREAM_REC_FOUND';
44 G_INVALID_CONTRACT CONSTANT VARCHAR2(200) := 'OKL_INVALID_CONTRACT';
45 G_K_NOT_ACTIVE CONSTANT VARCHAR2(200) := 'OKL_K_NOT_ACTIVE';
46 G_INVALID_FOR_ACTIVE_TYPE CONSTANT VARCHAR2(200) := 'OKL_INVALID_FOR_ACTIVE_TYPE';
47 G_INVALID_FOR_ACTIVE_STATUS CONSTANT VARCHAR2(200) := 'OKL_INVALID_FOR_ACTIVE_STATUS';
48 G_STREAM_ALREADY_ACTIVE CONSTANT VARCHAR2(200) := 'OKL_STREAM_ALREADY_ACTIVE';
49 G_INVALID_CONTRACT_LINE CONSTANT VARCHAR2(200) := 'OKL_INVALID_CONTRACT_LINE';
50 G_FND_LOOKUP_PAYMENT_FREQ CONSTANT VARCHAR2(200) := 'OKL_INS_PAYMENT_FREQUENCY';
51 G_NO_CAPITAL_AMOUNT CONSTANT VARCHAR2(200) := 'OKL_NO_CAPITAL_AMOUNT';
52 G_NO_SYSTEM_PROFILE CONSTANT VARCHAR2(200) := 'OKL_NO_SYSTEM_PROFILE';
53 G_SYS_PROFILE_NAME CONSTANT VARCHAR2(200) := 'OKL_SYS_PROFILE_NAME';
54 G_NO_INSURANCE CONSTANT VARCHAR2(200) := 'OKL_NO_INSURANCE';
55 G_NO_K_TERM CONSTANT VARCHAR2(200) := 'OKL_NO_K_TERM';
56 G_NO_K_OEC CONSTANT VARCHAR2(200) := 'OKL_NO_K_OEC';
57 G_NO_OEC CONSTANT VARCHAR2(200) := 'OKL_NO_OEC';
58 G_NO_KLE CONSTANT VARCHAR2(200) := 'OKL_NO_KLE';
59 G_NO_INS_CLASS CONSTANT VARCHAR2(200) := 'OKL_NO_INS_CLASS';
60 G_NOT_ACTIVE CONSTANT VARCHAR2(1) := 'A' ;
61 G_INVALID_INSURANCE_TERM CONSTANT VARCHAR2(200) := 'OKL_IPY_INVALID_DATERANGE';
62 ---------------------------------------------------------------------------
63 -- GLOBAL VARIABLES
64 ---------------------------------------------------------------------------
65 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AUTO_INSURANCE_PVT';
66 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
67 ---------------------------------------------------------------------------
68 -- GLOBAL EXCEPTION
69 ---------------------------------------------------------------------------
70 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
71 ---------------------------------------------------------------------------
72 -- Procedures and Functions
73 ---------------------------------------------------------------------------
74 PROCEDURE auto_ins_establishment(
75 errbuf OUT NOCOPY VARCHAR2,
76 retcode OUT NOCOPY NUMBER
77 );
78
79 PROCEDURE third_party_ins_followup(
80 errbuf OUT NOCOPY VARCHAR2,
81 retcode OUT NOCOPY NUMBER,
82 p_template_id IN NUMBER
83 );
84
85 PROCEDURE pol_exp_notification(
86 errbuf OUT NOCOPY VARCHAR2,
87 retcode OUT NOCOPY NUMBER ,
88 p_template_id IN NUMBER
89 ) ;
90
91
92 PROCEDURE pay_ins_payments
93 (
94 errbuf OUT NOCOPY VARCHAR2,
95 retcode OUT NOCOPY NUMBER
96 ,p_from_bill_date IN VARCHAR2
97 ,p_to_bill_date IN VARCHAR2
98 );
99
100 END OKL_AUTO_INSURANCE_PVT;