DBA Data[Home] [Help]

APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_PC_PLAN_RELATIONSHIP

Line 273: FROM qa_pc_plan_relationship

269: -- local variables will be used instead of input variables.
270: CURSOR c(c_parent_plan_id NUMBER,
271: c_child_plan_id NUMBER) IS
272: SELECT 1
273: FROM qa_pc_plan_relationship
274: WHERE parent_plan_id = c_parent_plan_id
275: AND child_plan_id = c_child_plan_id;
276:
277: BEGIN

Line 382: FROM qa_pc_plan_relationship

378: -- local variables will be used instead of inout variables.
379: CURSOR c(c_parent_plan_id NUMBER,
380: c_child_plan_id NUMBER) IS
381: SELECT 1
382: FROM qa_pc_plan_relationship
383: WHERE parent_plan_id = c_parent_plan_id
384: AND child_plan_id = c_child_plan_id;
385:
386: BEGIN

Line 721: from qa_pc_plan_relationship

717:
718: CURSOR c IS
719:
720: select rowid
721: from qa_pc_plan_relationship
722: where plan_relationship_id = p_plan_relationship_id;
723:
724: BEGIN
725:

Line 868: FROM qa_pc_plan_relationship

864: RETURN VARCHAR2 IS
865:
866: CURSOR c(c_child_plan_id NUMBER) IS
867: SELECT 1
868: FROM qa_pc_plan_relationship
869: WHERE parent_plan_id = c_child_plan_id;
870:
871: l_exists NUMBER:= -1;
872:

Line 1031: DELETE FROM QA_PC_PLAN_RELATIONSHIP

1027: PROCEDURE delete_plan_rel(p_plan_relationship_id NUMBER) IS
1028:
1029: BEGIN
1030:
1031: DELETE FROM QA_PC_PLAN_RELATIONSHIP
1032: WHERE plan_relationship_id = p_plan_relationship_id;
1033:
1034: DELETE FROM QA_PC_ELEMENT_RELATIONSHIP
1035: WHERE plan_relationship_id = p_plan_relationship_id;

Line 1063: from qa_pc_plan_relationship qpr, qa_plans qp

1059: l_search_array qa_txn_grp.ElementsArray;
1060:
1061: cursor l_plans_cursor IS
1062: select distinct qpr.parent_plan_id
1063: from qa_pc_plan_relationship qpr, qa_plans qp
1064: where qpr.parent_plan_id = qp.plan_id
1065: and qp.organization_id = p_org_id;
1066: BEGIN
1067: --sanity check, don't let them blink search using an org