APPS.OKL_ARINTF_PVT dependencies on RA_INTERFACE_DISTRIBUTIONS

Line 23: account_class RA_INTERFACE_DISTRIBUTIONS_ALL.account_class%TYPE,

19: --end: | 15-FEB-07 cklee R12 Billing enhancement project |
20:
21: -- rmunjulu R12 Fixes
22: TYPE dist_rec_type IS RECORD (
23: account_class RA_INTERFACE_DISTRIBUTIONS_ALL.account_class%TYPE,
24: dist_amount OKL_TRNS_ACC_DSTRS.amount%TYPE,
25: dist_percent OKL_TRNS_ACC_DSTRS.percentage%TYPE,
26: code_combination_id OKL_TRNS_ACC_DSTRS.code_combination_id%TYPE);
27:

Line 1898: type inv_dist_tbl_type is table of ra_interface_distributions_all%rowtype index by pls_integer;

1894:
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;

Line 2976: -- Build ra_interface_distributions_rec

2972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
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

Line 4421: INSERT INTO RA_INTERFACE_DISTRIBUTIONS_ALL

4417: END IF;
4418: IF inv_dist_tbl.count > 0 THEN
4419: FORALL indx in inv_dist_tbl.first..inv_dist_tbl.LAST
4420: SAVE EXCEPTIONS
4421: INSERT INTO RA_INTERFACE_DISTRIBUTIONS_ALL
4422: VALUES inv_dist_tbl(indx);
4423: END IF;
4424:
4425: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 4516: delete from RA_INTERFACE_DISTRIBUTIONS

4512:
4513: -- ---------------------------
4514: -- delete records from distributions
4515: -- ---------------------------
4516: delete from RA_INTERFACE_DISTRIBUTIONS
4517: --start: | 15-FEB-07 cklee R12 Billing enhancement project
4518: -- where interface_line_attribute10 = to_char(SUBSTR (error_tbl(indx).id,1, 20))
4519: -- and interface_line_attribute11 = to_char(SUBSTR(error_tbl(indx).id,21));
4520: where interface_line_attribute14 = to_char(error_tbl(indx).id);

Line 4574: DELETE FROM RA_INTERFACE_DISTRIBUTIONS

4570: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4571: AND TAI.ID = TIL.TAI_ID
4572: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));
4573:
4574: DELETE FROM RA_INTERFACE_DISTRIBUTIONS
4575: WHERE interface_line_attribute14 IN
4576: (SELECT TLD.ID
4577: FROM OKL_TXD_AR_LN_DTLS_B TLD
4578: , OKL_TXL_AR_INV_LNS_B TIL