[Home] [Help]
36: l_setup_attr_rec setup_attr_rec_type := p_setup_attr_rec;
37: l_setup_attr_count NUMBER;
38:
39: CURSOR c_setup_attr_seq IS
40: SELECT AMS_CUSTOM_SETUP_ATTR_S.NEXTVAL
41: FROM DUAL;
42:
43: CURSOR c_setup_attr_count(setup_attr_id IN NUMBER) IS
44: SELECT COUNT(*)
41: FROM DUAL;
42:
43: CURSOR c_setup_attr_count(setup_attr_id IN NUMBER) IS
44: SELECT COUNT(*)
45: FROM AMS_CUSTOM_SETUP_ATTR
46: WHERE setup_attribute_id = setup_attr_id;
47:
48: BEGIN
49: -- initialize
119: EXIT WHEN l_setup_attr_count = 0;
120: END LOOP;
121: END IF;
122:
123: INSERT INTO AMS_CUSTOM_SETUP_ATTR
124: (
125: setup_attribute_id,
126: custom_setup_id,
127: last_update_date,
315:
316: AMS_Utility_PVT.debug_message(l_full_name||': update');
317: END IF;
318:
319: UPDATE AMS_CUSTOM_SETUP_ATTR SET
320: custom_setup_id = l_setup_attr_rec.custom_setup_id,
321: last_update_date = SYSDATE,
322: last_updated_by = FND_GLOBAL.user_id,
323: object_version_number = l_setup_attr_rec.object_version_number + 1,
729: l_dummy NUMBER;
730:
731: CURSOR c_ess_seq_exists(seq_num_in IN NUMBER, id_in IN NUMBER, setup_id_in IN NUMBER) IS
732: SELECT 1 FROM dual
733: WHERE EXISTS (SELECT 1 FROM ams_custom_setup_attr
734: WHERE custom_setup_id = id_in
735: AND essential_seq_num = seq_num_in
736: AND setup_attribute_id <> setup_id_in
737: );
749: AND p_setup_attr_rec.setup_attribute_id IS NOT NULL
750: THEN
751: l_uk_flag := AMS_Utility_PVT.check_uniqueness
752: (
753: 'AMS_CUSTOM_SETUP_ATTR',
754: 'setup_attribute_id = ' || p_setup_attr_rec.setup_attribute_id
755: );
756: END IF;
757:
1057: )
1058: IS
1059:
1060: CURSOR c_setup_attr IS
1061: SELECT * FROM AMS_CUSTOM_SETUP_ATTR
1062: WHERE setup_attribute_id = p_setup_attr_rec.setup_attribute_id;
1063:
1064: l_setup_attr_rec c_setup_attr%ROWTYPE;
1065: