APPS.AMS_PARTY_MKT_SEG_LOADER_PVT dependencies on AMS_PARTY_MARKET_SEGMENTS_S

Line 313: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL

309: AND party_id = id
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(*)

Line 406: UPDATE AMS_PARTY_MARKET_SEGMENTS SET

402: CLOSE c_expire_party_count;
403:
404: IF l_expire_party_count > 0 THEN -- party expired
405:
406: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
407: last_update_date = SYSDATE
408: , last_updated_by = FND_GLOBAL.user_id
409: , last_update_login = FND_GLOBAL.conc_login_id
410: , object_version_number = object_version_number + 1

Line 692: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL

688: AND party_id = id
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(*)

Line 780: UPDATE AMS_PARTY_MARKET_SEGMENTS SET

776: CLOSE c_expire_party_count;
777:
778: IF l_expire_party_count > 0 THEN -- party expired
779:
780: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
781: last_update_date = SYSDATE
782: , last_updated_by = FND_GLOBAL.user_id
783: , last_update_login = FND_GLOBAL.conc_login_id
784: , object_version_number = object_version_number + 1

Line 2616: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL

2612: l_denorm_csr INTEGER;
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;

Line 2866: l_final_sql := l_final_sql || ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, SYSDATE, FND_GLOBAL.user_id';

2862: l_final_sql := 'INSERT INTO AMS_PARTY_MARKET_SEGMENTS(ams_party_market_segment_id, last_update_date, last_updated_by';
2863: l_final_sql := l_final_sql || ', creation_date, created_by, last_update_login, object_version_number, market_segment_id';
2864: l_final_sql := l_final_sql || ', market_segment_flag, party_id, start_date_active, end_date_active, org_id';
2865: l_final_sql := l_final_sql || ', market_qualifier_type, market_qualifier_reference, cust_account_id, cust_acct_site_id, site_use_code)';
2866: l_final_sql := l_final_sql || ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, SYSDATE, FND_GLOBAL.user_id';
2867: l_final_sql := l_final_sql || ', SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.conc_login_id, 1, 0';
2868: l_final_sql := l_final_sql || ', ''N'', party_id, SYSDATE, NULL, :org_id org_id';
2869: l_final_sql := l_final_sql || ', ''TERRITORY'', :terr_id market_qualifier_reference, cust_account_id, cust_acct_site_id, site_use_code FROM (';
2870: l_final_sql := l_final_sql || l_party_select_sql || substr(l_party_where_sql, 1, length(l_party_where_sql)-4) || ')';

Line 3038: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL

3034: /* yzhao: fix bug 2789492 - MKTF1R9:1159.0203:FUNC-BUDGET WITH MARKET ELIGIBILITY BUYING GROUP DOES NOT VALI */
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);