APPS.OKE_CONTRACT_APPROVAL_PVT dependencies on OKC_K_HEADERS_B

Line 89: from OKC_K_HEADERS_B H, okc_statuses_v S

85: H.CONTRACT_NUMBER_MODIFIER,
86: H.DATE_APPROVED,
87: S.MEANING,
88: S.STE_CODE
89: from OKC_K_HEADERS_B H, okc_statuses_v S
90: where H.ID = p_contract_id
91: and H.STS_CODE=S.CODE;
92: l_status varchar2(100);
93: l_status_type varchar2(100);

Line 588: from OKC_K_HEADERS_B

584: where ID = p_process_id and PDF_TYPE='WPS';
585: --
586: cursor wf_key_csr is
587: select CONTRACT_NUMBER||CONTRACT_NUMBER_MODIFIER wf_key
588: from OKC_K_HEADERS_B
589: where ID = p_contract_id;
590: --
591: cursor wf_exist_csr is
592: select '!'

Line 1241: from okc_k_headers_b

1237: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1238: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1239: cursor lock_csr(p number) is
1240: select object_version_number
1241: from okc_k_headers_b
1242: where ID = p
1243: ;
1244: l_api_name CONSTANT VARCHAR2(30) := 'k_approved';
1245: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1348: from OKC_K_HEADERS_B

1344: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1345: dummy varchar2(1) := '?';
1346: cursor c1 is
1347: select '!'
1348: from OKC_K_HEADERS_B
1349: where ID = p_contract_id and date_approved is not null;
1350: --
1351: cursor lock_csr(p number) is
1352: select object_version_number

Line 1353: from OKC_K_HEADERS_B

1349: where ID = p_contract_id and date_approved is not null;
1350: --
1351: cursor lock_csr(p number) is
1352: select object_version_number
1353: from OKC_K_HEADERS_B
1354: where ID = p
1355: ;
1356: l_api_name CONSTANT VARCHAR2(30) := 'k_erase_approved';
1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1473: from okc_k_headers_b

1469: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1470: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1471: cursor lock_csr(p number) is
1472: select object_version_number, START_DATE, END_DATE
1473: from okc_k_headers_b
1474: where ID = p
1475: ;
1476: --
1477: l_new_status varchar2(30);