DBA Data[Home] [Help]

PACKAGE: APPS.CS_SR_DELETE_UTIL

Source


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;