APPS.AMS_LIST_PURGE_PVT dependencies on FND_GLOBAL

Line 469: last_updated_by = FND_GLOBAL.user_id

465: user_status_id = l_status_id,
466: status_date = SYSDATE,
467: object_version_number = l_object_version + 1,
468: last_update_date = SYSDATE,
469: last_updated_by = FND_GLOBAL.user_id
470: WHERE a.import_list_header_id = l_import_list_header_id
471: AND a.object_version_number = l_object_version
472: AND NOT EXISTS (
473: SELECT import_source_line_id

Line 741: archived_by = FND_GLOBAL.user_id,

737: object_version_number = l_object_version + 1,
738: status_code = l_lookup_status,
739: user_status_id = l_user_status_id,
740: status_date = SYSDATE,
741: archived_by = FND_GLOBAL.user_id,
742: archived_date = SYSDATE,
743: last_update_date = SYSDATE,
744: last_updated_by = FND_GLOBAL.user_id
745: WHERE list_header_id = l_list_header_id;

Line 744: last_updated_by = FND_GLOBAL.user_id

740: status_date = SYSDATE,
741: archived_by = FND_GLOBAL.user_id,
742: archived_date = SYSDATE,
743: last_update_date = SYSDATE,
744: last_updated_by = FND_GLOBAL.user_id
745: WHERE list_header_id = l_list_header_id;
746: END IF; -- if sysdate >= l_grace_date
747: END IF; -- if l_sent_out_date is not null
748: -- END IF; -- if l_purged_flag = y

Line 918: , last_updated_by = FND_GLOBAL.user_id

914: UPDATE ams_imp_source_lines SET
915: current_usage = l_current_usage_tbl(i)
916: , object_version_number = l_object_version_tbl(i)
917: , last_update_date = SYSDATE
918: , last_updated_by = FND_GLOBAL.user_id
919: , last_update_login = FND_GLOBAL.conc_login_id
920: WHERE import_source_line_id = l_source_line_id_tbl(i);
921: END IF;
922:

Line 919: , last_update_login = FND_GLOBAL.conc_login_id

915: current_usage = l_current_usage_tbl(i)
916: , object_version_number = l_object_version_tbl(i)
917: , last_update_date = SYSDATE
918: , last_updated_by = FND_GLOBAL.user_id
919: , last_update_login = FND_GLOBAL.conc_login_id
920: WHERE import_source_line_id = l_source_line_id_tbl(i);
921: END IF;
922:
923: IF FND_API.to_boolean(p_commit) THEN

Line 1081: l_conc_request_id := FND_GLOBAL.conc_request_id();

1077: l_list_name_tbl l_char_tbl;
1078:
1079: BEGIN
1080: fnd_file.put_line(fnd_file.log,'Execution of Delete List entries master concurrent program started.');
1081: l_conc_request_id := FND_GLOBAL.conc_request_id();
1082: fnd_file.put_line(fnd_file.log,'Concurrent request id is '||l_conc_request_id);
1083: if p_list_header_id is not null then
1084: fnd_file.put_line(fnd_file.log,'List header id is '||p_list_header_id);
1085: -- Do the in use checks here before updating

Line 1399: l_conc_request_id := FND_GLOBAL.conc_request_id();

1395:
1396: BEGIN
1397:
1398: fnd_file.put_line(fnd_file.log,'Execution of Purge list and target group entries master concurrent program started.');
1399: l_conc_request_id := FND_GLOBAL.conc_request_id();
1400:
1401:
1402: fnd_file.put_line(fnd_file.log,'Concurrent request id is '||l_conc_request_id);
1403: fnd_file.put_line(fnd_file.log,'Created from date is '||p_cr_date_from);

Line 1497: archived_by = FND_GLOBAL.user_id,

1493: TCA_FAILED_RECORDS = 0,
1494: no_of_rows_initially_selected= 0,
1495: object_version_number = object_version_number + 1,
1496: status_date = SYSDATE,
1497: archived_by = FND_GLOBAL.user_id,
1498: archived_date = SYSDATE,
1499: last_update_date = SYSDATE,
1500: last_updated_by = FND_GLOBAL.user_id
1501: WHERE list_header_id = l_header_id_tbl(i);

Line 1500: last_updated_by = FND_GLOBAL.user_id

1496: status_date = SYSDATE,
1497: archived_by = FND_GLOBAL.user_id,
1498: archived_date = SYSDATE,
1499: last_update_date = SYSDATE,
1500: last_updated_by = FND_GLOBAL.user_id
1501: WHERE list_header_id = l_header_id_tbl(i);
1502:
1503: FOR i in 1 .. l_header_id_tbl.count
1504: LOOP