eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PMV_QUERY_PVT dependencies on BIS_PMV_PARAMETERS_PVT

Line 242: p_paramlvlparam_Tbl IN BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type,

238: END replace_prev_time_parameters;
239:
240: PROCEDURE retrieve_params_from_page (
241: p_user_session_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
242: p_paramlvlparam_Tbl IN BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type,
243: x_asof_date OUT NOCOPY VARCHAR2,
244: x_prev_asof_date OUT NOCOPY VARCHAR2,
245: x_time_comparison_type OUT NOCOPY VARCHAR2,
246: x_return_status out NOCOPY VARCHAR2,

Line 251: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

247: x_msg_count out NOCOPY NUMBER,
248: x_msg_data out NOCOPY VARCHAR2
249: ) IS
250:
251: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
252: BEGIN
253: -- retrieve the page level parameters
254:
255: l_parameter_rec := null;

Line 349: pParameterTbl IN BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

345:
346: -- replaces the time parameters
347: PROCEDURE replace_report_parameters(
348: p_user_session_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE ,
349: pParameterTbl IN BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
350: pStartChar IN CHAR DEFAULT '&',
351: pEndChar IN CHAR DEFAULT '',
352: pUseBindVariable In BOOLEAN DEFAULT true,
353: pReplaceSubstVariable In BOOLEAN DEFAULT true,

Line 369: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

365: x_bind_indexes IN OUT NOCOPY VARCHAR2,
366: x_bind_datatypes IN OUT NOCOPY VARCHAR2,
367: x_bind_count IN OUT NOCOPY NUMBER
368: ) IS
369: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
370: l_lookup_type varchar2(2000) := 'BIS_TIME_LEVEL_VALUES';
371: l_Dimlevel_Acronym varchar2(2000);
372: l_index number;
373: l_param_name VARCHAR2(32000);

Line 521: pParameterTbl IN BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE ,

