33: l_api_name || ' Start');
34: END IF;
35:
36: -- Initialize API return status to SUCCESS
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: i := p_TYPE_MAPPINGS_TBL.first;
40: l_last := p_TYPE_MAPPINGS_TBL.last;
41: WHILE i <= l_last
55: --,
56: -- SECURITY_GROUP_ID
57: ) VALUES (
58: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME,
59: FND_API.G_MISS_CHAR, NULL,
60: p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME),
61: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
62: FND_API.G_MISS_CHAR, NULL,
63: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
58: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME,
59: FND_API.G_MISS_CHAR, NULL,
60: p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME),
61: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
62: FND_API.G_MISS_CHAR, NULL,
63: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
64: decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
65: FND_API.G_MISS_CHAR, NULL,
66: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
61: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
62: FND_API.G_MISS_CHAR, NULL,
63: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
64: decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
65: FND_API.G_MISS_CHAR, NULL,
66: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
67: decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
68: FND_API.G_MISS_CHAR, NULL,
69: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
64: decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
65: FND_API.G_MISS_CHAR, NULL,
66: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
67: decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
68: FND_API.G_MISS_CHAR, NULL,
69: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
70: decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
71: FND_API.G_MISS_CHAR, NULL,
72: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
67: decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
68: FND_API.G_MISS_CHAR, NULL,
69: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
70: decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
71: FND_API.G_MISS_CHAR, NULL,
72: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
73: decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
74: FND_API.G_MISS_CHAR, NULL,
75: p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),
70: decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
71: FND_API.G_MISS_CHAR, NULL,
72: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
73: decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
74: FND_API.G_MISS_CHAR, NULL,
75: p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),
76: SYSDATE,
77: FND_GLOBAL.USER_ID,
78: SYSDATE,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.CONC_LOGIN_ID
81: --,
82: -- decode( p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID,
83: -- FND_API.G_MISS_NUM, NULL,
84: -- p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID)
85: );
86: i := i + 1;
87: END LOOP;
91: ( p_count => x_msg_count,
92: p_data => x_msg_data
93: );
94: EXCEPTION
95: WHEN FND_API.G_EXC_ERROR THEN
96: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
97: P_MODULE => l_module
98: ,P_API_NAME => L_API_NAME
99: ,P_PKG_NAME => G_PKG_NAME
102: ,X_MSG_COUNT => X_MSG_COUNT
103: ,X_MSG_DATA => X_MSG_DATA
104: ,X_RETURN_STATUS => X_RETURN_STATUS);
105:
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
108: P_MODULE => l_module
109: ,P_API_NAME => L_API_NAME
110: ,P_PKG_NAME => G_PKG_NAME
150: l_api_name || ' Start');
151: END IF;
152:
153: -- Initialize API return status to SUCCESS
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: i := p_TYPE_MAPPINGS_TBL.first;
157: l_last := p_TYPE_MAPPINGS_TBL.last;
158:
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),
170: PERIOD_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
171: FND_API.G_MISS_CHAR, PERIOD_TYPE,
172: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
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),
170: PERIOD_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
171: FND_API.G_MISS_CHAR, PERIOD_TYPE,
172: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
173: CONVERSION_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
174: FND_API.G_MISS_CHAR, CONVERSION_TYPE,
175: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
170: PERIOD_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
171: FND_API.G_MISS_CHAR, PERIOD_TYPE,
172: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
173: CONVERSION_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
174: FND_API.G_MISS_CHAR, CONVERSION_TYPE,
175: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
176: DESCRIPTION = decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
177: FND_API.G_MISS_CHAR, DESCRIPTION,
178: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
173: CONVERSION_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
174: FND_API.G_MISS_CHAR, CONVERSION_TYPE,
175: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
176: DESCRIPTION = decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
177: FND_API.G_MISS_CHAR, DESCRIPTION,
178: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
179: UPDATEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
180: FND_API.G_MISS_CHAR, UPDATEABLE_FLAG,
181: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
176: DESCRIPTION = decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
177: FND_API.G_MISS_CHAR, DESCRIPTION,
178: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
179: UPDATEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
180: FND_API.G_MISS_CHAR, UPDATEABLE_FLAG,
181: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
182: DELETEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
183: FND_API.G_MISS_CHAR, DELETEABLE_FLAG,
184: p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),
179: UPDATEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
180: FND_API.G_MISS_CHAR, UPDATEABLE_FLAG,
181: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
182: DELETEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
183: FND_API.G_MISS_CHAR, DELETEABLE_FLAG,
184: p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),
185: LAST_UPDATE_DATE = SYSDATE,
186: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
187: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
187: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
188: --,
189: -- SECURITY_GROUP_ID = decode(
190: -- p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID,
191: -- FND_API.G_MISS_NUM, SECURITY_GROUP_ID,
192: -- p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID)
193: WHERE PERIOD_SET_NAME = p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME
194: AND PERIOD_TYPE = p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE;
195:
204: ( p_count => x_msg_count,
205: p_data => x_msg_data
206: );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
210: P_MODULE => l_module
211: ,P_API_NAME => L_API_NAME
212: ,P_PKG_NAME => G_PKG_NAME
215: ,X_MSG_COUNT => X_MSG_COUNT
216: ,X_MSG_DATA => X_MSG_DATA
217: ,X_RETURN_STATUS => X_RETURN_STATUS);
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
221: P_MODULE => l_module
222: ,P_API_NAME => L_API_NAME
223: ,P_PKG_NAME => G_PKG_NAME
263: l_api_name || ' Start');
264: END IF;
265:
266: -- Initialize API return status to SUCCESS
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268:
269: i := p_TYPE_MAPPINGS_TBL.first;
270: l_last := p_TYPE_MAPPINGS_TBL.last;
271: WHILE i <= l_last
286: p_data => x_msg_data
287: );
288:
289: EXCEPTION
290: WHEN FND_API.G_EXC_ERROR THEN
291: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
292: P_MODULE => l_module
293: ,P_API_NAME => L_API_NAME
294: ,P_PKG_NAME => G_PKG_NAME
297: ,X_MSG_COUNT => X_MSG_COUNT
298: ,X_MSG_DATA => X_MSG_DATA
299: ,X_RETURN_STATUS => X_RETURN_STATUS);
300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
303: P_MODULE => l_module
304: ,P_API_NAME => L_API_NAME
305: ,P_PKG_NAME => G_PKG_NAME
346: l_api_name || ' Start');
347: END IF;
348:
349: -- Initialize API return status to SUCCESS
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: i := p_PERIOD_RATES_TBL.first;
353: l_last := p_PERIOD_RATES_TBL.last;
354: WHILE i <= l_last
363: MODE_FLAG,
364: INVERSE_CONVERSION_RATE
365: ) VALUES (
366: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
367: FND_API.G_MISS_CHAR, NULL,
368: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
369: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
370: FND_API.G_MISS_CHAR, NULL,
371: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
366: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
367: FND_API.G_MISS_CHAR, NULL,
368: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
369: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
370: FND_API.G_MISS_CHAR, NULL,
371: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
372: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
373: FND_API.G_MISS_DATE, NULL,
374: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
369: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
370: FND_API.G_MISS_CHAR, NULL,
371: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
372: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
373: FND_API.G_MISS_DATE, NULL,
374: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
375: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
376: FND_API.G_MISS_DATE, NULL,
377: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
372: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
373: FND_API.G_MISS_DATE, NULL,
374: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
375: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
376: FND_API.G_MISS_DATE, NULL,
377: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
378: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
379: FND_API.G_MISS_CHAR, NULL,
380: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
375: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
376: FND_API.G_MISS_DATE, NULL,
377: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
378: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
379: FND_API.G_MISS_CHAR, NULL,
380: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
381: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
382: FND_API.G_MISS_NUM, NULL,
383: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
378: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
379: FND_API.G_MISS_CHAR, NULL,
380: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
381: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
382: FND_API.G_MISS_NUM, NULL,
383: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
384: 'I',
385: NULL);
386:
392: ( p_count => x_msg_count,
393: p_data => x_msg_data
394: );
395: EXCEPTION
396: WHEN FND_API.G_EXC_ERROR THEN
397: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
398: P_MODULE => l_module
399: ,P_API_NAME => L_API_NAME
400: ,P_PKG_NAME => G_PKG_NAME
403: ,X_MSG_COUNT => X_MSG_COUNT
404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);
406:
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
409: P_MODULE => l_module
410: ,P_API_NAME => L_API_NAME
411: ,P_PKG_NAME => G_PKG_NAME
453: l_api_name || ' Start');
454: END IF;
455:
456: -- Initialize API return status to SUCCESS
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: i := p_PERIOD_RATES_TBL.first;
460: l_last := p_PERIOD_RATES_TBL.last;
461: WHILE i <= l_last
470: MODE_FLAG,
471: INVERSE_CONVERSION_RATE
472: ) VALUES (
473: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
474: FND_API.G_MISS_CHAR, NULL,
475: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
476: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
477: FND_API.G_MISS_CHAR, NULL,
478: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
473: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
474: FND_API.G_MISS_CHAR, NULL,
475: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
476: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
477: FND_API.G_MISS_CHAR, NULL,
478: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
479: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
480: FND_API.G_MISS_DATE, NULL,
481: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
476: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
477: FND_API.G_MISS_CHAR, NULL,
478: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
479: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
480: FND_API.G_MISS_DATE, NULL,
481: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
482: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
483: FND_API.G_MISS_DATE, NULL,
484: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
479: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
480: FND_API.G_MISS_DATE, NULL,
481: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
482: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
483: FND_API.G_MISS_DATE, NULL,
484: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
485: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
486: FND_API.G_MISS_CHAR, NULL,
487: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
482: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
483: FND_API.G_MISS_DATE, NULL,
484: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
485: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
486: FND_API.G_MISS_CHAR, NULL,
487: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
488: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
489: FND_API.G_MISS_NUM, NULL,
490: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
485: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
486: FND_API.G_MISS_CHAR, NULL,
487: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
488: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
489: FND_API.G_MISS_NUM, NULL,
490: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
491: 'I',
492: NULL);
493:
499: ( p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502: EXCEPTION
503: WHEN FND_API.G_EXC_ERROR THEN
504: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
505: P_MODULE => l_module
506: ,P_API_NAME => L_API_NAME
507: ,P_PKG_NAME => G_PKG_NAME
510: ,X_MSG_COUNT => X_MSG_COUNT
511: ,X_MSG_DATA => X_MSG_DATA
512: ,X_RETURN_STATUS => X_RETURN_STATUS);
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
516: P_MODULE => l_module
517: ,P_API_NAME => L_API_NAME
518: ,P_PKG_NAME => G_PKG_NAME
560: l_api_name || ' Start');
561: END IF;
562:
563: -- Initialize API return status to SUCCESS
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565:
566: i := p_PERIOD_RATES_TBL.first;
567: l_last := p_PERIOD_RATES_TBL.last;
568: WHILE i <= l_last
577: MODE_FLAG,
578: INVERSE_CONVERSION_RATE
579: ) VALUES (
580: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
581: FND_API.G_MISS_CHAR, NULL,
582: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
583: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
584: FND_API.G_MISS_CHAR, NULL,
585: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
580: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
581: FND_API.G_MISS_CHAR, NULL,
582: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
583: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
584: FND_API.G_MISS_CHAR, NULL,
585: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
586: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
587: FND_API.G_MISS_DATE, NULL,
588: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
583: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
584: FND_API.G_MISS_CHAR, NULL,
585: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
586: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
587: FND_API.G_MISS_DATE, NULL,
588: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
589: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
590: FND_API.G_MISS_DATE, NULL,
591: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
586: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
587: FND_API.G_MISS_DATE, NULL,
588: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
589: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
590: FND_API.G_MISS_DATE, NULL,
591: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
592: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
593: FND_API.G_MISS_CHAR, NULL,
594: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
589: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
590: FND_API.G_MISS_DATE, NULL,
591: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
592: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
593: FND_API.G_MISS_CHAR, NULL,
594: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
595: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
596: FND_API.G_MISS_NUM, NULL,
597: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
592: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
593: FND_API.G_MISS_CHAR, NULL,
594: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
595: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
596: FND_API.G_MISS_NUM, NULL,
597: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
598: 'D',
599: NULL);
600: i := i + 1;
605: ( p_count => x_msg_count,
606: p_data => x_msg_data
607: );
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
610: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
611: P_MODULE => l_module
612: ,P_API_NAME => L_API_NAME
613: ,P_PKG_NAME => G_PKG_NAME
616: ,X_MSG_COUNT => X_MSG_COUNT
617: ,X_MSG_DATA => X_MSG_DATA
618: ,X_RETURN_STATUS => X_RETURN_STATUS);
619:
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
622: P_MODULE => l_module
623: ,P_API_NAME => L_API_NAME
624: ,P_PKG_NAME => G_PKG_NAME