PACKAGE: APPS.JE_IL_TAX_PKG

Source

1 PACKAGE  JE_IL_TAX_PKG AUTHID CURRENT_USER
2 -- $Header: jeilwhtaps.pls 120.10.12020000.3 2013/03/19 12:56:00 rdebpur noship $
3 AS
4 
5   P_From_Period          VARCHAR2(10);
6   P_To_Period            VARCHAR2(10);
7   P_Vendor_Type          VARCHAR2(1);
8   P_Legal_Entity_ID      NUMBER;
9   P_Ledger_ID		 NUMBER;
10   P_Method		 VARCHAR2(10);
11   P_Order_By		 VARCHAR2(10);
12   P_Information_Level	 VARCHAR2(10);
13   P_Name_Level		 VARCHAR2(10);
14   P_Manual_Rpt_Exist	 VARCHAR2(10);
15   P_Comp_Rpt_Exist	 VARCHAR2(10);
16   P_Payer_Position	 VARCHAR2(10);
17   P_Vendor_Name		 VARCHAR2(200);
18   P_Vendor_Site		 VARCHAR2(200);
19   P_Report_Name		 VARCHAR2(10);
20   P_Year		 VARCHAR2(10);
21   P_From_Supplier_Number VARCHAR2(10);
22   P_To_Supplier_Number   VARCHAR2(10);
23   P_Include_WHT_0	 VARCHAR2(10);
24   gn_awt_amount          NUMBER;
25   gn_invoice_id          NUMBER;
26   gn_check_id            NUMBER;
27   p_vendor_name_col      VARCHAR2(1000);
28   p_vendor_sitecode_col  VARCHAR2(1000);
29   p_vat_reg_no           VARCHAR2(4000);
30   p_flex_value_cond      VARCHAR2(1000);
31   p_deduction_type_cond  VARCHAR2(1000);
32   p_business_sec_cond    VARCHAR2(3000);
33   p_tax_payerid_cond     VARCHAR2(3000);
34   p_global_cond          VARCHAR2(1000);
35   p_supplier_num_from    VARCHAR2(1000);
36   p_supplier_num_to      VARCHAR2(1000);
37   fnd_debug_log 		 VARCHAR2(3);
38   p_vendor_type_col 	 VARCHAR2(100);
39   p_vendor_type_cond 	 VARCHAR2(1000);
40   p_vendor_name_cond 	 VARCHAR2(500);
41   p_vendor_site_cond 	 VARCHAR2(500);
42   p_exp_irs_cond 	 VARCHAR2(1000);
43   p_supplier_type 	 VARCHAR2(1000);
44   p_bank_supplier 	 VARCHAR2(1000);
45   p_order_by_cond 	 VARCHAR2(500);
46   p_first_party_query    VARCHAR2(8000);
47   p_count_lines_query    VARCHAR2(8000);
48   p_payment_info_query   VARCHAR2(8000);
49   p_awt_taxrates_query   VARCHAR2(8000);
50   p_vendor_balance_query VARCHAR2(8000);
51   p_count_vendors_query  VARCHAR2(8000);
52   p_definition_code      VARCHAR2(30);
53 
54   l_currency_check       VARCHAR2(8000);
55   l_foreign_suppliers_check       VARCHAR2(8000);
56 
57   l_primary_ledger_id	 NUMBER;
58   l_period_set_name      VARCHAR2(20);
59 
60 
61   FUNCTION BeforeReport RETURN BOOLEAN;
62 
63   FUNCTION IS_NUMBER (p_str1 VARCHAR2,p_str2 VARCHAR2) RETURN VARCHAR2;
64 
65   FUNCTION get_gross_amount(pn_invoice_id NUMBER,pn_check_id NUMBER, pd_start_date DATE, pd_end_date DATE, pv_void NUMBER)RETURN NUMBER;
66   FUNCTION get_awt_amount RETURN NUMBER;
67   FUNCTION get_invoice_id RETURN NUMBER;
68   TYPE check_inv_r IS RECORD
69   ( check_id number,
70     invoice_id number);
71   TYPE check_inv_table IS TABLE OF  check_inv_r INDEX BY BINARY_INTEGER;
72    t_check_inv check_inv_table;
73 
74     FUNCTION Get_Awt_Amt( Pn_Invoice_Id In Number
75                           , Pn_Check_Id In Number
76                           , pd_start_date IN DATE
77                           , Pd_End_Date IN DATE
78                           , Pv_Void In Number)
79 	Return Number;
80    Function Get_Awt_Bank_Amt ( Pn_Check_Id In Number)
81 	RETURN NUMBER;
82 
83 END JE_IL_TAX_PKG;