517: /** substitute each of the dim+dimLevels of the params (parameterName) present in the where clause*/
518:
519: PROCEDURE replace_custom_sql(
520: p_user_session_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE ,
521: pParameterTbl IN BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE ,
522: p_original_sql in varchar2,
523: p_where IN OUT NOCOPY VARCHAR2,
524: x_bind_variables IN OUT NOCOPY VARCHAR2,
525: x_plsql_bind_variables IN OUT NOCOPY VARCHAR2,

Line 544: l_paramlvlparam_Tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type;

540: l_time_comparison_type_page varchar2(2000);
541: l_temp_start_date varchar2(2000);
542: l_temp_end_date varchar2(2000);
543:
544: l_paramlvlparam_Tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type;
545: BEGIN
546:
547:
548: replace_report_parameters(

Line 568: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PARAMLVL_PARAMETERS

564: ) ;
565:
566: IF (l_asof_date IS NULL OR l_time_comparison_type IS NULL) THEN
567:
568: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PARAMLVL_PARAMETERS
569: (p_user_session_Rec => p_user_session_rec
570: ,x_paramportlet_param_tbl => l_paramlvlparam_tbl
571: ,x_return_Status => x_return_Status
572: ,x_msg_count => x_msg_count

Line 701: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

697:
698:
699: -- parameter info from bis_user_attributes
700: l_user_session_rec BIS_PMV_SESSION_PVT.SESSION_REC_TYPE;
701: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
702: l_parameter_tbl BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE;
703:
704: -- report info from ak_regions_vl
705: CURSOR ak_region_cursor (cpRegionCode VARCHAR2) IS

Line 702: l_parameter_tbl BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE;

698:
699: -- parameter info from bis_user_attributes
700: l_user_session_rec BIS_PMV_SESSION_PVT.SESSION_REC_TYPE;
701: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
702: l_parameter_tbl BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE;
703:
704: -- report info from ak_regions_vl
705: CURSOR ak_region_cursor (cpRegionCode VARCHAR2) IS
706: SELECT attribute1 disable_viewby,

Line 895: BIS_PMV_PARAMETERS_PVT.RETRIEVE_SESSION_PARAMETERS

891:
892: --get parameter info from BIS_USER_ATTRIBUTES
893: if (p_schedule_id is null and p_source <> 'ACTUAL_FOR_KPI') or
894: (p_source = 'ACTUAL_FOR_KPI' and (p_page_id is null or p_page_id='')) then
895: BIS_PMV_PARAMETERS_PVT.RETRIEVE_SESSION_PARAMETERS
896: (p_user_session_rec => l_user_session_rec,
897: x_user_param_tbl => l_parameter_tbl,
898: x_return_status => l_return_status,
899: x_msg_count => l_msg_count,

Line 904: BIS_PMV_PARAMETERS_PVT.RETRIEVE_SCHEDULE_PARAMETERS

900: x_msg_data => l_msg_data
901: );
902: elsif p_page_id is null or p_page_id = '' then
903:
904: BIS_PMV_PARAMETERS_PVT.RETRIEVE_SCHEDULE_PARAMETERS
905: (p_schedule_id => p_schedule_id,
906: x_user_param_tbl => l_parameter_tbl,
907: x_return_status => l_return_status,
908: x_msg_count => l_msg_count,

Line 913: BIS_PMV_PARAMETERS_PVT.RETRIEVE_KPI_PARAMETERS

909: x_msg_data => l_msg_data
910: );
911: elsif p_source in ('ACTUAL','ACTUAL_FOR_KPI') then
912:
913: BIS_PMV_PARAMETERS_PVT.RETRIEVE_KPI_PARAMETERS
914: (p_user_session_rec => l_user_session_rec,
915: x_user_param_tbl => l_parameter_tbl,
916: x_return_status => l_return_status,
917: x_msg_count => l_msg_count,

Line 921: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PAGE_PARAMETERS

917: x_msg_count => l_msg_count,
918: x_msg_data => l_msg_data
919: );
920: else
921: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PAGE_PARAMETERS
922: (p_schedule_id => p_schedule_id,
923: p_user_session_rec => l_user_session_rec,
924: x_user_param_tbl => l_parameter_tbl,
925: x_return_status => l_return_status,

Line 1372: IF (l_parameter_rec.parameter_description = BIS_PMV_PARAMETERS_PVT.ROLLING_DIMENSION_DESCRIPTION AND l_parameter_rec.parameter_value is not null) THEN

1368: length(l_parameter_rec.parameter_name)-length('_HIERARCHY')+1) <> '_HIERARCHY') THEN
1369:
1370: if l_parameter_rec.dimension is not null and length(l_parameter_rec.dimension) > 0 then
1371: --serao - if rolling dimension - just append the base column name to the param value
1372: IF (l_parameter_rec.parameter_description = BIS_PMV_PARAMETERS_PVT.ROLLING_DIMENSION_DESCRIPTION AND l_parameter_rec.parameter_value is not null) THEN
1373: l_where := l_where || ' and SV.'||l_save_region_item_rec.base_column || ' '||l_parameter_rec.parameter_value||' ';
1374: ELSE
1375: --Fix for 2435613 and 2435528
1376: if l_parameter_rec.dimension in ('TIME', 'EDW_TIME_M') then

Line 1634: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE

1630: return l_format_string;
1631: end APPLY_DATA_FORMAT;
1632:
1633: function GET_CALCULATE_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
1634: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
1635: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
1636: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)
1637: return varchar2 is
1638: l_calculate_select varchar2(2000);

Line 1657: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE

1653: end GET_CALCULATE_SELECT;
1654:
1655: --not implemented yet!!
1656: function REPLACE_FORMULA(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
1657: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
1658: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
1659: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)
1660: return varchar2 is
1661: l_formula varchar2(2000);

Line 1735: p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

1731: -- added by serao -02/11/02 - orders dimensions one time while constructing the query
1732:
1733: PROCEDURE order_Dimensions(
1734: pSource In VARCHAR2,
1735: p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
1736: p_time_to_description in VARCHAR2,
1737: p_time_from_description in VARCHAR2,
1738: p_viewby_id_name IN VARCHAR2,
1739: p_viewby_dimension in VARCHAR2,

Line 1751: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

1747: x_bind_count in out NOCOPY NUMBER
1748: )
1749: IS
1750:
1751: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
1752:
1753: TYPE Dimension_Array IS TABLE OF VARCHAR2(80);
1754: l_dim_arr Dimension_Array := DImension_Array();
1755: l_dimLevel_arr Dimension_Array := DImension_Array();

Line 2737: p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

