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.

[Home] [Help]

APPS.QA_VALIDATION_API dependencies on QA_CHARS

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 2551: qa_chars qpcv

2547: SELECT
2548: qpcao.char_id,
2549: qpcv.datatype
2550: FROM qa_plan_char_action_outputs qpcao,
2551: qa_chars qpcv
2552: WHERE plan_char_action_id = pca_id
2553: AND token_name = token
2554: AND qpcao.char_id = qpcv.char_id;
2555:

Line 2643: FROM qa_chars qc,

2639: SELECT
2640: qpca.assign_type,
2641: qc.datatype,
2642: nvl(qpc.decimal_precision, qc.decimal_precision) decimal_precision
2643: FROM qa_chars qc,
2644: qa_plan_chars qpc,
2645: qa_plan_char_actions qpca,
2646: qa_plan_char_action_triggers qpcat
2647: WHERE

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 4025: FROM qa_chars

4021: p_char_id IN NUMBER) RETURN BOOLEAN IS
4022:
4023: CURSOR sql_valid(x_char_id NUMBER) IS
4024: SELECT 1
4025: FROM qa_chars
4026: WHERE char_id = x_char_id AND
4027: sql_validation_string is not null;
4028: p_sql_validation_flag BOOLEAN;
4029: temp NUMBER := 0; -- Flag number 1 for true and 0 for false

Line 4073: qa_chars qc

4069: --Collection plan
4070: SELECT qpc.char_id bulk collect
4071: INTO hardcoded_char_tab
4072: FROM qa_plan_chars qpc,
4073: qa_chars qc
4074: WHERE qpc.plan_id = p_plan_id
4075: AND qpc.char_id = qc.char_id
4076: AND qc.hardcoded_column IS NOT NULL
4077: AND fk_table_name IS NOT NULL;

Line 4085: from qa_chars

4081: LOOP
4082: -- Select the column name for the Hardcoded
4083: -- element based on the element id
4084: Select upper(translate(name,' ''*{}','_____')) into char_name
4085: from qa_chars
4086: where char_id = hardcoded_char_tab(cntr);
4087:
4088: --
4089: -- bug 7559568

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 || ',' ||

Line 4403: from qa_chars qc,

4399: CURSOR plan_chars IS
4400: select upper(translate(qc.name,' ''*{}','_____')) name,
4401: qpc.char_id char_id,
4402: qc.datatype
4403: from qa_chars qc,
4404: qa_plan_chars qpc
4405: WHERE qc.char_id = qpc.char_id
4406: AND qpc.plan_id = p_plan_id
4407: ORDER BY qpc.prompt_sequence;