1: package body AMS_IMP_LIST_IMPORT_TYPES_PKG as
2: /* $Header: amsilmtb.pls 115.6 2004/04/07 21:52:13 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);
178: close c_get_import_type_id;
179: else
180: l_imptype_id := X_IMPORT_TYPE_ID;
181: end if;
182: AMS_IMP_LIST_IMPORT_TYPES_PKG.INSERT_ROW (
183: X_ROWID => l_row_id,
184: X_IMPORT_TYPE_ID => X_IMPORT_TYPE_ID,
185: X_IMPORT_TYPE => X_IMPORT_TYPE,
186: X_VIEW_NAME => X_VIEW_NAME,
195:
196: else
197: close c_chk_col_exists;
198: l_imptype_id := X_IMPORT_TYPE_ID;
199: AMS_IMP_LIST_IMPORT_TYPES_PKG.UPDATE_ROW (
200: X_IMPORT_TYPE_ID => X_IMPORT_TYPE_ID,
201: X_IMPORT_TYPE => X_IMPORT_TYPE,
202: X_VIEW_NAME => X_VIEW_NAME,
203: X_B2B_FLAG => X_B2B_FLAG,
209: end if;
210:
211: end LOAD_ROW;
212:
213: end AMS_IMP_LIST_IMPORT_TYPES_PKG;
214: