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:
287: Cursor Company_Awt_Types (PC_Legal_Entity_ID xle_entity_profiles.legal_entity_id%TYPE)
288: IS

Line 794: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE

790: -- R12 KI
791: --
792:
793: PROCEDURE Supp_Wh_Def
794: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
795: , P_Inv_Line_Num ap_invoice_lines_all.line_number%TYPE
796: , P_Inv_Dist_Id ap_invoice_distributions_all.invoice_distribution_id%TYPE
797: , P_Calling_Module VARCHAR2
798: , P_Parent_Dist_ID IN Number Default null

Line 1299: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE

1295: Supp_Wh_ReDef receive as parameters the P_Invoice_Id and P_Vendor_ID
1296: Bug 3609925
1297: ------------------------------------------------------------------------------------------------*/
1298: PROCEDURE Supp_Wh_ReDefault
1299: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
1300: , P_Vendor_ID po_vendors.vendor_id%TYPE
1301: ) IS
1302:
1303: CURSOR Invoice_Distrib IS