1 PACKAGE GL_CALCULATE_TAX2_PKG as
2 /* $Header: glujet2s.pls 120.3.12000000.2 2007/07/03 17:08:22 djogg ship $ */
3
4 --
5 -- Package
6 -- GL_CALCULATE_TAX2_PKG
7 -- Purpose
8 -- To implement automatic taxing of journals for the Enter
9 -- Journals form
10 -- History
11 -- 10-DEC-96 D J Ogg Created
12 --
13
14 --
15 -- Procedure
16 -- define_cursor
17 -- Purpose
18 -- Defines the cursor to retrieve data about the lines
19 -- that need tax generation
20 -- History
21 -- 13-DEC-1996 D. J. Ogg Created
22 -- Arguments
23 -- coa_id Current chart of accounts
24 -- calculation_level Calculation level - journal or line
25 -- Example
26 -- gl_calculate_tax2_pkg.define_cursor(1, 'L', errbuf);
27 -- Notes
28 --
29 PROCEDURE define_cursor(coa_id NUMBER,
30 calculation_level VARCHAR2);
31
32 --
33 -- Procedure
34 -- bind_cursor
35 -- Purpose
36 -- Binds the current header id to the cursor to retrieve data about the lines
37 -- that need tax generation
38 -- History
39 -- 13-DEC-1996 D. J. Ogg Created
40 -- Arguments
41 -- header_id Header to be taxed
42 -- Example
43 -- gl_calculate_tax2_pkg.bind_cursor(1);
44 -- Notes
45 --
46 PROCEDURE bind_cursor(header_id NUMBER);
47
48 --
49 -- Procedure
50 -- execute_cursor
51 -- Purpose
52 -- Executes the cursor to retrieve data about the lines
53 -- that need tax generation
54 -- History
55 -- 13-DEC-1996 D. J. Ogg Created
56 -- Arguments
57 -- * NONE *
58 -- Example
59 -- gl_calculate_tax2_pkg.execute_cursor;
60 -- Notes
61 --
62 PROCEDURE execute_cursor;
63
64 --
65 -- Procedure
66 -- fetch_cursor
67 -- Purpose
68 -- Fetches data about the lines that need tax generation
69 -- History
70 -- 13-DEC-1996 D. J. Ogg Created
71 -- Arguments
72 -- coa_id Current chart of accounts
73 -- lgr_id Current ledger
74 -- org_id Current operating unit
75 -- calculation_level Calculation level - journal or line
76 -- journal_effective_date Effective date of journal being taxed
77 -- no_more_records Indicates all records have been fetched
78 -- last_in_group Indicates that this is the last record
79 -- in the group
80 -- bad_acct Indicates that the tax account is bad
81 -- bad_csegs Gives the bad account
82 -- line_num Line number of the current line
83 -- eff_date Effective date of the current line
84 -- ent_dr Entered debits of the current line
85 -- ent_cr Entered credits of the current line
86 -- rounding_rule Rounding rule of the current line
87 -- description Description of the current line
88 -- incl_tax Tax included flag for the current line
89 -- tax_code Tax code for the current line
90 -- tax_rate Tax rate for the current line
91 -- tax_ccid Tax ccid for the current line
92 -- tax_group Tax group for the current line
93 -- Example
94 -- gl_calculate_tax2_pkg.define_cursor(1, 'L', errbuf);
95 -- Notes
96 --
97 PROCEDURE fetch_cursor(coa_id NUMBER,
98 lgr_id NUMBER,
99 org_id NUMBER,
100 calculation_level VARCHAR2,
101 journal_effective_date DATE,
102 resp_appl_id NUMBER,
103 resp_id NUMBER,
104 user_id NUMBER,
105 no_more_records IN OUT NOCOPY BOOLEAN,
106 last_in_group IN OUT NOCOPY BOOLEAN,
107 bad_acct IN OUT NOCOPY BOOLEAN,
108 bad_csegs IN OUT NOCOPY VARCHAR2,
109 line_num IN OUT NOCOPY NUMBER,
110 eff_date IN OUT NOCOPY DATE,
111 ent_dr IN OUT NOCOPY NUMBER,
112 ent_cr IN OUT NOCOPY NUMBER,
113 rounding_rule IN OUT NOCOPY VARCHAR2,
114 description IN OUT NOCOPY VARCHAR2,
115 incl_tax IN OUT NOCOPY VARCHAR2,
116 tax_code IN OUT NOCOPY VARCHAR2,
117 tax_rate IN OUT NOCOPY NUMBER,
118 tax_ccid IN OUT NOCOPY NUMBER,
119 tax_group IN OUT NOCOPY NUMBER);
120
121 --
122 -- Procedure
123 -- closes_cursor
124 -- Purpose
125 -- Closes the cursor to retrieve data about the lines
126 -- that need tax generation
127 -- History
128 -- 13-DEC-1996 D. J. Ogg Created
129 -- Arguments
130 -- * NONE *
131 -- Example
132 -- gl_calculate_tax2_pkg.close_cursor;
133 -- Notes
134 --
135 PROCEDURE close_cursor;
136
137 END GL_CALCULATE_TAX2_PKG;