202: FORALL i in l_exp_party_tbl.FIRST..l_exp_party_tbl.LAST
203: UPDATE AMS_PARTY_MARKET_SEGMENTS
204: SET end_date_active = SYSDATE
205: , last_update_date = SYSDATE
206: , last_updated_by = FND_GLOBAL.user_id
207: , last_update_login = FND_GLOBAL.conc_login_id
208: WHERE market_segment_id = p_mkt_seg_id
209: AND party_id = l_exp_party_tbl(i);
210: END IF;
203: UPDATE AMS_PARTY_MARKET_SEGMENTS
204: SET end_date_active = SYSDATE
205: , last_update_date = SYSDATE
206: , last_updated_by = FND_GLOBAL.user_id
207: , last_update_login = FND_GLOBAL.conc_login_id
208: WHERE market_segment_id = p_mkt_seg_id
209: AND party_id = l_exp_party_tbl(i);
210: END IF;
211:
315: FORALL i in l_sql_tbl.first .. l_sql_tbl.last
316: UPDATE AMS_PARTY_MARKET_SEGMENTS
317: SET end_date_active = SYSDATE
318: , last_update_date = SYSDATE
319: , last_updated_by = FND_GLOBAL.user_id
320: , last_update_login = FND_GLOBAL.conc_login_id
321: WHERE market_segment_id = l_old_mkt_seg_id
322: AND party_id = l_sql_tbl(i);
323: END IF;
316: UPDATE AMS_PARTY_MARKET_SEGMENTS
317: SET end_date_active = SYSDATE
318: , last_update_date = SYSDATE
319: , last_updated_by = FND_GLOBAL.user_id
320: , last_update_login = FND_GLOBAL.conc_login_id
321: WHERE market_segment_id = l_old_mkt_seg_id
322: AND party_id = l_sql_tbl(i);
323: END IF;
324:
430: )
431: select
432: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
433: , SYSDATE
434: , FND_GLOBAL.user_id
435: , SYSDATE
436: , FND_GLOBAL.user_id
437: , FND_GLOBAL.conc_login_id
438: , 1
432: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
433: , SYSDATE
434: , FND_GLOBAL.user_id
435: , SYSDATE
436: , FND_GLOBAL.user_id
437: , FND_GLOBAL.conc_login_id
438: , 1
439: , p_mkt_seg_id
440: , 'Y' -- always put true for market_segment_flag
433: , SYSDATE
434: , FND_GLOBAL.user_id
435: , SYSDATE
436: , FND_GLOBAL.user_id
437: , FND_GLOBAL.conc_login_id
438: , 1
439: , p_mkt_seg_id
440: , 'Y' -- always put true for market_segment_flag
441: , l_party_tbl(i)
460: IF l_party_tbl.count > 0 THEN
461: FORALL i IN l_party_tbl.FIRST..l_party_tbl.LAST
462: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
463: last_update_date = SYSDATE
464: , last_updated_by = FND_GLOBAL.user_id
465: , last_update_login = FND_GLOBAL.conc_login_id
466: , object_version_number = object_version_number + 1
467: , market_segment_id = p_mkt_seg_id
468: , party_id = l_party_tbl(i)
461: FORALL i IN l_party_tbl.FIRST..l_party_tbl.LAST
462: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
463: last_update_date = SYSDATE
464: , last_updated_by = FND_GLOBAL.user_id
465: , last_update_login = FND_GLOBAL.conc_login_id
466: , object_version_number = object_version_number + 1
467: , market_segment_id = p_mkt_seg_id
468: , party_id = l_party_tbl(i)
469: , start_date_active =SYSDATE
635: UPDATE ams_cells_all_b
636: SET original_size = l_party_count,
637: object_version_number = object_version_number + 1,
638: last_update_date = SYSDATE,
639: last_updated_by = FND_GLOBAL.user_id,
640: last_update_login = FND_GLOBAL.conc_login_id
641: WHERE cell_id = l_cell_id;
642:
643: -- Keep size history
636: SET original_size = l_party_count,
637: object_version_number = object_version_number + 1,
638: last_update_date = SYSDATE,
639: last_updated_by = FND_GLOBAL.user_id,
640: last_update_login = FND_GLOBAL.conc_login_id
641: WHERE cell_id = l_cell_id;
642:
643: -- Keep size history
644: OPEN C_last_size(l_cell_id);
666: VALUES
667: (
668: ams_act_sizes_s.nextval,
669: SYSDATE,
670: fnd_global.user_id,
671: SYSDATE,
672: fnd_global.user_id,
673: fnd_global.conc_login_id,
674: l_cell_id,
668: ams_act_sizes_s.nextval,
669: SYSDATE,
670: fnd_global.user_id,
671: SYSDATE,
672: fnd_global.user_id,
673: fnd_global.conc_login_id,
674: l_cell_id,
675: 'CELL',
676: l_party_count,
669: SYSDATE,
670: fnd_global.user_id,
671: SYSDATE,
672: fnd_global.user_id,
673: fnd_global.conc_login_id,
674: l_cell_id,
675: 'CELL',
676: l_party_count,
677: 'SUCCESSED',