351: * Purpose : Obtains all the information associated to the current *
352: * withholding tax type and for a particular supplier: *
353: * 1. Minimum taxable base amount *
354: * 2. Minimum withheld amount *
355: * 3. Associated attributes (from JL_ZZ_AP_AWT_TYPES) *
356: * 4. Supplier exemptions *
357: * 5. Multilateral contribution *
358: * *
359: **************************************************************************/
359: **************************************************************************/
360: PROCEDURE Initialize_Withholding_Type
361: (P_AWT_Type_Code IN Varchar2,
362: P_Vendor_Id IN Number,
363: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
364: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE)
365: IS
366: ------------------------------
367: -- Local variables definition
381: -----------------------------------------------------------
382: l_debug_info := 'Obtains withholding tax type attributes';
383: SELECT *
384: INTO P_Rec_AWT_Type
385: FROM jl_zz_ap_awt_types
386: WHERE awt_type_code = P_AWT_Type_Code;
387:
388: -----------------------------------------------------------
389: -- Obtains all the attributes for the withholding tax type
766: * *
767: **************************************************************************/
768: PROCEDURE Process_Withholding_Name
769: (P_Vendor_Id IN Number,
770: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
771: P_Rec_AWT_Name IN Rec_AWT_CODE,
772: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
773: P_Rec_Suppl_AWT_Name IN jl_zz_ap_sup_awt_cd%ROWTYPE,
774: P_AWT_Date IN Date,
1730: * tax type included within the payment. *
1731: * *
1732: **************************************************************************/
1733: PROCEDURE Process_Withholding_Type
1734: (P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
1735: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
1736: P_AWT_Date IN Date,
1737: P_Currency_Code IN Varchar2,
1738: P_Tab_Withhold IN OUT NOCOPY Tab_Withholding)