[Home] [Help]
PACKAGE: APPS.XLA_XLAIQACL_UTILS_PKG
Source
1 PACKAGE xla_xlaiqacl_utils_pkg AS
2 /* $Header: xlafuacl.pkh 120.1 2004/02/13 22:51:40 weshen noship $ */
3
4 -- ************************************************************************
5 -- PUBLIC VARIABLES/TYPES
6 -- ************************************************************************
7
8 --
9 -- Accounting Methods record type
10 --
11 TYPE acct_method_info_rec IS RECORD (
12 accounting_method VARCHAR2(30),
13 sob_id NUMBER(15),
14 sob_curr VARCHAR2(15),
15 sob_type VARCHAR2(1),
16 sob_name VARCHAR2(30),
17 sob_short_name VARCHAR2(20),
18 accounting_method_name VARCHAR2(80));
19
20 TYPE acct_method_info_tbl IS TABLE OF acct_method_info_rec
21 INDEX BY BINARY_INTEGER;
22
23
24 -- ************************************************************************
25 -- PUBLIC PROCEDURES
26 -- ************************************************************************
27 /*===========================================================================+
28 | PROCEDURE |
29 | calc_sums |
30 | |
31 | DESCRIPTION |
32 | Calculates dr and cr totals either for given transaction or for the |
33 | passed where clause for given application. The function totals the lines|
34 | from the view name passed in. |
35 | |
36 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
37 | none |
38 | |
39 | ARGUMENTS : IN: p_application_id -- E.g 222 for Receivables |
40 | p_trx_hdr_table -- Transaction header table |
41 | p_trx_hdr_id -- Transaction header id |
42 | p_cost_type_id -- Cost Type Id (Mfg PAC trx) |
43 | p_ovr_where_clause -- Overriding where clause |
44 | p_view_name -- View Name |
45 | p_add_col_name_1 -- Additional Column 1 |
46 | p_add_col_value_1 -- Value of Additional Column 1 |
47 | p_add_col_name_2 -- Additional Column 2 |
48 | p_add_col_value_2 -- Value of Additional Column 2 |
49 | OUT: x_total_entered_dr |
50 | x_total_entered_cr |
51 | x_total_accounted_dr |
52 | x_total_accounted_cr |
53 | NOTES |
54 | |
55 | MODIFICATION HISTORY |
56 | 06-Nov-98 Heli Lankinen Created |
57 | 04-Aug-99 Mahesh Sabapthy Added parameter cost_type_id to |
58 | support Mfg. PAC transactions. |
59 | |
60 +===========================================================================*/
61
62 PROCEDURE CALC_SUMS (
63 p_application_id IN NUMBER,
64 p_set_of_books_id IN NUMBER,
65 p_trx_hdr_table IN VARCHAR2,
66 p_trx_hdr_id IN NUMBER,
67 p_cost_type_id IN NUMBER,
68 p_ovr_where_clause IN VARCHAR2,
69 p_view_name IN VARCHAR2,
70 p_add_col_name_1 IN VARCHAR2,
71 p_add_col_value_1 IN VARCHAR2,
72 p_add_col_name_2 IN VARCHAR2,
73 p_add_col_value_2 IN VARCHAR2,
74 x_total_entered_dr OUT NOCOPY NUMBER,
75 x_total_entered_cr OUT NOCOPY NUMBER,
76 x_total_accounted_dr OUT NOCOPY NUMBER,
77 x_total_accounted_cr OUT NOCOPY NUMBER );
78
79 /*===========================================================================+
80 | PROCEDURE |
81 | get_acct_method_info |
82 | |
83 | DESCRIPTION |
84 | Gets the accounting methods and set of books info associated with the |
85 | accounting method for a given application. |
86 | |
87 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
88 | none |
89 | |
90 | ARGUMENTS : IN: p_application_id -- E.g 200 for Payables |
91 | OUT: x_acct_method_info |
92 | NOTES |
93 | |
94 | MODIFICATION HISTORY |
95 | 28-Apr-99 Mahesh Sabapathy Created |
96 +===========================================================================*/
97 PROCEDURE get_acct_method_info (
98 p_application_id IN NUMBER,
99 x_acct_method_info OUT NOCOPY acct_method_info_tbl );
100
101 /*===========================================================================+
102 | PROCEDURE |
103 | get_acct_method_info_scalar |
104 | |
105 | DESCRIPTION |
106 | Gets the accounting methods and set of books info associated with the |
107 | accounting method for a given application. |
108 | |
109 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
110 | none |
111 | |
112 | ARGUMENTS : IN: p_application_id -- E.g 200 for Payables |
113 | OUT: |
114 | acct_method_n |
115 | sob_id_n |
116 | sob_curr_n |
117 | sob_type_n |
118 | sob_name_n |
119 | sob_short_name_n |
120 acct_method_name_n
121 | NOTES |
122 | |
123 | MODIFICATION HISTORY |
124 | 28-Apr-99 Mahesh Sabapathy Created |
125 +===========================================================================*/
126 PROCEDURE get_acct_method_info_scalar (
127 p_application_id IN NUMBER,
128 x_acct_method_1 OUT NOCOPY VARCHAR2,
129 x_sob_id_1 OUT NOCOPY NUMBER,
130 x_sob_curr_1 OUT NOCOPY VARCHAR2,
131 x_sob_type_1 OUT NOCOPY VARCHAR2,
132 x_sob_name_1 OUT NOCOPY VARCHAR2,
133 x_sob_short_name_1 OUT NOCOPY VARCHAR2,
134 x_acct_method_name_1 OUT NOCOPY VARCHAR2,
135 x_acct_method_2 OUT NOCOPY VARCHAR2,
136 x_sob_id_2 OUT NOCOPY NUMBER,
137 x_sob_curr_2 OUT NOCOPY VARCHAR2,
138 x_sob_type_2 OUT NOCOPY VARCHAR2,
139 x_sob_name_2 OUT NOCOPY VARCHAR2,
140 x_sob_short_name_2 OUT NOCOPY VARCHAR2,
141 x_acct_method_name_2 OUT NOCOPY VARCHAR2);
142
143 END XLA_XLAIQACL_UTILS_PKG;