[Home] [Help]
PACKAGE: APPS.CSE_GL_INTERFACE_PKG
Source
1 PACKAGE CSE_GL_INTERFACE_PKG AS
2 -- $Header: CSEGLINS.pls 120.7 2006/03/15 14:47 kuchauha noship $
3
4
5 TYPE gl_interface_rec is RECORD (
6
7 STATUS VARCHAR2(50) ,
8 LEDGER_ID NUMBER(15,0) ,
9 ACCOUNTING_DATE DATE ,
10 CURRENCY_CODE VARCHAR2(15) ,
11 DATE_CREATED DATE ,
12 CREATED_BY NUMBER(15,0) ,
13 ACTUAL_FLAG VARCHAR2(1) ,
14 USER_JE_CATEGORY_NAME VARCHAR2(25) ,
15 USER_JE_SOURCE_NAME VARCHAR2(25) ,
16 CURRENCY_CONVERSION_DATE DATE ,
17 ENCUMBRANCE_TYPE_ID NUMBER ,
18 BUDGET_VERSION_ID NUMBER ,
19 USER_CURRENCY_CONVERSION_TYPE VARCHAR2(30) ,
20 CURRENCY_CONVERSION_RATE NUMBER ,
21 SEGMENT1 VARCHAR2(25) ,
22 SEGMENT2 VARCHAR2(25) ,
23 SEGMENT3 VARCHAR2(25) ,
24 SEGMENT4 VARCHAR2(25) ,
25 SEGMENT5 VARCHAR2(25) ,
26 SEGMENT6 VARCHAR2(25) ,
27 SEGMENT7 VARCHAR2(25) ,
28 SEGMENT8 VARCHAR2(25) ,
29 SEGMENT9 VARCHAR2(25) ,
30 SEGMENT10 VARCHAR2(25) ,
31 SEGMENT11 VARCHAR2(25) ,
32 SEGMENT12 VARCHAR2(25) ,
33 SEGMENT13 VARCHAR2(25) ,
34 SEGMENT14 VARCHAR2(25) ,
35 SEGMENT15 VARCHAR2(25) ,
36 SEGMENT16 VARCHAR2(25) ,
37 SEGMENT17 VARCHAR2(25) ,
38 SEGMENT18 VARCHAR2(25) ,
39 SEGMENT19 VARCHAR2(25) ,
40 SEGMENT20 VARCHAR2(25) ,
41 SEGMENT21 VARCHAR2(25) ,
42 SEGMENT22 VARCHAR2(25) ,
43 SEGMENT23 VARCHAR2(25) ,
44 SEGMENT24 VARCHAR2(25) ,
45 SEGMENT25 VARCHAR2(25) ,
46 SEGMENT26 VARCHAR2(25) ,
47 SEGMENT27 VARCHAR2(25) ,
48 SEGMENT28 VARCHAR2(25) ,
49 SEGMENT29 VARCHAR2(25) ,
50 SEGMENT30 VARCHAR2(25) ,
51 ENTERED_DR NUMBER ,
52 ENTERED_CR NUMBER ,
53 ACCOUNTED_DR NUMBER ,
54 ACCOUNTED_CR NUMBER ,
55 TRANSACTION_DATE DATE ,
56 REFERENCE1 VARCHAR2(100) ,
57 REFERENCE2 VARCHAR2(240) ,
58 REFERENCE3 VARCHAR2(100) ,
59 REFERENCE4 VARCHAR2(100) ,
60 REFERENCE5 VARCHAR2(240) ,
61 REFERENCE6 VARCHAR2(100) ,
62 REFERENCE7 VARCHAR2(100) ,
63 REFERENCE8 VARCHAR2(100) ,
64 REFERENCE9 VARCHAR2(100) ,
65 REFERENCE10 VARCHAR2(240) ,
66 REFERENCE11 VARCHAR2(240) ,
67 REFERENCE12 VARCHAR2(100) ,
68 REFERENCE13 VARCHAR2(100) ,
69 REFERENCE14 VARCHAR2(100) ,
70 REFERENCE15 VARCHAR2(100) ,
71 REFERENCE16 VARCHAR2(100) ,
72 REFERENCE17 VARCHAR2(100) ,
73 REFERENCE18 VARCHAR2(100) ,
74 REFERENCE19 VARCHAR2(100) ,
75 REFERENCE20 VARCHAR2(100) ,
76 REFERENCE21 VARCHAR2(240) ,
77 REFERENCE22 VARCHAR2(240) ,
78 REFERENCE23 VARCHAR2(240) ,
79 REFERENCE24 VARCHAR2(240) ,
80 REFERENCE25 VARCHAR2(240) ,
81 REFERENCE26 VARCHAR2(240) ,
82 REFERENCE27 VARCHAR2(240) ,
83 REFERENCE28 VARCHAR2(240) ,
84 REFERENCE29 VARCHAR2(240) ,
85 REFERENCE30 VARCHAR2(240) ,
86 JE_BATCH_ID NUMBER(15,0) ,
87 PERIOD_NAME VARCHAR2(15) ,
88 JE_HEADER_ID NUMBER(15,0) ,
89 JE_LINE_NUM NUMBER(15,0) ,
90 CHART_OF_ACCOUNTS_ID NUMBER(15,0) ,
91 FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) ,
92 CODE_COMBINATION_ID NUMBER(15,0) ,
93 DATE_CREATED_IN_GL DATE ,
94 WARNING_CODE VARCHAR2(4) ,
95 STATUS_DESCRIPTION VARCHAR2(240),
96 STAT_AMOUNT NUMBER ,
97 GROUP_ID NUMBER(15,0) ,
98 REQUEST_ID NUMBER(15,0) ,
99 SUBLEDGER_DOC_SEQUENCE_ID NUMBER ,
100 SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER ,
101 ATTRIBUTE1 VARCHAR2(150),
102 ATTRIBUTE2 VARCHAR2(150),
103 ATTRIBUTE3 VARCHAR2(150),
104 ATTRIBUTE4 VARCHAR2(150),
105 ATTRIBUTE5 VARCHAR2(150),
106 ATTRIBUTE6 VARCHAR2(150),
107 ATTRIBUTE7 VARCHAR2(150),
108 ATTRIBUTE8 VARCHAR2(150),
109 ATTRIBUTE9 VARCHAR2(150),
110 ATTRIBUTE10 VARCHAR2(150),
111 ATTRIBUTE11 VARCHAR2(150),
112 ATTRIBUTE12 VARCHAR2(150),
113 ATTRIBUTE13 VARCHAR2(150),
114 ATTRIBUTE14 VARCHAR2(150),
115 ATTRIBUTE15 VARCHAR2(150),
116 ATTRIBUTE16 VARCHAR2(150),
117 ATTRIBUTE17 VARCHAR2(150),
118 ATTRIBUTE18 VARCHAR2(150),
119 ATTRIBUTE19 VARCHAR2(150),
120 ATTRIBUTE20 VARCHAR2(150),
121 CONTEXT VARCHAR2(150),
122 CONTEXT2 VARCHAR2(150),
123 INVOICE_DATE DATE ,
124 TAX_CODE VARCHAR2(15) ,
125 INVOICE_IDENTIFIER VARCHAR2(20) ,
126 INVOICE_AMOUNT NUMBER ,
127 CONTEXT3 VARCHAR2(150),
128 USSGL_TRANSACTION_CODE VARCHAR2(30) ,
129 DESCR_FLEX_ERROR_MESSAGE VARCHAR2(240),
130 JGZZ_RECON_REF VARCHAR2(240),
131 AVERAGE_JOURNAL_FLAG VARCHAR2(1) ,
132 ORIGINATING_BAL_SEG_VALUE VARCHAR2(25) ,
133 GL_SL_LINK_ID NUMBER ,
134 GL_SL_LINK_TABLE VARCHAR2(30) ,
135 REFERENCE_DATE DATE ,
136 SET_OF_BOOKS_ID NUMBER(15,0) ,
137 BALANCING_SEGMENT_VALUE VARCHAR2(25) ,
138 MANAGEMENT_SEGMENT_VALUE VARCHAR2(25) ,
139 CODE_COMBINATION_ID_INTERIM NUMBER(15) ) ;
140
141 TYPE gl_interface_tbl is TABLE OF gl_interface_rec INDEX BY BINARY_INTEGER;
142
143 -------------------------------------------------------------------------------------
144
145 PROCEDURE get_gl_interface_code(
146 p_mtl_txn_id IN NUMBER
147 ,p_csi_txn_id IN NUMBER
148 ,x_gl_interface_code OUT NOCOPY NUMBER
149 ,x_return_status OUT NOCOPY VARCHAR2
150 ,x_error_message OUT NOCOPY VARCHAR2);
151
152 -------------------------------------------------------------------------------------
153
154 PROCEDURE Create_gl_entries
155 (x_return_status OUT NOCOPY VARCHAR2,
156 x_error_msg OUT NOCOPY VARCHAR2,
157 p_conc_request_id IN NUMBER );
158
159
160 -------------------------------------------------------------------------------------
161 END CSE_GL_INTERFACE_PKG; -- Package spec