DBA Data[Home] [Help]

APPS.BIS_PMV_REGION_ITEMS_PVT dependencies on BIS_AK_REGION_PUB

Line 26: , p_Region_Item_Tbl IN BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type

22: PROCEDURE CREATE_REGION_ITEMS
23: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
24: , p_region_code IN VARCHAR2
25: , p_region_application_id IN NUMBER
26: , p_Region_Item_Tbl IN BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_msg_count OUT NOCOPY NUMBER
29: , x_msg_data OUT NOCOPY VARCHAR2
30: ) IS

Line 31: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;

27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_msg_count OUT NOCOPY NUMBER
29: , x_msg_data OUT NOCOPY VARCHAR2
30: ) IS
31: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
32: l_commit VARCHAR2(1) := 'N';
33: BEGIN
34: FND_MSG_PUB.Initialize;
35: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 39: BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW

35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36: IF (p_Region_Item_Tbl IS NOT NULL AND p_Region_Item_Tbl.COUNT > 0) THEN
37: FOR i IN p_Region_Item_Tbl.FIRST..p_Region_Item_Tbl.LAST LOOP
38: l_Region_Item_Rec := p_Region_Item_Tbl(i);
39: BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW
40: ( p_commit => p_commit
41: , p_region_code => p_region_code
42: , p_region_application_id => p_region_application_id
43: , p_Region_Item_Rec => l_Region_Item_Rec

Line 127: , p_Region_Item_Tbl IN BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type

123: PROCEDURE UPDATE_REGION_ITEMS
124: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
125: , p_region_code IN VARCHAR2
126: , p_region_application_id IN NUMBER
127: , p_Region_Item_Tbl IN BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
128: , x_return_status OUT NOCOPY VARCHAR2
129: , x_msg_count OUT NOCOPY NUMBER
130: , x_msg_data OUT NOCOPY VARCHAR2
131: ) IS

Line 132: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;

128: , x_return_status OUT NOCOPY VARCHAR2
129: , x_msg_count OUT NOCOPY NUMBER
130: , x_msg_data OUT NOCOPY VARCHAR2
131: ) IS
132: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
133: l_commit VARCHAR2(1) := 'N';
134: BEGIN
135: FND_MSG_PUB.Initialize;
136: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 140: BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW

136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137: IF (p_Region_Item_Tbl IS NOT NULL AND p_Region_Item_Tbl.COUNT > 0) THEN
138: FOR i IN p_Region_Item_Tbl.FIRST..p_Region_Item_Tbl.LAST LOOP
139: l_Region_Item_Rec := p_Region_Item_Tbl(i);
140: BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW
141: ( p_commit => p_commit
142: , p_region_code => p_region_code
143: , p_region_application_id => p_region_application_id
144: , p_Region_Item_Rec => l_Region_Item_Rec

Line 239: BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW

235: FND_MSG_PUB.Initialize;
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: IF (p_Attribute_Code_Tbl IS NOT NULL AND p_Attribute_Code_Tbl.COUNT > 0) THEN
238: FOR i IN p_Attribute_Code_Tbl.FIRST..p_Attribute_Code_Tbl.LAST LOOP
239: BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW
240: ( p_REGION_CODE => p_region_code
241: , p_REGION_APPLICATION_ID => p_region_application_id
242: , p_ATTRIBUTE_CODE => p_Attribute_Code_Tbl(i)
243: , p_ATTRIBUTE_APPLICATION_ID => p_Attribute_Appl_Id_Tbl(i)