35: | jypark 23-NOV-99 Created |
36: | |
37: +===========================================================================*/
38: PROCEDURE Get_Currency_Details(
39: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
40: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
43: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
36: | |
37: +===========================================================================*/
38: PROCEDURE Get_Currency_Details(
39: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
40: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
43: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
44: x_precision OUT NOCOPY NUMBER,
37: +===========================================================================*/
38: PROCEDURE Get_Currency_Details(
39: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
40: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
43: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
44: x_precision OUT NOCOPY NUMBER,
45: x_mau OUT NOCOPY NUMBER,
38: PROCEDURE Get_Currency_Details(
39: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
40: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
43: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
44: x_precision OUT NOCOPY NUMBER,
45: x_mau OUT NOCOPY NUMBER,
46: x_return_status OUT NOCOPY VARCHAR2,
39: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
40: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
43: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
44: x_precision OUT NOCOPY NUMBER,
45: x_mau OUT NOCOPY NUMBER,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
72: | jypark 23-NOV-99 Created |
73: | |
74: +===========================================================================*/
75: PROCEDURE Get_Curr_Round_Amount (
76: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
77: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
80: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
73: | |
74: +===========================================================================*/
75: PROCEDURE Get_Curr_Round_Amount (
76: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
77: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
80: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
81: p_currency_code IN VARCHAR2 DEFAULT g_functional_currency,
74: +===========================================================================*/
75: PROCEDURE Get_Curr_Round_Amount (
76: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
77: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
80: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
81: p_currency_code IN VARCHAR2 DEFAULT g_functional_currency,
82: x_rounded_amount OUT NOCOPY NUMBER,
75: PROCEDURE Get_Curr_Round_Amount (
76: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
77: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
80: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
81: p_currency_code IN VARCHAR2 DEFAULT g_functional_currency,
82: x_rounded_amount OUT NOCOPY NUMBER,
83: x_return_status OUT NOCOPY VARCHAR2,
76: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
77: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
80: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
81: p_currency_code IN VARCHAR2 DEFAULT g_functional_currency,
82: x_rounded_amount OUT NOCOPY NUMBER,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
123: | jypark 23-NOV-99 Created |
124: | |
125: +===========================================================================*/
126: PROCEDURE Get_functional_Amount(
127: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
128: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
131: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
124: | |
125: +===========================================================================*/
126: PROCEDURE Get_functional_Amount(
127: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
128: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
131: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
132: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
125: +===========================================================================*/
126: PROCEDURE Get_functional_Amount(
127: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
128: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
131: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
132: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
133: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
126: PROCEDURE Get_functional_Amount(
127: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
128: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
131: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
132: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
133: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
134: p_precision IN NUMBER DEFAULT FND_API.G_MISS_NUM,
127: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
128: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
131: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
132: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
133: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
134: p_precision IN NUMBER DEFAULT FND_API.G_MISS_NUM,
135: p_min_acc_unit IN NUMBER DEFAULT FND_API.G_MISS_NUM,
128: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
131: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
132: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
133: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
134: p_precision IN NUMBER DEFAULT FND_API.G_MISS_NUM,
135: p_min_acc_unit IN NUMBER DEFAULT FND_API.G_MISS_NUM,
136: x_functional_amount OUT NOCOPY NUMBER,
129: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
131: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
132: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
133: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
134: p_precision IN NUMBER DEFAULT FND_API.G_MISS_NUM,
135: p_min_acc_unit IN NUMBER DEFAULT FND_API.G_MISS_NUM,
136: x_functional_amount OUT NOCOPY NUMBER,
137: x_return_status OUT NOCOPY VARCHAR2,
130: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
131: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
132: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
133: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
134: p_precision IN NUMBER DEFAULT FND_API.G_MISS_NUM,
135: p_min_acc_unit IN NUMBER DEFAULT FND_API.G_MISS_NUM,
136: x_functional_amount OUT NOCOPY NUMBER,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
131: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
132: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
133: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
134: p_precision IN NUMBER DEFAULT FND_API.G_MISS_NUM,
135: p_min_acc_unit IN NUMBER DEFAULT FND_API.G_MISS_NUM,
136: x_functional_amount OUT NOCOPY NUMBER,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2
168: | |
169: +===========================================================================*/
170:
171: PROCEDURE Get_Func_Amt_Rate(
172: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
175: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
169: +===========================================================================*/
170:
171: PROCEDURE Get_Func_Amt_Rate(
172: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
175: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
177: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
170:
171: PROCEDURE Get_Func_Amt_Rate(
172: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
175: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
177: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_amount_functional OUT NOCOPY NUMBER,
171: PROCEDURE Get_Func_Amt_Rate(
172: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
175: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
177: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_amount_functional OUT NOCOPY NUMBER,
179: x_return_status OUT NOCOPY VARCHAR2,
172: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
175: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
177: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_amount_functional OUT NOCOPY NUMBER,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
175: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
177: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_amount_functional OUT NOCOPY NUMBER,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2
215: | |
216: +===========================================================================*/
217:
218: PROCEDURE Get_Func_Amt_Curr(
219: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
220: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
223: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
216: +===========================================================================*/
217:
218: PROCEDURE Get_Func_Amt_Curr(
219: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
220: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
223: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
224: p_currency_original IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217:
218: PROCEDURE Get_Func_Amt_Curr(
219: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
220: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
223: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
224: p_currency_original IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_exchange_date IN DATE DEFAULT FND_API.G_MISS_DATE,
218: PROCEDURE Get_Func_Amt_Curr(
219: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
220: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
223: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
224: p_currency_original IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_exchange_date IN DATE DEFAULT FND_API.G_MISS_DATE,
226: x_amount_functional OUT NOCOPY NUMBER,
219: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
220: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
223: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
224: p_currency_original IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_exchange_date IN DATE DEFAULT FND_API.G_MISS_DATE,
226: x_amount_functional OUT NOCOPY NUMBER,
227: x_return_status OUT NOCOPY VARCHAR2,
220: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
223: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
224: p_currency_original IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_exchange_date IN DATE DEFAULT FND_API.G_MISS_DATE,
226: x_amount_functional OUT NOCOPY NUMBER,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
221: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
223: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
224: p_currency_original IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_exchange_date IN DATE DEFAULT FND_API.G_MISS_DATE,
226: x_amount_functional OUT NOCOPY NUMBER,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2
260: | jypark 23-NOV-99 Created |
261: | |
262: +===========================================================================*/
263: PROCEDURE Get_Convert_Amount_Curr(
264: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
265: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
267: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
268: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
261: | |
262: +===========================================================================*/
263: PROCEDURE Get_Convert_Amount_Curr(
264: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
265: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
267: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
268: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
269: p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
262: +===========================================================================*/
263: PROCEDURE Get_Convert_Amount_Curr(
264: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
265: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
267: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
268: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
269: p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
270: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
263: PROCEDURE Get_Convert_Amount_Curr(
264: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
265: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
267: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
268: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
269: p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
270: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
271: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
264: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
265: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
267: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
268: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
269: p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
270: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
271: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
272: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
265: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
267: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
268: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
269: p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
270: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
271: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
272: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
273: x_amount_converted OUT NOCOPY NUMBER,
266: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
267: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
268: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
269: p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
270: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
271: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
272: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
273: x_amount_converted OUT NOCOPY NUMBER,
274: x_return_status OUT NOCOPY VARCHAR2,
267: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
268: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
269: p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
270: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
271: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
272: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
273: x_amount_converted OUT NOCOPY NUMBER,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
268: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
269: p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
270: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
271: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
272: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
273: x_amount_converted OUT NOCOPY NUMBER,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2
309: | jypark 23-NOV-99 Created |
310: | |
311: +===========================================================================*/
312: PROCEDURE get_convert_amount_sob(
313: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
314: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
317: p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: | |
311: +===========================================================================*/
312: PROCEDURE get_convert_amount_sob(
313: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
314: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
317: p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: +===========================================================================*/
312: PROCEDURE get_convert_amount_sob(
313: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
314: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
317: p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
312: PROCEDURE get_convert_amount_sob(
313: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
314: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
317: p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
320: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
314: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
317: p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
320: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
314: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
317: p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
320: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: x_amount_converted OUT NOCOPY NUMBER,
315: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
317: p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
320: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: x_amount_converted OUT NOCOPY NUMBER,
323: x_return_status OUT NOCOPY VARCHAR2,
316: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
317: p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
320: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: x_amount_converted OUT NOCOPY NUMBER,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
317: p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
320: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: x_amount_converted OUT NOCOPY NUMBER,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
325: x_msg_data OUT NOCOPY VARCHAR2
350: | jypark 23-NOV-99 Created |
351: | |
352: +===========================================================================*/
353: PROCEDURE Get_Funct_Curr(
354: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
355: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
356: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
358: x_functional_currency OUT NOCOPY VARCHAR2,
351: | |
352: +===========================================================================*/
353: PROCEDURE Get_Funct_Curr(
354: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
355: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
356: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
358: x_functional_currency OUT NOCOPY VARCHAR2,
359: x_return_status OUT NOCOPY VARCHAR2,
352: +===========================================================================*/
353: PROCEDURE Get_Funct_Curr(
354: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
355: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
356: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
358: x_functional_currency OUT NOCOPY VARCHAR2,
359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
353: PROCEDURE Get_Funct_Curr(
354: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
355: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
356: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
358: x_functional_currency OUT NOCOPY VARCHAR2,
359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2
381: | jypark 23-NOV-99 Created |
382: | |
383: +===========================================================================*/
384: PROCEDURE Get_Format_Mask(
385: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
389: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
382: | |
383: +===========================================================================*/
384: PROCEDURE Get_Format_Mask(
385: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
389: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
390: p_field_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
383: +===========================================================================*/
384: PROCEDURE Get_Format_Mask(
385: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
389: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
390: p_field_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
391: x_format_mask OUT NOCOPY VARCHAR2,
384: PROCEDURE Get_Format_Mask(
385: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
389: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
390: p_field_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
391: x_format_mask OUT NOCOPY VARCHAR2,
392: x_return_status OUT NOCOPY VARCHAR2,
385: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
389: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
390: p_field_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
391: x_format_mask OUT NOCOPY VARCHAR2,
392: x_return_status OUT NOCOPY VARCHAR2,
393: x_msg_count OUT NOCOPY NUMBER,
386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
389: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
390: p_field_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
391: x_format_mask OUT NOCOPY VARCHAR2,
392: x_return_status OUT NOCOPY VARCHAR2,
393: x_msg_count OUT NOCOPY NUMBER,
394: x_msg_data OUT NOCOPY VARCHAR2