APPS.OKC_CONTRACT_APPROVAL_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 372: from okc_k_headers_all_b H, okc_statuses_v S

368: H.CONTRACT_NUMBER_MODIFIER,
369: H.DATE_APPROVED,
370: S.MEANING,
371: S.STE_CODE
372: from okc_k_headers_all_b H, okc_statuses_v S
373: where H.ID = p_contract_id
374: and H.STS_CODE=S.CODE;
375: l_status varchar2(100);
376: l_status_type varchar2(100);

Line 861: UPDATE okc_k_headers_all_b

857: END IF;
858:
859: --Added to fix the bug#3269709
860: --issues lock if multiple users are accessing the same contract
861: UPDATE okc_k_headers_all_b
862: SET OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
863: WHERE ID=p_contract_id;
864: --
865: if (p_do_commit = OKC_API.G_TRUE) then

Line 932: from okc_k_headers_all_b

928: where ID = p_process_id and PDF_TYPE='WPS';
929: --
930: cursor wf_key_csr is
931: select CONTRACT_NUMBER||CONTRACT_NUMBER_MODIFIER wf_key
932: from okc_k_headers_all_b
933: where ID = p_contract_id;
934: --
935: cursor wf_exist_csr is
936: select '!'

Line 1719: from okc_k_headers_all_b

1715: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1716: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1717: cursor lock_csr(p number) is
1718: select object_version_number , org_id --mmadhavi added org_id for MOAC project
1719: from okc_k_headers_all_b
1720: where ID = p
1721: ;
1722: l_api_name CONSTANT VARCHAR2(30) := 'k_approved';
1723: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1843: from okc_k_headers_all_b

1839: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1840: dummy varchar2(1) := '?';
1841: cursor c1 is
1842: select '!'
1843: from okc_k_headers_all_b
1844: where ID = p_contract_id and date_approved is not null;
1845: --
1846: cursor lock_csr(p number) is
1847: select object_version_number

Line 1848: from okc_k_headers_all_b

1844: where ID = p_contract_id and date_approved is not null;
1845: --
1846: cursor lock_csr(p number) is
1847: select object_version_number
1848: from okc_k_headers_all_b
1849: where ID = p
1850: ;
1851: l_api_name CONSTANT VARCHAR2(30) := 'k_erase_approved';
1852: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1970: from okc_k_headers_all_b

1966: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1967: --Bug:3675868 fetch sts_code to set L1_header_rec.old_sts_code
1968: cursor lock_csr(p number) is
1969: select object_version_number, START_DATE, END_DATE, sts_code, scs_code
1970: from okc_k_headers_all_b
1971: where ID = p
1972: ;
1973: --
1974: l_new_status varchar2(30);

Line 2419: from okc_k_headers_all_b

2415: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
2416:
2417: cursor lock_csr is
2418: select object_version_number
2419: from okc_k_headers_all_b
2420: where ID = p_contract_id;
2421: --
2422: l_active_status varchar2(30) := 'ACTIVE';
2423: