1 Package PQH_DE_OPR_GRP AUTHID CURRENT_USER As
2 /* $Header: pqtskpln.pkh 115.2 2002/12/09 22:40:37 rpasapul noship $ */
3
4 /*REM TYPE => Pass 'P' for operation Plan, 'G' => for Operation group 'O' => Operation 'J' => Jobs
5 REM TRNTYP => 'I' => Insert 'S' => Select 'U' => Update */
6
7 Function Node_Sequence(P_Hierarchy_version_id IN Number,
8 P_Parent_Hierarchy_Id IN Number)
9 Return Number;
10 Procedure copy_Hierarchy
11 (P_Hierarchy_version_id IN Number,
12 P_Parent_Hierarchy_id IN Number,
13 P_Hierarchy_Id IN Number,
14 p_Business_group_Id IN Number,
15 p_Effective_Date IN Date);
16
17 Procedure Main
18 (P_Type IN Varchar2,
19 P_Trntype IN Varchar2,
20 P_Code IN Varchar2 Default NULL,
21 P_Description IN Varchar2 Default NULL,
22 p_Code_Id IN Number Default NULL,
23 P_Hierarchy_version_id IN Number Default NULL,
24 P_Parent_Hierarchy_id IN Number Default NULL,
25 P_Hierarchy_Id IN Number Default NULL,
26 p_Object_Version_Number IN Number Default NULL,
27 p_Business_group_Id IN Number ,
28 p_Effective_Date IN Date);
29
30 Procedure Copy_Hierarchy_version
31 (P_Type IN Varchar2,
32 P_Name IN Varchar2 Default NULL,
33 P_Date_From IN Date Default NULL,
34 P_Date_To IN Date Default NULL,
35 P_Hierarchy_Id IN Number Default NULL,
36 P_Hierarchy_Version_Id IN Number Default NULL,
37 P_Version_Number IN Number Default NULL,
38 P_Business_Group_id IN Number ,
39 P_Effective_Date IN Date ,
40 P_New_hierarchy_Id OUT NOCOPY Number ,
41 P_New_Hierarchy_Version_Id OUT NOCOPY Number);
42
43 End;