APPS.AS_OSI_LEAD_PUB dependencies on AS_OSI_LEADS_ALL

Line 37: from as_osi_leads_all

33: p_osi_ovd_tbl out OSI_OVD_TBL_TYPE
34: ) is
35: cursor osi_cur (lead_id_in in varchar2) is
36: select *
37: from as_osi_leads_all
38: where lead_id = lead_id_in;
39: cursor ovd_cur (lead_id_in in varchar2) is
40: select *
41: from as_osi_lead_ovl_all

Line 238: from as_osi_leads_all

234: end if;
235: begin
236: select osi_lead_id
237: into l_dummy
238: from as_osi_leads_all
239: where osi_lead_id = p_osi_rec.lead_id;
240: update as_osi_leads_all
241: set
242: last_update_date = sysdate

Line 240: update as_osi_leads_all

236: select osi_lead_id
237: into l_dummy
238: from as_osi_leads_all
239: where osi_lead_id = p_osi_rec.lead_id;
240: update as_osi_leads_all
241: set
242: last_update_date = sysdate
243: ,last_updated_by = nvl(to_number(l_osi_rec.last_updated_by),1)
244: ,OSI_LEAD_ID = l_osi_rec.OSI_LEAD_ID

Line 281: insert into as_osi_leads_all(

277: ,EXTRA_DOCS = to_number(l_osi_rec.EXTRA_DOCS)
278: where osi_lead_id = l_osi_rec.osi_lead_id;
279: exception
280: when no_data_found then
281: insert into as_osi_leads_all(
282: creation_date
283: ,created_by
284: ,last_update_date
285: ,last_updated_by