APPS.BIS_FUNCTIONAL_AREA_PVT dependencies on BIS_FUNCTIONAL_AREA_PUB

Line 29: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

25:
26: PROCEDURE Create_Functional_Area(
27: p_Api_Version IN NUMBER
28: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
29: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
30: ,x_Return_Status OUT NOCOPY VARCHAR2
31: ,x_Msg_Count OUT NOCOPY NUMBER
32: ,x_Msg_Data OUT NOCOPY VARCHAR2
33: ) IS

Line 35: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

31: ,x_Msg_Count OUT NOCOPY NUMBER
32: ,x_Msg_Data OUT NOCOPY VARCHAR2
33: ) IS
34:
35: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
36: l_Count NUMBER;
37:
38: BEGIN
39: SAVEPOINT CreateFuncAreaSP_Pvt;

Line 171: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

167: -- Update Functional Area API
168: PROCEDURE Update_Functional_Area(
169: p_Api_Version IN NUMBER
170: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
171: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
172: ,x_Return_Status OUT NOCOPY VARCHAR2
173: ,x_Msg_Count OUT NOCOPY NUMBER
174: ,x_Msg_Data OUT NOCOPY VARCHAR2
175: ) IS

Line 177: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

173: ,x_Msg_Count OUT NOCOPY NUMBER
174: ,x_Msg_Data OUT NOCOPY VARCHAR2
175: ) IS
176: l_Count NUMBER;
177: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
178: BEGIN
179: SAVEPOINT UpdateFuncAreaSP_Pvt;
180: FND_MSG_PUB.Initialize;
181: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 295: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

291: -- Translate the Functional Area Name/Description
292: PROCEDURE Translate_Functional_Area(
293: p_Api_Version IN NUMBER
294: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
295: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
296: ,x_Return_Status OUT NOCOPY VARCHAR2
297: ,x_Msg_Count OUT NOCOPY NUMBER
298: ,x_Msg_Data OUT NOCOPY VARCHAR2
299: ) IS

Line 301: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

297: ,x_Msg_Count OUT NOCOPY NUMBER
298: ,x_Msg_Data OUT NOCOPY VARCHAR2
299: ) IS
300: l_Count NUMBER;
301: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
302:
303: BEGIN
304: SAVEPOINT TransFuncAreaSP_Pvt;
305: FND_MSG_PUB.Initialize;

Line 413: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

409: END IF;
410: END Translate_Functional_Area;
411:
412: PROCEDURE Retrieve_Functional_Area(
413: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
414: ,x_Func_Area_Rec OUT NOCOPY BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
415: ,x_Return_Status OUT NOCOPY VARCHAR2
416: ,x_Msg_Count OUT NOCOPY NUMBER
417: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 414: ,x_Func_Area_Rec OUT NOCOPY BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

410: END Translate_Functional_Area;
411:
412: PROCEDURE Retrieve_Functional_Area(
413: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
414: ,x_Func_Area_Rec OUT NOCOPY BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
415: ,x_Return_Status OUT NOCOPY VARCHAR2
416: ,x_Msg_Count OUT NOCOPY NUMBER
417: ,x_Msg_Data OUT NOCOPY VARCHAR2
418: ) IS

Line 643: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

639: -- Delete the Functional Area
640: PROCEDURE Delete_Functional_Area(
641: p_Api_Version IN NUMBER
642: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
643: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
644: ,x_Return_Status OUT NOCOPY VARCHAR2
645: ,x_Msg_Count OUT NOCOPY NUMBER
646: ,x_Msg_Data OUT NOCOPY VARCHAR2
647: ) IS

Line 648: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

644: ,x_Return_Status OUT NOCOPY VARCHAR2
645: ,x_Msg_Count OUT NOCOPY NUMBER
646: ,x_Msg_Data OUT NOCOPY VARCHAR2
647: ) IS
648: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
649: l_Count NUMBER;
650:
651: CURSOR c_FuncArea_Dep IS
652: SELECT B.FUNCTIONAL_AREA_ID,