DBA Data[Home] [Help]

APPS.QA_WEB_TXN_API dependencies on QA_TXN_GRP

Line 826: elements qa_txn_grp.ElementsArray;

822: p_context_values IN VARCHAR2,
823: p_collection_id IN NUMBER) IS
824:
825: l_plan_id NUMBER;
826: elements qa_txn_grp.ElementsArray;
827:
828: Cursor c1(txn_no number, org_id number, col_id number) is
829: SELECT DISTINCT qpt.plan_id
830: FROM qa_plan_transactions qpt, qa_plans qp

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

852: qa_ss_const.eam_work_order_txn) THEN
853: -- CAll the procedure to process the result
854: -- Collection for Background Plans for EAM Txn
855: -- ntungare Wed Feb 22 07:48:02 PST 2006
856: qa_txn_grp.eam_post_background_results(p_txn_number => p_txn_number,
857: p_org_id => p_org_id,
858: p_context_values => p_context_values,
859: p_collection_id => p_collection_id);
860: ELSE

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

857: p_org_id => p_org_id,
858: p_context_values => p_context_values,
859: p_collection_id => p_collection_id);
860: ELSE
861: elements := qa_txn_grp.result_to_array(p_context_values);
862: OPEN c1(p_txn_number, p_org_id, p_collection_id);
863: LOOP
864: FETCH c1 INTO l_plan_id;
865: EXIT WHEN c1%NOTFOUND;

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

862: OPEN c1(p_txn_number, p_org_id, p_collection_id);
863: LOOP
864: FETCH c1 INTO l_plan_id;
865: EXIT WHEN c1%NOTFOUND;
866: qa_txn_grp.insert_results(l_plan_id, p_org_id, p_collection_id, elements);
867: END LOOP;
868: CLOSE c1;
869: END IF;
870: END post_background_results;