1 PACKAGE ICX_Related_Categories_PUB AUTHID CURRENT_USER AS
2 /* $Header: ICXPCATS.pls 115.1 99/07/17 03:20:04 porting ship $ */
3
4 -- Start of Comments
5 -- API name : Related_Categories
6 -- Type : PUBLIC
7 -- Function : The Related_Categories API provides procedures to insert
8 -- and delete category relationships for n-level category
9 -- heirarchy definition
10 --
11 --
12 -- Pre-reqs : None
13 --
14 -- Insert_Relation
15 -- Parameters :
16 -- IN : p_api_version_number number current version = 1.0
17 -- p_init_msg_list varchar2 standard api parameter
18 -- defaults to FND_API.G_FALSE, set to
19 -- FND_API.G_TRUE to have api initialize message list
20 -- p_simulate varchar2 standard api parameter
21 -- defaults to FND_API.G_FALSE, set to
22 -- FND_API.G_TRUE for simulation mode (api will not
23 -- commit any changes)
24 -- p_commit varchar2 standard api parameter
25 -- defaults to FND_API.G_FALSE, set to
26 -- FND_API.G_TRUE to have api commit changes
27 -- p_commit is ignored if p_simulate = FND_API.G_TRUE
28 -- p_validation_level number standard api parameter
29 -- defaults to FND_API.G_VALID_LEVEL_FULL
30 -- p_category_set_id number
31 -- either p_category_set_id or p_category_set must
32 -- be provided to the api. If p_category_set_id is
33 -- provided, then p_category_set is ignored. If
34 -- p_category_set_id is null, a category set id is
35 -- looked up based on p_category_set.
36 -- p_category_set varchar2
37 -- p_category_id number
38 -- either p_category_id or p_category must be provided
39 -- to the api. If p_category_id is provided, then
40 -- p_category is ignored. If p_category_id is null,
41 -- a category id is looked up based on p_category.
42 -- p_category varchar2
43 -- p_related_category_id number
44 -- either p_related_category_id or p_related_category
45 -- must be provided to the api. If p_related_category_id
46 -- is provided, then p_related_category is ignored. If
47 --- p_category_id is null, a related category id is
48 -- looked up based on p_related_category.
49 -- p_related_category
50 -- p_relationship_type varchar2
51 -- this is a required parameter and must be a valid
52 -- relationship based on the ICX_RELATION lookup type
53 -- p_created_by number
54 -- this is a required parameter which must correspond
55 -- to the user who is inserting the category relation
56 --
57 -- OUT : p_return_status varchar2(1) standard api parameter
58 -- S = api completed successfully,
59 -- E and U = api errored
60 -- p_msg_count number standard api parameter
61 -- records how many messages were placed on the
62 -- message stack during the api call. If p_msg_count
63 -- is 1 then the message is held in p_msg_data,
64 -- otherwise api caller must use fnd_msg_pub.get to
65 -- retrieve one message at a time.
66 -- p_msg_data varchar2(240) standard api parameter
67 -- if p_msg_count = 1 then p_msg_data holds the message
68 --
69 -- Delet_Relation
70 -- Parameters :
71 -- IN : p_api_version_number number current version = 1.0
72 -- p_init_msg_list varchar2 standard api parameter
73 -- defaults to FND_API.G_FALSE, set to
74 -- FND_API.G_TRUE to have api initialize message list
75 -- p_simulate varchar2 standard api parameter
76 -- defaults to FND_API.G_FALSE, set to
77 -- FND_API.G_TRUE for simulation mode (api will not
78 -- commit any changes)
79 -- p_commit varchar2 standard api parameter
80 -- defaults to FND_API.G_FALSE, set to
81 -- FND_API.G_TRUE to have api commit changes
82 -- p_commit is ignored if p_simulate = FND_API.G_TRUE
83 -- p_validation_level number standard api parameter
84 -- defaults to FND_API.G_VALID_LEVEL_FULL
85 -- p_category_set_id number
86 -- either p_category_set_id or p_category_set must
87 -- be provided to the api. If p_category_set_id is
88 -- provided, then p_category_set is ignored. If
89 -- p_category_set_id is null, a category set id is
90 -- looked up based on p_category_set.
91 -- p_category_set varchar2
92 -- p_category_id number
93 -- either p_category_id or p_category must be provided
94 -- to the api. If p_category_id is provided, then
95 -- p_category is ignored. If p_category_id is null,
96 -- a category id is looked up based on p_category.
97 -- p_category varchar2
98 -- p_related_category_id number
99 -- either p_related_category_id or p_related_category
100 -- must be provided to the api. If p_related_category_id
101 -- is provided, then p_related_category is ignored. If
102 --- p_category_id is null, a related category id is
103 -- looked up based on p_related_category.
104 -- p_related_category
105 --
106 -- OUT : p_return_status varchar2(1) standard api parameter
107 -- S = api completed successfully,
108 -- E and U = api errored
109 -- p_msg_count number standard api parameter
110 -- records how many messages were placed on the
111 -- message stack during the api call. If p_msg_count
112 -- is 1 then the message is held in p_msg_data,
113 -- otherwise api caller must use fnd_msg_pub.get to
114 -- retrieve one message at a time.
115 -- p_msg_data varchar2(240) standard api parameter
116 -- if p_msg_count = 1 then p_msg_data holds the message
117 --
118 --
119 -- End Of Comments
120
121
122 -- Global constants holding the package and file names to be used by
123 -- messaging routines in the case of an unexpected error.
124
125 G_PKG_NAME CONSTANT VARCHAR2(30):='ICX_Related_Categories_PUB';
126
127
128 PROCEDURE Insert_Relation
129 ( p_api_version_number IN NUMBER ,
130 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131 p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
132 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
134 p_return_status OUT VARCHAR2 ,
135 p_msg_count OUT NUMBER ,
136 p_msg_data OUT VARCHAR2 ,
137 p_category_set_id IN NUMBER DEFAULT NULL ,
138 p_category_set IN VARCHAR2 DEFAULT NULL ,
139 p_category_id IN NUMBER DEFAULT NULL ,
140 p_category IN VARCHAR2 DEFAULT NULL ,
141 p_related_category_id IN NUMBER DEFAULT NULL ,
142 p_related_category IN VARCHAR2 DEFAULT NULL ,
143 p_relationship_type IN VARCHAR2 ,
144 p_created_by IN NUMBER
145 );
146
147
148 PROCEDURE Delete_Relation
149 ( p_api_version_number IN NUMBER ,
150 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151 p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
152 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
154 p_return_status OUT VARCHAR2 ,
155 p_msg_count OUT NUMBER ,
156 p_msg_data OUT VARCHAR2 ,
157 p_category_set_id IN NUMBER DEFAULT NULL ,
158 p_category_set IN VARCHAR2 DEFAULT NULL ,
159 p_category_id IN NUMBER DEFAULT NULL ,
160 p_category IN VARCHAR2 DEFAULT NULL ,
161 p_related_category_id IN NUMBER DEFAULT NULL ,
162 p_related_category IN VARCHAR2 DEFAULT NULL
163 );
164
165
166 END ICX_Related_Categories_PUB; -- ICX_Related_Categories_PUB