1 package FA_MASS_ADD_VALIDATE as
2 -- $Header: faxmads.pls 120.2 2005/06/24 02:09:53 lson ship $
3
4
5 -- FUNCTION
6 -- check_valid_asset_number
7 -- PURPOSE
8 -- This function returns
9 -- 1 if asset number has not been used by FA and
10 -- does not conflict with FA automatic numbers
11 -- 0 if asset number is already in use
12 -- 2 if asset number is not in use, but conflicts with FA
13 -- automatic numbering
14 --
15 -- If Oracle error occurs, Oracle error number is returned.
16 --
17 --
18 -- HISTORY
19 -- 28-NOV-95 C. Conlin Created
20 --
21 --
22 function check_valid_asset_number(x_asset_number IN varchar2,
23 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
24 return number;
25 -- Fix for Bug #4183210. Comment out the pragma reference
26 -- pragma RESTRICT_REFERENCES (check_valid_asset_number, WNDS, WNPS );
27
28 --
29 -- FUNCTION
30 -- can_add_to_asset
31 -- PURPOSE
32 -- This function returns 1 if the asset can receive
33 -- additional cost and returns 0 if the asset cannot
34 -- receive additional cost.
35 --
36 -- If Oracle error occurs, Oracle error number is returned.
37 -- HISTORY
38 -- 28-NOV-95 C. Conlin Created
39 --
40 --
41 function can_add_to_asset(x_asset_id IN number,
42 x_book_type_code IN varchar2,
43 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
44 return number;
45 -- FUNCTION
46 -- valid_date_in_service
47 -- PURPOSE
48 -- This function returns 1 if the date placed in service
49 -- is valid and returns 0 if the date placed in service
50 -- is not valid.
51 --
52 -- If Oracle error occurs, Oracle error number is returned.
53 -- HISTORY
54 -- 28-NOV-95 C. Conlin Created
55 --
56 function valid_date_in_service(x_date_in_service IN date,
57 x_book_type_code IN varchar2,
58 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
59 return number;
60 pragma RESTRICT_REFERENCES (valid_date_in_service, WNDS, WNPS );
61
62
63 end fa_mass_add_validate;