1 PACKAGE ARP_ETAX_RECURR_UTIL AUTHID CURRENT_USER AS
2 /* $Header: AREBTICS.pls 120.0.12010000.2 2008/11/14 09:10:46 amitshuk ship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7 -- temp_variable1 VARCHAR2(10);
8
9 /*=======================================================================+
10 | Declare PUBLIC Exceptions
11 +=======================================================================*/
12 -- temp_exception EXCEPTION;
13
14 /*========================================================================
15 | PUBLIC PROCEDURE populate_ebt_gt
16 |
17 | DESCRIPTION
18 | This procedure populates the ebt GT tables that are used by
19 | autoinvoice for tax calculations. The procedure will be called
20 | twice - once for INV and a second time for CM (regular) data.
21 |
22 | PSEUDO CODE/LOGIC
23 |
24 | PARAMETERS
25 | p_request_id IN Request_id of import job
26 | p_phase IN Indicates 'INV' or 'CM' phase
27 |
28 | KNOWN ISSUES
29 |
30 | NOTES
31 |
32 | MODIFICATION HISTORY
33 | Date Author Description of Changes
34 | 28-FEB-2005 MRAYMOND Created
35 |
36 *=======================================================================*/
37 PROCEDURE calculate_tax(
38 p_request_id IN NUMBER,
39 p_error_count IN OUT NOCOPY NUMBER,
40 p_return_status OUT NOCOPY NUMBER);
41
42
43 PROCEDURE insert_tax_lines(p_original_line_id IN NUMBER,
44 p_new_customer_trx_id IN NUMBER,
45 p_new_line_id IN NUMBER,
46 p_request_id IN NUMBER);
47
48
49 PROCEDURE insert_header(p_customer_trx_id IN NUMBER);
50
51 PROCEDURE insert_line(p_orig_line_id IN NUMBER,
52 p_new_line_id IN NUMBER);
53
54 END ARP_ETAX_RECURR_UTIL;
55