1: PACKAGE BODY AMS_DiscovererSQL_PVT AS
2: /* $Header: amsvldcb.pls 115.13 2003/03/09 10:17:50 gjoby ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_DiscovererSQL_PVT';
4: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvldcb.pls';
5: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9: PROCEDURE get_source_type_code (
2: /* $Header: amsvldcb.pls 115.13 2003/03/09 10:17:50 gjoby ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_DiscovererSQL_PVT';
4: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvldcb.pls';
5: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9: PROCEDURE get_source_type_code (
10: p_workbook_name IN VARCHAR2,
3: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_DiscovererSQL_PVT';
4: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvldcb.pls';
5: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9: PROCEDURE get_source_type_code (
10: p_workbook_name IN VARCHAR2,
11: p_worksheet_name IN VARCHAR2,