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_METADATA_PVT

Line 717: l_ak_region_rec BIS_PMV_METADATA_PVT.AK_REGION_REC;

713: attribute11 where_clause
714: FROM AK_REGIONS
715: WHERE region_code = cpRegionCode;
716:
717: l_ak_region_rec BIS_PMV_METADATA_PVT.AK_REGION_REC;
718: l_ak_region_tbl BIS_PMV_METADATA_PVT.AK_REGION_TBL;
719:
720: /*
721: l_disable_viewby VARCHAR2(10);

Line 718: l_ak_region_tbl BIS_PMV_METADATA_PVT.AK_REGION_TBL;

714: FROM AK_REGIONS
715: WHERE region_code = cpRegionCode;
716:
717: l_ak_region_rec BIS_PMV_METADATA_PVT.AK_REGION_REC;
718: l_ak_region_tbl BIS_PMV_METADATA_PVT.AK_REGION_TBL;
719:
720: /*
721: l_disable_viewby VARCHAR2(10);
722: l_user_groupby VARCHAR2(2000);

Line 741: l_save_region_item_rec BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC;

737: or attribute2||'_FROM' = cpParameterName
738: or attribute2||'_TO' = cpParameterName)
739: ORDER BY display_sequence;
740:
741: l_save_region_item_rec BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC;
742:
743: -- report info from ak_region_items_vl
744: CURSOR ak_region_item_cursor (cpRegionCode VARCHAR2) IS
745: SELECT attribute1 attribute_type,

Line 764: l_ak_region_item_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC;

760: AND nested_region_code is null
761: ORDER BY display_sequence;
762:
763: l_item_count number;
764: l_ak_region_item_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC;
765: l_ak_region_item_tbl BIS_PMV_METADATA_PVT.AK_REGION_ITEM_TBL;
766: l_Ak_count number :=1;
767: l_base_column_tbl BISVIEWER.t_char;
768: l_aggregation_tbl BISVIEWER.t_char;

Line 765: l_ak_region_item_tbl BIS_PMV_METADATA_PVT.AK_REGION_ITEM_TBL;

761: ORDER BY display_sequence;
762:
763: l_item_count number;
764: l_ak_region_item_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC;
765: l_ak_region_item_tbl BIS_PMV_METADATA_PVT.AK_REGION_ITEM_TBL;
766: l_Ak_count number :=1;
767: l_base_column_tbl BISVIEWER.t_char;
768: l_aggregation_tbl BISVIEWER.t_char;
769:

Line 790: l_ak_region_item_ext_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_EXT_REC;

786: FROM BIS_AK_REGION_ITEM_EXTENSION
787: WHERE region_code = cpRegionCode
788: AND attribute_code = cpAttributeCode;
789:
790: l_ak_region_item_ext_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_EXT_REC;
791: l_ak_region_item_ext_tbl BIS_PMV_METADATA_PVT.AK_REGION_ITEM_EXT_TBL;
792:
793: --l_extra_groupby VARCHAR2(2000);
794: CURSOR base_col_cursor IS

Line 791: l_ak_region_item_ext_tbl BIS_PMV_METADATA_PVT.AK_REGION_ITEM_EXT_TBL;

787: WHERE region_code = cpRegionCode
788: AND attribute_code = cpAttributeCode;
789:
790: l_ak_region_item_ext_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_EXT_REC;
791: l_ak_region_item_ext_tbl BIS_PMV_METADATA_PVT.AK_REGION_ITEM_EXT_TBL;
792:
793: --l_extra_groupby VARCHAR2(2000);
794: CURSOR base_col_cursor IS
795: SELECT distinct attribute3 base_column, attribute9 aggregation_function

Line 1601: function GET_NORMAL_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC)

1597: x_bind_datatypes => x_bind_datatypes,
1598: x_view_by_value => x_view_by_value );
1599: end getQuery;
1600:
1601: function GET_NORMAL_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC)
1602: return varchar2 is
1603: l_select_string varchar2(2000);
1604: begin
1605: l_select_string := p_ak_region_item_rec.aggregate_function || '('

Line 1611: function APPLY_DATA_FORMAT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC)

1607: || p_ak_region_item_rec.attribute_code || '", ';
1608: return l_select_string;
1609: end GET_NORMAL_SELECT;
1610:
1611: function APPLY_DATA_FORMAT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC)
1612: return varchar2 is
1613: l_format_string varchar2(2000);
1614: l_default_date_format VARCHAR2(15) := 'DD-MON-RR';
1615: begin

Line 1633: function GET_CALCULATE_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC

1629: end if;
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

Line 1656: function REPLACE_FORMULA(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC

1652: return l_calculate_select;
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

Line 2736: p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC,

2732: END order_Dimensions;
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,

Line 2843: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,

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,
2847: p_viewby_dimension in VARCHAR2,

Line 2844: p_ak_region_rec in BIS_PMV_METADATA_PVT.AK_REGION_REC,

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,
2847: p_viewby_dimension in VARCHAR2,
2848: p_time_id_name in VARCHAR2,

Line 2883: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,

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,
2887: p_viewby_dimension in VARCHAR2,

Line 2884: p_ak_region_rec in BIS_PMV_METADATA_PVT.AK_REGION_REC,

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,
2887: p_viewby_dimension in VARCHAR2,
2888: p_time_id_name in VARCHAR2,

Line 3044: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,

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,
3048: x_bind_count in out NOCOPY number)

Line 3101: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,

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)
3105: return varchar2 is

Line 3409: pAKRegionRec in BIS_PMV_METADATA_PVT.AK_REGION_REC,

3405:
3406: /** Procedure to retun thre order by clause for given metadata and parmeters */
3407: procedure get_order_by_clause(
3408: p_source in varchar2 DEFAULT 'REPORT',
3409: pAKRegionRec in BIS_PMV_METADATA_PVT.AK_REGION_REC,
3410: pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
3411: p_sort_attribute in VARCHAR2 DEFAULT NULL,
3412: p_sort_direction in VARCHAR2 DEFAULT NULL,
3413: p_viewby_attribute2 IN VARCHAR2,

Line 3419: l_ak_region_item_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC;

3415: p_viewby_dimension_level In VARCHAR2,
3416: x_order_by OUT NOCOPY VARCHAR2
3417:
3418: ) IS
3419: l_ak_region_item_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC;
3420: l_view_by_attr2 VARCHAR2(80);
3421: l_view_by_attr_code VARCHAR2(80);
3422: l_main_order_by VARCHAR2(100) :=NULL;
3423: l_first_order_by VARCHAR2(100) := NULL;

Line 3825: pAKRegionRec in BIS_PMV_METADATA_PVT.AK_REGION_REC,

3821: END process_custom_output;
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,

Line 3859: l_save_region_item_rec BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC;

3855: l_temp_start_date varchar2(2000);
3856: l_temp_end_date varchar2(2000);
3857: l_description varchar2(32000);
3858: l_time_id varchar2(32000);
3859: l_save_region_item_rec BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC;
3860: l_bind_count number := 0;
3861: l_where varchar2(32000);
3862: l_bind_variables varchar2(32000);
3863: l_bind_indexes varchar2(32000);