eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_CO_AP_WITHHOLDING_PKG dependencies on AP_WITHHOLDING_PKG

Line 1: PACKAGE BODY JL_CO_AP_WITHHOLDING_PKG AS

1: PACKAGE BODY JL_CO_AP_WITHHOLDING_PKG AS
2: /* $Header: jlcopwhb.pls 120.12.12010000.2 2009/01/29 13:42:24 gkumares ship $ */
3:
4: /**************************************************************************
5: * Private Procedure Specification *

Line 57: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,

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);
61:

Line 60: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding);

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);
61:
62:
63:
64: /**************************************************************************

Line 80: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

76: P_GL_Period_Name IN Varchar2,
77: P_Base_Currency_Code IN Varchar2,
78: P_User_Defd_Formula IN Boolean,
79: P_NIT_Number IN Varchar2 Default null,
80: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
81: P_Tab_All_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding,
82: P_AWT_Success OUT NOCOPY Varchar2,
83: P_Last_Updated_By IN Number Default null,
84: P_Last_Update_Login IN Number Default null,

Line 81: P_Tab_All_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding,

77: P_Base_Currency_Code IN Varchar2,
78: P_User_Defd_Formula IN Boolean,
79: P_NIT_Number IN Varchar2 Default null,
80: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
81: P_Tab_All_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding,
82: P_AWT_Success OUT NOCOPY Varchar2,
83: P_Last_Updated_By IN Number Default null,
84: P_Last_Update_Login IN Number Default null,
85: P_Program_Application_Id IN Number Default null,

Line 135: current_calling_sequence := 'JL_CO_AP_WITHHOLDING_PKG.Jl_Co_Ap_Do_Withholding';

131:
132:
133: BEGIN
134:
135: current_calling_sequence := 'JL_CO_AP_WITHHOLDING_PKG.Jl_Co_Ap_Do_Withholding';
136:
137: -----------------------------------------------------------------------
138: -- IF calling module is different from AUTOAPPROVAL should not execute
139: -- anything for Colombia Bug# 2279293

Line 233: Ap_Withholding_Pkg.Create_AWT_Distributions

229: ELSE
230: ----------------------------
231: -- Create AWT Distributions
232: ----------------------------
233: Ap_Withholding_Pkg.Create_AWT_Distributions
234: (P_Invoice_Id,
235: P_Calling_Module,
236: l_create_dists,
237: P_Payment_Num,

Line 258: Ap_Withholding_Pkg.Create_AWT_Invoices

254:
255: -----------------------
256: -- Create AWT Invoices
257: -----------------------
258: Ap_Withholding_Pkg.Create_AWT_Invoices
259: (P_Invoice_Id,
260: P_AWT_Date,
261: P_Last_Updated_By,
262: P_Last_Update_Login,

Line 408: rec_awt_name Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code;

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:
412: -------------------------

Line 415: tab_withholdings Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding;

411:
412: -------------------------
413: -- Table Declaration
414: -------------------------
415: tab_withholdings Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding;
416: tab_invoice_wh Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding;
417:
418: BEGIN
419:

Line 416: tab_invoice_wh Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding;

412: -------------------------
413: -- Table Declaration
414: -------------------------
415: tab_withholdings Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding;
416: tab_invoice_wh Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding;
417:
418: BEGIN
419:
420: current_calling_sequence := 'JL_CO_AP_WITHHOLDING_PKG.Jl_Co_Ap_Calculate_AWT_Amounts';

Line 420: current_calling_sequence := 'JL_CO_AP_WITHHOLDING_PKG.Jl_Co_Ap_Calculate_AWT_Amounts';

416: tab_invoice_wh Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding;
417:
418: BEGIN
419:
420: current_calling_sequence := 'JL_CO_AP_WITHHOLDING_PKG.Jl_Co_Ap_Calculate_AWT_Amounts';
421:
422: ------------------------------------------
423: -- Opens the cursor to select all the NIT
424: ------------------------------------------

Line 465: l_base_currency_code := Jl_Zz_Ap_Withholding_Pkg.Get_Base_Currency_Code;

461:
462: ---------------------------
463: -- Gets generic parameters
464: ---------------------------
465: l_base_currency_code := Jl_Zz_Ap_Withholding_Pkg.Get_Base_Currency_Code;
466: l_gl_period_name := Jl_Zz_Ap_Withholding_Pkg.Get_GL_Period_Name
467: (P_AWT_Date);
468:
469: ----------------------------------

Line 466: l_gl_period_name := Jl_Zz_Ap_Withholding_Pkg.Get_GL_Period_Name

462: ---------------------------
463: -- Gets generic parameters
464: ---------------------------
465: l_base_currency_code := Jl_Zz_Ap_Withholding_Pkg.Get_Base_Currency_Code;
466: l_gl_period_name := Jl_Zz_Ap_Withholding_Pkg.Get_GL_Period_Name
467: (P_AWT_Date);
468:
469: ----------------------------------
470: -- Initialize auxillary variables

Line 506: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

502: IF (c_withholdings%NOTFOUND) THEN
503: ------------------------------------------------
504: -- Process the withholding tax name information
505: ------------------------------------------------
506: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name
507: (l_current_vendor_id,
508: rec_awt_type,
509: rec_awt_name,
510: rec_suppl_awt_type,

Line 556: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

552:
553: -------------------------------------------------
554: -- Process previous withholding tax information
555: -------------------------------------------------
556: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name
557: (l_current_vendor_id,
558: rec_awt_type,
559: rec_awt_name,
560: rec_suppl_awt_type,

Line 627: Jl_Zz_Ap_Withholding_Pkg.Print_Tax_Names (tab_withholdings);

623: -------------------------------------------
624: ELSIF (rec_withholding.tax_id <> l_previous_tax_id) THEN
625:
626:
627: Jl_Zz_Ap_Withholding_Pkg.Print_Tax_Names (tab_withholdings);
628:
629: ------------------------------------------------
630: -- Process previous withholding tax information
631: ------------------------------------------------

Line 633: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

629: ------------------------------------------------
630: -- Process previous withholding tax information
631: ------------------------------------------------
632:
633: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name
634: (l_current_vendor_id,
635: rec_awt_type,
636: rec_awt_name,
637: rec_suppl_awt_type,

Line 656: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name

652: -- Obtains all the information associated to the
653: -- withholding tax name
654: -------------------------------------------------
655:
656: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name
657: (rec_withholding.awt_type_code,
658: rec_withholding.tax_id,
659: rec_withholding.vendor_id,
660: rec_awt_name,

Line 679: l_tax_base_amt := Jl_Zz_Ap_Withholding_Pkg.Get_Taxable_Base_Amount

675:
676: -----------------------------------
677: -- Obtains the taxable base amount
678: -----------------------------------
679: l_tax_base_amt := Jl_Zz_Ap_Withholding_Pkg.Get_Taxable_Base_Amount
680: (rec_withholding.invoice_id,
681: rec_withholding.invoice_distribution_id,
682: rec_withholding.line_amount,
683: Null,

Line 692: Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name

688: -- Stores the information of the current tax name into the
689: -- PL/SQL table
690: -----------------------------------------------------------
691: l_current_awt := l_current_awt + 1;
692: Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name
693: (tab_withholdings,
694: l_current_awt,
695: rec_withholding.invoice_id,
696: rec_withholding.invoice_distribution_id,

Line 812: current_calling_sequence := 'JL_CO_AP_WITHHOLDING_PKG.User_Defined_Formula_Exists';

808:
809:
810: BEGIN
811:
812: current_calling_sequence := 'JL_CO_AP_WITHHOLDING_PKG.User_Defined_Formula_Exists';
813:
814: -------------------------------------------------------------------------
815: -- Opens the cursor to select all the user defined formula flag
816: -------------------------------------------------------------------------

Line 865: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,

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)
869: IS

Line 868: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding)

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)
869: IS
870: BEGIN
871:
872: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Type

Line 872: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Type

868: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding)
869: IS
870: BEGIN
871:
872: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Type
873: (P_AWT_Type_Code,
874: P_Vendor_Id,
875: P_Rec_AWT_Type,
876: P_Rec_Suppl_AWT_Type);

Line 878: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name

874: P_Vendor_Id,
875: P_Rec_AWT_Type,
876: P_Rec_Suppl_AWT_Type);
877:
878: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name
879: (P_AWT_Type_Code,
880: P_Tax_Id,
881: P_Vendor_Id,
882: P_Rec_AWT_Name,

Line 885: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Table

881: P_Vendor_Id,
882: P_Rec_AWT_Name,
883: P_Rec_Suppl_AWT_Name);
884:
885: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Table
886: (P_Wh_Table);
887:
888: END Initialize_Withholdings;
889:

Line 907: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

903: P_GL_Period_Name IN Varchar2,
904: P_Base_Currency_Code IN Varchar2,
905: P_User_Defd_Formula IN Boolean,
906: P_NIT_Number IN Varchar2 Default null,
907: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
908: P_Tab_All_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding,
909: P_AWT_Success OUT NOCOPY Varchar2,
910: P_Last_Updated_By IN Number Default null,
911: P_Last_Update_Login IN Number Default null,

Line 908: P_Tab_All_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding,

904: P_Base_Currency_Code IN Varchar2,
905: P_User_Defd_Formula IN Boolean,
906: P_NIT_Number IN Varchar2 Default null,
907: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
908: P_Tab_All_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding,
909: P_AWT_Success OUT NOCOPY Varchar2,
910: P_Last_Updated_By IN Number Default null,
911: P_Last_Update_Login IN Number Default null,
912: P_Program_Application_Id IN Number Default null,

Line 925: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type

921: BEGIN
922: ------------------------------------------------
923: -- Process previous withholding tax type
924: ------------------------------------------------
925: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type
926: (P_Rec_AWT_Type,
927: P_Rec_Suppl_AWT_Type,
928: P_AWT_Date,
929: P_Base_Currency_Code,

Line 937: Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings(P_Tab_Withhold,

933: -- Prorates the withheld amounts, if applicable
934: -------------------------------------------------
935: IF ((P_user_defd_formula) AND
936: (nvl(P_Rec_AWT_Type.user_defined_formula_flag,'N') = 'N')) THEN
937: Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings(P_Tab_Withhold,
938: P_Base_Currency_Code);
939: Jl_Zz_Ap_Withholding_Pkg.Store_Prorated_Withholdings
940: (P_Tab_Withhold,
941: P_Tab_All_Withhold);

Line 939: Jl_Zz_Ap_Withholding_Pkg.Store_Prorated_Withholdings

935: IF ((P_user_defd_formula) AND
936: (nvl(P_Rec_AWT_Type.user_defined_formula_flag,'N') = 'N')) THEN
937: Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings(P_Tab_Withhold,
938: P_Base_Currency_Code);
939: Jl_Zz_Ap_Withholding_Pkg.Store_Prorated_Withholdings
940: (P_Tab_Withhold,
941: P_Tab_All_Withhold);
942: END IF;
943:

Line 958: Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table

954:
955: ----------------------------------------
956: -- Insert Temporary Distributions Lines
957: ----------------------------------------
958: Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table
959: (P_Tab_Withhold,
960: P_Vendor_Id,
961: P_AWT_Date,
962: P_GL_Period_Name,

Line 985: Jl_Zz_Ap_Withholding_Pkg.Print_Tax_Names (P_Tab_Withhold);

981: IF (P_AWT_Success <> 'SUCCESS') THEN
982: RETURN;
983: END IF;
984:
985: Jl_Zz_Ap_Withholding_Pkg.Print_Tax_Names (P_Tab_Withhold);
986:
987: END Process_Withholdings;
988:
989: END JL_CO_AP_WITHHOLDING_PKG;

Line 989: END JL_CO_AP_WITHHOLDING_PKG;

985: Jl_Zz_Ap_Withholding_Pkg.Print_Tax_Names (P_Tab_Withhold);
986:
987: END Process_Withholdings;
988:
989: END JL_CO_AP_WITHHOLDING_PKG;