1 PACKAGE PA_CAPITAL_PROJECT_UTILS AUTHID CURRENT_USER as
2 /* $Header: PAXCAUTS.pls 115.2 2003/08/14 23:36:39 pbandla noship $ */
3
4 Function UnReversed_Assets_Exist
5 (P_Asset_Id In Number) RETURN VARCHAR2;
6
7 Function UnReversed_Costs_Exist
8 (P_EI_Id In Number) RETURN VARCHAR2;
9
10 Function Reverse_Event_Allow(P_Project_Id in Number,
11 P_Capital_Event_Id in Number)
12 Return Varchar2;
13
14 Function Reverse_Event_Upd(P_Project_Id in Number,
15 P_Capital_Event_Id in Number)
16 Return Number;
17
18 Function Is_Asset_Adj_Allowed(P_Fa_Asset_Id in Number,
19 P_Book_Type_Code in Varchar2)
20 Return Number;
21
22 Function Tag_Number_Exists(P_Tag_Number in Varchar2) RETURN VARCHAR2;
23
24 Function Allow_AssetType_Change(P_From_Asset_Type in Varchar2,
25 P_To_Asset_Type in Varchar2,
26 P_Project_Asset_Id in Number,
27 P_Capitalized_Flag in Varchar2,
28 P_Capital_Event_Id in Number
29 ) Return Varchar2;
30
31 PROCEDURE get_depreciation_expense_ccid
32 (P_project_asset_id IN NUMBER,
33 P_book_type_code IN VARCHAR2,
34 P_asset_category_id IN NUMBER,
35 P_date_placed_in_service IN DATE,
36 P_deprn_expense_ccid IN NUMBER,
37 X_Deprn_expense_CCID OUT NOCOPY NUMBER,
38 X_Error_Message_Code OUT NOCOPY VARCHAR2
39 );
40
41 FUNCTION Can_Delete_Event(P_Project_Id in NUMBER, P_Capital_Event_Id in NUMBER) RETURN VARCHAR2;
42
43 G_CCID_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
44
45 Function IsValidExpCCID(P_CCID IN NUMBER) RETURN VARCHAR2;
46
47
48 END PA_CAPITAL_PROJECT_UTILS;