APPS.OKL_ARINTF_PVT dependencies on RA_INTERFACE_SALESCREDITS

Line 1899: type sales_credits_tbl_type is table of ra_interface_salescredits_all%rowtype index by pls_integer;

1895: l_xfer_tbl xfer_tbl_type;
1896:
1897: type inv_lines_tbl_type is table of ra_interface_lines_all%rowtype index by binary_integer;
1898: type inv_dist_tbl_type is table of ra_interface_distributions_all%rowtype index by pls_integer;
1899: type sales_credits_tbl_type is table of ra_interface_salescredits_all%rowtype index by pls_integer;
1900: type ar_contingency_tbl_type is table of ar_interface_conts_all%rowtype index by pls_integer;
1901:
1902: inv_lines_tbl inv_lines_tbl_type;
1903: inv_dist_tbl inv_dist_tbl_type;

Line 2977: -- Build ra_interface_salescredits_all

2973: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','finished deleting pl/sql tables');
2974: END IF;
2975: -- Build ra_interface_lines_rec
2976: -- Build ra_interface_distributions_rec
2977: -- Build ra_interface_salescredits_all
2978: -- Build ar_interface_conts_all
2979:
2980: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2981: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Building AR records');

Line 4337: INSERT INTO RA_INTERFACE_SALESCREDITS_ALL

4333: END IF;
4334: IF sales_credits_tbl.COUNT > 0 THEN
4335: FORALL indx in sales_credits_tbl.first..sales_credits_tbl.LAST
4336: SAVE EXCEPTIONS
4337: INSERT INTO RA_INTERFACE_SALESCREDITS_ALL
4338: VALUES sales_credits_tbl(indx);
4339: END IF;
4340:
4341: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 4496: delete from RA_INTERFACE_SALESCREDITS

4492:
4493: -- --------------------------------------------
4494: -- delete records from sales credits interface
4495: -- --------------------------------------------
4496: delete from RA_INTERFACE_SALESCREDITS
4497: --start: | 15-FEB-07 cklee R12 Billing enhancement project
4498: -- where interface_line_attribute10 = to_char(SUBSTR (error_tbl(indx).id,1, 20))
4499: -- and interface_line_attribute11 = to_char(SUBSTR(error_tbl(indx).id,21));
4500: where interface_line_attribute14 = to_char(error_tbl(indx).id);

Line 4554: DELETE FROM RA_INTERFACE_SALESCREDITS

4550: IF l_error_tai_tbl.count > 0 THEN
4551: -- Delete AR Interface tables
4552: FOR err_tai_cnt IN l_error_tai_tbl.first .. l_error_tai_tbl.last
4553: LOOP
4554: DELETE FROM RA_INTERFACE_SALESCREDITS
4555: WHERE interface_line_attribute14 IN
4556: (SELECT TLD.ID
4557: FROM OKL_TXD_AR_LN_DTLS_B TLD
4558: , OKL_TXL_AR_INV_LNS_B TIL