1 PACKAGE oks_code_hook AUTHID CURRENT_USER AS
2 /* $Header: OKSCCHKS.pls 120.5.12020000.2 2013/02/06 07:06:18 mchandak ship $ */
3
4 /* PROCEDURE
5 tax_trx_date This routine is used to set a Transaction Date to calculate tax.
6
7 INPUT PARAMETERS
8 p_chr_id Contract Header Id
9 p_cle_id Contract Line Id
10 p_hdr_start_date Contract Header Start Date
11 p_lin_start_date Contract Line Start Date
12
13 RETURN VALUE
14 x_hook 1 Hook has been used
15 0 Hook has not been used
16 -1 Error in Hook
17 x_date Transaction Date for calculating tax
18 */
19 PROCEDURE tax_trx_date
20 (p_chr_id IN NUMBER,
21 p_cle_id IN NUMBER,
22 p_hdr_start_date IN DATE,
23 p_lin_start_date IN DATE,
24 x_hook OUT NOCOPY NUMBER,
25 x_date OUT NOCOPY DATE
26 );
27
28 /*added for bug7668259*/
29 /*Procedure
30 billing_interface_st_date This routine is a client extension that lets the user
31 have different approach while running service contracts
32 main billing program.
33
34 PARAMETERS
35
36 RETURN VALUE
37 x_hook 1 Hook has been used
38 0 Hook has not been used
39 -1 Error in Hook
40 x_date Billing Interface Start Date
41 x_hint Type of Parallel Thread Processing
42 Only Value allowed is "FULL"*/
43
44 PROCEDURE billing_interface_st_date
45 (x_hook OUT NOCOPY NUMBER,
46 x_date OUT NOCOPY DATE,
47 x_hint OUT NOCOPY VARCHAR2);
48
49 /* Added by sjanakir for Bug# 5073827 */
50 /* PROCEDURE
51 calc_header_amt This routine is a client extension that lets the user have
52 different approach for calculating header amount and header tax.
53
54 PARAMETERS
55 p_contract_id Contract Header Id
56
57 RETURN VALUE
58 x_hook 1 Hook has been used
59 0 Hook has not been used
60 -1 Error in Hook
61 x_tax Header Tax Amount
62 x_total Total Contract Header Amount */
63
64 PROCEDURE calc_header_amt
65 (p_contract_id IN NUMBER,
66 x_hook OUT NOCOPY NUMBER,
67 x_tax OUT NOCOPY NUMBER,
68 x_total OUT NOCOPY NUMBER);
69
70 /* Added by cgopinee for bug #7687114
71 /* FUNCTION
72 custom_function This function can be used to derive any custom data specific to a contract.
73
74 INPUT PARAMETERS
75 p_chr_id Contract Header Id
76
77 RETURN VALUE
78 l_custom_value custom data to be derived by the customer.
79 */
80
81 FUNCTION custom_function
82 (p_chr_id IN NUMBER
83 )Return VARCHAR2;
84
85 /* Added by cgopinee for Bug#9166537*/
86 /* FUNCTION
87 date_asmblr_fn This function is an extension that lets the user have
88 additional conditional calls to api's to filter the contracts
89 upfront during the date assembler program rather than defining
90 them as functions in independent conditions.
91
92 PARAMETERS
93 p_chr_id contract_header_id,
94 p_k_num contract_number,
95 p_k_modifier contract_number_modifier,
96 p_k_end_date contract_end_date,
97 p_class IN VARCHAR2,
98 p_scs_code IN VARCHAR2,
99 p_k_estamount IN NUMBER,
100 p_sts_code IN VARCHAR2,
101 p_auth_orgid IN NUMBER
102
103
104 RETURN VALUE
105 'Y' OR 'N' */
106
107 FUNCTION date_asmblr_fn
108 (p_chr_id IN NUMBER,
109 p_k_num IN VARCHAR2,
110 p_k_modifier IN VARCHAR2,
111 p_k_end_date IN DATE,
112 p_class IN VARCHAR2,
113 p_scs_code IN VARCHAR2,
114 p_k_estamount IN NUMBER,
115 p_sts_code IN VARCHAR2,
116 p_auth_orgid IN NUMBER
117 )
118 RETURN VARCHAR2;
119
120 /*
121 Added by skuchima for bug#9724454
122 PARAMETERS
123
124 p_oks_cnt Number of contracts picked from interface table
125
126 RETURN VALUE
127 x_hook 0 Hook has not been used
128 x_hook 1 Hook has been used
129 x_hook -1 Error in Hook
130
131 The customer has to write their own logic for post processing after the OKCALERT workflow is launced in Renewal process.
132 */
133 PROCEDURE custom_da_prc(p_oks_cnt IN NUMBER,
134 x_hook OUT NOCOPY NUMBER
135 );
136
137 /*
138 Added by spingali for bug#13024593
139 PARAMETERS
140
141 p_id contract id;
142 p_canc_reason_code cancellation reason code;
143 p_new_sts_code New status code to be refelected in contract.
144
145 RETURN VALUE
146 x_hook 0 Hook has not been used
147 x_hook 1 Hook has been used
148 x_hook -1 Error in Hook
149
150 The customer has to write their own logic to return the contract status to which they want to set when a contract is declined.
151 */
152 PROCEDURE get_custom_status(p_id IN NUMBER,
153 p_canc_reason_code IN varchar2,
154 p_term_cancel_source IN varchar2,
155 p_new_sts_code OUT NOCOPY varchar2 ,
156 x_hook OUT NOCOPY NUMBER
157 );
158
159 /*
160 Added by spingali for bug#14056524
161 PARAMETERS
162
163 req_id
164 set_number
165 process code
166
167 RETURN VALUE
168 x_hook 0 Hook has not been used
169 x_hook 1 Hook has been used
170 x_hook -1 Error in Hook
171
172 The customer has to write their own logic to update the TAS with the information updated in OKS during customer Merge.
173 */
174 PROCEDURE Update_Merge_Account(req_id IN NUMBER
175 ,set_number IN NUMBER
176 ,process_mode IN VARCHAR2
177 ,x_hook OUT NOCOPY NUMBER
178 );
179
180 /*
181 Added by spingali for bug#14056524
182 PARAMETERS
183
184 p_entity_name VARCHAR2 - Name of the entity that is being merged
185 p_from_id NUMBER - Id of the record that is being merged
186 p_from_fk_id NUMBER - Id of the Old Parent
187 p_to_fk_id NUMBER - Id of the New Parent
188 p_parent_entity_name VARCHAR2 - Parent entity name
189 p_batch_id NUMBER - Id of the Batch
190 p_batch_party_id NUMBER - Id of the batch and party record
191
192 RETURN VALUE
193 x_hook 0 Hook has not been used
194 x_hook 1 Hook has been used
195 x_hook -1 Error in Hook
196
197 The customer has to write their own logic to update the TAS with the information updated in OKS during Party Merge.
198 */
199
200 Procedure Update_Party_Merge(
201 p_entity_name IN VARCHAR2,
202 p_from_id IN NUMBER,
203 p_from_fk_id IN NUMBER,
204 p_to_fk_id IN NUMBER,
205 p_parent_entity_name IN VARCHAR2,
206 p_batch_id IN NUMBER,
207 p_batch_party_id IN NUMBER,
208 x_hook OUT NOCOPY VARCHAR2) ;
209
210
211 /*
212 Added by VGUJARAT for bug#14404570
213 PARAMETERS
214
215 p_column - VARCHAR2 - Determines the type of data to be retrieved
216 P_LSE_ID - NUMBER - Line type
217 p_sub_line_id - NUMBER - Contract Subline Id
218 p_chr_id - NUMBER - Contract Header Id
219
220 RETURN VALUE - VARCHAR2 - Source Transaction Information
221
222 Following function is used as part of VRM project to retrieve the source transaction information.
223 */
224
225 FUNCTION get_contract_source_details(p_column IN VARCHAR2,
226 P_LSE_ID IN NUMBER,
227 p_sub_line_id IN NUMBER ,
228 p_chr_id IN number)
229 RETURN VARCHAR2;
230
231 /*
232 Added by SKUCHIMA for bug#14576343
233 PARAMETERS
234 p_cle_id - NUMBER - Contract line Id
235 RETURN VALUE - NUMBER
236 Following function is used as part of VRM project to retrieve the quantity for subscription line.
237 */
238
239 function get_subs_qty
240 ( p_cle_id IN NUMBER
241 ) RETURN number ;
242
243 /*
244 Added by SKUCHIMA for bug#14576343
245 PARAMETERS
246 p_cle_id - NUMBER - Contract line Id
247 RETURN VALUE - VARCHAR2
248 Following function is used as part of VRM project to retrieve the UOM code for subscription line.
249 */
250 function get_subs_uom
251 ( p_cle_id IN NUMBER
252 ) RETURN varchar2 ;
253
254
255
256 END oks_code_hook;