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 4680: ( select ams_list_entries_s.nextval,

4676: exclude_in_triggered_list_flag ,
4677: enabled_flag,
4678: object_version_number
4679: )
4680: ( select ams_list_entries_s.nextval,
4681: sysdate,
4682: fnd_global.user_id,
4683: sysdate,
4684: nvl(l_created_by, fnd_global.user_id),

Line 4693: ams_list_entries_s.currval,

4689: s.incl_object_name,
4690: 'NONE',
4691: 0,
4692: h.list_used_by_id,
4693: ams_list_entries_s.currval,
4694: t.list_entry_source_id,
4695: t.list_entry_source_type,
4696: fnd_global.conc_login_id,
4697: 'N',

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

6507:
6508: write_to_act_log('Executing procedure get_list_entry_data.', 'LIST', g_list_header_id,'LOW');
6509: OPEN C_MAPPING_TYPES_USED(p_list_header_id);
6510: LOOP
6511: l_update_str := 'UPDATE ams_list_entries SET (';
6512: l_select_str := ' ) = ( SELECT ';
6513: l_header_clause := ' AND list_header_id = '||
6514: to_char(p_list_header_id);
6515: l_type_clause := ' AND list_entry_source_system_type = ';

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

6629: end if;
6630: l_iterator := 0;
6631: l_list_entry_columns := l_NULL_table;
6632: l_source_columns := l_NULL_table;
6633: l_update_str := 'UPDATE ams_list_entries SET (';
6634: l_select_str := ' ) = ( SELECT ';
6635: l_header_clause := ' AND list_header_id = '||
6636: to_char(p_list_header_id);
6637: l_type_clause := ' AND list_entry_source_system_type = ';

Line 10241: /* UPDATE ams_list_entries set

10237: end if;
10238:
10239: END if;
10240: --Code movded from tg api.
10241: /* UPDATE ams_list_entries set
10242: source_code = l_source_code ,
10243: arc_list_used_by_source = p_list_used_by ,
10244: source_code_for_id = p_list_used_by_id
10245: where list_header_id = g_list_header_id ;

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

10444: l_rank number := 0;
10445: BEGIN
10446: write_to_act_log('Executing procedure execute_remote_dedupe_list', 'LIST', p_list_header_id,'LOW');
10447: IF (p_object_name = 'AMS_LIST_ENTRIES') THEN
10448: l_sql_stmt1 := 'update ams_list_entries set dedupe_key = ';
10449: END IF;
10450:
10451: --performing check to see if this list has been deduped before.
10452: OPEN c_deduped_before (p_list_header_id);

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

10479: OUT l_return_status,
10480: OUT l_msg_count,
10481: OUT l_msg_data,
10482: p_list_header_id,
10483: 'UPDATE ams_list_entries SET dedupe_key = NULL WHERE list_header_id = '||to_char(p_list_header_id),
10484: l_null,
10485: l_null,
10486: OUT l_total_dup_recs,
10487: 'DEDUPE1';

Line 11185: ams_list_entries_s.nextval,

11181: RANK
11182: )
11183: SELECT
11184: list_header_id,
11185: ams_list_entries_s.nextval,
11186: object_version_number,
11187: source_code ,
11188: source_code_for_id ,
11189: arc_list_used_by_source ,

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

13698:
13699: -- DBMS_OUTPUT.PUT_LINE('TCA Upload Process : x_tmp_var ->' || x_tmp_var );
13700: -- DBMS_OUTPUT.PUT_LINE('TCA Upload Process : x_tmp_var ->' || x_tmp_var1 );
13701: END LOOP;
13702: update ams_list_entries set error_flag = 'E',
13703: tca_load_status = 'ERROR',
13704: ENABLED_FLAG = 'N',
13705: --error_text = 'TCA API ERROR :'||substr(x_tmp_var1,1,3000)
13706: error_text = 'TCA API ERROR :'||x_tmp_var

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

13706: error_text = 'TCA API ERROR :'||x_tmp_var
13707: where list_entry_id = l_list_entry_id;
13708: end if;
13709: if l_party_id is null then
13710: update ams_list_entries set error_flag = 'E',
13711: tca_load_status = 'ERROR',
13712: ENABLED_FLAG = 'N',
13713: --error_text = 'TCA API ERROR :'||nvl(x_tmp_var,substr(x_tmp_var1,1,3000))
13714: error_text = 'TCA API ERROR :'||x_tmp_var

Line 13719: update ams_list_entries set party_id = l_party_id,

13715: where list_entry_id = l_list_entry_id;
13716: end if;
13717:
13718: if l_party_id is not null then
13719: update ams_list_entries set party_id = l_party_id,
13720: error_flag = 'S',
13721: ENABLED_FLAG = 'Y',
13722: tca_load_status = 'SUCCESS'
13723: where list_entry_id = l_list_entry_id;