[Home] [Help]
PACKAGE: APPS.OKS_BILL_MIGRATION
Source
1 PACKAGE OKS_BILL_MIGRATION AS
2 /* $Header: OKSBMIGS.pls 120.0 2005/05/25 17:39:29 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
9 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
10 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
11 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
12 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
20 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
21 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
22 G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKC_INVALID_END_DATE';
23 --
24 G_QA_SUCCESS CONSTANT VARCHAR2(200) := 'OKS__QA_SUCCESS';
25 G_PARTY_COUNT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_PARTY_COUNT';
26 G_REQUIRED_RULE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE';
27 G_REQUIRED_RULE_VALUES CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_VALUES';
28 G_REQUIRED_RULE_PARTY_ROLE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_PARTY_ROLE';
29 G_RULE_DEPENDENT_VALUE CONSTANT VARCHAR2(200) := 'OKC_RULE_DEPENDENT_VALUE';
30 G_INVALID_LINE_DATES CONSTANT VARCHAR2(200) := 'OKC_INVALID_LINE_DATES';
31 G_REQUIRED_LINE_VALUE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_LINE_FIELD';
32 G_INVALID_LINE_CURRENCY CONSTANT VARCHAR2(200) := 'OKC_INVALID_LINE_CURRENCY';
33 G_INVALID_LINE_ITEM CONSTANT VARCHAR2(200) := 'OKS_INVALID_LINE_ITEM';
34 G_REQUIRED_COVERED_LINE CONSTANT VARCHAR2(200) := 'OKS_REQUIRED_COVERED_LINE';
35 G_INVALID_COVERAGE_LINE CONSTANT VARCHAR2(200) := 'OKS_INVALID_COVERAGE_LINE';
36 G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'OKS_COVERAGE_OVERLAP';
37 G_PARTY_ROLE CONSTANT VARCHAR2(200) := 'OKS_PARTY_ROLE';
38 G_BASE_READING CONSTANT VARCHAR2(200) := 'OKS_COUNTER_BASE_READING';
39 G_BILL_ATTR CONSTANT VARCHAR2(200) := 'OKS_BILLING_ATTRIBUTES';
40 G_SHORT_DESC CONSTANT VARCHAR2(200) := 'OKS_HDR_SHORT_DESC';
41 G_QA_CHECK CONSTANT VARCHAR2(200) := 'OKS_QA_CHECK_LIST';
42 G_K_GROUP CONSTANT VARCHAR2(200) := 'OKS_CONTRACT_GROUP';
43 G_WORKFLOW CONSTANT VARCHAR2(200) := 'OKS_WORK_FLOW';
44 G_DEFAULT_READING CONSTANT VARCHAR2(200) := 'OKS_COUNTER_DEFAULT_READING';
45 G_PRICE_LIST CONSTANT VARCHAR2(200) := 'OKS_PRICE_LIST';
46
47 G_ONE_CUST_CONTACT CONSTANT VARCHAR2(200) := 'OKS_ONE_CUST_CONTACT';
48 G_INVALID_TAX_EXEMPT CONSTANT VARCHAR2(200) := 'OKS_INVALID_TAX_EXEMPT';
49 G_CUSTOMER_ON_CREDIT_HOLD CONSTANT VARCHAR2(200) := 'OKS_CUST_ON_CREDIT_HOLD';
50 G_REQUIRED_FIELD CONSTANT VARCHAR2(200) := 'OKS_REQUIRED_FIELD';
51 G_AUTHORIZE_PAYMENT CONSTANT VARCHAR2(200) := 'AUTHORIZE_PAYMENT';
52 G_PRECESION CONSTANT NUMBER := .01;
53 G_Return_Status Varchar2(1) := 'S';
54
55 TYPE numeric_tab_typ IS TABLE of number INDEX BY BINARY_INTEGER;
56
57 ------------------------------------------------------------------------------------
58 -- GLOBAL EXCEPTION
59 ---------------------------------------------------------------------------
60 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
61
62 -- GLOBAL VARIABLES
63 ---------------------------------------------------------------------------
64 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_QA_DATA_INTEGRITY';
65 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
66 ---------------------------------------------------------------------------
67
68 TYPE bill_cont_type IS RECORD
69 (cle_id oks_bill_cont_lines.cle_id%type,
70 amount oks_bill_cont_lines.amount%type);
71
72 TYPE bill_cont_tbl IS TABLE of bill_cont_type index by binary_integer;
73
74
75 /********************* Rules Rearch *************************
76 PROCEDURE update_lvl_elements
77 (
78 p_lvl_element_tbl IN oks_bill_level_elements_pvt.letv_tbl_type
79 ,x_lvl_element_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_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 ********************* Rules Rearch *************************/
86 /********************* Rules Rearch *************************
87
88 FUNCTION Create_Timevalue (p_chr_id IN NUMBER,p_start_date IN DATE) RETURN NUMBER;
89
90 ********************* Rules Rearch *************************/
91
92
93 PROCEDURE BILL_UPGRADATION
94 (
95 p_chr_id_lo IN NUMBER DEFAULT NULL,
96 p_chr_id_hi IN NUMBER DEFAULT NULL
97 );
98
99
100
101 PROCEDURE BILL_UPGRADATION_OM
102 (
103 p_chr_id_lo IN NUMBER DEFAULT NULL,
104 p_chr_id_hi IN NUMBER DEFAULT NULL
105 );
106
107
108 PROCEDURE BILL_UPGRADATION_ALL
109 (
110 x_return_status OUT NOCOPY VARCHAR2
111 );
112
113 PROCEDURE BILL_UPGRADATION_ALL_OM
114 (
115 x_return_status OUT NOCOPY VARCHAR2
116 );
117
118 PROCEDURE Update_line_numbers
119 (
120 p_chr_id_lo IN NUMBER DEFAULT NULL,
121 p_chr_id_hi IN NUMBER DEFAULT NULL
122 );
123
124 PROCEDURE migrate_line_numbers
125 (
126 x_return_status OUT NOCOPY VARCHAR2
127 );
128
129
130 Procedure MIGRATE_CURRENCY;
131 /**********************************************************
132 PROCEDURE CREATE_BILL_DTLS_FOR_ORDER
133 ( p_dnz_chr_id IN NUMBER ,
134 x_return_status OUT NOCOPY VARCHAR2 ) ;
135 **************/
136
137 PROCEDURE CREATE_BILL_DTLS
138 ( p_dnz_chr_id IN number ,
139 p_top_line_id in number ,
140 p_top_line_start_date in date ,
141 p_top_line_end_date in date ,
142 p_top_line_UPG_ORIG_SYSTEM_REF in varchar2,
143 p_top_line_UPG_ORIG_SYSTEM_id in number,
144 p_top_line_date_terminated in date ,
145 x_return_status OUT NOCOPY varchar2 ) ;
146
147
148
149 procedure Create_Billing_Schd
150 (
151 P_srv_sdt IN Date
152 , P_srv_edt IN Date
153 , P_amount IN Number
154 , P_chr_id IN Number
155 , P_rule_id IN Varchar2
156 , P_line_id IN Number
157 , P_invoice_rule_id IN Number
158 , X_msg_data OUT NOCOPY Varchar2
159 , X_msg_count OUT NOCOPY Number
160 , X_Return_status OUT NOCOPY Varchar2
161 );
162
163
164
165 PROCEDURE UPDATE_OKS_LEVEL_ELEMENTS
166 ( p_dnz_chr_id IN NUMBER ,
167 x_return_status OUT NOCOPY VARCHAR2 ) ;
168
169 -----------------------------------------------------------------------------------------
170 -- Specification changes as part of rules Migration . --
171 -----------------------------------------------------------------------------------------
172
173
174 END OKS_BILL_MIGRATION;
175