APPS.JAI_AP_DTC_PREPAYMENTS_PKG dependencies on JAI_AP_TDS_INVOICES

Line 659: /*update JAI_AP_TDS_INVOICES

655: goto exit_from_procedure;
656: end if;
657:
658: /* prepayment apply scenario for backward compatibility*/
659: /*update JAI_AP_TDS_INVOICES
660: set amt_reversed = nvl(amt_reversed, 0) - r_get_total_prepayment_tax.tds_amount,
661: amt_applied = nvl(amt_applied, 0) - abs(r_get_total_prepayment_tax.tds_taxable_basis)
662: where invoice_id = p_invoice_id;*/
663: /* prepayment apply scenario for backward compatibility*/

Line 992: update JAI_AP_TDS_INVOICES

988: where invoice_id = p_invoice_id
989: and invoice_distribution_id_prepay = p_parent_distribution_id;
990:
991: /* prepayment apply scenario for backward compatibility*/
992: update JAI_AP_TDS_INVOICES
993: set amt_reversed = nvl(amt_reversed, 0) - r_get_total_prepayment_tax.tds_amount,
994: amt_applied = nvl(amt_applied, 0) - abs(p_prepay_amount * nvl(p_exchange_rate,1))
995: where invoice_id = p_invoice_id;
996:

Line 2172: update JAI_AP_TDS_INVOICES

2168: end if ; \* IF ln_tot_tds_amt > 0 THEN *\
2169: \*Bug 8431516 - End*\
2170:
2171: \* prepayment apply scenario for backward compatibility*\
2172: update JAI_AP_TDS_INVOICES
2173: set amt_reversed = nvl(amt_reversed, 0) + r_get_total_prepayment_tax.tds_amount,
2174: amt_applied = nvl(amt_applied, 0) + abs(p_prepay_amount)
2175: where invoice_id = p_invoice_id;
2176:

Line 2347: from JAI_AP_TDS_INVOICES

2343: is
2344:
2345: cursor c_tds_count(p_invoice_id number, p_source_attribute varchar2) is
2346: select count(1)
2347: from JAI_AP_TDS_INVOICES
2348: where invoice_id = p_invoice_id
2349: and source_attribute = p_source_attribute;
2350:
2351: /* Following cursor definition has been changed to cater for the obsoletion of table ja_in_ap_tds_inv_temp */

Line 3851: update JAI_AP_TDS_INVOICES

3847: -------------------------------------------------------------------------------------------
3848: --Added by Chong.Lei for bug#13802244 end
3849:
3850: /* prepayment apply scenario for backward compatibility*/
3851: update JAI_AP_TDS_INVOICES
3852: set amt_reversed = nvl(amt_reversed, 0) + r_get_total_prepayment_tax.tds_amount * nvl(p_exchange_rate,1),
3853: amt_applied = nvl(amt_applied, 0) + abs(p_prepay_amount) * nvl(p_exchange_rate,1)
3854: where invoice_id = p_invoice_id;
3855: