[Home] [Help]
PACKAGE: APPS.GCS_XML_DT_UTILITY_PKG
Source
1 PACKAGE GCS_XML_DT_UTILITY_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcsxmldtutils.pls 120.12 2007/05/04 12:07:41 sangarg noship $ */
3
4 -- Declare parameter with same name as declared in data template
5 -- So that XDO resolves parameter mapping to Data Template parameters
6 -- and this package APIs can utilize values supplied by calling program
7 pEntityId number;
8 --fix#5087857
9 pRunName varchar2(240);
10 pXmlFileId number;
11
12 pLanguageCode varchar2(20);
13 pCalPeriodEndDateAttr number;
14 pCalPeriodEndDateVersion number;
15 pEntityTypeAttr number;
16 pEntityTypeVersion number;
17 pEntityLedgerAttr number;
18 pEntityLedgerVersion number;
19 pEntitySrcsysAttr number;
20 pEntitySrcsysVersion number;
21 pLedgerCurrAttr number;
22 pLedgerCurrVersion number;
23 pLedgerVsComboAttr number;
24 pLedgerVsComboVersion number;
25
26 --start bug fix 5480573
27 --Paramneter Values for Adjustment Writeback
28 accountName VARCHAR2(2500);
29 pUserName VARCHAR2(100);
30 pEntityEnabledFlagVersion NUMBER;
31 pEntityEnabledFlagAttr NUMBER;
32 --end bug fix 5480573
33
34 --start bug fix 5518000
35 -- Parameter Values for Entries
36 addWhereClause VARCHAR2(200);
37 addREWhereClause VARCHAR2(200);
38
39 pSourceUI VARCHAR2(20);
40 pCalPeriodYearAttr NUMBER;
41 pCalPeriodYearVersion NUMBER;
42 --end bug fix 5518000
43
44 -- Literal values returned to data template
45 entityIdListLiteral varchar2(10000);
46 dsSelectLiteral varchar2(10000);
47 finElemsLiteral varchar2(150);
48 currencyLiteral varchar2(150);
49 currencyTypeLiteral varchar2(150);
50 entityOrgsLiteral varchar2(5000);
51
52 --Literal Values for Data Sub Impacted Balances Posted Report
53 FilterParamsLiteral VARCHAR2(5000) := ' ';
54 LedgerLiteral VARCHAR2(150);
55 --Parameter Values for Data Sub Impacted Balances Posted Report
56 pCalPeriodId NUMBER;
57 pCurrency VARCHAR2(100);
58 pEntityName VARCHAR2(150);
59 pCalPeriodName VARCHAR2(150);
60 pDataTypeCode VARCHAR2(150);
61 pLoadId NUMBER;
62 pOrgId NUMBER;
63 pDataTypeName VARCHAR2(150);
64 pCurrName VARCHAR2(150);
65
66 -- Start of Bugfix: 5861665
67 --Literal Values defined for Inter Company Matching Report
68 -- for consolidation entities
69 counterEntityIdLiteral VARCHAR2(150);
70 ruleIdLiteral VARCHAR2(150);
71 suspenseExFlagLiteral VARCHAR2(150);
72 --Parameter Values defined for Inter Company Matching Report
73 -- for consolidation entities
74 pHierarchy NUMBER;
75 -- Bugfix: 6020393
76 -- pHierarchyName VARCHAR2(100);
77 pEntity NUMBER;
78 -- Bugfix: 6006700 Variable pEntityName is already decleared above
79 -- pEntityName VARCHAR2(150);
80 pCEntity NUMBER;
81 pPeriod VARCHAR2(150);
82 pCalName VARCHAR2(150);
83 pRule VARCHAR2(150);
84 -- Bugfix: 6020393
85 -- pRuleName VARCHAR2(150);
86 pDataTemplate VARCHAR2(150);
87 -- Bugfix: 6008841 Variables removed from Data template
88 -- pNoCase VARCHAR2(150);
89 -- pYesCase VARCHAR2(150);
90 pTransactionType VARCHAR2(2);
91 pDrillDnEnabled VARCHAR2(150);
92 -- BugFix: 6004119
93 -- pLanguageCode VARCHAR2(150);
94 pBalanceTypeCode VARCHAR2(150);
95 -- End of Bugfix: 5861665
96
97 --
98 -- Function
99 -- before_cmtb_report
100 -- Purpose
101 -- An API to handle consolidation Trial Balance Data Template Literals
102 -- Arguments
103 -- Notes
104 --
105 FUNCTION before_cmtb_report RETURN BOOLEAN;
106 --
107 -- Function
108 -- before_dstb_report
109 -- Purpose
110 -- An API to handle Data Submission Trial Balance Data Template Literals
111 -- Arguments
112 -- Notes
113 --
114 FUNCTION before_dstb_report RETURN BOOLEAN;
115 --
116 -- Function
117 -- before_femnonposted_report
118 -- Purpose
119 -- An API to handle Fem Non Reported Rows
120 -- Arguments
121 -- Notes
122 --
123 FUNCTION before_femnonposted_report RETURN BOOLEAN;
124
125 --
126 -- Function
127 -- writeback_report
128 -- Purpose
129 -- An API to handle GL Writeback of Consolidation Entries
130 -- Arguments
131 -- Notes
132 --
133 FUNCTION writeback_report RETURN BOOLEAN;
134
135 --
136 -- Function
137 -- before_entry_report
138 -- Purpose
139 -- Adds the additional where clasue to the query displaying the entry
140 -- report data depending upon the LINE_TYPE_CODE column.
141 -- Arguments
142 -- Notes
143 -- Added to fix bug 5518000.
144 --
145 FUNCTION before_entry_report RETURN BOOLEAN;
146
147 --
148 -- Function
149 -- intercompany_report
150 -- Purpose
151 -- Returns where clause as per the variable values passed and
152 -- are appended to the data template query
153 -- Arguments
154 -- Notes
155 -- Added to fix bug 5861665.
156 --
157 FUNCTION intercompany_report RETURN BOOLEAN;
158
159 END GCS_XML_DT_UTILITY_PKG;