1 package PA_ASSET_UTILS AUTHID CURRENT_USER as
2 -- $Header: PAXAUTLS.pls 115.0 99/07/16 15:18:45 porting ship $
3
4
5 --
6 -- FUNCTION
7 -- check_unique_asset_name
8 -- PURPOSE
9 -- This function returns 1 if asset name is not already
10 -- used for assets on this project and returns 0 if name is used.
11 -- If Oracle error occurs, Oracle error number is returned.
12 -- HISTORY
13 -- 28-OCT-95 C. Conlin Created
14 --
15 --
16 function check_unique_asset_name (x_asset_name IN varchar2,
17 x_project_id IN number,
18 x_rowid IN varchar2 ) return number;
19 --
20 -- FUNCTION
21 -- check_valid_asset_number
22 -- PURPOSE
23 -- This function returns
24 -- 1 if asset number has not been used by PA.
25 -- 0 if asset number is already in use in PA
26 -- (further checking should be done to make
27 -- sure the asset is not in use in FA. See
28 -- the FA_MASS_ADD_VALIDATE package.
29 --
30 -- If Oracle error occurs, Oracle error number is returned.
31 --
32 --
33 -- HISTORY
34 -- 28-OCT-95 C. Conlin Created
35 --
36 --
37 function check_valid_asset_number (x_asset_number IN varchar2,
38 x_rowid IN varchar2 ) return number;
39 --
40 -- FUNCTION
41 -- check_asset_references
42 -- PURPOSE
43 -- This function returns 1 if an asset can be deleted, and
44 -- returns 0 if the asset has references which prevent it
45 -- from being deleted.
46 --
47 -- If Oracle error occurs, Oracle error number is returned.
48 -- HISTORY
49 -- 28-OCT-95 C. Conlin Created
50 --
51 --
52
53 function check_asset_references (x_project_asset_id IN number)
54 return number;
55
56
57 -- FUNCTION
58 -- check_fa_asset_num
59 -- PURPOSE
60 -- This function returns a 1 if the asset number being
61 -- checked is one of the valid FA asset numbers for the
62 -- given pa_asset_id. This function returns a 0 if the
63 -- asset number is NOT a valid FA asset number for the
64 -- given pa_asset_id.
65
66 --
67 -- If Oracle error occurs, Oracle error number is returned.
68 -- HISTORY
69 -- 29-JAN-96 C. Conlin Created
70 --
71 --
72 function check_fa_asset_num(pa_asset_id IN NUMBER,
73 check_asset_number IN VARCHAR2) return number;
74
75 -- FUNCTION
76 -- fa_implementation_status
77 -- PURPOSE
78 -- Returns a 'Y' if FA is implemented. Returns a 'N'
79 -- if FA is not implemented.
80 --
81 --
82
83 FUNCTION fa_implementation_status RETURN VARCHAR2;
84
85 end pa_asset_utils;