1 PACKAGE JAI_DRILLDOWN_UTILS_PKG AS
2 /* $Header: jai_drilldown_utils_pkg.pls 120.1.12020000.2 2012/10/09 06:47:13 anupgupt ship $ */
3
4
5 /********************************************************************************************************
6 FILENAME : jai_drilldown_utils_pkg.pls
7
8 Created By : Walton
9
10 Created Date : 15-Apr-2010
11
12 Bug : 9311844
13
14 Purpose : This is the drilldown utility package which contain some common used subprograms.
15
16 Called from : OFI code
17
18 --------------------------------------------------------------------------------------------------------
19 CHANGE HISTORY:
20 --------------------------------------------------------------------------------------------------------
21 S.No Date Author and Details
22 --------------------------------------------------------------------------------------------------------
23 1. 2010/04/07 Walton Liu
24 Bug No : 9311844
25 Description : The file is changed for ER GL drilldown
26 Fix Details : http://files.oraclecorp.com/content/MySharedFolders/R12.1.3/TDD/TDD_1213_FIN_JAI_GL_Drilldown.doc
27 Doc Impact : YES
28 Dependencies: YES, refer to Technical Design
29
30 2. 2010/04/15 Xiao Lv
31 Bug No : 9311844
32 Description : The file is changed for ER GL drilldown
33 Fix Details : http://files.oraclecorp.com/content/MySharedFolders/R12.1.3/TDD/TDD_1213_FIN_JAI_GL_Drilldown.doc
34 Doc Impact : YES
35 Dependencies: YES, refer to Technical Design
36
37
38 ***************************************************************************************************************/
39
40 --==========================================================================
41 -- FUNCTION NAME:
42 --
43 -- if_accounted Public
44 --
45 -- DESCRIPTION:
46 --
47 -- This function is used to check if accounting entries for OFI transactions
48 -- was imported into GL journal or not.
49 --
50 -- PARAMETERS:
51 -- In: pv_view_name Name of base view
52 -- pn_transaction_id Identifier of transaction header
53 --
54 --
55 -- DESIGN REFERENCES:
56 -- FDD_R12_1_3_GL_Drilldowndocx
57 --
58 -- CHANGE HISTORY:
59 --
60 -- 15-Apr-2010 Walton created
61 --==========================================================================
62 FUNCTION if_accounted (pv_view_name VARCHAR2, pn_transaction_id NUMBER) RETURN BOOLEAN;
63
64 --==========================================================================
65 -- FUNCTION NAME:
66 --
67 -- get_transfer_number Public
68 --
69 -- DESCRIPTION:
70 --
71 -- This function is used to get destination transfer number.
72 --
73 --
74 -- PARAMETERS:
75 -- In: pn_transfer_id Transfer id for Service Tax Distribution
76 -- pn_org_id Org id for accounting entries
77 -- pn_balance Balance for each accounting entries
78 --
79 --
80 -- DESIGN REFERENCES:
81 -- FDD_R12_1_3_GL_Drilldowndocx
82 --
83 -- CHANGE HISTORY:
84 --
85 -- 15-Apr-2010 Xiao created
86 --==========================================================================
87
88 FUNCTION get_transfer_number(pn_transfer_id IN NUMBER
89 , pn_org_id IN NUMBER
90 , pn_balance IN NUMBER) RETURN NUMBER;
91
92 --==========================================================================
93 -- FUNCTION NAME:
94 --
95 -- get_des_org_name Public
96 --
97 -- DESCRIPTION:
98 --
99 -- This function is used to get destination organization name.
100 --
101 --
102 -- PARAMETERS:
103 -- In: pn_transfer_id Transfer id for Service Tax Distribution
104 -- pn_org_id Org id for accounting entries
105 -- pn_balance Balance for each accounting entries
106 --
107 --
108 -- DESIGN REFERENCES:
109 -- FDD_R12_1_3_GL_Drilldowndocx
110 --
111 -- CHANGE HISTORY:
112 --
113 -- 15-Apr-2010 Xiao created
114 --==========================================================================
115 FUNCTION get_des_org_name( pn_transfer_id IN NUMBER
116 , pn_org_id IN NUMBER
117 , pn_balance IN NUMBER) RETURN VARCHAR2;
118
119 --==========================================================================
120 -- FUNCTION NAME:
121 --
122 -- get_des_org_type Public
123 --
124 -- DESCRIPTION:
125 --
126 -- This function is used to get destination organization type.
127 --
128 --
129 -- PARAMETERS:
130 -- In: pn_transfer_id Transfer id for Service Tax Distribution
131 -- pn_org_id Org id for accounting entries
132 -- pn_balance Balance for each accounting entries
133 --
134 --
135 -- DESIGN REFERENCES:
136 -- FDD_R12_1_3_GL_Drilldowndocx
137 --
138 -- CHANGE HISTORY:
139 --
140 -- 15-Apr-2010 Xiao created
141 --==========================================================================
142
143 FUNCTION get_des_org_type(pn_transfer_id IN NUMBER
144 , pn_org_id IN NUMBER
145 , pn_balance IN NUMBER) RETURN VARCHAR;
146 --==========================================================================
147 -- FUNCTION NAME:
148 --
149 -- get_des_loc_name Public
150 --
151 -- DESCRIPTION:
152 --
153 -- This function is used to get destination organization location name.
154 --
155 --
156 -- PARAMETERS:
157 -- In: pn_transfer_id Transfer id for Service Tax Distribution
158 -- pn_org_id Org id for accounting entries
159 -- pn_balance Balance for each accounting entries
160 --
161 --
162 -- DESIGN REFERENCES:
163 -- FDD_R12_1_3_GL_Drilldowndocx
164 --
165 -- CHANGE HISTORY:
166 --
167 -- 15-Apr-2010 Xiao created
168 --==========================================================================
169 FUNCTION get_des_loc_name(pn_transfer_id IN NUMBER
170 , pn_org_id IN NUMBER
171 , pn_balance IN NUMBER) RETURN VARCHAR;
172
173 --==========================================================================
174 -- FUNCTION NAME:
175 --
176 -- get_user_categ_name Public
177 --
178 -- DESCRIPTION:
179 --
180 -- This function is used to get gl user category name.
181 --
182 --
183 -- PARAMETERS:
184 -- In: pn_categ_name category name from gl
185 --
186 --
187 -- DESIGN REFERENCES:
188 -- FDD_R12_1_3_GL_Drilldowndocx
189 --
190 -- CHANGE HISTORY:
191 --
192 -- 09-Oct-2012 anupgupt created bug 14671875
193 --==========================================================================
194
195 FUNCTION get_user_categ_name(pn_categ_name IN VARCHAR) RETURN VARCHAR;
196
197
198 END JAI_DRILLDOWN_UTILS_PKG;