APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_INVOICE_LINES_ALL

Line 450: ,ap_invoice_lines_all ail

446: ,G_SRC_TYP_LINES_WITHOUT_DISTS
447: ,G_SRC_TAB_AP_INV_LINES_ALL
448: from
449: ap_invoices_all ai
450: ,ap_invoice_lines_all ail
451: ,ap_org_attributes_gt org_gtt
452: where
453: ai.invoice_id = ail.invoice_id
454: -- bug 7311486 UTR report must run even if dates and period is not specified

Line 512: ,ap_invoice_lines_all ail

508: ,G_SRC_TYP_LINES_WITHOUT_DISTS
509: ,G_SRC_TAB_AP_INV_LINES_ALL
510: from
511: ap_invoices_all ai
512: ,ap_invoice_lines_all ail
513: ,ap_org_attributes_gt org_gtt
514: where
515: ai.invoice_id = ail.invoice_id
516: -- bug 7311486 UTR report must run even if dates and period is not specified

Line 1827: UPDATE ap_invoice_lines_all ail

1823:
1824: debug ('update_ap_acct_date: total distributions processed in ap_period_close_excps_gt: '||l_dbi_key_value_list.count);
1825:
1826: forall i in l_dbi_key_value_list.first .. l_dbi_key_value_list.last
1827: UPDATE ap_invoice_lines_all ail
1828: SET accounting_date = g_sweep_to_date,
1829: period_name = g_sweep_to_period,
1830: last_update_date = sysdate,
1831: last_updated_by = 5

Line 1838: debug ('update_ap_acct_date: total lines processed in ap_invoice_lines_all: '||l_dbi_key_value_list.count);

1834: WHERE gt.invoice_distribution_id = l_dbi_key_value_list(i)
1835: AND gt.source_type=G_SRC_TYP_UNACCT_DISTS
1836: AND gt.source_table_name = G_SRC_TAB_AP_INV_DISTS_ALL); -- 7318763
1837:
1838: debug ('update_ap_acct_date: total lines processed in ap_invoice_lines_all: '||l_dbi_key_value_list.count);
1839:
1840: l_dbi_key_value_list.delete;
1841:
1842:

Line 1869: UPDATE ap_invoice_lines_all ail

1865:
1866: ltab_id.delete;
1867:
1868:
1869: UPDATE ap_invoice_lines_all ail
1870: SET accounting_date = g_sweep_to_date,
1871: period_name = g_sweep_to_period,
1872: last_update_date = sysdate,
1873: last_updated_by = 5

Line 1880: debug ('update_ap_acct_date: total records updated in ap_invoice_lines_all: '||sql%rowcount);

1876: FROM ap_period_close_excps_gt gt
1877: WHERE gt.source_type = G_SRC_TYP_LINES_WITHOUT_DISTS
1878: AND gt.source_table_name = G_SRC_TAB_AP_INV_LINES_ALL)
1879: returning ail.invoice_id, ail.line_number bulk collect into ltab_id, ltab_line_num;
1880: debug ('update_ap_acct_date: total records updated in ap_invoice_lines_all: '||sql%rowcount);
1881:
1882: forall i in ltab_id.first..ltab_id.last
1883: update ap_period_close_excps_gt gt
1884: set process_status_flag = 'Y'