eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OAM_DSCRAM_ARGS_PKG dependencies on FND_NUMBER

Line 58: l_num := FND_NUMBER.CANONICAL_TO_NUMBER(p_canonical_value);

54: CASE p_arg.datatype
55: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2 THEN
56: null; --no validation
57: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
58: l_num := FND_NUMBER.CANONICAL_TO_NUMBER(p_canonical_value);
59: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
60: l_date := FND_DATE.CANONICAL_TO_DATE(p_canonical_value);
61: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
62: --for some reason, this is refusing to throw an exception on invalid values

Line 219: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID);

215:
216: --do a big case statement on the state key to fetch the value
217: CASE p_state_key
218: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_RUN_ID THEN
219: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID);
220:
221: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_RUN_MODE THEN
222: l_canonical_value := FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE;
223:

Line 225: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID);

221: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_RUN_MODE THEN
222: l_canonical_value := FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE;
223:
224: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_ID THEN
225: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID);
226:
227: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_WORKERS_ALLOWED THEN
228: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED);
229:

Line 228: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED);

224: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_ID THEN
225: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID);
226:
227: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_WORKERS_ALLOWED THEN
228: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED);
229:
230: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_BATCH_SIZE THEN
231: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE);
232:

Line 231: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE);

227: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_WORKERS_ALLOWED THEN
228: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED);
229:
230: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_BATCH_SIZE THEN
231: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE);
232:
233: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_WORKER_ID THEN
234: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID);
235:

Line 234: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID);

230: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_BATCH_SIZE THEN
231: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE);
232:
233: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_WORKER_ID THEN
234: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID);
235:
236: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_TASK_ID THEN
237: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID);
238:

Line 237: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID);

233: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_WORKER_ID THEN
234: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID);
235:
236: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_TASK_ID THEN
237: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID);
238:
239: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_UNIT_ID THEN
240: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_UNITS_PKG.GET_UNIT_ID);
241:

Line 240: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_UNITS_PKG.GET_UNIT_ID);

236: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_TASK_ID THEN
237: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID);
238:
239: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_UNIT_ID THEN
240: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_UNITS_PKG.GET_UNIT_ID);
241:
242: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_USING_SPLITTING THEN
243: l_canonical_value := FND_OAM_DSCRAM_UTILS_PKG.BOOLEAN_TO_FLAG(p_using_splitting);
244:

Line 258: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_UNITS_PKG.GET_WORKERS_ALLOWED);

254: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_UNIT_OBJECT_NAME THEN
255: l_canonical_value := FND_OAM_DSCRAM_UNITS_PKG.GET_UNIT_OBJECT_NAME;
256:
257: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_UNIT_WORKERS_ALLOWED THEN
258: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_UNITS_PKG.GET_WORKERS_ALLOWED);
259:
260: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_UNIT_BATCH_SIZE THEN
261: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_UNITS_PKG.GET_BATCH_SIZE);
262:

Line 261: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_UNITS_PKG.GET_BATCH_SIZE);

257: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_UNIT_WORKERS_ALLOWED THEN
258: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_UNITS_PKG.GET_WORKERS_ALLOWED);
259:
260: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_UNIT_BATCH_SIZE THEN
261: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_UNITS_PKG.GET_BATCH_SIZE);
262:
263: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_DML_ID THEN
264: l_canonical_value := FND_OAM_DSCRAM_DMLS_PKG.GET_CURRENT_DML_ID;
265:

Line 270: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(px_arg.arg_id);

266: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_PLSQL_ID THEN
267: l_canonical_value := FND_OAM_DSCRAM_PLSQLS_PKG.GET_CURRENT_PLSQL_ID;
268:
269: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_ARGUMENT_ID THEN
270: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(px_arg.arg_id);
271:
272: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_WORKERS_ALLOWED THEN
273: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_WORKERS_ALLOWED,
274: FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED));

Line 273: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_WORKERS_ALLOWED,

269: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_ARGUMENT_ID THEN
270: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(px_arg.arg_id);
271:
272: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_WORKERS_ALLOWED THEN
273: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_WORKERS_ALLOWED,
274: FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED));
275:
276: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BATCH_SIZE THEN
277: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_BATCH_SIZE,

Line 277: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_BATCH_SIZE,

273: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_WORKERS_ALLOWED,
274: FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED));
275:
276: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BATCH_SIZE THEN
277: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_BATCH_SIZE,
278: FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE));
279: ELSE
280: x_return_msg := 'ARG ID('||px_arg.arg_id||'), invalid state key: '||p_state_key;
281: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

Line 340: x_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);

336: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
337: DBMS_SQL.VARIABLE_VALUE(p_execution_cursor_id,
338: l_bindvar_name,
339: l_number);
340: x_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);
341:
342: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
343: DBMS_SQL.VARIABLE_VALUE(p_execution_cursor_id,
344: l_bindvar_name,

Line 425: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);

421: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2 THEN
422: EXECUTE IMMEDIATE p_final_sql_stmt INTO l_canonical_value;
423: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
424: EXECUTE IMMEDIATE p_final_sql_stmt INTO l_number;
425: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);
426: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
427: EXECUTE IMMEDIATE p_final_sql_stmt INTO l_date;
428: l_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);
429: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN

Line 479: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);

475: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
476: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,
477: 1,
478: l_number);
479: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);
480: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
481: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,
482: 1,
483: l_date);

Line 1682: x_value := FND_NUMBER.CANONICAL_TO_NUMBER(l_varchar2);

1678: x_return_msg := l_return_msg;
1679: x_value := NULL;
1680: RETURN;
1681: END IF;
1682: x_value := FND_NUMBER.CANONICAL_TO_NUMBER(l_varchar2);
1683:
1684: --return success
1685: x_return_status := FND_API.G_RET_STS_SUCCESS;
1686: RETURN;

Line 2252: fnd_oam_debug.log(1, l_ctxt, 'Value(NUMBER): '||FND_NUMBER.NUMBER_TO_CANONICAL(l_number));

2248: l_number,
2249: l_return_status,
2250: l_return_msg);
2251: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2252: fnd_oam_debug.log(1, l_ctxt, 'Value(NUMBER): '||FND_NUMBER.NUMBER_TO_CANONICAL(l_number));
2253: ELSE
2254: --or fail
2255: x_return_status := l_return_status;
2256: x_return_msg := l_return_msg;