8: -- Pre-reqs : None.
9: -- Parameters :
10: -- IN p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
10: -- IN p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_CLASSID in out NUMBER
18: -- p_CLASS_CODE in VARCHAR2
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_CLASSID in out NUMBER
18: -- p_CLASS_CODE in VARCHAR2
19: -- p_CLASS_NAME in VARCHAR2
20: -- p_CLASS_DESCRIPTION in VARCHAR2
36: -- End of comments
37:
38: PROCEDURE create_work_request (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_org_id IN NUMBER,
44: p_asset_group_id IN NUMBER,
37:
38: PROCEDURE create_work_request (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_org_id IN NUMBER,
44: p_asset_group_id IN NUMBER,
45: p_asset_number IN VARCHAR2,
38: PROCEDURE create_work_request (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_org_id IN NUMBER,
44: p_asset_group_id IN NUMBER,
45: p_asset_number IN VARCHAR2,
46: p_priority_id IN NUMBER,
93: RETURN fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
94:
95: PROCEDURE update_work_request (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_org_id IN NUMBER,
101: p_asset_group_id IN NUMBER,
94:
95: PROCEDURE update_work_request (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_org_id IN NUMBER,
101: p_asset_group_id IN NUMBER,
102: p_asset_number IN VARCHAR2,
95: PROCEDURE update_work_request (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_org_id IN NUMBER,
101: p_asset_group_id IN NUMBER,
102: p_asset_number IN VARCHAR2,
103: p_request_id IN NUMBER,
146: );
147:
148: PROCEDURE validate_work_request (
149: p_api_version in NUMBER,
150: p_init_msg_list in VARCHAR2:= FND_API.G_FALSE,
151: p_mode in VARCHAR2,
152: p_org_id in NUMBER,
153: p_request_id in NUMBER,
154: p_asset_group_id in NUMBER,
192:
193:
194: PROCEDURE auto_approve_check (
195: p_api_version in NUMBER,
196: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
197: p_commit in VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_org_id in NUMBER,
200: x_return_check OUT NOCOPY VARCHAR2,
193:
194: PROCEDURE auto_approve_check (
195: p_api_version in NUMBER,
196: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
197: p_commit in VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_org_id in NUMBER,
200: x_return_check OUT NOCOPY VARCHAR2,
201: x_return_status OUT NOCOPY VARCHAR2,
194: PROCEDURE auto_approve_check (
195: p_api_version in NUMBER,
196: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
197: p_commit in VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_org_id in NUMBER,
200: x_return_check OUT NOCOPY VARCHAR2,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
204: );
205:
206: PROCEDURE create_and_approve(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
209: p_commit IN VARCHAR2 := FND_API.G_FALSE,
210: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
211: p_org_id IN NUMBER,
212: p_asset_group_id IN NUMBER,
205:
206: PROCEDURE create_and_approve(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
209: p_commit IN VARCHAR2 := FND_API.G_FALSE,
210: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
211: p_org_id IN NUMBER,
212: p_asset_group_id IN NUMBER,
213: p_asset_number IN VARCHAR2,
206: PROCEDURE create_and_approve(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
209: p_commit IN VARCHAR2 := FND_API.G_FALSE,
210: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
211: p_org_id IN NUMBER,
212: p_asset_group_id IN NUMBER,
213: p_asset_number IN VARCHAR2,
214: p_priority_id IN NUMBER,
254:
255:
256: PROCEDURE check_product_install(
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_appl_id IN NUMBER,
262: p_dep_appl_id IN Number,
255:
256: PROCEDURE check_product_install(
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_appl_id IN NUMBER,
262: p_dep_appl_id IN Number,
263: x_installed OUT NOCOPY NUMBER,
256: PROCEDURE check_product_install(
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_appl_id IN NUMBER,
262: p_dep_appl_id IN Number,
263: x_installed OUT NOCOPY NUMBER,
264: x_return_status OUT NOCOPY VARCHAR2,