1 PACKAGE IGC_ETAX_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGCETXUS.pls 120.2 2008/02/11 06:06:26 dvjoshi noship $ */
3
4 -- Global Variables
5 IGC_APPLICATION_ID CONSTANT NUMBER := 8407;
6 IGC_ENTITY_CODE CONSTANT VARCHAR2(64) := 'IGC_CC_HEADERS';
7 IGC_EVENT_CLASS_CODE CONSTANT VARCHAR2(64) := 'PURCHASE_TRANSACTION_TAX_QUOTE';
8 IGC_EVENT_TYPE_CODE CONSTANT VARCHAR2(32) := 'CREATE';
9 IGC_TAX_EVENT_TYPE_CODE CONSTANT VARCHAR2(32) := 'CREATE';
10 IGC_TRX_LEVEL_TYPE CONSTANT VARCHAR2(32) := 'LINE';
11 IGC_LINE_LEVEL_ACTION CONSTANT VARCHAR2(32) := 'CREATE';
12 IGC_LINE_CLASS CONSTANT VARCHAR2(32) := 'INVOICE';
13 IGC_TAX_QUOTE_FLAG CONSTANT VARCHAR2(1) := 'Y';
14 G_BATCH_LIMIT CONSTANT NUMBER := 1000;
15
16 /*=============================================================================
17 | PROCEDURE - set_tax_security_context()
18 |
19 | DESCRIPTION
20 | This procedure will return the tax effective date. The effective date
21 | is used in the list of values for tax drivers and tax related attributes.
22 |
23 | PARAMETERS
24 | p_org_id - Operating unit identifier
25 | p_legal_entity_id - Legal entity identifier.
26 | p_transaction_date - Transaction Date.
27 | p_related_doc_date - Date of the related document.
28 | p_adjusted_doc_date - Date of the adjusted document.
29 |
30 *============================================================================*/
31 PROCEDURE set_tax_security_context
32 (p_org_id IN NUMBER,
33 p_legal_entity_id IN NUMBER,
34 p_transaction_date IN DATE,
35 p_related_doc_date IN DATE,
36 p_adjusted_doc_date IN DATE,
37 p_effective_date OUT NOCOPY DATE,
38 p_return_status OUT NOCOPY VARCHAR2,
39 p_msg_count OUT NOCOPY NUMBER,
40 p_msg_data OUT NOCOPY VARCHAR2);
41
42 /*=============================================================================
43 | FUNCTION - Populate_Headers_GT()
44 |
45 | DESCRIPTION
46 | This function will get additional information required to populate the
47 | ZX_TRANSACTION_HEADERS_GT
48 | This function returns TRUE if the insert to the temp table goes
49 | through successfully. Otherwise, FALSE.
50 |
51 | PARAMETERS
52 | P_CC_Header_Rec - record with cc header information
53 | P_Calling_Mode - calling mode. it is used to
54 | P_Event_Class_Code - Event class code
55 | P_Event_Type_Code - Event type Code
56 | P_error_code - Error code to be returned
57 |
58 *============================================================================*/
59 FUNCTION Populate_Headers_GT(
60 P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,
61 P_Calling_Mode IN VARCHAR2,
62 --P_Event_Class_Code IN VARCHAR2,
63 --P_Event_Type_Code IN VARCHAR2,
64 P_Legal_Entity_Id IN NUMBER,
65 P_Error_Code OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
66
67 /*=============================================================================
68 | FUNCTION - Populate_Lines_GT()
69 |
70 | DESCRIPTION
71 | This function will get additional information required to populate the
72 | ZX_TRANSACTION_LINES_GT
73 | This function returns TRUE if the population of the temp table goes
74 | through successfully. Otherwise, FALSE.
75 |
76 |
77 *============================================================================*/
78 /* Bug 6719456 - Added new parameter P_Line_Id */
79 FUNCTION Populate_Lines_GT(
80 P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,
81 P_Line_Id IN igc_cc_acct_lines.cc_acct_line_id%type,
82 P_Calling_Mode IN VARCHAR2,
83 --P_Event_Class_Code IN VARCHAR2,
84 --P_Line_Number IN NUMBER DEFAULT NULL,
85 P_Error_Code OUT NOCOPY VARCHAR2,
86 P_Calling_Sequence IN VARCHAR2,
87 P_Amount IN NUMBER) RETURN VARCHAR2;
88
89
90 /*=============================================================================
91 | FUNCTION - Calculate_Tax()
92 |
93 | DESCRIPTION
94 | This function will call procedure to populate the
95 | ZX_TRANSACTION_HEADERS_GT,Populate_Lines_GT than E-Btax api calculate_tax
96 | This function returns TRUE call goes
97 | through successfully. Otherwise, FALSE.
98 |
99 | PARAMETERS
100 | P_CC_Header_Rec - record with cc header information
101 | P_Calling_Mode - calling mode. it is used to
102 | P_error_code - Error code to be returned
103 | P_Amt_Type - Amount type on which tax need to be calculated.
104 *============================================================================*/
105 Procedure Calculate_Tax(
106 P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,
107 P_Calling_Mode IN VARCHAR2,
108 P_Error_Code OUT NOCOPY VARCHAR2,
109 P_Amount IN NUMBER,
110 P_Tax_Amount OUT NOCOPY NUMBER,
111 P_Line_Id IN igc_cc_acct_lines.cc_acct_line_id%type,
112 P_Return_Status OUT NOCOPY VARCHAR2);
113 /*=============================================================================
114 */
115 PROCEDURE get_cc_def_tax_classification(
116 p_cc_header_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
117 p_cc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
118 p_cc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
119 p_vendor_id IN po_vendors.vendor_id%TYPE,
120 p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
121 p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
122 p_concatenated_segments IN varchar2,
123 p_templ_tax_classification_cd IN varchar2,
124 p_tax_classification_code IN OUT NOCOPY varchar2,
125 p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
126 p_tax_user_override_flag IN VARCHAR2,
127 p_user_tax_name IN VARCHAR2,
128 p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
129 p_calling_sequence IN VARCHAR2,
130 p_internal_organization_id IN NUMBER);
131
132 END IGC_ETAX_UTIL_PKG;