APPS.AMS_CUSTOM_SETUP_ATTR_PKG dependencies on AMS_CUSTOM_SETUP_ATTR

Line 1: package body AMS_CUSTOM_SETUP_ATTR_PKG as

1: package body AMS_CUSTOM_SETUP_ATTR_PKG as
2: /* $Header: amslattb.pls 115.12 2004/04/08 22:51:09 asaha ship $ */
3: PROCEDURE INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_SETUP_ATTRIBUTE_ID in NUMBER,

Line 28: CURSOR c IS select ROWID FROM AMS_CUSTOM_SETUP_ATTR

24: X_LAST_UPDATE_LOGIN in NUMBER,
25: X_ESSENTIAL_SEQ_NUM in NUMBER
26: )
27: IS
28: CURSOR c IS select ROWID FROM AMS_CUSTOM_SETUP_ATTR
29: WHERE SETUP_ATTRIBUTE_ID = X_SETUP_ATTRIBUTE_ID
30: ;
31: BEGIN
32: INSERT into AMS_CUSTOM_SETUP_ATTR (

Line 32: INSERT into AMS_CUSTOM_SETUP_ATTR (

28: CURSOR c IS select ROWID FROM AMS_CUSTOM_SETUP_ATTR
29: WHERE SETUP_ATTRIBUTE_ID = X_SETUP_ATTRIBUTE_ID
30: ;
31: BEGIN
32: INSERT into AMS_CUSTOM_SETUP_ATTR (
33: SETUP_ATTRIBUTE_ID,
34: OBJECT_VERSION_NUMBER,
35: CUSTOM_SETUP_ID,
36: DISPLAY_SEQUENCE_NO,

Line 110: UPDATE AMS_CUSTOM_SETUP_ATTR SET

106: X_ESSENTIAL_SEQ_NUM in NUMBER
107: )
108: IS
109: BEGIN
110: UPDATE AMS_CUSTOM_SETUP_ATTR SET
111: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
112: DISPLAY_SEQUENCE_NO = X_DISPLAY_SEQUENCE_NO,
113: ATTR_MANDATORY_FLAG = X_ATTR_MANDATORY_FLAG,
114: ATTR_AVAILABLE_FLAG = X_ATTR_AVAILABLE_FLAG,

Line 140: DELETE FROM AMS_CUSTOM_SETUP_ATTR

136: X_SETUP_ATTRIBUTE_ID in NUMBER
137: )
138: IS
139: BEGIN
140: DELETE FROM AMS_CUSTOM_SETUP_ATTR
141: WHERE SETUP_ATTRIBUTE_ID = X_SETUP_ATTRIBUTE_ID;
142:
143: IF (sql%NOTFOUND) THEN
144: RAISE no_data_found;

Line 198: FROM AMS_CUSTOM_SETUP_ATTR

194: l_db_luby_id NUMBER;
195:
196: cursor c_db_data_details is
197: select last_updated_by, nvl(object_version_number,1)
198: FROM AMS_CUSTOM_SETUP_ATTR
199: WHERE OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
200: AND CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
201:
202: CURSOR c_chk_code_exists IS

Line 204: FROM AMS_CUSTOM_SETUP_ATTR

200: AND CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
201:
202: CURSOR c_chk_code_exists IS
203: select 1
204: FROM AMS_CUSTOM_SETUP_ATTR
205: WHERE OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
206: AND CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
207:
208: CURSOR c_get_attr_id IS

Line 209: select AMS_CUSTOM_SETUP_ATTR_S.NEXTVAL

205: WHERE OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
206: AND CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
207:
208: CURSOR c_get_attr_id IS
209: select AMS_CUSTOM_SETUP_ATTR_S.NEXTVAL
210: FROM DUAL;
211:
212: CURSOR c_check_attr_id(attr_id IN NUMBER) IS
213: SELECT COUNT(*)

Line 214: FROM AMS_CUSTOM_SETUP_ATTR

210: FROM DUAL;
211:
212: CURSOR c_check_attr_id(attr_id IN NUMBER) IS
213: SELECT COUNT(*)
214: FROM AMS_CUSTOM_SETUP_ATTR
215: WHERE setup_attribute_id = attr_id;
216:
217: BEGIN
218:

Line 248: AMS_CUSTOM_SETUP_ATTR_PKG.INSERT_ROW (

244: EXIT WHEN l_count = 0;
245: END LOOP;
246:
247: l_obj_verno := 1;
248: AMS_CUSTOM_SETUP_ATTR_PKG.INSERT_ROW (
249: X_ROWID => l_row_id,
250: X_SETUP_ATTRIBUTE_ID => l_attr_id,
251: X_OBJECT_VERSION_NUMBER => l_obj_verno,
252: X_CUSTOM_SETUP_ID => X_CUSTOM_SETUP_ID,

Line 280: AMS_CUSTOM_SETUP_ATTR_PKG.UPDATE_ROW (

276: fetch c_db_data_details into l_db_luby_id, l_obj_verno;
277: close c_db_data_details;
278: if ( l_db_luby_id IN (1, 2, 0)
279: OR NVL(x_custom_mode,'PRESERVE') = 'FORCE') THEN
280: AMS_CUSTOM_SETUP_ATTR_PKG.UPDATE_ROW (
281: X_SETUP_ATTRIBUTE_ID => X_SETUP_ATTRIBUTE_ID,
282: X_OBJECT_VERSION_NUMBER => l_obj_verno + 1,
283: X_CUSTOM_SETUP_ID => X_CUSTOM_SETUP_ID,
284: X_DISPLAY_SEQUENCE_NO => X_DISPLAY_SEQUENCE_NO,

Line 302: UPDATE AMS_CUSTOM_SETUP_ATTR SET

298: X_LAST_UPDATE_LOGIN => 0,
299: X_ESSENTIAL_SEQ_NUM => X_ESSENTIAL_SEQ_NUM
300: );
301: ELSE
302: UPDATE AMS_CUSTOM_SETUP_ATTR SET
303: OBJECT_VERSION_NUMBER = l_obj_verno + 1,
304: OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE,
305: PARENT_FUNCTION_NAME = X_PARENT_FUNCTION_NAME,
306: FUNCTION_NAME = X_FUNCTION_NAME,

Line 322: END AMS_CUSTOM_SETUP_ATTR_PKG;

318: end if;
319: end if;
320: END LOAD_ROW;
321:
322: END AMS_CUSTOM_SETUP_ATTR_PKG;