9:
10: ------------------------------------------------------------------------------
11: -- GLOBAL CONSTANTS
12: ------------------------------------------------------------------------------
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
10: ------------------------------------------------------------------------------
11: -- GLOBAL CONSTANTS
12: ------------------------------------------------------------------------------
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
11: -- GLOBAL CONSTANTS
12: ------------------------------------------------------------------------------
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
19: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
12: ------------------------------------------------------------------------------
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
19: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
20: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
19: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
20: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
21:
23: -- Procedures and Functions
24: ---------------------------------------------------------------------------
25: procedure deliverables_notifier(
26: p_api_version IN NUMBER:=1.0,
27: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
28: p_deliverable_id IN NUMBER,
29: p_deliverable_name IN VARCHAR2,
30: p_deliverable_type IN VARCHAR2,
31: p_business_document_id IN NUMBER,