[Home] [Help]
PACKAGE BODY: APPS.JA_IN_XLA_UTILS_PKG
Source
1 PACKAGE BODY ja_in_xla_utils_pkg AS
2 /* $Header: ja_in_xla_utils.plb 120.1 2010/12/24 06:47:13 xlv noship $ */
3
4 /********************************************************************************************************
5 FILENAME : ja_in_xla_utils.plb
6
7 Created By : Walton
8
9 Created Date : 07-Apr-2010
10
11 Bug : 9311844
12
13 Purpose : Check whether OFI source and category be used or not.
14
15 Called from : XLACORE.pll
16
17 --------------------------------------------------------------------------------------------------------
18 CHANGE HISTORY:
19 --------------------------------------------------------------------------------------------------------
20 S.No Date Author and Details
21 --------------------------------------------------------------------------------------------------------
22 1. 2010/04/07 Walton Liu
23 Bug No : 9311844
24 Description : The file is changed for ER GL drilldown
25 Fix Details : http://files.oraclecorp.com/content/MySharedFolders/R12.1.3/TDD/TDD_1213_FIN_JAI_GL_Drilldown.doc
26 Doc Impact : YES
27 Dependencies: YES, refer to Technical Design
28 2. 2010/06/08 Xiao Lv for bug#9771635
29 Issue - DRILL DOWN FUNCTIONALITY DOESN'T WORK FOR TCS JOURNAL
30 Fixed - Reversed source and category for TCS accountings.
31 Source should be 'Receivables India,'
32 Category should be 'India Tax Collected'
33
34 ***************************************************************************************************************/
35
36 --==========================================================================
37 -- FUNCTION NAME:
38 --
39 -- if_OFI_drilldown Public
40 --
41 -- DESCRIPTION:
42 --
43 -- This function is used to Enable/Disable drilldown buttion
44 -- according OFI journal source and journal categories.
45 --
46 -- PARAMETERS:
47 -- In: pn_je_source Identifier of journal source
48 -- pn_je_category Identifier of journal category
49 --
50 --
51 -- DESIGN REFERENCES:
52 -- FDD_R12_1_4_GL_Drilldown_V0.4.docx
53 --
54 -- CHANGE HISTORY:
55 --
56 -- 09-Mar-2010 Jia Li created
57 --==========================================================================
58 FUNCTION if_OFI_drilldown (
59 pn_je_source VARCHAR2
60 , pn_je_category VARCHAR2
61 ) RETURN BOOLEAN
62 IS
63 lb_drilldown_flag BOOLEAN := FALSE;
64 lv_je_source varchar2(100);
65 lv_je_category varchar2(100);
66
67 CURSOR get_user_source IS
68 select user_je_source_name
69 from gl_je_sources gjs
70 where gjs.je_source_name = pn_je_source;
71
72 CURSOR get_user_category IS
73 select user_je_category_name
74 from gl_je_categories gjc
75 where gjc.je_category_name = pn_je_category;
76
77 BEGIN
78
79 OPEN get_user_source;
80 FETCH get_user_source INTO lv_je_source;
81 CLOSE get_user_source;
82
83 OPEN get_user_category;
84 FETCH get_user_category INTO lv_je_category;
85 CLOSE get_user_category;
86 --Add category 'India Tax Collected' by Xiao for bug#9771635 on 08-Jun-10
87 IF ((lv_je_source = 'Receivables India') AND (lv_je_category IN( 'Register India','India Tax Collected')))
88 OR
89 ((lv_je_source = 'Projects India') AND (lv_je_category = 'Register India'))
90 OR
91 ((lv_je_source = 'Inventory India') AND (lv_je_category = 'MTL'))
92 OR
93 ((lv_je_source = 'Payables India') AND (lv_je_category IN ('Bill of Entry India','Payments')))
94 OR
95 ((lv_je_source = 'Payables') AND (lv_je_category = 'BOE'))
96 OR
97 ((lv_je_source = 'Purchasing India') AND (lv_je_category IN ('Receiving India','OSP Issue India','OSP Receipt India', 'MMT')))
98 OR
99 ((lv_je_source = 'Register India') AND (lv_je_category IN ('Inventory India','VAT India','Register India')))
100 OR
101 ((lv_je_source IN ('VAT India','Service Tax India')) AND (lv_je_category = 'Register India'))
102 --Commented by Xiao for bug#9771635 on 08-Jun-10
103 --OR
104 --((lv_je_source = 'India Tax Collected') AND (lv_je_category = 'Receivalbes India'))
105 THEN
106 lb_drilldown_flag := TRUE;
107 END IF;
108
109 RETURN ( lb_drilldown_flag );
110
111 END if_OFI_drilldown;
112
113
114 END ja_in_xla_utils_pkg;