APPS.AMS_LIST_PURGE_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 41: FROM ams_imp_list_headers_all

37:
38: CURSOR c_all_imp_list_rec IS
39: SELECT import_list_header_id, object_version_number,
40: creation_date, expiry_date, usage
41: FROM ams_imp_list_headers_all
42: WHERE rented_list_flag = 'R'
43: and status_code <> 'PURGED';
44:
45: -- l_all_imp_list_rec c_all_imp_list_rec%ROWTYPE;

Line 454: AMS_Utility_PVT.Debug_Message(l_api_name||': Delete log and update ams_imp_list_headers_all ');

450: END IF;
451:
452: IF (AMS_DEBUG_HIGH_ON) THEN
453: AMS_Utility_PVT.debug_message(l_api_name||': count of ams_imp_source_lines deleted:'||sql%rowcount);
454: AMS_Utility_PVT.Debug_Message(l_api_name||': Delete log and update ams_imp_list_headers_all ');
455: END IF;
456:
457: OPEN C_get_usr_status(l_lookup_code);
458: FETCH C_get_usr_status INTO l_status_id;

Line 462: -- Update ams_imp_list_headers_all, only when all the lines are purged.

458: FETCH C_get_usr_status INTO l_status_id;
459: CLOSE C_get_usr_status;
460:
461: l_upd_status_code := NULL;
462: -- Update ams_imp_list_headers_all, only when all the lines are purged.
463: UPDATE ams_imp_list_headers_all a
464: SET status_code = l_lookup_code,
465: user_status_id = l_status_id,
466: status_date = SYSDATE,

Line 463: UPDATE ams_imp_list_headers_all a

459: CLOSE C_get_usr_status;
460:
461: l_upd_status_code := NULL;
462: -- Update ams_imp_list_headers_all, only when all the lines are purged.
463: UPDATE ams_imp_list_headers_all a
464: SET status_code = l_lookup_code,
465: user_status_id = l_status_id,
466: status_date = SYSDATE,
467: object_version_number = l_object_version + 1,

Line 513: DELETE FROM ams_imp_list_headers_all

509:
510: AMS_Utility_PVT.Debug_Message(l_api_name||': Delete cancelld imp list headers ');
511:
512: END IF;
513: DELETE FROM ams_imp_list_headers_all
514: WHERE status_code = 'CANCELLED';
515:
516: -- If no errors, commit the work
517: COMMIT WORK;