[Home] [Help]
PACKAGE: APPS.OKS_MASS_UPDATE_PVT
Source
1 PACKAGE OKS_MASS_UPDATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRMUPS.pls 120.14.12000000.1 2007/01/16 22:11:29 appldev ship $ */
3
4 ---------------------------------------------------------------------------
5 -- Constants used for Message Logging
6 ---------------------------------------------------------------------------
7 g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
8 g_level_error CONSTANT NUMBER := fnd_log.level_error;
9 g_level_exception CONSTANT NUMBER := fnd_log.level_exception;
10 g_level_event CONSTANT NUMBER := fnd_log.level_event;
11 g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
12 g_level_statement CONSTANT NUMBER := fnd_log.level_statement;
13 g_level_current CONSTANT NUMBER := fnd_log.g_current_runtime_level;
14 g_module_current CONSTANT VARCHAR2 (255) := 'oks.plsql.oks_int_mass_edit';
15 ---------------------------------------------------------------------------
16 -- GLOBAL MESSAGE CONSTANTS
17 ---------------------------------------------------------------------------
18 g_required_value CONSTANT VARCHAR2 (200) := okc_api.g_required_value;
19 g_invalid_value CONSTANT VARCHAR2 (200) := okc_api.g_invalid_value;
20 g_col_name_token CONSTANT VARCHAR2 (200) := okc_api.g_col_name_token;
21 g_parent_table_token CONSTANT VARCHAR2 (200) := okc_api.g_parent_table_token;
22 g_child_table_token CONSTANT VARCHAR2 (200) := okc_api.g_child_table_token;
23 g_unexpected_error CONSTANT VARCHAR2 (200) := 'OKC_CONTRACTS_UNEXP_ERROR';
24 g_sqlerrm_token CONSTANT VARCHAR2 (200) := 'SQLerrm';
25 g_sqlcode_token CONSTANT VARCHAR2 (200) := 'SQLcode';
26 g_uppercase_required CONSTANT VARCHAR2 (200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
27 ---------------------------------------------------------------------------
28 -- GLOBAL EXCEPTION
29 ---------------------------------------------------------------------------
30 g_exception_halt_validation EXCEPTION;
31 ---------------------------------------------------------------------------
32 -- GLOBAL VARIABLES
33 ---------------------------------------------------------------------------
34 g_pkg_name CONSTANT VARCHAR2 (200) := 'OKSMUPDB';
35 g_app_name CONSTANT VARCHAR2 (3) := 'OKS';
36 g_num_one CONSTANT NUMBER := 1;
37 l_api_version CONSTANT NUMBER := 1.0;
38 l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
39 ---------------------------------------------------------------------------
40 -- Package and functions
41 ---------------------------------------------------------------------------
42 TYPE batch_rules_rec_type IS RECORD (
43 billing_profile_id oks_billing_profiles_b.ID%TYPE,
44 invoicing_rule oks_billing_profiles_b.invoice_object1_id1%TYPE,
45 accounting_rule oks_billing_profiles_b.account_object1_id1%TYPE,
46 transfer_date DATE,
47 credit_option oks_batch_rules.credit_option%TYPE,
48 termination_reason_code oks_batch_rules.termination_reason_code%TYPE,
49 retain_contract_number_flag oks_batch_rules.retain_contract_number_flag%TYPE,
50 contract_modifier oks_batch_rules.contract_modifier%TYPE,
51 contract_status oks_batch_rules.contract_status%TYPE,
52 transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
53 transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
54 bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
55 transfer_option oks_batch_rules.transfer_option_code%TYPE,
56 bill_account_id oks_batch_rules.bill_account_id%TYPE,
57 ship_account_id oks_batch_rules.ship_account_id%TYPE,
58 bill_address_id oks_batch_rules.bill_address_id%TYPE,
59 ship_address_id oks_batch_rules.ship_address_id%TYPE,
60 bill_contact_id oks_batch_rules.bill_contact_id%TYPE,
61 -- ship_contact_id oks_batch_rules.ship_contact_id%TYPE,
62 new_customer_id NUMBER, --oks_batch_rules.new_account_id%TYPE,
63 new_party_id NUMBER,
64 party_name hz_parties.party_name%TYPE,
65 Batch_id NUMBER
66 );
67
68
69 TYPE batch_rules_trm_type IS RECORD
70 (
71 credit_option oks_batch_rules.credit_option%TYPE,
72 termination_reason_code oks_batch_rules.termination_reason_code%TYPE
73 );
74 TYPE jtf_note_rec_type IS RECORD (
75 jtf_note_id NUMBER,
76 source_object_code VARCHAR2 (240),
77 note_status VARCHAR2 (240),
78 note_type VARCHAR2 (240),
79 notes VARCHAR2 (2000),
80 notes_detail VARCHAR2 (32767),
81 created_by NUMBER,
82 last_updated_by NUMBER,
83 last_update_login NUMBER
84 );
85
86 TYPE jtf_note_tbl_type IS TABLE OF jtf_note_rec_type
87 INDEX BY BINARY_INTEGER;
88
89 l_notes_tbl jtf_note_tbl_type;
90
91 -- Billing rec
92 TYPE billing_rec_type IS RECORD (
93 start_date DATE,
94 end_date DATE,
95 inv_rule_id NUMBER,
96 schedule_type VARCHAR2 (1),
97 billing_type VARCHAR2 (10),
98 freq_period VARCHAR2 (10),
99 invoice_offset NUMBER,
100 interface_offset NUMBER,
101 amount NUMBER,
102 currency_code VARCHAR2 (10)
103 );
104
105 TYPE setup_rec IS RECORD (
106 pdf_id NUMBER,
107 qcl_id NUMBER,
108 cgp_new_id NUMBER,
109 rle_code oks_k_defaults.rle_code%TYPE
110 );
111 FUNCTION validate_account_id (
112 p_account_id NUMBER,
113 p_party_id Number,
114 p_org_id NUMBER
115 ) return number;
116 Function Get_address
117 (P_address_id Number,
118 p_Account_id Number,
119 p_party_id Number,
120 P_Site_use Varchar2,
121 P_org_id Number
122 ) Return Number;
123 PROCEDURE update_contracts (
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2,
126 p_batch_type IN VARCHAR2,
127 p_batch_id IN NUMBER,
128 p_new_acct_id IN NUMBER,
129 p_old_acct_id IN NUMBER,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135 FUNCTION check_relation (
136 p_old_customer IN VARCHAR2,
137 p_new_customer IN VARCHAR2,
138 p_transfer_date IN DATE
139 )
140 RETURN VARCHAR2;
141
142 Function get_ste_code(p_sts_code Varchar2) return Varchar2;
143
144
145
146 FUNCTION get_end_date (
147 p_sdate IN DATE,
148 p_edate IN DATE,
149 p_ins_date IN DATE
150 )
151 RETURN DATE;
152
153 FUNCTION get_status (
154 p_start_date IN VARCHAR2,
155 p_end_date IN VARCHAR2
156 )
157 RETURN VARCHAR2;
158
159 FUNCTION get_seq_no (
160 p_type IN VARCHAR2,
161 p_var IN VARCHAR2,
162 p_end_date IN DATE
163 )
164 RETURN NUMBER;
165
166 FUNCTION get_line_number (
167 p_type IN VARCHAR2
168 )
169 RETURN NUMBER;
170
171 FUNCTION get_Topline_number (
172 p_type IN VARCHAR2
173 )
174 RETURN NUMBER;
175
176
177 FUNCTION site_address (
178 p_customer_id IN NUMBER,
179 p_party_id IN NUMBER,
180 p_code IN VARCHAR2,
181 p_org_id IN NUMBER
182 )
183 RETURN NUMBER;
184
185 Function get_modifier(Contract_id Number) return varchar2 ;
186 Function Negotiated_amount
187 (P_start_date IN Date
188 ,P_end_date IN Date
189 ,P_price_uom IN Varchar2
190 ,P_period_type IN Varchar2
191 ,P_period_start IN Varchar2
192 ,P_new_start_date IN Date
193 ,P_amount IN Number
194 ,P_Currency IN Varchar2) Return Number ;
195
196 Procedure Create_transaction_source
197 (
198 P_Batch_id Number,
199 p_source_line_id Number,
200 P_target_line_id Number,
201 p_source_chr_id Number,
202 p_target_chr_id Number,
203 p_transaction Varchar2,
204 x_return_status OUT NOCOPY Varchar2,
205 x_msg_count OUT NOCOPY Number,
206 x_msg_data OUT NOCOPY Varchar2
207 );
208 Function get_status_code(p_ste_code Varchar2) return Varchar2;
209 Function get_line_status(p_lse_id Number,P_start_date date, p_end_date Date, P_line_status varchar2,p_batch_status Varchar2) return Varchar2 ;
210
211
212 END;
213
214
215