APPS.AMS_IMP_REG_DETAIL_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 19: from AMS_IMP_LIST_HEADERS_ALL

15: IS
16: CURSOR c_get_header_id IS
17: -- soagrawa 05-feb-2003 fixed bug# 2773827
18: SELECT IMPORT_LIST_HEADER_ID, PROCESSED_ROWS, NUMBER_OF_FAILED_RECORDS, record_update_flag
19: from AMS_IMP_LIST_HEADERS_ALL
20: where IMPORT_TYPE = 'EVENT'
21: and nvl(PROCESSED_ROWS, -1) < nvl(LOADED_NO_OF_ROWS, 0);
22:
23: CURSOR c_get_row_metadata(p_list_header_id in NUMBER) IS

Line 26: from AMS_IMP_LIST_HEADERS_ALL

22:
23: CURSOR c_get_row_metadata(p_list_header_id in NUMBER) IS
24: -- soagrawa 05-feb-2003 fixed bug# 2773827
25: SELECT PROCESSED_ROWS, NUMBER_OF_FAILED_RECORDS, record_update_flag
26: from AMS_IMP_LIST_HEADERS_ALL
27: where IMPORT_TYPE = 'EVENT'
28: and import_list_header_id = p_list_header_id;
29: --and nvl(PROCESSED_ROWS, -1) < nvl(LOADED_NO_OF_ROWS, 0);
30:

Line 1086: UPDATE ams_imp_list_headers_all

1082: );
1083: --FND_FILE.PUT_LINE(FND_FILE.LOG,'check the log table for detail error message');
1084: END IF;
1085: --DBMS_OUTPUT.put_line('Inside update_imp_hdr_line_rec');
1086: UPDATE ams_imp_list_headers_all
1087: SET processed_rows = p_processed_rows,
1088: number_of_failed_records = p_failed_rows
1089: WHERE import_list_header_id = p_imp_hdr_id;
1090: END;