[Home] [Help]
PACKAGE: APPS.OKL_LEASE_QUOTE_PVT
Source
1 PACKAGE OKL_LEASE_QUOTE_PVT AS
2 /* $Header: OKLRLSQS.pls 120.6 2007/08/08 21:11:02 rravikir noship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_LEASE_QUOTE_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 ------------------
24 -- DATA STRUCTURES
25 ------------------
26 SUBTYPE lease_qte_rec_type IS okl_lsq_pvt.lsqv_rec_type;
27 SUBTYPE lease_qte_tbl_type IS okl_lsq_pvt.lsqv_tbl_type;
28
29 SUBTYPE lease_qte_fee_rec_type IS okl_fee_pvt.feev_rec_type;
30
31 ----------------
32 -- PROGRAM UNITS
33 ----------------
34 PROCEDURE create_lease_qte (p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2,
36 p_transaction_control IN VARCHAR2,
37 p_lease_qte_rec IN lease_qte_rec_type,
38 x_lease_qte_rec OUT NOCOPY lease_qte_rec_type,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2);
42
43
44 PROCEDURE update_lease_qte (p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2,
46 p_transaction_control IN VARCHAR2,
47 p_lease_qte_rec IN lease_qte_rec_type,
48 x_lease_qte_rec OUT NOCOPY lease_qte_rec_type,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2);
52
53
54 PROCEDURE duplicate_lease_qte (p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2,
56 p_transaction_control IN VARCHAR2,
57 p_source_quote_id IN NUMBER,
58 p_lease_qte_rec IN lease_qte_rec_type,
59 x_lease_qte_rec OUT NOCOPY lease_qte_rec_type,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2);
63
64 PROCEDURE duplicate_lease_qte (p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2,
66 p_transaction_control IN VARCHAR2,
67 p_quote_id IN NUMBER,
68 x_lease_qte_rec OUT NOCOPY lease_qte_rec_type,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2);
72
73 PROCEDURE duplicate_quotes(p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2,
75 p_transaction_control IN VARCHAR2,
76 p_source_leaseopp_id IN NUMBER,
77 p_target_leaseopp_id IN NUMBER,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2);
81
82 PROCEDURE cancel_lease_qte (p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2,
84 p_transaction_control IN VARCHAR2,
85 p_lease_qte_tbl IN lease_qte_tbl_type,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2);
89
90 PROCEDURE submit_lease_qte (p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2,
92 p_transaction_control IN VARCHAR2,
93 p_quote_id IN NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2);
97
98 PROCEDURE accept_lease_qte (p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2,
100 p_transaction_control IN VARCHAR2,
101 p_quote_id IN NUMBER,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2);
105
106 PROCEDURE validate_lease_qte (p_lease_qte_rec IN lease_qte_rec_type,
107 x_return_status OUT NOCOPY VARCHAR2);
108
109 PROCEDURE unaccept_lease_qte (p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2,
111 p_transaction_control IN VARCHAR2,
112 p_quote_id IN NUMBER,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2);
116
117 PROCEDURE change_pricing(p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2,
119 p_transaction_control IN VARCHAR2,
120 p_quote_id IN NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2);
124
125 PROCEDURE calculate_sales_tax(p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_transaction_control IN VARCHAR2,
131 p_quote_id IN NUMBER);
132
133 END OKL_LEASE_QUOTE_PVT;