1 PACKAGE FA_MASSADD_PKG as
2 /* $Header: FAMAPTS.pls 120.4 2006/01/13 22:32:07 bridgway noship $ */
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 -- 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
22 FUNCTION Do_mass_property(
23 p_book_type_code IN VARCHAR2,
24 p_rowid_tbl IN char_tbl_type ,
25 p_mass_addition_id_tbl IN num_tbl_type ,
26 px_asset_id_tbl IN OUT NOCOPY num_tbl_type ,
27 px_add_to_asset_id_tbl IN OUT NOCOPY num_tbl_type ,
28 p_asset_category_id_tbl IN num_tbl_type ,
29 p_asset_type_tbl IN char_tbl_type ,
30 px_date_placed_in_service_tbl IN OUT NOCOPY date_tbl_type ,
31 px_amortize_flag_tbl IN OUT NOCOPY char_tbl_type ,
32 px_amortization_start_date_tbl IN OUT NOCOPY date_tbl_type ,
33 px_description_tbl IN OUT NOCOPY char_tbl_type ,
34 p_fixed_assets_units_tbl IN num_tbl_type ,
35 px_units_to_adjust_tbl IN OUT NOCOPY num_tbl_type ,
36 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
37
38 PROCEDURE allocate_workers (
39 p_book_type_code IN VARCHAR2,
40 p_mode IN VARCHAR2,
41 p_parent_request_id IN NUMBER,
42 p_total_requests IN NUMBER,
43 x_return_status OUT NOCOPY NUMBER);
44
45
46 END FA_MASSADD_PKG;