52: PROCEDURE Initialize_Withholdings
53: (P_Vendor_Id IN Number,
54: P_AWT_Type_Code IN Varchar2,
55: P_Tax_Id IN Number,
56: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
57: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
58: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
59: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
60: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding);
69: * *
70: **************************************************************************/
71: PROCEDURE Process_Withholdings
72: (P_Vendor_Id IN Number,
73: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
74: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
75: P_AWT_Date IN Date,
76: P_GL_Period_Name IN Varchar2,
77: P_Base_Currency_Code IN Varchar2,
377: ap_invoices apin,
378: ap_invoice_distributions apid,
379: jl_zz_ap_supp_awt_types jlst,
380: jl_zz_ap_sup_awt_cd jlsc,
381: jl_zz_ap_awt_types jlat,
382: po_vendors pove,
383: po_vendors pove2
384: WHERE
385: apid.invoice_id = jlwh.invoice_id
403: ------------------------
404: -- Records Declaration
405: ------------------------
406: rec_withholding c_withholdings%ROWTYPE;
407: rec_awt_type jl_zz_ap_awt_types%ROWTYPE;
408: rec_awt_name Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code;
409: rec_suppl_awt_type jl_zz_ap_supp_awt_types%ROWTYPE;
410: rec_suppl_awt_name jl_zz_ap_sup_awt_cd%ROWTYPE;
411:
773: IS
774: -------------------------------
775: -- Local Variables Definition
776: -------------------------------
777: l_user_defined_formula_flag jl_zz_ap_awt_types.user_defined_formula_flag%TYPE;
778: debug_info Varchar2(100);
779: current_calling_sequence Varchar2(2000);
780:
781: --------------------------------------------------------------------------
791: ap_invoices apin,
792: ap_invoice_distributions apid,
793: jl_zz_ap_supp_awt_types jlst,
794: jl_zz_ap_sup_awt_cd jlsc,
795: jl_zz_ap_awt_types jlat,
796: po_vendors pove
797: WHERE
798: apid.invoice_id = jlwh.invoice_id
799: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id
860: PROCEDURE Initialize_Withholdings
861: (P_Vendor_Id IN Number,
862: P_AWT_Type_Code IN Varchar2,
863: P_Tax_Id IN Number,
864: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
865: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
866: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
867: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
868: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding)
896: * *
897: **************************************************************************/
898: PROCEDURE Process_Withholdings
899: (P_Vendor_Id IN Number,
900: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
901: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
902: P_AWT_Date IN Date,
903: P_GL_Period_Name IN Varchar2,
904: P_Base_Currency_Code IN Varchar2,