DBA Data[Home] [Help]

APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_RESULTS_INTERFACE_PKG

Line 950: qa_results_interface_pkg.get_plan_vqr_sql (p_plan_id);

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

Line 985: qa_results_interface_pkg.get_plan_vqr_sql (p_child_plan_id);

981: WhereClause VARCHAR2(20000);
982: BEGIN
983:
984: SelectFromClause :=
985: qa_results_interface_pkg.get_plan_vqr_sql (p_child_plan_id);
986:
987:
988: -- Bug 9773013.Forward porting bug#9207821.Added condition of status = 2 to pick only
989: -- valid child records.pdube

Line 1011: qa_results_interface_pkg.get_plan_vqr_sql (p_parent_plan_id);

1007: WhereClause VARCHAR2(20000);
1008: BEGIN
1009:
1010: SelectFromClause :=
1011: qa_results_interface_pkg.get_plan_vqr_sql (p_parent_plan_id);
1012:
1013:
1014: -- Bug 9773013 FP to 9492520.Added condition for status.pdube
1015: WhereClause := ' WHERE PLAN_ID = ' || p_parent_plan_id