eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LISTIMPORT_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 393: select nvl(batch_size,0),parent_request_id from ams_imp_list_headers_all

389: i_batch_size number;
390:
391:
392: cursor c_header_status is
393: select nvl(batch_size,0),parent_request_id from ams_imp_list_headers_all
394: where import_list_header_id = p_import_list_header_id;
395:
396: cursor c_total_recs is
397: select count(*) from ams_imp_source_lines

Line 406: select import_type from ams_imp_list_headers_all

402:
403: -- Cursor to check if it's B2B or B2C party type.
404:
405: cursor b2borb2c is
406: select import_type from ams_imp_list_headers_all
407: where import_list_header_id = p_import_list_header_id;
408:
409:
410: /* For Mapped party */

Line 413: ams_imp_list_headers_all hd

409:
410: /* For Mapped party */
411: cursor party_mapped is
412: SELECT 'Y' FROM ams_list_src_fields sf,
413: ams_imp_list_headers_all hd
414: WHERE sf.field_column_name = 'PARTY_ID'
415: AND sf.enabled_flag = 'Y'
416: AND sf.list_source_type_id = hd.list_source_type_id
417: and hd.import_type = 'CUSTOMER'

Line 932: select status_code from ams_imp_list_headers_all

928: where fnd.user_Name = upper(x_sa_email_address)
929: and fnd.user_id = ams.user_id;
930:
931: cursor c_hdr_status is
932: select status_code from ams_imp_list_headers_all
933: where import_list_header_id = p_import_list_header_id;
934:
935: party_rec hz_party_v2pub.party_rec_type;
936: org_rec hz_party_v2pub.organization_rec_type;

Line 1084: update ams_imp_list_headers_all set BATCH_SIZE = l_numb_of_inst,

1080: end if;
1081: if l_numb_of_inst > 10 then
1082: l_numb_of_inst := 10;
1083: end if;
1084: update ams_imp_list_headers_all set BATCH_SIZE = l_numb_of_inst,
1085: parent_request_id = l_request_id
1086: where import_list_header_id = p_import_list_header_id;
1087: commit;
1088:

Line 1183: update ams_imp_list_headers_all set BATCH_SIZE = BATCH_SIZE - 1

1179: p_msg_type => 'DEBUG');
1180: */
1181: ELSIF p_number_of_processes = 0 THEN
1182:
1183: update ams_imp_list_headers_all set BATCH_SIZE = BATCH_SIZE - 1
1184: where import_list_header_id = p_import_list_header_id;
1185: commit;
1186:
1187:

Line 1746: UPDATE ams_imp_list_headers_all

1742: l_vr_code_exists := null;
1743: END LOOP;
1744: CLOSE b2b;
1745:
1746: UPDATE ams_imp_list_headers_all
1747: -- SET processed_rows = i_number_of_rows_processed
1748: SET processed_rows = nvl(processed_rows,0) + i_number_of_rows_processed
1749: WHERE import_list_header_id = p_import_list_header_id;
1750:

Line 2145: UPDATE ams_imp_list_headers_all

2141:
2142: END LOOP;
2143: CLOSE b2c;
2144:
2145: UPDATE ams_imp_list_headers_all
2146: -- SET processed_rows = i_number_of_rows_processed
2147: SET processed_rows = nvl(processed_rows,0) + i_number_of_rows_processed
2148: WHERE import_list_header_id = p_import_list_header_id;
2149:

Line 2202: UPDATE ams_imp_list_headers_all

2198: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2199: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2200: system_status_code = 'ERROR' and default_flag = 'Y';
2201:
2202: UPDATE ams_imp_list_headers_all
2203: set status_code = l_lookup_code,
2204: user_status_id = l_user_status_id,
2205: status_date = sysdate
2206: where import_list_header_id = p_import_list_header_id;

Line 2286: select name, server_flag, status_code, import_type, execute_mode from ams_imp_list_headers_all

2282: FROM ams_imp_source_lines
2283: WHERE import_list_header_id = p_import_list_header_id;
2284:
2285: cursor c_header_name is
2286: select name, server_flag, status_code, import_type, execute_mode from ams_imp_list_headers_all
2287: where import_list_header_id = p_import_list_header_id;
2288:
2289: cursor c_status is
2290: select status_code, nvl(dedupe_flag,'N') from ams_imp_list_headers_all

Line 2290: select status_code, nvl(dedupe_flag,'N') from ams_imp_list_headers_all

2286: select name, server_flag, status_code, import_type, execute_mode from ams_imp_list_headers_all
2287: where import_list_header_id = p_import_list_header_id;
2288:
2289: cursor c_status is
2290: select status_code, nvl(dedupe_flag,'N') from ams_imp_list_headers_all
2291: where import_list_header_id = p_import_list_header_id;
2292:
2293: cursor c_dup_recs is
2294: select count(*) from ams_imp_source_lines

Line 2316: ams_imp_list_headers_all hd

2312:
2313: -- For Mapped osr
2314: cursor osr_mapped is
2315: SELECT 'Y' FROM ams_list_src_fields sf,
2316: ams_imp_list_headers_all hd
2317: WHERE sf.field_column_name = 'ORIG_SYSTEM_REFERENCE'
2318: AND sf.enabled_flag = 'Y'
2319: AND sf.list_source_type_id = hd.list_source_type_id
2320: and hd.import_type in ('B2B','B2C')

Line 2351: UPDATE ams_imp_list_headers_all

2347: system_status_code = 'STAGED' and default_flag = 'Y';
2348:
2349: select as_import_interface_s.nextval into l_batch_id from dual;
2350:
2351: UPDATE ams_imp_list_headers_all
2352: set status_code = l_lookup_code,
2353: user_status_id = l_user_status_id,
2354: batch_id = l_batch_id,
2355: status_date = sysdate

Line 2379: UPDATE ams_imp_list_headers_all

2375: -- commented by ndadwal for Bug 5113207
2376: /* if l_status_code = 'NEW' then
2377: if l_server_flag = 'Y' then
2378: if p_staged_only = 'Y' then
2379: UPDATE ams_imp_list_headers_all
2380: set loaded_no_of_rows = l_loaded_rows,
2381: loaded_date = sysdate,
2382: status_code = 'STAGING',
2383: status_date = sysdate

Line 2393: UPDATE ams_imp_list_headers_all

2389: -- added by ndadwal for Bug 5113207
2390: if l_status_code = 'NEW' then
2391: if l_server_flag = 'Y' then
2392: if p_staged_only = 'Y' then
2393: UPDATE ams_imp_list_headers_all
2394: set loaded_no_of_rows = l_loaded_rows,
2395: loaded_date = sysdate,
2396: status_code = 'STAGED',
2397: status_date = sysdate

Line 2408: UPDATE ams_imp_list_headers_all

2404: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2405: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2406: system_status_code = 'STAGED' and default_flag = 'Y';
2407:
2408: UPDATE ams_imp_list_headers_all
2409: set loaded_no_of_rows = l_loaded_rows,
2410: loaded_date = sysdate,
2411: status_code = l_lookup_code,
2412: user_status_id = l_user_status_id,

Line 2473: UPDATE ams_imp_list_headers_all

2469: l_user_status_id := null;
2470: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2471: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2472: system_status_code = 'ERROR' and default_flag = 'Y';
2473: UPDATE ams_imp_list_headers_all
2474: set status_code = l_lookup_code,
2475: user_status_id = l_user_status_id,
2476: status_date = sysdate
2477: where import_list_header_id = p_import_list_header_id;

Line 2545: UPDATE ams_imp_list_headers_all

2541: l_user_status_id := null;
2542: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2543: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2544: system_status_code = 'ERROR' and default_flag = 'Y';
2545: UPDATE ams_imp_list_headers_all
2546: set status_code = l_lookup_code,
2547: user_status_id = l_user_status_id,
2548: status_date = sysdate
2549: where import_list_header_id = p_import_list_header_id;

Line 2577: UPDATE ams_imp_list_headers_all

2573: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2574: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2575: system_status_code = 'STAGED' and default_flag = 'Y';
2576:
2577: UPDATE ams_imp_list_headers_all
2578: set loaded_no_of_rows = l_loaded_rows,
2579: loaded_date = sysdate,
2580: status_code = l_lookup_code,
2581: user_status_id = l_user_status_id,

Line 2629: UPDATE ams_imp_list_headers_all

2625: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2626: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2627: system_status_code = 'ERROR' and default_flag = 'Y';
2628:
2629: UPDATE ams_imp_list_headers_all
2630: set status_code = l_lookup_code,
2631: user_status_id = l_user_status_id,
2632: status_date = sysdate
2633: where import_list_header_id = p_import_list_header_id;

Line 2717: UPDATE ams_imp_list_headers_all

2713: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2714: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2715: system_status_code = 'ERROR' and default_flag = 'Y';
2716:
2717: UPDATE ams_imp_list_headers_all
2718: set status_code = l_lookup_code,
2719: user_status_id = l_user_status_id,
2720: status_date = sysdate
2721: where import_list_header_id = p_import_list_header_id;

Line 2743: UPDATE ams_imp_list_headers_all

2739: l_user_status_id := null;
2740: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2741: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2742: system_status_code = 'ERROR' and default_flag = 'Y';
2743: UPDATE ams_imp_list_headers_all
2744: set status_code = l_lookup_code,
2745: user_status_id = l_user_status_id,
2746: status_date = sysdate
2747: where import_list_header_id = p_import_list_header_id;

Line 2765: UPDATE ams_imp_list_headers_all

2761: l_user_status_id := null;
2762: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2763: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2764: system_status_code = 'ERROR' and default_flag = 'Y';
2765: UPDATE ams_imp_list_headers_all
2766: set status_code = l_lookup_code,
2767: user_status_id = l_user_status_id,
2768: status_date = sysdate
2769: where import_list_header_id = p_import_list_header_id;

Line 2787: UPDATE ams_imp_list_headers_all

2783: l_user_status_id := null;
2784: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2785: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2786: system_status_code = 'ERROR' and default_flag = 'Y';
2787: UPDATE ams_imp_list_headers_all
2788: set status_code = l_lookup_code,
2789: user_status_id = l_user_status_id,
2790: status_date = sysdate
2791: where import_list_header_id = p_import_list_header_id;

Line 2815: UPDATE ams_imp_list_headers_all

2811: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2812: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2813: system_status_code = 'ERROR' and default_flag = 'Y';
2814:
2815: UPDATE ams_imp_list_headers_all
2816: set status_code = l_lookup_code,
2817: user_status_id = l_user_status_id,
2818: status_date = sysdate
2819: where import_list_header_id = p_import_list_header_id;

Line 2838: UPDATE ams_imp_list_headers_all

2834: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2835: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2836: system_status_code = 'ERROR' and default_flag = 'Y';
2837:
2838: UPDATE ams_imp_list_headers_all
2839: set status_code = l_lookup_code,
2840: user_status_id = l_user_status_id,
2841: status_date = sysdate
2842: where import_list_header_id = p_import_list_header_id;

Line 2863: update ams_imp_list_headers_all

2859:
2860: open c_dup_recs;
2861: fetch c_dup_recs into l_duplicate_records;
2862: close c_dup_recs;
2863: update ams_imp_list_headers_all
2864: set number_of_duplicate_records = l_duplicate_records
2865: where import_list_header_id = p_import_list_header_id;
2866:
2867: AMS_Utility_PVT.Create_Log (

Line 2934: select LOADED_NO_OF_ROWS into l_load_rows from ams_imp_list_headers_all

2930: p_msg_data => 'Starting List Generation for List Import.',
2931: p_msg_type => 'DEBUG'
2932: );
2933: l_load_rows := 0;
2934: select LOADED_NO_OF_ROWS into l_load_rows from ams_imp_list_headers_all
2935: where import_list_header_id = p_import_list_header_id;
2936:
2937: if l_load_rows > 0 then
2938:

Line 3054: select import_type,VALIDATE_FILE,NUMBER_OF_INSTANCES from ams_imp_list_headers_all

3050: l_numb_of_inst number;
3051:
3052:
3053: cursor c_import_type is
3054: select import_type,VALIDATE_FILE,NUMBER_OF_INSTANCES from ams_imp_list_headers_all
3055: where import_list_header_id = p_import_list_header_id;
3056:
3057: cursor c_conc_name is
3058: SELECT concurrent_program FROM ams_imp_list_import_types

Line 3095: UPDATE ams_imp_list_headers_all

3091: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3092: system_status_code = 'SCHEDULED' and default_flag = 'Y';
3093:
3094:
3095: UPDATE ams_imp_list_headers_all
3096: set status_code = l_lookup_code,
3097: user_status_id = l_user_status_id,
3098: status_date = sysdate
3099: where import_list_header_id = p_import_list_header_id;

Line 3144: UPDATE ams_imp_list_headers_all

3140: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3141: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3142: system_status_code = 'ERROR' and default_flag = 'Y';
3143:
3144: UPDATE ams_imp_list_headers_all
3145: set status_code = l_lookup_code,
3146: user_status_id = l_user_status_id,
3147: status_date = sysdate
3148: where import_list_header_id = p_import_list_header_id;

Line 3191: UPDATE ams_imp_list_headers_all

3187: l_user_status_id := null;
3188: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3189: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3190: system_status_code = 'ERROR' and default_flag = 'Y';
3191: UPDATE ams_imp_list_headers_all
3192: set status_code = l_lookup_code,
3193: user_status_id = l_user_status_id,
3194: status_date = sysdate
3195: where import_list_header_id = p_import_list_header_id;

Line 3270: UPDATE ams_imp_list_headers_all

3266: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3267: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3268: system_status_code = 'ERROR' and default_flag = 'Y';
3269:
3270: UPDATE ams_imp_list_headers_all
3271: set status_code = l_lookup_code,
3272: user_status_id = l_user_status_id,
3273: status_date = sysdate
3274: where import_list_header_id = p_import_list_header_id;

Line 3334: UPDATE ams_imp_list_headers_all

3330: l_user_status_id := null;
3331: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3332: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3333: system_status_code = 'ERROR' and default_flag = 'Y';
3334: UPDATE ams_imp_list_headers_all
3335: set status_code = l_lookup_code,
3336: user_status_id = l_user_status_id,
3337: status_date = sysdate
3338: where import_list_header_id = p_import_list_header_id;

Line 3374: UPDATE ams_imp_list_headers_all

3370: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3371: system_status_code = 'ERROR' and default_flag = 'Y';
3372: end if;
3373:
3374: UPDATE ams_imp_list_headers_all
3375: set status_code = l_lookup_code,
3376: user_status_id = l_user_status_id,
3377: status_date = sysdate
3378: where import_list_header_id = p_import_list_header_id;

Line 3393: UPDATE ams_imp_list_headers_all

3389: close c_loaded_records;
3390: open c_failed_records;
3391: fetch c_failed_records into l_failed_records;
3392: close c_failed_records;
3393: UPDATE ams_imp_list_headers_all
3394: SET loaded_no_of_rows = l_loaded_records,
3395: number_of_failed_records = l_failed_records,
3396: loaded_date = sysdate
3397: WHERE import_list_header_id = p_import_list_header_id;

Line 3412: UPDATE ams_imp_list_headers_all

3408: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3409: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3410: system_status_code = 'ERROR' and default_flag = 'Y';
3411:
3412: UPDATE ams_imp_list_headers_all
3413: set status_code = l_lookup_code,
3414: user_status_id = l_user_status_id,
3415: status_date = sysdate
3416: where import_list_header_id = p_import_list_header_id;

Line 3467: select import_type from ams_imp_list_headers_all where import_list_header_id = p_import_list_header_id;

3463: cursor c_file_type is
3464: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;
3465:
3466: cursor c_imptype is
3467: select import_type from ams_imp_list_headers_all where import_list_header_id = p_import_list_header_id;
3468:
3469:
3470: begin
3471:

Line 3479: update ams_imp_list_headers_all

3475: p_log_used_by_id => p_import_list_header_id,
3476: p_msg_data => 'Starting List Import Process',
3477: p_msg_type => 'DEBUG'
3478: );
3479: update ams_imp_list_headers_all
3480: set GENERATE_LIST = decode(p_generate_list,'Y','Y','DUMMY','N','N'),
3481: GENERATED_LIST_NAME = p_list_name
3482: where import_list_header_id = p_import_list_header_id;
3483: commit;

Line 3502: UPDATE ams_imp_list_headers_all

3498: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3499: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3500: system_status_code = 'ERROR' and default_flag = 'Y';
3501:
3502: UPDATE ams_imp_list_headers_all
3503: set status_code = l_lookup_code,
3504: user_status_id = l_user_status_id,
3505: status_date = sysdate
3506: where import_list_header_id = p_import_list_header_id;

Line 3526: UPDATE ams_imp_list_headers_all

3522: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3523: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3524: system_status_code = 'ERROR' and default_flag = 'Y';
3525:
3526: UPDATE ams_imp_list_headers_all
3527: set status_code = 'ERROR',
3528: user_status_id = l_user_status_id,
3529: status_date = sysdate
3530: where import_list_header_id = p_import_list_header_id;

Line 3561: UPDATE ams_imp_list_headers_all

3557: l_user_status_id := null;
3558: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3559: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3560: system_status_code = 'ERROR' and default_flag = 'Y';
3561: UPDATE ams_imp_list_headers_all
3562: set status_code = l_lookup_code,
3563: user_status_id = l_user_status_id,
3564: status_date = sysdate
3565: where import_list_header_id = p_import_list_header_id;

Line 3617: select import_type from ams_imp_list_headers_all where import_list_header_id = p_import_list_header_id;

3613: cursor c_prof_file_size is
3614: select file_size, file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;
3615:
3616: cursor c_imptype is
3617: select import_type from ams_imp_list_headers_all where import_list_header_id = p_import_list_header_id;
3618:
3619: BEGIN
3620: -- x_prof_file_size := fnd_profile.value('AMS_IMP_CLIENT_FILE_SIZE');
3621: open c_prof_file_size;

Line 3627: update ams_imp_list_headers_all

3623: close c_prof_file_size;
3624: open c_imptype;
3625: fetch c_imptype into x_imp_type;
3626: close c_imptype;
3627: update ams_imp_list_headers_all
3628: set GENERATE_LIST = decode(p_generate_list,'Y','Y','DUMMY','N','N'),
3629: GENERATED_LIST_NAME = p_list_name
3630: where import_list_header_id = p_import_list_header_id;
3631: commit;

Line 3646: UPDATE ams_imp_list_headers_all

3642: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3643: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3644: system_status_code = 'ERROR' and default_flag = 'Y';
3645:
3646: UPDATE ams_imp_list_headers_all
3647: set status_code = 'ERROR',
3648: user_status_id = l_user_status_id,
3649: status_date = sysdate
3650: where import_list_header_id = p_import_list_header_id;

Line 3681: UPDATE ams_imp_list_headers_all

3677: l_user_status_id := null;
3678: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3679: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3680: system_status_code = 'ERROR' and default_flag = 'Y';
3681: UPDATE ams_imp_list_headers_all
3682: set status_code = l_lookup_code,
3683: user_status_id = l_user_status_id,
3684: status_date = sysdate
3685: where import_list_header_id = p_import_list_header_id;

Line 3736: FROM ams_imp_list_headers_all

3732:
3733: /* mayjain bug 5235979 */
3734: cursor c_rule_type is
3735: SELECT 'IMPORT_CUST_' || import_type
3736: FROM ams_imp_list_headers_all
3737: where import_list_header_id = p_import_list_header_id;
3738:
3739: cursor c_ruleid (p_rule_type VARCHAR2) is
3740: SELECT us.list_rule_id

