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_PUB

Line 1: PACKAGE BODY BIS_AK_REGION_PUB as

1: PACKAGE BODY BIS_AK_REGION_PUB as
2: /* $Header: BISPAKRB.pls 120.7.12000000.3 2007/01/31 18:42:32 akoduri ship $ */
3: ----------------------------------------------------------------------------
4: -- PACKAGE: BIS_AK_REGION_PUB --
5: -- --

Line 4: -- PACKAGE: BIS_AK_REGION_PUB --

1: PACKAGE BODY BIS_AK_REGION_PUB as
2: /* $Header: BISPAKRB.pls 120.7.12000000.3 2007/01/31 18:42:32 akoduri ship $ */
3: ----------------------------------------------------------------------------
4: -- PACKAGE: BIS_AK_REGION_PUB --
5: -- --
6: -- DESCRIPTION: Private package that calls the AK packages to --
7: -- insert/update/delete records in the AK tables. --
8: --

Line 94: AND attribute1 IN (BIS_AK_REGION_PUB.C_MEASURE, BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET);

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);
95:
96: BEGIN
97: --retrive the first such aggregate function
98: FOR rec IN agg_cur LOOP

Line 116: RETURN (p_attribute_type = BIS_AK_REGION_PUB.C_MEASURE) OR (p_attribute_type = BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET);

112: p_attribute_type IN VARCHAR2
113: ) RETURN BOOLEAN
114: IS
115: BEGIN
116: RETURN (p_attribute_type = BIS_AK_REGION_PUB.C_MEASURE) OR (p_attribute_type = BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET);
117: END IS_MEASURE_TYPE;
118:
119: --return true if and only if p_attribute_type is C_COMPARE_TO_MEASURE_NO_TARGET
120: FUNCTION IS_COMPARE_TYPE(

Line 125: RETURN (p_attribute_type = BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET);

121: p_attribute_type IN VARCHAR2
122: ) RETURN BOOLEAN
123: IS
124: BEGIN
125: RETURN (p_attribute_type = BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET);
126: END IS_COMPARE_TYPE;
127:
128: --return true if and only if given measure short name exists
129: FUNCTION VALIDATE_MEASURE(

Line 181: AND ATTRIBUTE1 IN (BIS_AK_REGION_PUB.C_MEASURE, BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET);

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);
182: BEGIN
183: IF (p_compare_code IS NOT NULL) THEN
184: FOR rec IN comp_cur LOOP
185: l_result := VALIDATE_MEASURE(p_short_name => rec.attribute2, x_measure_short_name => x_measure_short_name, x_measure_name => x_measure_name);

Line 306: l_region_rec AK_REGION_PUB.Region_Rec_Type;

302: X_ATTRIBUTE13 in VARCHAR2,
303: X_ATTRIBUTE14 in VARCHAR2,
304: X_ATTRIBUTE15 in VARCHAR2) is
305:
306: l_region_rec AK_REGION_PUB.Region_Rec_Type;
307:
308: cursor cRegion is
309: select icx_custom_call,
310: num_columns,

Line 692: l_regionItem_rec AK_REGION_PUB.Item_Rec_Type;

688: X_ORDER_SEQUENCE in VARCHAR2 := NULL,
689: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR)
690: is
691:
692: l_regionItem_rec AK_REGION_PUB.Item_Rec_Type;
693:
694: cursor cRegionItem is
695: select display_sequence,
696: bold,

Line 1083: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_ROW: ' || SQLERRM;

1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1081: ,p_data => x_msg_data);
1082: if (x_msg_data is null) then
1083: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_ROW: ' || SQLERRM;
1084: end if;
1085:
1086: end INSERT_REGION_ROW;
1087:

Line 1091: , p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type

1087:
1088: -- nbarik 02/10/04 - overloaded for region record type
1089: PROCEDURE INSERT_REGION_ROW
1090: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
1091: , p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type
1092: , x_return_status OUT NOCOPY VARCHAR2
1093: , x_msg_count OUT NOCOPY NUMBER
1094: , x_msg_data OUT NOCOPY VARCHAR2
1095: ) IS

Line 1169: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ROW: ' || SQLERRM;

