DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_PPA_INVOICES_GT

Line 1018: -- now also be the Temp table AP_PPA_INVOICES_GT

1014: ----------------------------------------------------------------------
1015: -- Step 13
1016: -- Check for Invalid Global Flexfield Value.
1017: -- Retropricing: This may require JG modifications as parent table can
1018: -- now also be the Temp table AP_PPA_INVOICES_GT
1019: ----------------------------------------------------------------------
1020: debug_info := '(Check Invoice Validation 13) Check for GDFF';
1021: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
1022: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 1921: UPDATE AP_ppa_invoices_gt H

1917: AND nvl(trunc(PVS.INACTIVE_DATE),
1918: AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
1919: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;
1920:
1921: UPDATE AP_ppa_invoices_gt H
1922: SET vendor_site_id = l_vendor_site_id
1923: WHERE invoice_id = p_invoice_rec.invoice_id;
1924:
1925:

Line 1941: UPDATE AP_ppa_invoices_gt H

1937: AND nvl(trunc(PVS.INACTIVE_DATE),
1938: AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
1939: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;
1940:
1941: UPDATE AP_ppa_invoices_gt H
1942: SET vendor_site_id = l_vendor_site_id
1943: WHERE invoice_id = p_invoice_rec.invoice_id;
1944:
1945: EXCEPTION