APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_RESULTS_INTERFACE_PKG

Line 946: qa_results_interface_pkg.get_plan_vqr_sql (p_plan_id);

942: --should not have '@' at the beginning or end
943: --
944:
945: SelectFromClause :=
946: qa_results_interface_pkg.get_plan_vqr_sql (p_plan_id);
947:
948: --below for direct link, first check coll id and occ values
949:
950: if (p_collection_id is not null and p_occurrence is not null

Line 979: qa_results_interface_pkg.get_plan_vqr_sql (p_child_plan_id);

975: WhereClause VARCHAR2(20000);
976: BEGIN
977:
978: SelectFromClause :=
979: qa_results_interface_pkg.get_plan_vqr_sql (p_child_plan_id);
980:
981:
982: WhereClause := ' WHERE PLAN_ID = ' || p_child_plan_id
983: || ' AND (COLLECTION_ID, OCCURRENCE) IN (SELECT CHILD_COLLECTION_ID, CHILD_OCCURRENCE FROM QA_PC_RESULTS_RELATIONSHIP WHERE PARENT_OCCURRENCE = ' || p_parent_occurrence || ' AND CHILD_PLAN_ID = ' || p_child_plan_id || ' ) ';

Line 1002: qa_results_interface_pkg.get_plan_vqr_sql (p_parent_plan_id);

998: WhereClause VARCHAR2(20000);
999: BEGIN
1000:
1001: SelectFromClause :=
1002: qa_results_interface_pkg.get_plan_vqr_sql (p_parent_plan_id);
1003:
1004:
1005: WhereClause := ' WHERE PLAN_ID = ' || p_parent_plan_id
1006: || ' AND COLLECTION_ID = ' || p_parent_collection_id