APPS.AS_MULTI_CURRENCIES_PKG dependencies on AS_MC_TYPE_MAPPINGS

Line 43: INSERT INTO AS_MC_TYPE_MAPPINGS(

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,

Line 165: UPDATE AS_MC_TYPE_MAPPINGS

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),

Line 273: DELETE FROM AS_MC_TYPE_MAPPINGS

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