APPS.AS_OSI_LEAD_PUB dependencies on AS_OSI_LEAD_OVL_ALL

Line 41: from as_osi_lead_ovl_all

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
42: where osi_lead_id = lead_id_in
43: order by ovm_code;
44: cursor osi2_cur (lead_id_in in varchar2) is
45: select substr(addr.address1||' '||addr.city||','||addr.state,1,50) site_name,

Line 165: from as_osi_lead_ovl_all

161: x_msg_data OUT VARCHAR2
162: ) is
163: cursor ovd_cur (lead_id_in in varchar2) is
164: select *
165: from as_osi_lead_ovl_all
166: where osi_lead_id = lead_id_in
167: order by ovm_code;
168: l_dummy number;
169: l_osi_rec OSI_REC_TYPE;

Line 376: delete from as_osi_lead_ovl_all

372: end if;
373: end if;
374: end loop;
375: if l_delete_flag then
376: delete from as_osi_lead_ovl_all
377: where osi_lead_id = ovd.osi_lead_id
378: and ovm_code = ovd.ovm_code;
379: end if;
380: end loop;

Line 384: insert into as_osi_lead_ovl_all(

380: end loop;
381: for i in 1..l_osi_ovd_tbl.count loop
382: if l_osi_ovd_tbl(i).ovd_flag = 'Y' and l_osi_ovd_tbl(i).ovd_code is not null then
383: begin
384: insert into as_osi_lead_ovl_all(
385: creation_date
386: ,created_by
387: ,last_update_date
388: ,last_updated_by