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_LISTGENERATION_PKG dependencies on AMS_LIST_ENTRIES_S

Line 977: write_to_act_log('Executing delete_list_entries to delete entries from ams_list_entries(Since list/target group is generated in STANDARD mode).', 'LIST', g_list_header_id,'LOW');

973: l_total_recs number;
974: l_null varchar2(30) := null;
975: -- deletes from ams_list_entries in case of standard type of generation
976: BEGIN
977: write_to_act_log('Executing delete_list_entries to delete entries from ams_list_entries(Since list/target group is generated in STANDARD mode).', 'LIST', g_list_header_id,'LOW');
978: x_return_status := FND_API.G_RET_STS_SUCCESS;
979: -------------------------------------------------------------------------------
980: --Delete all existing entries for this list which are in the temporary table.--
981: -------------------------------------------------------------------------------

Line 1388: ams_list_entries_s.nextval, import_source_line_id,

1384: FAX
1385: )
1386: select
1387: ' || p_action_used_by_id || ' ,
1388: ams_list_entries_s.nextval, import_source_line_id,
1389: 1 ,' ||
1390: ''''||'NONE' ||'''' || ','||
1391: 0 || ',' ||
1392: ''''||'NONE' ||'''' || ','||

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

1390: ''''||'NONE' ||'''' || ','||
1391: 0 || ',' ||
1392: ''''||'NONE' ||'''' || ','||
1393: ''''||'IMPH' ||'''' || ','||
1394: 'ams_list_entries_s.currval'|| ','||
1395: 530 || ','||
1396: ''''||'N' ||''''|| ','||
1397: ''''||'N' ||''''|| ','||
1398: ''''||'N' ||''''|| ','||

Line 1580: ams_list_entries_s.nextval, ' ||

1576: FAX
1577: )
1578: select
1579: ' || p_action_used_by_id || ' ,
1580: ams_list_entries_s.nextval, ' ||
1581: ' import_source_line_id , ' ||
1582: ''''||'NONE' ||'''' || ','||
1583: 0 || ',' ||
1584: ''''||'NONE' ||'''' || ','||

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

1582: ''''||'NONE' ||'''' || ','||
1583: 0 || ',' ||
1584: ''''||'NONE' ||'''' || ','||
1585: ''''||'IMPH' ||'''' || ','||
1586: 'ams_list_entries_s.currval'|| ','||
1587: 530 || ','||
1588: ''''||'N' ||''''|| ','||
1589: ''''||'N' ||''''|| ','||
1590: ''''||'N' ||''''|| ','||

Line 2095: ams_list_entries_s.nextval,

2091: CUSTOM_COLUMN25
2092: )
2093: select ' ||
2094: p_action_used_by_id ||',
2095: ams_list_entries_s.nextval,
2096: 1 ,' ||
2097: ''''||'NONE' ||'''' || ','||
2098: 0 || ',' ||
2099: ''''||'NONE' ||'''' || ','||

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

2097: ''''||'NONE' ||'''' || ','||
2098: 0 || ',' ||
2099: ''''||'NONE' ||'''' || ','||
2100: ''''||'LIST' ||'''' || ','||
2101: 'ams_list_entries_s.currval'|| ','||
2102: 530 || ','||
2103: ''''||'N' ||''''|| ','||
2104: ''''||'N' ||''''|| ','||
2105: ''''||'N' ||''''|| ','||

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

2776: to_char(sysdate )|| ''''||','||
2777: to_char(FND_GLOBAL.login_id )|| ',' ||''''||
2778: to_char(sysdate )|| ''''||','||
2779: to_char(nvl(l_created_by, FND_GLOBAL.login_id) )|| ',' ||
2780: 'ams_list_entries_s.nextval' || ','||
2781: 1 || ','||
2782: ''''||'NONE' ||'''' || ','||
2783: 0 || ',' ||
2784: ''''||'NONE' ||'''' || ','||

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

2782: ''''||'NONE' ||'''' || ','||
2783: 0 || ',' ||
2784: ''''||'NONE' ||'''' || ','||
2785: ''''||'NONE' ||'''' || ','||
2786: 'ams_list_entries_s.currval'|| ','||
2787: 530 || ','||
2788: ''''||'N' ||''''|| ','||
2789: ''''||'N' ||''''|| ','||
2790: ''''||'N' ||''''|| ','||

Line 4687: ( select ams_list_entries_s.nextval,

4683: exclude_in_triggered_list_flag ,
4684: enabled_flag,
4685: object_version_number
4686: )
4687: ( select ams_list_entries_s.nextval,
4688: sysdate,
4689: fnd_global.user_id,
4690: sysdate,
4691: nvl(l_created_by, fnd_global.user_id),

Line 4700: ams_list_entries_s.currval,

4696: s.incl_object_name,
4697: 'NONE',
4698: 0,
4699: h.list_used_by_id,
4700: ams_list_entries_s.currval,
4701: t.list_entry_source_id,
4702: t.list_entry_source_type,
4703: fnd_global.conc_login_id,
4704: 'N',

Line 6518: l_update_str := 'UPDATE ams_list_entries SET (';

6514:
6515: write_to_act_log('Executing procedure get_list_entry_data.', 'LIST', g_list_header_id,'LOW');
6516: OPEN C_MAPPING_TYPES_USED(p_list_header_id);
6517: LOOP
6518: l_update_str := 'UPDATE ams_list_entries SET (';
6519: l_select_str := ' ) = ( SELECT DISTINCT ';
6520: l_header_clause := ' AND list_header_id = '||
6521: to_char(p_list_header_id);
6522: l_type_clause := ' AND list_entry_source_system_type = ';

Line 6654: l_update_str := 'UPDATE ams_list_entries SET (';

6650: end if;
6651: l_iterator := 0;
6652: l_list_entry_columns := l_NULL_table;
6653: l_source_columns := l_NULL_table;
6654: l_update_str := 'UPDATE ams_list_entries SET (';
6655: l_select_str := ' ) = ( SELECT ';
6656: l_header_clause := ' AND list_header_id = '||
6657: to_char(p_list_header_id);
6658: l_type_clause := ' AND list_entry_source_system_type = ';

Line 10342: /* UPDATE ams_list_entries set

10338: end if;
10339:
10340: END if;
10341: --Code movded from tg api.
10342: /* UPDATE ams_list_entries set
10343: source_code = l_source_code ,
10344: arc_list_used_by_source = p_list_used_by ,
10345: source_code_for_id = p_list_used_by_id
10346: where list_header_id = g_list_header_id ;

Line 10549: l_sql_stmt1 := 'update ams_list_entries set dedupe_key = ';

10545: l_rank number := 0;
10546: BEGIN
10547: write_to_act_log('Executing procedure execute_remote_dedupe_list', 'LIST', p_list_header_id,'LOW');
10548: IF (p_object_name = 'AMS_LIST_ENTRIES') THEN
10549: l_sql_stmt1 := 'update ams_list_entries set dedupe_key = ';
10550: END IF;
10551:
10552: --performing check to see if this list has been deduped before.
10553: OPEN c_deduped_before (p_list_header_id);

Line 10584: 'UPDATE ams_list_entries SET dedupe_key = NULL WHERE list_header_id = '||to_char(p_list_header_id),

10580: OUT l_return_status,
10581: OUT l_msg_count,
10582: OUT l_msg_data,
10583: p_list_header_id,
10584: 'UPDATE ams_list_entries SET dedupe_key = NULL WHERE list_header_id = '||to_char(p_list_header_id),
10585: l_null,
10586: l_null,
10587: OUT l_total_dup_recs,
10588: 'DEDUPE1';

Line 11286: ams_list_entries_s.nextval,

11282: RANK
11283: )
11284: SELECT
11285: list_header_id,
11286: ams_list_entries_s.nextval,
11287: object_version_number,
11288: source_code ,
11289: source_code_for_id ,
11290: arc_list_used_by_source ,

Line 13803: update ams_list_entries set error_flag = 'E',

13799:
13800: -- DBMS_OUTPUT.PUT_LINE('TCA Upload Process : x_tmp_var ->' || x_tmp_var );
13801: -- DBMS_OUTPUT.PUT_LINE('TCA Upload Process : x_tmp_var ->' || x_tmp_var1 );
13802: END LOOP;
13803: update ams_list_entries set error_flag = 'E',
13804: tca_load_status = 'ERROR',
13805: ENABLED_FLAG = 'N',
13806: --error_text = 'TCA API ERROR :'||substr(x_tmp_var1,1,3000)
13807: error_text = 'TCA API ERROR :'||x_tmp_var

Line 13811: update ams_list_entries set error_flag = 'E',

13807: error_text = 'TCA API ERROR :'||x_tmp_var
13808: where list_entry_id = l_list_entry_id;
13809: end if;
13810: if l_party_id is null then
13811: update ams_list_entries set error_flag = 'E',
13812: tca_load_status = 'ERROR',
13813: ENABLED_FLAG = 'N',
13814: --error_text = 'TCA API ERROR :'||nvl(x_tmp_var,substr(x_tmp_var1,1,3000))
13815: error_text = 'TCA API ERROR :'||x_tmp_var

Line 13820: update ams_list_entries set party_id = l_party_id,

13816: where list_entry_id = l_list_entry_id;
13817: end if;
13818:
13819: if l_party_id is not null then
13820: update ams_list_entries set party_id = l_party_id,
13821: error_flag = 'S',
13822: ENABLED_FLAG = 'Y',
13823: tca_load_status = 'SUCCESS'
13824: where list_entry_id = l_list_entry_id;