APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 52: FROM okl_trx_ap_invoices_b

48: AND chrb.sts_code in ('BOOKED', 'EVERGREEN', 'EXPIRED', 'TERMINATED', 'REVERSED', 'ABANDONED');
49:
50: Cursor funding_disb_txn_csr(p_contract_id NUMBER) IS
51: SELECT funding_type_code
52: FROM okl_trx_ap_invoices_b
53: WHERE khr_id = p_contract_id
54: -- AND ((funding_type_code = 'MANUAL_DISB') OR
55: -- Added for bug #5944260/5981076(Forward R12 cklee)
56: AND (trx_status_code in ('SUBMITTED', 'APPROVED', 'PROCESSED'));

Line 84: l_funding_type_code OKL_TRX_AP_INVOICES_B.funding_type_code%TYPE := NULL;

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;
88: l_billing_invoice_status VARCHAR2(1) := '?';

Line 250: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE) IS

246: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
251:
252: l_tapv_rec tapv_rec_type;
253: x_tapv_rec tapv_rec_type;
254: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_FUNDING_REQUEST';

Line 257: CURSOR c_tap (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)

253: x_tapv_rec tapv_rec_type;
254: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_FUNDING_REQUEST';
255:
256: -- Fix BPD Bug. these columns will be overridden by tapi
257: CURSOR c_tap (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
258: IS
259: SELECT h.VENDOR_INVOICE_NUMBER,
260: h.PAY_GROUP_LOOKUP_CODE,
261: h.NETTABLE_YN,

Line 264: FROM OKL_TRX_AP_INVOICES_B h

260: h.PAY_GROUP_LOOKUP_CODE,
261: h.NETTABLE_YN,
262: h.FUNDING_TYPE_CODE,
263: h.INVOICE_TYPE
264: FROM OKL_TRX_AP_INVOICES_B h
265: WHERE h.id = p_funding_id;
266:
267: r_tap c_tap%ROWTYPE;
268:

Line 371: l_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE; -- Added for bug 5944260/5981076(Forward R12 cklee)

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,
375: orig_system_id1

Line 381: FROM okl_trx_ap_invoices_b

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
381: FROM okl_trx_ap_invoices_b
382: WHERE khr_id = p_contract_id
383: AND trx_status_code not in ('CANCELED','SUBMITTED', 'APPROVED', 'PROCESSED');
384: -- Added for bug #5944260/5981076(Forward R12 cklee) -- End
385: Begin