[Home] [Help]
PACKAGE: APPS.OKL_LEASE_QUOTE_PRICING_PVT
Source
1 PACKAGE OKL_LEASE_QUOTE_PRICING_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRQUPS.pls 120.4 2005/11/23 06:30:10 asawanka noship $ */
3
4 SUBTYPE cashflow_hdr_rec_type IS okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
5 SUBTYPE cashflow_level_tbl_type IS okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
6
7 SUBTYPE lease_qte_rec_type IS okl_lsq_pvt.lsqv_rec_type;
8 SUBTYPE lease_qte_tbl_type IS okl_lsq_pvt.lsqv_tbl_type;
9
10 SUBTYPE fee_rec_type is okl_fee_pvt.feev_rec_type;
11 SUBTYPE asset_rec_type is okl_ass_pvt.assv_rec_type;
12
13 --------------------
14 -- PACKAGE CONSTANTS
15 --------------------
16 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_LEASE_QUOTE_PRICING_PVT';
17 G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;
18 G_API_TYPE CONSTANT VARCHAR2(30) := '_PVT';
19 G_API_VERSION CONSTANT NUMBER := 1;
20 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
21 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
22 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
25 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
27 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
28 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
29 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
30 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
31 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLCODE';
32 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLERRM';
33
34 ----------------
35 -- PROGRAM UNITS
36 ----------------
37 PROCEDURE validate (
38 p_api_version IN NUMBER
39 ,p_init_msg_list IN VARCHAR2
40 ,p_quote_id IN NUMBER
41 ,x_qa_result OUT NOCOPY VARCHAR2
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE price (
48 p_api_version IN NUMBER
49 ,p_init_msg_list IN VARCHAR2
50 ,p_quote_id IN NUMBER
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE calculate_tax(
57 p_api_version IN NUMBER
58 ,p_init_msg_list IN VARCHAR2
59 ,p_quote_id IN NUMBER
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 ) ;
64
65 PROCEDURE create_update_payment (
66 p_api_version IN NUMBER
67 ,p_init_msg_list IN VARCHAR2
68 ,p_lease_qte_rec IN lease_qte_rec_type
69 ,p_payment_header_rec IN cashflow_hdr_rec_type
70 ,p_payment_level_tbl IN cashflow_level_tbl_type
71 ,x_return_status OUT NOCOPY VARCHAR2
72 ,x_msg_count OUT NOCOPY NUMBER
73 ,x_msg_data OUT NOCOPY VARCHAR2
74 );
75
76 PROCEDURE create_update_payment (
77 p_api_version IN NUMBER
78 ,p_init_msg_list IN VARCHAR2
79 ,p_lease_qte_rec IN lease_qte_rec_type
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE create_update_line_payment (
86 p_api_version IN NUMBER
87 ,p_init_msg_list IN VARCHAR2
88 ,p_fee_rec IN fee_rec_type
89 ,p_asset_rec IN asset_rec_type
90 ,p_payment_header_rec IN cashflow_hdr_rec_type
91 ,p_payment_level_tbl IN cashflow_level_tbl_type
92 ,x_return_status OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER
94 ,x_msg_data OUT NOCOPY VARCHAR2
95 );
96
97 PROCEDURE create_update_line_payment (
98 p_api_version IN NUMBER
99 ,p_init_msg_list IN VARCHAR2
100 ,p_fee_rec IN fee_rec_type
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,x_msg_count OUT NOCOPY NUMBER
103 ,x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE create_update_line_payment (
107 p_api_version IN NUMBER
108 ,p_init_msg_list IN VARCHAR2
109 ,p_asset_rec IN asset_rec_type
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 );
114 PROCEDURE delete_line_payment(
115 p_api_version IN NUMBER
116 ,p_init_msg_list IN VARCHAR2
117 ,p_source_object_code IN VARCHAR2
118 ,p_source_object_id IN NUMBER
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_msg_count OUT NOCOPY NUMBER
121 ,x_msg_data OUT NOCOPY VARCHAR2
122 ) ;
123 PROCEDURE handle_parent_object_status(
124 p_api_version IN NUMBER
125 ,p_init_msg_list IN VARCHAR2
126 ,x_return_status OUT NOCOPY VARCHAR2
127 ,x_msg_count OUT NOCOPY NUMBER
128 ,x_msg_data OUT NOCOPY VARCHAR2
129 ,p_parent_object_code IN VARCHAR2
130 ,p_parent_object_id IN NUMBER
131 );
132 FUNCTION get_periods(
133 p_casflow_id IN NUMBER)
134 RETURN VARCHAR2 ;
135
136 FUNCTION get_amount(
137 p_casflow_id IN NUMBER)
138 RETURN VARCHAR2 ;
139
140 END OKL_LEASE_QUOTE_PRICING_PVT;