DBA Data[Home] [Help]

APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on JL_ZZ_AP_WITHHOLDING_PKG

Line 128: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,

124: P_AWT_Type_Code IN Varchar2,
125: P_Tax_Id IN Number,
126: P_Calling_Sequence IN Varchar2,
127: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
128: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
129: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
130: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
131: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding);
132:

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

127: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
128: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
129: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
130: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
131: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding);
132:
133:
134:
135:

Line 153: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

149: P_Base_Currency_Code IN Varchar2,
150: P_Check_Id IN Number,
151: P_Selected_Check_Id IN Number,
152: P_Calling_Sequence IN Varchar2,
153: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
154: P_Total_Wh_Amount IN OUT NOCOPY Number,
155: P_AWT_Success OUT NOCOPY Varchar2,
156: P_Last_Updated_By IN Number Default null,
157: P_Last_Update_Login IN Number Default null,

Line 246: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

242: P_Payment_Num IN Number,
243: P_Check_Id IN Number,
244: P_Selected_Check_Id IN Number,
245: P_Calling_Sequence IN Varchar2,
246: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
247: P_Last_Updated_By IN Number Default null,
248: P_Last_Update_Login IN Number Default null,
249: P_Program_Application_Id IN Number Default null,
250: P_Program_Id IN Number Default null,

Line 351: P_Tab_Withhold IN Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

347: (P_Invoice_Id IN Number,
348: P_Tax_Name IN Varchar2,
349: P_Tax_Id IN Number,
350: P_Taxable_Base_Amount_Basis IN Varchar2,
351: P_Tab_Withhold IN Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
352: P_Inv_Payment_Num IN Number,
353: P_Calling_Sequence IN Varchar2)
354: RETURN Boolean;
355:

Line 367: (P_Tab_Withhold IN Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

363: * type (sums up all the prorated amounts). *
364: * *
365: **************************************************************************/
366: FUNCTION Total_Withholding_Amount
367: (P_Tab_Withhold IN Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
368: P_Calling_Sequence IN Varchar2)
369: RETURN Number;
370:
371:

Line 1253: Jl_Zz_Ap_Withholding_Pkg.Get_Withholding_Options (l_create_distr,

1249: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Get_Withholding_Options ');
1250: END IF;
1251: -- End Debug
1252:
1253: Jl_Zz_Ap_Withholding_Pkg.Get_Withholding_Options (l_create_distr,
1254: l_create_invoices);
1255:
1256: IF (l_create_distr <> 'PAYMENT') THEN
1257: -- Nothing to do

Line 1538: Jl_Zz_Ap_Withholding_Pkg.Get_Withholding_Options (l_create_distr,

1534: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Get_Withholding_Options ');
1535: END IF;
1536: -- End Debug
1537:
1538: Jl_Zz_Ap_Withholding_Pkg.Get_Withholding_Options (l_create_distr,
1539: l_create_invoices);
1540:
1541: -- Debug Information
1542: IF (DEBUG_Var = 'Y') THEN

Line 1875: --Jl_Zz_Ap_Withholding_Pkg.Get_Withholding_Options (l_create_distr,

1871: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Get_Withholding_Options ');
1872: END IF;
1873: -- End Debug
1874:
1875: --Jl_Zz_Ap_Withholding_Pkg.Get_Withholding_Options (l_create_distr,
1876: -- l_create_invoices);
1877: -- Bug 5442868
1878: SELECT nvl(create_awt_dists_type, 'NEVER'),
1879: nvl(create_awt_invoices_type, 'NEVER')

Line 2216: rec_awt_name Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code;

2212: -- Records Declaration
2213: ------------------------
2214: rec_payment_wh Rec_Payment_Withholding;
2215: rec_awt_type jl_zz_ap_awt_types%ROWTYPE;
2216: rec_awt_name Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code;
2217: rec_suppl_awt_type jl_zz_ap_supp_awt_types%ROWTYPE;
2218: rec_suppl_awt_name jl_zz_ap_sup_awt_cd%ROWTYPE;
2219:
2220: ------------------------

Line 2223: tab_payment_wh Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding;

2219:
2220: ------------------------
2221: -- Tables Declaration
2222: ------------------------
2223: tab_payment_wh Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding;
2224: tab_all_wh Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding;
2225: tab_inv_amounts Tab_Amounts;
2226:
2227: BEGIN

Line 2224: tab_all_wh Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding;

2220: ------------------------
2221: -- Tables Declaration
2222: ------------------------
2223: tab_payment_wh Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding;
2224: tab_all_wh Jl_Zz_Ap_Withholding_Pkg.Tab_All_Withholding;
2225: tab_inv_amounts Tab_Amounts;
2226:
2227: BEGIN
2228: -------------------------------

Line 2261: l_base_currency_code := Jl_Zz_Ap_Withholding_Pkg.Get_Base_Currency_Code;

2257:
2258: ---------------------------
2259: -- Gets generic parameters
2260: ---------------------------
2261: l_base_currency_code := Jl_Zz_Ap_Withholding_Pkg.Get_Base_Currency_Code;
2262: l_gl_period_name := Jl_Zz_Ap_Withholding_Pkg.Get_GL_Period_Name
2263: (P_AWT_Date);
2264:
2265: -- Debug Information

Line 2262: l_gl_period_name := Jl_Zz_Ap_Withholding_Pkg.Get_GL_Period_Name

2258: ---------------------------
2259: -- Gets generic parameters
2260: ---------------------------
2261: l_base_currency_code := Jl_Zz_Ap_Withholding_Pkg.Get_Base_Currency_Code;
2262: l_gl_period_name := Jl_Zz_Ap_Withholding_Pkg.Get_GL_Period_Name
2263: (P_AWT_Date);
2264:
2265: -- Debug Information
2266: IF (DEBUG_Var = 'Y') THEN

Line 2438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when l_not_found');

2434: -----------------------------------------------------
2435:
2436: -- Debug Information
2437: IF (DEBUG_Var = 'Y') THEN
2438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when l_not_found');
2439: END IF;
2440: -- End Debug
2441:
2442: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

Line 2442: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

2438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when l_not_found');
2439: END IF;
2440: -- End Debug
2441:
2442: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name
2443: (l_current_vendor_id,
2444: rec_awt_type,
2445: rec_awt_name,
2446: rec_suppl_awt_type,

Line 2457: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when l_not_found');

2453: P_AWT_Success);
2454:
2455: -- Debug Information
2456: IF (DEBUG_Var = 'Y') THEN
2457: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when l_not_found');
2458: END IF;
2459: -- End Debug
2460:
2461: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 2528: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name IN ');

2524: ------------------------------------------------
2525:
2526: -- Debug Information
2527: IF (DEBUG_Var = 'Y') THEN
2528: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name IN ');
2529: END IF;
2530: -- End Debug
2531:
2532: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

Line 2532: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

2528: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name IN ');
2529: END IF;
2530: -- End Debug
2531:
2532: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name
2533: (l_current_vendor_id,
2534: rec_awt_type,
2535: rec_awt_name,
2536: rec_suppl_awt_type,

Line 2547: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name IN ELSIF');

2543: P_AWT_Success);
2544:
2545: -- Debug Information
2546: IF (DEBUG_Var = 'Y') THEN
2547: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name IN ELSIF');
2548: END IF;
2549: -- End Debug
2550:
2551: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 2659: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when <> Tax Name');

2655: ------------------------------------------------
2656:
2657: -- Debug Information
2658: IF (DEBUG_Var = 'Y') THEN
2659: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when <> Tax Name');
2660: END IF;
2661: -- End Debug
2662: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name
2663: (l_current_vendor_id,

Line 2662: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

2658: IF (DEBUG_Var = 'Y') THEN
2659: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when <> Tax Name');
2660: END IF;
2661: -- End Debug
2662: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name
2663: (l_current_vendor_id,
2664: rec_awt_type,
2665: rec_awt_name,
2666: rec_suppl_awt_type,

Line 2677: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when Tax Name Changed');

2673: P_AWT_Success);
2674:
2675: -- Debug Information
2676: IF (DEBUG_Var = 'Y') THEN
2677: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when Tax Name Changed');
2678: END IF;
2679: -- End Debug
2680:
2681: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 2693: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name. Getting Tax Code Info');

2689: ---------------------------------------------
2690:
2691: -- Debug Information
2692: IF (DEBUG_Var = 'Y') THEN
2693: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name. Getting Tax Code Info');
2694: END IF;
2695: -- End Debug
2696:
2697: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name

Line 2697: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name

2693: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name. Getting Tax Code Info');
2694: END IF;
2695: -- End Debug
2696:
2697: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name
2698: (rec_payment_wh.awt_type_code,
2699: rec_payment_wh.tax_id,
2700: rec_payment_wh.vendor_id,
2701: rec_awt_name,

Line 2783: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==>Calling Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');

2779:
2780: -- Debug Information
2781: IF (DEBUG_Var = 'Y') THEN
2782: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Increate l_current_awt = '||to_char(l_current_awt));
2783: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==>Calling Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');
2784: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Invoice_id = '||to_char(rec_payment_wh.invoice_id)||' - '||
2785: 'Tax_id = '||to_char(rec_payment_wh.tax_id)||' - '||
2786: 'Tax Name = '||rec_awt_name.name);
2787: END IF;

Line 2790: Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name

2786: 'Tax Name = '||rec_awt_name.name);
2787: END IF;
2788: -- End Debug
2789:
2790: Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name
2791: (tab_payment_wh,
2792: l_current_awt,
2793: rec_payment_wh.invoice_id,
2794: rec_payment_wh.invoice_distribution_id , -- Lines

Line 2809: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');

2805: rec_payment_wh.payment_num);
2806:
2807: -- Debug Information
2808: IF (DEBUG_Var = 'Y') THEN
2809: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');
2810: END IF;
2811: -- End Debug
2812:
2813: END IF; -- NOT Withholding_Already_Calculated

Line 2922: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,

2918: P_AWT_Type_Code IN Varchar2,
2919: P_Tax_Id IN Number,
2920: P_Calling_Sequence IN Varchar2,
2921: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
2922: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
2923: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
2924: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
2925: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding)
2926: IS

Line 2925: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding)

2921: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
2922: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
2923: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
2924: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
2925: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding)
2926: IS
2927:
2928: l_debug_info Varchar2(300);
2929: l_calling_sequence Varchar2(2000);

Line 2941: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Type

2937:
2938: -----------------------------------------
2939: -- Initializes records and PL/SQL tables
2940: -----------------------------------------
2941: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Type
2942: (P_AWT_Type_Code,
2943: P_Vendor_Id,
2944: P_Rec_AWT_Type,
2945: P_Rec_Suppl_AWT_Type);

Line 2947: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name

2943: P_Vendor_Id,
2944: P_Rec_AWT_Type,
2945: P_Rec_Suppl_AWT_Type);
2946:
2947: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name
2948: (P_AWT_Type_Code,
2949: P_Tax_Id,
2950: P_Vendor_Id,
2951: P_Rec_AWT_Name,

Line 2954: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Table

2950: P_Vendor_Id,
2951: P_Rec_AWT_Name,
2952: P_Rec_Suppl_AWT_Name);
2953:
2954: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Table
2955: (P_Wh_Table);
2956:
2957: EXCEPTION
2958: WHEN others THEN

