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;
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;
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;
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:
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:
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:
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: -- ===============================================================
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,
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
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: );
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,
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
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: );