APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on AMS_PARTY_MARKET_SEGMENTS_S

Line 673: -- SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL

669: -- l_hzsaleschannel_sql VARCHAR2(10000) := p_hzsaleschannel_sql;
670: -- TYPE PartyCurTyp IS REF CURSOR; -- define weak REF CURSOR type
671: -- l_party_cv PartyCurTyp; -- declare cursor variable
672: -- CURSOR c_party_mkt_seg_seq IS -- generate an ID for INSERT
673: -- SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
674: -- FROM DUAL;
675:
676:
677: --R12: mkothari -- added cursor to get territory org

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

1385: 'site_use_id, '||
1386: 'bill_to_site_use_id, '||
1387: 'site_use_code )';
1388: l_final_sql := l_final_sql ||
1389: ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, '||
1390: 'SYSDATE, '||
1391: 'FND_GLOBAL.user_id, ';
1392: l_final_sql := l_final_sql ||
1393: 'SYSDATE, '||

Line 1483: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL,

1479: SITE_USE_ID,
1480: ORG_ID
1481: )
1482: select
1483: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL,
1484: SYSDATE,
1485: FND_GLOBAL.user_id,
1486: SYSDATE,
1487: FND_GLOBAL.user_id,

Line 1676: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL

1672: AND object_id = p_bg_id
1673: /* yzhao: fix bug 2789492 - MKTF1R9:1159.0203:FUNC-BUDGET WITH MARKET ELIGIBILITY BUYING GROUP DOES NOT VALI */
1674: AND directional_flag = NVL(p_direction, directional_flag);
1675: CURSOR c_party_mkt_seg_seq IS -- generate an ID
1676: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
1677: FROM DUAL;
1678: BEGIN
1679: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Start buyinggroup_id=' || p_bg_id);
1680: p_errbuf := null;