1 PACKAGE cs_sr_delete_util AS
2 /* $Header: csvsrdls.pls 120.3 2005/08/23 02:32:31 varnaray noship $ */
3 /*#
4 * This package encapsulates procedures that act as helpers to
5 * cs_servicerequest_pvt.delete_servicerequest API. The validation procedure
6 * in this package performs validations against child objects that are
7 * linked to SRs to check if they can be deleted, as a result of which it
8 * can be decided if the SR itself can be deleted. The delete procedure
9 * encapsulates calls to the delete APIs of all child objects and also actually
10 * deletes the SRs finally.
11 * @rep:scope internal
12 * @rep:product CS
13 * @rep:displayname Service Request Delete Helper
14 */
15
16 PROCEDURE delete_sr_validations
17 (
18 p_api_version_number IN NUMBER := 1.0
19 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
20 , p_commit IN VARCHAR2 := FND_API.G_FALSE
21 , p_object_type IN VARCHAR2
22 , p_processing_set_id IN NUMBER
23 , p_purge_source_with_open_task IN VARCHAR2
24 , x_return_status OUT NOCOPY VARCHAR2
25 , x_msg_count OUT NOCOPY NUMBER
26 , x_msg_data OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE delete_servicerequest
30 (
31 p_api_version_number IN NUMBER := 1.0
32 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
33 , p_commit IN VARCHAR2 := FND_API.G_FALSE
34 , p_purge_set_id IN NUMBER
35 , p_processing_set_id IN NUMBER
36 , p_object_type IN VARCHAR2
37 , p_audit_required IN VARCHAR2
38 , x_return_status OUT NOCOPY VARCHAR2
39 , x_msg_count OUT NOCOPY NUMBER
40 , x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43 END cs_sr_delete_util;