1 PACKAGE ZX_TCM_EXT_SERVICES_PUB AS
2 /* $Header: zxpservs.pls 120.9 2005/12/15 19:34:10 hsi ship $ */
3
4 Procedure GET_DEFAULT_STATUS_RATES(
5 p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
6 p_tax IN ZX_TAXES_B.TAX%TYPE,
7 p_date IN DATE,
8 p_tax_status_code OUT NOCOPY ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
9 p_tax_rate_code OUT NOCOPY ZX_RATES_B.TAX_RATE_CODE%TYPE,
10 P_RETURN_STATUS OUT NOCOPY VARCHAR2);
11
12 Procedure GET_DEFAULT_CLASSIF_CODE(
13 p_fiscal_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
14 p_country_code IN FND_TERRITORIES.TERRITORY_CODE%TYPE,
15 p_application_id IN ZX_EVNT_CLS_MAPPINGS.APPLICATION_ID%TYPE,
16 p_entity_code IN ZX_EVNT_CLS_MAPPINGS.ENTITY_CODE%TYPE,
17 p_event_class_code IN ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_CODE%TYPE,
18 p_source_event_class_code IN ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_CODE%TYPE,
19 p_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
20 p_org_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,
21 p_default_code OUT NOCOPY VARCHAR2,
22 P_RETURN_STATUS OUT NOCOPY VARCHAR2);
23
24
25 Procedure GET_DEFAULT_PRODUCT_CLASSIF(
26 p_country_code IN FND_TERRITORIES.TERRITORY_CODE%TYPE,
27 p_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
28 p_org_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,
29 p_default_code OUT NOCOPY VARCHAR2,
30 P_RETURN_STATUS OUT NOCOPY VARCHAR2);
31
32 FUNCTION ZX_GET_PROD_CATEG (p_product_category IN OUT NOCOPY VARCHAR2,
33 p_product_fc IN OUT NOCOPY VARCHAR2,
34 p_country_code IN VARCHAR2) RETURN VARCHAR2;
35
36 FUNCTION IS_INV_INSTALLED RETURN BOOLEAN;
37
38 /**************************************************************************
39 * *
40 * Name : Get_Default_Tax_Reg *
41 * Purpose : Returns the Default Registration Number for a Given Party *
42 * Logic : In case there is tax registration mark as default *
43 * the function will return the registration number *
44 * associated to that record. Second case the function will *
45 * look for the registration row with null regime *
46 * (migrated records) *
47 * Parameters : P_Party_ID ------------ P_Party_Type *
48 * Party_Id CUSTOMER *
49 * Party_Site_Id CUSTOMER_SITE *
50 * Vendor_id SUPPLIER *
51 * Vendor_Site_ID SUPPLIER_SITE *
52 * Party_ID LEGAL_ESTABLISHMENT *
53 * *
54 * *
55 **************************************************************************/
56 FUNCTION Get_Default_Tax_Reg
57 (P_Party_ID IN zx_party_tax_profile.party_id%Type,
58 P_Party_Type IN zx_party_tax_profile.party_type_code%Type,
59 P_Effective_Date IN zx_registrations.effective_from%Type,
60 x_return_status OUT NOCOPY VARCHAR2
61 )
62 RETURN Varchar2;
63
64 /* ======================================================================*
65 | API TO GET LE FOR AP IMPORT TRANSACTIONS |
66 * ======================================================================*/
67 FUNCTION get_le_from_tax_registration
68 (
69 x_return_status OUT NOCOPY VARCHAR2,
70 p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,
71 p_effective_date IN ZX_REGISTRATIONS.effective_from%type,
72 p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type
73 ) RETURN Number;
74 END ZX_TCM_EXT_SERVICES_PUB;
75