1 PACKAGE JG_ZZ_COMMON_PKG AUTHID CURRENT_USER
2 -- $Header: jgzzvatcmns.pls 120.6.12010000.3 2009/01/09 13:26:35 vkejriwa ship $
3 --*************************************************************************************
4 -- | Copyright (c) 1996 Oracle Corporation Redwood Shores, California, USA|
5 -- | All rights reserved. |
6 --*************************************************************************************
7 --
8 --
9 -- PROGRAM NAME
10 -- JGZZ_COMMON_PKS.pls
11 --
12 -- DESCRIPTION
13 -- Script to create package specification for the common pack
14 --
15 -- HISTORY
16 -- =======
17 --
18 -- VERSION DATE AUTHOR(S) DESCRIPTION
19 -- ------- ----------- --------------- ---------------------------------------------------------------
20 -- DRAFT 1A 31-Jan-2006 Manish Upadhyay Initial draft version
21 -- DRAFT 1B 21-Feb-2006 Manish Upadhyay Modified as per the Review comments
22 -- 120.2 26-APR-2006 Brathod Bug: 5188902, Changed X_taxpayer_id
23 -- from Number to Varchar2
24 -- 120.3 30-May-2006 Rukmani Basker Added a procedure for fetching
25 -- configurable setup details.
26 -- 120.4 27-Jun-2006 Suresh.Pasupunuri Added X_ENTITY_IDENTIFIER new parameter
27 -- to get_entities_configuration_dtl function.
28 -- 120.7 09-Jan-2009 Varun Kejriwal Added a function get_amt_tot which takes invoice_id and ledger_id as parameters
29 -- and based on the type of the reporting entity ( LE/ Primary Ledger/ Secondary Ledger ),
30 -- it returns the appropriate invoice_amount.
31 ----------------------------------------------------------------------------------------------------------------
32 AS
33 PROCEDURE funct_curr_legal(x_func_curr_code OUT NOCOPY VARCHAR2
34 ,x_rep_entity_name OUT NOCOPY VARCHAR2
35 ,x_legal_entity_id OUT NOCOPY NUMBER
36 ,x_taxpayer_id OUT NOCOPY VARCHAR2
37 ,pn_vat_rep_entity_id IN NUMBER
38 ,pv_period_name IN VARCHAR2 DEFAULT NULL
39 ,pn_period_year IN NUMBER DEFAULT NULL
40 );
41
42 PROCEDURE tax_registration(x_tax_registration OUT NOCOPY VARCHAR2
43 ,x_period_start_date OUT NOCOPY DATE
44 ,x_period_end_date OUT NOCOPY DATE
45 ,x_status OUT NOCOPY VARCHAR2
46 ,pn_vat_rep_entity_id IN NUMBER
47 ,pv_period_name IN VARCHAR2 DEFAULT NULL
48 ,pn_period_year IN NUMBER DEFAULT NULL
49 ,pv_source IN VARCHAR2
50 );
51
52 PROCEDURE company_detail(x_company_name OUT NOCOPY VARCHAR2
53 ,x_registration_number OUT NOCOPY VARCHAR2
54 ,x_country OUT NOCOPY VARCHAR2
55 ,x_address1 OUT NOCOPY VARCHAR2
56 ,x_address2 OUT NOCOPY VARCHAR2
57 ,x_address3 OUT NOCOPY VARCHAR2
58 ,x_address4 OUT NOCOPY VARCHAR2
59 ,x_city OUT NOCOPY VARCHAR2
60 ,x_postal_code OUT NOCOPY VARCHAR2
61 ,x_contact OUT NOCOPY VARCHAR2
62 ,x_phone_number OUT NOCOPY VARCHAR2
63 ,x_province OUT NOCOPY VARCHAR2
64 ,x_comm_number OUT NOCOPY VARCHAR2
65 ,x_vat_reg_num OUT NOCOPY VARCHAR2
66 ,pn_legal_entity_id IN NUMBER
67 ,p_vat_reporting_entity_id IN NUMBER
68 );
69
70
71 PROCEDURE get_entities_configuration_dtl (
72 x_calendar_name OUT NOCOPY VARCHAR2
73 ,x_enable_register_flag OUT NOCOPY VARCHAR2
74 ,x_enable_report_seq_flag OUT NOCOPY VARCHAR2
75 ,x_enable_alloc_flag OUT NOCOPY VARCHAR2
76 ,x_enable_annual_alloc_flag OUT NOCOPY VARCHAR2
77 ,x_threshold_amt OUT NOCOPY VARCHAR2
78 ,x_entity_identifier OUT NOCOPY VARCHAR2
79 ,p_vat_rep_entity_id IN NUMBER
80 );
81 FUNCTION get_legal_entity_country_code (p_legal_entity_id IN NUMBER) RETURN VARCHAR2;
82
83 FUNCTION get_amt_tot (pn_invoice_id IN NUMBER, pn_ledger_id IN NUMBER, pn_precision IN NUMBER) RETURN NUMBER ;
84
85 END JG_ZZ_COMMON_PKG;