115:
116: lv_wip_demand_exists_flag := 0; --initialize it to 0 every time
117:
118: IF l_smc_table.inventory_item_id.EXISTS(1) THEN
119: l_component_ship_date := MRP_CALENDAR.date_offset(
120: p_atp_table.Source_Organization_id(1),
121: 1,/* Daily Bucket */
122: p_atp_table.Requested_Ship_Date(1),
123: -(NVL(l_smc_table.atp_lead_time(1),0)));
450: END;
451:
452: END IF;
453:
454: lv_offset_ship_date := MRP_CALENDAR.date_offset(
455: p_get_oe_record.Source_Organization_id(1),
456: 1,/* Daily Bucket */
457: p_get_oe_record.Requested_Ship_Date(1),
458: -(p_get_oe_record.mfg_lead_time(i) ) );