1 PACKAGE FA_MASSADD_PKG AUTHID CURRENT_USER as
2 /* $Header: FAMAPTS.pls 120.5.12020000.2 2012/07/23 08:46:10 rmandali 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(360) index by binary_integer;
7 type date_tbl_type is table of date index by binary_integer;
8
9 -- public functions
10 PROCEDURE Do_Mass_Addition
11 (p_book_type_code IN VARCHAR2,
12 p_mode IN VARCHAR2,
13 p_loop_count IN NUMBER,
14 p_parent_request_id IN NUMBER,
15 p_total_requests IN NUMBER,
16 p_request_number IN NUMBER,
17 x_success_count OUT NOCOPY number,
18 x_failure_count OUT NOCOPY number,
19 x_return_status OUT NOCOPY number );
20
21 FUNCTION Do_mass_property(
22 p_book_type_code IN VARCHAR2,
23 p_rowid_tbl IN char_tbl_type ,
24 p_mass_addition_id_tbl IN num_tbl_type ,
25 px_asset_id_tbl IN OUT NOCOPY num_tbl_type ,
26 px_add_to_asset_id_tbl IN OUT NOCOPY num_tbl_type ,
27 p_asset_category_id_tbl IN num_tbl_type ,
28 p_asset_type_tbl IN char_tbl_type ,
29 px_date_placed_in_service_tbl IN OUT NOCOPY date_tbl_type ,
30 px_amortize_flag_tbl IN OUT NOCOPY char_tbl_type ,
31 px_amortization_start_date_tbl IN OUT NOCOPY date_tbl_type ,
32 px_description_tbl IN OUT NOCOPY char_tbl_type ,
33 p_fixed_assets_units_tbl IN num_tbl_type ,
34 px_units_to_adjust_tbl IN OUT NOCOPY num_tbl_type
35 ) RETURN BOOLEAN;
36
37 PROCEDURE allocate_workers (
38 p_book_type_code IN VARCHAR2,
39 p_mode IN VARCHAR2,
40 p_parent_request_id IN NUMBER,
41 p_total_requests IN NUMBER,
42 x_return_status OUT NOCOPY NUMBER);
43
44
45 END FA_MASSADD_PKG;