APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_LIST_IMPORT_ERRORS

Line 3300: from ams_list_import_errors

3296: where import_list_header_id = p_import_list_header_id;
3297:
3298: cursor c_error_exists is
3299: select 'Y'
3300: from ams_list_import_errors
3301: where import_list_header_id = p_import_list_header_id
3302: and import_source_line_id = p_import_source_line_id
3303: and batch_id = l_batch_id;
3304:

Line 3346: update ams_list_import_errors

3342: fetch c_file_type into l_file_type;
3343: close c_file_type;
3344:
3345: if l_error_exist = 'Y' then
3346: update ams_list_import_errors
3347: set col1 = substr(col1||','||p_error_text,1,4000)
3348: where import_list_header_id = p_import_list_header_id
3349: and import_source_line_id = p_import_source_line_id
3350: and batch_id = l_batch_id;

Line 3354: INSERT INTO ams_list_import_errors

3350: and batch_id = l_batch_id;
3351: end if;
3352:
3353: if l_error_exist is null then
3354: INSERT INTO ams_list_import_errors
3355: (
3356: LIST_IMPORT_ERROR_ID,
3357: LAST_UPDATED_BY,
3358: LAST_UPDATE_DATE,

Line 3371: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

3367: col1
3368: )
3369: VALUES
3370: (
3371: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
3372: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
3373: SYSDATE, -- LAST_UPDATE_DATE,
3374: SYSDATE, -- CREATION_DATE,
3375: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 3492: update ams_list_import_errors

3488: open c_error_exists;
3489: fetch c_error_exists into l_error_exist;
3490: close c_error_exists;
3491: if l_error_exist = 'Y' then
3492: update ams_list_import_errors
3493: set col350 = substr(col350||','||p_error_text,1,4000)
3494: where import_list_header_id = p_import_list_header_id
3495: and import_source_line_id = p_import_source_line_id;
3496: end if;

Line 3498: INSERT INTO ams_list_import_errors

3494: where import_list_header_id = p_import_list_header_id
3495: and import_source_line_id = p_import_source_line_id;
3496: end if;
3497: if l_error_exist is null then
3498: INSERT INTO ams_list_import_errors
3499: (
3500: LIST_IMPORT_ERROR_ID,
3501: LAST_UPDATED_BY,
3502: LAST_UPDATE_DATE,

Line 3515: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

3511: col1
3512: )
3513: VALUES
3514: (
3515: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
3516: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
3517: SYSDATE, -- LAST_UPDATE_DATE,
3518: SYSDATE, -- CREATION_DATE,
3519: FND_GLOBAL.User_ID, -- CREATED_BY,