DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKL_PROCESS_SALES_TAX_PVT

Line 273: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |

269: AND c.cle_id = a.id;
270:
271: l_inventory_item_id NUMBER;
272: l_inventory_org_id NUMBER; --21-Oct-2011 sechawla Bug 12888543
273: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
274: lx_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
275: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
276: l_tax_call_success_flag varchar2(1) := 'Y';
277: x_msg_index_out NUMBER;

Line 274: lx_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;

270:
271: l_inventory_item_id NUMBER;
272: l_inventory_org_id NUMBER; --21-Oct-2011 sechawla Bug 12888543
273: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
274: lx_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
275: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
276: l_tax_call_success_flag varchar2(1) := 'Y';
277: x_msg_index_out NUMBER;
278: BEGIN

Line 275: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |

271: l_inventory_item_id NUMBER;
272: l_inventory_org_id NUMBER; --21-Oct-2011 sechawla Bug 12888543
273: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
274: lx_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
275: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
276: l_tax_call_success_flag varchar2(1) := 'Y';
277: x_msg_index_out NUMBER;
278: BEGIN
279:

Line 589: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |

585: -- Trx Business Category, Product Fiscal Classification, Product Type, Ship To Location Id
586: -- This code has been commented since this API is not available yet. This will be uncommented once eb Tax impacts are coded.
587: -- Please remove these comments then.
588: l_tax_call_success_flag := 'Y';
589: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
590:
591: OKL_PROCESS_SALES_TAX_PVT.get_tax_determinants(p_api_version => p_api_version
592: ,p_init_msg_list => p_init_msg_list
593: ,x_return_status => x_return_status

Line 591: OKL_PROCESS_SALES_TAX_PVT.get_tax_determinants(p_api_version => p_api_version

587: -- Please remove these comments then.
588: l_tax_call_success_flag := 'Y';
589: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
590:
591: OKL_PROCESS_SALES_TAX_PVT.get_tax_determinants(p_api_version => p_api_version
592: ,p_init_msg_list => p_init_msg_list
593: ,x_return_status => x_return_status
594: ,x_msg_count => x_msg_count
595: ,x_msg_data => x_msg_data

Line 630: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |

626:
627: EXIT;
628: END IF;
629:
630: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
631:
632: INSERT INTO ap_invoice_lines_interface(
633: accounting_date
634: ,amount

Line 720: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |

716: ,'OKL_TXL_AP_INV_LNS_ALL_B'
717: ,r_invoice_lines.tpl_id
718: ,l_inventory_org_id --21-Oct-2011 sechawla Bug 12888543 : added inv org id
719: ,trim(substr(trim(substr(l_contract_number,1,100)) || '/' || trim(substr(l_asset_number,1,100)) || '/' || trim(substr(l_stream_type_purpose,1,38)), 1,240))
720: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
721:
722: ,lx_tax_det_rec.x_tax_code
723: ,lx_tax_det_rec.x_trx_business_category
724: ,lx_tax_det_rec.x_product_category

Line 738: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |

734: ,NULL
735: ,NULL
736: ,NULL
737: */
738: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
739: ,l_ship_to
740: ,l_inventory_item_id
741: ,l_PAY_DIST_SET_ID --:| 16-Oct-2007 cklee -- Fixed bug:6502786
742: );

Line 754: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |

750: UPDATE okl_ext_pay_invs_b
751: SET trx_status_code = 'PROCESSED'
752: WHERE CURRENT OF c_invoice_hdr;
753:
754: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
755:
756: UPDATE ap_invoices_interface
757: SET TAXATION_COUNTRY = lx_tax_det_rec.X_DEFAULT_TAXATION_COUNTRY
758: WHERE invoice_id = r_invoice_hdr.invoice_id;

Line 760: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |

756: UPDATE ap_invoices_interface
757: SET TAXATION_COUNTRY = lx_tax_det_rec.X_DEFAULT_TAXATION_COUNTRY
758: WHERE invoice_id = r_invoice_hdr.invoice_id;
759:
760: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
761: END IF;
762:
763: EXCEPTION
764: