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 QA_CHARS_API

Line 2164: sql_string := qa_chars_api.remove_order_by_from_sql(sql_string);

2160: -- Bug 11659488
2161: -- For So_line_number, the LOV has to be pruned by the SO_Header_id
2162: --
2163: IF (element_id IN (qa_ss_const.rma_line_num, qa_ss_const.order_line)) THEN -- add more elements if needed.
2164: sql_string := qa_chars_api.remove_order_by_from_sql(sql_string);
2165: IF (element_id = qa_ss_const.rma_line_num AND g_rma_header_id IS NOT NULL) THEN
2166: sql_string := sql_string || ' AND SH.HEADER_ID = ' || g_rma_header_id;
2167: END IF;
2168:

Line 2177: sql_string := qa_chars_api.format_sql_for_validation (sql_string,

2173: || ' AND mso.segment2 = ot.name AND mso.sales_order_id = '|| g_sales_order_id || ')';
2174: END IF;
2175: END IF;
2176:
2177: sql_string := qa_chars_api.format_sql_for_validation (sql_string,
2178: x_org_id, x_user_id);
2179:
2180: IF qa_plan_element_api.value_in_sql (sql_string, value) THEN
2181: RETURN ok;

Line 2370: data_type := qa_chars_api.datatype(element_id);

2366: BEGIN
2367: -- bug 3178307. rkaza. 10/06/2003.
2368: -- Modifed the function for Timezone Support.
2369:
2370: data_type := qa_chars_api.datatype(element_id);
2371:
2372: len := qa_chars_api.display_length(element_id);
2373:
2374: -- Bug 3318462. History child plans showing wrong

Line 2372: len := qa_chars_api.display_length(element_id);

2368: -- Modifed the function for Timezone Support.
2369:
2370: data_type := qa_chars_api.datatype(element_id);
2371:
2372: len := qa_chars_api.display_length(element_id);
2373:
2374: -- Bug 3318462. History child plans showing wrong
2375: -- client timezone. It is saving date time in client timezone
2376: -- for child plans due to this, difference is again added when

Line 2390: -- precision := qa_chars_api.decimal_precision(element_id);

2386: -- Validation would be appropriate when decimal precision is
2387: -- taken from plan definition rather than element setup
2388: --
2389: -- Before this change
2390: -- precision := qa_chars_api.decimal_precision(element_id);
2391: -- After this change
2392: -- precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2393: -- qa_chars_api.decimal_precision(element_id));
2394: --

Line 2393: -- qa_chars_api.decimal_precision(element_id));

2389: -- Before this change
2390: -- precision := qa_chars_api.decimal_precision(element_id);
2391: -- After this change
2392: -- precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2393: -- qa_chars_api.decimal_precision(element_id));
2394: --
2395: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
2396: --
2397:

Line 2399: qa_chars_api.decimal_precision(element_id));

2395: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
2396: --
2397:
2398: precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2399: qa_chars_api.decimal_precision(element_id));
2400:
2401: IF (data_type = qa_ss_const.date_datatype) THEN
2402: error_code := validate_date(value, result_holder);
2403:

Line 3035: assigned_element := qa_chars_api.prompt(target_element);

3031:
3032: message_index := message_array.count;
3033: message_array(message_index).element_id := element_id;
3034: message_array(message_index).action_type := qa_ss_const.assign_value_action;
3035: assigned_element := qa_chars_api.prompt(target_element);
3036:
3037: -- bug 3178307. rkaza. 10/07/2003. Timezone Support.
3038: If qa_chars_api.datatype(target_element) = qa_ss_const.datetime_datatype then
3039: assigned_value :=

Line 3038: If qa_chars_api.datatype(target_element) = qa_ss_const.datetime_datatype then

3034: message_array(message_index).action_type := qa_ss_const.assign_value_action;
3035: assigned_element := qa_chars_api.prompt(target_element);
3036:
3037: -- bug 3178307. rkaza. 10/07/2003. Timezone Support.
3038: If qa_chars_api.datatype(target_element) = qa_ss_const.datetime_datatype then
3039: assigned_value :=
3040: fnd_date.date_to_displayDT(fnd_date.canonical_to_date(assigned_value), calendar_aware=> FND_DATE.calendar_aware_alt);
3041: End if;
3042:

Line 3135: datatype := qa_chars_api.datatype(element_id);

3131:
3132: value := row_elements(element_id).value;
3133:
3134: -- rkaza. bug 3248836. 11/11/2003. tz bug.
3135: datatype := qa_chars_api.datatype(element_id);
3136:
3137: IF (datatype = qa_ss_const.datetime_datatype) THEN
3138: val_len := length(value);
3139: if substr(value, val_len - 1, 2) = '.0' then

Line 4240: IF (qa_chars_api.datatype(p_element_id) IN (6,3) AND

4236:
4237: -- Bug 9382356. Use l_input_value instead of p_input_value.
4238: l_result_string := result_string || '@' || p_element_id || '=' || l_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

Line 4314: normalized_attr := qa_chars_api.hardcoded_column(p_element_id);

4310: IF ((qa_plan_element_api.keyflex(p_element_id) OR
4311: qa_plan_element_api.normalized(p_element_id)) = TRUE) THEN
4312: normalized_id_val := result_record.id;
4313: -- Set the normalized element VO attribute
4314: normalized_attr := qa_chars_api.hardcoded_column(p_element_id);
4315:
4316: IF normalized_id_val is NOT NULL THEN
4317: l_id_string := id_string || '@'|| p_element_id || '=' || normalized_id_val;
4318: ELSE

Line 4374: qa_chars_api.hardcoded_column(dependent_elements_arr(dep_elem_ctr));

4370: END IF;
4371:
4372: -- Getting the HC id column
4373: disabled_dep_elem_id_attr :=
4374: qa_chars_api.hardcoded_column(dependent_elements_arr(dep_elem_ctr));
4375:
4376: IF (disabled_dep_elem_id_attr IS NOT NULL AND
4377: disabled_dep_elem_id_attr <> disabled_dep_elem_vo_attr) THEN
4378: disabled_dep_elem_vo_attr_lst := disabled_dep_elem_vo_attr_lst || ',' ||