Line 3758: ams_imp_list_headers_all

3754: WHERE list_rule_id = i_rule_id;
3755:
3756: cursor c_word is
3757: select nvl(ENABLE_WORD_REPLACEMENT_FLAG,'N'), nvl(b2b_flag,'N') from
3758: ams_imp_list_headers_all
3759: WHERE import_list_header_id = p_import_list_header_id;
3760:
3761: cursor c_imp_src is
3762: select import_source_line_id from ams_imp_source_lines

Line 3998: from ams_imp_list_headers_all

3994: WHERE load_status = 'SUCCESS' AND batch_id = l_batch_id;
3995:
3996: cursor c_event_status is
3997: select nvl(PROCESSED_ROWS,0), nvl(NUMBER_OF_FAILED_RECORDS,0)
3998: from ams_imp_list_headers_all
3999: where import_list_header_id = p_import_list_header_id;
4000:
4001: cursor c_conc_name is
4002: SELECT concurrent_program FROM ams_imp_list_import_types

Line 4006: SELECT batch_id, VALIDATE_FILE, EXECUTE_MODE FROM ams_imp_list_headers_all

4002: SELECT concurrent_program FROM ams_imp_list_import_types
4003: where import_type = 'LEAD';
4004:
4005: cursor c_lead_process is
4006: SELECT batch_id, VALIDATE_FILE, EXECUTE_MODE FROM ams_imp_list_headers_all
4007: WHERE import_list_header_id = p_import_list_header_id ;
4008:
4009: cursor c_lead_source_system is
4010: select source_system from ams_lead_mapping_v

Line 4153: UPDATE ams_imp_list_headers_all

4149: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4150: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4151: system_status_code = 'ERROR' and default_flag = 'Y';
4152:
4153: UPDATE ams_imp_list_headers_all
4154: set status_code = l_lookup_code,
4155: user_status_id = l_user_status_id,
4156: status_date = sysdate
4157: where import_list_header_id = p_import_list_header_id;

Line 4205: UPDATE ams_imp_list_headers_all

4201: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4202: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4203: system_status_code = 'ERROR' and default_flag = 'Y';
4204:
4205: UPDATE ams_imp_list_headers_all
4206: set status_code = l_lookup_code,
4207: user_status_id = l_user_status_id,
4208: status_date = sysdate
4209: where import_list_header_id = p_import_list_header_id;

Line 4234: UPDATE ams_imp_list_headers_all

4230: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4231: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4232: system_status_code = 'ERROR' and default_flag = 'Y';
4233:
4234: UPDATE ams_imp_list_headers_all
4235: set status_code = l_lookup_code,
4236: user_status_id = l_user_status_id,
4237: status_date = sysdate,
4238: number_of_failed_records = l_rec_failed_in_ams

Line 4274: UPDATE ams_imp_list_headers_all

4270: l_user_status_id := null;
4271: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4272: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4273: system_status_code = 'ERROR' and default_flag = 'Y';
4274: UPDATE ams_imp_list_headers_all
4275: set status_code = l_lookup_code,
4276: user_status_id = l_user_status_id,
4277: status_date = sysdate
4278: where import_list_header_id = p_import_list_header_id;

