DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on ZX_TAX_DIST_ID_GT

Line 1518: INSERT into ZX_TAX_DIST_ID_GT

1514: l_msg_count number;
1515: l_msg_data varchar2(2000);
1516: BEGIN
1517:
1518: INSERT into ZX_TAX_DIST_ID_GT
1519: (SELECT detail_tax_dist_id
1520: FROM ap_period_close_excps_gt
1521: WHERE detail_tax_dist_id is not null
1522: AND source_type = G_SRC_TYP_UNACCT_DISTS

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

1522: AND source_type = G_SRC_TYP_UNACCT_DISTS
1523: AND source_table_name in ( G_SRC_TAB_AP_INV_DISTS_ALL,
1524: G_SRC_TAB_AP_SELF_TAX_DIST_ALL));
1525:
1526: debug ('update_ebtax_dists: total records inserted in ZX_TAX_DIST_ID_GT: '||sql%rowcount);
1527:
1528: if sql%rowcount > 0 then
1529:
1530: ZX_API_PUB.Update_Tax_dist_gl_date (