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 30: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
28: p_contract_id IN NUMBER) is
29:
30: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
31: SELECT contract_number
32: FROM okc_k_headers_v
33: WHERE id = p_chr_id;
34:

Line 32: FROM okc_k_headers_v

28: p_contract_id IN NUMBER) is
29:
30: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
31: SELECT contract_number
32: FROM okc_k_headers_v
33: WHERE id = p_chr_id;
34:
35: Cursor bankrupt_csr(p_contract_id NUMBER) IS
36: SELECT DECODE(disposition_code, 'NEGOTIATION', 'Y', 'GRANTED', 'Y', NULL, 'Y', 'N') bankruptcy_status

Line 82: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

78:
79: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
80: l_api_name CONSTANT varchar2(30) := 'VALIDATE_CANCEL_CONTRACTS';
81: l_api_version CONSTANT NUMBER := 1.0;
82: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
83: l_sts_code OKC_K_HEADERS_V.sts_code%TYPE := NULL;
84: l_funding_type_code OKL_TRX_AP_INVOICES_B.funding_type_code%TYPE := NULL;
85: l_txn_type FND_LOOKUPS.meaning%TYPE;
86: l_bankruptcy_status VARCHAR2(1);

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

79: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
80: l_api_name CONSTANT varchar2(30) := 'VALIDATE_CANCEL_CONTRACTS';
81: l_api_version CONSTANT NUMBER := 1.0;
82: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
83: l_sts_code OKC_K_HEADERS_V.sts_code%TYPE := NULL;
84: l_funding_type_code OKL_TRX_AP_INVOICES_B.funding_type_code%TYPE := NULL;
85: l_txn_type FND_LOOKUPS.meaning%TYPE;
86: l_bankruptcy_status VARCHAR2(1);
87: l_status_code OKC_K_HEADERS_B.sts_code%TYPE;

Line 367: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

363: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
364: l_api_name CONSTANT varchar2(30) := 'CONVERT_FA_AMOUNTS';
365: l_api_version CONSTANT NUMBER := 1.0;
366: l_seq_no NUMBER;
367: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
368: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
369: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
370: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
371: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)

Line 368: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;

364: l_api_name CONSTANT varchar2(30) := 'CONVERT_FA_AMOUNTS';
365: l_api_version CONSTANT NUMBER := 1.0;
366: l_seq_no NUMBER;
367: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
368: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
369: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
370: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
371: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)
372:

Line 369: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

365: l_api_version CONSTANT NUMBER := 1.0;
366: l_seq_no NUMBER;
367: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
368: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
369: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
370: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
371: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)
372:
373: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 370: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;

366: l_seq_no NUMBER;
367: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
368: l_orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
369: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
370: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
371: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)
372:
373: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
374: SELECT contract_number, orig_system_source_code,

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

369: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
370: l_orig_system_id1 OKC_K_HEADERS_V.ORIG_SYSTEM_ID1%TYPE;
371: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)
372:
373: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
374: SELECT contract_number, orig_system_source_code,
375: orig_system_id1
376: FROM okc_k_headers_v
377: WHERE id = p_chr_id;

Line 376: FROM okc_k_headers_v

372:
373: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
374: SELECT contract_number, orig_system_source_code,
375: orig_system_id1
376: FROM okc_k_headers_v
377: WHERE id = p_chr_id;
378: -- Added for bug #5944260/5981076(Forward R12 cklee) -- start
379: Cursor funding_cancel_csr(p_contract_id NUMBER) IS
380: SELECT id