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.QA_VALIDATION_API dependencies on QLTDATE

Line 2198: -- We use qltdate.number_to_cannon to ensure that there are no errors

2194: -- Bug 3303276
2195: -- Decimal precision of numbers was not being used. The new call
2196: -- uses the passed precision to round off the number according to
2197: -- the precision specified in the plan
2198: -- We use qltdate.number_to_cannon to ensure that there are no errors
2199: -- if the number is in format 1,2345 instead of 1.2345 (a German user
2200: -- perhaps).
2201:
2202: --result_holder.canonical_value := qltdate.any_to_number(value);

Line 2202: --result_holder.canonical_value := qltdate.any_to_number(value);

2198: -- We use qltdate.number_to_cannon to ensure that there are no errors
2199: -- if the number is in format 1,2345 instead of 1.2345 (a German user
2200: -- perhaps).
2201:
2202: --result_holder.canonical_value := qltdate.any_to_number(value);
2203: result_holder.canonical_value := qltdate.number_to_canon(
2204: round(qltdate.any_to_number(value),
2205: nvl(precision, 240)));
2206:

Line 2203: result_holder.canonical_value := qltdate.number_to_canon(

2199: -- if the number is in format 1,2345 instead of 1.2345 (a German user
2200: -- perhaps).
2201:
2202: --result_holder.canonical_value := qltdate.any_to_number(value);
2203: result_holder.canonical_value := qltdate.number_to_canon(
2204: round(qltdate.any_to_number(value),
2205: nvl(precision, 240)));
2206:
2207: RETURN ok;

Line 2204: round(qltdate.any_to_number(value),

2200: -- perhaps).
2201:
2202: --result_holder.canonical_value := qltdate.any_to_number(value);
2203: result_holder.canonical_value := qltdate.number_to_canon(
2204: round(qltdate.any_to_number(value),
2205: nvl(precision, 240)));
2206:
2207: RETURN ok;
2208:

Line 2222: result_holder.canonical_value := qltdate.any_to_canon(value);

2218: RETURN NUMBER IS
2219:
2220: BEGIN
2221: -- convert it to canonical format
2222: result_holder.canonical_value := qltdate.any_to_canon(value);
2223: RETURN ok;
2224:
2225: EXCEPTION
2226: WHEN OTHERS THEN

Line 2252: -- be in the format 'DD-MON-RRRR HH24:MI:SS'. So used qltdate.any_to_user_dt to convert

2248:
2249: -- Bug 4965371
2250: -- Convert the format of the argument value which would be '2005/12/21 17:09:36' to the
2251: -- format compatible to the fnd_date.displayDT_to_date function which needs the value to
2252: -- be in the format 'DD-MON-RRRR HH24:MI:SS'. So used qltdate.any_to_user_dt to convert
2253: -- the value to the format 'DD-MON-RRRR HH24:MI:SS' and then call the Fnd_date functions.
2254: -- ntungare Sun Feb 12 04:35:39 PST 2006
2255:
2256: l_value := qltdate.any_to_user_dt(value);

Line 2256: l_value := qltdate.any_to_user_dt(value);

2252: -- be in the format 'DD-MON-RRRR HH24:MI:SS'. So used qltdate.any_to_user_dt to convert
2253: -- the value to the format 'DD-MON-RRRR HH24:MI:SS' and then call the Fnd_date functions.
2254: -- ntungare Sun Feb 12 04:35:39 PST 2006
2255:
2256: l_value := qltdate.any_to_user_dt(value);
2257:
2258: -- convert the value to server tz and then to canonical.
2259: -- Bug 4965371
2260: -- Using the converted value

Line 2631: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';

2627: -- be copied to the target element (or) would error out in SSQR.
2628: if token_datatype in (1,4) then
2629: bind_var_name := bind_var_name;
2630: elsif token_datatype = 2 then
2631: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';
2632: elsif token_datatype = 3 then
2633: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2634:
2635: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003

Line 2633: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';

2629: bind_var_name := bind_var_name;
2630: elsif token_datatype = 2 then
2631: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';
2632: elsif token_datatype = 3 then
2633: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2634:
2635: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2636: elsif token_datatype = 6 then -- datetime
2637: bind_var_name := 'qltdate.any_to_datetime(' || bind_var_name || ')';

Line 2637: bind_var_name := 'qltdate.any_to_datetime(' || bind_var_name || ')';

2633: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2634:
2635: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2636: elsif token_datatype = 6 then -- datetime
2637: bind_var_name := 'qltdate.any_to_datetime(' || bind_var_name || ')';
2638: end if;
2639:
2640: --add the token value to the token value array and append the bind variable
2641: --reference string to the statement

Line 2746: return_value_char := qltdate.date_to_canon(return_value_date);

2742: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2743:
2744: -- dbms_sql.column_value(c1, 1, return_value_char);
2745: dbms_sql.column_value(c1, 1, return_value_date);
2746: return_value_char := qltdate.date_to_canon(return_value_date);
2747:
2748: ELSIF assigned_datatype = 6 THEN -- datetime
2749:
2750: dbms_sql.column_value(c1, 1, return_value_date);

Line 2751: return_value_char := qltdate.date_to_canon_dt(return_value_date);

2747:
2748: ELSIF assigned_datatype = 6 THEN -- datetime
2749:
2750: dbms_sql.column_value(c1, 1, return_value_date);
2751: return_value_char := qltdate.date_to_canon_dt(return_value_date);
2752:
2753: END IF;
2754: ELSE
2755: --if we didn't get anything then just give back a null

Line 4097: row_elements(p_element_id).value := QLTDATE.any_to_canon(UPPER(p_input_value));

4093:
4094: IF (qa_chars_api.datatype(p_element_id) IN (6,3) AND
4095: p_input_value is NOT NULL) THEN
4096: BEGIN
4097: row_elements(p_element_id).value := QLTDATE.any_to_canon(UPPER(p_input_value));
4098: EXCEPTION WHEN OTHERS THEN
4099: errors_list(1).error_code := invalid_date_error;
4100: errors_list(1).element_id := p_element_id;
4101: