81: l_authoring_org_id NUMBER; --CDUBEY l_authoring_org_id added for MOAC
82:
83: -- Fix Bug 3159867
84:
85: CURSOR khr_num IS SELECT contract_number , authoring_org_id FROM okc_k_headers_b
86: WHERE id = (SELECT khr_id FROM okl_k_headers_full_v
87: WHERE id = p_contract_id);
88: l_khr_number okc_k_headers_b.contract_number%TYPE;
89:
84:
85: CURSOR khr_num IS SELECT contract_number , authoring_org_id FROM okc_k_headers_b
86: WHERE id = (SELECT khr_id FROM okl_k_headers_full_v
87: WHERE id = p_contract_id);
88: l_khr_number okc_k_headers_b.contract_number%TYPE;
89:
90: BEGIN
91: -- CHECK_FOR_NULL_CONTRACT_ID;
92: -- If status type is not 'PASSED', do not proceed