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_ACT_LIST_PVT dependencies on AMS_LIST_ENTRIES

Line 2084: FROM ams_list_entries

2080: l_list_entry_count number;
2081:
2082: CURSOR c_list_entries (p_list_header_id IN number ) is
2083: SELECT list_entry_id
2084: FROM ams_list_entries
2085: WHERE list_header_id = p_list_header_id
2086: AND enabled_flag = 'Y'
2087: ORDER BY randomly_generated_number ;
2088:

Line 2091: FROM ams_list_entries

2087: ORDER BY randomly_generated_number ;
2088:
2089: CURSOR c_get_count (p_list_header_id IN number ) is
2090: SELECT count(1)
2091: FROM ams_list_entries
2092: WHERE list_header_id = p_list_header_id
2093: AND enabled_flag = 'Y';
2094:
2095: BEGIN

Line 2116: UPDATE ams_list_entries

2112: end if;
2113:
2114: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'SSSSDD')));
2115:
2116: UPDATE ams_list_entries
2117: SET randomly_generated_number = DBMS_RANDOM.random
2118: WHERE list_header_id = p_list_header_id
2119: and enabled_flag = 'Y';
2120:

Line 2130: UPDATE ams_list_entries

2126: FETCH c_list_entries BULK COLLECT INTO l_list_entries_id LIMIT l_total_random_rows;
2127: CLOSE c_list_entries;
2128:
2129: FORALL i in l_list_entries_id.FIRST .. l_list_entries_id.LAST
2130: UPDATE ams_list_entries
2131: SET part_of_control_group_flag = 'Y',
2132: enabled_flag = 'N'
2133: WHERE list_header_id = p_list_header_id
2134: AND list_entry_id = l_list_entries_id(i);

Line 2183: UPDATE ams_list_entries a

