954: set last_update_login = null
955: where plan_id = -1
956: and last_update_login = -999;
957:
958: update msc_supplies
959: set last_update_login = null
960: where plan_id = -1
961: and order_type = 5
962: and last_update_login = -999;
1906: BEGIN
1907:
1908: LOG_MESSAGE('Clean up the supplies first');
1909: begin
1910: DELETE msc_supplies
1911: WHERE plan_id = -1
1912: AND sr_instance_id = p_sr_instance_id
1913: AND organization_id = p_organization_id
1914: AND schedule_designator_id = p_mps_designator_id
1920: null;
1921: end;
1922:
1923:
1924: LOG_MESSAGE('insert msc supplies');
1925: select msc_supplies_s.nextval
1926: into l_nextid
1927: from dual;
1928:
1921: end;
1922:
1923:
1924: LOG_MESSAGE('insert msc supplies');
1925: select msc_supplies_s.nextval
1926: into l_nextid
1927: from dual;
1928:
1929: insert into msc_supplies (plan_id,
1925: select msc_supplies_s.nextval
1926: into l_nextid
1927: from dual;
1928:
1929: insert into msc_supplies (plan_id,
1930: transaction_id,
1931: organization_id,
1932: sr_instance_id,
1933: inventory_item_id,