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_LIST_PURGE_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 60: FROM ams_list_select_actions a, ams_list_headers_all b

56: l_upd_status_code VARCHAR2(30);
57:
58: CURSOR c_list_entries_rec_int (c_imp_header_id NUMBER) IS
59: SELECT DISTINCT b.list_header_id
60: FROM ams_list_select_actions a, ams_list_headers_all b
61: WHERE a.incl_object_id = c_imp_header_id
62: AND a.arc_incl_object_from = 'IMPH'
63: AND a.action_used_by_id = b.list_header_id
64: AND (b.list_type <> 'TARGET' OR b.status_code <> 'LOCKED');

Line 68: FROM ams_list_select_actions a, ams_list_headers_all b

64: AND (b.list_type <> 'TARGET' OR b.status_code <> 'LOCKED');
65:
66: CURSOR c_list_entries_force_rec_int (c_imp_header_id NUMBER) IS
67: SELECT DISTINCT b.list_header_id
68: FROM ams_list_select_actions a, ams_list_headers_all b
69: WHERE a.incl_object_id = c_imp_header_id
70: AND a.arc_incl_object_from = 'IMPH'
71: AND a.action_used_by_id = b.list_header_id;
72:

Line 281: UPDATE ams_list_headers_all

277: --IF l_list_iterator > 0 THEN
278: IF l_list_size_tbl.last > 0
279: THEN
280: FORALL i IN l_list_size_tbl.first .. l_list_size_tbl.last
281: UPDATE ams_list_headers_all
282: SET (no_of_rows_in_list
283: , no_of_rows_active
284: , last_update_date )=(select count(1),
285: sum(decode(enabled_flag,'Y',1,0)),

Line 414: UPDATE ams_list_headers_all

410: -- Do bulk update on list headers
411: --IF l_list_iterator > 0 THEN
412: IF l_list_size_tbl.last > 0 THEN
413: FORALL i IN l_list_size_tbl.first .. l_list_size_tbl.last
414: UPDATE ams_list_headers_all
415: SET (no_of_rows_in_list
416: , no_of_rows_active
417: , last_update_date )=(select count(1),
418: sum(decode(enabled_flag,'Y',1,0)),

Line 615: FROM ams_list_headers_all

611: CURSOR c_all_target_rec(p_list_type in VARCHAR2, p_list_status in VARCHAR2)
612: IS
613: SELECT list_header_id, status_code, object_version_number, purge_flag,
614: sent_out_date
615: FROM ams_list_headers_all
616: WHERE list_type = p_list_type
617: AND upper(status_code) <> p_list_status;
618:
619:

Line 704: -- Update ams_list_headers_all

700: -- initialize any default values
701:
702: --Should set the values for the summary cols to zero. there wont be any entries in the list entries table.
703: /*
704: -- Update ams_list_headers_all
705: UPDATE ams_list_headers_all
706: SET (no_of_rows_in_list
707: , no_of_rows_active
708: , NO_OF_ROWS_DUPLICATES

Line 705: UPDATE ams_list_headers_all

701:
702: --Should set the values for the summary cols to zero. there wont be any entries in the list entries table.
703: /*
704: -- Update ams_list_headers_all
705: UPDATE ams_list_headers_all
706: SET (no_of_rows_in_list
707: , no_of_rows_active
708: , NO_OF_ROWS_DUPLICATES
709: , NO_OF_ROWS_INACTIVE

Line 725: UPDATE ams_list_headers_all

721: OPEN c_get_user_status_id (l_lookup_status);
722: FETCH c_get_user_status_id INTO l_user_status_id;
723: CLOSE c_get_user_status_id ;
724:
725: UPDATE ams_list_headers_all
726: SET no_of_rows_in_list = 0,
727: no_of_rows_active = 0,
728: no_of_rows_inactive = 0,
729: no_of_rows_in_ctrl_group = 0,

Line 1021: DELETE from ams_list_headers_all

1017: WHERE cond.template_id = inst.template_id
1018: AND inst.instance_used_by_id is not null);
1019:
1020: FORALL i in 1 .. p_id_tbl.count
1021: DELETE from ams_list_headers_all
1022: WHERE list_header_id = p_id_tbl(i);
1023:
1024: EXCEPTION
1025: WHEN others then

Line 1042: FROM ams_list_headers_all

1038: , p_num_workers IN NUMBER DEFAULT 3) IS
1039:
1040: CURSOR c_get_list_header_status IS
1041: SELECT status_code
1042: FROM ams_list_headers_all
1043: WHERE list_header_id = p_list_header_id;
1044:
1045: CURSOR c_is_used_in_sel IS
1046: SELECT list_header_id

Line 1091: UPDATE ams_list_headers_all

1087: OPEN c_get_list_header_status;
1088: FETCH c_get_list_header_status INTO l_list_header_status;
1089: CLOSE c_get_list_header_status;
1090: if l_list_header_status = 'DELETED' then
1091: UPDATE ams_list_headers_all
1092: SET request_id = l_conc_request_id,user_status_id = 314
1093: WHERE list_header_id = p_list_header_id;
1094: fnd_file.put_line(fnd_file.log,'List header status is already DELETED');
1095: else

Line 1108: UPDATE ams_list_headers_all

1104: fnd_file.put_line(fnd_file.log,'This list is in use. Could not be deleted.');
1105: return;
1106: else
1107: fnd_file.put_line(fnd_file.log,'This list is not in use. Could be deleted.');
1108: UPDATE ams_list_headers_all
1109: SET request_id = l_conc_request_id, status_code = 'DELETED', user_status_id = 314
1110: WHERE list_header_id = p_list_header_id;
1111: end if;
1112: end if;

Line 1115: update ams_list_headers_all

1111: end if;
1112: end if;
1113: else
1114: fnd_file.put_line(fnd_file.log,'No list header id passed. So all the entries for lists in DELETED status will be deleted');
1115: update ams_list_headers_all
1116: set request_id = l_conc_request_id
1117: where status_code = 'DELETED';
1118: end if;
1119: fnd_file.put_line(fnd_file.log,'Submitting sub requests');

Line 1247: WHERE list_header_id IN (select list_header_id from ams_list_headers_all

1243: WHILE ( l_any_rows_to_process = TRUE )
1244: LOOP
1245: DELETE /*+ rowid(entries) */
1246: AMS_LIST_ENTRIES entries
1247: WHERE list_header_id IN (select list_header_id from ams_list_headers_all
1248: where request_id = x_argument4)
1249: AND ROWID BETWEEN l_start_rowid AND l_end_rowid;
1250:
1251: ad_parallel_updates_pkg.processed_rowid_range

Line 1300: UPDATE ams_list_headers_all

1296: l_header_id_tbl(i) := p_list_header_id_tbl(i).l_list_header_id;
1297: END LOOP;
1298:
1299: FORALL i in 1 .. l_header_id_tbl.count
1300: UPDATE ams_list_headers_all
1301: SET status_code = 'DELETED', user_status_id = 314
1302: WHERE list_header_id = l_header_id_tbl(i);
1303:
1304: COMMIT;

Line 1411: UPDATE ams_list_headers_all head

1407: l_end_date := to_date(p_cr_date_to, 'YYYY/MM/DD HH24:MI:SS');
1408:
1409: if p_list_type is not null then
1410: fnd_file.put_line(fnd_file.log,'Type chosen is '||p_list_type);
1411: UPDATE ams_list_headers_all head
1412: SET request_id = l_conc_request_id,last_update_date = sysdate
1413: WHERE status_code in ('AVAILABLE','LOCKED')
1414: AND trunc(creation_date) between trunc(l_start_date) AND trunc(l_end_date)
1415: AND list_type = p_list_type

Line 1423: UPDATE ams_list_headers_all head

1419: AND nvl(type.remote_flag,'N') = 'Y') ;
1420: -- AND nvl(remote_gen_flag,'N') = 'N';
1421: else
1422: fnd_file.put_line(fnd_file.log,'Type is not chosen. All the matching list and target group will be purged. ' );
1423: UPDATE ams_list_headers_all head
1424: SET request_id = l_conc_request_id,last_update_date = sysdate
1425: WHERE status_code in ('AVAILABLE','LOCKED')
1426: AND trunc(creation_date) between trunc(l_start_date) AND trunc(l_end_date)
1427: AND not exists (SELECT 1

Line 1480: UPDATE ams_list_headers_all

1476: DELETE from ams_act_logs
1477: WHERE act_log_used_by_id = l_header_id_tbl(i);
1478:
1479: FORALL i in 1 .. l_header_id_tbl.count
1480: UPDATE ams_list_headers_all
1481: SET status_code = 'PURGED',
1482: user_status_id = 313,
1483: no_of_rows_in_list = 0,
1484: no_of_rows_active = 0,

Line 1591: WHERE list_header_id IN (select list_header_id from ams_list_headers_all

1587: WHILE ( l_any_rows_to_process = TRUE )
1588: LOOP
1589: DELETE /*+ rowid(entries) */
1590: AMS_LIST_ENTRIES entries
1591: WHERE list_header_id IN (select list_header_id from ams_list_headers_all
1592: where request_id = x_argument4)
1593: AND ROWID BETWEEN l_start_rowid AND l_end_rowid;
1594:
1595: ad_parallel_updates_pkg.processed_rowid_range