1: package body AMS_IMP_COL_MAPPING_PKG as
2: /* $Header: amslccmb.pls 115.7 2004/04/07 21:22:10 usingh ship $ */
3: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
4: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
5: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
174: close c_get_col_mapping_id;
175: else
176: l_colmap_id := X_COL_MAPPING_ID;
177: end if;
178: AMS_IMP_COL_MAPPING_PKG.INSERT_ROW (
179: X_ROWID => l_row_id,
180: X_COL_MAPPING_ID => X_COL_MAPPING_ID,
181: X_TABLE_NAME => X_TABLE_NAME,
182: X_COLUMN_NAME => X_COLUMN_NAME,
192: else
193: close c_chk_col_exists;
194: l_colmap_id := X_COL_MAPPING_ID ;
195:
196: AMS_IMP_COL_MAPPING_PKG.UPDATE_ROW (
197: X_COL_MAPPING_ID => X_COL_MAPPING_ID,
198: X_TABLE_NAME => X_TABLE_NAME,
199: X_COLUMN_NAME => X_COLUMN_NAME,
200: X_MEANING => X_MEANING ,
207: end if;
208:
209: end LOAD_ROW;
210:
211: end AMS_IMP_COL_MAPPING_PKG;