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_AK_REGION_PUB dependencies on AK_REGION_ITEMS

Line 40: -- 11/04/04 ankgoel Bug#3990675 - Call AK_REGION_ITEMS_PKG.UPDATE_ROW only

36: -- 09/24/04 mdamle Bug#3893663 - Return SQLERRM for all unexp errs --
37: -- Added rollback within the lock procedure --
38: -- 09/29/04 sawu Bug#3921384 - Nullify attribute1 when attribute2
39: -- is set to null for 'Compare to Measure No Target'
40: -- 11/04/04 ankgoel Bug#3990675 - Call AK_REGION_ITEMS_PKG.UPDATE_ROW only
41: -- AK Item exists
42: -- 11/05/04 ankgoel Bug#3937907 - Added AK_DATA_SET to verify if AK data
43: -- will be modified for the source and compare-to columns
44: -- 11/24/04 sawu Bug#4028958: added GET_COMPARE_AGG_FUNCTION,

Line 49: -- 01/08/05 mdamle Add Url to AK_REGION_ITEMS routines --

45: -- IS_VIEW_BY_REPORT, IS_AGGREGATE_DEFINED and
46: -- updated UPDATE_REGION_ITEM_ATTR, COMPARE_TYPE_AND_SHORTNAME
47: -- 11/29/04 skchoudh Bug#4028958 Replaces the Aggregate Function of
48: -- COMPARE_TO with Measure
49: -- 01/08/05 mdamle Add Url to AK_REGION_ITEMS routines --
50: -- 02/01/05 mdamle Add order_sequence, direction to AK_REGION_ITEMS --
51: -- 03/21/05 ankagarw bug#4235732 - changing count(*) to count(1) --
52: -- 04/26/05 ankagarw bug#4194925 - saving measure display name as --
53: -- attribute long label in ak_region_items --

Line 50: -- 02/01/05 mdamle Add order_sequence, direction to AK_REGION_ITEMS --

46: -- updated UPDATE_REGION_ITEM_ATTR, COMPARE_TYPE_AND_SHORTNAME
47: -- 11/29/04 skchoudh Bug#4028958 Replaces the Aggregate Function of
48: -- COMPARE_TO with Measure
49: -- 01/08/05 mdamle Add Url to AK_REGION_ITEMS routines --
50: -- 02/01/05 mdamle Add order_sequence, direction to AK_REGION_ITEMS --
51: -- 03/21/05 ankagarw bug#4235732 - changing count(*) to count(1) --
52: -- 04/26/05 ankagarw bug#4194925 - saving measure display name as --
53: -- attribute long label in ak_region_items --
54: -- 04/28/05 ankgoel Bug#4289493 - Truncated ak_object name to 23 chars

Line 53: -- attribute long label in ak_region_items --

49: -- 01/08/05 mdamle Add Url to AK_REGION_ITEMS routines --
50: -- 02/01/05 mdamle Add order_sequence, direction to AK_REGION_ITEMS --
51: -- 03/21/05 ankagarw bug#4235732 - changing count(*) to count(1) --
52: -- 04/26/05 ankagarw bug#4194925 - saving measure display name as --
53: -- attribute long label in ak_region_items --
54: -- 04/28/05 ankgoel Bug#4289493 - Truncated ak_object name to 23 chars
55: -- 19-MAY-2005 visuri GSCC Issues bug 4363854 --
56: -- 06/14/05 ankgoel Bug#4371653 - Region name not getting saved
57: -- 06/30/05 akoduri Bug#4370200 - Default Number of Rows not getting saved

Line 60: -- 06/19/06 ankgoel Bug#5256605 - Support MLS for AK Region Items --

56: -- 06/14/05 ankgoel Bug#4371653 - Region name not getting saved
57: -- 06/30/05 akoduri Bug#4370200 - Default Number of Rows not getting saved
58: -- 07/07/05 rpenneru Bug#4468843 - Synonym should be treated as a valid DB Object.
59: -- 07/14/05 adrao Bug#4448994 added API Get_Region_Code_TL_Data
60: -- 06/19/06 ankgoel Bug#5256605 - Support MLS for AK Region Items --
61: -- 09-Aug-06 ankgoel Bug#5412517 Del all customizations for a ak region
62: -- 10/20/06 akoduri Bug#5584162 - Enable Sort For Percent Of Total
63: ----------------------------------------------------------------------------
64:

Line 67: p_src_type IN Ak_Region_Items.ATTRIBUTE1%TYPE

63: ----------------------------------------------------------------------------
64:
65: --return true if the attribute types and measure levels are the same
66: FUNCTION COMPARE_TYPE_AND_SHORTNAME(
67: p_src_type IN Ak_Region_Items.ATTRIBUTE1%TYPE
68: ,p_src_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE
69: ,p_target_type IN Ak_Region_Items.ATTRIBUTE1%TYPE
70: ,p_target_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE
71: ) RETURN BOOLEAN

Line 68: ,p_src_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE

64:
65: --return true if the attribute types and measure levels are the same
66: FUNCTION COMPARE_TYPE_AND_SHORTNAME(
67: p_src_type IN Ak_Region_Items.ATTRIBUTE1%TYPE
68: ,p_src_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE
69: ,p_target_type IN Ak_Region_Items.ATTRIBUTE1%TYPE
70: ,p_target_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE
71: ) RETURN BOOLEAN
72: IS

Line 69: ,p_target_type IN Ak_Region_Items.ATTRIBUTE1%TYPE

65: --return true if the attribute types and measure levels are the same
66: FUNCTION COMPARE_TYPE_AND_SHORTNAME(
67: p_src_type IN Ak_Region_Items.ATTRIBUTE1%TYPE
68: ,p_src_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE
69: ,p_target_type IN Ak_Region_Items.ATTRIBUTE1%TYPE
70: ,p_target_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE
71: ) RETURN BOOLEAN
72: IS
73: BEGIN

Line 70: ,p_target_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE

66: FUNCTION COMPARE_TYPE_AND_SHORTNAME(
67: p_src_type IN Ak_Region_Items.ATTRIBUTE1%TYPE
68: ,p_src_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE
69: ,p_target_type IN Ak_Region_Items.ATTRIBUTE1%TYPE
70: ,p_target_short_name IN Ak_Region_Items.ATTRIBUTE2%TYPE
71: ) RETURN BOOLEAN
72: IS
73: BEGIN
74: RETURN ((p_src_type = p_target_type) AND (p_src_short_name = p_target_short_name));

Line 77: --return the aggregate_function (ak_region_items.attribute9) for referenced measure

73: BEGIN
74: RETURN ((p_src_type = p_target_type) AND (p_src_short_name = p_target_short_name));
75: END COMPARE_TYPE_AND_SHORTNAME;
76:
77: --return the aggregate_function (ak_region_items.attribute9) for referenced measure
78: --column for this particular compare_to ak_region_item
79: FUNCTION GET_COMPARE_AGG_FUNCTION(
80: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
81: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

Line 80: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE

76:
77: --return the aggregate_function (ak_region_items.attribute9) for referenced measure
78: --column for this particular compare_to ak_region_item
79: FUNCTION GET_COMPARE_AGG_FUNCTION(
80: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
81: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
82: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
83: ) RETURN Ak_Region_Items.ATTRIBUTE9%TYPE
84: IS

Line 81: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

77: --return the aggregate_function (ak_region_items.attribute9) for referenced measure
78: --column for this particular compare_to ak_region_item
79: FUNCTION GET_COMPARE_AGG_FUNCTION(
80: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
81: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
82: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
83: ) RETURN Ak_Region_Items.ATTRIBUTE9%TYPE
84: IS
85: l_ret_val Ak_Region_Items.ATTRIBUTE9%TYPE := NULL;

Line 82: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type

78: --column for this particular compare_to ak_region_item
79: FUNCTION GET_COMPARE_AGG_FUNCTION(
80: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
81: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
82: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
83: ) RETURN Ak_Region_Items.ATTRIBUTE9%TYPE
84: IS
85: l_ret_val Ak_Region_Items.ATTRIBUTE9%TYPE := NULL;
86:

Line 83: ) RETURN Ak_Region_Items.ATTRIBUTE9%TYPE

