APPS.ARP_BF_BILL dependencies on AR_CONS_INV_TRX_LINES

Line 357: DELETE FROM ar_cons_inv_trx_lines

353: AND CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i
354: where i.status = 'PRE_REJECTED'));
355:
356:
357: DELETE FROM ar_cons_inv_trx_lines
358: WHERE cons_inv_id IN
359: (SELECT CI.cons_inv_id
360: FROM ar_cons_inv CI
361: WHERE CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i

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

1523: /** For audit purposes, insert detail line information even if
1524: reporting in summary. Also note that cons_inv_line_number
1525: is one value for detail lines for a specific invoice. **/
1526:
1527: write_debug_and_log('insert to ar_cons_inv_trx_lines for ' || L_inv_trx.trx_id);
1528: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1529: cons_inv_line_number,
1530: customer_trx_id,
1531: customer_trx_line_id,

Line 1528: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,

1524: reporting in summary. Also note that cons_inv_line_number
1525: is one value for detail lines for a specific invoice. **/
1526:
1527: write_debug_and_log('insert to ar_cons_inv_trx_lines for ' || L_inv_trx.trx_id);
1528: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1529: cons_inv_line_number,
1530: customer_trx_id,
1531: customer_trx_line_id,
1532: line_number,

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

1556: AND line_type NOT IN ('TAX', 'FREIGHT');
1557:
1558: /** now update lines with associated tax line **/
1559:
1560: write_debug_and_log('update ar_cons_inv_trx_lines for TAX');
1561: OPEN c_tax(L_inv_trx.trx_id);
1562: LOOP
1563: FETCH c_tax BULK COLLECT INTO
1564: l_line_id , l_tax_sum, l_include_tax_sum LIMIT l_bulk_fetch_rows;

Line 1569: UPDATE ar_cons_inv_trx_lines

1565:
1566: -- 1. Update tax_amount
1567: -- 2. Exclude inclusive tax amount total from extended_amount
1568: FORALL i IN 1..l_line_id.count
1569: UPDATE ar_cons_inv_trx_lines
1570: SET tax_amount = l_tax_sum(i),
1571: extended_amount = extended_amount - l_include_tax_sum(i)
1572: WHERE customer_trx_id = L_inv_trx.trx_id
1573: AND customer_trx_line_id = l_line_id(i) ;

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

1576: END LOOP;
1577: CLOSE c_tax;
1578:
1579: /** now create 1 summary row for freight **/
1580: write_debug_and_log('insert to ar_cons_inv_trx_lines for FREIGHT');
1581: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1582: cons_inv_line_number,
1583: customer_trx_id,
1584: customer_trx_line_id,

Line 1581: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,

1577: CLOSE c_tax;
1578:
1579: /** now create 1 summary row for freight **/
1580: write_debug_and_log('insert to ar_cons_inv_trx_lines for FREIGHT');
1581: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1582: cons_inv_line_number,
1583: customer_trx_id,
1584: customer_trx_line_id,
1585: line_number,

Line 2235: FROM ar_cons_inv_trx_lines

2231: 'DELAY_CMAPP');
2232:
2233: SELECT nvl(sum(tax_amount),0)
2234: INTO l_period_tax
2235: FROM ar_cons_inv_trx_lines
2236: WHERE cons_inv_id = l_consinv_id;
2237:
2238:
2239: UPDATE ar_cons_inv