APPS.AP_APXT7UTT_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 312: UPDATE ap_invoice_distributions id

308: begin
309:
310: BEGIN
311: IF P_update_misc = 'UPDATE' THEN
312: UPDATE ap_invoice_distributions id
313: SET type_1099 = type_1099
314: WHERE nvl(type_1099,1) <> nvl(type_1099,1)
315: AND invoice_id in (SELECT i.invoice_id
316: FROM AP_Invoices i, AP_Invoice_Payments ip

Line 346: UPDATE ap_invoice_distributions id

342: l_region := P_region_code;
343: END IF;
344:
345: IF P_region_code <> 'INCOME TAX REPORTING SITE' then
346: UPDATE ap_invoice_distributions id
347: SET income_tax_region = l_region
348: WHERE ( (P_region_code <>'VENDOR SITE'
349: AND NVL(id.income_tax_region, 'DuMmY') <> P_region_code)
350: OR (P_region_code = 'VENDOR SITE'

Line 361: UPDATE ap_invoice_distributions id

357: AND nvl(ip.accounting_date,sysdate) between
358: P_start_date and
359: P_end_date );
360: ELSE
361: UPDATE ap_invoice_distributions id
362: SET income_tax_region = (select pvs.state
363: from po_vendor_sites pvs
364: where pvs.tax_reporting_site_flag= 'Y'
365: and pvs.vendor_id=vendor_id_R)