APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_LIST_IMPORT_ERRORS

Line 3307: from ams_list_import_errors

3303: where import_list_header_id = p_import_list_header_id;
3304:
3305: cursor c_error_exists is
3306: select 'Y'
3307: from ams_list_import_errors
3308: where import_list_header_id = p_import_list_header_id
3309: and import_source_line_id = p_import_source_line_id
3310: and batch_id = l_batch_id;
3311:

Line 3353: update ams_list_import_errors

3349: fetch c_file_type into l_file_type;
3350: close c_file_type;
3351:
3352: if l_error_exist = 'Y' then
3353: update ams_list_import_errors
3354: set col1 = substr(col1||','||p_error_text,1,4000)
3355: where import_list_header_id = p_import_list_header_id
3356: and import_source_line_id = p_import_source_line_id
3357: and batch_id = l_batch_id;

Line 3361: INSERT INTO ams_list_import_errors

3357: and batch_id = l_batch_id;
3358: end if;
3359:
3360: if l_error_exist is null then
3361: INSERT INTO ams_list_import_errors
3362: (
3363: LIST_IMPORT_ERROR_ID,
3364: LAST_UPDATED_BY,
3365: LAST_UPDATE_DATE,

Line 3378: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

3374: col1
3375: )
3376: VALUES
3377: (
3378: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
3379: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
3380: SYSDATE, -- LAST_UPDATE_DATE,
3381: SYSDATE, -- CREATION_DATE,
3382: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 3499: update ams_list_import_errors

3495: open c_error_exists;
3496: fetch c_error_exists into l_error_exist;
3497: close c_error_exists;
3498: if l_error_exist = 'Y' then
3499: update ams_list_import_errors
3500: set col350 = substr(col350||','||p_error_text,1,4000)
3501: where import_list_header_id = p_import_list_header_id
3502: and import_source_line_id = p_import_source_line_id;
3503: end if;

Line 3505: INSERT INTO ams_list_import_errors

3501: where import_list_header_id = p_import_list_header_id
3502: and import_source_line_id = p_import_source_line_id;
3503: end if;
3504: if l_error_exist is null then
3505: INSERT INTO ams_list_import_errors
3506: (
3507: LIST_IMPORT_ERROR_ID,
3508: LAST_UPDATED_BY,
3509: LAST_UPDATE_DATE,

Line 3522: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

3518: col1
3519: )
3520: VALUES
3521: (
3522: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
3523: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
3524: SYSDATE, -- LAST_UPDATE_DATE,
3525: SYSDATE, -- CREATION_DATE,
3526: FND_GLOBAL.User_ID, -- CREATED_BY,