[Home] [Help]
PACKAGE: APPS.OKL_AM_CALC_QUOTE_PYMNT_PVT
Source
1 PACKAGE OKL_AM_CALC_QUOTE_PYMNT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRCQPS.pls 120.3 2005/10/30 04:32:44 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_CALC_QUOTE_PYMNT_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
11 G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
12 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16
17
18 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19
20 G_CURRENT_STATUS CONSTANT VARCHAR2(30) := 'CURRENT';
21 G_PROPOSED_STATUS CONSTANT VARCHAR2(30) := 'PROPOSED';
22
23 G_CASH_FLOW_TYPE CONSTANT VARCHAR2(30) := 'PAYMENT_SCHEDULE';
24
25 G_LINKED_SERVICE_LINE_TYPE CONSTANT VARCHAR2(30) := 'LINK_SERV_ASSET';
26
27 G_CONTRACT_OBJ_TYPE CONSTANT VARCHAR2(30) := 'LEASE_CONTRACT';
28 G_FIN_ASSET_OBJ_TYPE CONSTANT VARCHAR2(30) := 'FINANCIAL_ASSET_LINE';
29 G_SERVICE_LINE_OBJ_TYPE CONSTANT VARCHAR2(30) := 'SERVICE_LINE';
30 G_FEE_LINE_OBJ_TYPE CONSTANT VARCHAR2(30) := 'FEE_LINE';
31 G_SERV_ASSET_OBJ_TYPE CONSTANT VARCHAR2(30) := 'SERVICED_ASSET_LINE';
32
33 G_OBJECT_SRC_TABLE CONSTANT VARCHAR2(30) := 'OKL_TRX_QUOTES_B';
34
35 --Bug #3921591: pagarg +++ Rollover +++
36 -- constants for linked fee line type and fee asset line cash flow object type
37 G_LINKED_FEE_LINE_TYPE CONSTANT VARCHAR2(15) := 'LINK_FEE_ASSET';
38 G_FEE_ASSET_OBJ_TYPE CONSTANT VARCHAR2(15) := 'FEE_ASSET_LINE';
39
40 /*=======================================================================+
41 | Declare PUBLIC Data Types and Variables
42 +=======================================================================*/
43
44
45 TYPE pymt_smry_uv_rec_type IS RECORD (
46
47 --PAGARG Bug 4299668: Define Stream type id also.
48 p_strm_type_id NUMBER,
49 p_strm_type_code VARCHAR2(150),
50 p_curr_total NUMBER ,
51 p_prop_total NUMBER);
52
53 TYPE pymt_smry_uv_tbl_type IS TABLE OF pymt_smry_uv_rec_type INDEX BY BINARY_INTEGER;
54
55
56
57 /*========================================================================
58 | PUBLIC PROCEDURE get_payment_summary
59 |
60 | DESCRIPTION
61 | This procedure is used by the first payment screen to display payment
62 | summary information
63 |
64 | PSEUDO CODE/LOGIC
65 |
66 | PARAMETERS
67 | p_qte_id IN Quote ID
68 | x_pymt_smry_tbl OUT Payment Summary Table
69 | x_pymt_smry_tbl_count OUT Payment Summary Table Count
70 | x_total_curr_amt OUT Total Curernt Amount
71 | x_total_prop_amt OUT Total proposed Amount
72 |
73 | KNOWN ISSUES
74 |
75 | NOTES
76 |
77 |
78 | MODIFICATION HISTORY
79 | Date Author Description of Changes
80 | 14-OCT-2003 SECHAWLA Created
81 |
82 *=======================================================================*/
83
84 PROCEDURE get_payment_summary(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 x_return_status OUT NOCOPY VARCHAR2,
90 p_qte_id IN NUMBER,
91 x_pymt_smry_tbl OUT NOCOPY pymt_smry_uv_tbl_type,
92 x_pymt_smry_tbl_count OUT NOCOPY NUMBER,
93 x_total_curr_amt OUT NOCOPY NUMBER,
94 x_total_prop_amt OUT NOCOPY NUMBER) ;
95
96
97 /*========================================================================
98 | PUBLIC PROCEDURE calc_quote_payments
99 |
100 | DESCRIPTION
101 | This procedure calculates the revised payments for a partial
102 | termination quote
103 |
104 | PSEUDO CODE/LOGIC
105 |
106 | PARAMETERS
107 | p_quote_id IN Quote ID
108 |
109 | CALLS
110 | get_current_payments, calc_proposed_payments
111 |
112 | KNOWN ISSUES
113 |
114 | NOTES
115 |
116 |
117 | MODIFICATION HISTORY
118 | Date Author Description of Changes
119 | 14-OCT-2003 SECHAWLA Created
120 |
121 *=======================================================================*/
122 PROCEDURE calc_quote_payments(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_quote_id IN NUMBER);
129
130
131 END OKL_AM_CALC_QUOTE_PYMNT_PVT;