1: PACKAGE cse_fac_inservice_pkg AUTHID CURRENT_USER AS
2: /* $Header: CSEFPISS.pls 120.3.12010000.1 2008/07/30 05:17:43 appldev ship $ */
3:
4: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
5: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
6: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
7: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1: PACKAGE cse_fac_inservice_pkg AUTHID CURRENT_USER AS
2: /* $Header: CSEFPISS.pls 120.3.12010000.1 2008/07/30 05:17:43 appldev ship $ */
3:
4: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
5: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
6: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
7: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
9: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR ;
2: /* $Header: CSEFPISS.pls 120.3.12010000.1 2008/07/30 05:17:43 appldev ship $ */
3:
4: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
5: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
6: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
7: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
9: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR ;
10: G_False CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
3:
4: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
5: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
6: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
7: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
9: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR ;
10: G_False CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
11: G_True CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
4: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
5: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
6: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
7: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
9: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR ;
10: G_False CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
11: G_True CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
12: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
5: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
6: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
7: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
9: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR ;
10: G_False CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
11: G_True CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
12: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
13: G_API_NAME CONSTANT VARCHAR2(28):= 'CSE_FAC_PROJ_ITEM_IN_SVC_PKG';
6: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
7: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
9: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR ;
10: G_False CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
11: G_True CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
12: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
13: G_API_NAME CONSTANT VARCHAR2(28):= 'CSE_FAC_PROJ_ITEM_IN_SVC_PKG';
14:
7: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
9: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR ;
10: G_False CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
11: G_True CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
12: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
13: G_API_NAME CONSTANT VARCHAR2(28):= 'CSE_FAC_PROJ_ITEM_IN_SVC_PKG';
14:
15: PROCEDURE create_expitem(
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
9: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR ;
10: G_False CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
11: G_True CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
12: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
13: G_API_NAME CONSTANT VARCHAR2(28):= 'CSE_FAC_PROJ_ITEM_IN_SVC_PKG';
14:
15: PROCEDURE create_expitem(
16: X_Return_Status OUT NOCOPY VARCHAR2,