1 PACKAGE EGO_CATEGORY_SET_PUB AS
2 /* $Header: EGOCSTPS.pls 120.1 2005/06/02 05:38:51 lkapoor noship $ */
3
4 --Global Variables
5
6 G_DBI_FUNCTIONAL_AREA_ID CONSTANT NUMBER := 11;
7
8
9 /* Public API for inserting a category set/category association in the DBI staging table: ENI_DENORM_HRCHY_STG
10 ** This method is intended to be called every time there is a DML operation for mtl_category_set_valid_cats or mtl_categories
11 ** Parameters:
12 ** p_cat_set_id: the category set id in the association
13 ** p_child_id: The category id associated to the category set
14 ** p_parent_id: The category id of the parent category
15 ** p_new_flag: "A" for adding subcategory, "D" for delete and "M" for move, 'E' for change in disable date, 'C' for change in category desc.
16 ** return_status: this is returned by the api to indicate the success/failure of the call
17 ** msg_count: this is returned by the api to indicate the number of message logged for this
18 ** call.
19 **
20 */
21
22 PROCEDURE Process_Category_Set_Assoc
23 ( p_cat_set_id IN NUMBER
24 , p_child_id IN NUMBER
25 , p_parent_id IN NUMBER
26 , p_mode_flag IN VARCHAR2
27 , x_return_status OUT NOCOPY VARCHAR2
28 , x_msg_count OUT NOCOPY NUMBER
29 , x_msg_data OUT NOCOPY VARCHAR2
30
31 );
32
33
34 /**
35 ** This function will return 'Y' if DBI is installed and is version 59+
36 **/
37
38 FUNCTION Check_DBI_59_Installed
39 RETURN VARCHAR2;
40
41 FUNCTION Check_DBI_Default_Exists
42 RETURN VARCHAR2;
43
44 FUNCTION Get_DBI_Default_Category_Set
45 RETURN NUMBER;
46
47 FUNCTION Is_DBI_Catalog_Category
48 (
49 p_Category_Id IN NUMBER
50 )
51 RETURN VARCHAR2;
52
53 PROCEDURE Process_DBI_Category
54 ( p_category_id IN NUMBER
55 , p_mode_flag IN VARCHAR2
56 , x_return_status OUT NOCOPY VARCHAR2
57 , x_msg_count OUT NOCOPY NUMBER
58 , x_msg_data OUT NOCOPY VARCHAR2
59
60 );
61
62 PROCEDURE Process_DBI_Category
63 ( p_category_id IN NUMBER
64 , p_language_code IN VARCHAR2
65 , p_mode_flag IN VARCHAR2
66 , x_return_status OUT NOCOPY VARCHAR2
67 , x_msg_count OUT NOCOPY NUMBER
68 , x_msg_data OUT NOCOPY VARCHAR2
69
70 );
71
72 END EGO_CATEGORY_SET_PUB;