1: PACKAGE BODY ams_list_src_types_pkg AS
2: /* $Header: amsllstb.pls 120.2 2006/06/07 08:41:17 bmuthukr noship $ */
3:
4: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8: PROCEDURE insert_row (
1: PACKAGE BODY ams_list_src_types_pkg AS
2: /* $Header: amsllstb.pls 120.2 2006/06/07 08:41:17 bmuthukr noship $ */
3:
4: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8: PROCEDURE insert_row (
9: x_rowid IN OUT NOCOPY VARCHAR2,
2: /* $Header: amsllstb.pls 120.2 2006/06/07 08:41:17 bmuthukr noship $ */
3:
4: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8: PROCEDURE insert_row (
9: x_rowid IN OUT NOCOPY VARCHAR2,
10: x_list_source_type_id IN NUMBER,