APPS.BIS_PMV_PARAMETERS_PVT dependencies on AK_REGION_ITEMS

Line 318: FROM ak_region_items

314: l_region_code VARCHAR2(30);
315:
316: cursor getNestedRegionCode (cpRegionCode varchar2) is
317: SELECT nested_region_code
318: FROM ak_region_items
319: WHERE region_code = cpRegionCode
320: AND nested_region_code IS NOT NULL;
321: --ashgarg Bug 3878112: get Data Source
322: cursor getDataSource (cpRegionCode varchar2) is

Line 368: FROM ak_region_items

364: end if;
365:
366: SELECT attribute2, attribute_code, display_sequence, attribute4
367: BULK COLLECT INTO ldef_attr2_table, ldef_attr_code_table, lDef_disp_seq, lLov_where_table
368: FROM ak_region_items
369: WHERE region_code = l_region_code -- pRegionCode
370: AND NODE_QUERY_FLAG = 'Y'
371: ORDER BY DISPLAY_SEQUENCE;
372:

Line 2060: ( select attribute_code from ak_region_items akItems

2056: cursor c_rolling_dim is
2057: select attribute17 from bis_ak_region_item_extension ext
2058: where ext.region_code=p_user_session_rec.region_code
2059: and attribute_code =
2060: ( select attribute_code from ak_region_items akItems
2061: where akItems.region_code= ext.region_code
2062: and nvl(akItems.attribute2, akItems.attribute_code) = p_parameter_rec.parameter_name);
2063:
2064: BEGIN

Line 2233: from ak_region_items vl, ak_regions r

2229: cursor c_level_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
2230: select vl.attribute15, -- level view name
2231: substr(vl.attribute2, instr(vl.attribute2,'+')+1), -- dimension level
2232: nvl(r.region_object_type, 'OLTP') -- level type
2233: from ak_region_items vl, ak_regions r
2234: where nvl(vl.attribute2,vl.attribute_code) = rtrim(cp_parameter_name)
2235: and vl.region_code = rtrim(cp_region_code)
2236: and vl.region_code = r.region_code;
2237:

Line 2948: from ak_region_items

2944:
2945: /*
2946: cursor lov_where_cursor (cpRegionCode varchar2, cpAttr2 varchar2) is
2947: select attribute4
2948: from ak_region_items
2949: where region_code = cpRegionCode
2950: and attribute2 = cpAttr2;
2951: */
2952: BEGIN

Line 4053: from ak_region_items_vl

4049:
4050: /*
4051: cursor c_level_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
4052: select attribute15 level_values_view_name, substr(attribute2, 1, instr(attribute2, '+')-1) dimension ,substr(attribute2,instr(attribute2, '+')+1) dimension_level
4053: from ak_region_items_vl
4054: where nvl(attribute2,attribute_code) = rtrim(cp_parameter_name)
4055: and region_code = rtrim(cp_region_code);
4056:
4057: ----GSANAP for EDW purposes 10/17/00

Line 4060: from ak_region_items_vl vl, ak_regions r

4056:
4057: ----GSANAP for EDW purposes 10/17/00
4058: cursor c_edw_level_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
4059: select vl.attribute15 level_values_view_name, substr(vl.attribute2, instr(vl.attribute2, '+')+1) dimension_level
4060: from ak_region_items_vl vl, ak_regions r
4061: where nvl(vl.attribute2,vl.attribute_code) LIKE rtrim(cp_parameter_name)
4062: and vl.region_code = rtrim(cp_region_code)
4063: and vl.region_code = r.region_code
4064: and lower(r.region_object_type) = 'edw' ;

Line 4075: from ak_region_items vl, ak_regions r

4071: substr(vl.attribute2, 1, instr(vl.attribute2,'+')-1), -- dimension
4072: substr(vl.attribute2, instr(vl.attribute2,'+')+1), -- dimension level
4073: nvl(r.region_object_type, 'OLTP'), -- level type
4074: vl.attribute4 -- lov where clause
4075: from ak_region_items vl, ak_regions r
4076: where nvl(vl.attribute2,vl.attribute_code) = rtrim(cp_parameter_name)
4077: and vl.region_code = rtrim(cp_region_code)
4078: and vl.region_code = r.region_code;
4079:

Line 4375: from ak_region_items_vl

4371:
4372: /*
4373: cursor c_level_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
4374: select attribute15 level_values_view_name, substr(attribute2,instr(attribute2, '+')+1) dimension_level
4375: from ak_region_items_vl
4376: where nvl(attribute2,attribute_code) = rtrim(cp_parameter_name)
4377: and region_code = rtrim(cp_region_code);
4378:
4379: ----GSANAP for EDW purposes 10/17/00

Line 4382: from ak_region_items_vl vl, ak_regions r

4378:
4379: ----GSANAP for EDW purposes 10/17/00
4380: cursor c_edw_tmlvl_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
4381: select vl.attribute15 edw_level_values_view_name, substr(vl.attribute2, instr(vl.attribute2, '+')+1) dimension_level
4382: from ak_region_items_vl vl, ak_regions r
4383: where nvl(vl.attribute2,vl.attribute_code) LIKE rtrim(cp_parameter_name)
4384: and vl.region_code = rtrim(cp_region_code)
4385: and vl.region_code = r.region_code
4386: and lower(r.region_object_type) = 'edw';

Line 4393: from ak_region_items vl, ak_regions r

4389: cursor c_tmlvl_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
4390: select vl.attribute15, -- view name
4391: substr(vl.attribute2, instr(vl.attribute2, '+')+1), -- dimension level
4392: nvl(r.region_object_type, 'OLTP') -- level type
4393: from ak_region_items vl, ak_regions r
4394: where nvl(vl.attribute2,vl.attribute_code) = rtrim(cp_parameter_name)
4395: and vl.region_code = rtrim(cp_region_code)
4396: and vl.region_code = r.region_code;
4397:

Line 4400: from ak_region_items

4396: and vl.region_code = r.region_code;
4397:
4398: cursor c_nested_region(cp_region_code varchar2) is
4399: select nested_region_code
4400: from ak_region_items
4401: where region_code = cp_region_code
4402: and nested_region_code is not null;
4403:
4404: v_edw_tmlvl_values_view_name varchar2(2000) := null;

Line 6061: FROM ak_region_items a, bis_ak_region_item_extension c

6057: */
6058: -- nbarik - 03/29/04 - Parameter Validation while navigating through related links
6059: CURSOR c_validation_parameters IS
6060: SELECT a.attribute2, c.attribute26
6061: FROM ak_region_items a, bis_ak_region_item_extension c
6062: WHERE a.region_code=pParamRegionCode AND a.attribute_code=c.attribute_code(+) AND a.region_code=c.region_code(+);
6063:
6064: lValidationAttrList BISVIEWER.t_char;
6065: lValidationReqList BISVIEWER.t_char;