APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_TRX_AR_INVOICES_B

Line 48: TYPE tai_id_tbl_type IS TABLE OF okl_trx_ar_invoices_b.id%TYPE

44: total_error_tbl error_tbl_type;
45:
46: --for bulk update
47: l_tai_id_cnt NUMBER := 0;
48: TYPE tai_id_tbl_type IS TABLE OF okl_trx_ar_invoices_b.id%TYPE
49: INDEX BY BINARY_INTEGER;
50: --TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
51: tai_id_tbl tai_id_tbl_type;
52:

Line 352: UPDATE okl_trx_ar_invoices_b

348: -- update the status
349: PRINT_TO_LOG('BULK tai_id_tbl.COUNT: '||tai_id_tbl.COUNT);
350: IF (tai_id_tbl.COUNT > 0) THEN
351: FORALL indx IN tai_id_tbl.FIRST..tai_id_tbl.LAST
352: UPDATE okl_trx_ar_invoices_b
353: SET trx_status_code = 'PROCESSED',
354: last_update_date = SYSDATE,
355: last_updated_by = Fnd_Global.USER_ID,
356: last_update_login = Fnd_Global.LOGIN_ID

Line 1971: UPDATE okl_trx_ar_invoices_b

1967:
1968: END LOOP;
1969: END IF;
1970:
1971: UPDATE okl_trx_ar_invoices_b
1972: SET trx_status_code = n_taiv_rec.trx_status_code
1973: WHERE id = n_taiv_rec.id;
1974:
1975: -- Performance Improvement

Line 3111: UPDATE okl_trx_ar_invoices_b

3107: WHERE id = d_xsiv_rec.id;
3108: END LOOP;
3109: END IF;
3110:
3111: UPDATE okl_trx_ar_invoices_b
3112: SET trx_status_code = n_taiv_rec.trx_status_code
3113: WHERE id = n_taiv_rec.id;
3114:
3115: -- Performance Improvement