Line 4333: UPDATE ams_imp_list_headers_all

4329: l_user_status_id := null;
4330: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4331: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4332: system_status_code = 'ERROR' and default_flag = 'Y';
4333: UPDATE ams_imp_list_headers_all
4334: set status_code = l_lookup_code,
4335: user_status_id = l_user_status_id,
4336: status_date = sysdate
4337: where import_list_header_id = p_import_list_header_id;

Line 4384: UPDATE ams_imp_list_headers_all

4380: p_msg_data => 'Some of the leads in the batch has errors.',
4381: p_msg_type => 'DEBUG'
4382: );
4383: /*
4384: UPDATE ams_imp_list_headers_all
4385: set status_code = l_lookup_code,
4386: user_status_id = l_user_status_id,
4387: status_date = sysdate
4388: where import_list_header_id = p_import_list_header_id;

Line 4865: from ams_imp_list_headers_all hd, ams_imp_source_lines sr

4861:
4862:
4863: cursor b2borb2c is
4864: select hd.import_type, hd.rented_list_flag, hd.import_list_header_id
4865: from ams_imp_list_headers_all hd, ams_imp_source_lines sr
4866: where hd.import_list_header_id = sr.import_list_header_id
4867: and sr.party_id = p_party_id;
4868:
4869: cursor c_relationship is

Line 6769: FROM ams_imp_list_headers_all

6765:
6766: CURSOR c_lead_batch_id is
6767: SELECT
6768: batch_id
6769: FROM ams_imp_list_headers_all
6770: WHERE import_list_header_id = p_import_list_header_id;
6771:
6772: CURSOR c_lead_date_fields is
6773: SELECT

Line 7728: from ams_imp_list_headers_all

7724: and batch_id = p_batch_id;
7725:
7726: cursor c_imp_type is
7727: select import_type
7728: from ams_imp_list_headers_all
7729: where import_list_header_id = p_import_list_header_id;
7730:
7731: cursor c_b2bxmlrec is
7732: select org_imp_xml_element_id, add_imp_xml_element_id, ocont_imp_xml_element_id,

Line 8116: FROM ams_imp_list_headers_all

8112:
8113: CURSOR c_lead_batch_id is
8114: SELECT
8115: batch_id
8116: FROM ams_imp_list_headers_all
8117: WHERE import_list_header_id = p_import_list_header_id;
8118:
8119: CURSOR c_as_list_headers is
8120: SELECT

Line 8608: FROM ams_imp_list_headers_all

8604:
8605: CURSOR c_lead_batch_id is
8606: SELECT
8607: batch_id
8608: FROM ams_imp_list_headers_all
8609: WHERE import_list_header_id = p_import_list_header_id;
8610:
8611: -- Cursor for B2B party type
8612:

Line 10008: select import_type from ams_imp_list_headers_all

10004:
10005: -- Cursor to check if it's B2B or B2C party type.
10006:
10007: cursor b2borb2c is
10008: select import_type from ams_imp_list_headers_all
10009: where import_list_header_id = p_import_list_header_id;
10010:
10011:
10012: CURSOR c_b2b_date_fields is

Line 11139: FROM ams_imp_list_headers_all

11135:
11136: CURSOR c_lead_batch_id is
11137: SELECT
11138: batch_id
11139: FROM ams_imp_list_headers_all
11140: WHERE import_list_header_id = p_import_list_header_id;
11141:
11142: -- Cursor for B2B party type
11143:

Line 11979: select import_type from ams_imp_list_headers_all

11975:
11976: -- Cursor to check if it's B2B or B2C party type.
11977:
11978: cursor b2borb2c is
11979: select import_type from ams_imp_list_headers_all
11980: where import_list_header_id = p_import_list_header_id;
11981:
11982:
11983: begin

Line 13671: ,nvl(NUMBER_OF_INSTANCES,1) from ams_imp_list_headers_all

13667: L_MESG_TEXT varchar2(2000);
13668:
13669: cursor c_import_type is
13670: select import_type, dedupe_flag, nvl(VALIDATE_FILE,'N'),status_code,EXECUTE_MODE,nvl(RECORD_UPDATE_FLAG,'N')
13671: ,nvl(NUMBER_OF_INSTANCES,1) from ams_imp_list_headers_all
13672: where import_list_header_id = p_import_list_header_id;
13673:
13674: cursor c_dup_recs is
13675: select count(*) from ams_imp_source_lines

Line 13681: from ams_imp_list_headers_all

13677: and duplicate_flag = 'Y';
13678:
13679: cursor c_event_status is
13680: select nvl(PROCESSED_ROWS,0), nvl(NUMBER_OF_FAILED_RECORDS,0)
13681: from ams_imp_list_headers_all
13682: where import_list_header_id = p_import_list_header_id;
13683:
13684: cursor c_conc_name is
13685: SELECT concurrent_program FROM ams_imp_list_import_types

Line 13732: ams_imp_list_headers_all hd

13728:
13729: -- For Mapped osr
13730: cursor osr_mapped is
13731: SELECT 'Y' FROM ams_list_src_fields sf,
13732: ams_imp_list_headers_all hd
13733: WHERE sf.field_column_name = 'ORIG_SYSTEM_REFERENCE'
13734: AND sf.enabled_flag = 'Y'
13735: AND sf.list_source_type_id = hd.list_source_type_id
13736: and hd.import_type in ('B2B','B2C')

Line 13784: UPDATE ams_imp_list_headers_all

13780: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
13781: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
13782: system_status_code = 'ERROR' and default_flag = 'Y';
13783:
13784: UPDATE ams_imp_list_headers_all
13785: set status_code = l_lookup_code,
13786: user_status_id = l_user_status_id,
13787: status_date = sysdate
13788: where import_list_header_id = p_import_list_header_id;

Line 13809: UPDATE ams_imp_list_headers_all

13805: system_status_code = 'STAGED' and default_flag = 'Y';
13806:
13807: select as_import_interface_s.nextval into l_batch_id from dual;
13808:
13809: UPDATE ams_imp_list_headers_all
13810: set status_code = l_lookup_code,
13811: user_status_id = l_user_status_id,
13812: batch_id = l_batch_id,
13813: status_date = sysdate

Line 13885: UPDATE ams_imp_list_headers_all

13881: null,
13882: substr(x_mdata,1,2000));
13883: end if;
13884: end if;
13885: UPDATE ams_imp_list_headers_all
13886: set status_code = 'SCHEDULED',
13887: loaded_date = sysdate,
13888: status_date = sysdate
13889: where import_list_header_id = p_import_list_header_id;

Line 13916: update ams_imp_list_headers_all

13912:
13913: open c_dup_recs;
13914: fetch c_dup_recs into l_duplicate_records;
13915: close c_dup_recs;
13916: update ams_imp_list_headers_all
13917: set number_of_duplicate_records = l_duplicate_records
13918: where import_list_header_id = p_import_list_header_id;
13919:
13920: AMS_Utility_PVT.Create_Log (

Line 14044: UPDATE ams_imp_list_headers_all

14040: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14041: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14042: system_status_code = 'ERROR' and default_flag = 'Y';
14043:
14044: UPDATE ams_imp_list_headers_all
14045: set status_code = l_lookup_code,
14046: user_status_id = l_user_status_id,
14047: status_date = sysdate
14048: where import_list_header_id = p_import_list_header_id;

Line 14098: UPDATE ams_imp_list_headers_all

14094: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14095: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14096: system_status_code = 'ERROR' and default_flag = 'Y';
14097:
14098: UPDATE ams_imp_list_headers_all
14099: set status_code = l_lookup_code,
14100: user_status_id = l_user_status_id,
14101: status_date = sysdate
14102: where import_list_header_id = p_import_list_header_id;

Line 14134: UPDATE ams_imp_list_headers_all

14130: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14131: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14132: system_status_code = 'ERROR' and default_flag = 'Y';
14133:
14134: UPDATE ams_imp_list_headers_all
14135: set status_code = l_lookup_code,
14136: user_status_id = l_user_status_id,
14137: status_date = sysdate
14138: where import_list_header_id = p_import_list_header_id;

Line 14169: UPDATE ams_imp_list_headers_all

14165: l_user_status_id := null;
14166: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14167: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14168: system_status_code = 'ERROR' and default_flag = 'Y';
14169: UPDATE ams_imp_list_headers_all
14170: set status_code = l_lookup_code,
14171: user_status_id = l_user_status_id,
14172: status_date = sysdate
14173: where import_list_header_id = p_import_list_header_id;

Line 14226: UPDATE ams_imp_list_headers_all

14222: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14223: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14224: system_status_code = 'ERROR' and default_flag = 'Y';
14225:
14226: UPDATE ams_imp_list_headers_all
14227: set status_code = l_lookup_code,
14228: user_status_id = l_user_status_id,
14229: status_date = sysdate
14230: where import_list_header_id = p_import_list_header_id;

Line 14262: UPDATE ams_imp_list_headers_all

14258: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14259: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14260: system_status_code = 'ERROR' and default_flag = 'Y';
14261:
14262: UPDATE ams_imp_list_headers_all
14263: set status_code = l_lookup_code,
14264: user_status_id = l_user_status_id,
14265: status_date = sysdate
14266: where import_list_header_id = p_import_list_header_id;

Line 14313: UPDATE ams_imp_list_headers_all

14309: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14310: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14311: system_status_code = 'ERROR' and default_flag = 'Y';
14312:
14313: UPDATE ams_imp_list_headers_all
14314: set status_code = l_lookup_code,
14315: user_status_id = l_user_status_id,
14316: status_date = sysdate
14317: where import_list_header_id = p_import_list_header_id;

Line 14338: UPDATE ams_imp_list_headers_all

14334: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14335: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14336: system_status_code = 'ERROR' and default_flag = 'Y';
14337:
14338: UPDATE ams_imp_list_headers_all
14339: set status_code = l_lookup_code,
14340: user_status_id = l_user_status_id,
14341: status_date = sysdate
14342: where import_list_header_id = p_import_list_header_id;

Line 14411: UPDATE ams_imp_list_headers_all

14407: l_user_status_id := null;
14408: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14409: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14410: system_status_code = 'ERROR' and default_flag = 'Y';
14411: UPDATE ams_imp_list_headers_all
14412: set status_code = l_lookup_code,
14413: user_status_id = l_user_status_id,
14414: status_date = sysdate
14415: where import_list_header_id = p_import_list_header_id;

Line 14445: UPDATE ams_imp_list_headers_all

14441: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14442: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14443: system_status_code = 'ERROR' and default_flag = 'Y';
14444:
14445: UPDATE ams_imp_list_headers_all
14446: set status_code = l_lookup_code,
14447: user_status_id = l_user_status_id,
14448: status_date = sysdate
14449: where import_list_header_id = p_import_list_header_id;

Line 14464: UPDATE ams_imp_list_headers_all

14460: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14461: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14462: system_status_code = 'ERROR' and default_flag = 'Y';
14463:
14464: UPDATE ams_imp_list_headers_all
14465: set status_code = l_lookup_code,
14466: user_status_id = l_user_status_id,
14467: status_date = sysdate
14468: where import_list_header_id = p_import_list_header_id;

Line 14477: UPDATE ams_imp_list_headers_all

14473: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14474: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14475: system_status_code = 'COMPLETED' and default_flag = 'Y';
14476:
14477: UPDATE ams_imp_list_headers_all
14478: set status_code = l_lookup_code,
14479: user_status_id = l_user_status_id,
14480: status_date = sysdate
14481: where import_list_header_id = p_import_list_header_id;

Line 14495: UPDATE ams_imp_list_headers_all

14491: close c_loaded_records;
14492: open c_failed_records;
14493: fetch c_failed_records into l_failed_records;
14494: close c_failed_records;
14495: UPDATE ams_imp_list_headers_all
14496: SET loaded_no_of_rows = l_loaded_records,
14497: number_of_failed_records = l_failed_records,
14498: loaded_date = sysdate
14499: WHERE import_list_header_id = p_import_list_header_id;

Line 14513: select LOADED_NO_OF_ROWS into l_loaded_rows from ams_imp_list_headers_all

14509: p_msg_type => 'DEBUG'
14510: );
14511:
14512: l_loaded_rows := 0;
14513: select LOADED_NO_OF_ROWS into l_loaded_rows from ams_imp_list_headers_all
14514: where import_list_header_id = p_import_list_header_id;
14515:
14516: if l_loaded_rows > 0 then
14517:

Line 14557: UPDATE ams_imp_list_headers_all

14553: --
14554:
14555: if l_import_type = 'LEAD' then
14556: if l_status_code = 'STAGED' then
14557: UPDATE ams_imp_list_headers_all
14558: set status_code = 'SCHEDULED',
14559: loaded_date = sysdate,
14560: status_date = sysdate
14561: where import_list_header_id = p_import_list_header_id;

Line 14590: UPDATE ams_imp_list_headers_all

14586: --
14587:
14588: if l_import_type = 'EVENT' then
14589: if l_status_code = 'STAGED' then
14590: UPDATE ams_imp_list_headers_all
14591: set status_code = 'SCHEDULED',
14592: loaded_date = sysdate,
14593: status_date = sysdate
14594: where import_list_header_id = p_import_list_header_id;

Line 14630: UPDATE ams_imp_list_headers_all

14626: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14627: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14628: system_status_code = 'ERROR' and default_flag = 'Y';
14629:
14630: UPDATE ams_imp_list_headers_all
14631: set status_code = l_lookup_code,
14632: user_status_id = l_user_status_id,
14633: status_date = sysdate
14634: where import_list_header_id = p_import_list_header_id;

Line 14677: UPDATE ams_imp_list_headers_all

14673: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14674: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14675: system_status_code = 'ERROR' and default_flag = 'Y';
14676:
14677: UPDATE ams_imp_list_headers_all
14678: set status_code = l_lookup_code,
14679: user_status_id = l_user_status_id,
14680: status_date = sysdate
14681: where import_list_header_id = p_import_list_header_id;

Line 14690: UPDATE ams_imp_list_headers_all

14686: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14687: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14688: system_status_code = 'COMPLETED' and default_flag = 'Y';
14689:
14690: UPDATE ams_imp_list_headers_all
14691: set status_code = l_lookup_code,
14692: user_status_id = l_user_status_id,
14693: status_date = sysdate
14694: where import_list_header_id = p_import_list_header_id;

Line 14708: UPDATE ams_imp_list_headers_all

14704: open c_failed_records;
14705: fetch c_failed_records into l_failed_records;
14706: close c_failed_records;
14707:
14708: UPDATE ams_imp_list_headers_all
14709: SET loaded_no_of_rows = l_loaded_records,
14710: number_of_failed_records = l_failed_records,
14711: loaded_date = sysdate
14712: where import_list_header_id = p_import_list_header_id;

Line 15366: FROM ams_imp_list_headers_all

15362:
15363: CURSOR c_lead_batch_id is
15364: SELECT
15365: batch_id
15366: FROM ams_imp_list_headers_all
15367: WHERE import_list_header_id = p_import_list_header_id;
15368:
15369: begin
15370:

Line 15984: UPDATE ams_imp_list_headers_all

15980: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
15981: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
15982: system_status_code = l_status_code and default_flag = 'Y';
15983:
15984: UPDATE ams_imp_list_headers_all
15985: set status_code = l_status_code,
15986: user_status_id = l_user_status_id,
15987: loaded_no_of_rows = l_tot_numb_success_records,
15988: number_of_duplicate_records = l_tot_numb_dup_records,

Line 16038: select decode(import_type,'B2B','Y','N') from ams_imp_list_headers_all

16034:
16035: l_b2b_flag VARCHAR2(1);
16036:
16037: cursor c_b2b is
16038: select decode(import_type,'B2B','Y','N') from ams_imp_list_headers_all
16039: WHERE import_list_header_id = p_import_list_header_id;
16040:
16041: begin
16042:

Line 17610: cursor c_batchID is select batch_id from ams_imp_list_headers_all

17606: x_return_status OUT NOCOPY varchar2,
17607: x_msg_data OUT NOCOPY varchar2) is
17608:
17609: l_batch_id number;
17610: cursor c_batchID is select batch_id from ams_imp_list_headers_all
17611: where import_list_header_id = p_import_list_header_id;
17612:
17613: begin
17614: open c_batchID;

Line 18048: cursor c_batchID is select batch_id from ams_imp_list_headers_all

18044: x_return_status OUT NOCOPY varchar2,
18045: x_msg_data OUT NOCOPY varchar2) IS
18046:
18047: l_batch_id number;
18048: cursor c_batchID is select batch_id from ams_imp_list_headers_all
18049: where import_list_header_id = p_import_list_header_id;
18050:
18051: begin
18052: open c_batchID;

Line 20890: from ams_imp_list_headers_all

20886:
20887: cursor c_import_type is
20888: select
20889: GENERATE_LIST,GENERATED_LIST_NAME,OWNER_USER_ID,dedupe_flag
20890: from ams_imp_list_headers_all
20891: where import_list_header_id = p_import_list_header_id;
20892:
20893: cursor c_dup_recs is
20894: select count(*) from ams_imp_source_lines

Line 20957: UPDATE ams_imp_list_headers_all

20953: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
20954: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
20955: system_status_code = 'ERROR' and default_flag = 'Y';
20956:
20957: UPDATE ams_imp_list_headers_all
20958: set status_code = l_lookup_code,
20959: user_status_id = l_user_status_id,
20960: status_date = sysdate
20961: where import_list_header_id = p_import_list_header_id;

Line 20970: UPDATE ams_imp_list_headers_all

20966: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
20967: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
20968: system_status_code = 'COMPLETED' and default_flag = 'Y';
20969:
20970: UPDATE ams_imp_list_headers_all
20971: set status_code = l_lookup_code,
20972: user_status_id = l_user_status_id,
20973: status_date = sysdate
20974: where import_list_header_id = p_import_list_header_id;

Line 20991: UPDATE ams_imp_list_headers_all

20987: close c_failed_records;
20988: open c_dup_records;
20989: fetch c_dup_records into L_TOTAL_DUP_RECORDS;
20990: close c_dup_records;
20991: UPDATE ams_imp_list_headers_all
20992: SET loaded_no_of_rows = l_loaded_records,
20993: number_of_failed_records = l_failed_records,
20994: number_of_duplicate_records = L_TOTAL_DUP_RECORDS,
20995: loaded_date = sysdate

Line 21024: select LOADED_NO_OF_ROWS into l_loaded_rows from ams_imp_list_headers_all

21020: p_msg_data => 'Starting List Generation for List Import.',
21021: p_msg_type => 'DEBUG'
21022: );
21023: l_loaded_rows := 0;
21024: select LOADED_NO_OF_ROWS into l_loaded_rows from ams_imp_list_headers_all
21025: where import_list_header_id = p_import_list_header_id;
21026:
21027: if l_loaded_rows > 0 then
21028: AMS_ListGeneration_PKG.create_import_list

Line 21183: select import_type from ams_imp_list_headers_all

21179: L_IMPORT_SOURCE_LINE_ID IMPORT_SOURCE_LINE_ID_LIST;
21180: L_TRANSPOSED_PHONE_NUMBER TRANSPOSED_PH_NUMBER_LIST;
21181:
21182: cursor c_imp_type is
21183: select import_type from ams_imp_list_headers_all
21184: where import_list_header_id = p_import_list_header_id;
21185:
21186: cursor c_b2b_ph_no is
21187: select IMPORT_SOURCE_LINE_ID ,

Line 21384: select import_type,last_updated_by,vendor_id,charset from ams_imp_list_headers_all

21380: l_error_text VARCHAR2(4000);
21381: l_user_status_id NUMBER;
21382:
21383: Cursor c_header_info is
21384: select import_type,last_updated_by,vendor_id,charset from ams_imp_list_headers_all
21385: where import_list_header_id = p_import_list_header_id;
21386:
21387: Begin
21388: AMS_Utility_PVT.Create_Log (

Line 21459: UPDATE ams_imp_list_headers_all

21455: l_user_status_id := null;
21456: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
21457: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
21458: system_status_code = 'ERROR' and default_flag = 'Y';
21459: UPDATE ams_imp_list_headers_all
21460: set status_code = 'ERROR' ,
21461: user_status_id = l_user_status_id,
21462: status_date = sysdate
21463: where import_list_header_id = p_import_list_header_id;