DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on ZX_TAX_DIST_ID_GT

Line 1781: INSERT into ZX_TAX_DIST_ID_GT

1777: l_msg_count number;
1778: l_msg_data varchar2(2000);
1779: BEGIN
1780:
1781: INSERT into ZX_TAX_DIST_ID_GT
1782: (SELECT detail_tax_dist_id
1783: FROM ap_period_close_excps_gt
1784: WHERE detail_tax_dist_id is not null
1785: AND source_type = G_SRC_TYP_UNACCT_DISTS

Line 1789: debug ('update_ebtax_dists: total records inserted in ZX_TAX_DIST_ID_GT: '||sql%rowcount);

1785: AND source_type = G_SRC_TYP_UNACCT_DISTS
1786: AND source_table_name in ( G_SRC_TAB_AP_INV_DISTS_ALL,
1787: G_SRC_TAB_AP_SELF_TAX_DIST_ALL));
1788:
1789: debug ('update_ebtax_dists: total records inserted in ZX_TAX_DIST_ID_GT: '||sql%rowcount);
1790:
1791: if sql%rowcount > 0 then
1792:
1793: ZX_API_PUB.Update_Tax_dist_gl_date (