DBA Data[Home] [Help]

APPS.JAI_OPEN_API_PKG dependencies on JAI_AP_INVOICE_LINES

Line 10867: , 'JAI_AP_INVOICE_LINES' --Source_Table_Name

10863: , v_modvat_flag --Modvat_Flag
10864: , 'STANDALONE_INVOICE' --Source_Doc_Type
10865: , tax_lines_rec.internal_trx_id --Source_Doc_ID
10866: , tax_lines_rec.internal_trx_line_id --Source_Doc_Line_ID, will update with real invoice line number in later program.
10867: , 'JAI_AP_INVOICE_LINES' --Source_Table_Name
10868: , 'SYSTEM' --Tax_Modified_By
10869: , tax_lines_rec.adhoc_flag
10870: , ln_p1
10871: , ln_p2

Line 11224: /* For item lines in jai_ap_invoice_lines, organization_id, location_id,

11220: , lv_service_type_code
11221: , ln_tax_category_id;
11222: CLOSE interface_lines_cur;
11223:
11224: /* For item lines in jai_ap_invoice_lines, organization_id, location_id,
11225: * service_type_code, tax_category will leave as NULL after Open API importing.
11226: * So, following code manually update organization_id, location_id, service_type_code
11227: * tax_category column on table jai_ap_invoice_lines.
11228: */

Line 11227: * tax_category column on table jai_ap_invoice_lines.

11223:
11224: /* For item lines in jai_ap_invoice_lines, organization_id, location_id,
11225: * service_type_code, tax_category will leave as NULL after Open API importing.
11226: * So, following code manually update organization_id, location_id, service_type_code
11227: * tax_category column on table jai_ap_invoice_lines.
11228: */
11229: UPDATE jai_ap_invoice_lines
11230: SET organization_id = ln_organization_id
11231: , location_id = ln_location_id

Line 11229: UPDATE jai_ap_invoice_lines

11225: * service_type_code, tax_category will leave as NULL after Open API importing.
11226: * So, following code manually update organization_id, location_id, service_type_code
11227: * tax_category column on table jai_ap_invoice_lines.
11228: */
11229: UPDATE jai_ap_invoice_lines
11230: SET organization_id = ln_organization_id
11231: , location_id = ln_location_id
11232: , service_type_code = nvl(lv_service_type_code,service_type_code) --Changed by zhiwei for Bug#12537533 on 20110510
11233: , tax_category_id = ln_tax_category_id