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.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKC_K_HEADERS_V

Line 326: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

322: x_msg_count OUT NOCOPY NUMBER,
323: x_msg_data OUT NOCOPY VARCHAR2,
324: p_contract_id IN NUMBER) is
325:
326: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
327: SELECT contract_number
328: FROM okc_k_headers_v
329: WHERE id = p_chr_id;
330:

Line 328: FROM okc_k_headers_v

324: p_contract_id IN NUMBER) is
325:
326: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
327: SELECT contract_number
328: FROM okc_k_headers_v
329: WHERE id = p_chr_id;
330:
331: Cursor bankrupt_csr(p_contract_id NUMBER) IS
332: SELECT DECODE(disposition_code, 'NEGOTIATION', 'Y', 'GRANTED', 'Y', NULL, 'Y', 'N') bankruptcy_status

Line 378: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

374:
375: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
376: l_api_name CONSTANT varchar2(30) := 'VALIDATE_CANCEL_CONTRACTS';
377: l_api_version CONSTANT NUMBER := 1.0;
378: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
379: l_sts_code OKC_K_HEADERS_V.sts_code%TYPE := NULL;
380: l_funding_type_code OKL_TRX_AP_INVOICES_B.funding_type_code%TYPE := NULL;
381: l_txn_type FND_LOOKUPS.meaning%TYPE;
382: l_bankruptcy_status VARCHAR2(1);

Line 379: l_sts_code OKC_K_HEADERS_V.sts_code%TYPE := NULL;

375: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
376: l_api_name CONSTANT varchar2(30) := 'VALIDATE_CANCEL_CONTRACTS';
377: l_api_version CONSTANT NUMBER := 1.0;
378: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
379: l_sts_code OKC_K_HEADERS_V.sts_code%TYPE := NULL;
380: l_funding_type_code OKL_TRX_AP_INVOICES_B.funding_type_code%TYPE := NULL;
381: l_txn_type FND_LOOKUPS.meaning%TYPE;
382: l_bankruptcy_status VARCHAR2(1);
383: l_status_code OKC_K_HEADERS_B.sts_code%TYPE;

Line 663: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

659: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
660: l_api_name CONSTANT varchar2(30) := 'CONVERT_FA_AMOUNTS';
661: l_api_version CONSTANT NUMBER := 1.0;
662: l_seq_no NUMBER;
663: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
664: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
665: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
666: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
667: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)

Line 664: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;

660: l_api_name CONSTANT varchar2(30) := 'CONVERT_FA_AMOUNTS';
661: l_api_version CONSTANT NUMBER := 1.0;
662: l_seq_no NUMBER;
663: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
664: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
665: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
666: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
667: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)
668:

Line 665: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

661: l_api_version CONSTANT NUMBER := 1.0;
662: l_seq_no NUMBER;
663: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
664: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
665: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
666: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
667: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)
668:
669: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 666: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;

662: l_seq_no NUMBER;
663: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
664: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
665: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
666: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
667: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)
668:
669: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
670: SELECT contract_number, orig_system_source_code,

Line 669: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

665: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
666: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
667: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)
668:
669: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
670: SELECT contract_number, orig_system_source_code,
671: orig_system_id1
672: FROM okc_k_headers_v
673: WHERE id = p_chr_id;

Line 672: FROM okc_k_headers_v

668:
669: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
670: SELECT contract_number, orig_system_source_code,
671: orig_system_id1
672: FROM okc_k_headers_v
673: WHERE id = p_chr_id;
674: -- Added for bug #5944260/5981076(Forward R12 cklee) -- start
675: Cursor funding_cancel_csr(p_contract_id NUMBER) IS
676: SELECT id