APPS.QA_RESULTS_INTERFACE_PKG dependencies on QA_CORE_PKG

Line 76: column_name := upper(QA_CORE_PKG.get_result_column_name(element.char_id, given_plan_id));

72: elsif ((element.char_id = 15) or (element.char_id = 65)) then
73: column_name := 'qa_flex_util.locator(organization_id, locator_id) LOCATOR';
74:
75: else
76: column_name := upper(QA_CORE_PKG.get_result_column_name(element.char_id, given_plan_id));
77:
78: end if;
79:
80: if (first = 1) then

Line 195: column_name := upper(QA_CORE_PKG.get_result_column_name(element.char_id, p_plan_id));

191:
192: ELSIF not qa_plan_element_api.hardcoded(element.char_id) and
193: element.datatype in (qa_ss_const.date_datatype ,
194: qa_ss_const.datetime_datatype) then
195: column_name := upper(QA_CORE_PKG.get_result_column_name(element.char_id, p_plan_id));
196: column_name := 'fnd_date.canonical_to_date(' || column_name || ') ' || column_name;
197: ELSE
198: column_name := upper(QA_CORE_PKG.get_result_column_name(
199: element.char_id, p_plan_id));

Line 198: column_name := upper(QA_CORE_PKG.get_result_column_name(

194: qa_ss_const.datetime_datatype) then
195: column_name := upper(QA_CORE_PKG.get_result_column_name(element.char_id, p_plan_id));
196: column_name := 'fnd_date.canonical_to_date(' || column_name || ') ' || column_name;
197: ELSE
198: column_name := upper(QA_CORE_PKG.get_result_column_name(
199: element.char_id, p_plan_id));
200: END IF;
201:
202: IF (first = 1) THEN

Line 271: column_name := upper(QA_CORE_PKG.get_result_column_name(

267: ELSIF element_id = qa_ss_const.work_order THEN
268: column_name := 'qa_flex_util.work_order(organization_id, work_order_id)';
269:
270: ELSE
271: column_name := upper(QA_CORE_PKG.get_result_column_name(
272: element_id, p_plan_id));
273: END IF;
274:
275: where_clause := where_clause || ' and ' || column_name;

Line 658: if (QA_CORE_PKG.is_mandatory (GIVEN_PLAN_ID, ELEMENT_ID) = True) then

654: if (ELEMENT_ID is not null) then
655:
656:
657: if (ELEMENT_VALUE is null) then
658: if (QA_CORE_PKG.is_mandatory (GIVEN_PLAN_ID, ELEMENT_ID) = True) then
659: return 4;
660: end if;
661: end if;
662:

Line 663: element_name := QA_CORE_PKG.get_result_column_name (ELEMENT_ID, given_plan_id);

659: return 4;
660: end if;
661: end if;
662:
663: element_name := QA_CORE_PKG.get_result_column_name (ELEMENT_ID, given_plan_id);
664:
665: script := script || ', ' || element_name;
666:
667: if (QA_CORE_PKG.get_element_data_type(Element_ID) = 3 ) then

Line 667: if (QA_CORE_PKG.get_element_data_type(Element_ID) = 3 ) then

663: element_name := QA_CORE_PKG.get_result_column_name (ELEMENT_ID, given_plan_id);
664:
665: script := script || ', ' || element_name;
666:
667: if (QA_CORE_PKG.get_element_data_type(Element_ID) = 3 ) then
668: if (ELEMENT_ID = 1 ) then
669: date_flag := -1;
670: temp_date := qltdate.any_to_date(ELEMENT_VALUE);
671: date_flag := 0;

Line 678: elsif (QA_CORE_PKG.get_element_data_type(ELEMENT_ID) = 2 ) then

674: temp :=qltdate.any_to_canon(ELEMENT_VALUE);
675: tail_script := tail_script || ', ' || ''''|| temp || '''';
676: end if;
677:
678: elsif (QA_CORE_PKG.get_element_data_type(ELEMENT_ID) = 2 ) then
679: temp_num := to_number(ELEMENT_VALUE);
680: tail_script := tail_script || ', ' || ''''|| temp_num || '''';
681: else
682: tail_script := tail_script || ', ' || ''''|| dequote(ELEMENT_VALUE) || '''';

Line 723: QA_CORE_PKG.EXEC_SQL(final_script);

719: if (no_error) then
720:
721: final_script := script || ') ' || taiL_script || ')';
722: -- htp.p(final_script); htp.nl;
723: QA_CORE_PKG.EXEC_SQL(final_script);
724:
725: end if;
726:
727: