[Home] [Help]
PACKAGE: APPS.OKL_LEASE_QUOTE_INS_PVT
Source
1 PACKAGE OKL_LEASE_QUOTE_INS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRQUIS.pls 120.1.12020000.2 2012/08/07 13:30:54 rpillay ship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_LEASE_QUOTE_INS_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;
9 G_API_VERSION CONSTANT NUMBER := 1;
10 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
11 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
12 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
18 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
19 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
20 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLCODE';
21 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLERRM';
22
23 TYPE ins_est_rec_type IS RECORD (
24 id NUMBER
25 ,ovn NUMBER
26 ,quote_type_code VARCHAR2(30) -- mandatory Allowable values: 'LQ' 'LA'
27 ,lease_quote_id NUMBER
28 ,policy_term BINARY_INTEGER
29 ,stream_type_id NUMBER
30 ,payment_frequency VARCHAR2(1)
31 ,periodic_amount NUMBER
32 ,cashflow_object_id NUMBER -- mandatory for update
33 ,cashflow_header_id NUMBER -- mandatory for update
34 ,cashflow_header_ovn NUMBER -- mandatory for update
35 ,cashflow_level_id NUMBER -- mandatory for update
36 ,cashflow_level_ovn NUMBER -- mandatory for update
37 ,description VARCHAR2(240)
38 --Bug 6935907-Added by kkorrapo
39 ,attribute_category VARCHAR2(90)
40 ,attribute1 VARCHAR2(450)
41 ,attribute2 VARCHAR2(450)
42 ,attribute3 VARCHAR2(450)
43 ,attribute4 VARCHAR2(450)
44 ,attribute5 VARCHAR2(450)
45 ,attribute6 VARCHAR2(450)
46 ,attribute7 VARCHAR2(450)
47 ,attribute8 VARCHAR2(450)
48 ,attribute9 VARCHAR2(450)
49 ,attribute10 VARCHAR2(450)
50 ,attribute11 VARCHAR2(450)
51 ,attribute12 VARCHAR2(450)
52 ,attribute13 VARCHAR2(450)
53 ,attribute14 VARCHAR2(450)
54 ,attribute15 VARCHAR2(450)
55 --Bug 6935907-Addition end
56 );
57
58 ----------------
59 -- PROGRAM UNITS
60 ----------------
61 PROCEDURE create_insurance_estimate (
62 p_api_version IN NUMBER
63 ,p_init_msg_list IN VARCHAR2
64 ,p_transaction_control IN VARCHAR2
65 ,p_insurance_estimate_rec IN ins_est_rec_type
66 ,x_insurance_estimate_id OUT NOCOPY NUMBER
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 );
71
72
73 PROCEDURE update_insurance_estimate (
74 p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2
76 ,p_transaction_control IN VARCHAR2
77 ,p_insurance_estimate_rec IN ins_est_rec_type
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83
84 PROCEDURE delete_insurance_estimate (
85 p_api_version IN NUMBER
86 ,p_init_msg_list IN VARCHAR2
87 ,p_transaction_control IN VARCHAR2
88 ,p_insurance_estimate_id IN NUMBER
89 ,x_return_status OUT NOCOPY VARCHAR2
90 ,x_msg_count OUT NOCOPY NUMBER
91 ,x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94 --Added by jjuneja
95 PROCEDURE duplicate_insurance_estimate (
96 p_api_version IN NUMBER
97 ,p_init_msg_list IN VARCHAR2
98 ,p_transaction_control IN VARCHAR2
99 ,p_source_insurance_id IN NUMBER
100 ,p_target_quote_id IN NUMBER
101 ,x_insurance_est_id OUT NOCOPY NUMBER
102 ,x_return_status OUT NOCOPY VARCHAR2
103 ,x_msg_count OUT NOCOPY NUMBER
104 ,x_msg_data OUT NOCOPY VARCHAR2 );
105
106 --End of addition by jjuneja
107
108 END OKL_LEASE_QUOTE_INS_PVT;