APPS.QA_WEB_TXN_API dependencies on QA_RESULTS

Line 532: IF (p_function_name = 'QA_RESULTS_ENTER' OR

528: -- Bug 3412523 ksoh Fri Jan 30 11:38:19 PST 2004
529: -- should return false for Update/Entry/Delete of a
530: -- plan that has history relationship with another parent plan(s)
531: -- regardless of the security profile.
532: IF (p_function_name = 'QA_RESULTS_ENTER' OR
533: p_function_name = 'QA_RESULTS_UPDATE' OR
534: p_function_name = 'QA_RESULTS_DELETE') THEN
535: OPEN c;
536: FETCH c INTO dummy;

Line 533: p_function_name = 'QA_RESULTS_UPDATE' OR

529: -- should return false for Update/Entry/Delete of a
530: -- plan that has history relationship with another parent plan(s)
531: -- regardless of the security profile.
532: IF (p_function_name = 'QA_RESULTS_ENTER' OR
533: p_function_name = 'QA_RESULTS_UPDATE' OR
534: p_function_name = 'QA_RESULTS_DELETE') THEN
535: OPEN c;
536: FETCH c INTO dummy;
537: IF c%FOUND THEN

Line 534: p_function_name = 'QA_RESULTS_DELETE') THEN

530: -- plan that has history relationship with another parent plan(s)
531: -- regardless of the security profile.
532: IF (p_function_name = 'QA_RESULTS_ENTER' OR
533: p_function_name = 'QA_RESULTS_UPDATE' OR
534: p_function_name = 'QA_RESULTS_DELETE') THEN
535: OPEN c;
536: FETCH c INTO dummy;
537: IF c%FOUND THEN
538: CLOSE c;

Line 750: select collection_id from QA_RESULTS

746: --
747: if (p_txn_number = 31) then --maintenance work order completion
748: select 'Y' into l_results_entered
749: from dual where exists (
750: select collection_id from QA_RESULTS
751: where organization_id = p_organization_id
752: and work_order_id =l_wip_entity_id
753: and (maintenance_op_seq is null or transaction_number = 31)
754: and plan_id = l_plans_table(i)

Line 761: select collection_id from QA_RESULTS

757: );
758: elsif (p_txn_number = 33) then --maintenance op completion
759: select 'Y' into l_results_entered from dual
760: where exists (
761: select collection_id from QA_RESULTS
762: where organization_id = p_organization_id
763: and work_order_id =l_wip_entity_id
764: and maintenance_op_seq = pk5
765: and transaction_number = 33

Line 807: qa_results_pub.enable_and_fire_action (

803: BEGIN
804: -- This procedure shoots off the background actions after
805: -- parent transactions have committed.
806:
807: qa_results_pub.enable_and_fire_action (
808: p_api_version => 1.0,
809: p_commit => FND_API.G_TRUE,
810: p_collection_id => p_collection_id,
811: x_return_status => p_return_status,

Line 841: FROM qa_results qr

837: AND qpt.enabled_flag = 1
838: AND qpt.background_collection_flag = 1
839: AND NOT EXISTS
840: (SELECT 1
841: FROM qa_results qr
842: WHERE qr.plan_id = qpt.plan_id
843: AND qr.collection_id = col_id);
844:
845: BEGIN

Line 914: FROM QA_RESULTS

910: RETURN VARCHAR2 IS
911:
912: CURSOR c1(x_plan_id NUMBER, x_collection_id NUMBER, x_status NUMBER) IS
913: SELECT occurrence
914: FROM QA_RESULTS
915: WHERE plan_id = x_plan_id
916: AND collection_id = x_collection_id
917: AND status = x_status;
918: