DBA Data[Home] [Help]

APPS.AMS_CUSTOM_SETUP_ATTR_PKG dependencies on AMS_CUSTOM_SETUP_ATTR_S

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 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 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,