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.OKC_TERMS_QA_GRP dependencies on OKC_TEMPLATE_USAGES

Line 75: l_contract_source OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

71: l_qa_result_tbl qa_result_tbl_type;
72: l_bus_doc_date_events_tbl BUSDOCDATES_TBL_TYPE;
73: l_error_found Boolean := FALSE;
74: l_warning_found Boolean := FALSE;
75: l_contract_source OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
76: l_now DATE;
77:
78: l_qa_code OKC_QA_ERRORS_T.QA_CODE%TYPE;
79: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 82: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;

78: l_qa_code OKC_QA_ERRORS_T.QA_CODE%TYPE;
79: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
80: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
81: l_perform_layout_tmpl_qa VARCHAR2(1);
82: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
83:
84: CURSOR l_get_qa_detail_csr IS
85: SELECT fnd.lookup_code qa_code,
86: fnd.meaning qa_name,

Line 97: FROM OKC_TEMPLATE_USAGES

93: AND Fnd.LOOKUP_TYPE=G_QA_LOOKUP;
94:
95: CURSOR l_get_template_id IS
96: SELECT template_id
97: FROM OKC_TEMPLATE_USAGES
98: WHERE document_type = p_doc_type
99: AND document_id = p_doc_id;
100:
101: BEGIN

Line 430: l_contract_source OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

426: l_sequence_id NUMBER;
427: l_bus_doc_date_events_tbl BUSDOCDATES_TBL_TYPE;
428: l_error_found Boolean := FALSE;
429: l_warning_found Boolean := FALSE;
430: l_contract_source OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
431: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
432:
433: CURSOR l_get_template_id IS
434: SELECT template_id

Line 431: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;

427: l_bus_doc_date_events_tbl BUSDOCDATES_TBL_TYPE;
428: l_error_found Boolean := FALSE;
429: l_warning_found Boolean := FALSE;
430: l_contract_source OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
431: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
432:
433: CURSOR l_get_template_id IS
434: SELECT template_id
435: FROM OKC_TEMPLATE_USAGES

Line 435: FROM OKC_TEMPLATE_USAGES

431: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
432:
433: CURSOR l_get_template_id IS
434: SELECT template_id
435: FROM OKC_TEMPLATE_USAGES
436: WHERE document_type = p_doc_type
437: AND document_id = p_doc_id;
438:
439: BEGIN