APPS.AMS_CUST_SETUP_PVT dependencies on AMS_CUSTOM_SETUPS_B

Line 40: SELECT AMS_CUSTOM_SETUPS_B_S.NEXTVAL

36: l_cust_setup_rec cust_setup_rec_type := p_cust_setup_rec;
37: l_cust_setup_count NUMBER;
38:
39: CURSOR c_cust_setup_seq IS
40: SELECT AMS_CUSTOM_SETUPS_B_S.NEXTVAL
41: FROM DUAL;
42:
43: CURSOR c_cust_setup_count(cust_setup_id IN NUMBER) IS
44: SELECT COUNT(*)

Line 121: INSERT INTO AMS_CUSTOM_SETUPS_B

117:
118: AMS_Utility_PVT.debug_message(l_full_name || ': insert');
119: END IF;
120:
121: INSERT INTO AMS_CUSTOM_SETUPS_B
122: (
123: custom_setup_id,
124: last_update_date,
125: last_updated_by,

Line 693: UPDATE AMS_CUSTOM_SETUPS_B SET

689:
690: AMS_Utility_PVT.debug_message(l_full_name||': update');
691: END IF;
692:
693: UPDATE AMS_CUSTOM_SETUPS_B SET
694: last_update_date = SYSDATE,
695: last_updated_by = FND_GLOBAL.user_id,
696: object_version_number = l_cust_setup_rec.object_version_number + 1,
697: last_update_login = FND_GLOBAL.conc_login_id,

Line 826: FROM AMS_CUSTOM_SETUPS_B

822: WHERE custom_setup_id = cust_setup_id;
823:
824: CURSOR c_object_version(cust_setup_id IN NUMBER) IS
825: SELECT object_version_number
826: FROM AMS_CUSTOM_SETUPS_B
827: WHERE custom_setup_id = cust_setup_id;
828:
829: BEGIN
830: -- initialize

Line 897: DELETE FROM AMS_CUSTOM_SETUPS_B

893: END IF;
894: RAISE FND_API.g_exc_error;
895: END IF;
896:
897: DELETE FROM AMS_CUSTOM_SETUPS_B
898: WHERE custom_setup_id = p_cust_setup_id
899: AND object_version_number = p_object_version;
900:
901: IF (SQL%NOTFOUND) THEN

Line 916: UPDATE AMS_CUSTOM_SETUPS_B SET -- IS USED

912: END IF;
913: RAISE FND_API.g_exc_error;
914: END IF;
915: ELSE
916: UPDATE AMS_CUSTOM_SETUPS_B SET -- IS USED
917: object_version_number = l_object_version +1,
918: enabled_flag = 'N'
919: WHERE custom_setup_id = p_cust_setup_id
920: AND object_version_number = p_object_version;

Line 1015: FROM AMS_CUSTOM_SETUPS_B

1011: l_cust_setup_id NUMBER;
1012:
1013: CURSOR c_cust_setup_b IS
1014: SELECT custom_setup_id
1015: FROM AMS_CUSTOM_SETUPS_B
1016: WHERE custom_setup_id = p_cust_setup_id
1017: AND object_version_number = p_object_version
1018: FOR UPDATE OF custom_setup_id NOWAIT;
1019: