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 1047: type inv_dist_tbl_type is table of ra_interface_distributions_all%rowtype index by pls_integer;

1043:
1044: l_xfer_tbl xfer_tbl_type;
1045:
1046: type inv_lines_tbl_type is table of ra_interface_lines_all%rowtype index by binary_integer;
1047: type inv_dist_tbl_type is table of ra_interface_distributions_all%rowtype index by pls_integer;
1048: type sales_credits_tbl_type is table of ra_interface_salescredits_all%rowtype index by pls_integer;
1049: type ar_contingency_tbl_type is table of ar_interface_conts_all%rowtype index by pls_integer;
1050:
1051: inv_lines_tbl inv_lines_tbl_type;

Line 1865: -- Build ra_interface_distributions_rec

1861: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1862: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','finished deleting pl/sql tables');
1863: END IF;
1864: -- Build ra_interface_lines_rec
1865: -- Build ra_interface_distributions_rec
1866: -- Build ra_interface_salescredits_all
1867: -- Build ar_interface_conts_all
1868:
1869: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3133: INSERT INTO RA_INTERFACE_DISTRIBUTIONS_ALL

3129: END IF;
3130: IF inv_dist_tbl.count > 0 THEN
3131: FORALL indx in inv_dist_tbl.first..inv_dist_tbl.LAST
3132: SAVE EXCEPTIONS
3133: INSERT INTO RA_INTERFACE_DISTRIBUTIONS_ALL
3134: VALUES inv_dist_tbl(indx);
3135: END IF;
3136:
3137: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 3228: delete from RA_INTERFACE_DISTRIBUTIONS

3224:
3225: -- ---------------------------
3226: -- delete records from distributions
3227: -- ---------------------------
3228: delete from RA_INTERFACE_DISTRIBUTIONS
3229: --start: | 15-FEB-07 cklee R12 Billing enhancement project
3230: -- where interface_line_attribute10 = to_char(SUBSTR (error_tbl(indx).id,1, 20))
3231: -- and interface_line_attribute11 = to_char(SUBSTR(error_tbl(indx).id,21));
3232: where interface_line_attribute14 = to_char(error_tbl(indx).id);