APPS.QA_TXN_GRP dependencies on QA_PARENT_CHILD_PKG

Line 382: p_plans_tab IN QA_PARENT_CHILD_PKG.ChildPlanArray,

378: PROCEDURE evaltriggers_InsertRes_eamtxn(
379: p_txn_number IN NUMBER,
380: p_org_id IN NUMBER,
381: p_context_values IN VARCHAR2,
382: p_plans_tab IN QA_PARENT_CHILD_PKG.ChildPlanArray,
383: p_collection_id IN NUMBER) IS
384:
385: elements ElementsArray;
386: denormalized_values ElementsArray;

Line 700: plan_id_tab QA_PARENT_CHILD_PKG.ChildPlanArray;

696: FROM qa_results qr
697: WHERE qr.plan_id = qpt.plan_id
698: AND qr.collection_id = col_id);
699:
700: plan_id_tab QA_PARENT_CHILD_PKG.ChildPlanArray;
701:
702: BEGIN
703: -- Populating the array of the Plan_ids with the
704: -- Plan Txn Ids as the Indices

Line 823: QA_PARENT_CHILD_PKG.find_parent(

819: open child_rec(child_collection_id);
820: fetch child_rec into child_plan_id, child_occurrence;
821:
822: parent_rec_found :=
823: QA_PARENT_CHILD_PKG.find_parent(
824: p_child_plan_id => child_plan_id,
825: p_child_collection_id => child_collection_id,
826: p_child_occurrence => child_occurrence,
827: x_parent_plan_id => parent_plan_id,

Line 834: QA_PARENT_CHILD_PKG.relate(

830:
831: If parent_rec_found = 'T' then
832: Loop
833: -- 12.1 QWB Usability improvements
834: QA_PARENT_CHILD_PKG.relate(
835: p_parent_plan_id => parent_plan_id,
836: p_parent_collection_id => parent_collection_id,
837: p_parent_occurrence => parent_occurrence,
838: p_child_plan_id => child_plan_id,

Line 1108: QA_PARENT_CHILD_PKG.get_criteria_values

1104: 'BEFORE GETTING PC CRITERIA VALUES'
1105: );
1106: END IF;
1107:
1108: QA_PARENT_CHILD_PKG.get_criteria_values
1109: (
1110: p_parent_plan_id => p_plan_id,
1111: p_parent_collection_id => p_collection_id,
1112: p_parent_occurrence => p_occurrence,

Line 1127: QA_PARENT_CHILD_PKG.evaluate_criteria

1123: );
1124: END IF;
1125:
1126: x_return_status :=
1127: QA_PARENT_CHILD_PKG.evaluate_criteria
1128: (
1129: p_plan_id => p_plan_id,
1130: p_criteria_values => x_criteria_values,
1131: p_relationship_type => p_relationship_type,

Line 1174: QA_PARENT_CHILD_PKG.insert_automatic_records

1170: x_child_plan_ids => l_child_plan_ids
1171: );
1172:
1173: IF( l_return_status = 'T' ) THEN
1174: QA_PARENT_CHILD_PKG.insert_automatic_records
1175: (
1176: p_plan_id => p_plan_id,
1177: p_collection_id => p_collection_id,
1178: p_occurrence => p_occurrence,

Line 1381: -- Modified to call new overloaded QA_PARENT_CHILD_PKG.commit_allowed

1377: END IF;
1378:
1379: -- Check if Results have been submitted for Immediate Child Plans
1380: -- Bug 5161719. SHKALYAN 13-Apr-2006
1381: -- Modified to call new overloaded QA_PARENT_CHILD_PKG.commit_allowed
1382: -- so that incomplete child plan ids are obtained
1383: l_return_status :=
1384: QA_PARENT_CHILD_PKG.commit_allowed
1385: (

Line 1384: QA_PARENT_CHILD_PKG.commit_allowed

1380: -- Bug 5161719. SHKALYAN 13-Apr-2006
1381: -- Modified to call new overloaded QA_PARENT_CHILD_PKG.commit_allowed
1382: -- so that incomplete child plan ids are obtained
1383: l_return_status :=
1384: QA_PARENT_CHILD_PKG.commit_allowed
1385: (
1386: p_plan_id => l_plans(i),
1387: p_collection_id => p_collection_id,
1388: p_occurrence => l_occurrences(i),