[Home] [Help]
2345: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2346: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
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,
3198: end if;
3199:
3200: if l_import_type = 'LEAD' then
3201: /*
3202: SELECT batch_id into l_batch_id FROM as_import_interface
3203: WHERE IMP_LIST_HEADER_NUMBER = p_import_list_header_id AND ROWNUM < 2;
3204: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3205: application => 'AS', -- 'AST',
3206: program => l_conc_prog_name, -- ' ASXSLIMP' 'AST_LEAD_IMPORT',
3908:
3909: cursor c_error is
3910: SELECT error.error_text
3911: FROM as_lead_import_errors error,
3912: as_import_interface inter
3913: WHERE error.batch_id = inter.batch_id
3914: AND inter.IMP_LIST_HEADER_NUMBER = p_import_list_header_id;
3915:
3916: BEGIN
3985: l_rec_dup_in_as NUMBER;
3986: L_MESG_TEXT varchar2(2000);
3987:
3988: cursor c_lead_status is
3989: SELECT distinct load_status FROM as_import_interface
3990: WHERE load_status = 'ERROR' AND batch_id = l_batch_id;
3991:
3992: cursor c_lead_status_sucess is
3993: SELECT distinct load_status FROM as_import_interface
3989: SELECT distinct load_status FROM as_import_interface
3990: WHERE load_status = 'ERROR' AND batch_id = l_batch_id;
3991:
3992: cursor c_lead_status_sucess is
3993: SELECT distinct load_status FROM as_import_interface
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)
4050: and errors.error_type = 'E';
4051: */
4052:
4053: cursor c_rec_uploaded_in_as is
4054: select count(*) from as_import_interface
4055: where batch_id = l_batch_id;
4056:
4057: cursor c_rec_pro_succ_in_as is
4058: select count(*) from as_import_interface
4054: select count(*) from as_import_interface
4055: where batch_id = l_batch_id;
4056:
4057: cursor c_rec_pro_succ_in_as is
4058: select count(*) from as_import_interface
4059: where batch_id = l_batch_id
4060: and load_status = 'SUCCESS';
4061:
4062: cursor c_rec_pro_fail_in_as is
4059: where batch_id = l_batch_id
4060: and load_status = 'SUCCESS';
4061:
4062: cursor c_rec_pro_fail_in_as is
4063: select count(*) from as_import_interface
4064: where batch_id = l_batch_id
4065: and load_status in ('ERROR','T-ERROR','UNEXP_ERROR');
4066:
4067:
4075: where import_list_header_id = p_import_list_header_id
4076: and load_status = G_STATUS_ERROR;
4077:
4078: cursor c_rec_pro_dup_in_as is
4079: select count(*) from as_import_interface
4080: where batch_id = l_batch_id
4081: and load_status = 'DUPLICATE';
4082:
4083:
4099: fetch c_rec_in_ams into l_rec_in_ams;
4100: close c_rec_in_ams;
4101:
4102: /*
4103: SELECT batch_id into l_batch_id FROM as_import_interface
4104: WHERE IMP_LIST_HEADER_NUMBER = p_import_list_header_id AND ROWNUM < 2;
4105: as_import_sl_pvt.main(l_msg_buf,
4106: l_msg_code,
4107: 'NEW', -- 'MARKETING',
13803: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
13804: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
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,