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:

Line 454: l_contract_source OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

450: l_sequence_id NUMBER;
451: l_bus_doc_date_events_tbl BUSDOCDATES_TBL_TYPE;
452: l_error_found Boolean := FALSE;
453: l_warning_found Boolean := FALSE;
454: l_contract_source OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
455: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
456: l_clm_doc_flag varchar2(1) := 'N';
457:
458: CURSOR l_get_template_id IS

Line 455: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;

451: l_bus_doc_date_events_tbl BUSDOCDATES_TBL_TYPE;
452: l_error_found Boolean := FALSE;
453: l_warning_found Boolean := FALSE;
454: l_contract_source OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
455: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
456: l_clm_doc_flag varchar2(1) := 'N';
457:
458: CURSOR l_get_template_id IS
459: SELECT template_id

Line 460: FROM OKC_TEMPLATE_USAGES

456: l_clm_doc_flag varchar2(1) := 'N';
457:
458: CURSOR l_get_template_id IS
459: SELECT template_id
460: FROM OKC_TEMPLATE_USAGES
461: WHERE document_type = p_doc_type
462: AND document_id = p_doc_id;
463:
464: