1 PACKAGE BOM_PFI_PVT AS
2 /* $Header: BOMVPFIS.pls 120.1 2005/06/21 05:30:17 appldev ship $ */
3
4 /****************************************************************************/
5 -- --------------- Global constants -----------------
6 -- ----------------------------------------------------
7
8 -- Product Family Category Set ID number
9 --
10 G_PF_Category_Set_ID CONSTANT NUMBER := 3 ;
11
12 -- Item Categories key flexfield Product Family structure number
13 --
14 G_PF_Structure_ID CONSTANT NUMBER := 2 ;
15
16 -- System Items key flexfield structure number
17 --
18 G_MSTK_Structure_ID CONSTANT NUMBER := 101 ;
19
20 -- PF structure segments status values
21 --
22 G_PF_Segs_Status_OK CONSTANT NUMBER := 2 ;
23 G_PF_Segs_Status_Mismatch CONSTANT NUMBER := 1 ;
24 G_PF_Segs_Status_Undefined CONSTANT NUMBER := 0 ;
25
26 /****************************************************************************/
27
28 TYPE Create_Category_Rec_Type IS RECORD
29 ( item_id NUMBER ,
30 org_id NUMBER
31 );
32
33 TYPE Create_Category_Tbl_Type IS TABLE OF Create_Category_Rec_Type
34 INDEX BY BINARY_INTEGER;
35
36 TYPE Delete_Category_Rec_Type IS RECORD
37 ( item_id NUMBER ,
38 org_id NUMBER
39 );
40
41 TYPE Delete_Category_Tbl_Type IS TABLE OF Delete_Category_Rec_Type
42 INDEX BY BINARY_INTEGER;
43
44 TYPE Category_Assign_Rec_Type IS RECORD
45 ( item_id NUMBER ,
46 org_id NUMBER ,
47 pf_item_id NUMBER
48 );
49
50 TYPE Category_Assign_Tbl_Type IS TABLE OF Category_Assign_Rec_Type
51 INDEX BY BINARY_INTEGER;
52
53
54 G_Create_Cat_Tbl Create_Category_Tbl_Type ;
55 G_Cat_Create_Num BINARY_INTEGER := 0 ;
56
57 G_Delete_Cat_Tbl Delete_Category_Tbl_Type ;
58 G_Cat_Num BINARY_INTEGER := 0 ;
59
60 G_Cat_Assign_Tbl Category_Assign_Tbl_Type ;
61 G_Assign_Num BINARY_INTEGER := 0 ;
62
63 -- PF structure segments status
64 PF_Segs_Status NUMBER := 2 ;
65
66 /****************************************************************************/
67
68 PROCEDURE Store_Cat_Create
69 ( p_return_sts IN OUT NOCOPY NUMBER ,
70 p_return_err IN OUT NOCOPY VARCHAR2 ,
71 p_item_id IN NUMBER ,
72 p_org_id IN NUMBER ,
73 p_Cat_Create_Num IN OUT NOCOPY BINARY_INTEGER ,
74 p_Create_Cat_Tbl IN OUT NOCOPY Create_Category_Tbl_Type
75 );
76
77 /****************************************************************************/
78
79 PROCEDURE Create_PF_Category
80 ( p_return_sts IN OUT NOCOPY NUMBER ,
81 p_return_err IN OUT NOCOPY VARCHAR2 ,
82 p_Cat_Create_Num IN OUT NOCOPY BINARY_INTEGER ,
83 p_Create_Cat_Tbl IN OUT NOCOPY Create_Category_Tbl_Type
84 );
85
86 /****************************************************************************/
87
88 PROCEDURE Store_Category
89 ( p_return_sts IN OUT NOCOPY NUMBER ,
90 p_return_err IN OUT NOCOPY VARCHAR2 ,
91 p_item_id IN NUMBER ,
92 p_org_id IN NUMBER ,
93 p_Cat_Num IN OUT NOCOPY BINARY_INTEGER ,
94 p_Delete_Cat_Tbl IN OUT NOCOPY Delete_Category_Tbl_Type
95 );
96
97 /****************************************************************************/
98
99 PROCEDURE Delete_PF_Category
100 ( p_return_sts IN OUT NOCOPY NUMBER ,
101 p_return_err IN OUT NOCOPY VARCHAR2 ,
102 p_Cat_Num IN OUT NOCOPY BINARY_INTEGER ,
103 p_Delete_Cat_Tbl IN OUT NOCOPY Delete_Category_Tbl_Type
104 );
105
106 /****************************************************************************/
107
108 PROCEDURE Store_Cat_Assign
109 ( p_return_sts IN OUT NOCOPY NUMBER ,
110 p_return_err IN OUT NOCOPY VARCHAR2 ,
111 p_item_id IN NUMBER ,
112 p_org_id IN NUMBER ,
113 p_pf_item_id IN NUMBER ,
114 p_Assign_Num IN OUT NOCOPY BINARY_INTEGER ,
115 p_Cat_Assign_Tbl IN OUT NOCOPY Category_Assign_Tbl_Type
116 );
117
118 /****************************************************************************/
119
120 PROCEDURE Assign_To_Category
121 ( p_return_sts IN OUT NOCOPY NUMBER ,
122 p_return_err IN OUT NOCOPY VARCHAR2 ,
123 p_Assign_Num IN OUT NOCOPY BINARY_INTEGER ,
124 p_Cat_Assign_Tbl IN OUT NOCOPY Category_Assign_Tbl_Type
125 );
126
127 /****************************************************************************/
128
129 PROCEDURE Remove_From_Category
130 ( p_return_sts IN OUT NOCOPY NUMBER ,
131 p_return_err IN OUT NOCOPY VARCHAR2 ,
132 p_item_id IN NUMBER ,
133 p_org_id IN NUMBER
134 );
135
136 /****************************************************************************/
137
138 PROCEDURE Get_Category_ID
139 ( p_return_sts IN OUT NOCOPY NUMBER ,
140 p_return_err IN OUT NOCOPY VARCHAR2 ,
141 p_item_id IN NUMBER ,
142 p_org_id IN NUMBER ,
143 p_concat_segments IN OUT NOCOPY VARCHAR2 ,
144 p_category_id IN OUT NOCOPY NUMBER
145 );
146
147 /****************************************************************************/
148
149 PROCEDURE Get_Master_Org_ID
150 ( p_return_sts IN OUT NOCOPY NUMBER ,
151 p_return_err IN OUT NOCOPY VARCHAR2 ,
152 p_org_id IN NUMBER ,
153 p_master_org_id IN OUT NOCOPY NUMBER
154 );
155
156 /****************************************************************************/
157
158 FUNCTION Org_Is_Master
159 ( p_org_id IN NUMBER
160 )
161 RETURN BOOLEAN;
162
163 /****************************************************************************/
164
165 PROCEDURE Check_PF_Segs;
166
167 /****************************************************************************/
168
169 FUNCTION PF_Segs_Undefined
170 RETURN BOOLEAN;
171
172 /****************************************************************************/
173
174 END BOM_PFI_PVT;