APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on AP_INVOICES_ALL

Line 41: P_Invoice_Id IN ap_invoices_all.invoice_id%TYPE,

37: -- R12 KI
38: --
39:
40: PROCEDURE Insert_AWT_Default(
41: P_Invoice_Id IN ap_invoices_all.invoice_id%TYPE,
42: P_Inv_Dist_Id IN ap_invoice_distributions_all.invoice_distribution_id%TYPE,
43: P_Supp_Awt_Code_Id IN jl_zz_ap_sup_awt_cd.supp_awt_code_id%TYPE,
44: p_calling_sequence IN VARCHAR2,
45: P_Org_Id IN jl_zz_ap_sup_awt_cd.org_id%TYPE) IS

Line 213: , P_Invoice_Id ap_invoices_all.invoice_id%TYPE

209: If tax_payerid is not null find the vendor_id for this tax_payerid Else
210: return the vendor id from the invoice.
211: ------------------------------------------------------------------------------------------------*/
212: FUNCTION Get_Vendor_Id ( P_Tax_Payer_Id ap_invoice_distributions_all.global_attribute2%TYPE
213: , P_Invoice_Id ap_invoices_all.invoice_id%TYPE
214: )
215: return number is
216: --------------------------------------------------------------------
217: -- Get the information from po_vendors when tax_payerid is not null

Line 225: -- Get the information from ap_invoices_all when tax_payerid is null.

221: FROM po_vendors
222: WHERE segment1 = P_Tax_Payer_Id; -- R12 KI : Need to uptake PTP?
223:
224: --------------------------------------------------------------------
225: -- Get the information from ap_invoices_all when tax_payerid is null.
226: --------------------------------------------------------------------
227: CURSOR Invoice_Vendor IS
228: SELECT Vendor_Id
229: FROM ap_invoices

Line 284: P_Invoice_Id ap_invoices_all.invoice_id%TYPE)

280: The function receive the Supplier Withholding Type as parameter.
281: ------------------------------------------------------------------------------------------------*/
282:
283: FUNCTION Company_Agent (P_Awt_Type_Code jl_zz_ap_awt_types.awt_type_code%TYPE,
284: P_Invoice_Id ap_invoices_all.invoice_id%TYPE)
285: return boolean is
286: /* bug 16010780
287: Cursor Company_Awt_Types (PC_Legal_Entity_ID xle_entity_profiles.legal_entity_id%TYPE)
288: IS

Line 852: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE

848: -- R12 KI
849: --
850:
851: PROCEDURE Supp_Wh_Def
852: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
853: , P_Inv_Line_Num ap_invoice_lines_all.line_number%TYPE
854: , P_Inv_Dist_Id ap_invoice_distributions_all.invoice_distribution_id%TYPE
855: , P_Calling_Module VARCHAR2
856: , P_Parent_Dist_ID IN Number Default null

Line 1363: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE

1359: Supp_Wh_ReDef receive as parameters the P_Invoice_Id and P_Vendor_ID
1360: Bug 3609925
1361: ------------------------------------------------------------------------------------------------*/
1362: PROCEDURE Supp_Wh_ReDefault
1363: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
1364: , P_Vendor_ID po_vendors.vendor_id%TYPE
1365: ) IS
1366:
1367: CURSOR Invoice_Distrib IS