DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on QA_PARENT_CHILD_PKG

Line 417: p_plans_tab IN QA_PARENT_CHILD_PKG.ChildPlanArray,

413: PROCEDURE evaltriggers_InsertRes_eamtxn(
414: p_txn_number IN NUMBER,
415: p_org_id IN NUMBER,
416: p_context_values IN VARCHAR2,
417: p_plans_tab IN QA_PARENT_CHILD_PKG.ChildPlanArray,
418: p_collection_id IN NUMBER) IS
419:
420: elements ElementsArray;
421: denormalized_values ElementsArray;

Line 735: plan_id_tab QA_PARENT_CHILD_PKG.ChildPlanArray;

731: FROM qa_results qr
732: WHERE qr.plan_id = qpt.plan_id
733: AND qr.collection_id = col_id);
734:
735: plan_id_tab QA_PARENT_CHILD_PKG.ChildPlanArray;
736:
737: BEGIN
738: -- Populating the array of the Plan_ids with the
739: -- Plan Txn Ids as the Indices

Line 858: QA_PARENT_CHILD_PKG.find_parent(

854: open child_rec(child_collection_id);
855: fetch child_rec into child_plan_id, child_occurrence;
856:
857: parent_rec_found :=
858: QA_PARENT_CHILD_PKG.find_parent(
859: p_child_plan_id => child_plan_id,
860: p_child_collection_id => child_collection_id,
861: p_child_occurrence => child_occurrence,
862: x_parent_plan_id => parent_plan_id,

Line 869: QA_PARENT_CHILD_PKG.relate(

865:
866: If parent_rec_found = 'T' then
867: Loop
868: -- 12.1 QWB Usability improvements
869: QA_PARENT_CHILD_PKG.relate(
870: p_parent_plan_id => parent_plan_id,
871: p_parent_collection_id => parent_collection_id,
872: p_parent_occurrence => parent_occurrence,
873: p_child_plan_id => child_plan_id,

Line 1144: QA_PARENT_CHILD_PKG.get_criteria_values

1140: 'BEFORE GETTING PC CRITERIA VALUES'
1141: );
1142: END IF;
1143:
1144: QA_PARENT_CHILD_PKG.get_criteria_values
1145: (
1146: p_parent_plan_id => p_plan_id,
1147: p_parent_collection_id => p_collection_id,
1148: p_parent_occurrence => p_occurrence,

Line 1163: QA_PARENT_CHILD_PKG.evaluate_criteria

1159: );
1160: END IF;
1161:
1162: x_return_status :=
1163: QA_PARENT_CHILD_PKG.evaluate_criteria
1164: (
1165: p_plan_id => p_plan_id,
1166: p_criteria_values => x_criteria_values,
1167: p_relationship_type => p_relationship_type,

Line 1210: QA_PARENT_CHILD_PKG.insert_automatic_records

1206: x_child_plan_ids => l_child_plan_ids
1207: );
1208:
1209: IF( l_return_status = 'T' ) THEN
1210: QA_PARENT_CHILD_PKG.insert_automatic_records
1211: (
1212: p_plan_id => p_plan_id,
1213: p_collection_id => p_collection_id,
1214: p_occurrence => p_occurrence,

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

1415: END IF;
1416:
1417: -- Check if Results have been submitted for Immediate Child Plans
1418: -- Bug 5161719. SHKALYAN 13-Apr-2006
1419: -- Modified to call new overloaded QA_PARENT_CHILD_PKG.commit_allowed
1420: -- so that incomplete child plan ids are obtained
1421: l_return_status :=
1422: QA_PARENT_CHILD_PKG.commit_allowed
1423: (

Line 1422: QA_PARENT_CHILD_PKG.commit_allowed

1418: -- Bug 5161719. SHKALYAN 13-Apr-2006
1419: -- Modified to call new overloaded QA_PARENT_CHILD_PKG.commit_allowed
1420: -- so that incomplete child plan ids are obtained
1421: l_return_status :=
1422: QA_PARENT_CHILD_PKG.commit_allowed
1423: (
1424: p_plan_id => l_plans(i),
1425: p_collection_id => p_collection_id,
1426: p_occurrence => l_occurrences(i),