1 PACKAGE XLA_TACCOUNTS_DATA_PKG AS
2 /* $Header: xlatacct.pkh 120.1 2004/02/13 23:02:28 weshen noship $ */
3
4 -- Record structure for TAccounts
5 TYPE LineData IS RECORD (
6 lineType NUMBER
7 ,Ccid NUMBER(15)
8 ,Account VARCHAR2(1000)
9 ,AccountDesc VARCHAR2(2000)
10 ,lineReference VARCHAR2(1000)
11 ,enteredCurrency VARCHAR2(15)
12 ,accountingCurrency VARCHAR2(15)
13 ,enteredAmountDr NUMBER
14 ,enteredAmountCr NUMBER
15 ,accountedAmountDr NUMBER
16 ,accountedAmountCr NUMBER
17 ,reportedAmountDr NUMBER
18 ,reportedAmountCr NUMBER
19 );
20
21 TYPE t_TAlineDataArray IS TABLE OF LineData INDEX BY BINARY_INTEGER;
22
23 TA_lineDataArray t_TAlineDataArray;
24
25 -- Record structure for Trial Balance
26 TYPE TB_LineData IS RECORD (
27 lineType NUMBER
28 ,Ccid NUMBER(15)
29 ,Account VARCHAR2(1000)
30 ,AccountDesc VARCHAR2(2000)
31 ,enteredCurrency VARCHAR2(15)
32 ,balancebeforeDr NUMBER
33 ,balancebeforeCr NUMBER
34 ,balancebeforeNet NUMBER
35 ,balanceAfterDr NUMBER
36 ,balanceAfterCr NUMBER
37 ,balanceAfterNet NUMBER
38 ,enteredAmountDr NUMBER
39 ,enteredAmountCr NUMBER
40 ,accountedAmountDr NUMBER
41 ,accountedAmountCr NUMBER
42 ,reportedAmountDr NUMBER
43 ,reportedAmountCr NUMBER
44 ,enteredAmountNet NUMBER
45 ,accountedAmountNet NUMBER
46 ,reportingAmountNet NUMBER
47 );
48
49 TYPE T_TBLineDataArray IS TABLE OF TB_LineData INDEX BY BINARY_INTEGER;
50
51 AccountingCurrency VARCHAR2(15);
52 ReportingCurrency VARCHAR2(15);
53
54
55 /*===========================================================================+
56 | PROCEDURE |
57 | init |
58 | |
59 | DESCRIPTION |
60 | Accounting Data for T Accounts API |
61 | |
62 | SCOPE - PUBLIC |
63 | |
64 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
65 | |
66 | ARGUMENTS : IN: p_application_id |
67 | |
68 | NOTES |
69 | |
70 | MODIFICATION HISTORY |
71 | 14-Sep-98 Dirk Stevens Created |
72 | 04-Aug-99 Mahesh Sabapthy Added parameter cost_type_id to |
73 | support Mfg. PAC transactions. |
74 | 16-Sep-99 Dimple Shah Added parameters- |
75 | add_col_name_1, add_col_value_1, |
76 | add_col_name_2, add_col_value_2 |
77 | |
78 +===========================================================================*/
79 PROCEDURE ta_init (
80 p_Application_ID IN NUMBER
81 ,p_Trx_Header_Table IN VARCHAR2
82 ,p_Trx_Header_ID IN NUMBER
83 ,p_Cost_Type_ID IN NUMBER
84 ,p_Chart_Of_Accounts_ID IN NUMBER
85 ,p_Set_Of_Books_ID IN NUMBER
86 ,p_Organize_By IN VARCHAR2 -- ACCOUNT | SEGMENT
87 ,p_Segment1 IN NUMBER
88 ,p_Segment2 IN NUMBER
89 ,p_OverRidingWhereClause IN VARCHAR2
90 ,p_viewName IN VARCHAR2
91 ,p_add_col_name_1 IN VARCHAR2 DEFAULT NULL
92 ,p_add_col_value_1 IN VARCHAR2 DEFAULT NULL
93 ,p_add_col_name_2 IN VARCHAR2 DEFAULT NULL
94 ,p_add_col_value_2 IN VARCHAR2 DEFAULT NULL
95 );
96
97 PROCEDURE tb_init (
98 p_Application_ID IN NUMBER
99 ,p_Trx_Header_Table IN VARCHAR2
100 ,p_Trx_Header_ID IN NUMBER
101 ,p_Cost_Type_ID IN NUMBER
102 ,p_Chart_Of_Accounts_ID IN NUMBER
103 ,p_Set_Of_Books_ID IN NUMBER
104 ,p_Organize_By IN VARCHAR2 -- ACCOUNT | SEGMENT
105 ,p_Segment1 IN NUMBER
106 ,p_Segment2 IN NUMBER
107 ,p_OverRidingWhereClause IN VARCHAR2
108 ,p_viewName IN VARCHAR2
109 ,p_add_col_name_1 IN VARCHAR2 DEFAULT NULL
110 ,p_add_col_value_1 IN VARCHAR2 DEFAULT NULL
111 ,p_add_col_name_2 IN VARCHAR2 DEFAULT NULL
112 ,p_add_col_value_2 IN VARCHAR2 DEFAULT NULL
113 );
114
115 PROCEDURE ta_fetch_rows ( p_rows IN NUMBER DEFAULT 50
116 ,p_TALineDataArray OUT NOCOPY T_TALineDataArray
117 ,p_eof OUT NOCOPY BOOLEAN );
118 PROCEDURE ta_close;
119
120 PROCEDURE tb_fetch_rows ( p_rows IN NUMBER DEFAULT 50
121 ,p_TbLineDataArray OUT NOCOPY T_TBLineDataArray
122 ,p_eof OUT NOCOPY BOOLEAN );
123 PROCEDURE tb_close;
124
125 FUNCTION getAccountingCurrency(pSetOfBooksID IN NUMBER)
126 RETURN VARCHAR2;
127
128 FUNCTION getReportingCurrency(pSetOfBooksID IN NUMBER)
129 RETURN VARCHAR2;
130
131 FUNCTION getChartOfAccountsID(pSetOfBooksID IN NUMBER)
132 RETURN NUMBER;
133
134 FUNCTION xla_supported(p_application_id in NUMBER)
135 RETURN NUMBER;
136
137 END XLA_TACCOUNTS_DATA_PKG;