DBA Data[Home] [Help]

APPS.QA_WEB_TXN_API dependencies on QA_TXN_GRP

Line 799: elements qa_txn_grp.ElementsArray;

795: p_context_values IN VARCHAR2,
796: p_collection_id IN NUMBER) IS
797:
798: l_plan_id NUMBER;
799: elements qa_txn_grp.ElementsArray;
800:
801: Cursor c1(txn_no number, org_id number, col_id number) is
802: SELECT DISTINCT qpt.plan_id
803: FROM qa_plan_transactions qpt, qa_plans qp

Line 829: qa_txn_grp.eam_post_background_results(p_txn_number => p_txn_number,

825: qa_ss_const.eam_work_order_txn) THEN
826: -- CAll the procedure to process the result
827: -- Collection for Background Plans for EAM Txn
828: -- ntungare Wed Feb 22 07:48:02 PST 2006
829: qa_txn_grp.eam_post_background_results(p_txn_number => p_txn_number,
830: p_org_id => p_org_id,
831: p_context_values => p_context_values,
832: p_collection_id => p_collection_id);
833: ELSE

Line 834: elements := qa_txn_grp.result_to_array(p_context_values);

830: p_org_id => p_org_id,
831: p_context_values => p_context_values,
832: p_collection_id => p_collection_id);
833: ELSE
834: elements := qa_txn_grp.result_to_array(p_context_values);
835: OPEN c1(p_txn_number, p_org_id, p_collection_id);
836: LOOP
837: FETCH c1 INTO l_plan_id;
838: EXIT WHEN c1%NOTFOUND;

Line 839: qa_txn_grp.insert_results(l_plan_id, p_org_id, p_collection_id, elements);

835: OPEN c1(p_txn_number, p_org_id, p_collection_id);
836: LOOP
837: FETCH c1 INTO l_plan_id;
838: EXIT WHEN c1%NOTFOUND;
839: qa_txn_grp.insert_results(l_plan_id, p_org_id, p_collection_id, elements);
840: END LOOP;
841: CLOSE c1;
842: END IF;
843: END post_background_results;