1 PACKAGE gl_tax_option_accounts_pkg AS
2 /* $Header: glisttas.pls 120.5 2005/05/05 01:27:42 kvora ship $ */
3 --
4 -- Package
5 -- gl_tax_option_accounts_pkg
6 -- Purpose
7 -- To implement various data checking needed for the
8 -- gl_tax_option_accounts table
9 -- History
10 -- 05-DEC-96 W Wong Created
11 --
12
13 --
14 -- Procedure
15 -- check_tax_type
16 --
17 -- Purpose
18 -- Check the following constraints for tax type of a given account:
19 -- 1. Only one input line can be defined for each account.
20 -- 2. Only one output line can be defined for each account.
21 -- 3. If an account has a non-taxable line, then input and output
22 -- lines cannot be defined for that account.
23 --
24 -- History
25 -- 22-Nov-96 W. Wong Created
26 --
27 -- Arguments
28 -- x_ledger_id ID of the current ledger
29 -- x_org_id ID of the current organization
30 -- x_account_segment_value Account segment to be checked
31 -- x_tax_code Tax code of current account
32 -- x_rowid Row ID
33 --
34 PROCEDURE check_tax_type(
35 x_ledger_id NUMBER,
36 x_org_id NUMBER,
37 x_account_segment_value VARCHAR2,
38 x_tax_type_code VARCHAR2,
39 x_rowid VARCHAR2);
40
41 --
42 -- Procedure
43 -- select_columns
44 --
45 -- Purpose
46 -- Gets various information about the tax options associated
47 -- with the given account, ledger id, and organization
48 --
49 -- History
50 -- 05-DEC-96 D J Ogg Created
51 --
52 -- Arguments
53 -- x_ledger_id ID of the current ledger
54 -- x_org_id ID of the current organization
55 -- x_account_segment_value Account segment to be checked
56 -- x_tax_type_code Default Tax type
57 -- x_tax_code Default Tax code
58 -- x_allow_override Allow Tax code override
59 -- x_amount_includes_tax Default amount includes tax
60 --
61 PROCEDURE select_columns(
62 x_ledger_id NUMBER,
63 x_org_id NUMBER,
64 x_account_value VARCHAR2,
65 x_tax_type_code IN OUT NOCOPY VARCHAR2,
66 x_tax_code IN OUT NOCOPY VARCHAR2,
67 x_allow_override IN OUT NOCOPY VARCHAR2,
68 x_amount_includes_tax IN OUT NOCOPY VARCHAR2);
69
70 --
71 -- Procedure
72 -- get_acct_description
73 --
74 -- Purpose
75 -- Gets the description for an account segment value
76 --
77 -- History
78 -- 13-Jan-97 D J Ogg Created
79 --
80 -- Arguments
81 -- x_coa_id ID of the current chart of accounts
82 -- x_account_val Account Segment value
83 FUNCTION get_acct_description(
84 x_coa_id NUMBER,
85 x_account_val VARCHAR2
86 ) RETURN VARCHAR2;
87
88 END gl_tax_option_accounts_pkg;