310: AND end_date_active IS NOT NULL;
311:
312: CURSOR c_party_mkt_seg_seq IS -- generate an ID
313: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
314: FROM DUAL;
315:
316: CURSOR c_party_mkt_seg_count(party_mkt_seg_id IN NUMBER) IS -- check if ID is unique
317: SELECT count(*)
318: FROM AMS_PARTY_MARKET_SEGMENTS
689: AND end_date_active IS NOT NULL;
690:
691: CURSOR c_party_mkt_seg_seq IS -- generate an ID
692: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
693: FROM DUAL;
694:
695: CURSOR c_party_mkt_seg_count(party_mkt_seg_id IN NUMBER) IS -- check if ID is unique
696: SELECT count(*)
697: FROM AMS_PARTY_MARKET_SEGMENTS
2613:
2614: /*
2615: CURSOR c_party_mkt_seg_seq IS -- generate an ID for INSERT
2616: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
2617: FROM DUAL;
2618: */
2619: BEGIN
2620: p_retcode := 0;
2621: FND_MSG_PUB.initialize;
3035: AND directional_flag = NVL(p_direction, directional_flag);
3036:
3037: CURSOR c_party_mkt_seg_seq IS -- generate an ID
3038: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
3039: FROM DUAL;
3040:
3041: BEGIN
3042: Ams_Utility_pvt.Write_Conc_log(l_full_name || ': Start buyinggroup_id=' || p_bg_id);
3043: p_errbuf := null;