1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1167: ,p_data => x_msg_data);
1168: IF (x_msg_data IS NULL) THEN
1169: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ROW: ' || SQLERRM;
1170: END IF;
1171:
1172: END INSERT_REGION_ROW;
1173:

Line 1203: l_region_rec AK_REGION_PUB.Region_Rec_Type;

1199: ,x_msg_count OUT NOCOPY NUMBER
1200: ,x_msg_data OUT NOCOPY VARCHAR2
1201: ) is
1202:
1203: l_region_rec AK_REGION_PUB.Region_Rec_Type;
1204:
1205: cursor cRegion is
1206: select icx_custom_call,
1207: num_columns,

Line 1436: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;

1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1434: ,p_data => x_msg_data);
1435: if (x_msg_data is null) then
1436: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;
1437: end if;
1438:
1439: end UPDATE_REGION_ROW;
1440:

Line 1444: , p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type

1440:
1441: -- nbarik 02/10/04 - overloaded for region record type
1442: PROCEDURE UPDATE_REGION_ROW
1443: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
1444: , p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type
1445: , x_return_status OUT NOCOPY VARCHAR2
1446: , x_msg_count OUT NOCOPY NUMBER
1447: , x_msg_data OUT NOCOPY VARCHAR2
1448: ) IS

Line 1450: l_region_rec AK_REGION_PUB.Region_Rec_Type;

1446: , x_msg_count OUT NOCOPY NUMBER
1447: , x_msg_data OUT NOCOPY VARCHAR2
1448: ) IS
1449:
1450: l_region_rec AK_REGION_PUB.Region_Rec_Type;
1451:
1452: CURSOR cRegion IS
1453: SELECT icx_custom_call,
1454: num_columns,

Line 1680: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;

1676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1678: ,p_data => x_msg_data);
1679: IF (x_msg_data IS NULL) THEN
1680: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;
1681: END IF;
1682:
1683: END UPDATE_REGION_ROW;
1684:

Line 1717: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ROW: ' || SQLERRM;

1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1715: ,p_data => x_msg_data);
1716: if (x_msg_data is null) then
1717: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ROW: ' || SQLERRM;
1718: end if;
1719:
1720: END DELETE_REGION_ROW;
1721:

Line 1957: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;

1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1955: ,p_data => x_msg_data);
1956: if (x_msg_data is null) then
1957: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;
1958: end if;
1959:
1960: end INSERT_REGION_ITEM_ROW;
1961:

Line 1967: , p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type

1963: PROCEDURE INSERT_REGION_ITEM_ROW
1964: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
1965: , p_region_code IN VARCHAR2
1966: , p_region_application_id IN NUMBER
1967: , p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
1968: , x_return_status OUT NOCOPY VARCHAR2
1969: , x_msg_count OUT NOCOPY NUMBER
1970: , x_msg_data OUT NOCOPY VARCHAR2
1971: ) IS

Line 2176: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;

2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2173: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2174: ,p_data => x_msg_data);
2175: IF (x_msg_data IS NULL) THEN
2176: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;
2177: END IF;
2178:
2179: END INSERT_REGION_ITEM_ROW;
2180:

Line 2187: , p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type

2183: PROCEDURE UPDATE_REGION_ITEM_ROW
2184: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
2185: , p_region_code IN VARCHAR2
2186: , p_region_application_id IN NUMBER
2187: , p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
2188: , x_return_status OUT NOCOPY VARCHAR2
2189: , x_msg_count OUT NOCOPY NUMBER
2190: , x_msg_data OUT NOCOPY VARCHAR2
2191: ) IS

Line 2193: l_regionItem_rec AK_REGION_PUB.Item_Rec_Type;

2189: , x_msg_count OUT NOCOPY NUMBER
2190: , x_msg_data OUT NOCOPY VARCHAR2
2191: ) IS
2192:
2193: l_regionItem_rec AK_REGION_PUB.Item_Rec_Type;
2194: l_label_length NUMBER;
2195:
2196: CURSOR cRegionItem IS
2197: SELECT display_sequence,

Line 2487: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW: ' || SQLERRM;

2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2484: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2485: ,p_data => x_msg_data);
2486: IF (x_msg_data IS NULL) THEN
2487: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW: ' || SQLERRM;
2488: END IF;
2489:
2490: END UPDATE_REGION_ITEM_ROW;
2491:

Line 2528: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW: ' || SQLERRM;

