12: -- and mtl_categories_tl from forms / html interface
13: -- * Parameters :
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- p_dml_type IN VARCHAR2 Required
22: -- Corresponds to the dml action done to the
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- p_dml_type IN VARCHAR2 Required
22: -- Corresponds to the dml action done to the
23: -- category. The allowed values
24: -- are "CREATE/UPDATE/DELETE"
45: --
46: -- End of comments
47: PROCEDURE populateCategoryChange
48: ( p_api_version IN NUMBER ,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
51: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
52: x_return_status OUT NOCOPY VARCHAR2 ,
53: p_dml_type IN VARCHAR2 ,
46: -- End of comments
47: PROCEDURE populateCategoryChange
48: ( p_api_version IN NUMBER ,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
51: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
52: x_return_status OUT NOCOPY VARCHAR2 ,
53: p_dml_type IN VARCHAR2 ,
54: p_structure_id IN NUMBER ,
47: PROCEDURE populateCategoryChange
48: ( p_api_version IN NUMBER ,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
51: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
52: x_return_status OUT NOCOPY VARCHAR2 ,
53: p_dml_type IN VARCHAR2 ,
54: p_structure_id IN NUMBER ,
55: p_category_name IN VARCHAR2 ,
67: -- from forms / html interface.
68: -- * Parameters :
69: -- IN : p_api_version IN NUMBER Required
70: -- p_init_msg_list IN VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Optional
73: -- Default = FND_API.G_FALSE
74: -- p_validation_level IN NUMBER Optional
75: -- Default = FND_API.G_VALID_LEVEL_FULL
69: -- IN : p_api_version IN NUMBER Required
70: -- p_init_msg_list IN VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Optional
73: -- Default = FND_API.G_FALSE
74: -- p_validation_level IN NUMBER Optional
75: -- Default = FND_API.G_VALID_LEVEL_FULL
76: -- p_category_set_id IN NUMBER Required
77: -- Corresponds to the column CATEGORY_SET_ID in
71: -- Default = FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Optional
73: -- Default = FND_API.G_FALSE
74: -- p_validation_level IN NUMBER Optional
75: -- Default = FND_API.G_VALID_LEVEL_FULL
76: -- p_category_set_id IN NUMBER Required
77: -- Corresponds to the column CATEGORY_SET_ID in
78: -- the table MTL_CATEGORY_SET_VALID_CATS, and
79: -- identifies the category_set_id of the category.
92: --
93: -- End of comments
94: PROCEDURE populateValidCategorySetInsert
95: ( p_api_version IN NUMBER ,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
98: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
99: x_return_status OUT NOCOPY VARCHAR2 ,
100: p_category_set_id IN NUMBER ,
93: -- End of comments
94: PROCEDURE populateValidCategorySetInsert
95: ( p_api_version IN NUMBER ,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
98: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
99: x_return_status OUT NOCOPY VARCHAR2 ,
100: p_category_set_id IN NUMBER ,
101: p_category_id IN NUMBER
94: PROCEDURE populateValidCategorySetInsert
95: ( p_api_version IN NUMBER ,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
98: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
99: x_return_status OUT NOCOPY VARCHAR2 ,
100: p_category_set_id IN NUMBER ,
101: p_category_id IN NUMBER
102: );
112: -- from forms / html interface.
113: -- * Parameters :
114: -- IN : p_api_version IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional
116: -- Default = FND_API.G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
114: -- IN : p_api_version IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional
116: -- Default = FND_API.G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_category_set_id IN NUMBER Required
122: -- Corresponds to the column CATEGORY_SET_ID in
116: -- Default = FND_API.G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_category_set_id IN NUMBER Required
122: -- Corresponds to the column CATEGORY_SET_ID in
123: -- the table MTL_CATEGORY_SET_VALID_CATS, and
124: -- identifies the category_set_id of the category.
141: --
142: -- End of comments
143: PROCEDURE populateValidCategorySetUpdate
144: ( p_api_version IN NUMBER ,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
147: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
148: x_return_status OUT NOCOPY VARCHAR2 ,
149: p_category_set_id IN NUMBER ,
142: -- End of comments
143: PROCEDURE populateValidCategorySetUpdate
144: ( p_api_version IN NUMBER ,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
147: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
148: x_return_status OUT NOCOPY VARCHAR2 ,
149: p_category_set_id IN NUMBER ,
150: p_old_category_id IN NUMBER ,
143: PROCEDURE populateValidCategorySetUpdate
144: ( p_api_version IN NUMBER ,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
147: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
148: x_return_status OUT NOCOPY VARCHAR2 ,
149: p_category_set_id IN NUMBER ,
150: p_old_category_id IN NUMBER ,
151: p_new_category_id IN NUMBER
162: -- from forms / html interface.
163: -- * Parameters :
164: -- IN : p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional
166: -- Default = FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Optional
168: -- Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional
170: -- Default = FND_API.G_VALID_LEVEL_FULL
164: -- IN : p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional
166: -- Default = FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Optional
168: -- Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional
170: -- Default = FND_API.G_VALID_LEVEL_FULL
171: -- p_category_set_id IN NUMBER Required
172: -- Corresponds to the column CATEGORY_SET_ID in
166: -- Default = FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Optional
168: -- Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional
170: -- Default = FND_API.G_VALID_LEVEL_FULL
171: -- p_category_set_id IN NUMBER Required
172: -- Corresponds to the column CATEGORY_SET_ID in
173: -- the table MTL_CATEGORY_SET_VALID_CATS, and
174: -- identifies the category_set_id of the category.
187: --
188: -- End of comments
189: PROCEDURE populateValidCategorySetDelete
190: ( p_api_version IN NUMBER ,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
193: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
194: x_return_status OUT NOCOPY VARCHAR2 ,
195: p_category_set_id IN NUMBER ,
188: -- End of comments
189: PROCEDURE populateValidCategorySetDelete
190: ( p_api_version IN NUMBER ,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
193: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
194: x_return_status OUT NOCOPY VARCHAR2 ,
195: p_category_set_id IN NUMBER ,
196: p_category_id IN NUMBER
189: PROCEDURE populateValidCategorySetDelete
190: ( p_api_version IN NUMBER ,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
193: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
194: x_return_status OUT NOCOPY VARCHAR2 ,
195: p_category_set_id IN NUMBER ,
196: p_category_id IN NUMBER
197: );