APPS.BIS_AK_REGION_PUB dependencies on AK_REGION_ITEMS_PKG

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 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 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 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 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