Line 2994: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

2990: P_Base_Currency_Code IN Varchar2,
2991: P_Check_Id IN Number,
2992: P_Selected_Check_Id IN Number,
2993: P_Calling_Sequence IN Varchar2,
2994: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
2995: P_Total_Wh_Amount IN OUT NOCOPY Number,
2996: P_AWT_Success OUT NOCOPY Varchar2,
2997: P_Last_Updated_By IN Number Default null,
2998: P_Last_Update_Login IN Number Default null,

Line 3060: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');

3056: ------------------------------------------------
3057:
3058: -- Debug Information
3059: IF (DEBUG_Var = 'Y') THEN
3060: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');
3061: END IF;
3062: -- End Debug
3063:
3064: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type

Line 3064: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type

3060: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');
3061: END IF;
3062: -- End Debug
3063:
3064: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type
3065: (P_Rec_AWT_Type,
3066: P_Rec_Suppl_AWT_Type,
3067: P_AWT_Date,
3068: P_Base_Currency_Code,

Line 3073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');

3069: P_Tab_Withhold);
3070:
3071: -- Debug Information
3072: IF (DEBUG_Var = 'Y') THEN
3073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');
3074: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3075: END IF;
3076: -- End Debug
3077:

Line 3115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');

3111: -------------------------------------------------
3112:
3113: -- Debug Information
3114: IF (DEBUG_Var = 'Y') THEN
3115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');
3116: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3117: END IF;
3118: -- End Debug
3119:

Line 3120: Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings (P_Tab_Withhold,

3116: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3117: END IF;
3118: -- End Debug
3119:
3120: Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings (P_Tab_Withhold,
3121: P_Base_Currency_Code);
3122:
3123: -- Debug Information
3124: IF (DEBUG_Var = 'Y') THEN

Line 3125: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');

3121: P_Base_Currency_Code);
3122:
3123: -- Debug Information
3124: IF (DEBUG_Var = 'Y') THEN
3125: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');
3126: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3127: END IF;
3128: -- End Debug
3129:

Line 3136: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table');

3132: -- Insert Temporary Distributions Lines
3133: ----------------------------------------
3134: -- Debug Information
3135: IF (DEBUG_Var = 'Y') THEN
3136: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table');
3137: END IF;
3138: -- End Debug
3139:
3140: Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table

Line 3140: Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table

3136: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table');
3137: END IF;
3138: -- End Debug
3139:
3140: Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table
3141: (P_Tab_Withhold,
3142: P_Vendor_Id,
3143: P_AWT_Date,
3144: P_GL_Period_Name,

Line 3163: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table');

3159: P_Payment_Num);
3160:
3161: -- Debug Information
3162: IF (DEBUG_Var = 'Y') THEN
3163: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table');
3164: END IF;
3165: -- End Debug
3166:
3167: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 3984: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

3980: P_Payment_Num IN Number,
3981: P_Check_Id IN Number,
3982: P_Selected_Check_Id IN Number,
3983: P_Calling_Sequence IN Varchar2,
3984: P_Tab_Withhold IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
3985: P_Last_Updated_By IN Number Default null,
3986: P_Last_Update_Login IN Number Default null,
3987: P_Program_Application_Id IN Number Default null,
3988: P_Program_Id IN Number Default null,

Line 5079: P_Tab_Withhold IN Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

5075: (P_Invoice_Id IN Number,
5076: P_Tax_Name IN Varchar2,
5077: P_Tax_Id IN Number,
5078: P_Taxable_Base_Amount_Basis IN Varchar2,
5079: P_Tab_Withhold IN Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
5080: P_Inv_Payment_Num IN Number,
5081: P_Calling_Sequence IN Varchar2)
5082: RETURN Boolean
5083: IS

Line 5182: (P_Tab_Withhold IN Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

5178: * type (sums up all the prorated amounts). *
5179: * *
5180: **************************************************************************/
5181: FUNCTION Total_Withholding_Amount
5182: (P_Tab_Withhold IN Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,
5183: P_Calling_Sequence IN Varchar2)
5184: RETURN Number
5185: IS
5186: