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.

[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on QA_RESULTS

Line 589: 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 )';

585: l_enabled_flag = 1 AND
586: l_displayed_flag = 1 ) THEN
587:
588: -- Get the user-entered value for the status element
589: 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 )';
590:
591: BEGIN
592: EXECUTE IMMEDIATE l_result_sql_stmt INTO l_result_column_value USING p_collection_id, p_collection_id;
593: EXCEPTION

Line 725: l_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;

721:
722: l_return_status VARCHAR2(1);
723: l_msg_data VARCHAR2(2000);
724: l_msg_count NUMBER;
725: l_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
726: l_hidden_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
727: l_context_tbl AHL_QA_RESULTS_PVT.qa_context_tbl_type;
728: l_organization_id NUMBER := NULL;
729: l_collection_id NUMBER := NULL;

Line 726: l_hidden_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;

722: l_return_status VARCHAR2(1);
723: l_msg_data VARCHAR2(2000);
724: l_msg_count NUMBER;
725: l_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
726: l_hidden_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
727: l_context_tbl AHL_QA_RESULTS_PVT.qa_context_tbl_type;
728: l_organization_id NUMBER := NULL;
729: l_collection_id NUMBER := NULL;
730: l_result_count NUMBER := 1;

Line 727: l_context_tbl AHL_QA_RESULTS_PVT.qa_context_tbl_type;

723: l_msg_data VARCHAR2(2000);
724: l_msg_count NUMBER;
725: l_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
726: l_hidden_results_tbl AHL_QA_RESULTS_PVT.qa_results_tbl_type;
727: l_context_tbl AHL_QA_RESULTS_PVT.qa_context_tbl_type;
728: l_organization_id NUMBER := NULL;
729: l_collection_id NUMBER := NULL;
730: l_result_count NUMBER := 1;
731: l_occurrence_count NUMBER := 1;

Line 732: l_occurrence_tbl AHL_QA_RESULTS_PVT.occurrence_tbl_type;

728: l_organization_id NUMBER := NULL;
729: l_collection_id NUMBER := NULL;
730: l_result_count NUMBER := 1;
731: l_occurrence_count NUMBER := 1;
732: l_occurrence_tbl AHL_QA_RESULTS_PVT.occurrence_tbl_type;
733:
734: BEGIN
735:
736: FOR i IN p_counter_tbl.FIRST..p_counter_tbl.LAST LOOP

Line 772: AHL_QA_RESULTS_PVT.submit_qa_results

768:
769: -- Post the Results for the Counter Reading Plan in Oracle Quality
770: -- Note :- The p_commit flag is TRUE because, actions have to fired for
771: -- the Counter Reading Plan
772: AHL_QA_RESULTS_PVT.submit_qa_results
773: (
774: p_api_version => 1.0,
775: p_init_msg_list => FND_API.G_TRUE,
776: p_commit => FND_API.G_TRUE,

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

1251: p_operation_rec.collection_id IS NULL ) THEN
1252: OPEN is_qa_coll_reqd(p_operation_rec.plan_id);
1253: FETCH is_qa_coll_reqd INTO l_junk;
1254: IF(is_qa_coll_reqd%FOUND) THEN
1255: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_NO_QA_RESULTS' );
1256: FND_MSG_PUB.add;
1257: CLOSE is_qa_coll_reqd;
1258: RETURN FND_API.G_RET_STS_ERROR;
1259: END IF;

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

1526: -- bug no 3942950
1527:
1528: /*IF ( p_workorder_rec.plan_id IS NOT NULL AND
1529: p_workorder_rec.collection_id IS NULL ) THEN
1530: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NO_QA_RESULTS' );
1531: FND_MSG_PUB.add;
1532: RETURN FND_API.G_RET_STS_ERROR;
1533: END IF;
1534: */

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

1611: p_workorder_rec.collection_id IS NULL ) THEN
1612: OPEN is_qa_coll_reqd(p_workorder_rec.plan_id);
1613: FETCH is_qa_coll_reqd INTO l_junk;
1614: IF(is_qa_coll_reqd%FOUND) THEN
1615: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NO_QA_RESULTS' );
1616: FND_MSG_PUB.add;
1617: CLOSE is_qa_coll_reqd;
1618: RETURN FND_API.G_RET_STS_ERROR;
1619: END IF;

Line 5910: SELECT qa.plan_id from qa_results qa

5906: AND VT.unit_effectivity_id = UE.unit_effectivity_id
5907: AND UE.unit_effectivity_id = c_unit_effectivity_id;
5908:
5909: CURSOR get_qa_plan_id_csr1(p_collection_id IN NUMBER)IS
5910: SELECT qa.plan_id from qa_results qa
5911: where qa.collection_id = p_collection_id and rownum < 2;
5912:
5913: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
5914: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT

Line 6366: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Before GOTO counter_qa_results_label' );

6362: l_workorder_tbl(l_ctr).actual_end_date := l_mr_rec.actual_end_date;
6363:
6364:
6365: IF ( G_DEBUG = 'Y' ) THEN
6366: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Before GOTO counter_qa_results_label' );
6367: END IF;
6368:
6369: -- GOTO
6370: GOTO counter_qa_results_label;

Line 6370: GOTO counter_qa_results_label;

6366: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Before GOTO counter_qa_results_label' );
6367: END IF;
6368:
6369: -- GOTO
6370: GOTO counter_qa_results_label;
6371:
6372: END IF;
6373:
6374: IF ( G_DEBUG = 'Y' ) THEN

Line 7879: <>

7875: END IF;
7876:
7877:
7878: --JKJain, Bug 9250614, Define label
7879: <>
7880:
7881: IF ( G_DEBUG = 'Y' ) THEN
7882: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Recording Counter Readings, COUNT = '||l_workorder_tbl.COUNT|| ' and Plan_ID = '|| G_CTR_READING_PLAN_ID );
7883: END IF;

Line 8245: SELECT qa.plan_id from qa_results qa

8241: and awo1.visit_id = c_visit_id
8242: );
8243:
8244: CURSOR get_qa_plan_id_csr1(p_collection_id IN NUMBER)IS
8245: SELECT qa.plan_id from qa_results qa
8246: where qa.collection_id = p_collection_id and rownum < 2;
8247:
8248: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
8249: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT

Line 8753: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Before GOTO vmwo_counter_qa_results_label' );

8749: l_workorder_tbl(l_ctr).wip_entity_id := l_visit_rec.wip_entity_id;
8750: l_workorder_tbl(l_ctr).actual_end_date := l_visit_rec.actual_end_date;
8751:
8752: IF ( G_DEBUG = 'Y' ) THEN
8753: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Before GOTO vmwo_counter_qa_results_label' );
8754: END IF;
8755:
8756: -- GOTO
8757: GOTO vmwo_counter_qa_results_label;

Line 8757: GOTO vmwo_counter_qa_results_label;

8753: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Before GOTO vmwo_counter_qa_results_label' );
8754: END IF;
8755:
8756: -- GOTO
8757: GOTO vmwo_counter_qa_results_label;
8758:
8759: END IF;
8760:
8761: IF ( G_DEBUG = 'Y' ) THEN

Line 10058: <>

10054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10055: END IF;
10056:
10057: --JKJain, Bug 9250614, Define label
10058: <>
10059:
10060: IF ( G_DEBUG = 'Y' ) THEN
10061: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Recording Counter Readings, COUNT = '||l_workorder_tbl.COUNT|| ' and Plan_ID = '|| G_CTR_READING_PLAN_ID );
10062: END IF;

Line 11789: SELECT qa.plan_id from qa_results qa

11785: WHERE WO.visit_task_id = p_visit_task_id
11786: AND master_workorder_flag = 'Y';
11787:
11788: CURSOR get_qa_plan_id_csr1(p_collection_id IN NUMBER)IS
11789: SELECT qa.plan_id from qa_results qa
11790: where qa.collection_id = p_collection_id and rownum < 2;
11791:
11792: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
11793: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT