APPS.QA_WEB_TXN_API dependencies on QA_RESULTS

Line 522: IF (p_function_name = 'QA_RESULTS_ENTER' OR

518: -- Bug 3412523 ksoh Fri Jan 30 11:38:19 PST 2004
519: -- should return false for Update/Entry/Delete of a
520: -- plan that has history relationship with another parent plan(s)
521: -- regardless of the security profile.
522: IF (p_function_name = 'QA_RESULTS_ENTER' OR
523: p_function_name = 'QA_RESULTS_UPDATE' OR
524: p_function_name = 'QA_RESULTS_DELETE') THEN
525: OPEN c;
526: FETCH c INTO dummy;

Line 523: p_function_name = 'QA_RESULTS_UPDATE' OR

519: -- should return false for Update/Entry/Delete of a
520: -- plan that has history relationship with another parent plan(s)
521: -- regardless of the security profile.
522: IF (p_function_name = 'QA_RESULTS_ENTER' OR
523: p_function_name = 'QA_RESULTS_UPDATE' OR
524: p_function_name = 'QA_RESULTS_DELETE') THEN
525: OPEN c;
526: FETCH c INTO dummy;
527: IF c%FOUND THEN

Line 524: p_function_name = 'QA_RESULTS_DELETE') THEN

520: -- plan that has history relationship with another parent plan(s)
521: -- regardless of the security profile.
522: IF (p_function_name = 'QA_RESULTS_ENTER' OR
523: p_function_name = 'QA_RESULTS_UPDATE' OR
524: p_function_name = 'QA_RESULTS_DELETE') THEN
525: OPEN c;
526: FETCH c INTO dummy;
527: IF c%FOUND THEN
528: CLOSE c;

Line 724: select collection_id from QA_RESULTS

720: end if;
721: if (p_txn_number = 31) then --maintenance work order completion
722: select 'Y' into l_results_entered
723: from dual where exists (
724: select collection_id from QA_RESULTS
725: where organization_id = p_organization_id
726: and work_order_id =l_wip_entity_id
727: and maintenance_op_seq is null
728: and plan_id = l_plans_table(i)

Line 735: select collection_id from QA_RESULTS

731: );
732: elsif (p_txn_number = 33) then --maintenance op completion
733: select 'Y' into l_results_entered from dual
734: where exists (
735: select collection_id from QA_RESULTS
736: where organization_id = p_organization_id
737: and work_order_id =l_wip_entity_id
738: and maintenance_op_seq = pk5
739: and plan_id = l_plans_table(i)

Line 780: qa_results_pub.enable_and_fire_action (

776: BEGIN
777: -- This procedure shoots off the background actions after
778: -- parent transactions have committed.
779:
780: qa_results_pub.enable_and_fire_action (
781: p_api_version => 1.0,
782: p_commit => FND_API.G_TRUE,
783: p_collection_id => p_collection_id,
784: x_return_status => p_return_status,

Line 814: FROM qa_results qr

810: AND qpt.enabled_flag = 1
811: AND qpt.background_collection_flag = 1
812: AND NOT EXISTS
813: (SELECT 1
814: FROM qa_results qr
815: WHERE qr.plan_id = qpt.plan_id
816: AND qr.collection_id = col_id);
817:
818: BEGIN

Line 887: FROM QA_RESULTS

883: RETURN VARCHAR2 IS
884:
885: CURSOR c1(x_plan_id NUMBER, x_collection_id NUMBER, x_status NUMBER) IS
886: SELECT occurrence
887: FROM QA_RESULTS
888: WHERE plan_id = x_plan_id
889: AND collection_id = x_collection_id
890: AND status = x_status;
891: