1 Package Pa_Rbs_Elements_Pkg AUTHID CURRENT_USER AS
2 /* $Header: PARELETS.pls 120.0.12020000.3 2013/03/27 13:40:37 bpottipa ship $*/
3
4 Procedure Insert_Row(
5 P_Rbs_Element_Name_Id IN Number,
6 P_RBS_Version_Id IN Number,
7 P_Outline_Number IN Varchar2,
8 P_Order_Number IN Number,
9 P_Resource_Type_Id IN Number,
10 P_Resource_Source_Id IN Number,
11 P_Person_Id IN Number,
12 P_Job_Id IN Number,
13 P_Organization_Id IN Number,
14 P_Expenditure_Type_Id IN Number,
15 P_Event_Type_Id IN Number,
16 P_Expenditure_Category_Id IN Number,
17 P_Revenue_Category_Id IN Number,
18 P_Inventory_Item_Id IN Number,
19 P_Item_Category_Id IN Number,
20 P_BOM_Labor_Id IN Number,
21 P_BOM_Equipment_Id IN Number,
22 P_Non_Labor_Resource_Id IN Number,
23 P_Role_Id IN Number,
24 P_Person_Type_Id IN Number,
25 P_Resource_Class_Id IN Number,
26 P_Supplier_Id IN Number,
27 P_Rule_Flag IN Varchar2,
28 P_Parent_Element_Id IN Number,
29 P_Rbs_Level IN Number,
30 P_Element_Identifier IN Number,
31 P_User_Created_Flag IN Varchar2,
32 P_User_Defined_Custom1_Id IN Number,
33 P_User_Defined_Custom2_Id IN Number,
34 P_User_Defined_Custom3_Id IN Number,
35 P_User_Defined_Custom4_Id IN Number,
36 P_User_Defined_Custom5_Id IN Number,
37 P_Last_Update_Date IN Date,
38 P_Last_Updated_By IN Number,
39 P_Last_Update_Login IN Number,
40 P_Creation_Date IN Date,
41 P_Created_By IN Number,
42 X_RBS_Element_Id OUT NOCOPY Number,
43 P_Level_Code IN VARCHAR2 default null,--15834912
44 P_COST_CODE IN VARCHAR2 default null,--15834912
45 P_COST_CODE_NAME IN VARCHAR2 default null,--16430696
46 X_Error_Msg_Data OUT NOCOPY Varchar2);
47
48 Procedure Update_Row(
49 P_RBS_Element_Id IN Number,
50 P_Rbs_Element_Name_Id IN Number,
51 P_RBS_Version_Id IN Number,
52 P_Outline_Number IN Varchar2,
53 P_Order_Number IN Number,
54 P_Resource_Type_Id IN Number,
55 P_Resource_Source_Id IN Number,
56 P_Person_Id IN Number,
57 P_Job_Id IN Number,
58 P_Organization_Id IN Number,
59 P_Expenditure_Type_Id IN Number,
60 P_Event_Type_Id IN Number,
61 P_Expenditure_Category_Id IN Number,
62 P_Revenue_Category_Id IN Number,
63 P_Inventory_Item_Id IN Number,
64 P_Item_Category_Id IN Number,
65 P_BOM_Labor_Id IN Number,
66 P_BOM_Equipment_Id IN Number,
67 P_Non_Labor_Resource_Id IN Number,
68 P_Role_Id IN Number,
69 P_Person_Type_ID IN Number,
70 P_Resource_Class_Id IN Number,
71 P_Supplier_Id IN Number,
72 P_Rule_Flag IN Varchar2,
73 P_Parent_Element_Id IN Number,
74 P_Rbs_Level IN Number,
75 P_Element_Identifier IN Number,
76 P_User_Created_Flag IN Varchar2,
77 P_User_Defined_Custom1_Id IN Number,
78 P_User_Defined_Custom2_Id IN Number,
79 P_User_Defined_Custom3_Id IN Number,
80 P_User_Defined_Custom4_Id IN Number,
81 P_User_Defined_Custom5_Id IN Number,
82 P_Last_Update_Date IN Date,
83 P_Last_Updated_By IN Number,
84 P_Last_Update_Login IN Number,
85 P_Level_Code IN VARCHAR2 default null,--15834912
86 P_COST_CODE IN VARCHAR2 default null,--15834912
87 P_COST_CODE_NAME IN VARCHAR2 default null,--16430696
88 X_Error_Msg_Data OUT NOCOPY Varchar2);
89
90 Procedure Delete_Row(
91 P_RBS_Element_Id IN Number);
92
93 END Pa_Rbs_Elements_Pkg;
[Home] [Help]