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_QA_RESULTS_PVT dependencies on QA_RESULTS

Line 1: PACKAGE BODY AHL_QA_RESULTS_PVT AS

1: PACKAGE BODY AHL_QA_RESULTS_PVT AS
2: /* $Header: AHLVQARB.pls 120.5 2008/01/28 20:36:02 sikumar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_QA_RESULTS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_QA_RESULTS_PVT';

1: PACKAGE BODY AHL_QA_RESULTS_PVT AS
2: /* $Header: AHLVQARB.pls 120.5 2008/01/28 20:36:02 sikumar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_QA_RESULTS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: -- Added by Arvind for 11.5.10
8: G_MR_TXN_NO NUMBER := TO_NUMBER( FND_PROFILE.value( 'AHL_MR_QA_TXN_NO' ) );

Line 50: p_results_tbl IN qa_results_tbl_type,

46: p_plan_id IN NUMBER,
47: p_organization_id IN NUMBER,
48: p_transaction_no IN NUMBER,
49: p_specification_id IN NUMBER,
50: p_results_tbl IN qa_results_tbl_type,
51: p_hidden_results_tbl IN qa_results_tbl_type,
52: p_context_tbl IN qa_context_tbl_type,
53: p_result_commit_flag IN NUMBER,
54: p_collection_id IN NUMBER

Line 51: p_hidden_results_tbl IN qa_results_tbl_type,

47: p_organization_id IN NUMBER,
48: p_transaction_no IN NUMBER,
49: p_specification_id IN NUMBER,
50: p_results_tbl IN qa_results_tbl_type,
51: p_hidden_results_tbl IN qa_results_tbl_type,
52: p_context_tbl IN qa_context_tbl_type,
53: p_result_commit_flag IN NUMBER,
54: p_collection_id IN NUMBER
55: ) RETURN VARCHAR2

Line 78: FROM QA_RESULTS

74:
75: CURSOR get_plan_from_results( c_collection_id NUMBER )
76: IS
77: SELECT plan_id
78: FROM QA_RESULTS
79: WHERE collection_id = c_collection_id;
80:
81: CURSOR get_chars_for_plan( c_plan_id NUMBER )
82: IS

Line 293: p_results_tbl IN qa_results_tbl_type,

289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_plan_id IN NUMBER,
292: p_transaction_no IN NUMBER,
293: p_results_tbl IN qa_results_tbl_type,
294: p_context_tbl IN qa_context_tbl_type,
295: p_collection_id IN NUMBER
296: ) RETURN VARCHAR2
297: IS

Line 406: p_hidden_results_tbl IN qa_results_tbl_type,

402: END fire_ahl_actions;
403:
404: FUNCTION form_hidden_qa_result_string
405: (
406: p_hidden_results_tbl IN qa_results_tbl_type,
407: p_results_tbl IN qa_results_tbl_type,
408: p_search_end_index IN NUMBER,
409: p_id_or_value IN VARCHAR2,
410: x_result_string OUT NOCOPY VARCHAR2

Line 407: p_results_tbl IN qa_results_tbl_type,

403:
404: FUNCTION form_hidden_qa_result_string
405: (
406: p_hidden_results_tbl IN qa_results_tbl_type,
407: p_results_tbl IN qa_results_tbl_type,
408: p_search_end_index IN NUMBER,
409: p_id_or_value IN VARCHAR2,
410: x_result_string OUT NOCOPY VARCHAR2
411: ) RETURN VARCHAR2

Line 450: p_results_tbl IN qa_results_tbl_type,

446: END form_hidden_qa_result_string;
447:
448: FUNCTION form_qa_result_string
449: (
450: p_results_tbl IN qa_results_tbl_type,
451: p_start_index IN NUMBER,
452: p_end_index IN NUMBER,
453: p_id_or_value IN VARCHAR2,
454: x_result_string OUT NOCOPY VARCHAR2

Line 476: PROCEDURE submit_qa_results

472:
473: RETURN FND_API.G_RET_STS_SUCCESS;
474: END form_qa_result_string;
475:
476: PROCEDURE submit_qa_results
477: (
478: p_api_version IN NUMBER := 1.0,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
480: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 491: p_results_tbl IN qa_results_tbl_type,

487: p_plan_id IN NUMBER,
488: p_organization_id IN NUMBER,
489: p_transaction_no IN NUMBER,
490: p_specification_id IN NUMBER := NULL,
491: p_results_tbl IN qa_results_tbl_type,
492: p_hidden_results_tbl IN qa_results_tbl_type,
493: p_context_tbl IN qa_context_tbl_type,
494: p_result_commit_flag IN NUMBER,
495: p_id_or_value IN VARCHAR2 := 'VALUE',

Line 492: p_hidden_results_tbl IN qa_results_tbl_type,

488: p_organization_id IN NUMBER,
489: p_transaction_no IN NUMBER,
490: p_specification_id IN NUMBER := NULL,
491: p_results_tbl IN qa_results_tbl_type,
492: p_hidden_results_tbl IN qa_results_tbl_type,
493: p_context_tbl IN qa_context_tbl_type,
494: p_result_commit_flag IN NUMBER,
495: p_id_or_value IN VARCHAR2 := 'VALUE',
496: p_x_collection_id IN OUT NOCOPY NUMBER,

Line 500: l_api_name VARCHAR2(30) := 'submit_qa_results';

496: p_x_collection_id IN OUT NOCOPY NUMBER,
497: p_x_occurrence_tbl IN OUT NOCOPY occurrence_tbl_type
498: )
499: IS
500: l_api_name VARCHAR2(30) := 'submit_qa_results';
501: l_msg_data VARCHAR2(2000);
502: l_return_status VARCHAR2(1);
503: l_msg_count NUMBER;
504: l_occurrence NUMBER := NULL;

Line 522: SAVEPOINT submit_qa_results_PVT;

518: -- Initialize API return status to success
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
521: -- Standard Start of API savepoint
522: SAVEPOINT submit_qa_results_PVT;
523:
524: -- Initialize message list if p_init_msg_list is set to TRUE.
525: IF FND_API.to_boolean( p_init_msg_list ) THEN
526: FND_MSG_PUB.initialize;

Line 703: SAVEPOINT submit_qa_results_PVT;

699: l_result_string := NULL;
700:
701: IF ( l_committed = 1 ) THEN
702: -- Reset Save Point because a Commit Occurs
703: SAVEPOINT submit_qa_results_PVT;
704: END IF;
705:
706: END LOOP;
707:

Line 790: ROLLBACK TO submit_qa_results_PVT;

786:
787: EXCEPTION
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO submit_qa_results_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: FND_MSG_PUB.count_and_get
793: (
794: p_encoded => FND_API.G_FALSE,

Line 804: ROLLBACK TO submit_qa_results_PVT;

800: AHL_DEBUG_PUB.disable_debug;
801: END IF;
802:
803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
804: ROLLBACK TO submit_qa_results_PVT;
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
806: FND_MSG_PUB.count_and_get
807: (
808: p_encoded => FND_API.G_FALSE,

Line 818: ROLLBACK TO submit_qa_results_PVT;

814: AHL_DEBUG_PUB.disable_debug;
815: END IF;
816:
817: WHEN OTHERS THEN
818: ROLLBACK TO submit_qa_results_PVT;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
820: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
821: THEN
822: FND_MSG_PUB.add_exc_msg

Line 840: END submit_qa_results;

836: IF ( G_DEBUG = 'Y' ) THEN
837: AHL_DEBUG_PUB.disable_debug;
838: END IF;
839:
840: END submit_qa_results;
841:
842: PROCEDURE get_char_lov_sql
843: (
844: p_api_version IN NUMBER := 1.0,

Line 1086: END AHL_QA_RESULTS_PVT;

1082: AHL_DEBUG_PUB.disable_debug;
1083: END IF;
1084: END get_qa_plan;
1085:
1086: END AHL_QA_RESULTS_PVT;