1 PACKAGE BIS_OBJECT_EXTENSIONS_PVT AS
2 /* $Header: BISVEXTS.pls 120.0 2005/06/01 14:54:20 appldev noship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BISVEXTS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: Wrapper for populating the extension tables |
13 REM | - BIS_MEASURES_EXTENSION_TL |
14 REM | - BIS_FORM_FUNCTION_EXTENSION_TL/B |
15 REM | NOTES |
16 REM | 24-NOV-2004 Krishna Created. |
17 REM +=======================================================================+
18 */
19
20 G_PKG_NAME CONSTANT VARCHAR2(30):= 'BIS_OBJECT_EXTENSIONS_PVT';
21 -- APIS to manage Measure Extensions
22
23 PROCEDURE Create_Measure_Extension(
24 p_Api_Version IN NUMBER
25 ,p_Commit IN VARCHAR2
26 ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
27 ,x_Return_Status OUT NOCOPY VARCHAR2
28 ,x_Msg_Count OUT NOCOPY NUMBER
29 ,x_Msg_Data OUT NOCOPY VARCHAR2
30 );
31
32 PROCEDURE Retrieve_Measure_Extension(
33 p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
34 ,x_Meas_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
35 ,x_Return_Status OUT NOCOPY VARCHAR2
36 ,x_Msg_Count OUT NOCOPY NUMBER
37 ,x_Msg_Data OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE Update_Measure_Extension(
41 p_Api_Version IN NUMBER
42 ,p_Commit IN VARCHAR2
43 ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
44 ,x_Return_Status OUT NOCOPY VARCHAR2
45 ,x_Msg_Count OUT NOCOPY NUMBER
46 ,x_Msg_Data OUT NOCOPY VARCHAR2
47 );
48
49
50 PROCEDURE Translate_Measure_Extension(
51 p_Api_Version IN NUMBER
52 ,p_Commit IN VARCHAR2
53 ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
54 ,x_Return_Status OUT NOCOPY VARCHAR2
55 ,x_Msg_Count OUT NOCOPY NUMBER
56 ,x_Msg_Data OUT NOCOPY VARCHAR2
57 );
58
59 -- APIS to manage FORM_FUNCTION extensions
60 PROCEDURE Create_Form_Func_Extension(
61 p_Api_Version IN NUMBER
62 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
63 ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
64 ,x_Return_Status OUT NOCOPY VARCHAR2
65 ,x_Msg_Count OUT NOCOPY NUMBER
66 ,x_Msg_Data OUT NOCOPY VARCHAR2
67 );
68
69
70 PROCEDURE Update_Form_Func_Extension(
71 p_Api_Version IN NUMBER
72 ,p_Commit IN VARCHAR2
73 ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
74 ,x_Return_Status OUT NOCOPY VARCHAR2
75 ,x_Msg_Count OUT NOCOPY NUMBER
76 ,x_Msg_Data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE Translate_Form_Func_Extension(
80 p_Api_Version IN NUMBER
81 ,p_Commit IN VARCHAR2
82 ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
83 ,x_Return_Status OUT NOCOPY VARCHAR2
84 ,x_Msg_Count OUT NOCOPY NUMBER
85 ,x_Msg_Data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE Retrieve_Form_Func_Extension(
89 p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
90 , x_Form_Func_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
91 , x_Return_Status OUT NOCOPY VARCHAR2
92 , x_Msg_Count OUT NOCOPY NUMBER
93 , x_Msg_Data OUT NOCOPY VARCHAR2
94 );
95
96 PROCEDURE Delete_Form_Func_Extension(
97 p_Api_Version IN NUMBER
98 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
99 ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
100 ,x_Return_Status OUT NOCOPY VARCHAR2
101 ,x_Msg_Count OUT NOCOPY NUMBER
102 ,x_Msg_Data OUT NOCOPY VARCHAR2
103 );
104 PROCEDURE Add_Language;
105
106 PROCEDURE Delete_Measure_Extension(
107 p_Api_Version IN NUMBER
108 ,p_Commit IN VARCHAR2
109 ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
110 ,x_Return_Status OUT NOCOPY VARCHAR2
111 ,x_Msg_Count OUT NOCOPY NUMBER
112 ,x_Msg_Data OUT NOCOPY VARCHAR2
113 );
114
115 FUNCTION Get_FA_Id_By_Short_Name (p_Functional_Area_Short_Name IN VARCHAR2)RETURN NUMBER;
116
117 END BIS_OBJECT_EXTENSIONS_PVT;