79: FUNCTION GET_COMPARE_AGG_FUNCTION(
80: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
81: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
82: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
83: ) RETURN Ak_Region_Items.ATTRIBUTE9%TYPE
84: IS
85: l_ret_val Ak_Region_Items.ATTRIBUTE9%TYPE := NULL;
86:
87: --need to take care when multiple attribute codes defined in the same report

Line 85: l_ret_val Ak_Region_Items.ATTRIBUTE9%TYPE := NULL;

81: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
82: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
83: ) RETURN Ak_Region_Items.ATTRIBUTE9%TYPE
84: IS
85: l_ret_val Ak_Region_Items.ATTRIBUTE9%TYPE := NULL;
86:
87: --need to take care when multiple attribute codes defined in the same report
88: CURSOR agg_cur IS
89: SELECT attribute9

Line 90: FROM ak_region_items

86:
87: --need to take care when multiple attribute codes defined in the same report
88: CURSOR agg_cur IS
89: SELECT attribute9
90: FROM ak_region_items
91: WHERE region_code = p_region_code
92: AND region_application_id = p_region_app_id
93: AND attribute_code = p_compare_code
94: AND attribute1 IN (BIS_AK_REGION_PUB.C_MEASURE, BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET);

Line 161: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which

157: EXCEPTION
158: WHEN OTHERS THEN RETURN false;
159: END VALIDATE_MEASURE;
160:
161: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which
162: --subsequently refers to a valid measure
163: FUNCTION VALIDATE_COMPARE(
164: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
165: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

Line 164: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE

160:
161: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which
162: --subsequently refers to a valid measure
163: FUNCTION VALIDATE_COMPARE(
164: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
165: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
166: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
167: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
168: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE

Line 165: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

161: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which
162: --subsequently refers to a valid measure
163: FUNCTION VALIDATE_COMPARE(
164: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
165: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
166: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
167: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
168: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
169: ) RETURN BOOLEAN

Line 166: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type

162: --subsequently refers to a valid measure
163: FUNCTION VALIDATE_COMPARE(
164: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
165: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
166: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
167: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
168: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
169: ) RETURN BOOLEAN
170: IS

Line 173: --need to handle the case when there are multiple ak_region_items in the same

169: ) RETURN BOOLEAN
170: IS
171: l_result BOOLEAN := false;
172:
173: --need to handle the case when there are multiple ak_region_items in the same
174: --report with the same attribute_code
175: CURSOR comp_cur IS
176: SELECT attribute2
177: FROM Ak_Region_Items

Line 177: FROM Ak_Region_Items

173: --need to handle the case when there are multiple ak_region_items in the same
174: --report with the same attribute_code
175: CURSOR comp_cur IS
176: SELECT attribute2
177: FROM Ak_Region_Items
178: WHERE REGION_CODE = p_region_code
179: AND REGION_APPLICATION_ID = p_region_app_id
180: AND ATTRIBUTE_CODE = p_compare_code
181: AND ATTRIBUTE1 IN (BIS_AK_REGION_PUB.C_MEASURE, BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET);

Line 471: l_url AK_REGION_ITEMS.URL%TYPE;

467:
468: l_display_value_length number;
469: l_attributeCount number;
470: l_attribute_rowid varchar2(50);
471: l_url AK_REGION_ITEMS.URL%TYPE;
472: l_nested_region_appl_id number;
473:
474: cursor cAttributeExists is
475: select count(1)

Line 556: AK_REGION_ITEMS_PKG.INSERT_ROW (

552: l_nested_region_appl_id := null;
553: end if;
554:
555:
556: AK_REGION_ITEMS_PKG.INSERT_ROW (
557: X_ROWID => X_ROWID,
558: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
559: X_REGION_CODE => upper(X_REGION_CODE),
560: X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,

Line 771: from ak_region_items_vl

767: attribute14,
768: attribute15,
769: attribute_label_short,
770: description
771: from ak_region_items_vl
772: where region_code = X_REGION_CODE
773: and region_application_id = X_REGION_APPLICATION_ID
774: and attribute_code = X_ATTRIBUTE_CODE
775: and attribute_application_id = X_ATTRIBUTE_APPLICATION_ID;

Line 870: AK_REGION_ITEMS_PKG.UPDATE_ROW (

866: if X_ORDER_DIRECTION <> BIS_COMMON_UTILS.G_DEF_CHAR then
867: l_regionItem_rec.order_direction := x_ORDER_DIRECTION;
868: end if;
869:
870: AK_REGION_ITEMS_PKG.UPDATE_ROW (
871: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
872: X_REGION_CODE => X_REGION_CODE,
873: X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
874: X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,

Line 973: AK_REGION_ITEMS_PKG.DELETE_ROW(

969: X_ATTRIBUTE_CODE IN VARCHAR2
970: ) IS
971: BEGIN
972:
973: AK_REGION_ITEMS_PKG.DELETE_ROW(
974: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
975: X_REGION_CODE => X_REGION_CODE,
976: X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
977: X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE

Line 1851: AK_REGION_ITEMS_PKG.INSERT_ROW (

1847: if (p_nested_region_code is null) then
1848: l_nested_region_appl_id := null;
1849: end if;
1850:
1851: AK_REGION_ITEMS_PKG.INSERT_ROW (
1852: X_ROWID => l_ROWID,
1853: X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
1854: X_REGION_CODE => upper(p_REGION_CODE),
1855: X_ATTRIBUTE_APPLICATION_ID => p_ATTRIBUTE_APPLICATION_ID,

Line 1976: l_Item_Style AK_REGION_ITEMS.ITEM_STYLE%TYPE;

1972: l_attribute_rowid VARCHAR2(30);
1973: l_attributeCount NUMBER;
1974: l_label_length NUMBER;
1975: l_rowid VARCHAR2(30);
1976: l_Item_Style AK_REGION_ITEMS.ITEM_STYLE%TYPE;
1977:
1978: CURSOR cAttributeExists IS
1979: SELECT COUNT(1)
1980: FROM ak_attributes

Line 2066: AK_REGION_ITEMS_PKG.INSERT_ROW (

2062: l_Item_Style := p_Region_Item_Rec.Item_Style;
2063: END IF;
2064:
2065:
2066: AK_REGION_ITEMS_PKG.INSERT_ROW (
2067: X_ROWID => l_rowid,
2068: X_REGION_APPLICATION_ID => p_region_application_id,
2069: X_REGION_CODE => UPPER(p_region_code),
2070: X_ATTRIBUTE_APPLICATION_ID => p_Region_Item_Rec.Attribute_Application_Id,

Line 2275: FROM ak_region_items_vl

2271: attribute14,
2272: attribute15,
2273: attribute_label_short,
2274: description
2275: FROM ak_region_items_vl
2276: WHERE region_code = p_region_code
2277: AND region_application_id = p_region_application_id
2278: AND attribute_code = p_Region_Item_Rec.Attribute_Code
2279: AND attribute_application_id = p_Region_Item_Rec.Attribute_Application_Id;

Line 2378: AK_REGION_ITEMS_PKG.UPDATE_ROW (

2374: ELSE
2375: l_label_length := LENGTH(p_Region_Item_Rec.Long_Label);
2376: END IF;
2377:
2378: AK_REGION_ITEMS_PKG.UPDATE_ROW (
2379: X_REGION_APPLICATION_ID => p_region_application_id,
2380: X_REGION_CODE => p_region_code,
2381: X_ATTRIBUTE_APPLICATION_ID => p_Region_Item_Rec.Attribute_Application_Id,
2382: X_ATTRIBUTE_CODE => p_Region_Item_Rec.Attribute_Code,

Line 2507: AK_REGION_ITEMS_PKG.DELETE_ROW(

2503: BEGIN
2504:
2505: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2506:
2507: AK_REGION_ITEMS_PKG.DELETE_ROW(
2508: X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
2509: X_REGION_CODE => p_REGION_CODE,
2510: X_ATTRIBUTE_APPLICATION_ID => p_ATTRIBUTE_APPLICATION_ID,
2511: X_ATTRIBUTE_CODE => p_ATTRIBUTE_CODE

Line 2606: from ak_region_items

2602: ) is
2603:
2604: cursor items_cursor IS
2605: select attribute_code, attribute_application_id
2606: from ak_region_items
2607: where region_code = p_REGION_CODE
2608: and region_application_id = p_REGION_APPLICATION_ID;
2609:
2610: begin

Line 2794: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE

2790:
2791: PROCEDURE GET_REGION_ITEM_REC
2792: ( p_region_code IN VARCHAR2
2793: , p_region_application_id IN NUMBER
2794: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
2795: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
2796: , x_Region_Item_Rec OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
2797: , x_return_status OUT NOCOPY VARCHAR2
2798: , x_msg_count OUT NOCOPY NUMBER

Line 2795: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

2791: PROCEDURE GET_REGION_ITEM_REC
2792: ( p_region_code IN VARCHAR2
2793: , p_region_application_id IN NUMBER
2794: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
2795: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
2796: , x_Region_Item_Rec OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
2797: , x_return_status OUT NOCOPY VARCHAR2
2798: , x_msg_count OUT NOCOPY NUMBER
2799: , x_msg_data OUT NOCOPY VARCHAR2

Line 2826: FROM ak_region_items_vl

2822: attribute10,
2823: attribute13,
2824: attribute8,
2825: attribute11
2826: FROM ak_region_items_vl
2827: WHERE region_code = p_region_code
2828: AND region_application_id = p_region_application_id
2829: AND attribute_code = p_Attribute_Code
2830: AND attribute_application_id = p_Attribute_Application_Id;

Line 2889: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE

2885: PROCEDURE UPDATE_REGION_ITEM_ATTR
2886: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
2887: , p_region_code IN VARCHAR2
2888: , p_region_application_id IN NUMBER
2889: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
2890: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
2891: , p_Short_Name IN VARCHAR2
2892: , x_return_status OUT NOCOPY VARCHAR2
2893: , x_msg_count OUT NOCOPY NUMBER

Line 2890: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

2886: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
2887: , p_region_code IN VARCHAR2
2888: , p_region_application_id IN NUMBER
2889: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
2890: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
2891: , p_Short_Name IN VARCHAR2
2892: , x_return_status OUT NOCOPY VARCHAR2
2893: , x_msg_count OUT NOCOPY NUMBER
2894: , x_msg_data OUT NOCOPY VARCHAR2

Line 2941: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE

2937: PROCEDURE UPDATE_REGION_ITEM_ATTR
2938: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
2939: , p_region_code IN VARCHAR2
2940: , p_region_application_id IN NUMBER
2941: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
2942: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
2943: , p_Short_Name IN VARCHAR2
2944: , p_type IN VARCHAR2
2945: , p_Meas_Name IN VARCHAR2

Line 2942: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

2938: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
2939: , p_region_code IN VARCHAR2
2940: , p_region_application_id IN NUMBER
2941: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
2942: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
2943: , p_Short_Name IN VARCHAR2
2944: , p_type IN VARCHAR2
2945: , p_Meas_Name IN VARCHAR2
2946: , x_return_status OUT NOCOPY VARCHAR2

Line 3126: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE

3122: -- SC - Source Column modified
3123: -- CC - Compare-to Column modified
3124: -- SSCC - Both Source and Compare-to columns modified
3125: FUNCTION AK_DATA_SET(
3126: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
3127: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
3128: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3129: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3130: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE

Line 3127: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

3123: -- CC - Compare-to Column modified
3124: -- SSCC - Both Source and Compare-to columns modified
3125: FUNCTION AK_DATA_SET(
3126: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
3127: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
3128: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3129: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3130: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
3131: ) RETURN VARCHAR2

Line 3128: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type

3124: -- SSCC - Both Source and Compare-to columns modified
3125: FUNCTION AK_DATA_SET(
3126: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
3127: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
3128: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3129: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3130: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
3131: ) RETURN VARCHAR2
3132: IS

Line 3129: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type

3125: FUNCTION AK_DATA_SET(
3126: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
3127: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
3128: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3129: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3130: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
3131: ) RETURN VARCHAR2
3132: IS
3133: ak_sc_modify BOOLEAN := TRUE;

Line 3141: FROM ak_region_items a

3137: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
3138:
3139: CURSOR attribute_cur(p_attr_code VARCHAR2) IS
3140: SELECT a.attribute2
3141: FROM ak_region_items a
3142: WHERE a.region_code = p_region_code
3143: AND a.region_application_id = p_region_app_id
3144: AND a.attribute1 IN ('MEASURE', 'MEASURE_NOTARGET')
3145: AND a.attribute_code = p_attr_code

Line 3150: FROM ak_region_items sc, ak_region_items cc

3146: AND a.attribute2 = p_measure_short_name;
3147:
3148: CURSOR compare_col_cur IS
3149: SELECT sc.attribute2
3150: FROM ak_region_items sc, ak_region_items cc
3151: WHERE sc.region_code = p_region_code
3152: AND sc.region_code = cc.region_code
3153: AND sc.region_application_id = p_region_app_id
3154: AND (sc.attribute1 IN ('MEASURE','MEASURE_NOTARGET') AND sc.attribute_code = p_source_code)

Line 3248: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE

3244:
3245: --return 'T' if at least one aggregate function is defined in any column
3246: --for the given report, 'F' otherwise
3247: FUNCTION IS_AGGREGATE_DEFINED(
3248: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
3249: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
3250: ) RETURN VARCHAR2
3251: IS
3252: l_count NUMBER := 0;

Line 3249: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

3245: --return 'T' if at least one aggregate function is defined in any column
3246: --for the given report, 'F' otherwise
3247: FUNCTION IS_AGGREGATE_DEFINED(
3248: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
3249: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
3250: ) RETURN VARCHAR2
3251: IS
3252: l_count NUMBER := 0;
3253: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;

Line 3256: FROM ak_region_items

3252: l_count NUMBER := 0;
3253: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;
3254: BEGIN
3255: SELECT COUNT(0) INTO l_count
3256: FROM ak_region_items
3257: WHERE region_code = p_region_code
3258: AND region_application_id = p_region_app_id
3259: AND attribute9 IS NOT NULL;
3260:

Line 3322: -- Bug#5256605 : Reset the display sequence of AK Region Items

3318: END IF;
3319: x_Return_Status := FND_API.G_RET_STS_ERROR;
3320: END Get_Region_Code_TL_Data;
3321:
3322: -- Bug#5256605 : Reset the display sequence of AK Region Items
3323: -- starting from -1 down below. This is done before updating all AK Items.
3324: PROCEDURE reset_ak_items_display_seq (
3325: p_region_code IN VARCHAR2
3326: , p_region_application_id IN NUMBER

Line 3335: FROM ak_region_items

3331: IS
3332: l_counter NUMBER;
3333: CURSOR cr_items IS
3334: SELECT attribute_code, attribute_application_id
3335: FROM ak_region_items
3336: WHERE region_code = p_region_code
3337: AND region_application_id = p_region_application_id;
3338:
3339: BEGIN

Line 3346: UPDATE ak_region_items

3342: END IF;
3343:
3344: l_counter := -1;
3345: FOR cr IN cr_items LOOP
3346: UPDATE ak_region_items
3347: SET display_sequence = l_counter
3348: WHERE attribute_code = cr.attribute_code
3349: AND attribute_application_id = cr.attribute_application_id
3350: AND region_code = p_region_code