2733:
2734:
2735: procedure GET_TARGET_SELECT(p_user_session_rec in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
2736: p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC,
2737: p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
2738: p_report_type in VARCHAR2,
2739: p_plan_id in VARCHAR2,
2740: p_viewby_dimension in VARCHAR2,
2741: p_viewby_attribute2 in VARCHAR2,

Line 2753: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

2749: x_bind_count IN OUT NOCOPY NUMBER) is
2750: l_target_select varchar2(2000);
2751: l_no_target boolean := false;
2752: l_dimension_select varchar2(2000);
2753: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
2754: l_measure_short_name varchar2(2000);
2755: l_dimension_level varchar2(2000);
2756: l_count number;
2757: l_target_level_id NUMBER;

Line 2842: function GET_DIMENSION_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,

2838: x_no_target := l_no_target;
2839:
2840: end GET_TARGET_SELECT;
2841:
2842: function GET_DIMENSION_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,
2843: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,
2844: p_ak_region_rec in BIS_PMV_METADATA_PVT.AK_REGION_REC,
2845: p_org_dimension_level in VARCHAR2,
2846: p_org_dimension_level_value in VARCHAR2,

Line 2882: function GET_TIME_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,

2878: end if;
2879: return l_dimension_where;
2880: end GET_DIMENSION_WHERE;
2881:
2882: function GET_TIME_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,
2883: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,
2884: p_ak_region_rec in BIS_PMV_METADATA_PVT.AK_REGION_REC,
2885: p_org_dimension_level in VARCHAR2,
2886: p_org_dimension_level_value in VARCHAR2,

Line 3043: function GET_NON_TIME_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,

3039: end if;
3040: return l_time_label_where;
3041: end GET_TIME_LABEL_WHERE;
3042:
3043: function GET_NON_TIME_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,
3044: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,
3045: p_source in varchar2 default null,
3046: x_bind_variables in OUT NOCOPY VARCHAR2,
3047: --x_bind_indexes in OUT NOCOPY VARCHAR2,

Line 3100: function GET_NON_DIMENSION_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,

3096: end if;
3097: return l_non_time_where;
3098: end GET_NON_TIME_WHERE;
3099:
3100: function GET_NON_DIMENSION_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,
3101: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,
3102: x_bind_variables in OUT NOCOPY VARCHAR2,
3103: --x_bind_indexes in OUT NOCOPY VARCHAR2,
3104: x_bind_count in out NOCOPY number)

Line 3141: function GET_LOV_WHERE(p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

3137: end if;
3138: return l_non_dimension_where;
3139: end GET_NON_DIMENSION_WHERE;
3140:
3141: function GET_LOV_WHERE(p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
3142: p_where_clause in VARCHAR2,
3143: p_region_code in VARCHAR2 )
3144: return varchar2 is
3145: l_lov_where varchar2(2000) := p_where_clause;

Line 3153: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

3149: l_index2 number := 1;
3150: l_attribute_code varchar2(2000);
3151: l_attribute2 varchar2(2000);
3152: l_parameter_name varchar2(2000);
3153: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
3154: l_parameter_value varchar2(2000);
3155: l_parameter_description varchar2(2000);
3156: begin
3157: -- Fix for bug 2763327

Line 3738: l_parameter_rec BIS_PMV_PARAMETERS_PVT.parameter_rec_type ;

3734: ) IS
3735: l_return_status VARCHAR2(80);
3736: l_msg_count NUMBER;
3737: l_msg_data VARCHAR2(2000);
3738: l_parameter_rec BIS_PMV_PARAMETERS_PVT.parameter_rec_type ;
3739: l_user_session_rec BIS_PMV_SESSION_PVT.SESSION_REC_TYPE := pUserSession;
3740: BEGIN
3741:
3742: l_user_session_rec.page_id := null;

Line 3745: BIS_PMV_PARAMETERS_PVT.DELETE_SCHEDULE_PARAMETER

