[Home] [Help]
475: ,G_SRC_TYP_LINES_WITHOUT_DISTS
476: ,G_SRC_TAB_AP_INV_LINES_ALL
477: from
478: ap_invoices_all ai
479: ,ap_invoice_lines_all ail
480: ,ap_org_attributes_gt org_gtt
481: where
482: ai.invoice_id = ail.invoice_id
483: and (ail.accounting_date between g_period_start_date and g_period_end_date)
2104:
2105: debug ('update_ap_acct_date: total distributions processed in ap_period_close_excps_gt: '||l_dbi_key_value_list.count);
2106:
2107: forall i in l_dbi_key_value_list.first .. l_dbi_key_value_list.last
2108: UPDATE ap_invoice_lines_all ail
2109: SET accounting_date = g_sweep_to_date,
2110: period_name = g_sweep_to_period,
2111: last_update_date = sysdate,
2112: last_updated_by = 5
2116: WHERE gt.invoice_distribution_id = l_dbi_key_value_list(i)
2117: AND gt.source_type = G_SRC_TYP_UNACCT_DISTS
2118: AND gt.source_table_name = G_SRC_TAB_AP_INV_DISTS_ALL); -- 7318763
2119:
2120: debug ('update_ap_acct_date: total lines processed in ap_invoice_lines_all: '||l_dbi_key_value_list.count);
2121:
2122: l_dbi_key_value_list.delete;
2123:
2124:
2148:
2149: ltab_id.delete;
2150:
2151:
2152: UPDATE ap_invoice_lines_all ail
2153: SET accounting_date = g_sweep_to_date,
2154: period_name = g_sweep_to_period,
2155: last_update_date = sysdate,
2156: last_updated_by = 5
2159: FROM ap_period_close_excps_gt gt
2160: WHERE gt.source_type = G_SRC_TYP_LINES_WITHOUT_DISTS
2161: AND gt.source_table_name = G_SRC_TAB_AP_INV_LINES_ALL)
2162: returning ail.invoice_id, ail.line_number bulk collect into ltab_id, ltab_line_num;
2163: debug ('update_ap_acct_date: total records updated in ap_invoice_lines_all: '||sql%rowcount);
2164:
2165: forall i in ltab_id.first..ltab_id.last
2166: update /*+index (gt AP_PERIOD_CLOSE_EXCPS_GT_N4)*/ap_period_close_excps_gt gt --Bug 9045217
2167: set process_status_flag = 'Y'