APPS.ARP_BF_BILL dependencies on AR_CONS_INV_TRX_LINES

Line 337: DELETE FROM ar_cons_inv_trx_lines

333: AND CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i
334: where i.status = 'PRE_REJECTED'));
335:
336:
337: DELETE FROM ar_cons_inv_trx_lines
338: WHERE cons_inv_id IN
339: (SELECT CI.cons_inv_id
340: FROM ar_cons_inv CI
341: WHERE CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i

Line 1565: write_debug_and_log('insert to ar_cons_inv_trx_lines for ' || L_inv_trx.trx_id);

1561: /** For audit purposes, insert detail line information even if
1562: reporting in summary. Also note that cons_inv_line_number
1563: is one value for detail lines for a specific invoice. **/
1564:
1565: write_debug_and_log('insert to ar_cons_inv_trx_lines for ' || L_inv_trx.trx_id);
1566: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1567: cons_inv_line_number,
1568: customer_trx_id,
1569: customer_trx_line_id,

Line 1566: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,

1562: reporting in summary. Also note that cons_inv_line_number
1563: is one value for detail lines for a specific invoice. **/
1564:
1565: write_debug_and_log('insert to ar_cons_inv_trx_lines for ' || L_inv_trx.trx_id);
1566: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1567: cons_inv_line_number,
1568: customer_trx_id,
1569: customer_trx_line_id,
1570: line_number,

Line 1598: write_debug_and_log('update ar_cons_inv_trx_lines for TAX');

1594: AND line_type NOT IN ('TAX', 'FREIGHT');
1595:
1596: /** now update lines with associated tax line **/
1597:
1598: write_debug_and_log('update ar_cons_inv_trx_lines for TAX');
1599: OPEN c_tax(L_inv_trx.trx_id);
1600: LOOP
1601: FETCH c_tax BULK COLLECT INTO
1602: l_line_id , l_tax_sum, l_include_tax_sum LIMIT l_bulk_fetch_rows;

Line 1607: UPDATE ar_cons_inv_trx_lines

1603:
1604: -- 1. Update tax_amount
1605: -- 2. Exclude inclusive tax amount total from extended_amount
1606: FORALL i IN 1..l_line_id.count
1607: UPDATE ar_cons_inv_trx_lines
1608: SET tax_amount = l_tax_sum(i),
1609: extended_amount = extended_amount - l_include_tax_sum(i)
1610: WHERE customer_trx_id = L_inv_trx.trx_id
1611: AND customer_trx_line_id = l_line_id(i) ;

Line 1618: write_debug_and_log('insert to ar_cons_inv_trx_lines for FREIGHT');

1614: END LOOP;
1615: CLOSE c_tax;
1616:
1617: /** now create 1 summary row for freight **/
1618: write_debug_and_log('insert to ar_cons_inv_trx_lines for FREIGHT');
1619: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1620: cons_inv_line_number,
1621: customer_trx_id,
1622: customer_trx_line_id,

Line 1619: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,

1615: CLOSE c_tax;
1616:
1617: /** now create 1 summary row for freight **/
1618: write_debug_and_log('insert to ar_cons_inv_trx_lines for FREIGHT');
1619: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1620: cons_inv_line_number,
1621: customer_trx_id,
1622: customer_trx_line_id,
1623: line_number,

Line 2484: FROM ar_cons_inv_trx_lines

2480: 'DELAY_CMAPP');
2481:
2482: SELECT nvl(sum(tax_amount),0)
2483: INTO l_period_tax
2484: FROM ar_cons_inv_trx_lines
2485: WHERE cons_inv_id = l_consinv_id;
2486:
2487:
2488: UPDATE ar_cons_inv