[Home] [Help]
PACKAGE: APPS.PA_RBS_ELEMENTS_PVT
Source
1 Package Pa_Rbs_Elements_Pvt AS
2 /* $Header: PARELEVS.pls 120.0 2005/05/31 05:56:21 appldev noship $*/
3
4 -- Standard Who
5 G_Last_Updated_By Number(15) := Fnd_Global.User_Id;
6 G_Last_Update_Date Date := SysDate;
7 G_Creation_Date Date := SysDate;
8 G_Created_By Number(15) := Fnd_Global.User_Id;
9 G_Last_Update_Login Number(15) := Fnd_Global.Login_Id;
10
11 /* -------------------------------------------------------------------------------
12 * Procedure: Process_RBS_Elements
13 * Function: Entry point for the insert/update/delete of elements/nodes
14 * ------------------------------------------------------------------------------- */
15
16 Procedure Process_RBS_Element (
17 P_RBS_Version_Id IN Number,
18 P_Parent_Element_Id IN Number,
19 P_Element_Id IN Number,
20 P_Resource_Type_Id IN Number,
21 P_Resource_Source_Id IN Number,
22 P_Order_Number IN Number,
23 P_Process_Type IN Varchar2,
24 X_RBS_Element_id OUT NOCOPY Number,
25 X_Error_Msg_Data OUT NOCOPY Varchar2);
26
27 Procedure DeleteRbsElement(
28 P_RBS_Version_Id IN Number,
29 P_Element_Id IN Number,
30 X_Error_Msg_Data OUT NOCOPY Varchar2);
31
32 Procedure UpdateExisingRbsElement(
33 P_Rbs_Version_Id IN Number,
34 P_Parent_Element_Id IN Number,
35 P_Rbs_Element_Id IN Number,
36 P_Resource_Type_Id IN Number,
37 P_Resource_Source_Id IN Number,
38 P_Order_Number IN Number,
39 X_Error_Msg_Data OUT NOCOPY Varchar2);
40
41 Procedure CreateNewRbsElement(
42 P_Rbs_Version_Id IN Number,
43 P_Parent_Element_Id IN Number,
44 P_Rbs_Element_Id IN Number,
45 P_Resource_Type_Id IN Number,
46 P_Resource_Source_Id IN Number,
47 P_Order_Number IN Number,
48 X_RBS_Element_id OUT NOCOPY Number,
49 X_Error_Msg_Data OUT NOCOPY Varchar2);
50
51 Procedure ValidateAndBuildElement(
52 P_Mode IN Varchar2,
53 P_Rbs_Version_Id IN Number,
54 P_Parent_Element_Id IN Number,
55 P_Rbs_Element_Id IN Number,
56 P_Resource_Type_Id IN Number,
57 P_Resource_Source_Id IN Number,
58 P_Order_Number IN Number,
59 X_Person_Id OUT NOCOPY Number,
60 X_Job_Id OUT NOCOPY Number,
61 X_Organization_Id OUT NOCOPY Number,
62 X_Exp_Type_Id OUT NOCOPY Number,
63 X_Event_Type_Id OUT NOCOPY Number,
64 X_Exp_Cat_Id OUT NOCOPY Number,
65 X_Rev_Cat_Id OUT NOCOPY Number,
66 X_Inv_Item_Id OUT NOCOPY Number,
67 X_Item_Cat_Id OUT NOCOPY Number,
68 X_BOM_Labor_Id OUT NOCOPY Number,
69 X_BOM_Equip_Id OUT NOCOPY Number,
70 X_Non_Labor_Res_Id OUT NOCOPY Number,
71 X_Role_Id OUT NOCOPY Number,
72 X_Person_Type_Id OUT NOCOPY Number,
73 X_User_Def_Custom1_Id OUT NOCOPY Number,
74 X_User_Def_Custom2_Id OUT NOCOPY Number,
75 X_User_Def_Custom3_Id OUT NOCOPY Number,
76 X_User_Def_Custom4_Id OUT NOCOPY Number,
77 X_User_Def_Custom5_Id OUT NOCOPY Number,
78 X_Res_Class_Id OUT NOCOPY Number,
79 X_Supplier_Id OUT NOCOPY Number,
80 X_Rbs_Level OUT NOCOPY Number,
81 X_Rule_Based_Flag OUT NOCOPY Varchar2,
82 X_Rbs_Element_Name_Id OUT NOCOPY Number,
83 X_Order_Number OUT NOCOPY Number,
84 X_Element_Identifier OUT NOCOPY Number,
85 X_Outline_Number OUT NOCOPY Varchar2,
86 X_Error_Msg_Data OUT NOCOPY Varchar2);
87
88 Procedure ValidateRbsElement(
89 P_Mode IN Varchar2,
90 P_Rbs_Version_Id IN Number,
91 P_Parent_Element_Id IN Number,
92 P_Rbs_Element_Id IN Number,
93 P_Old_Resource_Type_Id IN Number,
94 P_Old_Resource_Source_Id IN Number,
95 P_Resource_Type_Id IN Number,
96 P_Resource_Source_Id IN Number,
97 X_Resource_Type OUT NOCOPY Varchar2,
98 X_Error_Msg_Data OUT NOCOPY Varchar2);
99
100 Procedure ValidateResource(
101 P_Resource_Type_Id IN Number,
102 P_Resource_Source_Id IN Number,
103 P_Resource_Type IN Varchar2,
104 X_Error_Msg_Data OUT NOCOPY Varchar2);
105
106 Procedure GetParentRbsData(
107 P_Parent_Element_Id IN Number,
108 X_Person_Id OUT NOCOPY Number,
109 X_Job_Id OUT NOCOPY Number,
110 X_Organization_Id OUT NOCOPY Number,
111 X_Exp_Type_Id OUT NOCOPY Number,
112 X_Event_Type_Id OUT NOCOPY Number,
113 X_Exp_Cat_Id OUT NOCOPY Number,
114 X_Rev_Cat_Id OUT NOCOPY Number,
115 X_Inv_Item_Id OUT NOCOPY Number,
116 X_Item_Cat_Id OUT NOCOPY Number,
117 X_BOM_Labor_Id OUT NOCOPY Number,
118 X_BOM_Equip_Id OUT NOCOPY Number,
119 X_Non_Labor_Res_Id OUT NOCOPY Number,
120 X_Role_Id OUT NOCOPY Number,
121 X_Person_Type_Id OUT NOCOPY Number,
122 X_User_Def_Custom1_Id OUT NOCOPY Number,
123 X_User_Def_Custom2_Id OUT NOCOPY Number,
124 X_User_Def_Custom3_Id OUT NOCOPY Number,
125 X_User_Def_Custom4_Id OUT NOCOPY Number,
126 X_User_Def_Custom5_Id OUT NOCOPY Number,
127 X_Res_Class_Id OUT NOCOPY Number,
128 X_Supplier_Id OUT NOCOPY Number,
129 X_Rbs_Level OUT NOCOPY Number,
130 X_Outline_Number OUT NOCOPY Varchar2);
131
132 Procedure UpdateOrderOutlineNumber(
133 P_Parent_Element_Id_Tbl IN System.Pa_Num_Tbl_Type,
134 X_Error_Msg_Data OUT NOCOPY Varchar2 );
135
136 Procedure Update_Children_Data(
137 P_Rbs_Element_Id IN Number,
138 X_Error_Msg_Data OUT NOCOPY Varchar2);
139
140
141
142 END Pa_Rbs_Elements_Pvt;