DBA Data[Home] [Help]

APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on MSC_SUP_DEM_ENTRIES

Line 894: insert into msc_sup_dem_entries (

890: BEGIN
891:
892: FORALL j in t_pub.FIRST..t_pub.LAST
893:
894: insert into msc_sup_dem_entries (
895: transaction_id,
896: plan_id,
897: sr_instance_id,
898: publisher_name,

Line 952: msc_sup_dem_entries_s.nextval,

948: last_updated_by,
949: last_update_date,
950: last_update_login
951: ) values (
952: msc_sup_dem_entries_s.nextval,
953: -1,
954: -1,
955: t_pub(j),
956: t_pub_id(j),

Line 1097: delete from msc_sup_dem_entries sd

1093:
1094: -- dbms_output.put_line('l_supplier_site_id := ' || l_supplier_site_id);
1095:
1096:
1097: delete from msc_sup_dem_entries sd
1098: where sd.publisher_order_type = 1 and
1099: sd.plan_id = -1 and
1100: sd.publisher_id = 1 and
1101: sd.publisher_site_id = nvl(l_supplier_site_id, sd.publisher_site_id) and