2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2525: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2526: ,p_data => x_msg_data);
2527: if (x_msg_data is null) then
2528: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW: ' || SQLERRM;
2529: end if;
2530:
2531: END DELETE_REGION_ITEM_ROW;
2532:

Line 2552: BIS_AK_REGION_PUB.DELETE_REGION_ROW(

2548: x_msg_count => x_msg_count,
2549: x_msg_data =>x_msg_data);
2550:
2551:
2552: BIS_AK_REGION_PUB.DELETE_REGION_ROW(
2553: p_REGION_CODE => p_REGION_CODE ,
2554: p_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
2555: x_return_status => x_return_status,
2556: x_msg_count => x_msg_count,

Line 2589: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_AND_REGION_ITEMS: ' || SQLERRM;

2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2587: ,p_data => x_msg_data);
2588: if (x_msg_data is null) then
2589: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_AND_REGION_ITEMS: ' || SQLERRM;
2590: end if;
2591:
2592:
2593: END DELETE_REGION_AND_REGION_ITEMS;

Line 2616: BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW(

2612: close items_cursor;
2613: end if;
2614:
2615: for cr in items_cursor loop
2616: BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW(
2617: p_REGION_CODE => p_REGION_CODE,
2618: p_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
2619: p_ATTRIBUTE_CODE => cr.attribute_code,
2620: p_ATTRIBUTE_APPLICATION_ID => cr.attribute_application_id,

Line 2640: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEMS: ' || SQLERRM;

2636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2637: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2638: ,p_data => x_msg_data);
2639: if (x_msg_data is null) then
2640: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEMS: ' || SQLERRM;
2641: end if;
2642:
2643:
2644: END DELETE_REGION_ITEMS;

Line 2696: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_EXT_ITEMS: ' || SQLERRM;

2692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2694: ,p_data => x_msg_data);
2695: if (x_msg_data is null) then
2696: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_EXT_ITEMS: ' || SQLERRM;
2697: end if;
2698:
2699:
2700: END DELETE_EXT_REGION_ITEMS;

Line 2796: , x_Region_Item_Rec OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type

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
2800: ) IS

Line 2879: x_msg_data := 'BIS_AK_REGION_PUB.GET_REGION_ITEM_REC: ' || SQLERRM;

2875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2876: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2877: ,p_data => x_msg_data);
2878: IF (x_msg_data IS NULL) THEN
2879: x_msg_data := 'BIS_AK_REGION_PUB.GET_REGION_ITEM_REC: ' || SQLERRM;
2880: END IF;
2881: END GET_REGION_ITEM_REC;
2882:
2883:

Line 2897: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;

2893: , x_msg_count OUT NOCOPY NUMBER
2894: , x_msg_data OUT NOCOPY VARCHAR2
2895: ) IS
2896:
2897: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
2898: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
2899: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
2900: l_msg_data VARCHAR2(300);
2901: l_msg_count NUMBER;

Line 2908: BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR

2904: BEGIN
2905: -- Save the current data
2906: x_return_status := FND_API.G_RET_STS_SUCCESS;
2907:
2908: BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR
2909: ( p_commit => p_commit
2910: , p_region_code => p_region_code
2911: , p_region_application_id => p_region_application_id
2912: , p_Attribute_Code => p_Attribute_Code

Line 2931: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;

2927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2928: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2929: ,p_data => x_msg_data);
2930: IF (x_msg_data IS NULL) THEN
2931: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;
2932: END IF;
2933: END UPDATE_REGION_ITEM_ATTR;
2934:
2935: --bug#3859267: overloaded to take in p_type, which is one of

Line 2951: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;

2947: , x_msg_count OUT NOCOPY NUMBER
2948: , x_msg_data OUT NOCOPY VARCHAR2
2949: ) IS
2950:
2951: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
2952: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
2953: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
2954: l_msg_data VARCHAR2(300);
2955: l_msg_count NUMBER;

Line 2964: (p_type <> BIS_AK_REGION_PUB.C_MEASURE) AND

2960: -- Save the current data
2961: x_return_status := FND_API.G_RET_STS_SUCCESS;
2962: --make sure p_type is recognized
2963: IF ((p_type IS NOT NULL) AND
2964: (p_type <> BIS_AK_REGION_PUB.C_MEASURE) AND
2965: (p_type <> BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET) AND
2966: (p_type <> BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET)) THEN
2967: RAISE FND_API.G_EXC_ERROR;
2968: END IF;

