[Home] [Help]
2344: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2345: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2346: system_status_code = 'STAGED' and default_flag = 'Y';
2347:
2348: select as_import_interface_s.nextval into l_batch_id from dual;
2349:
2350: UPDATE ams_imp_list_headers_all
2351: set status_code = l_lookup_code,
2352: user_status_id = l_user_status_id,
3197: end if;
3198:
3199: if l_import_type = 'LEAD' then
3200: /*
3201: SELECT batch_id into l_batch_id FROM as_import_interface
3202: WHERE IMP_LIST_HEADER_NUMBER = p_import_list_header_id AND ROWNUM < 2;
3203: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3204: application => 'AS', -- 'AST',
3205: program => l_conc_prog_name, -- ' ASXSLIMP' 'AST_LEAD_IMPORT',
3907:
3908: cursor c_error is
3909: SELECT error.error_text
3910: FROM as_lead_import_errors error,
3911: as_import_interface inter
3912: WHERE error.batch_id = inter.batch_id
3913: AND inter.IMP_LIST_HEADER_NUMBER = p_import_list_header_id;
3914:
3915: BEGIN
3984: l_rec_dup_in_as NUMBER;
3985: L_MESG_TEXT varchar2(2000);
3986:
3987: cursor c_lead_status is
3988: SELECT distinct load_status FROM as_import_interface
3989: WHERE load_status = 'ERROR' AND batch_id = l_batch_id;
3990:
3991: cursor c_lead_status_sucess is
3992: SELECT distinct load_status FROM as_import_interface
3988: SELECT distinct load_status FROM as_import_interface
3989: WHERE load_status = 'ERROR' AND batch_id = l_batch_id;
3990:
3991: cursor c_lead_status_sucess is
3992: SELECT distinct load_status FROM as_import_interface
3993: WHERE load_status = 'SUCCESS' AND batch_id = l_batch_id;
3994:
3995: cursor c_event_status is
3996: select nvl(PROCESSED_ROWS,0), nvl(NUMBER_OF_FAILED_RECORDS,0)
4049: and errors.error_type = 'E';
4050: */
4051:
4052: cursor c_rec_uploaded_in_as is
4053: select count(*) from as_import_interface
4054: where batch_id = l_batch_id;
4055:
4056: cursor c_rec_pro_succ_in_as is
4057: select count(*) from as_import_interface
4053: select count(*) from as_import_interface
4054: where batch_id = l_batch_id;
4055:
4056: cursor c_rec_pro_succ_in_as is
4057: select count(*) from as_import_interface
4058: where batch_id = l_batch_id
4059: and load_status = 'SUCCESS';
4060:
4061: cursor c_rec_pro_fail_in_as is
4058: where batch_id = l_batch_id
4059: and load_status = 'SUCCESS';
4060:
4061: cursor c_rec_pro_fail_in_as is
4062: select count(*) from as_import_interface
4063: where batch_id = l_batch_id
4064: and load_status in ('ERROR','T-ERROR','UNEXP_ERROR');
4065:
4066:
4074: where import_list_header_id = p_import_list_header_id
4075: and load_status = G_STATUS_ERROR;
4076:
4077: cursor c_rec_pro_dup_in_as is
4078: select count(*) from as_import_interface
4079: where batch_id = l_batch_id
4080: and load_status = 'DUPLICATE';
4081:
4082:
4098: fetch c_rec_in_ams into l_rec_in_ams;
4099: close c_rec_in_ams;
4100:
4101: /*
4102: SELECT batch_id into l_batch_id FROM as_import_interface
4103: WHERE IMP_LIST_HEADER_NUMBER = p_import_list_header_id AND ROWNUM < 2;
4104: as_import_sl_pvt.main(l_msg_buf,
4105: l_msg_code,
4106: 'NEW', -- 'MARKETING',
13802: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
13803: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
13804: system_status_code = 'STAGED' and default_flag = 'Y';
13805:
13806: select as_import_interface_s.nextval into l_batch_id from dual;
13807:
13808: UPDATE ams_imp_list_headers_all
13809: set status_code = l_lookup_code,
13810: user_status_id = l_user_status_id,