1123: l_sources.instance_id(1) := p_instance_id;
1124:
1125: --load data in temp table if line > 1
1126: IF l_atp_table.inventory_item_id.count > 1 THEN
1127: DELETE MSC_SHIP_SET_TEMP;
1128: FORALL l_count in 1..p_atp_table.inventory_item_id.count
1129: INSERT INTO MSC_SHIP_SET_TEMP(inventory_item_id,
1130: line_id)
1131: VALUES
1125: --load data in temp table if line > 1
1126: IF l_atp_table.inventory_item_id.count > 1 THEN
1127: DELETE MSC_SHIP_SET_TEMP;
1128: FORALL l_count in 1..p_atp_table.inventory_item_id.count
1129: INSERT INTO MSC_SHIP_SET_TEMP(inventory_item_id,
1130: line_id)
1131: VALUES
1132: (p_atp_table.inventory_item_id(l_count),
1133: p_atp_table.identifier(l_count));
1131: VALUES
1132: (p_atp_table.inventory_item_id(l_count),
1133: p_atp_table.identifier(l_count));
1134: IF PG_DEBUG in ('Y', 'C') THEN
1135: msc_sch_wb.atp_debug('Rows inserted in MSC_SHIP_SET_TEMP := ' || SQL%ROWCOUNT);
1136: END IF;
1137: END IF;
1138:
1139: