APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 348: FROM okl_trx_ap_invoices_b

344: AND chrb.sts_code in ('BOOKED', 'EVERGREEN', 'EXPIRED', 'TERMINATED', 'REVERSED', 'ABANDONED');
345:
346: Cursor funding_disb_txn_csr(p_contract_id NUMBER) IS
347: SELECT funding_type_code
348: FROM okl_trx_ap_invoices_b
349: WHERE khr_id = p_contract_id
350: -- AND ((funding_type_code = 'MANUAL_DISB') OR
351: -- Added for bug #5944260/5981076(Forward R12 cklee)
352: AND (trx_status_code in ('SUBMITTED', 'APPROVED', 'PROCESSED'));

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

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

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

542: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
543: x_return_status OUT NOCOPY VARCHAR2,
544: x_msg_count OUT NOCOPY NUMBER,
545: x_msg_data OUT NOCOPY VARCHAR2,
546: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
547:
548: l_tapv_rec tapv_rec_type;
549: x_tapv_rec tapv_rec_type;
550: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_FUNDING_REQUEST';

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

549: x_tapv_rec tapv_rec_type;
550: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_FUNDING_REQUEST';
551:
552: -- Fix BPD Bug. these columns will be overridden by tapi
553: CURSOR c_tap (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE)
554: IS
555: SELECT h.VENDOR_INVOICE_NUMBER,
556: h.PAY_GROUP_LOOKUP_CODE,
557: h.NETTABLE_YN,

Line 560: FROM OKL_TRX_AP_INVOICES_B h

556: h.PAY_GROUP_LOOKUP_CODE,
557: h.NETTABLE_YN,
558: h.FUNDING_TYPE_CODE,
559: h.INVOICE_TYPE
560: FROM OKL_TRX_AP_INVOICES_B h
561: WHERE h.id = p_funding_id;
562:
563: r_tap c_tap%ROWTYPE;
564:

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

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

Line 677: FROM okl_trx_ap_invoices_b

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