DBA Data[Home] [Help]

APPS.IEX_CURRENCY_PVT dependencies on FND_API

Line 39: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 40: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 41: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 42: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 43: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 76: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 77: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 78: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 79: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 80: p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 127: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 128: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 129: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 130: p_validation_level 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,

Line 131: p_amount 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,

Line 132: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 133: p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 134: p_precision IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 135: p_min_acc_unit 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,
139: x_msg_data OUT NOCOPY VARCHAR2

Line 172: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 174: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 175: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 176: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 177: p_exchange_rate 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,
181: x_msg_data OUT NOCOPY VARCHAR2

Line 219: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 220: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 221: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 222: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 223: p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 224: p_currency_original IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 225: p_exchange_date IN DATE DEFAULT FND_API.G_MISS_DATE,

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

Line 264: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 265: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 266: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 267: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 268: p_from_currency 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,

Line 269: p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 270: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 271: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 272: p_amount_original 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,
276: x_msg_data OUT NOCOPY VARCHAR2

Line 313: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 314: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 315: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 316: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 317: p_set_of_books_id 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,

Line 318: p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 319: p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 320: p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 321: p_amount_original 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,
325: x_msg_data OUT NOCOPY VARCHAR2

Line 354: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 355: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 356: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 357: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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

Line 385: p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 388: p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 389: p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 390: p_field_length 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,
394: x_msg_data OUT NOCOPY VARCHAR2