1 package FA_MASS_ADD_VALIDATE AUTHID CURRENT_USER as
2 -- $Header: faxmads.pls 120.4 2009/08/05 20:22:56 bridgway 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, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
23 return number;
24 -- Fix for Bug #4183210. Comment out the pragma reference
25 -- pragma RESTRICT_REFERENCES (check_valid_asset_number, WNDS, WNPS );
26
27 --
28 -- FUNCTION
29 -- can_add_to_asset
30 -- PURPOSE
31 -- This function returns 1 if the asset can receive
32 -- additional cost and returns 0 if the asset cannot
33 -- receive additional cost.
34 --
35 -- If Oracle error occurs, Oracle error number is returned.
36 -- HISTORY
37 -- 28-NOV-95 C. Conlin Created
38 --
39 --
40 function can_add_to_asset(x_asset_id IN number,
41 x_book_type_code IN varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
42 return number;
43 -- FUNCTION
44 -- valid_date_in_service
45 -- PURPOSE
46 -- This function returns 1 if the date placed in service
47 -- is valid and returns 0 if the date placed in service
48 -- is not valid.
49 --
50 -- If Oracle error occurs, Oracle error number is returned.
51 -- HISTORY
52 -- 28-NOV-95 C. Conlin Created
53 --
54 function valid_date_in_service(x_date_in_service IN date,
55 x_book_type_code IN varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
56 return number;
57 pragma RESTRICT_REFERENCES (valid_date_in_service, WNDS, WNPS );
58
59
60 end fa_mass_add_validate;
[Home] [Help]