eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_PARTY_SEG_LOADER_PVT dependencies on AMS_PARTY_MARKET_SEGMENTS_S

Line 391: SELECT seg.party_id FROM AMS_PARTY_MARKET_SEGMENTS seg,

387: WHERE market_segment_id = p_mkt_seg_id;
388:
389: --Cursor to select inactive parties from segments table which are also returned by seg query
390: CURSOR C_activate_parties IS
391: SELECT seg.party_id FROM AMS_PARTY_MARKET_SEGMENTS seg,
392: (SELECT column_value party_id FROM TABLE(CAST(p_party_tbl AS jtf_number_table))) tbl
393: WHERE seg.party_id = tbl.party_id
394: AND seg.end_date_active IS NOT NULL; --Inactive parties
395:

Line 432: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL

428: , end_date_active
429: , org_id
430: )
431: select
432: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
433: , SYSDATE
434: , FND_GLOBAL.user_id
435: , SYSDATE
436: , FND_GLOBAL.user_id

Line 462: UPDATE AMS_PARTY_MARKET_SEGMENTS SET

458: END IF;
459:
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