eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_COMPLETIONS_PVT dependencies on QA_RESULTS

Line 563: l_result_sql_stmt := 'SELECT ' || l_result_column_name || ' FROM QA_RESULTS_V WHERE collection_id = :c_collection_id AND occurrence = ( SELECT MAX( occurrence ) FROM QA_RESULTS WHERE collection_id = :c_collection_id )';

559: l_enabled_flag = 1 AND
560: l_displayed_flag = 1 ) THEN
561:
562: -- Get the user-entered value for the status element
563: l_result_sql_stmt := 'SELECT ' || l_result_column_name || ' FROM QA_RESULTS_V WHERE collection_id = :c_collection_id AND occurrence = ( SELECT MAX( occurrence ) FROM QA_RESULTS WHERE collection_id = :c_collection_id )';
564:
565: BEGIN
566: EXECUTE IMMEDIATE l_result_sql_stmt INTO l_result_column_value USING p_collection_id, p_collection_id;
567: EXCEPTION

Line 699: l_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;

695:
696: l_return_status VARCHAR2(1);
697: l_msg_data VARCHAR2(2000);
698: l_msg_count NUMBER;
699: l_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
700: l_hidden_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
701: l_context_tbl AHL_QA_RESULTS_PVT.qa_context_tbl_type;
702: l_organization_id NUMBER := NULL;
703: l_collection_id NUMBER := NULL;

Line 700: l_hidden_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;

696: l_return_status VARCHAR2(1);
697: l_msg_data VARCHAR2(2000);
698: l_msg_count NUMBER;
699: l_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
700: l_hidden_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
701: l_context_tbl AHL_QA_RESULTS_PVT.qa_context_tbl_type;
702: l_organization_id NUMBER := NULL;
703: l_collection_id NUMBER := NULL;
704: l_result_count NUMBER := 1;

Line 701: l_context_tbl AHL_QA_RESULTS_PVT.qa_context_tbl_type;

697: l_msg_data VARCHAR2(2000);
698: l_msg_count NUMBER;
699: l_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
700: l_hidden_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
701: l_context_tbl AHL_QA_RESULTS_PVT.qa_context_tbl_type;
702: l_organization_id NUMBER := NULL;
703: l_collection_id NUMBER := NULL;
704: l_result_count NUMBER := 1;
705: l_occurrence_count NUMBER := 1;

Line 706: l_occurrence_tbl AHL_QA_RESULTS_PVT.occurrence_tbl_type;

702: l_organization_id NUMBER := NULL;
703: l_collection_id NUMBER := NULL;
704: l_result_count NUMBER := 1;
705: l_occurrence_count NUMBER := 1;
706: l_occurrence_tbl AHL_QA_RESULTS_PVT.occurrence_tbl_type;
707:
708: BEGIN
709:
710: FOR i IN p_counter_tbl.FIRST..p_counter_tbl.LAST LOOP

Line 746: AHL_QA_RESULTS_PVT.submit_qa_results

742:
743: -- Post the Results for the Counter Reading Plan in Oracle Quality
744: -- Note :- The p_commit flag is TRUE because, actions have to fired for
745: -- the Counter Reading Plan
746: AHL_QA_RESULTS_PVT.submit_qa_results
747: (
748: p_api_version => 1.0,
749: p_init_msg_list => FND_API.G_TRUE,
750: p_commit => FND_API.G_TRUE,

Line 1211: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_NO_QA_RESULTS' );

1207: */
1208:
1209: IF ( p_operation_rec.plan_id IS NOT NULL AND
1210: p_operation_rec.collection_id IS NULL ) THEN
1211: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_NO_QA_RESULTS' );
1212: FND_MSG_PUB.add;
1213: RETURN FND_API.G_RET_STS_ERROR;
1214: END IF;
1215:

Line 1469: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NO_QA_RESULTS' );

1465: -- bug no 3942950
1466:
1467: /*IF ( p_workorder_rec.plan_id IS NOT NULL AND
1468: p_workorder_rec.collection_id IS NULL ) THEN
1469: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NO_QA_RESULTS' );
1470: FND_MSG_PUB.add;
1471: RETURN FND_API.G_RET_STS_ERROR;
1472: END IF;
1473: */

Line 1550: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NO_QA_RESULTS' );

1546: -- this validation is not required for deferral
1547: -- bug no 3942950
1548: IF ( p_workorder_rec.plan_id IS NOT NULL AND
1549: p_workorder_rec.collection_id IS NULL ) THEN
1550: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NO_QA_RESULTS' );
1551: FND_MSG_PUB.add;
1552: RETURN FND_API.G_RET_STS_ERROR;
1553: END IF;
1554:

Line 5628: SELECT qa.plan_id from qa_results qa

5624: AND VT.unit_effectivity_id = UE.unit_effectivity_id
5625: AND UE.unit_effectivity_id = c_unit_effectivity_id;
5626:
5627: CURSOR get_qa_plan_id_csr1(p_collection_id IN NUMBER)IS
5628: SELECT qa.plan_id from qa_results qa
5629: where qa.collection_id = p_collection_id and rownum < 2;
5630:
5631: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
5632: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT

Line 7839: SELECT qa.plan_id from qa_results qa

7835: and awo1.visit_id = c_visit_id
7836: );
7837:
7838: CURSOR get_qa_plan_id_csr1(p_collection_id IN NUMBER)IS
7839: SELECT qa.plan_id from qa_results qa
7840: where qa.collection_id = p_collection_id and rownum < 2;
7841:
7842: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
7843: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT

Line 10934: SELECT qa.plan_id from qa_results qa

10930: WHERE WO.visit_task_id = p_visit_task_id
10931: AND master_workorder_flag = 'Y';
10932:
10933: CURSOR get_qa_plan_id_csr1(p_collection_id IN NUMBER)IS
10934: SELECT qa.plan_id from qa_results qa
10935: where qa.collection_id = p_collection_id and rownum < 2;
10936:
10937: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
10938: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT