APPS.AMS_ACT_MARKET_SEGMENTS_PVT dependencies on AMS_ACT_MARKET_SEGMENTS_S

Line 37: SELECT AMS_ACT_MARKET_SEGMENTS_S.NEXTVAL

33: l_mks_rec mks_rec_type := p_mks_rec;
34: l_mks_count NUMBER;
35:
36: CURSOR c_mks_seq IS
37: SELECT AMS_ACT_MARKET_SEGMENTS_S.NEXTVAL
38: FROM DUAL;
39:
40: CURSOR c_mks_count(mks_id IN NUMBER) IS
41: SELECT COUNT(*)

Line 367: UPDATE AMS_ACT_MARKET_SEGMENTS SET

363:
364: -- update
365: AMS_Utility_PVT.debug_message(l_full_name||': update');
366:
367: UPDATE AMS_ACT_MARKET_SEGMENTS SET
368: last_update_date = SYSDATE,
369: last_updated_by = FND_GLOBAL.user_id,
370: market_segment_id = l_mks_rec.market_segment_id,
371: act_market_segment_used_by_id = l_mks_rec.act_market_segment_used_by_id,