1 PACKAGE FA_TAX_UPLOAD_PKG AUTHID CURRENT_USER as
2 /* $Header: fataxups.pls 120.4 2009/03/26 23:06:32 bridgway ship $ */
3
4 -- type for table variable
5 type num_tbl_type is table of number index by binary_integer;
6 type char_tbl_type is table of varchar2(150) index by binary_integer;
7 type date_tbl_type is table of date index by binary_integer;
8
9 -- Changes made as per the ER No.s 6606548 and 6606552 by Vkukutam Start
10
11 TYPE msg_error_rec IS RECORD(asset_number VARCHAR2(50)
12 ,exception_code VARCHAR2(10)
13 );
14 TYPE msg_error_tbl IS TABLE OF msg_error_rec INDEX BY BINARY_INTEGER;
15 g_error_msg msg_error_tbl;
16
17 TYPE new_taxbk_col_rec_type IS RECORD (
18 nbv_at_switch NUMBER,
19 prior_deprn_limit_amount NUMBER,
20 period_full_reserve VARCHAR2(30),
21 prior_deprn_method VARCHAR2(20),
22 period_extd_deprn VARCHAR2(30),
23 period_counter_fully_reserved NUMBER,
24 extended_depreciation_period NUMBER);
25
26 TYPE basic_info_rec_type IS RECORD (
27 asset_id NUMBER,
28 book_type_code VARCHAR2(100),
29 date_placed_in_service DATE,
30 deprn_method_code VARCHAR2(100),
31 asset_number VARCHAR2(100),
32 deprn_reserve NUMBER
33 );
34 -- Changes made as per the ER No.s 6606548 and 6606552 by Vkukutam End
35
36 PROCEDURE faxtaxup(
37 p_book_type_code IN VARCHAR2,
38 p_parent_request_id IN NUMBER,
39 p_total_requests IN NUMBER,
40 p_request_number IN NUMBER,
41 px_max_asset_id IN OUT NOCOPY NUMBER,
42 x_success_count OUT NOCOPY number,
43 x_failure_count OUT NOCOPY number,
44 x_return_status OUT NOCOPY number);
45
46 PROCEDURE write_message
47 (p_asset_number in varchar2,
48 p_message in varchar2);
49
50 PROCEDURE allocate_workers (
51 p_book_type_code IN VARCHAR2,
52 p_parent_request_id IN NUMBER,
53 p_total_requests IN NUMBER,
54 x_return_status OUT NOCOPY NUMBER);
55
56 END FA_TAX_UPLOAD_PKG ;