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_CAMPAIGNRULES_PVT dependencies on AMS_SOURCE_CODES

Line 331: FROM ams_source_codes

327:
328:
329: CURSOR c_source_code IS
330: SELECT source_code_id
331: FROM ams_source_codes
332: WHERE source_code = x_source_code
333: AND active_flag = 'Y';
334:
335: l_rollup VARCHAR2(30) ;

Line 427: -- 'ams_source_codes',

423: --aranka added 07/27/02
424: --sam added start
425: -- IF p_source_code IS NOT NULL THEN
426: -- IF AMS_Utility_PVT.check_uniqueness(
427: -- 'ams_source_codes',
428: -- 'source_code = ''' || p_source_code ||
429: -- ''' AND active_flag = ''Y'''
430: -- ) = FND_API.g_false
431: -- THEN

Line 514: -- otherwise revoke the old one and add the new one to ams_source_codes

510: END IF;
511: END IF;
512: -- end soagrawa
513:
514: -- otherwise revoke the old one and add the new one to ams_source_codes
515: AMS_SourceCode_PVT.revoke_sourcecode(
516: p_api_version => 1.0,
517: p_init_msg_list => FND_API.g_false,
518: p_commit => FND_API.g_false,

Line 1993: -- FROM ams_source_codes

1989: -- l_msg_data VARCHAR2(2000);
1990:
1991: -- CURSOR c_source_code IS
1992: -- SELECT 1
1993: -- FROM ams_source_codes
1994: -- WHERE source_code = p_csch_rec.source_code
1995: -- AND active_flag = 'Y';
1996:
1997: -- CURSOR c_csch IS

Line 3386: FROM ams_source_codes

3382: ) IS
3383:
3384: CURSOR c_sc_from_source_codes IS
3385: SELECT source_code_id
3386: FROM ams_source_codes
3387: WHERE source_code = p_source_code
3388: AND source_code_for_id = p_source_code_for_id
3389: AND arc_source_code_for = p_source_code_for;
3390: