DBA Data[Home] [Help]

APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on JL_ZZ_AP_AWT_TYPES

Line 127: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,

123: (P_Vendor_Id IN Number,
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);

Line 145: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,

141: * *
142: **************************************************************************/
143: PROCEDURE Process_Withholdings
144: (P_Vendor_Id IN Number,
145: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
146: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
147: P_AWT_Date IN Date,
148: P_GL_Period_Name IN Varchar2,
149: P_Base_Currency_Code IN Varchar2,

Line 240: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,

236: * *
237: **************************************************************************/
238: PROCEDURE Update_Credit_Letter
239: (P_Vendor_Id IN Number,
240: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
241: P_AWT_Date IN Date,
242: P_Payment_Num IN Number,
243: P_Check_Id IN Number,
244: P_Selected_Check_Id IN Number,

Line 2082: jl_zz_ap_awt_types jlty

2078: ap_invoice_distributions apid,
2079: ap_invoice_payments apip,
2080: jl_zz_ap_supp_awt_types jlst,
2081: jl_zz_ap_sup_awt_cd jlsc,
2082: jl_zz_ap_awt_types jlty
2083: WHERE
2084: apid.invoice_id = jlwh.invoice_id
2085: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256
2086: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id -- Lines

Line 2126: jl_zz_ap_awt_types jlty

2122: ap_invoice_distributions apid,
2123: iby_hook_docs_in_pmt_t docs,
2124: jl_zz_ap_supp_awt_types jlst,
2125: jl_zz_ap_sup_awt_cd jlsc,
2126: jl_zz_ap_awt_types jlty
2127: WHERE docs.payment_id = P_Check_Id
2128: AND apid.invoice_id = jlwh.invoice_id
2129: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256
2130: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id -- Lines

Line 2184: jl_zz_ap_awt_types jlty

2180: -- ap_selected_invoices apsi,
2181: iby_hook_docs_in_pmt_t docs,
2182: jl_zz_ap_supp_awt_types jlst,
2183: jl_zz_ap_sup_awt_cd jlsc,
2184: jl_zz_ap_awt_types jlty
2185: WHERE docs.payment_id = P_Selected_Check_Id
2186: AND apid.invoice_id = jlwh.invoice_id
2187: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256
2188: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id -- Lines

Line 2215: rec_awt_type jl_zz_ap_awt_types%ROWTYPE;

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

Line 2921: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,

2917: (P_Vendor_Id IN Number,
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)

Line 2986: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,

2982: * *
2983: **************************************************************************/
2984: PROCEDURE Process_Withholdings
2985: (P_Vendor_Id IN Number,
2986: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
2987: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
2988: P_AWT_Date IN Date,
2989: P_GL_Period_Name IN Varchar2,
2990: P_Base_Currency_Code IN Varchar2,

Line 3978: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,

3974: * *
3975: **************************************************************************/
3976: PROCEDURE Update_Credit_Letter
3977: (P_Vendor_Id IN Number,
3978: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
3979: P_AWT_Date IN Date,
3980: P_Payment_Num IN Number,
3981: P_Check_Id IN Number,
3982: P_Selected_Check_Id IN Number,