Line 2965: (p_type <> BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET) AND

2961: x_return_status := FND_API.G_RET_STS_SUCCESS;
2962: --make sure p_type is recognized
2963: IF ((p_type IS NOT NULL) AND
2964: (p_type <> BIS_AK_REGION_PUB.C_MEASURE) AND
2965: (p_type <> BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET) AND
2966: (p_type <> BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET)) THEN
2967: RAISE FND_API.G_EXC_ERROR;
2968: END IF;
2969:

Line 2966: (p_type <> BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET)) THEN

2962: --make sure p_type is recognized
2963: IF ((p_type IS NOT NULL) AND
2964: (p_type <> BIS_AK_REGION_PUB.C_MEASURE) AND
2965: (p_type <> BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET) AND
2966: (p_type <> BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET)) THEN
2967: RAISE FND_API.G_EXC_ERROR;
2968: END IF;
2969:
2970: BIS_AK_REGION_PUB.GET_REGION_ITEM_REC

Line 2970: BIS_AK_REGION_PUB.GET_REGION_ITEM_REC

2966: (p_type <> BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET)) THEN
2967: RAISE FND_API.G_EXC_ERROR;
2968: END IF;
2969:
2970: BIS_AK_REGION_PUB.GET_REGION_ITEM_REC
2971: ( p_region_code => p_region_code
2972: , p_region_application_id => p_region_application_id
2973: , p_Attribute_Code => p_Attribute_Code
2974: , p_Attribute_Application_Id => p_Attribute_Application_Id

Line 2987: l_type := BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET;

2983: END IF;
2984:
2985: --set type
2986: IF (p_type IS NULL) THEN
2987: l_type := BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET;
2988: ELSE
2989: l_type := p_type;
2990: END IF;
2991:

Line 2994: l_Region_Item_Rec.Attribute_Type := BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET;

2990: END IF;
2991:
2992: --check attribute1
2993: IF (BIS_UTILITIES_PUB.Value_Missing(l_Region_Item_Rec.Attribute_Type) = FND_API.G_TRUE) THEN
2994: l_Region_Item_Rec.Attribute_Type := BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET;
2995: END IF;
2996:
2997: --set attribute2
2998: IF (BIS_UTILITIES_PUB.Value_Missing(p_Short_Name) = FND_API.G_TRUE) THEN

Line 3033: l_Region_Item_Rec.Aggregate_Function := BIS_AK_REGION_PUB.C_SUM;

3029: --handle measure type here:
3030: IF (IS_MEASURE_TYPE(l_Region_Item_Rec.Attribute_Type) = TRUE) THEN
3031: --if veiw based and view by report, for measure type, if attribute9 is null, set it to 'SUM'
3032: IF (IS_VIEW_BY_REPORT(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN
3033: l_Region_Item_Rec.Aggregate_Function := BIS_AK_REGION_PUB.C_SUM;
3034: ELSIF (IS_AGGREGATE_DEFINED(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN
3035: --if view based and non-view by report, for measure type, if attribute9 is null,
3036: --check if any other column in the same report has non-null attribute9, is so, set this measure column to 'SUM'
3037: l_Region_Item_Rec.Aggregate_Function := BIS_AK_REGION_PUB.C_SUM;

Line 3037: l_Region_Item_Rec.Aggregate_Function := BIS_AK_REGION_PUB.C_SUM;

3033: l_Region_Item_Rec.Aggregate_Function := BIS_AK_REGION_PUB.C_SUM;
3034: ELSIF (IS_AGGREGATE_DEFINED(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN
3035: --if view based and non-view by report, for measure type, if attribute9 is null,
3036: --check if any other column in the same report has non-null attribute9, is so, set this measure column to 'SUM'
3037: l_Region_Item_Rec.Aggregate_Function := BIS_AK_REGION_PUB.C_SUM;
3038: END IF;
3039:
3040: --handle compare type here:
3041: ELSIF (IS_COMPARE_TYPE(l_Region_Item_Rec.Attribute_Type) = TRUE) THEN

Line 3051: BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW

3047:
3048: END IF;
3049: END IF;
3050:
3051: BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW
3052: ( p_commit => p_commit
3053: , p_region_code => p_region_code
3054: , p_region_application_id => p_region_application_id
3055: , p_Region_Item_Rec => l_Region_Item_Rec

Line 3071: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;

3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3068: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3069: ,p_data => x_msg_data);
3070: IF (x_msg_data IS NULL) THEN
3071: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;
3072: END IF;
3073: END UPDATE_REGION_ITEM_ATTR;
3074:
3075: PROCEDURE LOCK_REGION_ROW

Line 3101: x_record_status := BIS_AK_REGION_PUB.c_RECORD_DELETED;

3097: OPEN cRegion;
3098: FETCH cRegion INTO l_last_update_date;
3099:
3100: if (cRegion%notfound) then
3101: x_record_status := BIS_AK_REGION_PUB.c_RECORD_DELETED;
3102: end if;
3103:
3104: if p_last_update_date is not null then
3105: if p_last_update_date <> TO_CHAR(l_last_update_date, BIS_AK_REGION_PUB.C_LAST_UPDATE_DATE_FORMAT) then

Line 3105: if p_last_update_date <> TO_CHAR(l_last_update_date, BIS_AK_REGION_PUB.C_LAST_UPDATE_DATE_FORMAT) then

3101: x_record_status := BIS_AK_REGION_PUB.c_RECORD_DELETED;
3102: end if;
3103:
3104: if p_last_update_date is not null then
3105: if p_last_update_date <> TO_CHAR(l_last_update_date, BIS_AK_REGION_PUB.C_LAST_UPDATE_DATE_FORMAT) then
3106: x_record_status := BIS_AK_REGION_PUB.c_RECORD_CHANGED;
3107: end if;
3108: end if;
3109:

Line 3106: x_record_status := BIS_AK_REGION_PUB.c_RECORD_CHANGED;

3102: end if;
3103:
3104: if p_last_update_date is not null then
3105: if p_last_update_date <> TO_CHAR(l_last_update_date, BIS_AK_REGION_PUB.C_LAST_UPDATE_DATE_FORMAT) then
3106: x_record_status := BIS_AK_REGION_PUB.c_RECORD_CHANGED;
3107: end if;
3108: end if;
3109:
3110: rollback to SP_LOCK_REGION_ROW;

Line 3117: x_record_status := BIS_AK_REGION_PUB.c_RECORD_CHANGED;

3113:
3114: EXCEPTION
3115: WHEN OTHERS THEN
3116: close cRegion;
3117: x_record_status := BIS_AK_REGION_PUB.c_RECORD_CHANGED;
3118: rollback to SP_LOCK_REGION_ROW;
3119: END LOCK_REGION_ROW;
3120:
3121: -- ankgoel: bug#3937907 - Verify if AK data will be modified or not for the current source and compare-to column only

Line 3317: x_msg_data := SQLERRM || ' at BIS_AK_REGION_PUB.Get_Region_Code_TL_Data ';

3313:
3314: EXCEPTION
3315: WHEN OTHERS THEN
3316: IF (x_msg_data IS NULL) THEN
3317: x_msg_data := SQLERRM || ' at BIS_AK_REGION_PUB.Get_Region_Code_TL_Data ';
3318: END IF;
3319: x_Return_Status := FND_API.G_RET_STS_ERROR;
3320: END Get_Region_Code_TL_Data;
3321:

Line 3377: x_msg_data := 'BIS_AK_REGION_PUB.reset_ak_items_display_seq: ' || SQLERRM;

3373: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3374: , p_count => x_msg_count
3375: , p_data => x_msg_data);
3376: IF (x_msg_data IS NULL) THEN
3377: x_msg_data := 'BIS_AK_REGION_PUB.reset_ak_items_display_seq: ' || SQLERRM;
3378: END IF;
3379: END reset_ak_items_display_seq;
3380:
3381: END BIS_AK_REGION_PUB;

Line 3381: END BIS_AK_REGION_PUB;

3377: x_msg_data := 'BIS_AK_REGION_PUB.reset_ak_items_display_seq: ' || SQLERRM;
3378: END IF;
3379: END reset_ak_items_display_seq;
3380:
3381: END BIS_AK_REGION_PUB;