DBA Data[Home] [Help]

APPS.AMS_CUST_SETUP_PVT dependencies on AMS_CUSTOM_SETUPS_B_S

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