APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 671: UPDATE Okl_Trx_Ap_Invoices_B

667:
668: --l_return_status := x_return_status;
669: lu_tapv_rec.TRX_STATUS_CODE := 'ERROR';
670:
671: UPDATE Okl_Trx_Ap_Invoices_B
672: SET TRX_STATUS_CODE = 'ERROR'
673: WHERE id = lx_tapv_rec.id;
674:
675: IF ( x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 842: l_try_id okl_trx_ap_invoices_b.try_id%TYPE;

838:
839:
840: --Local Variables
841: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
842: l_try_id okl_trx_ap_invoices_b.try_id%TYPE;
843: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
844: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
845:
846: TYPE tap_id_tbl_type IS TABLE OF okl_trx_ap_invoices_b.id%type

Line 846: TYPE tap_id_tbl_type IS TABLE OF okl_trx_ap_invoices_b.id%type

842: l_try_id okl_trx_ap_invoices_b.try_id%TYPE;
843: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
844: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
845:
846: TYPE tap_id_tbl_type IS TABLE OF okl_trx_ap_invoices_b.id%type
847: INDEX BY BINARY_INTEGER;
848:
849: l_tap_id_tbl tap_id_tbl_type;
850: id_ind NUMBER;

Line 1127: update okl_trx_ap_invoices_b

1123:
1124: IF (l_overall_status <> OKL_API.G_RET_STS_SUCCESS AND l_tap_id_tbl.count > 0 ) THEN
1125: print_line (' -- Updating pay invoices TRX_STATUS_CODE with ERROR status since l_overall_status = ' || l_overall_status);
1126: FOR id_ind IN l_tap_id_tbl.first..l_tap_id_tbl.last LOOP
1127: update okl_trx_ap_invoices_b
1128: set TRX_STATUS_CODE = 'ERROR'
1129: ,object_version_number = object_version_number + 1
1130: ,last_updated_by = FND_GLOBAL.USER_ID
1131: ,last_update_date = sysdate

Line 2599: -- instead of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements

2595: l_dummy NUMBER;
2596: l_principal_tot NUMBER := 0;
2597:
2598: -- sjalasut, modified the cursor to have khr_id referred to okl_txl_ap_inv_lns_all_b
2599: -- instead of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements
2600: -- project.
2601: cursor c_disb_tot(p_creditline_id number) is
2602: SELECT NVL(SUM(NVL(TAP.AMOUNT,0)),0)
2603: FROM OKL_TRX_AP_INVOICES_B TAP

Line 2603: FROM OKL_TRX_AP_INVOICES_B TAP

2599: -- instead of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements
2600: -- project.
2601: cursor c_disb_tot(p_creditline_id number) is
2602: SELECT NVL(SUM(NVL(TAP.AMOUNT,0)),0)
2603: FROM OKL_TRX_AP_INVOICES_B TAP
2604: ,OKL_TXL_AP_INV_LNS_ALL_B TPL
2605: WHERE TAP.ID = TPL.TAP_ID
2606: AND TAP.TRX_STATUS_CODE = 'PROCESSED' -- push to AP
2607: AND TRUNC(DATE_INVOICED) <= TRUNC(p_trx_date)