PACKAGE: APPS.AMW_ASSESSMENTS_PVT

Source

1 PACKAGE AMW_ASSESSMENTS_PVT AS
2 /* $Header: amwtasss.pls 120.0 2005/05/31 19:14:13 appldev noship $ */
3 
4 -- ===============================================================
5 -- Package name
6 --          AMW_ASSESSMENTS_PVT
7 -- Purpose
8 -- 		  	for handling Assessments and the related
9 -- History
10 -- 		  	12/28/2003    tsho     Creates
11 -- ===============================================================
12 
13 
14 -- FND_API global constant
15 G_FALSE    		  		   CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16 G_TRUE 					   CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17 G_VALID_LEVEL_FULL 		   CONSTANT NUMBER 		:= FND_API.G_VALID_LEVEL_FULL;
18 G_RET_STS_SUCCESS 		   CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19 G_RET_STS_ERROR			   CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20 G_RET_STS_UNEXP_ERROR 	   CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
21 
22 
23 
24 -- ===============================================================
25 -- Procedure name
26 --          Delete_Procedure_Related
27 -- Purpose
28 -- 		  	Delete any others related to this assessment procedure,
29 --          ie. assessProcedure, assessProcedureStep
30 -- ===============================================================
31 PROCEDURE Delete_Procedure_Related(
32     p_assess_procedure_id        IN   NUMBER,
33     p_init_msg_list              IN   VARCHAR2   := FND_API.G_FALSE,
34     p_commit                     IN   VARCHAR2   := FND_API.G_FALSE,
35     p_validate_only              IN   VARCHAR2   := FND_API.G_FALSE,
36     x_return_status              OUT  NOCOPY VARCHAR2,
37     x_msg_count                  OUT  NOCOPY NUMBER,
38     x_msg_data                   OUT  NOCOPY VARCHAR2
39 );
40 
41 
42 
43 -- ===============================================================
44 -- Procedure name
45 --          Delete_Assessment_Related
46 -- Purpose
47 -- 		  	Delete any others related to this assessment,
48 --          ie. AssessmentProcedure, Survey, Context, Component
49 -- ===============================================================
50 PROCEDURE Delete_Assessment_Related(
51     p_assessment_id              IN  NUMBER,
52     p_init_msg_list              IN  VARCHAR2   := FND_API.G_FALSE,
53     p_commit                     IN  VARCHAR2   := FND_API.G_FALSE,
54     p_validate_only              IN  VARCHAR2   := FND_API.G_FALSE,
55     x_return_status              OUT  NOCOPY VARCHAR2,
56     x_msg_count                  OUT  NOCOPY NUMBER,
57     x_msg_data                   OUT  NOCOPY VARCHAR2
58 );
59 
60 
61 -- ----------------------------------------------------------------------
62 END AMW_ASSESSMENTS_PVT;