3741:
3742: l_user_session_rec.page_id := null;
3743: --delete the existing view by
3744: if (l_user_session_Rec.schedule_id is not null) then
3745: BIS_PMV_PARAMETERS_PVT.DELETE_SCHEDULE_PARAMETER
3746: (p_parameter_name => 'VIEW_BY'
3747: ,p_schedule_id => l_user_session_rec.schedule_id
3748: ,x_return_status => l_return_Status
3749: ,x_msg_count => l_msg_count

Line 3753: BIS_PMV_PARAMETERS_PVT.DELETE_PARAMETER( p_user_session_rec =>l_user_session_rec

3749: ,x_msg_count => l_msg_count
3750: ,x_msg_data => l_msg_Data
3751: );
3752: else
3753: BIS_PMV_PARAMETERS_PVT.DELETE_PARAMETER( p_user_session_rec =>l_user_session_rec
3754: ,p_parameter_name => 'VIEW_BY'
3755: ,p_schedule_option =>'NULL'
3756: ,x_return_status =>l_return_status
3757: ,x_msg_count => l_msg_count

Line 3786: BIS_PMV_PARAMETERS_PVT.CREATE_PARAMETER(p_user_session_rec =>l_user_session_rec

3782: sysdate, -1, sysdate, -1);
3783: commit;
3784: else
3785:
3786: BIS_PMV_PARAMETERS_PVT.CREATE_PARAMETER(p_user_session_rec =>l_user_session_rec
3787: ,p_parameter_rec => l_parameter_rec
3788: ,x_return_status => l_return_status
3789: ,x_msg_count => l_msg_count
3790: ,x_msg_Data => l_msg_data );

Line 3826: pParameterTbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

3822:
3823:
3824: procedure get_custom_sql (p_source in varchar2 DEFAULT 'REPORT',
3825: pAKRegionRec in BIS_PMV_METADATA_PVT.AK_REGION_REC,
3826: pParameterTbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
3827: pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
3828: p_sort_attribute in VARCHAR2 DEFAULT NULL,
3829: p_sort_direction in VARCHAR2 DEFAULT NULL,
3830: p_viewby_attribute2 VARCHAR2,

Line 3847: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

3843: x_view_by_value OUT NOCOPY VARCHAR2)
3844: IS
3845: l_custom_sql varchar2(32000);
3846: l_dynamic_sql_str varchar2(32000);
3847: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
3848: l_lookup_type varchar2(2000) := 'BIS_TIME_LEVEL_VALUES';
3849: l_Dimlevel_Acronym varchar2(2000);
3850: l_where_clause varchar2(2000);
3851: l_prev_start_Date date;

Line 3872: l_paramlvlparam_Tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type;

3868: l_prev_asof_date_page varchar2(2000) := to_char(sysdate,'DD-MON-YYYY');
3869: l_time_comparison_type varchar2(2000);
3870: l_time_comparison_page varchar2(2000);
3871: l_time_parameter varchar2(2000);
3872: l_paramlvlparam_Tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type;
3873: l_page_parameter_rec BIS_PMV_PAGE_PARAMETER_REC :=
3874: BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null); --msaran:4600562 - added null for operator
3875: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL := BIS_PMV_PAGE_PARAMETER_TBL();
3876: l_query_attributes_tbl BIS_QUERY_ATTRIBUTES_TBL := BIS_QUERY_ATTRIBUTES_TBL();

Line 3907: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PARAMLVL_PARAMETERS

3903:
3904: BEGIN
3905: /*
3906: --First get the special page level parameters.
3907: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PARAMLVL_PARAMETERS
3908: (p_user_session_Rec => pusersession
3909: ,x_paramportlet_param_tbl => l_paramlvlparam_tbl
3910: ,x_return_Status => x_return_Status
3911: ,x_msg_count => x_msg_count

Line 4501: l_parameter_tbl BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE;

4497: x_msg_count out NOCOPY NUMBER,
4498: x_msg_data out NOCOPY VARCHAR2
4499: ) IS
4500:
4501: l_parameter_tbl BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE;
4502: l_bind_variables VARCHAR2(1000);
4503: l_plsql_bind_variables VARCHAR2(1000);
4504: l_bind_indexes VARCHAR2(1000);
4505: l_bind_datatypes VARCHAR2(32000);

Line 4516: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PAGE_PARAMETERS

4512: IF (x_lov_where IS NOT NULL) THEN
4513: --check if it has any subs variables
4514: IF (instrb(x_lov_where, '{' ) > 0) THEN
4515:
4516: BIS_PMV_PARAMETERS_PVT.RETRIEVE_PAGE_PARAMETERS
4517: (p_schedule_id => pSchedule_id,
4518: p_user_session_rec => pUserSession_rec,
4519: x_user_param_tbl => l_parameter_tbl,
4520: x_return_status => x_return_status,