[Home] [Help]
PACKAGE: APPS.OKL_CS_LC_CONTRACT_PVT
Source
1 PACKAGE Okl_Cs_Lc_Contract_Pvt AS
2 /* $Header: OKLRLCRS.pls 120.10 2008/02/19 05:26:53 asawanka noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
10 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
11 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
12 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
16 ---------------------------------------------------------------------------
17 -- GLOBAL VARIABLES
18 ---------------------------------------------------------------------------
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_INFO_PVT';
20 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
21
22 ---------------------------------------------------------------------------
23 -- GLOBAL DECLARATION
24 ---------------------------------------------------------------------------
25 SUBTYPE deal_tbl_type IS okl_deal_create_pub.deal_tab_type;
26
27 PROCEDURE next_due(p_contract_id IN NUMBER,
28 o_next_due_amt OUT NOCOPY NUMBER,
29 o_next_due_date OUT NOCOPY DATE);
30 PROCEDURE last_due(p_customer_id IN NUMBER,
31 p_contract_id IN NUMBER,
32 o_last_due_amt OUT NOCOPY NUMBER,
33 o_last_due_date OUT NOCOPY DATE);
34 PROCEDURE total_asset_cost(p_contract_id IN NUMBER,
35 o_asset_cost OUT NOCOPY NUMBER);
36 PROCEDURE total_subsidy_cost(p_contract_id IN NUMBER,
37 o_subsidy_cost OUT NOCOPY NUMBER);
38 PROCEDURE out_standing_rcvble(p_contract_id IN NUMBER,
39 o_rcvble_amt OUT NOCOPY NUMBER);
40 --varangan added for bug#5036582 start
41 PROCEDURE outstanding_billed_amt(p_contract_id IN NUMBER,
42 o_billed_amt OUT NOCOPY NUMBER);
43 PROCEDURE outstanding_unbilled_amt(p_contract_id IN NUMBER,
44 o_unbilled_amt OUT NOCOPY NUMBER);
45 --bug#5036582 end
46 PROCEDURE contract_dates(p_contract_id IN NUMBER,
47 o_start_date OUT NOCOPY DATE,
48 o_end_date OUT NOCOPY DATE,
49 o_term_duration OUT NOCOPY NUMBER);
50 PROCEDURE rent_security_interest(p_contract_id IN NUMBER,
51 o_advance_rent OUT NOCOPY NUMBER,
52 o_security_deposit OUT NOCOPY NUMBER,
53 o_interest_type OUT NOCOPY VARCHAR2);
54 PROCEDURE notes(p_contract_id IN NUMBER,
55 o_notes OUT NOCOPY VARCHAR2
56 );
57 FUNCTION get_vendor_program(
58 p_contract_id IN NUMBER,
59 x_vendor_program OUT NOCOPY VARCHAR2)
60 RETURN VARCHAR2;
61 -- Returns Private Label as a String namely URL
62 FUNCTION get_private_label(
63 p_contract_id IN NUMBER,
64 x_private_label OUT NOCOPY VARCHAR2)
65 RETURN VARCHAR2;
66 -- Returns Currency Code
67 FUNCTION get_currency(
68 p_contract_id IN NUMBER,
69 x_currency OUT NOCOPY VARCHAR2)
70 RETURN VARCHAR2;
71
72 -- Returns "Y" or "N"
73 FUNCTION get_syndicate_flag(
74 p_contract_id IN NUMBER,
75 x_syndicate_flag OUT NOCOPY VARCHAR2)
76 RETURN VARCHAR2;
77
78 -- Returns org ID
79 FUNCTION GET_ORG_ID(
80 p_contract_id IN NUMBER,
81 x_org_id OUT NOCOPY NUMBER
82 )
83 RETURN VARCHAR2;
84
85 FUNCTION GET_resource_ID(
86 x_res_id OUT NOCOPY NUMBER
87 )
88 RETURN VARCHAR2;
89
90 FUNCTION get_warning_message(
91 p_contract_id IN NUMBER,
92 x_delinquent_flag OUT NOCOPY VARCHAR2,
93 x_bankrupt_flag OUT NOCOPY VARCHAR2,
94 x_syndicate_flag OUT NOCOPY VARCHAR2,
95 x_special_handling_flag OUT NOCOPY VARCHAR2
96 )
97 RETURN VARCHAR2;
98
99 FUNCTION Get_K_Access_Level(p_chr_id IN NUMBER,
100 p_scs_code IN VARCHAR2 DEFAULT NULL)
101 RETURN VARCHAR2;
102
103 PROCEDURE note_context_info (
104 p_sql_statement IN VARCHAR2,
105 -- SPILLAIP -2689257 - Start
106 p_object_info IN OUT NOCOPY VARCHAR2,
107 -- SPILLAIP -2689257 - End
108 p_object_id IN NUMBER);
109
110 FUNCTION note_context_info (
111 p_select_id VARCHAR2,
112 p_select_name VARCHAR2,
113 p_select_details VARCHAR2,
114 p_from_table VARCHAR2,
115 p_where_clause VARCHAR2,
116 p_object_id NUMBER)
117 RETURN VARCHAR2;
118
119 FUNCTION party_type_info (
120 p_object_id NUMBER)
121 RETURN VARCHAR2;
122
123 FUNCTION read_clob (
124 p_clob CLOB)
125 RETURN VARCHAR2;
126
127 FUNCTION read_clob (
128 p_note_id NUMBER)
129 RETURN VARCHAR2;
130
131 FUNCTION get_contract_status(
132 p_contract_id IN NUMBER,
133 p_working_mode IN VARCHAR2 DEFAULT 'QUERY',
134 p_contract_status OUT NOCOPY VARCHAR2,
135 x_allowed OUT NOCOPY VARCHAR2)
136 RETURN VARCHAR2;
137 FUNCTION contract_cust_accounts( p_cust_acct_id IN NUMBER,
138 x_no_contracts OUT NOCOPY NUMBER
139 ) RETURN VARCHAR2;
140 PROCEDURE EXECUTE(p_api_version IN NUMBER
141 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
142 ,x_return_status OUT NOCOPY VARCHAR2
143 ,x_msg_count OUT NOCOPY NUMBER
144 ,x_msg_data OUT NOCOPY VARCHAR2
145 ,p_formula_name IN VARCHAR2
146 ,p_contract_id IN NUMBER
147 ,x_value OUT NOCOPY NUMBER
148 );
149
150 PROCEDURE update_deal(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_durv_tbl IN deal_tbl_type,
157 x_durv_tbl OUT NOCOPY deal_tbl_type
158 );
159
160 PROCEDURE commit_update;
161
162 PROCEDURE contract_securitized(
163 p_contract_id IN NUMBER
164 ,x_value OUT NOCOPY VARCHAR2
165 );
166
167 -- Added by rkuttiya for OKL.H
168 FUNCTION Get_Total_Tax_Amount(p_trx_id IN NUMBER) RETURN NUMBER;
169
170 -- Added by rkuttiya in 11i OKL.H for Rebook Enhancements
171 FUNCTION Get_Total_Stream_Amount(p_khr_id IN NUMBER,
172 p_kle_id IN NUMBER,
173 p_sty_id IN NUMBER)
174 RETURN NUMBER;
175
176 --dkagrawa added the function for bug # 4723838
177 FUNCTION get_asset_number(p_kle_id IN NUMBER)
178 RETURN VARCHAR2;
179 --dkagrawa added following function for okl12b to get the tax amount per line
180 FUNCTION get_ap_line_tax(p_invoice_id IN NUMBER, p_line_number IN NUMBER)
181 RETURN NUMBER;
182 --asawanka added for ebtax project
183 FUNCTION get_tax_sch_Req_flag(
184 p_contract_id IN NUMBER)
185 RETURN VARCHAR2;
186
187 -- zrehman added for Forward Port Bug#5759229
188 FUNCTION get_cov_asset_id(p_kle_id IN NUMBER)
189 RETURN NUMBER;
190
191 FUNCTION get_payment_remaining(p_khr_id IN NUMBER) RETURN VARCHAR2;
192 FUNCTION get_term_remaining(p_khr_id IN NUMBER) RETURN NUMBER;
193
194 FUNCTION get_total_billed(p_khr_id IN NUMBER) RETURN NUMBER;
195 FUNCTION get_total_paid_credited(p_khr_id IN NUMBER) RETURN NUMBER;
196 FUNCTION get_total_remaining(p_khr_id IN NUMBER) RETURN NUMBER;
197
198
199 END Okl_Cs_Lc_Contract_Pvt;