[Home] [Help]
PACKAGE: APPS.BIS_FORM_FUNCTIONS_PUB
Source
1 PACKAGE BIS_FORM_FUNCTIONS_PUB as
2 /* $Header: BISPFFNS.pls 120.2 2005/08/25 02:02:06 kyadamak noship $ */
3 ----------------------------------------------------------------------------
4 -- PACKAGE: BIS_FORM_FUNCTIONS_PUB --
5 -- --
6 -- DESCRIPTION: Private package that calls the FND packages to --
7 -- insert records in the FND tables. --
8 --
9 -- --
10 -- MODIFICATIONS --
11 -- Date User Modification
12 -- XX-XXX-XX XXXXXXXX Modifications made, which procedures changed & --
13 -- list bug number, if fixing a bug. --
14 -- --
15 -- 11/21/01 mdamle Initial creation --
16 -- 12/25/03 mdamle Page Definer Integration - overloaded for addnl --
17 -- functionality and error messaging --
18 -- 06/07/04 mdamle Added delete_function_and_menu_ent --
19 -- 08/04/04 mdamle Bug#3823878 - Add lock_row --
20 -- 09/28/04 mdamle Bug#3919538 - Update function menu prompts --
21 -- 10/27/04 mdamle Bug#3972992 - Region code and app id in form fn --
22 -- 01/03/05 mdamle Enh#3014083 - Integrate with Extension table --
23 -- 01/13/05 vtulasi Bug#4102897 - Change in size of variables --
24 -- 01/29/05 akoduri Bug#4083833 - Select Content FROM OA Region --
25 -- 05/22/05 akoduri Enhancement#3865711 -- Obsolete Seeded Objects --
26 -- 05/03/05 rpenneru Enhancement#4346994 -- HTML Portlet --
27 -- 19-MAY-2005 visuri GSCC Issues bug 4363854 --
28 -- 17-AUG-2005 kyadamak Bug#4516889 added regioncode,regionapplid to update_row --
29 ----------------------------------------------------------------------------
30
31 -- Defaults
32 c_WEB_SECURED constant varchar2(1) := 'N';
33 c_WEB_ENCRYPT_PARAMETERS constant varchar2(1) := 'N';
34 c_RECORD_DELETED constant varchar2(7) := 'DELETED';
35 c_RECORD_CHANGED constant varchar2(7) := 'CHANGED';
36 C_LAST_UPDATE_DATE_FORMAT varchar2(21) := 'YYYY/MM/DD-HH24:MI:SS';
37 c_CUSTOM_FUNCTIONAL_AREA constant varchar2(7) := 'BIS_UNN';
38
39 TYPE FormFunction_Rec_Type IS RECORD (
40 function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE,
41 user_function_name VARCHAR2(80),
42 type VARCHAR2(30),
43 web_html_call VARCHAR2(240),
44 web_host_name VARCHAR2(80),
45 web_agent_name VARCHAR2(80),
46 web_encrypt_parameters VARCHAR2(1),
47 web_secured VARCHAR2(1),
48 web_icon VARCHAR2(30),
49 object_id NUMBER,
50 region_application_id NUMBER,
51 region_code VARCHAR2(30),
52 application_id NUMBER,
53 form_id NUMBER,
54 maintenance_mode_support VARCHAR2(8),
55 context_dependence VARCHAR2(8),
56 parameters VARCHAR2(2000),
57 description VARCHAR2(240)
58 );
59
60 procedure INSERT_ROW (
61 X_ROWID in out NOCOPY VARCHAR2,
62 X_USER_ID in NUMBER,
63 X_FUNCTION_ID in out NOCOPY VARCHAR2,
64 X_WEB_HTML_CALL in VARCHAR2,
65 X_FUNCTION_NAME in VARCHAR2,
66 X_PARAMETERS in VARCHAR2,
67 X_TYPE in VARCHAR2,
68 X_USER_FUNCTION_NAME in VARCHAR2,
69 X_DESCRIPTION in VARCHAR2);
70
71 -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
72 procedure INSERT_ROW (
73 p_FUNCTION_NAME in VARCHAR2
74 ,p_WEB_HTML_CALL in VARCHAR2
75 ,p_PARAMETERS in VARCHAR2
76 ,p_TYPE in VARCHAR2
77 ,p_USER_FUNCTION_NAME in VARCHAR2
78 ,p_DESCRIPTION in VARCHAR2 := NULL
79 ,x_FUNCTION_ID OUT NOCOPY NUMBER
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
84 ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
85 ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
86 ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
87 ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
88 );
89
90 procedure UPDATE_ROW (
91 X_USER_ID in NUMBER,
92 X_FUNCTION_ID in NUMBER,
93 X_PARAMETERS in VARCHAR2,
94 X_DESCRIPTION in VARCHAR2);
95
96 -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
97 procedure UPDATE_ROW (
98 p_FUNCTION_ID IN NUMBER
99 ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
100 ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
101 ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
102 ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
103 ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
104 ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
105 ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
106 ,x_return_status OUT NOCOPY VARCHAR2
107 ,x_msg_count OUT NOCOPY NUMBER
108 ,x_msg_data OUT NOCOPY VARCHAR2
109 ,p_REGION_CODE IN VARCHAR2 := NULL
110 ,p_REGION_APPLICATION_ID IN NUMBER := NULL
111
112 );
113
114 -- mdamle 12/25/2003
115 PROCEDURE DELETE_ROW (
116 p_FUNCTION_ID in VARCHAR2
117 ,x_return_status OUT NOCOPY VARCHAR2
118 ,x_msg_count OUT NOCOPY NUMBER
119 ,x_msg_data OUT NOCOPY VARCHAR2
120 );
121
122 PROCEDURE DELETE_FUNCTION_AND_MENU_ENT
123 (p_function_name IN VARCHAR2
124 ,x_return_status OUT NOCOPY VARCHAR2
125 ,x_msg_count OUT NOCOPY NUMBER
126 ,x_msg_data OUT NOCOPY VARCHAR2);
127
128 PROCEDURE DELETE_ROW_FUNC_MENUENTRIES (
129 p_FUNCTION_ID in VARCHAR2
130 ,x_return_status OUT NOCOPY VARCHAR2
131 ,x_msg_count OUT NOCOPY NUMBER
132 ,x_msg_data OUT NOCOPY VARCHAR2) ;
133
134 PROCEDURE LOCK_FUNCTION_ROW
135 ( p_function_id IN NUMBER
136 , p_last_update_date IN VARCHAR2
137 , x_record_status OUT NOCOPY VARCHAR2
138 );
139
140 PROCEDURE UPDATE_FUNCTION_MENU_PROMPTS
141 (p_function_id IN NUMBER
142 ,p_user_function_name IN VARCHAR2
143 ,x_return_status OUT NOCOPY VARCHAR2
144 ,x_msg_count OUT NOCOPY NUMBER
145 ,x_msg_data OUT NOCOPY VARCHAR2
146 );
147
148 PROCEDURE Update_Form_Func_Obsolete_Flag (
149 p_commit IN VARCHAR2 := FND_API.G_FALSE,
150 p_func_name IN VARCHAR2,
151 p_obsolete IN VARCHAR2,
152 x_return_status OUT nocopy VARCHAR2,
153 x_Msg_Count OUT NOCOPY NUMBER,
154 x_msg_data OUT nocopy VARCHAR2
155 );
156
157 PROCEDURE Check_Form_Function(
158 p_functionName IN VARCHAR2
159 ,p_user_functionName IN VARCHAR2
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ,x_msg_count OUT NOCOPY NUMBER
162 ,x_msg_data OUT NOCOPY VARCHAR2
163 );
164
165 END BIS_FORM_FUNCTIONS_PUB;