APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on AMS_PARTY_MARKET_SEGMENTS_S

Line 679: -- SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL

675: -- l_hzsaleschannel_sql VARCHAR2(10000) := p_hzsaleschannel_sql;
676: -- TYPE PartyCurTyp IS REF CURSOR; -- define weak REF CURSOR type
677: -- l_party_cv PartyCurTyp; -- declare cursor variable
678: -- CURSOR c_party_mkt_seg_seq IS -- generate an ID for INSERT
679: -- SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
680: -- FROM DUAL;
681:
682:
683: --R12: mkothari -- added cursor to get territory org

Line 1402: ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, '||

1398: 'site_use_id, '||
1399: 'bill_to_site_use_id, '||
1400: 'site_use_code )';
1401: l_final_sql := l_final_sql ||
1402: ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, '||
1403: 'SYSDATE, '||
1404: 'FND_GLOBAL.user_id, ';
1405: l_final_sql := l_final_sql ||
1406: 'SYSDATE, '||

Line 1496: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL,

1492: SITE_USE_ID,
1493: ORG_ID
1494: )
1495: select
1496: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL,
1497: SYSDATE,
1498: FND_GLOBAL.user_id,
1499: SYSDATE,
1500: FND_GLOBAL.user_id,

Line 1689: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL

1685: AND object_id = p_bg_id
1686: /* yzhao: fix bug 2789492 - MKTF1R9:1159.0203:FUNC-BUDGET WITH MARKET ELIGIBILITY BUYING GROUP DOES NOT VALI */
1687: AND directional_flag = NVL(p_direction, directional_flag);
1688: CURSOR c_party_mkt_seg_seq IS -- generate an ID
1689: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
1690: FROM DUAL;
1691: BEGIN
1692: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Start buyinggroup_id=' || p_bg_id);
1693: p_errbuf := null;