DBA Data[Home] [Help]

APPS.QA_VALIDATION_API dependencies on QA_CHARS_API

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

2106: END IF;
2107:
2108: sql_string := qa_plan_element_api.get_sql_validation_string(element_id);
2109:
2110: sql_string := qa_chars_api.format_sql_for_validation (sql_string,
2111: x_org_id, x_user_id);
2112:
2113: IF qa_plan_element_api.value_in_sql (sql_string, value) THEN
2114: RETURN ok;

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

2299: BEGIN
2300: -- bug 3178307. rkaza. 10/06/2003.
2301: -- Modifed the function for Timezone Support.
2302:
2303: data_type := qa_chars_api.datatype(element_id);
2304:
2305: len := qa_chars_api.display_length(element_id);
2306:
2307: -- Bug 3318462. History child plans showing wrong

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

2301: -- Modifed the function for Timezone Support.
2302:
2303: data_type := qa_chars_api.datatype(element_id);
2304:
2305: len := qa_chars_api.display_length(element_id);
2306:
2307: -- Bug 3318462. History child plans showing wrong
2308: -- client timezone. It is saving date time in client timezone
2309: -- for child plans due to this, difference is again added when

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

2319: -- Validation would be appropriate when decimal precision is
2320: -- taken from plan definition rather than element setup
2321: --
2322: -- Before this change
2323: -- precision := qa_chars_api.decimal_precision(element_id);
2324: -- After this change
2325: -- precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2326: -- qa_chars_api.decimal_precision(element_id));
2327: --

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

2322: -- Before this change
2323: -- precision := qa_chars_api.decimal_precision(element_id);
2324: -- After this change
2325: -- precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2326: -- qa_chars_api.decimal_precision(element_id));
2327: --
2328: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
2329: --
2330:

Line 2332: qa_chars_api.decimal_precision(element_id));

2328: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
2329: --
2330:
2331: precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2332: qa_chars_api.decimal_precision(element_id));
2333:
2334: IF (data_type = qa_ss_const.date_datatype) THEN
2335: error_code := validate_date(value, result_holder);
2336:

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

2964:
2965: message_index := message_array.count;
2966: message_array(message_index).element_id := element_id;
2967: message_array(message_index).action_type := qa_ss_const.assign_value_action;
2968: assigned_element := qa_chars_api.prompt(target_element);
2969:
2970: -- bug 3178307. rkaza. 10/07/2003. Timezone Support.
2971: If qa_chars_api.datatype(target_element) = qa_ss_const.datetime_datatype then
2972: assigned_value :=

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

2967: message_array(message_index).action_type := qa_ss_const.assign_value_action;
2968: assigned_element := qa_chars_api.prompt(target_element);
2969:
2970: -- bug 3178307. rkaza. 10/07/2003. Timezone Support.
2971: If qa_chars_api.datatype(target_element) = qa_ss_const.datetime_datatype then
2972: assigned_value :=
2973: fnd_date.date_to_displayDT(fnd_date.canonical_to_date(assigned_value));
2974: End if;
2975:

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

3064:
3065: value := row_elements(element_id).value;
3066:
3067: -- rkaza. bug 3248836. 11/11/2003. tz bug.
3068: datatype := qa_chars_api.datatype(element_id);
3069:
3070: IF (datatype = qa_ss_const.datetime_datatype) THEN
3071: val_len := length(value);
3072: if substr(value, val_len - 1, 2) = '.0' then

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

4090: row_elements(p_element_id).value := p_input_value;
4091:
4092: l_result_string := result_string || '@' || p_element_id || '=' || 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

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

4164: IF ((qa_plan_element_api.keyflex(p_element_id) OR
4165: qa_plan_element_api.normalized(p_element_id)) = TRUE) THEN
4166: normalized_id_val := result_record.id;
4167: -- Set the normalized element VO attribute
4168: normalized_attr := qa_chars_api.hardcoded_column(p_element_id);
4169:
4170: IF normalized_id_val is NOT NULL THEN
4171: l_id_string := id_string || '@'|| p_element_id || '=' || normalized_id_val;
4172: ELSE

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

4224: END IF;
4225:
4226: -- Getting the HC id column
4227: disabled_dep_elem_id_attr :=
4228: qa_chars_api.hardcoded_column(dependent_elements_arr(dep_elem_ctr));
4229:
4230: IF (disabled_dep_elem_id_attr IS NOT NULL AND
4231: disabled_dep_elem_id_attr <> disabled_dep_elem_vo_attr) THEN
4232: disabled_dep_elem_vo_attr_lst := disabled_dep_elem_vo_attr_lst || ',' ||