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 146: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,

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

Line 241: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,

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

Line 2161: jl_zz_ap_awt_types jlty

2157: ap_invoice_distributions apid,
2158: ap_invoice_payments apip,
2159: jl_zz_ap_supp_awt_types jlst,
2160: jl_zz_ap_sup_awt_cd jlsc,
2161: jl_zz_ap_awt_types jlty
2162: WHERE
2163: apid.invoice_id = jlwh.invoice_id
2164: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256
2165: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id -- Lines

Line 2208: jl_zz_ap_awt_types jlty

2204: ap_invoice_distributions apid,
2205: iby_hook_docs_in_pmt_t docs,
2206: jl_zz_ap_supp_awt_types jlst,
2207: jl_zz_ap_sup_awt_cd jlsc,
2208: jl_zz_ap_awt_types jlty
2209: WHERE docs.payment_id = P_Check_Id
2210: AND apid.invoice_id = jlwh.invoice_id
2211: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256
2212: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id -- Lines

Line 2270: jl_zz_ap_awt_types jlty

2266: -- Payment Exchange Rate ER 8648739 End 3
2267: iby_hook_docs_in_pmt_t docs,
2268: jl_zz_ap_supp_awt_types jlst,
2269: jl_zz_ap_sup_awt_cd jlsc,
2270: jl_zz_ap_awt_types jlty
2271: WHERE docs.payment_id = P_Selected_Check_Id
2272: AND apid.invoice_id = jlwh.invoice_id
2273: -- AND apid.distribution_line_number = jlwh.distribution_line_number - Lines 4382256
2274: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id -- Lines

Line 2306: rec_awt_type jl_zz_ap_awt_types%ROWTYPE;

2302: ------------------------
2303: -- Records Declaration
2304: ------------------------
2305: rec_payment_wh Rec_Payment_Withholding;
2306: rec_awt_type jl_zz_ap_awt_types%ROWTYPE;
2307: rec_awt_name Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code;
2308: rec_suppl_awt_type jl_zz_ap_supp_awt_types%ROWTYPE;
2309: rec_suppl_awt_name jl_zz_ap_sup_awt_cd%ROWTYPE;
2310:

Line 3064: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,

3060: (P_Vendor_Id IN Number,
3061: P_AWT_Type_Code IN Varchar2,
3062: P_Tax_Id IN Number,
3063: P_Calling_Sequence IN Varchar2,
3064: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
3065: P_Rec_AWT_Name OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Rec_AWT_Code,
3066: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE,
3067: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,
3068: P_Wh_Table IN OUT NOCOPY Jl_Zz_Ap_Withholding_Pkg.Tab_Withholding,

Line 3146: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,

3142: * *
3143: **************************************************************************/
3144: PROCEDURE Process_Withholdings
3145: (P_Vendor_Id IN Number,
3146: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
3147: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
3148: P_AWT_Date IN Date,
3149: P_GL_Period_Name IN Varchar2,
3150: P_Base_Currency_Code IN Varchar2,

Line 4181: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,

4177: * *
4178: **************************************************************************/
4179: PROCEDURE Update_Credit_Letter
4180: (P_Vendor_Id IN Number,
4181: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
4182: P_AWT_Date IN Date,
4183: P_Payment_Num IN Number,
4184: P_Check_Id IN Number,
4185: P_Selected_Check_Id IN Number,