39: i := p_TYPE_MAPPINGS_TBL.first;
40: l_last := p_TYPE_MAPPINGS_TBL.last;
41: WHILE i <= l_last
42: LOOP
43: INSERT INTO AS_MC_TYPE_MAPPINGS(
44: PERIOD_SET_NAME,
45: PERIOD_TYPE,
46: CONVERSION_TYPE,
47: DESCRIPTION,
161: IF l_debug THEN
162: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
163: 'i=' || i);
164: END IF;
165: UPDATE AS_MC_TYPE_MAPPINGS
166: SET
167: PERIOD_SET_NAME = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME,
168: FND_API.G_MISS_CHAR, PERIOD_SET_NAME,
169: p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME),
269: i := p_TYPE_MAPPINGS_TBL.first;
270: l_last := p_TYPE_MAPPINGS_TBL.last;
271: WHILE i <= l_last
272: LOOP
273: DELETE FROM AS_MC_TYPE_MAPPINGS
274: WHERE PERIOD_SET_NAME = p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME
275: AND PERIOD_TYPE = p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE;
276:
277: IF (SQL%NOTFOUND) THEN