2179: fetch c_get_list into l_list_header_id ;
2180: exit when c_get_list%notfound;
2181: if p_supp_type = 'PARTY_ID' then
2182: if ams_listgeneration_pkg.g_remote_list_gen = 'N' then
2183: UPDATE ams_list_entries a
2184: SET a.enabled_flag = 'N', a.MARKED_AS_SUPPRESSED_FLAG = 'Y'
2185: WHERE a.list_header_id = p_list_header_id
2186: AND a.enabled_flag = 'Y'
2187: AND exists (SELECT 'x'

Line 2188: FROM ams_list_entries b

2184: SET a.enabled_flag = 'N', a.MARKED_AS_SUPPRESSED_FLAG = 'Y'
2185: WHERE a.list_header_id = p_list_header_id
2186: AND a.enabled_flag = 'Y'
2187: AND exists (SELECT 'x'
2188: FROM ams_list_entries b
2189: WHERE b.list_header_id = l_list_header_id
2190: AND a.party_id = b.party_id
2191: AND b.enabled_flag = 'Y');
2192: write_to_act_log(p_msg_data => sql%rowcount||' entries disabled for party_id based suppression. Suppression list header id is '||l_list_header_id,

Line 2212: UPDATE ams_list_entries a SET a.enabled_flag = 'N', a.MARKED_AS_SUPPRESSED_FLAG = 'Y'

2208: end if;
2209: elsif p_supp_type = 'DEDUPE' then
2210: if nvl(ams_listgeneration_pkg.g_remote_list_gen,'N') = 'N' then
2211: EXECUTE IMMEDIATE p_sql_string using l_list_header_id;
2212: UPDATE ams_list_entries a SET a.enabled_flag = 'N', a.MARKED_AS_SUPPRESSED_FLAG = 'Y'
2213: WHERE a.list_header_id = p_list_header_id
2214: AND a.enabled_flag = 'Y'
2215: AND exists (SELECT 'x'
2216: FROM ams_list_entries b

Line 2216: FROM ams_list_entries b

2212: UPDATE ams_list_entries a SET a.enabled_flag = 'N', a.MARKED_AS_SUPPRESSED_FLAG = 'Y'
2213: WHERE a.list_header_id = p_list_header_id
2214: AND a.enabled_flag = 'Y'
2215: AND exists (SELECT 'x'
2216: FROM ams_list_entries b
2217: WHERE b.list_header_id = l_list_header_id
2218: AND b.dedupe_key = a.dedupe_key
2219: AND b.enabled_flag = 'Y');
2220: write_to_act_log(p_msg_data => sql%rowcount||' entries disabled for dedupe rule based suppression. Suppression list header id is '||l_list_header_id,

Line 2286: --to get the columns in ams_list_entries mapped

2282: SELECT list_source_type
2283: FROM ams_list_headers_all
2284: WHERE list_header_id = p_list_header_id ;
2285:
2286: --to get the columns in ams_list_entries mapped
2287: --to the attributes of the datasource which
2288: --were used to define the de-duplication rule
2289: CURSOR c_rule_field(cur_rule_id number) is
2290: SELECT b.field_column_name

Line 2343: --call procedure to update ams_list_entries table

2339: write_to_act_log( p_msg_data => 'Calling apply_supp procedure to perform party_id based suppression',
2340: p_arc_log_used_by => 'LIST',
2341: p_log_used_by_id => p_list_header_id,p_level=>'HIGH');
2342:
2343: --call procedure to update ams_list_entries table
2344: --matching the entries of the supprssion list(s)
2345: --using PARTY_ID as the dedupe_key in this case
2346: apply_supp(p_list_header_id, l_string,l_media_id,l_source_type,'PARTY_ID',x_return_status,x_msg_count,x_msg_data);
2347: write_to_act_log( p_msg_data => 'Party_id based suppression done.',

Line 2360: l_string := 'update ams_list_entries set dedupe_key = ';

2356:
2357: --dedupe rule based suppression
2358: if l_rule_id is not null then
2359: --reset l_string to new value
2360: l_string := 'update ams_list_entries set dedupe_key = ';
2361:
2362: open c_rule_field(l_rule_id);
2363: LOOP
2364: fetch c_rule_field into l_column;

Line 2406: --call procedure to update ams_list_entries table

2402: out x_msg_data,
2403: out x_return_status;
2404: null;*/
2405: end if;
2406: --call procedure to update ams_list_entries table
2407: --matching the entries of the supprssion list(s)
2408: --using dedupe_keys from the selected De-Dupe Rule
2409: apply_supp(p_list_header_id, l_string,l_media_id,l_source_type,'DEDUPE',x_return_status,x_msg_count,x_msg_data);
2410: --end of Phase II; de-dupe key used from the selected De-dupe rule, if any ---------------------

Line 2798: UPDATE ams_list_entries a

2794: write_to_act_log(p_msg_data => 'Marking duplicates based on dedupe key and party id' ,
2795: p_arc_log_used_by => 'LIST',
2796: p_log_used_by_id => g_list_header_id,
2797: p_level => 'HIGH');
2798: UPDATE ams_list_entries a
2799: SET a.enabled_flag = 'N',
2800: a.marked_as_duplicate_flag = 'Y'
2801: WHERE a.list_header_id = l_list_header_id
2802: and a.enabled_flag = 'Y'

Line 2804: from ams_list_entries b

2800: a.marked_as_duplicate_flag = 'Y'
2801: WHERE a.list_header_id = l_list_header_id
2802: and a.enabled_flag = 'Y'
2803: AND a.rowid > (SELECT min(b.rowid)
2804: from ams_list_entries b
2805: where b.list_header_id = l_list_header_id
2806: and b.dedupe_key = a.dedupe_key
2807: and b.enabled_flag = 'Y'
2808: );*/

Line 2811: UPDATE ams_list_entries a

2807: and b.enabled_flag = 'Y'
2808: );*/
2809:
2810: /*
2811: UPDATE ams_list_entries a
2812: SET a.enabled_flag = 'N',
2813: a.marked_as_duplicate_flag = 'Y'
2814: WHERE a.list_header_id = l_list_header_id
2815: and a.enabled_flag = 'Y'

Line 2817: from ams_list_entries b

2813: a.marked_as_duplicate_flag = 'Y'
2814: WHERE a.list_header_id = l_list_header_id
2815: and a.enabled_flag = 'Y'
2816: AND a.rowid > (SELECT min(b.rowid)
2817: from ams_list_entries b
2818: where b.list_header_id = l_list_header_id
2819: and b.party_id = a.party_id
2820: and b.enabled_flag = 'Y'
2821: );

Line 2824: /* UPDATE ams_list_entries a

2820: and b.enabled_flag = 'Y'
2821: );
2822: */
2823:
2824: /* UPDATE ams_list_entries a
2825: SET a.enabled_flag = 'N',
2826: a.marked_as_duplicate_flag = 'Y'
2827: WHERE a.list_header_id =l_list_header_id
2828: and a.enabled_flag = 'Y'

Line 2830: from ams_list_entries b

2826: a.marked_as_duplicate_flag = 'Y'
2827: WHERE a.list_header_id =l_list_header_id
2828: and a.enabled_flag = 'Y'
2829: AND a.rowid > (SELECT min(b.rowid)
2830: from ams_list_entries b
2831: where b.list_header_id = l_list_header_id
2832: and b.party_id = a.party_id
2833: and b.enabled_flag = 'Y'
2834: and b.rank = a.rank

Line 2837: UPDATE ams_list_entries a

2833: and b.enabled_flag = 'Y'
2834: and b.rank = a.rank
2835: );
2836:
2837: UPDATE ams_list_entries a
2838: SET a.enabled_flag = 'N',
2839: a.marked_as_duplicate_flag = 'Y'
2840: WHERE a.list_header_id = l_list_header_id
2841: and a.enabled_flag = 'Y'

Line 2844: from ams_list_entries b

2840: WHERE a.list_header_id = l_list_header_id
2841: and a.enabled_flag = 'Y'
2842: -- AND a.rowid > (SELECT min(b.rowid)
2843: AND a.rank > (SELECT min(b.rank)
2844: from ams_list_entries b
2845: where b.list_header_id = l_list_header_id
2846: and b.party_id = a.party_id
2847: and b.enabled_flag = 'Y'
2848: );*/

Line 2860: UPDATE ams_list_entries a

2856: p_list_header_id => l_list_header_id );
2857:
2858: end if;
2859:
2860: UPDATE ams_list_entries a
2861: SET a.enabled_flag = 'N',
2862: a.marked_as_duplicate_flag = 'Y'
2863: WHERE a.list_header_id = l_list_header_id
2864: and a.enabled_flag = 'Y'

Line 2866: from ams_list_entries b

2862: a.marked_as_duplicate_flag = 'Y'
2863: WHERE a.list_header_id = l_list_header_id
2864: and a.enabled_flag = 'Y'
2865: AND a.rowid > (SELECT min(b.rowid)
2866: from ams_list_entries b
2867: where b.list_header_id = l_list_header_id
2868: and b.dedupe_key = a.dedupe_key
2869: and b.enabled_flag = 'Y'
2870: );*/

Line 2878: from ams_list_entries

2874:
2875:
2876: /*select count(1)
2877: into l_count
2878: from ams_list_entries
2879: where list_header_id = l_list_header_id
2880: and enabled_flag = 'Y';
2881:
2882: if l_generate_control_group_flag = 'Y' then

Line 2899: UPDATE ams_list_entries set

2895: p_log_used_by_id => g_list_header_id,
2896: p_level => 'LOW');
2897: end if;*/
2898:
2899: UPDATE ams_list_entries set
2900: source_code = l_source_code ,
2901: arc_list_used_by_source = p_list_used_by ,
2902: source_code_for_id = p_list_used_by_id
2903: where list_header_id = l_list_header_id ;

Line 3433: l_insert_sql := 'insert into ams_list_entries '||

3429:
3430:
3431:
3432: WRITE_TO_ACT_LOG('form_sql_statement:before insert_sql ','LIST',g_list_header_id);
3433: l_insert_sql := 'insert into ams_list_entries '||
3434: '( LIST_SELECT_ACTION_FROM_NAME, '||
3435: ' LIST_ENTRY_SOURCE_SYSTEM_ID , '||
3436: ' LIST_ENTRY_SOURCE_SYSTEM_TYPE, '||
3437: ' list_select_action_id , '||

Line 3466: 'ams_list_entries_s.nextval' || ','||

3462: to_char(sysdate )|| ''''||','||
3463: to_char(FND_GLOBAL.login_id )|| ',' ||''''||
3464: to_char(sysdate )|| ''''||','||
3465: to_char(nvl(l_created_by, FND_GLOBAL.login_id) )|| ',' ||
3466: 'ams_list_entries_s.nextval' || ','||
3467: 1 || ','||
3468: ''''||'NONE' ||'''' || ','||
3469: 0 || ',' ||
3470: ''''||'NONE' ||'''' || ','||

Line 3472: 'ams_list_entries_s.currval'|| ','||

3468: ''''||'NONE' ||'''' || ','||
3469: 0 || ',' ||
3470: ''''||'NONE' ||'''' || ','||
3471: ''''||'NONE' ||'''' || ','||
3472: 'ams_list_entries_s.currval'|| ','||
3473: 530 || ','||
3474: ''''||'N' ||''''|| ','||
3475: ''''||'N' ||''''|| ','||
3476: ''''||'N' ||''''|| ','||

Line 3826: ' from ams_list_entries ' ||

3822:
3823: l_final_big_sql := x_include_sql || x_std_sql ;
3824: l_const_sql := ' minus '||
3825: ' select list_entry_source_system_id ' ||
3826: ' from ams_list_entries ' ||
3827: ' where list_header_id = ' || g_list_header_id ;
3828: l_final_big_sql := l_final_big_sql || l_const_sql || ' )';
3829: --write_to_act_log('l_final_big_sql',null,null);
3830: l_no_of_chunks := ceil(length(l_final_big_sql)/2000 );