[Home] [Help]
PACKAGE: APPS.CSK_SETUP_UTILITY_PKG
Source
1 PACKAGE CSK_SETUP_UTILITY_PKG
2 /* $Header: csktsus.pls 120.0 2005/06/01 12:38:45 appldev noship $ */
3 AS
4 CAT_GROUP_API_TEST_DEFAULT CONSTANT NUMBER := -1;
5 CAT_GROUP_API_TEST_CG1 CONSTANT NUMBER := -2;
6 CAT_GROUP_API_TEST_CG2 CONSTANT NUMBER := -3;
7
8 SOLN_TYPE_FAQ_API_TEST CONSTANT NUMBER := -1;
9
10 STMT_TYPE_FAQ_API_TEST CONSTANT NUMBER := -1;
11
12 VISIBILITY_RESTRICTED_API_TEST CONSTANT NUMBER := -1;
13 VISIBILITY_INTERNAL_API_TEST CONSTANT NUMBER := -2;
14 VISIBILITY_LIMITED_API_TEST CONSTANT NUMBER := -3;
15 VISIBILITY_EXTERNAL_API_TEST CONSTANT NUMBER := -4;
16
17 FLOW_API_TEST_FLOW CONSTANT NUMBER := -1;
18
19 TYPE Soln_rec_type IS RECORD (
20 set_id NUMBER,
21 Set_Number VARCHAR2(30),
22 set_type_id NUMBER,
23 name VARCHAR2(500) ,
24 -- status VARCHAR2(30),
25 visibility_id VARCHAR2(150)
26 );
27
28 TYPE Stmt_rec_type IS RECORD (
29 element_id NUMBER,
30 element_number VARCHAR2(30),
31 element_type_id NUMBER(15) ,
32 access_level NUMBER,
33 name VARCHAR2(2000),
34 --description VARCHAR2(2000) ,
35 content_type VARCHAR2(30)
36 );
37
38 --TYPE Cat_rec_type IS RECORD (
39 -- category_id NUMBER
40 -- );
41
42 TYPE Stmt_tbl_type IS TABLE OF Stmt_rec_type;
43 --TYPE Cat_tbl_type IS TABLE OF Cat_rec_type;
44
45 TYPE Cat_tbl_type IS TABLE OF number(15);
46
47
48 PROCEDURE Validate_Seeded_Setups(
49 p_api_version in number,
50 p_init_msg_list in varchar2 := FND_API.G_FALSE,
51 p_commit in varchar2 := FND_API.G_FALSE,
52 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
53 x_return_status OUT NOCOPY varchar2,
54 x_msg_count OUT NOCOPY number,
55 x_msg_data OUT NOCOPY varchar2);
56
57 PROCEDURE Create_Category (
58 p_api_version in number,
59 p_init_msg_list in varchar2 := FND_API.G_FALSE,
60 p_commit in varchar2 := FND_API.G_FALSE,
61 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
62 x_return_status OUT NOCOPY varchar2,
63 x_msg_count OUT NOCOPY number,
64 x_msg_data OUT NOCOPY varchar2,
65 P_PARENT_CATEGORY_ID IN NUMBER,
66 P_CATEGORY_ID IN NUMBER,
67 P_CATEGORY_NAME IN VARCHAR2,
68 P_VISIBILITY_ID IN NUMBER);
69
70 PROCEDURE Delete_Category (
71 p_api_version in number,
72 p_init_msg_list in varchar2 := FND_API.G_FALSE,
73 p_commit in varchar2 := FND_API.G_FALSE,
74 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
75 x_return_status OUT NOCOPY varchar2,
76 x_msg_count OUT NOCOPY number,
77 x_msg_data OUT NOCOPY varchar2,
78 P_CATEGORY_ID IN NUMBER);
79
80 PROCEDURE Create_Solution (
81 p_api_version in number,
82 p_init_msg_list in varchar2 := FND_API.G_FALSE,
83 p_commit in varchar2 := FND_API.G_FALSE,
84 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
85 x_return_status OUT NOCOPY varchar2,
86 x_msg_count OUT NOCOPY number,
87 x_msg_data OUT NOCOPY varchar2,
88 P_SOLN_REC IN Soln_rec_type,
89 P_STMT_TBL IN Stmt_tbl_type,
90 P_CAT_TBL IN Cat_tbl_type,
91 P_PUBLISH IN Boolean );
92
93 PROCEDURE Delete_Solution (
94 p_api_version in number,
95 p_init_msg_list in varchar2 := FND_API.G_FALSE,
96 p_commit in varchar2 := FND_API.G_FALSE,
97 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
98 x_return_status OUT NOCOPY varchar2,
99 x_msg_count OUT NOCOPY number,
100 x_msg_data OUT NOCOPY varchar2,
101 P_SET_ID IN NUMBER);
102
103 PROCEDURE Obsolete_Solution (
104 p_api_version in number,
105 p_init_msg_list in varchar2 := FND_API.G_FALSE,
106 p_commit in varchar2 := FND_API.G_FALSE,
107 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
108 x_return_status OUT NOCOPY varchar2,
109 x_msg_count OUT NOCOPY number,
110 x_msg_data OUT NOCOPY varchar2,
111 P_SET_ID IN NUMBER);
112
113 FUNCTION Get_Next_Set_ID RETURN NUMBER;
114
115 FUNCTION Get_Next_Set_Number RETURN NUMBER;
116
117 FUNCTION Get_Next_Element_ID RETURN NUMBER;
118
119 FUNCTION Get_Next_Element_Number RETURN NUMBER;
120
121 FUNCTION Get_Next_Category_ID RETURN NUMBER;
122
123 FUNCTION Calculate_Set_Index_Content (P_SET_ID IN NUMBER) RETURN VARCHAR2;
124
125 END CSK_SETUP_UTILITY_PKG;