APPS.OKL_ARINTF_PVT dependencies on AR_INTERFACE_CONTS

Line 1900: type ar_contingency_tbl_type is table of ar_interface_conts_all%rowtype index by pls_integer;

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;
1904: sales_credits_tbl sales_credits_tbl_type;

Line 2978: -- Build ar_interface_conts_all

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');
2982: END IF;

Line 3916: SELECT AR_INTERFACE_CONTS_S.NEXTVAL

3912: --begin bug 5474184
3913: cont_cnt := ( ar_contingency_tbl.count + 1 );
3914:
3915: BEGIN
3916: SELECT AR_INTERFACE_CONTS_S.NEXTVAL
3917: INTO ar_contingency_tbl(cont_cnt).INTERFACE_CONTINGENCY_ID
3918: FROM DUAL;
3919: EXCEPTION
3920: WHEN OTHERS THEN

Line 4379: INSERT INTO AR_INTERFACE_CONTS_ALL

4375: IF ar_contingency_tbl.COUNT > 0 THEN
4376:
4377: FORALL indx in ar_contingency_tbl.first..ar_contingency_tbl.LAST
4378: SAVE EXCEPTIONS
4379: INSERT INTO AR_INTERFACE_CONTS_ALL
4380: VALUES ar_contingency_tbl(indx);
4381:
4382: END IF;
4383:

Line 4506: delete from AR_INTERFACE_CONTS

4502:
4503: -- ----------------------------------
4504: -- delete records from contingencies
4505: -- ----------------------------------
4506: delete from AR_INTERFACE_CONTS
4507: --start: | 15-FEB-07 cklee R12 Billing enhancement project
4508: -- where interface_line_attribute10 = to_char(SUBSTR (error_tbl(indx).id,1, 20))
4509: -- and interface_line_attribute11 = to_char(SUBSTR(error_tbl(indx).id,21));
4510: where interface_line_attribute14 = to_char(error_tbl(indx).id);

Line 4564: DELETE FROM AR_INTERFACE_CONTS

4560: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4561: AND TAI.ID = TIL.TAI_ID
4562: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));
4563:
4564: DELETE FROM AR_INTERFACE_CONTS
4565: WHERE interface_line_attribute14 IN
4566: (SELECT TLD.ID
4567: FROM OKL_TXD_AR_LN_DTLS_B TLD
4568: , OKL_TXL_AR_INV_LNS_B TIL