PACKAGE: APPS.JL_ZZ_AP_AWT_DEFAULT_PKG

Source

1 PACKAGE JL_ZZ_AP_AWT_DEFAULT_PKG AS
2 /* $Header: jlzzpwds.pls 120.15.12010000.1 2008/07/31 04:24:58 appldev ship $ */
3 
4 --
5 -- R12 KI
6 --
7 PROCEDURE Insert_AWT_Default(
8               P_Invoice_Id			IN	ap_invoices_all.invoice_id%TYPE,
9               P_Inv_Dist_Id  		IN	ap_invoice_distributions_all.invoice_distribution_id%TYPE,
10               P_Supp_Awt_Code_Id		IN	jl_zz_ap_sup_awt_cd.supp_awt_code_id%TYPE,
11               p_calling_sequence   		IN    	VARCHAR2,
12               P_Org_Id           		IN	jl_zz_ap_sup_awt_cd.org_id%TYPE);
13 
14 FUNCTION Ver_Territorial_Flag
15             (P_Province_Code jl_ar_ap_provinces.province_code%TYPE
16             ) return boolean ;
17 
18 FUNCTION Get_Vendor_Id
19             (P_Tax_Payer_Id ap_invoice_distributions_all.global_attribute2%TYPE
20             ,P_Invoice_Id ap_invoices_all.invoice_id%TYPE
21             ) return number;
22 
23 FUNCTION Company_Agent
24             (P_Awt_Type_Code jl_zz_ap_awt_types.awt_type_code%TYPE,
25              P_Invoice_Id ap_invoices_all.invoice_id%TYPE)
26             return boolean ;
27 
28 FUNCTION Validate_Line_Type
29             (v_dist_type  varchar2
30             ,v_tax_id     ap_tax_codes_all.tax_id%type)
31              return boolean;
32 
33 PROCEDURE  Province_Zone_City
34               (p_ship_to_location_id in hr_locations_all.location_id%TYPE
35               ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
36               ,v_hr_province out NOCOPY  hr_locations_all.region_2%TYPE
37               ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE);
38 
39 --
40 -- R12 KI
41 --
42 PROCEDURE Del_Wh_Def
43              (p_inv_dist_id  ap_invoice_distributions_all.invoice_distribution_id%TYPE
44              ) ;
45 
46 --
47 -- R12 KI
48 --
49 PROCEDURE Supp_Wh_Def_Line
50             (p_invoice_id   NUMBER,
51              p_inv_dist_id  NUMBER,
52              p_tax_payer_id NUMBER,
53              p_ship_to_loc  VARCHAR2,
54              p_line_type    VARCHAR2,
55              p_vendor_id    NUMBER
56              ) ;
57 --
58 -- R12 KI
59 --
60 PROCEDURE Supp_Wh_Def
61              ( P_Invoice_Id   ap_invoices_all.invoice_id%TYPE
62              , P_Inv_Line_Num ap_invoice_lines_all.line_number%TYPE
63              , P_Inv_Dist_Id  ap_invoice_distributions_all.invoice_distribution_id%TYPE
64              , P_Calling_Module VARCHAR2
65              , P_Parent_Dist_ID IN Number Default null
66              ) ;
67 --
68 -- R12 KI
69 --
70 PROCEDURE Carry_Withholdings_Prepay
71                     (P_prepay_dist_id     Number
72                     ,P_Invoice_Id         Number
73                     ,P_inv_dist_id        Number
74                     ,P_User_Id            Number
75                     ,P_last_update_login  Number
76                     ,P_Calling_Sequence   Varchar2);
77 
78 
79 /*----------------------------------------------------------------------------------------------
80    Supp_Wh_ReDef receive as parameters the P_Invoice_Id and P_Vendor_ID
81    Bug 3609925
82 ------------------------------------------------------------------------------------------------*/
83 
84 PROCEDURE Supp_Wh_ReDefault
85              ( P_Invoice_Id  ap_invoices_all.invoice_id%TYPE
86              , P_Vendor_ID   po_vendors.vendor_id%TYPE
87              );
88 
89 END JL_ZZ_AP_AWT_DEFAULT_PKG;