[Home] [Help]
PACKAGE BODY: APPS.BIS_PARAMETER_VALIDATION
Source
1 PACKAGE BODY BIS_PARAMETER_VALIDATION AS
2 /* $Header: BISPARMB.pls 120.2 2006/03/28 10:42:14 nbarik noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb \
4 -- dbdrv: checkfile(115.97=120.2):~PROD:~PATH:~FILE
5 ----------------------------------------------------------------------------
6 -- PACKAGE: BIS_PARAMETER_VALIDATE --
7 -- --
8 -- DESCRIPTION: This package contains all the procedures used to --
9 -- validate the Report Generator parameters. --
10 -- --
11 -- MODIFICATIONS --
12 -- Date User Modification --
13 -- 03/28/06 nbarik This package is a candidate for stubbing --
14 -- but since there are dependencies keeping it now --
15 ----------------------------------------------------------------------------
16 /*
17 nbarik - 03/27/06 - Bug Fix 4941893
18 This package shouldn't be used for new code.
19 This is not stubbed yet because of there are some dependencies.
20 If there is any change required to this package, then chage it in
21 appropriate places and remove it from here.
22 */
23 FUNCTION getTimeLovSql (p_dimn_level_short_name IN VARCHAR2,
24 p_dimn_level_value IN VARCHAR2,
25 p_sql_type IN VARCHAR2 DEFAULT NULL,
26 p_region_code IN VARCHAR2,
27 pResponsibilityId IN VARCHAR2,
28 pOrgParam IN VARCHAR2,
29 pOrgValue IN VARCHAR2) RETURN VARCHAR2
30 IS
31
32 l_sql_statement VARCHAR2(3000);
33 l_bind_sql VARCHAR2(3000);
34 l_bind_variables VARCHAR2(3000);
35 l_bind_count NUMBER;
36 l_return_status VARCHAR2(2000);
37 l_msg_count NUMBER;
38 l_msg_data VARCHAR2(2000);
39
40 BEGIN
41 BIS_PMV_PARAMETERS_PVT.getTimeLovSql (
42 p_parameter_name => p_dimn_level_short_name
43 , p_parameter_description => p_dimn_level_value
44 , p_sql_type => p_sql_type
45 , p_date => NULL
46 , p_region_code => p_region_code
47 , p_responsibility_id => pResponsibilityId
48 , p_org_name => pOrgParam
49 , p_org_value => pOrgValue
50 , x_sql_statement => l_sql_statement
51 , x_bind_sql => l_bind_sql
52 , x_bind_variables => l_bind_variables
53 , x_bind_count => l_bind_count
54 , x_return_status => l_return_status
55 , x_msg_count => l_msg_count
56 , x_msg_data => l_msg_data
57 );
58
59 RETURN l_sql_statement;
60
61 EXCEPTION
62 WHEN OTHERS THEN
63 NULL;
64 END getTimeLovSql;
65
66 PROCEDURE drillAcross( pUrlString IN VARCHAR2
67 , pUserId IN VARCHAR2 DEFAULT NULL
68 , pRespId IN VARCHAR2 DEFAULT NULL
69 , pSessionId IN VARCHAR2 DEFAULT NULL
70 , pFunctionName IN VARCHAR2 DEFAULT NULL
71 )
72 IS
73 BEGIN
74 BISVIEWER_PUB.showReport(
75 pUrlString
76 , pUserId
77 , pRespId
78 , pSessionId
79 , pFunctionName
80 );
81 END drillacross;
82
83 FUNCTION getHierarchyElementId (
84 pElementShortName IN VARCHAR2
85 , pDimensionShortName IN VARCHAR2
86 )
87 RETURN VARCHAR2
88 IS
89 vElementId NUMBER;
90 BEGIN
91 vElementId := BIS_PMV_UTIL.getHierarchyElementId (
92 pElementShortName
93 , pDimensionShortName
94 );
95 RETURN vElementId;
96 EXCEPTION
97 WHEN OTHERS THEN
98 RETURN 0;
99 END getHierarchyElementId;
100
101 FUNCTION getDimensionForAttribute (
102 pAttributecode IN VARCHAR2
103 , pRegionCode IN VARCHAR2
104 )
105 RETURN VARCHAR2
106 IS
107 l_attribute2 VARCHAR2(100);
108 BEGIN
109 l_attribute2 := BIS_PMV_UTIL.getDimensionForAttribute (
110 pAttributecode
111 , pRegionCode
112 );
113 RETURN l_attribute2;
114 EXCEPTION
115 WHEN OTHERS THEN
116 NULL;
117 END getDimensionForAttribute;
118
119 END BIS_PARAMETER_VALIDATION;