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 2265: -- We use qltdate.number_to_cannon to ensure that there are no errors

2261: -- Bug 3303276
2262: -- Decimal precision of numbers was not being used. The new call
2263: -- uses the passed precision to round off the number according to
2264: -- the precision specified in the plan
2265: -- We use qltdate.number_to_cannon to ensure that there are no errors
2266: -- if the number is in format 1,2345 instead of 1.2345 (a German user
2267: -- perhaps).
2268:
2269: --result_holder.canonical_value := qltdate.any_to_number(value);

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

2265: -- We use qltdate.number_to_cannon to ensure that there are no errors
2266: -- if the number is in format 1,2345 instead of 1.2345 (a German user
2267: -- perhaps).
2268:
2269: --result_holder.canonical_value := qltdate.any_to_number(value);
2270: result_holder.canonical_value := qltdate.number_to_canon(
2271: round(qltdate.any_to_number(value),
2272: nvl(precision, 240)));
2273:

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

2266: -- if the number is in format 1,2345 instead of 1.2345 (a German user
2267: -- perhaps).
2268:
2269: --result_holder.canonical_value := qltdate.any_to_number(value);
2270: result_holder.canonical_value := qltdate.number_to_canon(
2271: round(qltdate.any_to_number(value),
2272: nvl(precision, 240)));
2273:
2274: RETURN ok;

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

2267: -- perhaps).
2268:
2269: --result_holder.canonical_value := qltdate.any_to_number(value);
2270: result_holder.canonical_value := qltdate.number_to_canon(
2271: round(qltdate.any_to_number(value),
2272: nvl(precision, 240)));
2273:
2274: RETURN ok;
2275:

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

2285: RETURN NUMBER IS
2286:
2287: BEGIN
2288: -- convert it to canonical format
2289: result_holder.canonical_value := qltdate.any_to_canon(value);
2290: RETURN ok;
2291:
2292: EXCEPTION
2293: WHEN OTHERS THEN

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

2315:
2316: -- Bug 4965371
2317: -- Convert the format of the argument value which would be '2005/12/21 17:09:36' to the
2318: -- format compatible to the fnd_date.displayDT_to_date function which needs the value to
2319: -- be in the format 'DD-MON-RRRR HH24:MI:SS'. So used qltdate.any_to_user_dt to convert
2320: -- the value to the format 'DD-MON-RRRR HH24:MI:SS' and then call the Fnd_date functions.
2321: -- ntungare Sun Feb 12 04:35:39 PST 2006
2322:
2323: l_value := qltdate.any_to_user_dt(value);

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

2319: -- be in the format 'DD-MON-RRRR HH24:MI:SS'. So used qltdate.any_to_user_dt to convert
2320: -- the value to the format 'DD-MON-RRRR HH24:MI:SS' and then call the Fnd_date functions.
2321: -- ntungare Sun Feb 12 04:35:39 PST 2006
2322:
2323: l_value := qltdate.any_to_user_dt(value);
2324:
2325: -- convert the value to server tz and then to canonical.
2326: -- Bug 4965371
2327: -- Using the converted value

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

2694: -- be copied to the target element (or) would error out in SSQR.
2695: if token_datatype in (1,4) then
2696: bind_var_name := bind_var_name;
2697: elsif token_datatype = 2 then
2698: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';
2699: elsif token_datatype = 3 then
2700: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2701:
2702: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003

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

2696: bind_var_name := bind_var_name;
2697: elsif token_datatype = 2 then
2698: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';
2699: elsif token_datatype = 3 then
2700: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2701:
2702: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2703: elsif token_datatype = 6 then -- datetime
2704: bind_var_name := 'qltdate.any_to_datetime(' || bind_var_name || ')';

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

2700: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2701:
2702: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2703: elsif token_datatype = 6 then -- datetime
2704: bind_var_name := 'qltdate.any_to_datetime(' || bind_var_name || ')';
2705: end if;
2706:
2707: --add the token value to the token value array and append the bind variable
2708: --reference string to the statement

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

2809: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2810:
2811: -- dbms_sql.column_value(c1, 1, return_value_char);
2812: dbms_sql.column_value(c1, 1, return_value_date);
2813: return_value_char := qltdate.date_to_canon(return_value_date);
2814:
2815: ELSIF assigned_datatype = 6 THEN -- datetime
2816:
2817: dbms_sql.column_value(c1, 1, return_value_date);

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

2814:
2815: ELSIF assigned_datatype = 6 THEN -- datetime
2816:
2817: dbms_sql.column_value(c1, 1, return_value_date);
2818: return_value_char := qltdate.date_to_canon_dt(return_value_date);
2819:
2820: END IF;
2821: ELSE
2822: --if we didn't get anything then just give back a null

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

4239:
4240: IF (qa_chars_api.datatype(p_element_id) IN (6,3) AND
4241: p_input_value is NOT NULL) THEN
4242: BEGIN
4243: row_elements(p_element_id).value := QLTDATE.any_to_canon(UPPER(p_input_value));
4244: EXCEPTION WHEN OTHERS THEN
4245: errors_list(1).error_code := invalid_date_error;
4246: errors_list(1).element_id := p_element_id;
4247: